Home

Islamic Accounts User Manual

1. Instrument Details Cheque Number Stationary Number Beneficiary Name Branch Instrument Type Status Expiry Date Issuing Bank Beneficiary Address odg Other Details Other Details Type 1 Type 2 Type 3 Type 4 Type 5 Type 6 Details 1 Details 2 Details 3 Details 4 Details 5 gonoddd goodid Details 6 In this screen you can select the Close Mode which is to be used to close the account The option list positioned next to this field contains a list of all the Close Modes maintained in the Customer Account Closing Modes screen The product linked to the close mode will be defaulted Some of the close out modes may require additional details to complete the transaction These additional details can pertain to either of the following e The Offset Account e The Instrument when the Close Out is through an Instrument with which you payoff the balance in the account Thus based on the mode selected the withdrawal entries are booked against the appropriate product The balance of the account will drop down to zero Subsequently the account is marked as closed For detailed information on the Customer Account Closing Mode Maintenance screen you can refer the Maintaining Customer Account Closing Modes sub headin
2. Class Code Class Description Event Details 10f1 Een coe vesem O o Accounting Entries Advices Specify the following details Event A contract goes through different stages in its life cycle In Oracle FLEXCUBE the different stages a contract passes through in its life cycle are referred to as events Example Some of the stages in the lifecycle of a security are Deal Booking Money Settlement of Securities Deal Settlement of Securities Deal Reversal of Securities Deal Cancellation of Securities Deal Each stage is referred to as an Event in Oracle FLEXCUBE 3 8 ORACLE You can define the accounting entries and advices for events using either of the following methods e Associating a product with an Events Class This is possible only if you have maintained Events classes specifically for the module e By defining event details specifically for the product Click Default From Class button in this screen to associate the product you are maintaining with an Events class A list of the Events classes that you have defined specifically for the module will be displayed Choose a class with the requisite events and accounting details maintained The product acquires the accounting entries and advices defined for the Events class you choose Maintaining Branch details Branch details are maintained through the Branch Currency Restrictions screen Click the
3. You will have to maintain a set of parameters for the billing module While settling or liquidating the bill the default parameters that you have maintained for the account involved in this module will be used The screen also displays the Product Code and Description of all Billing Products applicable to the account Consolidating Account You can specify a consolidating account for the given account From the option list you can choose e A different account number if you want to consolidate the charge under this account to a different account The Consolidation account selected for this account should be in the same currency as this account It also has to belong to the same branch as the specified account e The same account to indicate that there is no consolidation and an individual billing invoice is to be raised on this account 2 105 ORACLE Billing Liquidation You have two modes of liquidation i e Auto or Manual The preference you have maintained for the billing product will be defaulted here You can choose to change the mode for the specified account under the following scenarios e f Auto is chosen then you have to specify whether the settlement is through a settlement account or through Direct Debit Instruction e Incase you want to raise Direct Debit instruction for the billing invoice amount irrespective of whether the liquidation mode is Auto or Manual you have to maintain the details for Direct Debit de
4. Account Class SD User Reference Main Nominee Deposit Dual Currency Deposit Check List Description Escrow Transfer Details Fund Id Account Type Single Escrow Transfer Applicable Linked Deposit Branch Joint Branch Code Linked Deposit Account Country Code Es count Zakat Exemption Mode of Operation Escrow Percentage Option it Open Date ate C Alternate Account Number Signature Clearing Bank Code Address Location Media Profit Charges Linked Entities Restrictions mis Statement Joint Holders Fields Account Signatory TD Payout Details Change Log Maker Date Time Mod No Checker Date Time Record Status Authorization Status Specify the following details Branch Code The system displays the branch code of the sign on branch Term Deposit Account Number The system creates a unique reference number to identify the TD account number and displays it here on saving the record Term Deposit Currency Specify the currency of the TD A list of all the currencies maintained in the system is displayed in the available option list You can select the appropriate one SD User Reference The system displays the SD user reference for the TD accounts 4 9 ORACLE Customer No If you have included the CIF Number of the customer as part of the Account Mask the system automatically defaults the CIF code of the customer in the respective field You will not b
5. gt Email ID from customer personal maintenance gt Mobile number from CIF personal information 2 128 ORACLE 3 Creating an Islamic Profit Distribution Product 3 1 Introduction In this chapter we shall discuss the manner in which you can define attributes specific to an Islamic Profit or Charges product You can create an Islamic profit or charges product in the Islamic Profit Distribution Product Maintenance screen invoked from the Application Browser You can invoke the Islamic Profit Distribution Product Maintenance screen by typing IADPRMNT in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button In this screen you can enter basic information relating to a profit or charges product such as the Product Code the Description and so on Profit amp Charges Product Maintenance Product Code Product Description Product Type Description Slogan Charge Basis Product Group Description Product Group Description Start Date End Date Remarks Booking Account Type Rule Rule Description Maker Checker Date Time Date Time Include For TDS Calc Deposit Tax Billing Liquidation Mod No Record Status Authorization Status For any product you create in Oracle FLEXCUBE you can define generic attributes such as branch currency and customer restrictions accounting roles and heads and so on by clicking on the app
6. 10f1 ra Accounting Role Role Description Account Head GL Description EEE Enter the following details Product Code and Description In this field briefly describe the product that you are maintaining The description that you enter here will help you identify the product all through the module Adopting either of the following procedures you can specify the accounting roles and heads for a product e Associating the product with an Accounting Role to Head Mapping Class This is possible only if you have maintained classes of Accounting Roles and Heads specifically for the module e Mapping accounting roles and heads specifically for the product 3 1 1 1 Indicating Class Details Enter the following details 3 6 ORACLE Class Code and Description You can opt to associate an Accounting Role to Head Mapping Definition Class that you have maintained with the portfolio product that you are creating By opting to associate a class with a product you save the effort of defining the accounting roles and heads for a product all over again The roles and heads defined for the class will automatically default to the portfolio product You can change these defaults to suit the product you are defining Click Default From Class button in the Product Accounting Role to Head Mapping Definition screen to associate the product you are maintaining with a class of mapped roles and heads A list of the classes that you h
7. Maker Date Time Mod No Checker Date Time Record Status Authorization Status Bank Local Ccy The system displays the local currency of the bank Financial Cycle The system displays the previous month s financial cycle 3 4 1 1 Period Code From You can specify the period code from which the profit needs to be shared The option list displays all period codes maintained in the system You can select the appropriate one To You can specify the period code until which the profit needs to be shared The option list displays all period codes maintained in the system You can select the appropriate one Period Type Specify the type of period for which the profit sharing needs to be done You can choose any of the following options available in the drop down list 3 34 ORACLE e Notional e Actual Mudarabah Fund ID You can specify the fund id for which the profit calculation needs to be done The option list displays all fund IDs for which the profit has to run for the period codes However if the profit distribution is done already then the system will not display those fund IDs Profit Calc Sequence Number When you click save icon the system defaults the Profit Calc Sequence Number in this field Profit Equalization Amount You can indicate the following preferences Credit Debit Indicate whether the PEA amount should be deducted from or added to the depositor s profit Select one of the following options
8. Maturity Date The system defaults the maturity date from the default tenor from the account class However you can modify this date On this date the term deposit account gets Auto Rollover Check this field to automatically rollover the deposit you are maintaining You have to indicate Rollover Type on selecting this option Close on Maturity Check this field to close the term deposit account on maturity date and transfer the amount to the principal liquidation account If you select this option the principal liquidation account should be an account other than the term deposit account Move Profit to Unclaimed Check this field to move the profit amount to the unclaimed GL mapped at the IC product in the accounting roles on maturity date of the term deposit account If you select this option the principal liquidation account should be the term deposit account Move Principal to Unclaimed Check this field to move the principal amount to the unclaimed GL mapped at the IC product in the accounting roles and liquidate the profit amount to the profit booking account on maturity date of the term deposit account is moved and is liquidated If you select this option the principal liquidation account should be the term deposit account Term Deposit Amount Specify the amount which is paid for the time deposit account in the account currency If you have specified the percentage in the Pay In options on clicking the Compute
9. Media combination Location codes maintained through the Account Address Location Type Maintenance screen are made available against this field The address maintained here is always the primary or the default address Each customer can have several addresses for a particular media To distinguish between one address of a customer from another for a given media it is essential for you to specify a unique location for each address Also if you are amending an address here the same gets updated in the Customer Account Address Detailed table after the validations are through Media Select the media to communicate account related details to the customer such as account maintenance related charges fees profit etc from the option list You can choose either of the following e Mail e Telex e SWIFT e Fax Linked Deposit Branch Specify the linked deposit branch Linked Deposit Account Specify the linked deposit account Zakat Exemption When an account is opened in a branch you need to clarify with the customer whether he or she will pay Zakat or will seek exemption Check this box to indicate that the customer seeks exemption from Zakat charge 4 12 ORACLE Escrow Transfer Details You can specify the following details Escrow Transfer Applicable This box is checked by default when an account is created Uncheck this box if Escrow transfer is not applicable Branch Code Select the branch code in wh
10. Specify the date from which the joint holding of the account begins End Date Specify the date on which the joint holding of the account ends 2 3 22 Specifying UDF Details User defined fields are maintained through the User Defined Fields screen Click the Fields button in the Islamic Customer Accounts Detailed screen to invoke this screen 2 102 ORACLE User Defined Fields UDF Details 10f1 r 2 3 23 Specifying Deposits Instruction Details Deposits instructions are maintained through the Deposits Instructions screen Click the Deposits Instructions button in the Islamic Customer Accounts Detailed screen to invoke this screen Deposits Instruction Branch Code Account Account Class Customer Currency Sweep Branch Deposit Currency Sweep To Account Sweep Amount Sequence Number Tenor Sweep Multiple Of Minimum Required Balance Source Code External Reference Retry Till Date Start Date Here you can capture the following details e Branch Code The branch code of the branch which is to be associated with the account e Account Specify the account number of the customer Select the account number from the adjoining option list e Account Class This is the account class to which the account is linked e Customer The customer for whom you are maintaining the deposit instructions 2 103 ORACLE Currency Currency of the particular account Swee
11. 180 9 0 Validation digit 0 Since the check digit 0 is equal to the Mod 9 remainder 0 this check will be passed Validation digit 9 9 Mod 9 remainder 9 0 9 2 57 ORACLE Since the check digit 0 is not equal to the 9 Mod 9 remainder 9 this check will be rejected Check no 1872 Check digit 2 Mod 9 remainder 187 9 7 Validation digit 0 Since the check digit 2 is not equal to the Mod 9 remainder 7 this check will be rejected Validation digit 9 9 Mod 9 remainder 9 7 2 Since the check digit 2 is equal to the 9 Mod 9 remainder 2 this check will be passed Account Facilities Specify the following Cheque Book Enabling this check box indicates whether or not the accounts linked to the class are issued checkbooks Passbook Enabling this check box indicates whether or not the accounts linked to the account class are issued passbooks CAS Account Specify CAS account Offset Branch Choose the branch ID for the offset account specified in the next field from the option list Offset Account You have to specify the customer account from which the money is to be debited for booking the TD If you click on option list in the Offset Account field a list of all valid account numbers that is maintained in the branch specified in the previous field will be displayed Double click on the account that you want to specify as the offset account Waive Account Opening
12. Account Class screen however you can modify it You can choose the appropriate values applicable e Previous MT942 This indicates that all transactions posted and authorized since previous MT942 would be sent in the current interim statement 2 109 ORACLE e Previous MT940 This indicates that all transactions posted and authorized since previous MT940 will be sent in the current interim statement If this option is selected you will have to specify the cycle of account statement to be considered Minimum Debit Amount Specify the minimum transaction amount for the debit transaction to be eligible for reporting in the interim statement The corresponding amount for the account currency will be defaulted However you can modify the amount defaulted If the amounts are not defined at the account class for the currency in which the account is being created no defaulting of amounts shall be done Minimum Credit Amount Specify the minimum transaction amount for the credit transaction to be eligible for reporting in the interim statement However you can modify the amount defaulted If the amounts are not defined at the account class for the currency in which the account is being created no defaulting of amounts shall be done Daily Statement Count Specify the count of interim statement generated during the day In case a statement is scheduled to generate but is not generated because there is no movement the counter will not b
13. IRR 10 Since the Contribute to PDM box for account AC00001 and AC00002 is checked and Exclude from distribution box is unchecked the account balance will be considered as depositor s investment and profit will be distributed AC00001 Investment Account average balance 1 Cash reserve ratio 100 3 46 ORACLE 25000 1 20 100 20000 AC00002 Investment Account average balance 1 Cash reserve ratio 100 25000 1 20 100 20000 In this example the cash reserve ratio is maintained as 20 which is equivalent to 10000 AED So the depositor s investment will be computed as shown below Depositor s investment Account average balance Cash reserve amount 50000 10000 40000 Since the Contribute to PDM box for account ACO0003 is unchecked and Exclude from distribution box is checked the account balance will not be considered as depositor s investment and profit will not be distributed Shareholders investment Average balance of GLO0001 35000 Shareholders weight Shareholders Investment 100 Shareholders investment depositor s investment PEA GL 35000 100 35000 40000 15000 38 89 Depositors weight Depositors Investment PEA GL 100 Shareholders investment Depositor s investment PEA GL 40000 15000 100 35000 40000 15000 61 11 Let us assume that the total profit for
14. Open Minimum Maximum Discount Discount Percentage Discount Amount Account Details You can maintain the account details for an account here Branch Code The current branch code is defaulted here Account The system generates the account number maintained in the Main screen of Account Class Transfer Product Details You can specify product details for your account here Product Code Select a valid product code from the adjoining option list Currency The system generates the user defined currency type defined for the selected consolidated charges product 2 71 ORACLE 2 3 8 Minimum Specify the minimum consolidated charges that can be applied for the account Maximum Specify the maximum consolidated charges that can be applied for the account Open Check this box if you need to apply the selected consolidated charges product for the account Waive Charges Check this box if you need to waive the consolidated charges defined for the selected consolidated charges product Discount You can specify discount details for the consolidated charges applied for the account Discount Percentage Specify percentage of the amount to be discounted from the computed consolidated charges Discount Amount Specify a flat amount to be discounted from the computed consolidated charges Specifying BIC Details You can capture details of all SWIFT BICs are maintained through the Authorised SWIFT BIC
15. Transaction Code You have to specify the transaction code for the auto creation of the deposit Currency Mention the currency in which the deposit is created Minimum Required Balance The minimum balance indicates that only the amounts above this limit will be used for auto creating deposits You have to specify the minimum amount that the customer can retain in the account Cluster ID The system displays the cluster id linked with the deposit account class linked to the savings account class Break Deposits First Check the box to indicate whether you want the funds to be moved by breaking deposits before breaking the deposit accounts If you leave the box unchecked the funds will be moved first from the linked CASA accounts Def Rate Code Select the code of the differential rate from the adjoining option list Def Rate Type Select the type of differential rate code whether Mid or Buy or Sell Sweep Mode You can indicate the pattern in which sweep outs are created by selecting any on of the two options e Auto Here the amounts are automatically swept out at the end of day when minimum balance exceeds e Manual You have to manually initiate the sweep The sweep will execute only those instructions that are specified while account opening ad hoc 2 30 ORACLE Break Method You can choose to maintain the any of the following order of breaking deposits e LIFO Last In First Out Ind
16. accrual occurs you would post the entry to the GL SL that you identified Events Definition screen 3 15 ORACLE Now the frequency with which you accrue profit for the account classes has to be defined In the Product Preferences screen you can specify the accrual frequency The frequency with which you accrue profit can be e daily e monthly e quarterly e semi annual e annual e on liquidation accrues only when you liquidate profit Periodic accruals for all formulae for which profit has to be accrued will be done during the end of day processing for each account linked to the product Entries will be passed to the accrual accounts that you have specified while creating the product If you have specified that accrual entries have to be passed for a product rather than for individual accounts a consolidated entry will be passed for the formula for all the accounts linked to the product If not an entry will be passed for each account individually Accruals will also be performed whenever there is profit liquidation For an account on which a liquidation is done out of turn an ad hoc liquidation when a periodic liquidation is not due accrual entries will be passed till the date of liquidation The next accruals for the account will be done from the next day onwards Indicating the accrual cycle If the frequency with which you choose to accrue profit is e quarterly e semi annual e annual You should specify the
17. e Credit Choose this to add the PEA amount to the depositor s profit e Debit Choose this to deduct the PEA amount from the depositor s profit Ley Specify the PEA amount in local currency that should be deducted from the depositor s profit before deduction of the Mudarib fee If you have chosen Credit as the PEA criterion then indicate the amount that should be added to the depositor s profit Mudarib fee will not be deducted in this case Alternatively if you have specified the PEA for depositor s investment the system will compute the PEA amount in local currency and display it here PEA for DEP Investment Specify the amount that should be considered for PEA deduction addition as a percentage of the depositor s profit The PEA amount in local currency will be computed based on this figure Alternatively if you have specified the PEA local currency amount the system will display the same as a percentage of the depositor s profit You can view details of the batch by clicking the View Profit Calc Log button The batch needs to be authorised in order to be submitted While executing this batch the system computes the balance of each account based on the profit calculation balance basis maintained for the linked account class The system computes the cash reserve amount for each account based on the cash reserve ratio CRR maintained for the currency in the linked account class If the CRR value is no
18. s When you select this option the GL s maintained for the account class will be applicable to the customer account you are defining in this screen The reporting lines will be propagated to the account whenever a status change occurs If you do not want the account class details to be propagated to the account as well you have the option of maintaining the status codes and the reporting lines exclusively for an account You can achieve this through the Status Details screen Click the Account Status button in the Islamic Customer Accounts Detailed screen to invoke it Account Auto Closed The system checks this option to identify the accounts that should be closed by auto account closure By default the system will not check this option Account Derived Status The system displays the current status of the account here This is applicable for CASA accounts current accounts and savings accounts 2 52 ORACLE Dormancy Parameters If Transaction Code associated with the account has the consider for account activity option enabled the dormant status of the account will be updated to active Apart from this you can specify the parameter that is required for re activating the account Choose from the following options to indicate the re activation parameters for the dormant account e Debit e Credit e Any e Manual In case of a transaction the system will check for the parameter you have specified here and ac
19. 000 Customer No al Account Customer Name Currency m e Account Class x IP SD User Reference Main Auxiliary Nominee Positive Pay Provisioning Details Cheque Book Preferences Positive Pay Auto Provisioning Required Auto Reorder of Cheque Funding Exposure Category Boek Reorder Cheque Level Mod 9 Validation Required Risk Free Exposure Amount Reorder Number Of Leaves Stale Days Provisioning Currency Account Cheque Book Name 1 Fund Branch loos Ch Book Name 2 eque Book Name Deferred Reconciliation ae Max No of Cheque Rejection Funding Account Options s Validation Digit Eur Cheques Initial Funding Account Facilities Nets Reon Account Opening Amount Cheque Book Lodgment Book Pay In Option Pay In By Account Passbook Consolidated Cert Reqd Pay In By GL CAS Account Peer ceed Eyes Escrow Transfer Details Escrow Tranfer Applicable Offset Branch Aim pstue E oai mej ATM Branch Code Branch Escrow Account Waive account Opening Account Number Escrow Percentage Charges Daily Amount Limit r Profit Charges Consolidated Charges BIC Deposits Instructions Standing Instructions Linked Entities REG Account Status Restrictions Currency Limits mas Statement Limits Joint Holders Fields Deposits Instruction Billing Parameters Account Signatory Interim Transactions Report Wotice Cards OFAC Check Change Log Maker e Cancel Checker Date Time Date Time Mod No Record St
20. Exclude Same Day Reversal Transactions from Statement basas Account Number The system displays the account number for which you are setting the statement details Primary A c Statement This refers to the type of statement to be generated periodically by the system for this account You can specify whether you want a detailed or summary statement or if you do not want a statement for this account at all Cycle You can specify the frequency for generating the account statements To specify the frequency of the statements click on the adjoining drop down list The following list is displayed e Annual ORACLE 2 91 e Semi annual e Quarterly e Monthly e Fortnightly e Weekly e Daily On For a weekly statement you specify the day of the week on which account statements should be generated and for fortnightly and monthly statements the dates of the month To specify for weekly statements click on the adjoining drop down list The following list of days will be displayed e Monday e Tuesday e Wednesday e Thursday e Friday e Saturday e Sunday To specify for monthly statements enter a number between 1 and 31 corresponding to the system date If you set the statement date to 30 then account statements will be generated on e The last working day for months with lt 30 days e For months with 30 days on the 30th if 30th is a holiday on the next working day If you set the statement date to 31 then a
21. Exclude Same Day Reversal transaction from Statement If you do not wish transactions booked and reversed on the same day to be reflected in the account statement you can specify the preference here This feature is applicable only for the customer account legs and not for the related GL legs Also reversals made through the DE module will not be considered for exclusion Your specification for this at the account class level defaults to all accounts involving the class You can change it for a specific account For comparing transactions the system will look for similarity of reference number and date Back Period Entry Allowed lf checked indicates that back valued entries can be posted to account belonging to the class as long as the account is open You will be allowed to change this specification for a specific account While posting back valued transactions the system verifies whether the Back Period Entry Allowed option has been enabled for the account class If the option has not been enabled an error message is displayed This check is also performed while uploading journal entry transactions Profit Statement Check this box to generate the profit statement Available Balance Check Required Check this box to indicate available balance is required or not Referral Required Enabling this option indicates whether a referral check should be performed on accounts belonging to the account class Consequently the system checks
22. account level for any of the accounts linked to the class Account level parameters will supersede those defined for the account class While defining the Islamic account classes you should also keep in mind that the profit rate structure is also specified for an account class in the Profit and Charges module The account class table is maintained at the Bank Level by the Head Office branch You can invoke the Islamic Account Class Maintenance screen by typing IADACCLS in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button 2 1 ORACLE Account Class Maintenance Account Class Start Date Description End Date Account Type Account Details Statement Parameters Account Code Escrow Transfer Applicable Provisioning Details Dormancy Days Transaction Code Required Account Statement Transaction Code For Format Provisioning Frequency Reversal Display IBAN in Advices Provision Currency Local Cash Deposit Limit on Inter Pay Account Trust Account Exposure Category Event Class Code Natural GL Debit Credit Dormancy Parameters Debit Interest Charge Liquidation Applicable Customer Liquidate Using Receivable Status Verify Funds Charges Debit Notice Charge Start Advice Liquidation Days Advice Days Liquidation Mode Free Period eestictons Branc Currency Resticton cuntomericatgones Ws Preerences REG Deposit auo epost GL nes sta
23. balance report Message generation time Specify the timing for generation of the MT 941 MT942 message You can specify the time interval in hours only The details for issuing the balance reports are discussed in the chapter Maintaining Mandatory information for different accounts under a particular class The details involved in generation of a balance report for a specific customer account correspond with those discussed for account classes 2 3 27 Specifying Notice Details Notice preferences are maintained through the Notice Preferences screen Click the Notice Preferences button in the Islamic Customer Accounts Detailed screen to invoke this screen Notice Preference Description Advance Profit Monthly Free Amount Notice Days Validity Period The following field is displayed in this screen 2 111 ORACLE Description The following details are defaulted from the account class maintenance level However at the account level you are allowed to modify this Advance Profit Check this field to levy the advance profit on the account Note the following e The customer is liable to pay this advance profit in case he she fails to provide the required notice to the bank e The system deducts the advance profit from the credit profit earned by the customer on his her credit balance in the account Monthly Free Amount Specify the amount that the customer can withdraw per calendar month from h
24. button the system computes the amount And while saving the system validates the sum of Pay In Amounts against the TD Amount keyed in The system will validate for the following e The deposit amount should be equal or greater than minimum booking amount maintained at the Deposits Cluster Maintenance screen else the system will display the following error message The deposit amount is less than the minimum booking amount e The deposit amount should be a multiple of the booking unit maintained at the Deposits Cluster Maintenance screen else the system will display the following error message The deposit amount must be in multiples of booking unit 4 16 ORACLE Computed Amount Specify the computed amount Next Maturity Date On selecting the rollover for the TD account the system defaults the next maturity date from the previous tenor of the deposit Deposit Tenor The system calculates the tenor of the deposit account to the difference between profit start date and Maturity date and displays it In case of change in maturity date the system changes the value of this field Rollover Type e Principal e Principal Profit e Special Amount e Profit Rollover Amount If a special amount is to be rolled over you have to specify the amount less than the original deposit amount in this field Payin Details You can view the following details of the deposit Term Deposit Pay in Option Indicate th
25. by providing appropriate reasons for the same During maintenance or online operations in the respective contract screens for the restricted transactions when you specify the customer account the system checks whether the account is restricted for the product that has been selected or the debit credit transaction type If so an override is sought when such contracts are saved Cr During transaction processing the system will validate whether any restrictions are placed on the account based on either product and or transaction code If you have indicated to allow debit transactions for the product ABCD and attempt to post a credit entry the system will seek an override You can continue the transaction despite the restrictions by providing appropriate reasons for the same 2 84 ORACLE During maintenance or online operations in the respective contract screens for the restricted transactions when you specify the customer account the system checks whether the account is restricted for the product that has been selected or the debit credit transaction type If so an override is sought when such contracts are saved 2 85 ORACLE 2 3 16 Specifying Currency Limits Details Currency limits are maintained through the Currency Limits Details screen Click the Currency Limits button in the Islamic Customer Accounts Detailed screen to invoke this screen G Currency Limits Details Branch Code Account Currenc
26. else the system will display the following error message Withdrawal exceeds minimum balance level Waive Compensation Check this field to waive any compensation related to the deposit redemption Waive Profit Check this box to waive of a particular profit that has been specified Tenor Specify the following details for TD tenor in case you are renewing the TD Days Specify the renewal tenor in terms of days Months Specify the renewal tenor in terms of months Years Specify the renewal tenor in terms of years 4 27 ORACLE Redemption By Select the means of redemption from the following options e Savings e General Ledger e Bank Check 4 5 1 Bank Cheque Tab By default this tab is displayed when the screen is invoked You can capture the following details Cheque Details Specify the following cheque details Bank Code Specify the bank code of the Bankers cheque Cheque Date Specify the cheque date for the redemption Cheque Currency Specify the currency in which the cheque is drawn The adjoining option list displays all valid currency codes maintained in the system You can select the appropriate one Cheque Amount The amount being liquidated for the TD is displayed in the cheque currency Exchange Rate In case the TD currency is different from the cheque currency the exchange rate used to convert TD currency into cheque currency is displayed here based on the rate maintained for the cur
27. for instance if you define a monthly primary statement you cannot define a secondary or tertiary statement with a monthly frequency e Offline limit is maintained only for primary level Tertiary Account Statement Parameters Indicate the following details 2 10 ORACLE Type The first preference that you specify for Islamic account class is to indicate whether the periodic generation an account statement is required If the generation of an account statement is necessary you have to specify the format in which it is to be generated The options available are e None e Detailed indicating that the statement should be a detailed account of all the customer transactions within the account class e Summary indicating that only a summary of the transaction details is enough Cycle The system generates the account statement details at a frequency that you specify The frequency can be e Annual e Semi annual e Quarterly e Monthly e Fortnightly e Weekly e Daily If you indicate that the statement generation frequency is weekly you should also indicate the day of the week on which the account statement is due Similarly for a monthly statement you should indicate the day of the month On To specify the frequency for a monthly statement you can specify a number between 1 and 31 corresponding to the system date If you set the statement date to 30 then account statements will be generated on e The last workin
28. maintained the settlement mode as direct debit transaction The upload happens for both automatic liquidation and manual liquidation 2 106 ORACLE 2 3 25 Specifying Account Signatory Details Account Signatory details are maintained through the Signatory Details screen Click the Account Signatory button in the Islamic Customer Accounts Detailed screen to invoke this screen Signatory Details Branch Code Account Account Description Customer No Minimum No of Signatories Customer Name Account Message Signatory Details 10f1 ro Signature Id Signatory Name Signatory Type Approval Limit Signatory Message E O Here you can capture the following details Branch The system defaults the current branch here Account Number This is the account number to which signatories are to being linked Account Description The system displays the description for the account you have selected Customer Number Enter the customer signatory you want to link to the account You can link a customer signatory to an account either by e Click on the option list next to the Signatory Number A list of customer signatory numbers whose details have been captured will be displayed along with their names Pick up the signatory whom you want to make an account signatory for the account e Keying in the customer Signatory Number and Name directly if the signatory number has not been maintained through the Custo
29. system will refund all the taxes that are levied till date for the deposit This option will be enabled only when you maintain deposit type of profit products 3 1 10 1 Passing accounting entries for the refund amount When a preclosure of a term deposit takes place the original tax entries are not reversed Instead the system will pass a new set of entries for the refunded tax amount The amount tag TAX_REFUND will be used to pass the refund entry This amount tag will give the total tax calculated on the profit Accounting Role Amount Tag Dr Cr Indicator LIABGL TAX_REFUND Cr Liability GL for Deposits FRTAXS_PAY TAX_REFUND Dr Tax Payable GL Example The following example will illustrate the manner in which tax is calculated and refunded on preclosure of a term deposit Mr Silas Manner a customer of your bank makes a deposit for a period of three months The details of the deposit are as follows e Opening date 10 October 2003 e Maturity Date 10 January 2004 e Deposit amount 10000000 e Profit rate 13 5 e Profit Basis Actual 360 e Compensation Profit 13 The profit rate of 13 5 will be applicable from the opening date and will remain constant for the term of the deposit Now we will calculate the profit and tax due on the deposit on a month end basis As on 31 October 2003 Number of days 22 from 10 Oct to 31 Oct Profit ason31 Oct 82500 00 100000
30. the Auto Reorder of Cheque Book option is checked Reorder Number of Leaves Specify the number of leaves that should be ordered for the new Cheque Book This field will be enabled only if you have checked the Auto Reorder of Cheque Book option earlier Cheque Book Name 1 Specify the name used for opening savings account A1 This name will be printed on the cheque book and will be used for all cheque transactions Cheque Book Name 2 Specify the name if you need to enter the name of the joint account holder on the cheque book if the customer account is joint operations account Max No of Cheque Rejection The system defaults the value of maximum number of cheque rejections that can be allowed for an account from the account class However you can modify it at the account level Initial Funding Account Opening Amount Specify the amount being deposited to open a customer account While saving the record the system checks whether this amount is equal to or greater than the minimum limit maintained for the linked account class If the amount is less than the applicable limit the system will display an error message If it is equal to or greater than the limit amount the system will proceed with saving Input to this field will be mandatory if limit amount has been maintained for the linked account class Pay in Option Indicate the method for initial funding during account creation Choose one of the following op
31. 0 DEPOSIT_AMOUNT MUDARABAH_RATE 100 DAYS YEAR For details about the screen refer the chapter Maintaining Interest Rules in the Interest and Charges User Manual 5 3 UDE Value Maintenance You can maintain UDE values for the rules using the User Data Element Maintenance screen You can invoke the Interest amp Charges User Data Element Maintenance screen by typing ICDUDVAL in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button UDE Values Product Code Branch Code Effective Date Description Accrual Frequency Liquidation Frequency Days Months Years User Data Elements E User Element Account Class Currency Code Rule Product Accruals Rate Chart Allowed Description User Element Amounts Currency Description User Element Value Rate Code TD Rate Code ol az laz Input By Date Time Authorized By Modification Authorized Exe Date Time Number Open For details about the screen refer the chapter Giving UDE Values for Condition in the Interest and Charges User Manual In this screen you need to maintain the following UDEs for the different IC products Assume that you have maintained the following IC products e TD with Capitalization e Normal TD with Simple Profit e
32. 000 then the customer is alerted that the credit facility against the FD is breached The Intermediate data store consists of the following details e DCN e BRN e Customer Account Number e Customer No e Customer Mail e Customer Mobile No e Utilized Amount e Overdraft Amount e Dispatch Flag You need to maintain the following message advice format through the Advice Format Maintenance screen RH 2 126 ORACLE lt SOD ACCOUNT UTILIZATION gt Date DATE _ Bank Name _BANK NAME _ Branch Address BRANCH ADDR_ Customer Name CUST NAME1_ Customer ID CUSTOMER __ Account Number ACCOUNT NO _ OD Amount OD AMOUNT _ Utilised Amount _UTIL_AMOUNT _ EH B SC IF _DIFFEQAUL_ Your Account with Account Number _ACCOUNT NO_has reached the limit of the OD ENDIF IF _DIFFGREATER_ Your Account with Account Number _ACCOUNT NO_ has breached the limit of the OD by _DIFFGREATER_ ENDIF EC EB RF 2 127 ORACLE FOR __BRANCHNAME _ AUTHORIZED SIGNATORY EF For more information on Advice Format refer Maintaining Advice Format chapter under Messaging System User Manual Note the following e For multiple collaterals you need to consider consolidated limit amount for deriving the breach limit amount e The process of sending of the SMS alert messages is handled by the third party system e The system re uses the following key information for alert generation
33. 10 Specifying Instructions Details You can maintain Account Operating Instructions for a branch and customer account combination The operating instructions are different from the standing instructions and merely indicate the instructions to be borne in mind when operating a customer account The instructions are maintained through the Islamic Customer Accounts Detailed screen invoked by clicking the Instructions button 2 74 ORACLE Account Operating Instructions Maintenance Date of Last Maintenance Maintenance Instruction Conditions 1 Instructions 1 Conditions 2 Conditions 3 Conditions 4 Instructions 2 Instructions 3 Instructions 4 Conditions Elements Operators Value Cancel You can enter the following details in this screen Date of Last Maintenance The current system date is also displayed Instructions Specify the instructions to be borne in mind when operating a customer account Conditions At the time of maintaining an instruction you can also specify a condition for displaying the instructions when transactions pertaining to this account are being processed The instruction will be displayed to you when the condition is satisfied The sign on branch code is defaulted when you main
34. Applicable Customer Liquidate Using Receivable as erify Funds Charges Debit Notice Charge Start Advice Liquidation Days Advice Days Liquidation Mode Free Period BranchiCurrency Restriction CustomersiCategories MIS Preferences REG Deposit Auto Deposit Status Rule Amt Block Statement nonce ees Maker Date Time Mod No Checker Date Time Record Status Authorization Status 4 1 ORACLE 4 2 1 Refer the section Maintaining Islamic Account Class in the chapter Creating Islamic Accounts of this User Manual for details about setting up an account class Typically for every deposit scheme you offer at your bank you would set up a Deposit Type Account Class Specifying Deposit Preferences Click the Deposit button to define the parameters for a deposit type account class The Deposit Account Details screen will be displayed Deposit Account Details Rollover Minimum Close On Maturity Maximum Allow Partial Liquidation Grace Period for Renewal Allow Partial Liquidation Reference Date with Amount Block Auto Extension Move Profit To Unclaimed Allow Prepayment Move Principal to Cluster Identification Unclaimed Minimum Tenor Default Tenor Maximum Tenor Days Days Days Months Months Months Years Years Years Recurring Deposit Installment Frequency Redemption Recurring Deposit Days Redemption Move Maturity to Unclaimed Months Pre Redemption Move funds on Over
35. Charges Check this box to indicate that account opening charges should be waived for individual customer account 2 58 ORACLE Provisioning Details Auto Provisioning Required You can indicate whether provisioning is applicable for the account If you indicate so the provisioning batch when executed picks up the account for provisioning Exposure Category If the logic for deriving the exposure category of the CIF or customer group to which the customer belongs based on the total exposure has been maintained in the Exposure Type Category Linkage maintenance then the exposure category of the account is identified If no logic has been maintained you can specify the exposure category in the Islamic Customer Account Maintenance screen Risk Free Exposure Amount You can indicate the risk free exposure amount that would be used in computing the provisioning amount for the account Provisioning Currency You can indicate the currency in which the provisioning amount must be calculated either account currency or local currency This specification is defaulted from the preferences for the Islamic account class used by the account and you can alter it if necessary Options Indicate the following Euro Cheques Euro chequebook can be issued to a customer whose account has checked for Euro cheques option in the customer account maintenance screen the account should be a account with EUR currency only Mt210 Requi
36. Deposits First Deposit For creating an auto deposit you have to maintain the following parameters Account Class For creating an auto deposit you have to specify an account class of the deposit The tenor and profit conditions maintained for the selected account class will be defaulted You cannot create an auto deposit if the Account class you have chosen has expired that is surpassed the end date maintained for the account class The system will log an exception in such a case Transaction Code You have to specify the transaction code for the auto creation of the deposit Currency Mention the currency in which the deposit is created Minimum Required Balance The minimum balance indicates that only the amounts above this limit will be used for auto creating deposits You have to specify the minimum amount that the customer can retain in the account Deposit Multiple Of For an account you can indicate the amount which will be the basis for the deposit amount wherein the deposit amount will be in the multiples of the amount you specify here 4 5 ORACLE 4 3 Def Rate Code Select the code of the differential rate from the adjoining option list Def Rate Type Select the type of differential rate code whether Mid or Buy or Sell Break Deposits First Check the box to indicate whether you want the funds to be moved by breaking deposits before breaking the deposit accounts If you leave the box
37. Holder Balance Type field Bank Parameters Preferences screen Depositors On selecting the Mudarabah fund id the system displays the total investment of the fund as contributed by the depositors in this field The system arrives at this amount based on the preference set in the Profit Contribution Balance Basis field in the Account Class Maintenance screen for the account class to which the particular Mudarabah fund id is linked Total On selecting the Mudarabah fund id the system displays the total investment of the fund in this field Weights in Specify the weight as a percentage of the total shareholders investment that should be used to compute the profit for shareholders The system shows a default value of 100 However you can change it EFF WTS Once the shareholders weight is specified the system displays the effective weight of the shareholders as a percentage of the total shareholders investment PEA GL ADJ You can specify the adjustment amount posted to the PEA GL contribution Share Holders ADJ You can specify the adjustment amount posted to the shareholders contribution Total ADJ The system displays the sum of the Shareholder Depositor and PEA contribution after adjustment Profit Distributable to Depositors The system deducts the PEA from the depositors share of profit minus the Mudarib fee and displays it here 3 42 ORACLE 3 6 1 3 Total Profit
38. Liquidation Start Date as the last date of the month from which you would begin liquidation For example for a month end quarterly liquidation beginning March 98 you should have the Liquidation Start Date as 31 March 98 You should also check the box against Liquidation at month ends Thus all the accounts that are linked to a product will have the same liquidation date fixed using the first liquidation date and frequency irrespective of their account opening date The first ever profit liquidation would therefore be for a period that may not reflect the frequency of liquidation for the product The following example illustrates this point Example The frequency of profit liquidation for a product is quarterly and the First Liquidation Date is 31 March 98 All accounts linked to this product will have an automatic profit liquidation on 31 March 98 irrespective of the date on which they were opened Profit for an account opened on or before 01 January 98 will be liquidated on 31 March 98 and so will an account opened for example on 30 March Thus accounts that were opened anytime during this quarter will have varying number of profit days depending on the date they were opened Also the month in which the account was opened will be considered for profit application depending on your definition in the Rule Maintenance screen During subsequent automatic liquidation s profit will be applied for a quarter pr
39. On To specify the frequency for a monthly statement you can specify a number between 1 and 31 corresponding to the system date If you set the statement date to 30 then account statements will be generated on e The last working day for months with lt 30 days e For months with 30 days on the 30th if 30th is a holiday on the next working day If you set the statement date to 31 then account statements will be generated on e The 31st for month with 31 days if 31st is a holiday on the next working day e The last working day for months lt 31 days 2 12 ORACLE For all other cycles account statement would be generated on the last day of that cycle 2 2 3 Capturing Additional Details You can capture additional details for the Islamic Account Class by clicking the following buttons in the Islamic Account Class Maintenance screen Button Function Restrictions This invokes the Account Class Product and Transaction Codes Maintenance screen Branch Currency This invokes the Branch Currency screen Restriction Customer This invokes the Account Class Customer List screen Categories MIS This invokes the Management Information System screen Preferences This invokes the Preferences screen REG This invokes the REG Details screen Deposit This invokes the Deposit Account Details screen Auto Deposit This invokes the Auto Depo
40. Regulation D applicability as Statement Cycle the restricted transactions would be counted over the primary statement cycle defined for the account class 2 27 ORACLE The Regulation D applicability details specified for the account class would default to all accounts using the class However you can make changes to these details when you set up a customer account that uses the account class 2 2 11 Specifying Deposit Details To handle term deposits in Oracle FLEXCUBE you have to set up an account class of type Deposit in the Account Class Maintenance screen Identify the account class you are setting up with a unique code and a brief description To handle term deposits choose the Deposit option under Account Type Typically for every deposit scheme you offer at your bank you would set up a Deposit Type Account Class 2 28 ORACLE Click the Deposit button to define the parameters for a deposit type account class The Deposit Account Details screen is displayed Deposit Account Details Minimum Tenor Rollover Close On Maturity Allow Partial Liquidation Allow Partial Liquidation with Amount Block Move Profit To Unclaimed Move Principal to Unclaimed Days Months Years Recurring Deposit Minimum Schedule Days Minimum Installment Amount Recurring Deposit Move Maturity to Unclaimed Move funds on Override Minimum Maximum Grace Period for Renewal Referenc
41. TD with Rate Chart Allowed 5 5 ORACLE e Recurring deposit Scheme 5 3 1 TD with Capitalization You need to maintain values for the following UDEs under this product e D1 e D2 e D3 e TD_PNL e TAX_RATE 5 3 2 Normal TD with Simple Profit You need to maintain values for the following UDEs under this product e D1 e D2 e D3 e TD_PNL 5 3 3 TAX RATE TD with Rate Chart Allowed You need to maintain values for the following UDEs under this product e D1 e TD_PNL e TAX_RATE 5 3 4 Recurring deposit Scheme You need to maintain values for the following UDEs under this product e TD1 e OVERDUE_PENALTY e TAX RATE 5 6 ORACLE 5 4 IC Rates Maintenance You can maintain rate codes for branches using the IC Rate Code Branch Availability Maintenance screen You can invoke this screen by typing ICDRESTR in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button IC Rate Code Branch Availability Rate Code Branch Restrictions Allow Disallow Branch Specific Rates o az Input By Authorized By Modification Authorized exit Date Time Date Time Number Open You need to maintain the following rate codes for all branches of your bank e FLOATRATE 5 7 ORACLE For the aforesaid rate code you need to maintain rates and effective dates in the Interest and Charges Rate Input screen You can invoke the Int
42. The following conditions should be satisfied for initiation of automatic reordering e The Auto Reorder of Cheque Book option is turned on at the account level e The number of unused check leaves for the account is less than or equal to the reorder level maintained at the account level The system will pick up the number of leaves to be reordered from the field Reorder Number of Leaves maintained for the account The numbering of cheque leaves for the new Cheque Book will depend on the Cheque Number Unique for Branch option in the Bank Parameters screen If this option is checked the numbering will begin from the Last Number 1 of the Cheque Book that was delivered last to any account If you do not select this option the number will start from the Last Number 1 of the Cheque Book delivered to the same account previously The value of Include for Cheque Book Printing and Cheque Type specifications defined in the Cheque Book Details screen will be defaulted from the previous order of the Cheque Book 2 61 ORACLE Reorder Cheque Level Here you have to indicate the level at which the reordering of Cheque Book should happen Automatic reordering will be set off by the system when the unused number of cheque leaves becomes equal to or less than the re order level that you maintain here This field will be enabled only if you have indicated that automatic reordering of Cheque Books is required that is
43. Viewing Total Available Balance Details The total available balance displayed by the System includes the unutilized line amount in case the customer enjoys an OD limit 2 119 ORACLE Example The customer account has a line with an amount of USD 50 000 linked to it Case e Account has a Credit balance of USD 1000 e Total unutilized line amount is USD 50 000 e Your bank would like to see USD 51 000 The total available balance is displayed as e Unutilized Line amount USD 50000 e Total available balance USD 51 000 Case Il e Account has a Debit balance of USD 2000 e Total unutilized line amount is USD 48 000 e Your bank would like to see USD 48 000 The total available balance is displayed as e Unutilized Line amount USD 48 000 e Total available balance USD 48 000 In the Amounts and Dates screen you can view the outstanding debit profit and or charges due on the account as on the current date You can also view the amount that can be withdrawn against uncollected funds on the account The System computes the allowable amount based on the Withdrawable Uncollected Funds Basis option specified in the Branch Parameters Preferences screen e Viewing Turnover Amounts In the Customer Account Turnover Amounts screen you can view the total turnover of this customer account from the first date of this month to the current day s system date Also you can view the accumulated profit associated with debit o
44. an account e periodically e onan ad hoc basis Monthly liquidation of profit on an account is an example of periodic liquidation When you do not liquidate profit on an account at fixed intervals the liquidation is referred to as ad hoc liquidation If you opt to liquidate profit periodically you can automate the liquidation process The automatic processes that are generated at the end of day will liquidate profit for those accounts that are marked for liquidation 3 18 ORACLE You can perform an ad hoc liquidation on accounts anytime even if the accounts are marked for auto liquidation You should necessarily liquidate profit before you e close an account e change its account class e change the calculation account Specifying the Liquidation Frequency The term liquidation frequency refers to the interval between successive periodic liquidation s You can specify the liquidation frequency for the profit product that you are creating You can specify the liquidation frequency in e days e months e years Days If you want to liquidate profit every 15 days enter 15 If you want to liquidate profit every 9 days enter 09 Months If you want to liquidate profit every month enter 01 If you want to liquidate profit every quarter enter 03 Years If you want to liquidate profit every year enter 01 Example Assume you would like to liquidate profit every qu
45. an account class The following are the preferences that you can specify for Islamic account class e Limit Check You can check this box to indicate that a limit check for sufficient availability of funds in the account will be made for all accounts belonging to the account class e Overdraft Facility If checked it indicates that all accounts belonging to this class would be allowed an overdraft facility facility to draw a specified amount over and above the balance in the account e Passbook Facility If checked it indicates that accounts linked to the account class are issued passbooks e Track Receivable If checked you can choose to block the subsequent credit that happens to the settlement account linked to this account class of a finance contract or retail teller contract if the system detects insufficient funds in the account during liquidation In other words the system will track the account for receivables credits As and when a credit happens the funds will be allocated to the finance or the retail teller contract for liquidation e Account Statistics You can enable printing statistics in respect of accounts using an account class either period code wise or financial year wise for the following customer information 2 22 ORACLE gt Low and High Balance for a period The lowest and highest current balances for the period gt Average credit and debit balance for a period This is comput
46. and MOD 11 validation if the value of the UDF Clearing A C Mandatory is maintained as YES in the Field Name to Value Definition screen However you can choose to change this number here and the system validates this number with the account mask you have maintained for the branch IBAN Account Number To capture the detail of the IBAN account for a specific customer you have to enable the IBAN Required option by enabling it Subsequently click the M button The IBAN details sub screen will be displayed In this screen you can capture the IBAN Account Number as well as the bank code of the bank where the IBAN account resides Address Specify the address of the customer Statuses The status reflects the status of the account The account may have a No Credit or No Debit order issued against it or a Stop Payment order or it may have been frozen for some reason and therefore dormant While posting transactions to the customer account the system checks the status of the account before the entry is processed No Debits No debits can be posted to the account For example Silas Marner a customer of your bank going abroad for a year instructs you not to debits his account till his return You can execute this instruction by checking this box 2 49 ORACLE No Credits No credits can be posted to the customer account by enabling the check box positioned next to this field Stop Payments For Stop Payments if in t
47. button in the Islamic Customer Accounts Detailed screen The Linked Entities screen will be displayed Csccusin_Desc Account Number 10f1 You can enter the following details in this screen Customer Select the customer from the option list with whom you want to establish the relationship with the customer account that you are maintaining Description In this field the system displays the name of customer that you have selected in the previous field You cannot change the description Relationship You have to choose a relationship code to establish a relationship between the customer being selected and the customer account you are maintaining By default the system will select the customer of the account as the Primary Holder This is a pre shipped relationship and you will not be allowed to change the relationship 2 3 13 Specifying REG Details For a customer account you can indicate whether check deposits to the account must be considered for Reg CC availability You can indicate this in the Reg Details screen which you can invoke by clicking the REG button in the Islamic Customer Accounts Detailed screen A customer account using an account class for which Regulation D limits are applicable inherits the applicability of Regulation D limits However you can make changes to the details if necessary 2 77 ORACLE In the Islamic Customer Accounts Detailed screen click th
48. categories and allowed and disallowed customers 2 16 ORACLE 2 2 6 1 1 Maintaining Branch Preferences You can specify the branch and currency preferences through the Branch Currency screen Click the Branch Currency Restriction button in the Islamic Account Class Maintenance screen The screen will be displayed Branch Currency Account Class Branch Details Currency Details Branch Restrictions Allowed Disallowed Available Branches 10f1 O Currency Preferences All the allowed currencies you have defined for this account class will be displayed in the Allowed column You can enter the minimum balance that should be maintained against each currency Additionally you can also enter the currency wise minimum balance for the profit sharing that should be maintained in the accounts under the account class to be eligible for profit sharing Customer accounts maintained in any branch can be linked to any account class However you have the option of restricting the linkage of customer accounts in a particular branch or branches to an account class Example Your bank has a total of 25 branches Branch 001 and 004 handles only Corporate Customers For an account class say SAV IND savings accounts of individuals you would like to disallow linkage of all customer accounts of branch 001 and 004 To specify this click on disallowed since the disallowed branch list is smaller than the allowed
49. check digit it could be alphabetical or numeric depending upon the mask defined You cannot alter the relative position of the constituents of customer account as defined in the mask while maintaining actual customer accounts Currency You have to identify the currency of the customer account A list of all the currencies maintained in the system will be displayed in the available list You can select the currency of transaction for the respective account If the currency of the account is not defined for the current period in the Turnover Limit Maintenance screen you will not be able to save the account In case the account is linked to a fund The system defaults the fund currency You cannot modify this SD User Reference The system displays the SD user reference for the TD accounts Customer No If you have included the CIF Number of the customer as part of the Account Mask the system automatically defaults the CIF code of the customer in the respective field You will not be allowed to modify this code However while defining the Account Mask in the Account Parameters section of the Bank wide Parameters screen if you have specified that the CIF Number should not be a part of the account mask you will have to specify the customer code manually A list of all the valid customer codes is displayed in the available option list You can select the appropriate Customer Name On entering the Customer No the customer name
50. chosen if the system finds the account balance greater than or equal to the minimum balance for profit sharing Except for Dly Net Balance amp Avg Balance the system will consider that account for profit sharing e Mudarabah Fund ID You can indicate as to which fund the aggregate account balance of all the customers under this account class will report for the depositor contribution from the option list e Processing for consolidation of inward Clearing During the Inward Clearing process the consolidated entry for clearing will be passed according to the following grouping gt Remitter s Account gt Clearing Product gt Instrument Currency gt Remitter s branch gt End point A consolidated clearing entry will be passed using a separate Transaction Code maintained in the Clearing Product Preferences screen This Transaction Code should be set with Cheque Mandatory option as No in the Transaction Code Maintenance screen One consolidated clearing entry will be passed for each of the above groups Entries will be passed against a common reference no generated for each of the groups After the consolidated entry has been passed each individual instrument will be processed separately to pass charge entries if applicable at the transaction level Cash Reserve Ratio Specify the cash reserve ratio that should be maintained for all accounts under this account class This ratio will be applied on the account ba
51. is automatically displayed Account Class In Oracle FLEXCUBE you can classify the customer accounts of your bank into different groups Each group is referred to as an account class and is maintained in the Account Class Maintenance screen For each class you have to define certain common attributes applicable to all accounts in the particular class 2 47 ORACLE 2 3 1 While maintaining a specific account you have to identify the class to which the particular account belongs You can select the appropriate account class from the list of all the valid account classes maintained in the system Account classes that have surpassed their end date expired will not be displayed in the option list Main Tab The Main tab is displayed by default in the Islamic Customer Accounts Detailed screen The fields in the Main section are as follows Description This is the description of the account Here you can enter the nature of the account like current savings overdraft and so on If a customer has two or more accounts under one account class you can specify the purpose of that account Account type You have to indicate whether the account is to be opened only by the account holder or whether it can be jointly operated Fund Id The system defaults the Fund Id from the account opening fund MIS The system displays this field only in a case where the selected branch is a fund branch Country Code To define the count
52. mode of redemption from the following options e Full Redemption In this case you can redeem the complete deposit balance of the account On save the redemption amount will be equal to the account balance Full redemption will update the status of the deposit amount as closed On complete redemption profit along with principal is redeemed The redemption amount is equal to the total of principle and profit amounts subtracted by penalty and tax amounts 4 26 ORACLE e Partial Redemption In this case you have to specify the redemption amount Ensure that that the redemption amount is less than the account balance On partial redemption only the principal amount is withdrawn where as the profit amount is liquidated only on liquidation cycle Redemption Amount Specify the redemption amount for the partial redemption Ensure that that the redemption amount is less than the account balance On partial redemption only the principal amount is withdrawn where as the profit amount is liquidated only on liquidation cycle rne system will validate for the following e During partial redemption the withdrawal amount should be a multiple of withdrawal unit maintained at the Deposits Cluster Maintenance level else the system will display the following error message Withdrawal amount must be multiples of withdrawal unit e Withdrawal amount should be greater than minimum booking amount maintained at the Deposits Cluster Maintenance level
53. new account under the account class is disallowed Consequently the option list for Islamic account class in all further transactions screen in Oracle FLEXCUBE will not display the expired account class as of the system date However the existing accounts for the account class will be active even after the end date If you do not specify an End Date for the account class the account is taken to be an open ended account class Account Details Tab The Account Details tab is displayed by default in the Islamic Accounts Class Maintenance screen The fields in the Account Details section are as follows Account Code As per your bank s requirement you can choose to classify Islamic account class into different account codes The bank can decide the manner in which the account classes are to be assigned to different account codes An account code can consist of a maximum of four characters Depending on the customer account mask maintained the value in the account code field would be used during the generation of customer account numbers through the Islamic Customer Accounts Maintenance screen If you have decided to include account code as part of the customer account number in the account number mask then at the time of creating a new customer account number you will need to select the account class for the account number being generated In the option list provided the account class is displayed along wit
54. option indicates that a notification needs to be sent to customers before debiting the customer account for the profit charge calculated for the period 2 6 ORACLE Liquidation Days Specifies the number of working days from the actual liquidation date before the profit charge can be liquidated into the customer account Working days are calculated on the basis of the Local Holiday Calendar Liquidation Mode Debit profit or charges can be liquidated either Manually or Automatically If you choose the automatic mode of liquidation debit profit or charges are liquidated automatically as part of the BOD process on the liquidation date However after having specified Auto as the mode of liquidation if you wish to liquidate them manually for a specific account the System intimates you with an override message Manual profit liquidation can be triggered through the Debit Profit Liquidation screen Manual liquidation is recommended during Account Closure Note the following e You will not be allowed to change these preferences at the account level However in the Amounts and Dates section of the Islamic Customer Accounts Maintenance screen both the total debit profit due as well as the charges due are displayed e If there is any outstanding profit or charges on the account the outstanding amount is displayed as an override while saving the transaction involving the account e While closing an account closure the system
55. option to indicate that Integrated Liquidity Management is applicable to the customer IL Product Type Specify the IL product type Waive Profit Check this box if you need to waive of profit or charges defined for the selected profit product at the Profit Product Preference level Generate UDE Change Advice Check this box if you need to generate advice for user defined changes for the account Open Check this box if you need to apply the selected profit product for the account Specifying Charges Details You can capture details of charges for the account using the Account level charges conditions screen To invoke this screen click the Charge button in the Islamic Customer Accounts Detailed screen Account level charges conditions Account Details Branch Code Account Defaut Product Details Product Code Description Currency Minimum Maximum Free Items Waive Charges Open List of Slab Amounts 10f1 Li 2 69 ORACLE You can enter the following details Branch The Branch Code to which the account belongs for which you are defining special conditions is displayed in this field Account The Account number of customer for which you are defining special conditions is displayed in this field You can click the Default button to default the Charge Products and the corresponding details applicable for the account You can then modify these values to de
56. profit product has to be considered for TDS Tax Deducted at Source calculation or not To indicate that the product is to be used for computation of TDS click Include for TDS Calc in the Product Definition screen for the Profit product you are maintaining In case you do not want to use a particular profit product to compute TDS leave the box unchecked Deposit The profit that applies on time deposits may vary with every deposit product you offer In Oracle FLEXCUBE profit on a time deposit and balance type accounts is calculated on the basis of the Profit Rules and Profit Products that are associated with the deposit account To calculate and apply profit on a Mudarabah time deposit you have to set up a Mudarabah profit product Indicate that the Mudarabah profit product you are creating applies on deposit accounts by choosing the Deposit option in the product type For a deposit type Profit product you have to specify the Unclaimed Deposits GLs that should be used to move the principal and profit amounts of unclaimed deposits The Accounting Roles for the GLs are PRN_UNCLAIMED and INT_UNCLAIMED respectively In the Accounting Role Definition screen you have to map these roles to the appropriate Miscellaneous Credit GLs maintained In addition in the Event Definition screen you have to specify the accounting entries for the event MAT For this event you have to specify all possi
57. status of the debit card by selecting one of the following values e Open e Closed Branch Code The system displays the branch code where the debit card has been issued 2 113 ORACLE Request Reference Number The system displays the request reference number of the card issuance record Card Number The system displays the debit card number of the card holder Multiple cards can be issued to a customer 2 3 29 Specifying OFAC Check Details OFAC check enables the application to call an external web service to perform black list check for customer and customer accounts and give warnings appropriately while transacting with black listed customers You can also capture your remarks before overriding the black list warning 2 114 ORACLE Click OFAC Check button in Islamic Customer Accounts Detailed screen to view the OFAC check response in the External System Details screen On clicking OFAC Check button system will build the request XML and call the web service The External System details screen displays the response is received from the external system and you will be also allowed to enter your remarks in this screen The response received will also be sent to Oracle FLEXCUBE Database layer for any further interpretations of the same External System Details External System Response User Remarks Here you can view capture the following details External System Response The response from t
58. the account balance as the depositor s contribution but it will not distribute profit to the depositor Account Set for Closing On receipt of the closure request for the account wherein profit distribution is due you can check this box after making the account balance 0 and then pay the customer If a transaction is initiated on an account for which this box is checked the system will display the following override Account set for closure do you wish to still process If you select OK the system will allow you to proceed with the transaction This override will be displayed only if the transaction is initiated using any module other than the Funds transfer module In case of a transaction initiated through the FT module on an account for which this box is checked the system will display an error message Note the following e You can check this box only for a Savings type of account e Once you check this box and save the record you will not be able to uncheck it e Upon re opening the account the system will automatically uncheck this box Closing Date The system displays the date on which you have checked the box Account Set for Closing This date is used to validate the profit sharing cycle settlement in order to close the account automatically Status Details Specify the following details 2 51 ORACLE Status At the time of maintaining a customer account for the first time the account statu
59. the current period is 20000 AED Based on the shareholders weight and depositor s weight we can arrive at the shareholders profit and depositor s profit as shown below Shareholders profit Total profit Shareholders weight 100 20000 38 89 100 7778 Depositors profit Total profit Depositors weight 100 20000 61 11 100 3 47 ORACLE 12222 Now allocate PEA from depositor s profit Depositors profit after PEA Depositors profit PEA GL Allocation 12222 2222 10000 Profit for individual depositors account should be arrived at and Mudarib fee should be deducted from individual depositor s account AC00001 Profit Depositors profit after PEA ACO001 investment depositors investment 10000 20000 40000 5000 AC00002 Profit Depositors profit after PEA ACO002 investment depositors investment 10000 20000 40000 5000 AC00001 profit after Mudarib fee AC00001 Profit 1 Mudarib fee 100 5000 1 20 100 4000 AC00002 profit after Mudaribfee AC00002 Profit 1 Mudarib fee 100 5000 1 20 100 4000 Now allocate IRR from depositor s profit AC00001 Profit after IRR AC00001 profit after Mudarib fee IRR 4000 1 10 100 3600 AC00002 Profit after IRR AC00001 profit after Mudarib fee IRR 4000 1 10 100 3600 3 48 ORACLE 3 7 Profit Calculation Exclusion Batch You can invoke the Profit Cal
60. to an account with a track receivable option the system will check if the account has any receivable being tracked against it If yes the amount is blocked as a receivable and this process continues until the amount needed for liquidation becomes fully available The batch process run as part of EOD BOD will liquidate the loan contract or retail teller contracts If the amount received is not sufficient for full liquidation then depending on the minimum amount required for liquidation the system would initiate a partial liquidation for loans but for retail teller contracts liquidation will be initiated only when full amount is available The following example illustrates the manner in which the system will use the sequence for allocation of funds Assume that you have maintained the following product sequence for funds allocation Sequence No Product 1 ADBN 2 36 ORACLE Sequence No Product 2 LDBD 3 ABCD The liquidation schedule dates for the various loan contracts are as follows Contract Liq Schedule Dt Liqd Amt in USD LDBDOO1 1 January 2002 1000 LDBD002 1 January 2002 500 ADBNOO01 2 January 2002 1000 ABCD001 2 January 2002 500 Further all contracts are marked for auto liquidation and the settlement account for all contracts is A1 The balance in account A1 as on 1 January 2002 is 500 USD Batch l
61. unchecked the Mudarabah profit product for which you have enabled Include for TDS Calc option will be treated as a non tax product The credit profit for the account will be calculated and booked using such non tax products For details on setting SDE s for computing TDS refer to the section Maintaining SDE for TDS under the chapter Maintaining System Data Elements in this Profit and Charges user manual Billing Liquidation Charge products can also be used for billing liquidation on the charges levied for a customer In Oracle FLEXCUBE all the charge products specified for billing liquidation will not be liquidated during the IC EOD process but will be processed during the invoice generation maintained for the consolidated billing product As a result the system handles the EOD processing separately for billing products and non billing products An unchecked box will indicate that the product is a non billing product The Billing Liquidation check box is applicable only for charge products and consolidated charge products Charge Basis If you are creating a Charge product you must specify the basis on which you want to apply the charge You can choose to apply charges on the basis of any of the following e NUM ACCT STMTS Number of Account Statements You can fix the number of free account statements for a liquidation cycle For every extra account statement that you issue you can levy a charge e NUM CHQ RET
62. unchecked the funds will be moved first from the linked CASA accounts Sweep Mode You can indicate the pattern in which sweep outs are created by selecting any on of the two options e Auto Here the amounts are automatically swept out at the end of day when minimum balance exceeds e Manual You have to manually initiate the sweep The sweep will execute only those instructions that are specified while account opening ad hoc Break Method You can choose to maintain the any of the following order of breaking deposits e LIFO Last In First Out Indicates that the last created deposit will be broken first e FIFO First In First Out Indicates that the Earliest Deposit will be broken first e MAXB Maximum Balance Indicates that the Deposits are broken in descending order of available balance e MINB Minimum balance indicates that the order of breaking of Sweep Auto deposit will be done for the Account Deposit with the Minimum Balance Provide Profit on Broken Deposits You have to specify whether you want provide profit on deposits that were broken prematurely Check the box to indicate that you want to give profit for the deposits Leave it unchecked to indicate otherwise Setting Up Profit Preferences for TD You need to set up a Profit Charge product to handle the calculation of profit and charges on a TD You can set up a product using the Islamic Profit Distribution Product Maintenance screen
63. 00 13 5 22 36000 3 23 ORACLE 3 1 11 Tax at 1 825 82500 100 Profit earned 81675 82500 825 As on 30th November 2003 Number of days 30 Profit ason30 Nov_ 112500 10000000 13 5 30 36000 Tax at 1 1125 112500 100 Profit earned 111375 112500 1125 As on 31st December 2003 Number of days 31 from 10 Oct to 31 Oct Profit ason31 Oct 116250 10000000 13 5 31 36000 Tax at 1 1163 116250 100 Profit earned 115087 116250 1163 As on 10th January 2003 Number of days 9 from 10 Oct to 31 Oct Profit on day of maturity 33750 10000000 13 5 9 36000 Tax at 1 338 33750 100 Profit earned 33412 33750 338 Total profit booked 341549 81675 111375 115087 33412 Now on gh January Mr Silas Manner decides to close the deposit He will be charged a compensation at 13 The compensation is calculated as follows Compensation Profit Deposit Amount Days Compensation Rate 100 Days in year 10000000 87 13 100 365 309863 01 Therefore the customer will be charged a compensation profit of 309863 01 due to the preclosure The tax collected till date will be refunded So an amount of 3113 00 825 1125 1163 will be refunded to Mr Silas Manner Deferring the liquidation of periodic profit on a CASA You may wish to defer the calculation and liquidation of periodic profit on an account for a few days beyond the end date
64. 29 as the case may be If a month has 31 days the accruals for the extra day will be done during the next accrual cycle That is the 31st of the month will be taken into account when profit is accrued for the next month Note that accruals will always be done till the Next Working Day 1 that is up to but not including the next working day Specifying the Payment Method In case of Term deposits you have to specify whether the payment method for the main profit is to be Bearing or Discounted This cannot be changed at the time of processing a deposit Discounted Products For discounted products e the payment of profit is upfront e rollover option is also disabled e no profit liquidation on maturity date In case of true discounted the payment method is calculated based on the formula maintained in the IC rule definition and the profit is calculated based on the formula defined at the rule level The rule you define for true discounted products is applied exclusively for the discounted products The rule is maintained in the following two ways e Formula 1 Non booked DEPOSIT_AMOUNT TENOR RATE 100 YEAR The first formula is used for calculating the profit e Formula 2 Booked 3 17 ORACLE FORMULA POWER 1 RATE 100 TENOR YEAR The second formula is used for discounting the result of formula 1 To define the formula for the rule and to calculate the TD profit System Data Element SDE
65. 3 ZIAO Specifying Instr ctions Details sisisi ipi E E E E E E E a i 2 74 2 3 11 Specifying Standing Instructions Details sseesesseseeeeneseeeeseseereseesesrreresesreesesressesersreserrresesreereseee 2 76 2 3 12 Specifying Linked Entities Details cccccc cucsoncsessssesesesoccencsentesetocneessasungessduenevaesseneeneeevensoesepsssonseess 2 76 2313 Specyine REG Details siiin a e R E E E e E E N 2 77 2 3 14 Specifying Account Status Details cccecccesccesccesecsseesecesecsseeseeseeeseeseceseeeeeeeeceseceaecaecaaecaaeeaaeeaseaaeees 2 79 2 3 15 Specifying Restrictions Details ossiani aeai i iien 2 80 2 3 16 Specifying Currency Limits Details cccsccessssesesssesesssesecsseeeceseeseesecssesecaceeecseesesaecseesesaeeeeseaeeneaees 2 86 23317 SPeCifyinie MIS Des srira a E vasetsucesutoctoaneasnsoasguevesuevveude Seu N 2 87 2 3 18 Specifying Change Log Details ccceccccccccesscesscesscesecesecsseesseeseesseeeeeeseeeeeeeseesseeseeeseceaeceaeseaesnaeseaeees 2 88 ORACLE ZIAD Specifying Statement Details vvesnccscesevs iiien ei eau nesncechnesndesngedeeveve us E EERE 2 90 23 20 Specifying Limits Deals nissin nna ine i e E EE E dues R E E E E E E TEN 2 97 2 3 21 Specifying Joint Holders Details cccccccsccessceesseceescessecseccecnsecesacecssecseceecaeceeaeeesaeeseeeeesaeceeneeeneeees 2 100 D322 iSPecif yin UDF Detil oeenn e e i venus E E E ARET E EEE E E EE 2 102 2 3 23 Specifying Deposits Instruction Details o eccceces
66. ACLE 4 1 4 2 4 Creating Islamic Term Deposits Introduction Any deposit with a fixed term or tenor is referred to as a Term Deposit TD To handle a TD in Oracle FLEXCUBE you need to e Setup a suitable account class e Setup a suitable IC product e Maintain a TD account e Define Profit Conditions and other parameters for the deposit account Additionally you need to maintain the following details for operating a Term Deposit TD e Instructions e Payin Parameters e Closing Mode Maintaining Term Deposit Account Class To handle term deposits in Oracle FLEXCUBE you have to set up an account class of type Deposit in the Islamic Account Class Maintenance screen You can invoke the Islamic Account Class Maintenance screen by typing I ADACCLS in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button Account Class Maintenance Account Class Start Date Description End Date Account Type Account Details Statement Parameters Account Code Provisioning Details Escrow Transfer Applicable Dormancy Days Transaction Code Required Account Statement Transaction Code For Format Provisioning Frequency Reversal Display IBAN in Advices rovi Cy Ci p Provision Currenc Local Cash Deposit Limit on Inter Pay Account Trust Account Exposure Category Event Class Code Natural GL Debit Credit Dormancy Parameters Debit Interest Charge Liquidation
67. Account Sato rim Trensactons Report nouce Cards orac Check Change Log Maker Checker Date Time Mod No Date Time Record Status Authorization Status The details maintained in this screen have been classified into three broad heads Main Here you maintain the basic attributes of each customer account like the account number customer code the account class account currency type of account single or joint account status other statuses applicable Cheque Book preferences and so on Auxiliary Here you can view other details like provisioning and so on Nominee Nominee details are maintained under nominee head The Islamic Customer Accounts Detailed Main screen is displayed by default when you invoke the Islamic Customer Accounts Detailed screen The Branch Code of the sign on branch is on display Branch Code The system displays the branch code of the sign on branch 2 46 ORACLE Account You can indicate the account number of the customer One customer can have any number of accounts The structure of the account number is defined in the customer account mask maintained in the Account Parameters sub screen of the Branch wide parameters screen The account number can be a combination of the account class customer code CIF Number serial number or currency as defined in the customer account mask The last constituent of the account number is always a system generated
68. Balance Profit Sh LJ For every allowed currency you can enter the minimum balance that should be maintained against each currency Additionally you can specify the limit for performing cash transactions in an ATM You can also enter the currency wise minimum balance for the profit sharing that should be maintained in the accounts under the account class to be eligible for profit sharing You can also specify the cash reserve ratio CRR percentage for different currencies Amount as per this ratio will be deducted from the account balance before applying weights If the box Escrow Transfer Applicable is checked for the account class you can capture currency wise cash deposit limit for the Trust accounts linked to the account class 2 2 7 Specifying Customers Categories Details Instead of linking each customer account to the account class a customer category is linked to the class 2 18 ORACLE For an account class you should specify the category that should be linked to it and also specify if all customers under each of the categories are to be linked to the account class In the Account Class Customer List screen you have the option of specifying the categories that should be linked to this account class and within a category you can also restrict individual customers to be linked to the class 2 19 ORACLE To indicate allowed customer categories click the Customers Categories button The Account Clas
69. Branch button in the Islamic Profit Distribution Product Maintenance Detailed screen to invoke this screen Branch Currency Restriction Product Code Product Description Class Code Class Description Branch Restrictions Disallowed Allowed Branch Code Currency Restrictions Disallowed Allowed Currency 10f1 L Product Code 10f1 O The code of the Charge product for which you are defining preferences is displayed in this field Description Enter a brief description of the product This description will be associated with the product for information retrieval purposes 3 9 ORACLE 3 1 3 1 Class Details Class Code In this field you can view the code of the product for which you are defining the Branch and Currency restrictions 3 1 3 2 Currency Restrictions First of all you must specify the list type that you want to maintain Under Currency Restriction you will see two buttons If you want to maintain an allowed list of currencies for the product that you are creating click on the button adjacent to Allowed Likewise if you want to maintain a list Disallowed currencies click on the button against Disallowed 3 1 3 3 Branch Restrictions You may want to create a product specifically for certain branches of your bank In such a case you can either maintain a list of e Allowed branches for a product e A list of disallowed branches Click o
70. CDWTMNT Weights Maintenance ICDZAKBA_ Zakat Processing Batch STDREXBT Profit Calculation Exclusion Batch ORACLE ORACLE Islamic Accounts April 2014 Version 11 3 83 02 0 Oracle Financial Services Software Limited Oracle Park Off Western Express Highway Goregaon East Mumbai Maharashira 400 063 India Worldwide Inquiries Phone 91 22 6718 3000 Fax 91 22 6718 3001 www oracle com financialservices Copyright 2005 2014 Oracle and or its affiliates All rights reserved Oracle and Java are registered trademarks of Oracle and or its affiliates Other names may be trademarks of their respective owners U S GOVERNMENT END USERS Oracle programs including any operating system integrated software any programs installed on the hardware and or documentation delivered to U S Government end users are commercial computer software pursuant to the applicable Federal Acquisition Regulation and agency specific supplemental regulations As such use duplication disclosure modification and adaptation of the programs including any operating system integrated software any programs installed on the hardware and or documentation shall be subject to license terms and license restrictions applicable to the programs No other rights are granted to the U S Government This software or hardware is developed for general use in a variety of information management applications It is not developed or intended
71. CLE Formula Number Periodicity Daily v Debit Credit Debit v Book Flag Booked w Daysina Month Actuals DaysinaYear Actuals Accruals Required Rounding Required C Interest Method Default From Currency Definition Tax Category Tax Description Calculation Parameters Booking Basis Percent Book Tax To Expense Local Currency Basis Account Tax Payable Currency Flag Tax Amount Option Option Method Method Basis Amount Decimals Decimals Units Units You need to maintain one booked formulae Formula 1 Specify the following details Book Flag Select Booked from the adjoining drop down list Debit Credit Select Credit from the adjoining drop down list Days in a Month Select 30 Days from the adjoining drop down list Days in a Year Select 360 from the adjoining drop down list Accrual Required Check this box Rounding Required Check this box Click Formula Wizard button and invoke the Formula Wizard screen 5 3 ORACLE Formula Wizard Formula Wizard Result El Expression of Element Functions Operators Logical Operators 5 4 ORACLE Specify the following expressions Case Result DEPOSIT_AMOUNT gt
72. D e Mobile number The system runs a CASA batch adding the following process SODALERT e Identify the SOD accounts to be processed e Read the percentage for breach calculation e Identify if the breach happened e Generate the alert to intermediate data store e Generate the MSG handoff in case the medium is mail e Complete the message generation if the medium is mail e Update the dispatch flag as processed 2 125 ORACLE 2 3 36 1 1 Creating a Message Advice Format You need to create a message advice format through the Advice Format Maintenance screen with the format named SOD_CR_UTIL You should also create an outgoing generic interface to generate ASCII file where in the component details for the generic interface are the elements from the new data store You need to schedule this generic interface to be executed during EOD through GIDPRSIF batch The system processes alerts only if the email address and mobile number are maintained for a customer You can know the Limit Utilization Breach for the account by the application of the following formula Utilized limit amount 2 SOD Amount SOD notification percentage 100 Example Assume the following for processing alerts e Term Deposit booked is for Rs 100 000 for account CHO123 e SOD amount for the corresponding TD CHO123 is Rs 90000 e SOD Notification Percentage is 90 If the Utilized amount for the OD is equal to or greater than Rs 81
73. FLEXCUBE you need to maintain Customer Information Files CIF records for each entity who is a customer of your bank Apart from creating CIF records for each entity you need to maintain separate accounts for each customer The features of these two screens have been discussed in detail in the preceding sections While defining Islamic Deposit Accounts you would have noticed that many of the fields have option lists positioned next to them While some option lists contain pre defined values for some option lists to be populated you need to capture data through separate screens For instance each Islamic deposit account needs to be associated with an Islamic account class Therefore you will need to maintain Islamic account class before you start defining Islamic deposit accounts All such screens have been documented in the subsequent sections Maintaining Islamic Account Class In the Islamic Account Class Maintenance screen where you open Islamic deposit accounts for the customers of your bank each customer account is linked to an Islamic deposit account class and the attributes defined for the account class are by default applicable to the customer account For instance if the frequency of account statement generation has been defined as daily for Islamic account class the system generates statements for all accounts under this class on a daily basis However some of the parameters defined for the account class can be revised at the
74. Here you can capture the following details Total The total profit for the Mudarabah fund is calculated from the income expense type GLs linked to the particular Mudarabah fund in the Mudarabah Profit Calculation Linkage screen Profit ADJ You can specify the total profit adjustment amount Profit After ADJ The system displays the total amount less the profit adjustment Share Holders The system computes the total profit for shareholders based on the effective investment ratio calculated earlier and displays it here Depositors The system computes the profit share for depositors based on the effective investment ratio Total Fee Amount System display the Total Mudarabah fee amount calculated for the Depositor accounts Mudarib fee percentage will be taken from the weight maintenance screen maintained for account class Depositor s Profit After Fee The system deducts the Mudarib fee amount from the depositors share of profit and displays it here Total PEA ADJ Amount System display the total PEA Adj amount made for the depositor in the Profit Calc Update screen Depositor s Profit After PEA The system deducts the PEA amount from the depositors profit fit and displays the net amount here Total Adhoc ADJ Amount The system sums up the adjustment amounts made for the depositors and then displays the total adjustment here 3 43 ORACLE Depositor s Profit After IRR The system displays the deposit
75. Identifier codes for the joint holders e Descriptions of joint holders The following parameters need to be maintained for a joint account Joint Holder This field specifies the code numbers assigned to each of the joint holders of Code this account Description This is the description of the joint holder Here you can enter the name of the joint holder and also his relationship with this customer Joint Holders Branch Code Account Customer No List of Joint Holders 10f1 ro Joint Holder Code Joint Holder Type Start Date End Date CI Indicate the following details Branch The system displays the branch code of the current branch Account Number The system displays the account number here Joint Holder Code This field specifies the code numbers assigned to each of the joint holders of this account Description This is the description of the joint holder Here you can enter the name of the joint holder and also his relationship with this customer 2 101 ORACLE Joint Holder Type Specify the type of authority Select the appropriate one from the drop down menu The options are e Authorized Signatory e Customer Contact Person e Guardian e Custodian e Developer e Guarantor e Joint and First e Joint and Other e Joint or First e Joint or Other e Nominee e Related for Enquiry e Solicitor e Sole Owner e Third Party e Trustee e Valuer e Power of Attorney Start Date
76. Islamic Accounts Oracle FLEXCUBE Universal Banking Release 11 3 83 02 0 April 2014 Oracle Part Number E53607 01 ORACLE FINANCIAL SERVICES Islamic Accounts Table of Contents 1 ABOUT THIS MANUAL wu cceccescscscccecensscsnsscnsssssesessssesessnessesscesosssssnsssssnessesnessesessesssssnesssssessesncssesenses 1 1 1 1 TINTRODUGTION iis seeierstectietatede iibscisevabstes dabsc dictates Netsc setae tes Halse hi REET ATEETAN EE TETE EEEREN EEEE 1 1 L2 AUDENCE iceri Ses istesssctace cs ietest ovate MintatetbldAodstesenie T OERA TETERE AEEA T AEAEE TEET 1 1 V3 ORGANIZATION E Pebvestestestble voststetidsuay donisteceosasie dorustesionite enistsstesisledeistastoites ess 1 1 1 3 1 Related Documents nsien ie oiia iien aE EEA AEE E EAEE taped E ENEE S Yee 1 1 LA GLOSSARY OF LCONS esiis iea e SEEE EAEE EEEREN EN 1 2 2 CREATING ISLAMIC ACCOUNTS seseeeseesssoesesesoecesosoeseseeceoerosoesesesoeoesesesoeeosoroeseseeoeserosoeseeeeoeeosoesesesoeseeese 2 1 2 1 INTRODUCTION as i E A TE AE EE AEN EE EN EEA 2 1 22 MAINTAINING ISLAMIC ACCOUNT CLASS cccsssssssessssensesecsenseseceeneesececneeseceenseseceensesecesneesecesneenesesnseneeneneens 2 1 2 2 1 Account Details TAD escceccssserceseceseversnetseverecenecencssecosesenseesseenenesoeeesenesonsesenesenesetsesneerenseaesoneneseese 2 3 2 2 2 Statement Parameters Tabire aasien aori e i a EN E SA EERE EE EENS 2 8 2 2 3 Capturing Additional Details eccecccccssecscesecssesscsse
77. Islamic TD Accounts Maintenance screen The IC Special Conditions Maintenance screen is displayed ic Special Conditions Maintenance Account Details Branch Code Account Calculation Account Profit Booking Account Charge Booking Account Consolidated Charge Account Currency Profit Start Date Charge Start Date Profit Booking Branch Profit Statement Charge Booking Branch Product Details Product Code UDE Currency IL Product Type Effective Date Integrated LM Product Dr Cr Advices Waive Profit Generate UDE Change Advice Open 10 gt i Hy ereoneoae 05 OOOO O a ara UDE Values 10f1 I m User Defined Element Id UDE Value Rate Code ea In this screen you can specify the following TD related preferences Profit Booking Account Specify the account into which profit on the TD should be booked for the customer 4 23 ORACLE TD Rate Code If you specify a Rate Code for the UDE you will have to specify the rate code that should be applied for computing profit on the TD account Refer the section Specifying Profit Details in the chapter Creating Islamic Account in this User Manual for further details Refer the chapter Creating Islamic Account in this User Manual for further details about the aforesaid buttons 4 24 ORACLE 4 5 Redeeming TD The redemption option enables you to redeem a term deposit Using this option you can do a pr
78. Number of cheques returned Every cheque that bounces is recorded in the Cheques Returned file You can charge compensation on every bounced cheque e NUM CHQ ISS Number of cheques issued For every extra cheque leaf issued you can levy a charge e NUM STOP PAY Number of Stop Payments You can levy a charge for every stop payment instruction e TURNOVER Total turnover You can charge on the basis of the turnover in an account You can opt to levy charges on turnovers exceeding a free amount that you specify in the Charge Product Preferences screen 3 4 ORACLE e ITEM COUNT Number of transactions If the number of transactions during a liquidation cycle exceeds a certain number you can levy a charge e ADHOC STMT Number of ad hoc Account Statements Account statements are normally generated at a specific frequency If you generate an out of turn statement you can levy a charge e NET TURNOVER DR Dr Turnover You can charge a customer on the basis of the debit turnover in an account This will return a value if the account is in debit else zero will be returned e NET TURNOVER CR Cr Turnover You can also charge a customer based on the net credit turnover in the account Sum of all credits the sum of all debits net credit turnover This will return a value if the account is in debit else a value of zero will be returned Turnovers will be applied on an account only if the transaction code associated with the c
79. Only Check this option for Mudaraba products Repopulating the UDE values at Rollover For the account class and currency you can specify whether you want to repopulate the rates during a rollover of the Term Deposits If you opt for this option the system will use the latest available rate maintained UDE for the account class and currency combination at the time of rollover Conversely the system will use the rates maintained initially for the deposit 3 2 Creating a profit Product for Zakat Collection Zakat is a charge that needs to be collected from savings accounts and term deposit accounts of customers who are not exempt from this charge To collect this charge you need to create a separate product for Zakat and then link it to the applicable accounts You need to maintain the following parameters for the Zakat product 3 26 ORACLE Profit Preferences Product Code UDE Currency Description Profit Charges Consolidated Charges Reallocation Through neaer Product Level LM Parameters Accrual Day Integrated LM Product Frequency Integrated LM Type Cycle Payment Method Bearing Discounted Debit Profit Notification Receivable General Ledger Calculation and Liquidation Days First Liquidation On Months Liquidation at Month Ends Year Start Date Start From Account Back Value Recalculation Opening Flag Refund Tax on Pre Closure Defer Liquidation Defer Liquidation Days Liquidation Before Month E
80. The system displays the account class to which the deposit accounts belong You cannot modify it Madarabah Fund ID System will display the Mudarabah fund id to which the selected account class is linked From Period Code The system displays the period code from which the profit needs to be shared Previous Months Period code To Period Code The system displays the period code until which the profit needs to be shared Previous Months Period code Financial Cycle The system displays the previous month s financial cycle 3 37 ORACLE Period Type The system displays type of period for which the profit sharing needs to be done It can be any of the following options e Notional e Actual Product Type The system displays the type of product It could be either Savings or Deposit TD Type If the accounts belong to a Term Deposit account class the system will display the account type Broken Normal Account Ccy The system displays the currency in which the investment account is maintained Amount Slab The system displays the maximum limit of the Investment amount to make up the slab Tenor The system displays the tenor of the deposits falling under the amount slab in terms of months For savings the tenor is displayed as 1 month PPO The system displays the profit pay out frequency of the Investment falling within the amount range and tenor in terms of days months or year The frequency is show
81. a are defined for a product to be applicable for all accounts linked to the product either through an Account Class or as a special condition the accrual accounts will be the same for all the accounts If you choose to accrue at the product level rather than at the account level a consolidated entry will be passed for the formula for all the accounts linked to the product Thus there will be a single accrual entry instead of many If you choose to accrue profit for each Mudarabah account linked to the product an accrual entry will be posted for each account individually The account for which the accrual entry is passed will be shown when you retrieve information about an entry If you opt however to accrue profit at the Product Level the accrued profit due to a formula for all the accounts linked to the product will be consolidated and a single entry posted for the product The details of accruals for each account will be available in the Accrual Control Journal a report generated whenever accruals are performed as part of end of cycle processing Frequency of accrual Let us recall the operations relating to accruals that you have performed so far When you build a profit rule you define if the result of a formula is to be accrued When defining the product to which you link the rule you would e identify the GL SL to which you post the profit accrued Product Accounting Role Definition screen e specify that when the event
82. account details should be displayed in the generated report Specifying Limits Details A bank lends overdraft credit facility to both its corporate and individual customers For a corporate customer a bank defines a credit line based limit For an individual customer the bank gives an account based overdraft limit In the Oracle FLEXCUBE system an account based limit can co exist with the credit based limit For a credit line based limit one customer is designated as a liability customer who is assigned a credit limit Other customers are designated as subsidiaries of his liability limit Thus these subsidiary customers are linked to a main credit line of the liability customer There can be several such liability customers to whom a few subsidiary customers are linked A credit line has three basic levels of limits e Overall limit this is the maximum credit exposure that a bank is willing to take for a liability group e Main Line Limit this is typically an overall limit for a product It can be used to sub divide the overall limit by other criteria such as customer industry region and so on e Sub Line limit this is used to allocate the main line credit limit to specifics For example finances into short term long term finances Also the same customer may have different overdraft limit for different accounts This credit is always granted for a specified time period and therefore referred to as temporary To specify t
83. accrual cycle vis a vis the months For example a quarterly cycle may be March June September and December indicating that the accrual should take place in these months For a half yearly cycle you would specify June and December Indicating the day on which accruals should be done For a non daily accrual frequency the Accrual Day indicates the day of the month on which the accruals have to be carried out For example an Accrual Day of 25 indicates an automatic accrual should be done on 25 of the month as per the frequency 3 16 ORACLE 3 1 7 Accruing only on month ends If you have specified that you would like to accrue profit for accounts linked to a product in cycles of a month or more that is every month quarter six months or year you can indicate if the profit is to be accrued on the last working day of the month If you opt to accrue profit on a month end accruals will be carried out every month on the last working day of the month Normally you would want to accrue profit on month ends To accrue profit on month ends enter 31 in the Accrual Day field For months with 31 days profit will be accrued on the 31st For months with 30 days profit will be accrued on the 30th and for February profit will be accrued on the 28th or the 29th as the case may be If you enter 30 in the Accrual Day field for example profit will be accrued on the 30 of the month till the 30 For February it will be either 28 or
84. and in hand with the Positive Pay described above and Deferred Reconciliation is applicable only for Positive Pay Accounts If Positive Pay No and Deferred Reconciliation No the cheque is subjected to the usual validations and is Rejected if gt There is any discrepancy in the instrument gt There is a Stop payment instruction issued against the instrument If Positive Pay Yes and Deferred Reconciliation No Cheque is subject to the usual validations and processing If Positive Pay Yes and Deferred Reconciliation Yes and if any one or more of the three fields viz Branch Account No Cheque No does not match with the Positive Pay instruction the cheque will be put under Deferred Reconciliation as Unreconciled gt If this unreconciled cheque comes in for clearing once again with the same set of parameters it is Rejected 2 56 ORACLE gt If Positive Pay instruction is received for an unreconciled cheque it is marked Reconciled and the cheque status is marked Liquidated e f Positive Pay Yes and Deferred Reconciliation Yes and the Amount field does not match with the Positive Pay instruction the check is Rejected outright All data pertaining to reconciled and unreconciled cheques are maintained and information regarding account no cheque no amount and status of the instrument reconciled or unreconciled can be retrieved if needed An EOD batch function will purge all reconciled cheques as part of the
85. and type of rate not the numeric value will be picked up from the accounts in the same manner Also the accrual and liquidation details for the Mudarabah account class will be the same for all the accounts You can thus have all the attributes except those of User Data Elements UDEs like the rate tier structure and so on same for accounts belonging to different account classes Product Code The product code for which you are defining preferences is displayed in this field 3 14 ORACLE 3 1 6 Accrual Related Details While building a formula for the rule to which you have linked the product if you indicated that the result of the formula is profit that should be accrued the profit amount for all the accounts linked to the product will be accrued When defining the pref erences for this product you can choose to pass the accrual entries in the following manner e pass an accrual entry for each account e consolidate the profit to be accrued for individual accounts and track it against the product If you choose the latter option the cumulative value of all the accruals for accounts linked to the product will be passed as a single accounting entry Example You have defined debit profit DRIN as a product and linked it to the account class Current Money 01 Accrual entries passed for accounts linked to DRIN will be as follows Dr Profit receivable e Cr Profit Earned Since accrual accounts for a formul
86. arges module will process accounts linked to this class Track Accrued Profit If checked it indicates whether accrued profit in the Profit and Charges module on an account linked to this class would be considered while computing credit utilization for the account Debit Credit Advices If checked indicates that for all accounts belonging to this class the system will generate a debit credit advices on profit liquidation The advices are generated during end of day processing in SWIFT or and MAIL format You can also specify this preference through the Special Conditions screen Posting Allowed If checked indicates that the account class being created is to be used while creating IRA monetary accounts Monetary accounts used for IRA need to be distinguished from the other accounts in Oracle FLEXCUBE so that these accounts do not come up for posting in the other Oracle FLEXCUBE screens Lodgment Book If you wish to allow orders of lodgment books for all accounts that use this account class you can indicate so in the Islamic Account Class Maintenance screen by selecting the Lodgment Book option Replicate Customer Signature Check this box to indicate that customer signature should be replicated On checking this option the signature of the customer gets defaulted to account level Profit Calculation Balance Basis You can specify the balance basis on which all accounts under this account class should be consider
87. arter that is in the months of March June September and December You would like to liquidate profit on the 5th day of the month that is on the 5th of March the 5th of June and so on To achieve this result enter 05 in the Days field and 03 in the Months field Profit for the accounts linked to the product will be liquidated automatically according to your specifications during the end of day processing on the day the liquidation becomes due To specify ad hoc liquidation for a product enter a zero for day month and year in the liquidation frequency Ad hoc liquidation can be carried out any time on an account even if it has been defined for automatic liquidation An ad hoc liquidation of profit for an account defined for auto liquidation will liquidate profit till the date you specify when you carry out ad hoc liquidation The subsequent automatic liquidation will be for the remaining days in the liquidation period The following example illustrates this point 3 19 ORACLE Example For a product the liquidation periodicity has been defined as monthly to be carried out on the last working day of the month On 15 April you do ad hoc liquidation of profit for a few accounts linked to the product The profit for 14 days in April assuming that you specify the date of liquidation as 14 April will be liquidated during this ad hoc liquidation The next automatic liquidation of profit for all accounts involving the
88. ary statement cycle defined for the customer account The start date for Regulation D applicability is first set to be the date on which you mark the availability flag in this screen Subsequent to the first period the EOD process would update the start and end dates according to the periodicity defined If you indicate the periodicity of Regulation D applicability as Statement Cycle the restricted transactions would be counted over the primary statement cycle defined for the customer account 2 3 14 Specifying Account Status Details If you do not want the Islamic account class details to be propagated to the account as well you have the option of maintaining the status codes and the reporting lines exclusively for an account You can achieve this through the Status Details screen Click the Account Status button in the Islamic Customer Accounts Detailed screen to invoke it Status Details Branch Code Account Account Status Status Description Reporting Lines GL Lines Credit Debit Central Bank Lines Credit Debit Head Office Lines Credit Debit The details maintained for the Islamic account class will be displayed in this screen However you are allowed to make amendments to the defaulted values Here you can capture the following details Branch Code The system defaults the code of the current branch 2 79 ORACLE Account The system defaults th
89. ate on a half yearly basis that is June and December and on month ends you should specify the date of first liquidation as 30 June 1999 e Ifyou want to liquidate profit every two months that is February April June August October and December at the end of month you should specify the date of first liquidation as 29 February 1999 e Ifyou want to liquidate profit annually that is every December on 31 December you should specify the first day of liquidation as 31 December and so on The First Liquidation Date thus determines the date on which the first liquidation should be carried out for all accounts linked to a product Subsequent liquidation dates will be fixed based on this date and the frequency of liquidation Start Date The system displays the Start Date based on the First Liquidation Date and the Liquidation Frequency that you specify The Start Date that is displayed is the First Liquidation Date the Liquidation Frequency 3 20 ORACLE For example if you specified the First Liquidation Date as 31 January 2000 and the Liquidation Frequency as 1 Month the system will display the Start Date as 1 January 2000 Liquidating profit on month ends For a liquidation frequency in months or multiples of a month for example quarterly half yearly every two months and so on you can specify that liquidation has to be carried out as of the last working day of the month In this case you should specify the
90. ates the account statement details at a frequency that you specify The frequency can be e Annual 2 9 ORACLE e Semi annual e Quarterly e Monthly e Fortnightly e Weekly e Daily If you indicate that the statement generation frequency is weekly you should also indicate the day of the week on which the account statement is due Similarly for a monthly statement you should indicate the day of the month On To specify the frequency for a monthly statement you can specify a number between 1 and 31 corresponding to the system date If you set the statement date to 30 then account statements will be generated on e The last working day for months with lt 30 days e For months with 30 days on the 30th if 30th is a holiday on the next working day If you set the statement date to 31 then account statements will be generated on e The 31st for month with 31 days if 31st is a holiday on the next working day e The last working day for months lt 31 days For all other cycles account statement would be generated on the last day of that cycle Offline Limit This is the limiting amount till which transactions will be carried out between account s for the account class you are defining here between branches when the database connectivity is not functional Enter the off line limit here Note the following e Ifyou are defining primary secondary and tertiary statements the frequency for each must be different and unique
91. ation 4 4 2 Nominee Tab 4 13 ORACLE Click Nominee tab in the Islamic TD Accounts Maintenance screen The following tab will be displayed islamic TD Accounts Maintenance Branch Code Account Customer Name Currency SD User Reference Customer No Account Class Main Nominee Deposit Dual Currency Deposit Check List Nominee Details Name Guardian Name Date of Birth Relationship Address1 Address2 Address3 Relationship Address1 Address2 Address3 Address4 Address4 Minor Profit Charges Linked Entities Restrictions mls Statement Joint Holders Account Signatory TD Payout Details Change Log Maker Date Time Mod No Checker Date Time Record Status Authorization Status Specify the following details Name Specify the name of the nominee Date of Birth Specify the date of birth of the nominee Relationship Specify the relationship of the nominee with the customer Address 1 to 4 Specify the address of domicile of the nominee Four lines have been provided for this Each line can have a maximum of 105 alphanumeric characters Minor Check this box if the nominee is a minor Guardian Name If the nominee is a minor specify the name of the guardian Relationship Specify the relationship of the guardian with the minor 4 14 ORACLE Address 1 to 4 Specify the address of domicile of the guardian Four lines have been provided for this Eac
92. atus Authorization Status Positive Pay Indicate the following Positive Pay For the account you are maintaining you can specify whether you want positive pay facility for the account or not When a check comes in for payment the system validates for any unpaid record only for those accounts that are under positive pay For all the other accounts that are not specified for positive pay the system does not do any validation before making payments for the checks Funding If you enable Funding accounting entries will be posted by the Positive Pay maintenance upload table for the positive pay transaction You have to enable Positive Pay to make use of Funding functionality If Positive Pay is not enabled Funding option will not be applicable If Funding is not selected accounting entries will not be passed for positive pay transactions You cannot enable both Deferred Reconciliation and Funding functionalities You have to choose between either of them for a particular account ORACLE 2 55 Mod 9 Validation Required You can enable Mod 9 Validation for positive pay accounts only Only if positive pay enabled then Mod 9 Validation will be active In the case of inward clearing of Positive Pay files if Modulo 9 is enabled for the product the system performs a Modulo 9 Validation on any new cheque If the cheque fails modulo 9 validations the syste
93. automatically acquir Under tenor details you can specify the reference date also The system uses this date while calculating the maturity date of the deposit If you specify the reference date the system will calculate the maturity date by adding the tenor value to the reference date e this tenor However you can change the tenor to suit the requirements of a specific deposit 4 3 ORACLE 4 2 1 3 Defining Redemption Details Indicate the following preferences Profit Sharing You can opt to consider all Mudarabah deposit accounts under this account class for Mudarabah profit sharing purpose If you wish to achieve this check the option Consider for Profit Sharing Once this option is checked the profit sharing for Mudarabah deposit is done Redemption A deposit can be redeemed in two ways at maturity e Principal component alone e Principal and profit components You can choose the appropriate option from the following values displayed in the drop down list e Principal e Principal Profit For all Mudarabah deposits that are considered for profit sharing the system allows only principal redemption on the maturity date The deposits remain in the Active status till the next profit distribution date The profit is liquidated into the deposit only the next date of profit distribution Pre Redemption In case of Mudarabah deposits that are redeemed before maturity you can indicate the components that should be pa
94. ave defined specifically for the module will be displayed Choose a class with the requisite accounting heads and roles mapped 3 1 1 2 Specifying Roles Enter the following details Accounting Role If you do not use a class to define accounting role and heads for a product in this screen you can define them specifically for the product you are creating In the Accounting Roles column select an Accounting Role from the adjoining option list You can choose a role by double clicking on it Next in the Account Head column select an accounting head from the adjoining option list Click add icon to map the role with the corresponding head in the Accounting Head column If you would like to delete a role to head mapping click delete icon Account Head If you choose not to associate the product with a class you have to specify the account heads for the product in this field You can invoke a list of the accounting heads that you have maintained from the option list positioned next to this field Choose a head by double clicking on it Description A brief description of each accounting head that you choose will be provided in the Description field 3 7 ORACLE 3 1 2 Maintaining Events Events are maintained through the Events screen Click the Events button in the Islamic Profit Distribution Product Maintenance Detailed screen to invoke this screen Events Class Details Product Code Product Description
95. be done Generate Balance Report To indicate that the customer account is considered for generation of its balance message check this box Report Transaction Since This section lists all the transactions the customer account has undergone in the interval of balance messages generated for the account You can choose the appropriate values applicable e MT940 This indicates all transactions posted and authorized since the issue of a previous MT 940 in the current balance report e MT941 This indicates all transactions posted and authorized since the issue of a previous MT 941 in the current balance report Of Select the mode of message for balance generation from the adjoining drop down list This list displays the following values e Primary e Secondary e Tertiary 2 40 ORACLE 2 2 16 1 1 Time Interim Transactions Report Generation Time Generation Time Cafes me Cancel i 2 2 16 1 2 Times Balance Report Generation Time Generation Time oO Generation Time Cancel 2 41 ORACLE 2 2 17 Specifying Notice Details Notice preferences are maintained through the Notice Details screen Click the Notice button in the Islamic Account Class Maintenance screen to invoke this screen Notice Details Account Class Account Description Advance Profit Monthly Free Amount Notice Days Validity Period The following field is di
96. before the ICEOD batch is run for the branch The system will trigger the following changes on executing the batch e Status Change The status of the accounts will be changed based on the status criteria defined for the account class in the Account Class Maintenance screen to which the accounts report Refer the Core Entities User Manual for details on maintaining status criteria e Stop IC Profit and charge application will be stopped for the account if the option is checked for the new status e Reverse Accrual The accrual amount till date will be reversed if the Reverse Accrual option is enabled for the new status e Accrual transfer If the accounting heads of the new status is different from the ones maintained for the previous status then the accrual amount will be transferred to the new account heads Click the OK button to run the batch You can use the cancel button Exit to stop the execution 3 30 ORACLE 3 3 Maintaining Investment Weights In order to compute the profit distribution on a Mudarabah fund you need to capture the risk associated with every investment that forms the Mudarabah fund You can capture the risk or weight attached to every deposit investment in the Weights Maintenance screen This screen allows weights maintenance for different combinations of fund Id product type account class effective date and currency You can invoke the Weights Maintenance screen by t
97. ble accounting entries that will be passed including the movement of unclaimed deposits to the respective GLs Tax Mudarabah profit products can also be used for computing the TDS Tax Deducted at Source on the profit earned for a customer In Oracle FLEXCUBE you can compute TDS only for savings current and TD accounts However this facility is not applicable for deposits booked under the Finances If you have enabled the check box Include for TDS Calc for the Mudarabah profit product you can maintain the profit product as a Tax or Non Tax product Choose the Tax option in the Product Type to define the Mudarabah profit product as a Tax product This allows you to calculate deduct and view the TDS for the accounts belonging to this product No accounting entries are available for IACR Profit accrual since no accrual is done for the Tax products The rule for calculating the profit for TDS and booking is computed using the following two formulas Formula 1 Non Booked No accruals required TOT_INT_AMOUNT gt TDS_LIMIT PROFIT_AMOUNT TAX_RATE 3 3 ORACLE Formula 2 Booked no accruals GREATEST FORMULA1 TDS_AMOUNT 0 You have to maintain the TDS_LIMIT and TAX_RATE UDE s at the rule level for each product account class currency and effective date combination In case you have defined the Mudarabah profit product as a Tax product then the Deposit check box will be disabled In case the Tax check box is left
98. branch code is defaulted here Calculation Account Select the valid customer account number for calculation from the adjoining option list 2 67 ORACLE Profit Booking Account Select the valid customer account number from the adjoining option list Charge Booking Account Select the valid customer account number for booking the charge from the adjoining option list Profit Statement Check this box to generate the profit statement Consolidated Charge Account Select the valid account number from the adjoining option list Profit Start Date Select to indicate the effective date to generate profit from the adjoining calendar Charge Start Date Specify to indicate the effective date to generate charges from the adjoining calendar Profit Booking Branch Select to indicate valid Branch for calculating the profit from the adjoining option list Dr Cr Advices Check this box to generate debit and credit related advices Charge Booking Branch Select to indicate the valid Branch from the option list for calculating the charge Consolidated charge branch Select the valid branch from the adjoining option list Product Details You can specify product details for your account here Product Code Select the valid product code from the adjoining option list UDE Currency The system generates the user defined currency type maintained at Profit Product Preference level 2 68 ORACLE 2 3 6 Integrated LM Product Select this
99. branch list From the list of Available Branches select 001 and click the adjoining arrow Repeat the procedure for 004 001 and 004 will be listed under disallowed branches For specifying the allowed list of branches first click on allowed You will notice that the list title changes accordingly to allowed and vice versa You should select allowed or disallowed depending upon the length of the list 2 17 ORACLE 2 2 6 1 2 Maintaining Currency Preferences In this screen you can specify the following for an account class e Those branches to which all parameters defined for this account class should be available e Those currencies in which all customer accounts linked to this account class can operate For all accounts under this account class you have the option of specifying currencies in which transactions are allowed disallowed Example You want to restrict all account level transactions under the account class Corporations for corporate type accounts to four important currencies only say USD GBP JPY and DEM You can specify the same But currency preference needs to be accompanied by specifications regarding the minimum balance limit in each currency To do this click the Currency Preferences button in the Branch Currency screen to invoke Currency Preferences screen Currency Preferences Account Class Currency Preferences 10f1 jum Currency Code ATM Cash Limit ATM Transaction Limit Minimum
100. ccecccecesscessceesseceeccecuseceeccecseceeaceceaecseaeecnaeeeeaeeenaeeesaes 2 103 2 3 24 Specifying Billing Parameters Details ccccccescecessceensecesseeesseceteceessecseneeeseceeaeecsaeceeneecseeeeaeeceaeeeees 2 105 2 3 25 Specifying Account Signatory Details ccccccsccessceessecseceeesseceseceesseceeneeeaseceeeceesaeeeeeecseeeeaeeceaeenses 2 107 2 3 26 Specifying Interim Transactions Report Details cscccsccesceesceseceseeeseesseeseeeseeeseeeseeeeceeeeeeeseeeaeenss 2 109 2 3 27 Specifying Notice Details ccccccssccesscsessecesscescecesscecsnecssccecanececceeaaecssceeeaeeceeceesaeseeneeeceeceaeeesseeeses 2 111 2 3 28 Specifying Cards Details 0 2 cccesccecccesecsseesseesceeseessescesecseesecesecesecuaecaecaaecaeecaeeeaeeeseseneeeseneneenaeeaas 2 112 2 3 29 Specifying OFAC Check Details cccccccccsccesceesceesceseeescesecesecuaecnecanecaneeaeeeseeeaeeeceeeeeeeeeeeeceaeeerenenenaas 2 114 2 3 30 Specifying Change Log Detail s cccccccessccessceesesesseeessecssneeeseececeeesaecseceeeseceeneecaeeeeneecnaeeeeaeeenaeesees 2 116 2 3 31 Maintaining Provisioning Percentages Details cscccscccssseseenceenseteseeeenseceteceenseceeneeeneecenneeeeenees 2 118 2 3 32 Viewing details of Amounts and Dates 1 cssccececsseesseeseeeseesseeeseesecsecsecceeaeceseceaeceaecueeeeeeenseeenees 2 118 2 3 33 Maintaining Other Details for Islamic Deposit Account ccecceeesecesceensecetneeensecesneeenseceneecnaeeeses 2 121 2 3 34 Closin
101. ccount statements will be generated on e The 31st for month with 31 days if 31st is a holiday on the next working day e The last working day for months lt 31 days For a fortnightly statement you could specify 1 and 15 For all other cycles account statement will be generated on the last day of that cycle Generate Stat Only On Movement You can indicate that an account statement should be generated for the customer s account only when there has been a movement of funds into the account or when funds have been transferred out of the account 2 92 ORACLE For instance let us assume that on the August 21 2001 you have set the account statement generation frequency as Daily for the account LI020804 On the September 5 2001 there has been no movement of funds in the particular account If you have opted for the Generate Only on Movement option the system will not generate a statement message for September 5 2001 If you choose not to enable this option account statements will be generated regardless of whether there has been a movement of funds or not Display IBAN in Advices If you would like to print the IBAN number of the customer on advices sent to the customer you can enable the Display IBAN in Advices option by checking it This specification will be defaulted from the account class linked to the customer account You will be allowed to change it for a specific account You can choose to print the IBAN Number in advice
102. ccounts eligible for profit sharing Based on the balance basis maintained in the Account Class Maintenance screen and the transaction code wise exclusion criteria maintained in the Exclusion Transaction Count screen the system will exclude all the accounts which satisfy the Exclusion criteria You can trigger this Exclusion process through the Profit Calculation Exclusion Batch screen You can invoke the Profit Calculation Exclusion Batch screen by typing STDREXBT in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button 2 43 ORACLE 2 3 Profit Calculation Exclusion Batch Period Code Financial Year Populate Parameters ntraday Sequence Submit Batch View AM Log You can enter the following details in this screen Period Code Specify the period code for which you wish to run the batch process The adjoining option list displays all the period codes maintained in the system You can select the appropriate one Financial Year Specify the financial year for which you wish to run the batch process The adjoining option list displays all the financial year codes maintained in the system You can select the appropriate one Click the Submit Batch button to execute the batch The system will identify all accounts that are not eligible for profit sharing in the given period and finanial year and e
103. clearing batch process During the upload process validation is done against all the positive pay and the deferred reconciliation flags combinations and all Unreconciled Positive Pay Instructions are marked as Reconciled and liquidated Deferred reconciliation will be overridden by a stop payment instruction if any An error message or an override will be shown if a Cheque that comes in for clearing has a stop pay instruction against it but has no positive pay instruction Funding Account Click on the adjoining option list to choose the account into which funds have to be transferred on receipt of a positive pay instruction The accounts that satisfy the following conditions will be available in the list of Positive Pay Parking Account e Both accounts belong to the same customer e The currency of both the accounts is the same Validation Digit Validation digit will be having values only 0 and 9 If validation digit is 9 then 9 mod 9 remainder for the check number Excluding the check digit should be equal to the check digit for the check to be passed else the check is rejected The check digit is the last digits of the check that is if check number is 1800 then check digit is 0 The mod 9 remainder of the check number should be equal to the check digit for the check to be passed if validation digit in customer accounts maintenance is 0 else the check is rejected Examples Check no 1800 Check digit 0 Mod 9 remainder
104. cordingly change the status of the account The parameter you specify here will supercede the parameter you have maintained at the account class level Location An address for a customer account is based on the Location and Media combination Location codes maintained through the Account Address Location Type Maintenance screen are made available against this field The address maintained here is always the primary or the default address Each customer can have several addresses for a particular media To distinguish between one address of a customer from another for a given media it is essential for you to specify a unique location for each address Also if you are amending an address here the same gets updated in the Customer Account Address Detailed table after the validations are through Media Indicate the media for which the charge should be levied Select one of the following options from the option list e Mail e Telex e SWIFT e Fax Linked Deposit Branch This field displays the branch of the account that is linked to both the funds when the inter fund subscription happens This field is updated by the system when inter fund subscription transaction is booked Linked Deposit Account The system updates this field in case of an inter fund subscription If an Islamic deposit account is linked to a fund the system verifies if there exists a parent account for the child deposit It also verifies whe
105. culation Exclusion Batch screen by typing STDREXBT in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button Profit Calculation Exclusion Batch Period Code Financial Year Populate Parameters ntraday Sequence Submit Batch View AM Log Specify the following details Period Code Financial Year Intraday Sequence Number 3 49 ORACLE 3 8 Zakat Batch Process 3 8 1 The Zakat processing batch needs to be run for all the savings accounts for which the Zakat Exemption option is unchecked in the Customer Accounts Maintenance screen You can run this batch through the Zakat Processing Batch screen You can invoke this screen by typing ICDZAKBA in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button Zakat Processing Batch IC Product az Populate Parameters Ramadan Date Intraday Sequence Number Batch Sumit Here you can capture the following details IC Product Specify an IC product maintained for Zakat computation The adjoining option list displays all the IC products maintained in the system You can select the appropriate one from there Also you can select All and execute batch for all Zakat products You can run this batch on the First Day of Ramadan On execution of this batch process the Zakat will be aut
106. d below If you would like to associate a customer restrictions class to a product click Default From Class button in the Product Customers and Categories Restrictions screen The product acquires the restrictions defined for the class Defining Customer Restrictions specifically for a product If you do not use a class to indicate customer restrictions you should define these restrictions specifically for the product in the Product Customer Restrictions screen Restriction Types You can restrict customers from availing a product by maintaining an allowed list or a disallowed list of customer categories Only customer categories that are a part of an allowed list maintained for a product can avail the product Likewise customer categories that are part of a disallowed list cannot avail the product or service Category Code Specify the category that should be allowed disallowed for the product Customer ID Specify the customer identification number of the customer that should be allowed disallowed for the product 3 12 ORACLE Allowed You can exempt a particular customer from the restriction specified for the product in case you are maintaining a Disallowed list Choose to Allow option of the customer whom you wish to allow for the product After you maintain branch and currency restrictions for a product click Ok button to confirm your specifications Click Exit or Cancel button
107. d description will be displayed alongside Transaction Code A Transaction Code is used to identify the nature of the accounting entries posted The code selected here will be used to track the accounting entries resulting from the movement of the account to the status being maintained Stop IC You can select this option if you want the system to stop processing Profit and Charges when the account moves to the status that is being defined If not checked profit and charges will continue to be applicable on the account Reverse Accrual If you select this option all the accruals that have happened till date will be reversed when the account moves into this status Accounting Role to Account Head mapping Accounting Roles are tags that identify the type of accounting entry that is posted to an accounting head which in turn refer to the different GLs and SLs maintained in your Chart of Accounts You can select the different heads and roles to which the accruals till date would be posted when the account moves to this status Further accruals will be posted to the account heads specified here if the account heads maintained for the next status is not different from the ones specified for the current status 3 2 2 1 Status Change Processing For accounts marked with automatic status change you can execute a batch process at EOD to trigger the status movement and other associated changes Note that the status change batch should be executed
108. d here ORACLE 4 29 Exchange Rate In case the TD currency is different from the account currency the exchange rate used to convert TD currency into account currency is displayed here based on the rate maintained for the currency pair Savings Amount The amount being liquidated for the TD is displayed in the account currency Narrative Give a brief description for the transaction if required 4 5 3 General Ledger Tab If you have indicated the means of redemption as General Ledger then click the General Ledger tab on the Term Deposits Redemption Input screen Term Deposits Redemption Input Reference Number Account Number Branch Code Description Customer Id Account Amount Currency Action Flag Renewal Redemption Redemption Renewal d ion Mod Redemption Mode Next Maturity Date Redemption Amount Tenor Waive Compensation Waive Profit Days Months Redemption By Years Redemption By Savings General Ledger Bankers Cheque Bank Cheque Savings General Ledger General Ledger Number Exchange Rate Transaction Amount Transaction currency Narrative Maker Date Time Mod No Checker Date Time Record Status Authorization Status Specify the following details General Ledger Number Specify the GL into which the TD has to be liquidated The adjoining option list displays all valid GLs maintained in the system You can choose the appropriate one Exchange Rate In case the TD curre
109. dation for default settlement pick up also 2 3 19 Specifying Statement Details Preferences regarding the type of account statement detailed or summary or none at all as well as the statement frequency including whether multiple statements are to be generated are specified for the account class in the Islamic Account Class screen These details are applicable to all accounts linked to the account class While maintaining customer account details in the Islamic Customer Accounts Detailed screen these details are defaulted 2 90 ORACLE For a particular customer account you may redefine the default specification The details specified at the account level will supersede those specified for the account class To specify account level details click the Statement button The statement details table will be displayed Statement Details Primary Account Statement Display IBAN in Advices Type Account Generate Statement Only On Movement None Summary Detailed Cycle On Secondary Account Statement Generate Statement Only On Movement None Summary Detailed On Tertiary Account Statement Generate Statement Only On Movement Previous Statement Details Date Balance No Previous Statement Details Date Balance No Previous Statement Details Date Balance Statement Account Type No Exclude Same Day Reversal Transactions from Statement
110. days cannot be lesser than zero or greater than the tenor of the TD Yield Enhancement Specify the additional percentage of yield that the customer receives for agreeing on a currency Option Inception Fair Value Specify the market value of the option contract at inception This option is defaulted from the linked Options contract 4 4 5 Capturing Additional Details You can capture additional details for the TD by clicking the following buttons in the Islamic TD Accounts Maintenance screen Button Function Profit This invokes the IC Special Conditions Maintenance screen Charges This invokes the Account level charges conditions screen Linked Entities This invokes the Linked Entities screen Restrictions This invokes the Products and Transaction Codes Restriction screen MIS This invokes the Management Information System screen Statement This invokes the Statement Details screen Joint Holders This invokes the Linked Entities screen Fields This invokes the User Defined Fields screen Account This invokes the Signatory Details screen Signatory TD Payout This invokes the Term Deposit Payout Details screen Details 4 22 ORACLE Change Log This invokes the View screen 4 4 6 Specifying Profit Details To define profit and other parameters for a TD click the Profit button in the
111. dentification Specify the function ID ICPDMBT End of Cycle Group Choose End of Transaction Input 2 124 ORACLE Frequency Choose Daily from the adjoining drop down list After each profit distribution cycle you will have to take a report of accounts where Account set for closing is checked and then transfer the balance in such accounts in order to make the balance to zero for the purpose of automatic closure This batch will close all the applicable accounts after ensuring the following e Account balance is Zero e Profit distribution is done e Nomore profit is accrued In case any of the aforesaid validations fail the batch will not close the customer accounts In case of such failure the system will raise an exception 2 3 36 Generating Alert for Secure Overdraft Utilization Secure Overdraft SOD facility is given against collaterals for an account Oracle FLEXCUBE facilitates generation of alert when SOD utilization is closer towards the consolidated limit amount of the collaterals Oracle FLEXCUBE runs a batch process to identify such breached SOD accounts and generates alerts as per the maintained percentage parameter at SOD account level and decides the breach limit for every account The system sends the generated alerts as ADVICE format email or ASCII flat file It defines the message format for email and captures the following key information to send these alerts to OD customer e Email I
112. done already then the system will not display those fund Ids Click the Populate button to view the record for the combination of the data entered in the Profit Cal Update screen If there is any unauthorized record the system will not populate the record 3 6 1 2 Total Investment Here you can capture the following details PEA GL The system displays the balance of the PEA GL for the Mudarabah fund This amount is computed on the basis of the liability GL specified as PEA that is linked to the particular Mudarabah fund id in the Mudarabah Profit Calculation Maintenance screen IRR GL The system displays the balance of IRR liability GL This balance is computed based on the Profit Contribution Balance Basis specified in the Islamic Profit Calculation GL Maintenance screen 3 41 ORACLE Share Holders On selecting the Mudarabah fund id the system displays the total investment of the fund as contributed by the shareholders in this field This amount is computed on the basis of all the liability GLs that are linked to the particular Mudarabah fund id The system arrives at this amount based on the preference set in the Profit Contribution Balance Basis field in the Mudarabah Profit Calculation Maintenance screen for the selected Mudarabah Fund ID If the balance basis is not maintained for that GL in the Linkage screen the system will consider the preference set in the Mudarabah fund Share
113. e REG button to invoke the Reg Details screen where you can specify the Regulation D applicability details REG Details Reg D Applicable REG D Period Periodicity Monthly Start Date Statement Cycle End Date None Reg CC Availability You can enter the following details in this screen Reg D Applicable Indicate whether the Regulation D limits are applicable for the account Periodicity If you indicate the periodicity of Regulation D applicability as Statement Cycle the restricted transactions would be counted over the primary statement cycle defined for the customer account Reg CC Availability Check this box if the check deposits into this account should be considered for Regulation CC aggregation Indicating Reg D Period Details Start Date The start date for Regulation D applicability is first set to be the date on which you mark the availability option in this screen Subsequent to the first period the EOD process would update the start date according to the periodicity defined End Date Subsequent to the first period the EOD process would update the end date according to the periodicity defined 2 78 ORACLE You can define whether the Regulation D limits are applicable for the account and the period over which the limits would be applicable If you indicate the periodicity of Regulation D applicability as Statement Cycle the restricted transactions would be counted over the prim
114. e Customer Status Specify the applicable customer status from the drop down list The available options are e Major e Minor e Both 2 4 ORACLE e Not Applicable Note the following e By default Not applicable option would be selected when a new account class is created e Ifyou select Minor option at the CIF level and Applicable customer status as Major at the account class level then the system throws an error stating that The A c class you selected is for major customer e Similarly if you uncheck Minor option at the CIF level and select Applicable customer status as Minor at the account class level then the system throws an error stating that The A c class you selected is for minor customer Charges Specify the following details Charge Start Advice You can use this field to indicate whether a charge start advice is to be sent to the customer indicating the commencement of charging on accounts under the account class Charging on the accounts under the class would commence on the charge start date specified for the account The charge start advice would be sent a specified number of days in advance the Advice Days of the charge start date Advice Days If you have indicated that a charge start advice is to be sent to the customer indicating the commencement of charging on accounts under the account class specify the number of days before the charge start date the cha
115. e Date Cluster Identification Auto Extension Allow Prepayment Maximum Tenor Default Tenor Days Months Years Installment Frequency Days Months Years Maximum Schedule Days Days Months Years Redemption Redemption Pre Redemption If you want to allow partial redemption of TDs linked to this account class you will have to check the box Allow Partial Redemption Refer the chapter Term Deposit Maintenance in the Term Deposits User Manual for more details about this screen 2 2 12 Specifying Auto Deposit Details You can create an auto deposit in case the balance in the source account is overdrawn The auto creation of deposits is carried out as an end of day process For creating an auto deposit you have to maintain the following parameters Auto Deposits Account Class Transaction Code Currency Minimum Required Balance Cluster Identification Break Deposits First Def Rate Code Def Rate Type Sweep Mode Break Method Provide Profit On Broken Deposit 2 29 ORACLE Account Class For creating an auto deposit you have to specify an account class of the deposit The tenor and profit conditions maintained for the selected account class will be defaulted You cannot create an auto deposit if the Account class you have chosen has expired that is surpassed the end date maintained for the account class The system will log an exception in such a case
116. e account class You will be allowed to change this option for a specific account IBAN Account numbers for specific customers can be captured while defining a specific account through the IBAN Sub screen of the Islamic Customer Account Maintenance screen Interpay Check this box if you wish to interpay Natural GL The reporting of all turnovers of the particular Islamic account class will be directed to the GL that you identify as the natural GL Based on the characteristic of the account balance you can specify whether the turnover is to be posted to the Debit GL or to the Credit GL For instance if the account class is for overdrafts the balance is normally a debit whereas current accounts normally do not have a debit balance Dormancy Parameters As stated above if transaction code associated with the account has the Consider for Account Activity option enabled the dormant status of the account will be updated to Active Apart from this you can specify the parameter that is required for re activating the account To indicate the re activation parameters for the dormant account choose any from the following options e Debit e Credit e Any e Manual In case of a transaction the system will check for the parameter you have specified here and accordingly change the status of the account However the parameter maintained at the account level will supercede the parameter you have specified here Applicabl
117. e account number from the main screen Status You can select the different status codes applicable to the account class in this field Use the Add icon to define each status and the attributes for the same You can use the navigation icons to move from one status to the other On selection of the status the associated description will be displayed alongside Specifying Reporting Line Debit and Credit GL Line Select the debit GL account to which all debit balances within a specific account class will report to when it moves to the status being defined You can identify the debit GL from the list of existing GLs Likewise all credits within a particular account class will report to the GL account that you have identified to track credits Central Bank Line Debit Specify the Central Bank line to which this account will report to if it is in debit This line is maintained in the Reporting Lines Maintenance screen Credit Specify the Central Bank line to which this account will report to if it is in credit This central bank line is maintained in the Reporting Lines Maintenance screen Head Office Line Debit Specify the Debit Head Office GL to which the account will report if they are in a debit Credit Specify the Credit Head Office GL to which this account will report if it is running in credit 2 3 15 Specifying Restrictions Details You can place restrictions on transactions involving customer accounts b
118. e allowed to modify this code However while defining the Account Mask in the Account Parameters section of the Bank wide Parameters screen if you have specified that the CIF Number should not be a part of the account mask you will have to specify the customer code manually A list of all the valid customer codes is displayed in the available option list You can select the appropriate Customer Name On entering the Customer No the customer name is automatically displayed Account Class In Oracle FLEXCUBE you can classify the customer accounts of your bank into different groups Each group is referred to as an account class and is maintained in the Account Class Maintenance screen For each class you have to define certain common attributes applicable to all accounts in the particular class While maintaining a specific account you have to identify the class to which the particular account belongs You can select the appropriate account class from the list of all the valid account classes maintained in the system Account classes that have surpassed their end date expired will not be displayed in the option list Details maintained in this screen are classified into four tabs Main Here you maintain the main attributes of the TD like the account number customer code the account class account currency type of account single or joint account status etc Nominee Here you can capture nominee details for the TD Dep
119. e incremented The counter will be reset at End of Day Year to Date Statement Count Specify the count of interim statement generated for the account since start of the financial year The financial year will be as defined in the Accounting Period maintenance This counter would be set at the end of year Generate Balance Report To indicate that the customer account is considered for generation of its balance message check this box Of Select the mode of message for balance generation from the option list Report Transaction Since This section lists all the transactions the customer account has undergone in the interval of balance messages generated for the account You can choose the appropriate values applicable e Previous MT940 This indicates all transactions posted and authorized since the issue of a previous MT 940 in the current balance report e Previous MT941 This indicates all transactions posted and authorized since the issue of a previous MT 941 in the current balance report e Previous MT950 This indicates all transactions posted and authorized since the issue of a previous MT 950 in the current balance report 2 110 ORACLE You can synchronize the time instance by hours for generation of the balance message by clicking the Times button Account Report Gen Time 1of1 _ oO Time This screen is employed to indicate the the time instance in hours for the generation of the
120. e method for initial funding during account creation Choose one of the following options e Pay In By Account e Pay In By GL Percentage Indicates the percentage of the amount to be deposited Amount Specify the amount being deposited to open a customer account 4 17 ORACLE Offset Branch The system populates the branch code of the account from which fund is transferred to TD account Offset Account Specify the account number GL from which the fund is transferred to TD account This field returns the branch code if the account is selected and NULL is returned if GL is selected If it is Pay In mode in GL then the system displays only GL s and if the Pay In mode is Account then only accounts are displayed in the option list islamic TD Accounts Maintenance x 1of1 Term Deposit Payout Details Ee C PayoutType Percentage OffsetBranch OffsetAccount Narrative Recurring Deposit Installment Frequency Auto Payment TakeDown Move funds on Overdraft Move Maturities to Days Unclaimed Months Payment Branch Years Payment Accounts Installment Amount Recurring Deposit Account Payment Date Payment Currency lt j Linked Entities Statement f Joint Holders Account Signatory TD Payout Details Change Log Maker Date Time Mod No Record Status Checker Date Time Authorization Status Recurring Deposit Specify the following details Auto Payment Take Down Check this field to allow the recurring d
121. e product that you are creating In the Slogan field enter a slogan that suitably announces the product to your customers Product Group Specify a valid product group to which you wish to assign the product The adjoining option list displays all valid product groups maintained in the system You can select the appropriate one Products can be categorized into groups based on the common elements that they share Associating a product with a group will facilitate retrieval of information of a class of products at one stroke Start Date When you create a product you must also specify a date from which it can be used This date is called the product Start Date The start and end dates of a product come in handy when you are defining a product for a scheme which is open for a specific period End Date Indicate an expiry date for a product that you create The expiry date is referred to as the product end date You cannot use a product beyond the specified expiry date ror If you do not specify an End Date the product can be used until it is closed Remarks Enter information about the product intended for your bank s internal reference in this screen This information will not be printed on any correspondence with the customer 3 2 ORACLE The remarks are displayed when the details of the profit or Charge product is displayed or printed Include For TDS Calc Additionally you have the option to specify whether the
122. e special conditions for an account the restrictions defined for the Account Class to which the account belongs will NOT apply to this account If you wish to continue with the account class restrictions opt for Special Condition Not Applicable Restriction Type Specify the restriction type here The options available are 2 82 ORACLE e Allowed If you select this the products entered in the multi entry block will be allowed for that customer account e Disallowed If you select this option the products entered in the multi entry block will be disallowed Product Code You can select the products and specify the type of transaction Dr Cr or both that you would like to allow disallow for each product In contracts involving the selected products the accounts would be used for processing the selected type of transaction For instance assume that for the account A1 you have allowed Dr for the product ABCD This would mean that if a Dr entry for the product ABCD is passed to the account A1 it would go through but in case a Cr entry is passed for this product then the system will display a message indicating that the transaction is restricted for the account Description The system displays the description for the product code that which you have specified Dr During transaction processing the system will validate whether any restrictions are placed on the account based on either product and or transac
123. e top right corner of the Application tool bar and click the adjoining arrow button 15 0 Authorization Status Record Status Reference Number E Account Number E Branch Code E Customer Id Action Flag Redemption By Redemption Mode Redemption Amount ail 14 4 1 OF 1 gt py lemme Authorization Status Record Status Reference Number Account Number Branch Code Customer Id Action Flag Redemption KA You can query on records based on any one or all of the following criteria Click Authorization Status Record Status Reference Number Account Number Branch Code Customer Id Action Flag Redemption By Redemption Mode Redemption Amount Search button The system identifies all records satisfying the specified criteria and displays the following details for each one of them Authorization Status Record Status 4 33 ORACLE 4 7 e Reference Number e Branch Code e Account Number e Customer Id e Action Flag e Redemption By Redeeming TD partially On partial redemption of a TD the system credits the redemption amount to the customer payout account and debits it from the TD account It recalculates the tenor for the redemption amount i e completed tenor from the TD value date till the partial redemption date in months This indicates the reduced tenor It also recalculates the profit for the previous periods including the curren
124. eases to be effective Temp OD Start The start and end dates represent the dates from which the temporary overdraft limit becomes effective upto the date on which it should ceases to be effective Credit Line You can indicate the credit line to which you would like to link the customer to A list of all the credit line codes maintained in the system will be displayed in the option list You can select the appropriate Netting Required To process linked accounts which are marked for referral you will need to enable the Netting Required option This option is defaulted from the Credit Line associated with the customer account If you change the default option the system displays an override message 2 98 ORACLE Temp OD Limit The temporary OD limit is the limit upto which any overdraft is allowed for a specified time period over and above the limit set for this account This limit is independent of any credit line linked to this account This is mostly used for short term overdrawing Sublimit The sub limit represents that portion of the total credit amount that can be used by this customer account The sub limit need be input only when the account is to be limited to a portion of the available line amount While passing transactions to an account with a sub limit the first credit check made is against this sub limit amount If the sub limit is crossed you will be asked for an override Uncoll Funds Limit The uncoll
125. ected funds limit represents the credit transaction amounts that have not been collected as of the current day You can set the limit upto which withdrawal is allowed against uncollected funds The uncollected opening balance is reset with the current uncollected balance amount during the EOD process This amount is to be considered when calculating Central Limit availability Offline Limit This is the limiting amount till which transactions will be carried out between account s for the account class you are defining here between branches when the database connectivity is not functional Daylight Limit The daylight limit is the limit up to which an overdraft is allowed for the business day The daylight limit will be added to temporary overdraft to calculate the available balance if EOD is not in progress Daylight limit is not considered during EOD You can specify the daylight limit only if Daylight Limit option is checked in linked Account Class Preferences screen By default the system will display the value as zero You can however change it SOD Notification Specify the consolidated percentage utilization used for notification of the limit breach under the SOD 2 99 ORACLE 2 3 21 For more information on SOD Alert Generation refer topic Generating Alert for SOD Utilization later in this chapter Cr Transaction Limit The limit for credit transactions in the account currency When a transaction
126. ed as the sum of credit debit current balances in a period divided by the number of days of credit debit balance during the period gt Credit and debit days The number of days the account was in credit debit balance in the period gt Credit and Debit Turnover The credit debit turnover for the period gt Excess days in debit balance The number of days in a month when the account exceeded the overdraft limits gt Overdraft Limit This is computed by summing the temporary overdraft limit and the sub limit of the account For each month this would represent the limit on the last date of the month gt Credit grade of the Customer This would be the prevalent rating on the last day of the period For the current period this information is provided up to the previous working day To enable printing of this information for all accounts using the account class you must enable the Account Statistics option in the Islamic Account Class Maintenance screen For each account class for which account statistics has been enabled an accounting End of Day EOD process updates the statistics table both period wise and according to financial years The book dated balances are used for computation of statistics and the balances are maintained according to accounting periods For information about viewing the period wise account statistics refer the section Querying on Account Statistics found earlier in this chapter
127. ed for Mudarabah profit sharing You can choose the appropriate option from the following values available in the drop down list adjoining the field Profit Contribution Balance Basis gt Monthly Average Balance This option indicates that the system will check whether or not the average balance in every account under this account class is equal to or greater than the minimum balance for profit sharing gt Month End Balance This option indicates that the system will check whether or not the balance on the last day of the month in every account under this account class is equal to or greater than the minimum balance for profit sharing gt Dly Net Balance amp Avg Balance This method of calculation is similar to the average balance calculation as explained above with the only difference that whenever the day end balance of an account falls below the minimum balance Not the Minimum balance maintained for profit Sharing stipulated for the account the contribution of 2 24 ORACLE that days balance will be taken as zero while doing summation for the month System will not check the Balance arrived from the above method with the Minimum balance maintained for Profit Sharing gt Min Balance This option indicates that the system will check whether or not the lowest ever balance in every account under this account class is equal to or greater than the minimum balance for Profit Sharing Based on the balance basis
128. ed to mandatorily specify this product if the Linked Currency is entered You will be allowed to capture this value here only if the option Dual CCY Deposit is checked at the Account Class Maintenance screen You will be allowed to modify this value even after authorization On saving the account system validates the following to ensure that the currency option product selected here has the below features e Contract type is Trade e Option Type is Call e Deal Type is Buy e Option Style is Plain Vanilla e Barrier is not allowed e Delivery type is Physical e Expiration Style is American Option Contract Ref No Specify the option contract reference number Exchange Rate Specify the exchange rate of the currency Linked Currency Settlement A c Specify the settlement account of the linked CCY Alternatively you can also select the settlement account from the adjoining option list This settlement account is used if the settlement has to take place in the Linked CCY at maturity Linked Currency GL Specify the GL used for posting the settlement entries in the linked currency The adjoining option list displays all valid GLs maintained in the system You can select the appropriate one 4 21 ORACLE Fixing Days Specify the number of days from TD maturity date before which the exchange rate has to be fixed This will be defaulted from the Account Class Maintenance screen However you change it Note that fixing
129. emature redemption either in full or in part and also complete redemption on maturity of the deposit This screen also allows you to renew the TD However renewal of the TD is enabled only if you have specified Grace period for Renewal option for the account You can do this by accessing the TD Redemption screen You can invoke the Term Deposits Redemption Input screen by typing IADREDMN in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button Term Deposits Redemption Input Reference Number Account Number Branch Code Description Customer Id Account Amount Currency Action Flag Renewal Redemption Renewal on Mod Redemption Mode Next Maturity Date Redemption Amount Waive Compensation Tenor Waive Profit Days Months Redemption By Years Redemption By Savings General Ledger Bankers Cheque Bank Cheque Savings General Ledger Cheque Details Bank Code Cheque Date Cheque Currency Cheque Amount Exchange Rate Beneficiary Details Beneficiary Name Passport Number Narrative Address Maker Date Time Mod No Checker Date Time Record Status Authorization Status You have to specify the following fields for redeeming the TD Reference Number The system displays the reference number here ror This field will be enabled only for the query mode Branch Specify the branch where the TD resides The adjoining optio
130. ence here This feature is applicable only for the customer account legs and not for the related GL legs Also reversals made through the DE module will not be considered for exclusion This specification is defaulted from the account class linked to the account You can change it for a specific account Statement Account A customer may have two or more accounts with your bank but may desire to receive a single consolidated account statement Oracle FLEXCUBE allows you to link accounts For the particular account whose statement preferences you are defining you can indicate the parent account to which the account should be linked for statement generation purposes The statement account is applicable for all type of account statements Primary Secondary and Tertiary If the statement account has been specified you cannot enter other statement details 2 96 ORACLE 2 3 20 If the statement account is not specified for a particular account then the account can be a statement account for other accounts If statement accounts have been maintained during EOD the account statement will not be individually generated for the child accounts Instead a consolidated account statement would be generated based on the frequency specified for the parent account While closing a parent account a message will be shown requesting removal of the parent child account linkage Even while generating ad hoc statements you can indicate whether linked
131. ency as Daily for the account LI020804 On September 5 2001 there has been no movement of funds in the particular account If you have opted for the Generate Only on Movement option the system will not generate a statement message for September 5 2001 If you choose not to enable this option account statements will be generated regardless of whether there has been a movement of funds or not Tertiary A c Statement This refers to the type of statement to be generated periodically by the system for this account You can specify whether you want a detailed or summary statement or if you do not want a statement for this account at all Cycle You can specify the frequency for generating the account statements To specify the frequency of the statements click on the adjoining drop down list The following list is displayed e Annual e Semi annual e Quarterly e Monthly e Fortnightly e Weekly e Daily On For a weekly statement you specify the day of the week on which account statements should be generated and for fortnightly and monthly statements the dates of the month To specify for weekly statements click on the adjoining drop down list The following list of days will be displayed e Monday e Tuesday e Wednesday e Thursday e Friday e Saturday e Sunday To specify for monthly statements enter a number between 1 and 31 corresponding to the system date 2 95 ORACLE If you set the statement date to 30 the
132. eporting lines for each status may be defined in the Status Details screen Click the GL Lines button in the Islamic Account Class Maintenance screen to invoke it Account Class Description Status Description Rebook Provisioning on Status Change Debit Reporting Lines Credit Reporting Lines Debit Credit Status Details 10f1 a 2 31 ORACLE You can specify the following details in this screen Status You can select the different status codes applicable to the account class in this field Use the Add icon to define each status and the attributes for the same You can use the navigation icons to move from one status to the other Only status codes with status type Account will be available in the option list if the Status Processing Basis is defined as Contract Account for all branches in the Branch Parameters If the Status Processing Basis is defined as Group CIF level for any branch then the statuses of type Both are available In this case it is mandatory to link all the statuses defined On selection of the status the associated description will be displayed alongside Specifying Reporting line Details You can enter the following details Dr and Cr GL Lines Select the debit GL account to which all debit balances within a specific account class will report to when it moves to the status being defined You can identify the debit GL from the list of existing GLs L
133. eposit account to debit the payment account for the payment amount as per the installment frequency Move Maturities to Unclaimed Check this field to move all the funds on the maturity date to the unclaimed GL mapped to the accounting role in the IC product Payment Branch Specify the details for the branch to which the payment account belongs 4 18 ORACLE Payment Accounts Specify the Payment Account this can be either savings account or the current account from which the installment for the Recurring Deposit is collected as per the installment frequency Installment Amount Specify the installment amount that has to be collected from the payment account as per the installment frequency This installment amount should be greater than the minimum amount mentioned at the account class Recurring Deposit Account Check this field to indicate recurring deposit account Payment Date Specify the date on which the payment needs to be done for recurring deposit account Payment Currency Specify currency of the payment amount Note the following e The system enables the offset account and branch detail fields only if the option to pay is selected as the savings account e The Unclaimed Profit and Principal GLs are specified while maintaining an Profit and Charges IC Deposit Type product The Accounting Roles for the GLs are INT _UNCLAIMED and PRN_UNCLAIMED respectively When maintaining an IC Deposit type p
134. erest and Charges Rate Input screen by typing ICDRATES in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button interest amp Charges Rate Input Currency Code Branch Code Rate Code Rates Effective Date oO E Input By Authorized By Modification Authorized Ext Date Time Date Time Number Open These rates are picked up by the TD module while processing profit applicable on a TD account Refer the chapter Floating Rate Codes for IC Module for details about rate maintenance 5 8 ORACLE 6 1 6 Screen Glossary Function ID List The following table lists the function id and the function description of the screens covered as part of this User Manual Function ID Function Description EIDMANPR Mandatory Batch Program Maintenance IADACCLS Islamic Account Class Maintenance IADCUSAC Islamic Customer Accounts Detailed IADCUSTD Islamic TD Accounts Maintenance IADPRMNT Islamic Profit Distribution Product Maintenance Detailed IADREDMN Term Deposits Redemption Input IASREDMN Term Deposits Redemption Summary ICDPRABT Profit Distribution Batch ICDPRCBT Profit Calc Batch ICDPRUPD Profit Calc Update ICDRATES Interest amp Charges Rate Input ICDRESTR IC Branch Availability Maintenance ICDUDVAL User Data Element Maintenance I
135. esceseessesesasesecsceseesseaeesecsceeecsaeeasesesaceseeseseneeaeeneeas 2 13 2 2 4 Specifying Restrictions Details cccccccesccesceseceseeseesseeeeeeeceeeeeeceseceseeeeeeeceaeceseceaecsaecaaecseeeaeeeaeeenees 2 13 2 2 5 Maintaining exclusion criteria for Profit sharing c ccccsccesecete cee ene tesecseeaceeeeeeeceeeeeeeeneeeseenaeenaeenes 2 15 2 2 6 Specifying Branch Currency Restriction Details cccccccccecceesceeseescesscesecesecuseceeeaeeeseeeseeeeseeeeeaees 2 16 2 2 7 Specifying Customers Categories Details ccccccccesceesseessesseesscesscesecesecnseceaecaeceaecaaecsaeeseeeaeeeseeenees 2 18 2 2 8 Speci Ving MIS Detail ssc sevcsd cesiseistas de vieshacsedeleetovsradgesyies A E a davtesendeiasts 2 21 2 2 9 Specifying Preferences Details ccccccesccescesecssecnseeseeeseeeseeeeeeseceeceaeceeceseeesesesecaecsaecsaecaeseaeseaeeeaees 2 22 22 40 Specifying REG Details sisino a a E E aai 2 27 2241 Specifying Deposit Details snini aaia E E aai 2 28 2 2 12 Specifying Auto Deposit Details cecccecccescceccescceseceecnsecnseeseeeseeeseeeeeeseeeseeeeeesecsaesuaececeaesnaeeaeeaaeens 2 29 2 213 Specifying GL Lines Details ssssirssiniansinan aaa a 2 31 2 2 14 Specifying Status Rule Details cccecccesccescessesscesecesecesecceeseeeseeeseeceeeseeesecesesesecesecaecnaseasenaeenaeeaaeees 2 33 2 2 15 Specifying Amount Block Details ccceccceccesccescesecesecssecnseeaeeeseeeseeeeeeseeeseeeeceseceaecneceaeseaesnaeenaeeaaeea
136. eters tab in the Islamic Accounts Class Maintenance screen The fields in the Statement Parameters section are as follows Account Class Maintenance Account Class Start Date Description End Date Account Type Account Details Statement Parameters Primary Account Statement Parameters Secondary Account Statement Parameters Type None Type None Summary Summary Detailed Detailed Cycle On Offline Limit Tertiary Account Statement Parameters Document List Type None 10f1 Summary mi Document Type Customer Type Mang Detailed aesiicons rancnicurrency Resticton Customers Categories Wis Preterences RES Depost avo venosi ot tines sia Rule amt ocx Sateen ronce res Maker Date Time Mod No Checker Date Time Record Status Authorization Status Specify the following details Primary Account Statement Parameters Indicate the following details Type The first preference that you specify for Islamic account class is to indicate whether the periodic generation an account statement is required If the generation of an account statement is necessary you have to specify the format in which it is to be generated The options available are e None e Detailed indicating that the statement should be a detailed account of all the customer transactions within the account class e Summary indicating that only a summary of the transaction details is enough Cycle The system gener
137. evel will be displayed here When you define transaction code or product restriction attributes for an account itself rather than for the account class to which it belongs it is referred to as a Special Condition You can apply special conditions by selecting the option Special Condition Applicable at the account level If you opt to define special conditions for an account the restrictions defined for the Account Class to which the account belongs will NOT apply to this account If you wish to continue with the account class restrictions opt for Special Condition Not Applicable Restriction Type Specify the restriction type here The options available are e Allowed If you select this the products entered in the multi entry block will be allowed for that customer account e Disallowed If you select this option the products entered in the multi entry block will be disallowed Transaction Code Likewise you can maintain restrictions for transaction codes as well Description The system displays the description for the transaction code that you have specified Dr During transaction processing the system will validate whether any restrictions are placed on the account based on either product and or transaction code If you have indicated to allow debit transactions for the product ABCD and attempt to post a credit entry the system will seek an override You can continue the transaction despite the restrictions
138. evsscesiacsnsereavsnssteveesvevesterecvbsteatevouseuensersetenvosdeteeteaiee 5 6 5 3 3 TAX_RATE TD with Rate Chart Allowed vicccccccccccccccsccsccccssssssscccccecsesssssscsssccsesssssessscecsesesscssecsseeessseass 5 6 5 3 4 Recurring deposit Scheme ccsccscesccssssscssessseseesseeceesecsecscesecsseeeeeseesessecseesecseeeeeeaseeesaeeseeseseaeeeseaseneeaees 5 6 5 4 IC RATES MAINTENANCE ccssescccceceesessececececeesenseaececececeesaaececececeeseaaeeeeececseseaaeseseeeceeseuaaeceeseeeeeseaaeaeeees 5 7 6 SCREEN GLOSSARY cisisscccsesscvscvssvssse esnsssensicesseveseceenvaveessdosteesescsdeuesdsesenegesavenssdseseeacechseussSeissccavesvesdsseseosseete 6 1 6 1 FUNCTION TID LIST x2 s ssscacesdeccssdhuesieeesiveessseaccencesevecvs ooeeteeoessusouacaces cgoss E a EEEE ESR 6 1 ORACLE 1 About This Manual 1 1 Introduction This manual is designed to help you quickly acquaint yourself with the Islamic Accounts module of Oracle FLEXCUBE It provides information on creating Islamic accounts in Oracle FLEXCUBE You can obtain information specific to a particular field by placing the cursor on the relevant field and striking lt F1 gt on the keyboard 1 2 Audience This manual is intended for the following User User Roles Role Function Back office managers officers Authorization functions Product Managers Product definition and authorization End of day operators Processing during end of day beginning of day Financial Contro
139. exceeds this limit an override is displayed The override requires a dual authorization to save the transaction Credit Start Date This is the date from which this monitoring comes into effect The check will be performed for all entries to customer accounts with transaction booking date greater than or equal to the start date Credit Rev Date This is the date on which you would wish to revise this limit The limit check will continue irrespective of the date maintained here The revision date must be greater than the start date and can be left blank Specifying TOD Renewal Details Renew TOD Check this box if you want to renew TOD Renew Frequency Specify the renew frequency from the drop down list The available options are e Days e Month Renew Units Specify the renew units The following validations need to be done for the frequency e If Renew Frequency chosen is Days then Renew Units cannot be greater than 366 e If Renew Frequency chosen is Month then Renew Units cannot be greater than 12 Next Renewal Limit Specify the TOD amount that can be renewed in next cycle Specifying Joint Holders Details For a joint account type of customer account you need to specify details of the other joint holders of the account Click the Joint Holders button to display the joint account holder s screen 2 100 ORACLE In this screen you maintain the following for a joint account e
140. f the extended tenure 4 2 1 1 Defining Specifications for Unclaimed Deposits On the maturity date of a deposit you can opt to 1 Liquidate the deposit 2 Rollover the deposit 3 Move it to an unclaimed GL Profit for the term deposits liquidated during the specified schedules is handled in two ways e Ifa customer account has been specified profit is moved to the account during each liquidation event e You can opt to move the profit to an Unclaimed profit GL When claimed the profit can be paid out of this GL Similarly on maturity the principal can be moved to specified Principal Liquidation Account if specified or to an Unclaimed Principal GL Note the following e f you select the Move to Unclaimed GL option this specification takes precedence That is on maturity the funds will be moved directly to the respective Unclaimed GLs even if customer accounts for the principal and profit have been maintained e The Unclaimed profit and Principal GLs are specified while maintaining an profit and Charges IC Deposit Type product The Accounting Roles for the GLs are INT_UNCLAIMED and PRN_UNCLAIMED respectively When maintaining an C Deposit type product you have to map these Accounting Roles to the appropriate GLs maintained at your bank 4 2 1 2 Specifying Default Tenor You can define a tenor for the deposits that are opened under an account class Deposits opened under the account class will
141. f the tier structure as UDEs The UDE Currency will determine the currency of the limits when they are applied on the accounts If the UDE Currency is specified as Account Currency the upper limits of the tier structure will be taken to be in the currency of the account when it is applied Thus for Smart Save accounts in USD the upper limits will be taken to be in USD while that for accounts in Pound Sterling they will be taken to be in Pound Sterling On the other hand if the UDE currency is specified as local currency the tier limits will be converted to the account currency for foreign currency accounts before they are applied on an account If the UDE currency is defined as local and the product is applied on an account in a foreign currency all the Amount type UDEs will be converted to the account currency before it is used for profit application This currency conversion will be done at the day s rates between the two currencies The values of the UDEs have to be specified in the UDE Values screen for the Account Class or account itself and currency combination to which you link the product The linking of accounts to a product and the specification of UDE values are discussed in subsequent chapters The Customer Credit Rating field at the Customer level will be used as a SDE CUSTOMER_CREDIT_RATING for defining status change rules This will also be available for provision rule definition at the IA product level Spl Condn
142. fine the special conditions Specifying Product Details Specify the following details Product The system defaults a product when you click the Default button at the time of account creation You must modify it to identify the Charge product using which the applicable charges would be collected Currency The charges would be collected in the currency defined for the selected charge product and this currency is displayed on the screen Minimum and Maximum You must indicate the charge amount range representing the minimum and maximum charge that can be applied for the account Free Items You must indicate the number of free items for which the customer will not be charged Open By default each charge consolidation charge set up that you set up is enabled and active You can also disable the set up by checking the Open box If the account is marked for closure you will have to uncheck this box Waive Charges You can choose to waive charges for an account 2 70 ORACLE 2 3 7 Specifying Consolidated Charges Details Consolidated Charges are maintained through the Account level Consolidated Charges Condition screen Click the Consolidated Charges button in the Islamic Customer Accounts Detailed screen to invoke this screen Account Level Consolidated Charges Conditions Account Details Branch Code Account Product Details Product Code Currency Waive Charges
143. for use in any inherently dangerous applications including applications that may create a risk of personal injury If you use this software or hardware in dangerous applications then you shall be responsible to take all appropriate failsafe backup redundancy and other measures to ensure its safe use Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws Except as expressly permitted in your license agreement or allowed by law you may not use copy reproduce translate broadcast modify license transmit distribute exhibit perform publish or display any part in any form or by any means Reverse engineering disassembly or decompilation of this software unless required by law for interoperability is prohibited The information contained herein is subject to change without notice and is not warranted to be error free If you find any errors please report them to us in writing This software or hardware and documentation may provide access to or information on content products and services from third parties Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third party content products and services O
144. fy the customer account the system checks whether the account class used by the specified account is restricted for the product that has been selected or the debit credit transaction type If so an override is sought when such contracts are saved 2 2 5 Maintaining exclusion criteria for profit sharing You can specify the allowed transaction count for accounts in the account class to be considered for the profit sharing process and also you need to specify the threshold count for every allowed transaction code maintained for the Account Class In case the transaction count for certain accounts exceeds the stipulated count then such accounts will not be considered for the purpose of profit contribution and sharing 2 15 ORACLE Click on Exclusion Criteria For Profit Sharing button in the Account Class Product and Transaction Codes Maintenance screen to invoke Exclusion Criteria For Profit Sharing screen Exclusion Criteria For Profit Sharing Account Class Profit Sharing 11 Here you specify the count threshold for every transaction code maintained in the system 2 2 6 Specifying Branch Currency Restriction Details In addition to what you have specified in the Islamic Account Class Maintenance screen you have the option of specifying the following for the accounts class e List of allowed or disallowed branches and allowed or disallowed currencies e List of allowed and disallowed customer
145. g AISIAMIC ACCOUNT ciissiiestiiriacisseisadsiaencda eis Geacesat anaes sbeci inasdebi di sdacctduaduscaeussiesbasecbscdeuesoenstts 2 122 2 3 35 Executing Automatic Closure Batch c ccccccccesccesecsseesseesseeseesseeeseesscesecusecaecaaecaaecaeesseeeseeeseeaneneeenaees 2 124 2 3 36 Generating Alert for Secure Overdraft Utilization cccccccccceecceesceeseeeecesecnsecsecacecseeeseenseestenseennees 2 125 CREATING AN ISLAMIC PROFIT DISTRIBUTION PRODUCT ccssssscesssssscesssccscssscccssssscesssees 3 1 3 1 INTRODUCTION ccccssssssccccecsesssececececeeseueseceeeceeseseaeseeececeeaaeseeececseneaaeeesececeesesaeaecececeeseuaaeceeececeesesaeseeecs 3 1 3 1 1 Maintaining Accounting Roles ccccsccescceseesseeseeeenseeseeseeeseeeceeseeeseeesecesecaecaaecaaecaeeeseeeseeeaseaeeeneeeaees 3 6 3 1 2 Maimt mnine EVENIS siinsesse nenie aae i ep eia i aa se ts vabinu ss ti 3 8 3 1 3 Maintaining Branch details cccccecceccesesssesscssesecssesseeseeseesecacesecsseesesaeeseesecseeseesaeeeesaeeaeeeeeaeeaeeaeseeeeaeeaes 3 9 3 1 4 Maintaining Customer Restrictions s esssssessesseseeeeeresrsreesrsresrererrresrsreesrreentessesreereserrreserrreesrentset 3 10 313 Defining Preferences for Mudarabah Profit Products cc ccccscscssesssesserseseesecseeecuceenenseeeeeseeaeesecnaeees 3 13 3 1 6 Accrual Related Details 2 cacccsisesincsnaeeliseneesde a a a e a i E ie a 3 15 3 1 7 Specifying the Payment Method siiente E e a a 3 17 3 1 8 Identifying the Suspen
146. g day for months with lt 30 days e For months with 30 days on the 30th if 30th is a holiday on the next working day If you set the statement date to 31 then account statements will be generated on e The 31st for month with 31 days if 31st is a holiday on the next working day e The last working day for months lt 31 days For all other cycles account statement would be generated on the last day of that cycle 2 11 ORACLE Secondary Account Statement Parameters Indicate the following details Type The first preference that you specify for Islamic account class is to indicate whether the periodic generation an account statement is required If the generation of an account statement is necessary you have to specify the format in which it is to be generated The options available are e None e Detailed indicating that the statement should be a detailed account of all the customer transactions within the account class e Summary indicating that only a summary of the transaction details is enough Cycle The system generates the account statement details at a frequency that you specify The frequency can be e Annual e Semi annual e Quarterly e Monthly e Fortnightly e Weekly e Daily If you indicate that the statement generation frequency is weekly you should also indicate the day of the week on which the account statement is due Similarly for a monthly statement you should indicate the day of the month
147. g in Core Entities User Manual 2 123 ORACLE 2 3 35 Executing Automatic Closure Batch You can have all accounts for which the box Account set for closing is checked automatically closed using a batch process after the profit distribution is completed You need to configure this batch as a mandatory program in End of transaction Input EOTI stage using the Mandatory Batch Program Maintenance screen You can also configure it as an intraday batch You can invoke the Mandatory Batch Program Maintenance screen by typing EIDMANPR in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button Mandatory Batch Program Maintenance Branch Function Id Module az Sequence Number Description End Of Cycle Group Txn Input Error Handling Stop Automatic End Of Day End of Txn Input and Run Emergency Program End of Fin Input Continue with Automatic End of Day End Of Day Beginning of Day Frequency Daily r Number Of Days Holiday Rule Do Not Execute Run Date Job Code Description Execution Layer Database Application Sub Stage 4 N Predecessors IE Predecessors o Input By Authorized By Modification Authorized Date Time Date Time Number Open This batch should be configured for execution after ICEOD batch Function I
148. gesececeusaavoosecseeesss 3 40 3 7 PROFIT CALCULATION EXCLUSION BATCH sssscsssccccessssscacccececsensnsecccecscesnsauecsecscesssancecsecscessesseeseeeecs 3 49 3 8 ZiAKAT BATCH PROGESS E E EEE E E EE E ied saat opacuees cegesscacadeeweusddvondeces 3 50 3 8 1 Status Change Batch Processing CSDSTBTC cccccssssssesssesseesecesecnseceaecaecaeeeaeeesseeeeeseeeeeeeaees 3 50 CREATING ISLAMIC TERM DEPOSITS sssscssssssscsssscccessscccssssccsessssccscsscescesnscescssseccsssseccessececessnees 4 1 4 1 DOAN D 0 05 Y COIN PEPEE 4 1 4 2 MAINTAINING TERM DEPOSIT ACCOUNT CLASS ccccccccccecsssssececececeesssececececeessaeeeeececseneseaeceesesesessaeaeeecs 4 1 4 2 1 Specifying Deposit Preferences cccsccesccesecsseesseesseeseesseeeseeecesecaecuaecaaecaaecaaeeseeeaeeseseeeeeeeeeeeeeeeeneenaes 4 2 4 2 2 Specifying the Auto Deposits ssssessssesesseeessereesseesreresresrrresesressesreerssrsteesttesesteeresrenrnsestsseeerensesreets 4 4 4 3 SETTING UP PROFIT PREFERENCES FOR TD ccccccccccecsesssececececsessaececececsesssaesecececeeseaeseceeeceesennsaeeeeeeeenes 4 6 4 3 1 Linking TD Account Class to Profit Product cccccsccescceseesecesecusecuseeaeeeseeeseeseeeeeeeeeenseceseseaecnaeeaaeens 4 7 4 4 CREATING ISLAMIC TD E 4 9 4 4 1 Mam AO a a T a E E a ara aaa a a a aa aaa aeaa 4 10 4 4 2 N minee TAD ni anneo a o a e a a i aa a E a Eaei 4 13 4 4 3 Deposu TAD eee e we wad e css E E E E E E A E O 4 15 4 4 4 Dual Currency Depo
149. h Offset Account Provisioning Details Positive Pay Funding Exposure Category Risk Free Exposure Amount Provisioning Currency Mod 9 Validation Required Deferred Reconciliation provisions Auto Provisioning Required Reorder Cheque Level Reorder No of Leaves Cheque Book Name 1 Cheque Book Name 2 Max No of Cheque Rejections Account Local Cheque Book Passbook CAS Account ATM Details Initial Funding Cheque Book Preferences ______ Auto Reorder of Cheque Book Euro Cheques Mt210 Required Lodgment Book Consolidated Certificate Required Back Period Entry Allowed Account Opening Amount Pay In Option Waive account Opening Charges Branch Account Number Daily Amount Limit Daily count Limit Branch Code Escrow Account Escrow Percentage Pay In By Account Pay In By GL Escrow Transfer Details ____ Escrow Transfer Applicable Profit Charges Consolidated Charges Bic Deposits instructions standing instructions Linked Entities REG account status Restrictions Currency Limits MIS statement Limits Joint Holders Fields Deposits instruction Biting Parameters Account Signatory Interim Transactions Report notice Cards OFAC Check Maker Checker Date Time Date Time Mod No Record Status Authorization Status 2 117 ORACLE 2 3 31 Maintaining Provisioning Percentages Deta
150. h line can have a maximum of 105 alphanumeric characters 4 4 3 Deposit Tab Click Deposit tab on the Islamic TD Accounts Maintenance screen The following tab will be displayed Islamic TD Accounts Maintenance Branch Code Customer No Account Customer Name Currency Account Class SD User Reference Main Nominee Deposit Dual Currency Deposit Check List Profit Start Date Next Maturity Date Maturity Date Deposit Tenor Auto Rollover Rollover Type Principal Close on Maturity Principal Profit Move Interestto Unclaimed Special Amount Move Principal to Profit Unclaimed Rollover Amount Term Deposit Amount Computed Amount Pay In Details 10f1 a E Term Deposit Payout Details 10f1 m Payout Type Offset Branch Offset Account Narrative Recurring Deposit Installment Frequency Auto Payment Takedown Move funds on Overdraft Move Maturities to Days Unclaimed Months Payment Branch Payment Accounts Years Installment Amount Recurring Deposit Account Payment Date Payment Currency Profit Charges Linked Entities Restrictions ms statement Joint Holders Fields account Signatory TD Payout Details Change Log Maker Date Time Mod No Checker Date Time Record Status Authorization Status Specify the following details 4 15 ORACLE Profit Start Date Specify the date from which the profit accruals of TD account begins
151. h the associated account code When the account number gets populated it is the account code that forms a part of the customer account number Dormancy Days You have to indicate the period after which an account in an Islamic account class becomes inactive or dormant if customer transactions are not posted into the account However while maintaining transaction codes if you have checked the Consider for Account Activity field all transactions posted to any account under this account class linked to the particular transaction code will become active from dormant irrespective of the dormancy period If a customer initiated transaction is posted into the account with the dormant status the account status will be updated to Active from Dormant since the Transaction Code associated with the account has the Consider for Account Activity option enabled Account Statement Format Choose ACST_DETAILED for Savings type of account class and Nostro type of account class 2 3 ORACLE Display IBAN in Advices For an Islamic account class you can indicate whether the IBAN number of the customers involving the accounts within the class should be printed on advices sent to the customer If you would like to print the IBAN number of the customers on advices sent to the customers involving the account class you can enable the Display IBAN in Advices option by checking it Your specification will be made applicable to all customers linked to th
152. h wide parameters screen The account number can be a combination of the account class customer code CIF Number serial number or currency as defined in the customer account mask The last constituent of the account number is always a system generated check digit it could be alphabetical or numeric depending upon the mask defined You cannot alter the relative position of the constituents of customer account as defined in the mask while maintaining actual customer accounts Daily Amount Limit Specify the daily limit for the amount that can be withdrawn from the ATM Daily Count Limit Specify the daily count for the amount that can be withdrawn from the ATM Cheque Book Preferences In Oracle FLEXCUBE you can set off automatic reordering of Cheque Books for a Islamic account You can set up parameters based on which the system will trigger this activity The Cheque Book preferences maintained for the Islamic Account Class to which the account belongs will be defaulted to this screen However you may change your specifications for an account if required Auto Reorder of Cheque Book You have to select this option to specify that automatic reordering of Cheque Books is required for the account being maintained This option will be enabled only if you have indicated that the account holder should be provided with a Cheque Book facility The automatic reordering of Cheque Books is processed at EOD by executing a batch function
153. have to maintain the criteria based on which the system will bring about the status change automatically You can define the different criteria in the Status Rule Definition screen Click the Status Rule button in the Islamic Account Class Maintenance screen to invoke it Status Rule Definition Account Class Description Sequence Number Derivation Rule Elements Logical Operators Status 2 33 ORACLE In this screen you can define five conditions for each status applicable to an account class An account will be said to be in a specific status if any one of the five conditions associated with the status holds true for an account Conversely if all the conditions are false the account will automatically move to the next available status for which the condition is true Elements The following elements are available based on which you can build a condition for automatic status change You can associate each of these elements with an account in the Customer Accounts Maintenance screen The set of elements are as follows e Frozen e Dormant e Nodebits e Nocredits e Stoppayment e Current Status In addition the following elements will also be available for processing e OD overdraft Days e Inactive Days e Overline Days e TOD Temporary Overdraft Days e Customer Classification Logical Operators Logical Operators are indicators of certain conditions that you specify while building a
154. he CASA module a stop payment instruction is issued for a check or an amount against the account number the system automatically enables the Stop Payment check box When the stop payment instruction is withdrawn the status gets updated accordingly Ifa customer has requested for stop payment of multiple cheques the Stop Payment option will continue to remain checked till the last request is also cancelled After cancellation of the last stop payment instruction the option gets updated unchecked immediately Dormant The system updates this status for an account based on the dormancy days specified in the Account Class Maintenance screen Frozen If you have frozen a customer account in the Customer Information Maintenance Basic screen the accounts gets frozen For instance at the behest of a court order the status of the account is reflected here in the Customer Accounts Maintenance screen Posting Allowed If checked indicates that the account class being created is to be used while creating IRA monetary accounts Monetary accounts used for IRA need to be distinguished from the other accounts in Oracle FLEXCUBE so that these accounts do not come up for posting in the other Oracle FLEXCUBE screens Status change automatic This specification will be defaulted from the account class to which the account belongs However you have the option of changing it at the customer account level If you check th
155. he credit line details click the Limits button and invoke the Account Limits screen will be displayed The Limit currency specified in the Islamic Customer Accounts Maintenance screen is displayed Limit currency refers to the currency in which the bank wants to give credit facility to this account S This button appears enabled only if the function Id LMTACRES has been added to your User Role You will then be able to View Modify Add Define the details of limits maintained at the Account Level If this function ID has not been added to your User Role this button will appear disabled 2 97 ORACLE Account Limits Limit Currency Sublimit Temporary Overdraft Start Uncollected Funds Limit Temporary Overdraft End Temporary Overdraft Limit Credit Line Offline Limit Netting Required Daylight Limit Credit Start Date Notification Percentage Credit Rev Date Cr Transaction Limit TOD Renewal Renew TOD Renew Frequency Renew Unit Next Renewal Limit In this table you can define the following attributes for a credit line e Temporary Overdraft Limit e Sub limit e The date from which this credit line is effective e The expiry date of this credit line e The credit line to which you want to link this customer e Uncollected Funds Limits e Credit Transaction Limits Temp OD Start The start and end dates represent the dates from which the temporary overdraft limit becomes effective upto the date on which it should c
156. he external system regarding the black listed customer is displayed here User Remarks Specify your remarks regarding the black listed customer here 2 115 ORACLE 2 3 30 Specifying Change Log Details Change log details are maintained through the View Click the Change Log button in the Islamic Customer Accounts Detailed screen to invoke this screen View Modification Number Modification Status Maker ID Maker Date Stamp Authorization Status View Changes Remarks Maker Remarks First Checker Remarks Maker Override Remarks ji Checker Remarks 1of1 E Warnings Fi Warning Code Varning Description Fields O Field Name oia Value New Value Cancel 2 116 ORACLE 2 3 30 1 1 Maintaining Provisioning Preferences for a Islamic account An account inherits the provisioning parameters defined for the Islamic account class it uses You can change the defaulted parameters and make the following specifications as required in the Provision Details section of the Islamic Customer Accounts Detailed Auxiliary screen e Customer Accounts Maintenance Branch Code Account Currency SD User Reference Main Auxiliary Nominee Positive Pay Customer No Customer Name Account Class Check List Stale Days Fund Branch Funding Account Validation Digit Account Facilities Offset Branc
157. he system will trigger the event LBLK indicating that enough funds are not available and that subsequent credits made to the account will be blocked as a receivable 2 38 ORACLE 2 2 16 Specifying Statement Details Interim Transaction reports are maintained through the Interim Transactions and Balance Report screen Click the Statement button in the Islamic Account Class Maintenance screen to invoke this screen interim Transactions and Balance Report Interim Transactions Report Generate Message Generate Message only on Movement Report Transactions Since Interim Report Type Minimum Debit Amount Minimum Credit Amount 11 11 poorer amo O E L Balance Report Generate Balance Report Report Transactions Since Times Interim Transactions Report Times Balance Report Specifying Interim Transactions Report Generate Message Check this box to indicate that the periodic interim statement MT942 generation is required for the account The Consolidated Statement and Generate Message are mutually restricted Generate Message Only on Movement Check this box to indicate that the interim statement generation is required only if additional entries have been posted subsequent to the previous interim statement generation Report Transaction Since This section lists all the transactions of the interim account statement which are supposed to be reported You can c
158. hoose the appropriate values applicable e MT942 This indicates that all transactions posted and authorized since previous MT942 would be sent in the current interim statement e MT940 This indicates that all transactions posted and authorized since previous MT940 will be sent in the current interim statement If this option is selected you will have to specify the cycle of account statement to be considered 2 39 ORACLE e MT941 This indicates all transactions posted and authorized since the issue of a previous MT 941 in the current balance report Interim Report Type Select the interim report type from the adjoining drop down list This list displays the following values e Primary e Secondary e Tertiary Minimum Debit Amount Specify the minimum transaction amount for the debit transaction to be eligible for reporting in the interim statement The corresponding amount for the account currency will be defaulted However you can modify the amount defaulted If the amounts are not defined at the account class for the currency in which the account is being created no defaulting of amounts shall be done Minimum Credit Amount Specify the minimum transaction amount for the credit transaction to be eligible for reporting in the interim statement However you can modify the amount defaulted If the amounts are not defined at the account class for the currency in which the account is being created no defaulting of amounts shall
159. icates that the last created deposit will be broken first e FIFO First In First Out Indicates that the Earliest Deposit will be broken first e MAXB Maximum Balance Indicates that the Deposits are broken in descending order of available balance e MINB Minimum balance indicates that the order of breaking of Sweep Auto deposit will be done for the Account Deposit with the Minimum Balance Provide Profit on Broken Deposits You have to specify whether you want provide profit on deposits that were broken prematurely Check the box to indicate that you want to give the profit for the deposits Leave it unchecked to indicate otherwise 2 2 13 Specifying GL Lines Details In Oracle FLEXCUBE you can assign different status codes to the account class which will be applicable to all the accounts under it The accounts will move from one status to the other based on the number of days they have remained inactive in the system The status of an account will determine whether the account should be marked as an NPA Non Performing Asset or not Further you can also specify the reporting lines for GL Central Bank and Head Office to which accounting entries should be passed when an account moves from one status to the other You can post all debit and credit balances of one account class to a single General Ledger account Conversely you also have the option of posting debits and credits to separate GLs The status codes and the r
160. ich the Escrow account has to be created from the adjoining option list Escrow Account Select a valid account to be used as an Escrow account from the adjoining option list The list displays all valid accounts based on the selected Escrow branch and the currency of the project account Escrow Percentage Specify the percentage of the credited amount which has to be transferred to the Escrow account Options Indicate the following preferences Track Receivable During liquidation of finance contracts as well as processing of retail teller contracts if the system detects insufficient funds in the settlement account then you can choose to block the subsequent credit that happens to the settlement account In other words the system will track the account for receivables credits As and when a credit happens the funds will be allocated to the finance or retail teller contract for liquidation If the track receivable option is checked for the account the system will track the receivables for the account if sufficient funds are not available in the account The allocation of funds will happen in a sequence that you specify at the account class level This is explained in the section titled Maintaining Account Classes Replicate Customer Signature The signature of the customer gets defaulted from the account class level to account level This value is defaulted only if the customer type is individual with single mode of oper
161. ich the first liquidation should be done for accounts linked to the product gt Whether automatic liquidation s should always take place on a month end Profit Preferences Product Code UDE Currency Account Currency Description Profit Charges Consolidated Charges l C Reallocation Through Header Accrual I LM Parameters Product Level I J Integrated LM Product Accural Day 0 Integrated LM Type Frequency Daily vi Debit Profit Notification Cycle None w Receivable General Ledger az Payment Method Bearing Discounted y Calculation and Liquidation Days o First Liquidation On amp Months o C Liquidation at month ends Year o Start Date o Start From Account Opening g Back Value Recalculation o Refund Tax on Preclosure Fiag PRENT li O Deter Liquidation Frequency pee Defer Liquidation Days o oO Liquidation Before Month End Defer Before Month End Days o C Zakat Product 1of1 Account Details Fj Account Class Description Currency Spl Condn Only Repop AtLiqn Repopulate UDE at Rollover Open Ok Cancel You can apply a Mudarabah profit product to any number of Mudarabah accounts or account classes When you apply a product to Mudarabah account class profit for all the accounts will be calculated according to the rule or the calculation method to which the product is linked That is the principal period
162. id at the time of redemption You can choose from the following values displayed in the drop down list e Principal e Principal Profit For such Mudarabah deposits on the date of redemption the system re computes the profit for the period for which the profit has already been paid using broken period rate It then deducts the computed amount from the Mudarabah deposits principal amount The system then credits the reduced principal amount to the payout account The deposit remains in the Active status till the next profit distribution date from the date of redemption In the case of premature redemption the profit gets liquidated only after the profit calculation and distribution has happened for that financial cycle This is done by checking Defer Liquidation option in the Islamic Profit Distribution Product screen The profit will finally get liquidated into the Payout account maintained 4 2 2 Specifying the Auto Deposits 4 4 ORACLE You can create an auto deposit in case the balance in the source account exceeds a certain threshold The auto creation of deposits is carried out as an end of day process Click Auto Deposits button in the Islamic Account Class Maintenance screen and invoke the following screen Auto Deposits Account Class Def Rate Code Transaction Code Def Rate Type Currency Sweep Mode Minimum Required Balance Break Method Cluster Identification Provide Profit On Broken Break
163. ify that automatic reordering of Cheque Books is required for all accounts reporting to this account class This field will be enabled only if you have checked the Cheque Book option explained above Reorder Level Here you have to indicate the level at which the reordering of Cheque Book should happen Automatic reordering will be set off by the system when the unused number of cheque leaves becomes equal to or less than the re order level that you maintain here This field will be enabled only if you have indicated that automatic reordering of Cheque Books is required i e the Auto Reorder of Cheque Book option is checked Reorder Number of Leaves In this field you have to specify the number of leaves that should be ordered for the new Cheque Book This field will be enabled only if you have checked the Auto Reorder of Cheque Book option Max No of Cheque Rejections Specify the maximum number of cheque rejections that can be allowed for an account 2 2 10 Specifying REG Details For Islamic account class you can define whether the Regulation D limits are applicable and the period over which the limits would be applicable To invoke REG Details screen click the REG button in the Islamic Account Class Maintenance screen You can specify the Regulation D applicability details in this screen REG Details Applicable Periodicity Monthly Statement Cycle None If you indicate the periodicity of
164. ikewise all credits within a particular account class will report to the GL account that you have identified to track credits Dr and Cr Central Bank Lines Select the Central Bank Debit line to which all debit accounts belonging to an account class should report to when it moves to the selected status You have maintained Central Bank Debit lines in the Reporting Lines Maintenance screen You can select the appropriate CB Debit Line from the available option list Similarly all accounts belonging to an account class if in credit should report to a Central Bank Credit Line for the selected status You can identify the CB Credit Line that should be associated with the status from the option list available Dr and Cr Head Office Lines This is the Debit Head Office GL maintained in the Reporting Lines Maintenance screen to which all accounts belonging to this class will report if they move to the status being defined Similarly select the Credit Head Office GL maintained in the Reporting Lines Maintenance screen to which all accounts belonging to this class will report to when they move to the status being defined As a mandatory requirement you have to associate the status NORM Normal when maintaining status codes for an account class 2 32 ORACLE 2 2 14 Accounting Roles and Heads for Provisioning In addition to the provisioning preferences that you specify for an account class you must also maintai
165. ill display the entire list of customer accounts maintained under the customer category Financial Institutions 2 20 ORACLE 3 Select Morgan Stanley It will be listed in the first row To allow this customer the parameters assigned to this account class check the small square box alongside 4 To add a row click the Add icon To delete an extra row click the Delete icon 5 To disallow Midas Bank click on Banks under available categories Click the adjoining arrow against Customers to display a list of all the customers under this category Select Midas Bank Since you would like to disallow this customer do not check the square box against it o Check the square box to allow a customer the parameters assigned to this account class Leave the box unchecked to disallow a customer from being assigned to this account class 2 2 8 Specifying MIS Details To invoke the MIS details screen for an account click the MIS button while opening modifying the account The entities defined for the customer will be picked up by default and these entities can be changed Account Class Pool Code Transaction MIS MIS Class 1 MIS Class 2 MIS Class 3 MIS Class 4 MIS Class 5 MIS Class 6 MIS Class 7 MIS Class 8 MIS Class 9 MIS Class 10 MIS Group MIS Code 1 MIS Code 2 MIS Code 3 MIS Code 4 MIS Code 5 MIS e6 MIS Code 7 MIS Code 8 MIS Code 9 MIS Code 10 Link To Group Cost Code1 Cost Code2 Cost Code3 Cost Code4 Cos
166. ils In addition to the provisioning preferences listed above you must also indicate the applicable provisioning percentage and the discount percentage details in the Provision Percentages screen that you can invoke by clicking the Provision button in the Provisioning Details section of the Islamic Customer Accounts Detailed Auxiliary screen Provisioning Percentage Account Number Provisioning Percentage Details 10f1 Li You can maintain the following details here Provisioning Percentage If you wish to indicate a specific provisioning percentage to be applicable for the account you can specify it in the Provisioning Percentage screen If you do not specify any provisioning percentage the provisioning batch picks up the applicable provisioning percentage from the Exposure Provisioning Percentage Maintenance for the exposure category of the account and the account status Discount Percentage If you wish to indicate a specific discount percentage to be applicable for the account you can specify it in the Provisioning Percentage screen If you do not specify any discount percentage the provisioning batch picks up the applicable discount percentage from the Exposure Provisioning Percentage Maintenance for the exposure category of the account and the account status Viewing the Computed Provision Amount The provision amount computed for the account is displayed in the Provision A
167. in branch code is displayed here MIS Group For an account the transaction type of MIS class will be picked up from the account class Rate Code Specify the rate code Select the appropriate one from the adjoining option list which displays all valid rate codes maintained in the system 2 87 ORACLE Link to Group If an MIS Group is linked you can indicate whether the linkage with the group should always be maintained If yes any change to the MIS Group will automatically apply to the customer to whom the MIS Group is linked If not the entities defaulted for the customer will continue even if they are changed subsequently for the group Rate type If you have indicated that rates maintained for the individual account should be picked up for MIS refinancing you have to specify the Rate Type that is to be used The options available are e Fixed e Floating Automatic indicating that the system should pick up the refinancing rate associated with the account Since the account number is linked to a Rate Code the system picks up the rate code associated with the account when the EOD processes are run to refresh the various rates Select the appropriate Pool Code Account Level The Pool Code Account Level to which the account class or product belongs should be defined Pool Code For an account the pool code will be picked up from the account class Transaction MIS Group For an account the transaction type of MIS class wil
168. ing Profit Rules Maintaining System Data Elements Giving UDE Values for a Condition and Building Formulae for further details about profit rule maintenance Specifying status codes for an account At the time of defining a Profit Charge product you can maintain different status codes and specify parameters based on which accrual and application of profit charges will happen for the status of the account Status codes are maintained through the Status Control screen Click the Status Maintenance button in the Islamic Profit Distribution Product Maintenance Detailed screen to invoke this screen The screen is as below Status Control Product Code Description Status Details Status Description Transaction Code Stop IC Reverse Accrual Role to Head Mapping 10f1 ro Accounting Role Accounting Head IL The following parameters may be maintained in this screen Product Code The code of the Charge product for which you are defining preferences is displayed in this field Status You can select the different status codes applicable to the Mudarabah product in this field Use the add button to define each status and the attributes for the same You can use the navigation buttons to move from one status to the other The status codes with status type Account only will be available in the option list provided 3 29 ORACLE On selection of the status the associate
169. ing of the account and generating queries In the Data Entry Module you can input a transaction using the alternate account number instead of the actual account number Clearing Bank Code The clearing bank code for the customer account is generated automatically if you have opted for auto generation in the Branch parameters Clearing Account Number The clearing account number for the customer account is generated automatically if you have opted for auto generation in the Branch parameters The account number is created according to the account mask you have maintained for the branch This will be mandatory and has to comply with length of 9 characters and MOD 11 validation if the value of the UDF Clearing A C Mandatory is maintained as YES in the Field Name to Value Definition screen 4 11 ORACLE However you can choose to change this number here and the system validates this number with the account mask you have maintained for the branch IBAN Account Number To capture the detail of the IBAN account for a specific customer you have to enable the IBAN Required option by enabling it Subsequently click the M button The IBAN details sub screen will be displayed In this screen you can capture the IBAN Account Number as well as the bank code of the bank where the IBAN account resides Address Specify the address of the customer Location An address for a customer account is based on the Location and
170. invoked from the Application Browser You can invoke the Islamic Profit Distribution Product Maintenance screen by typing IADPRMNT in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button 4 6 ORACLE Profit amp Charges Product Maintenance Product Code Include For TDS Calc Product Description Deposit Product Type Tax Description Billing Liquidation Slogan Charge Basis Product Group Description Product Group Description Booking Account Type Start Date End Date Remarks Rule Rule Description Recountng Roles Events oranch customer references status maintenance Maker Date Time Mod No Checker Date Time Record Status Authorization Status 4 3 1 Linking TD Account Class to Profit Product You can link the TD Account Class to the Profit product in the Profit Preferences screen Click Preferences button on the Islamic Profit Distribution Product Maintenance screen and invoke the following screen 4 7 ORACLE Profit Preferences Product Code Description Profit Charges UDE Currency Consolidated Charges Reallocation Through Accrual Header LM Parameters Integrated LM Type Accrual Day Integrated LM Product Frequency Cycle Payment Method Debit Profit Notification Receivable General Ledger Product Level Bearing Discounted Calculation and Liquidation Days Months Year Account Detail
171. iquidation run as part of BOD EOD on 1 Jan Liquidation does not occur as the system detects insufficient funds in A1 only 400 USD The account is marked for receivable tracking and a block is placed on 400 USD A credit of 500 USD to A1 on 2 Jan The total amount blocked gets updated to 1000 USD Since we have two contracts involving the same product LDBD maturing on the same date funds will be allocated to the first contract LDBDO01 based on the Contract Reference Number Subsequent credits to the account will be used towards loan LDBDO02 Since contracts with LDBD have earlier schedule dates funds will be allocated to them though as per the product sequence contracts with ADBN should receive the funds first The liquidation schedule date takes precedence in this case Further credits to account A1 will be allocated against the contract ADBNO01 followed by the contract ABCD001 This will be based on the product sequence number since both contracts have the same schedule dates Within a contract allocation of funds towards the various components like profit compensation profit etc will be determined by the Liquidation Order maintained for the loan product To sum up the schedule date of the loan contract takes precedence followed by the product sequence and finally the liquidation order 2 37 ORACLE If insufficient funds are detected in an account with a receivable tracking t
172. is option the status of the account will be changed automatically by the system as per the conditions maintained in the Status Rule Definition screen invoked from the Account Class Maintenance screen If you do not select this option you have to change the status manually through the Manual Status Change screen OverDraft Check this option to provide overdraft facility for the account Refer to the section titled Modifying an account status manually later in this chapter for more details Contribute to PDM This box is checked by default while creating an account to indicate that the account balance should be considered for contribution to the profit distribution pool However you can uncheck it 2 50 ORACLE Exclude from Distribution This preference is defaulted from the linked account class However you can change it If this box is checked the system will not consider the account for profit distribution Leave the box unchecked to include the account in profit distribution Note that you can uncheck this box only if you check the box Contribute to PDM Note the following e f you check the box Contribute to PDM and uncheck the box Exclude from Distribution the system will consider the account balance as the depositor s contribution and also distribute profit to the depositor e Ifyou check the boxes Contribute to PDM and Exclude from Distribution the system will consider
173. is her savings account without being liable to pay advance profit Notice Days Specify the number of days before which the customer should notify the bank if he she wants to withdraw an amount more than the Free Amount from his her account Validity Period Specify the validity period in number of days During this period the customer can do the withdrawal of the amount for which he she notified the bank This screen is applicable only for saving type of account 2 3 28 Specifying Cards Details Card Summary details are maintained through the Card Summary screen Click the Cards button in the Islamic Customer Accounts Detailed screen to invoke this screen 2 112 ORACLE LBL_CARDSSUMMARY_SCREEN LBL_BRANCH_CODE LBL_CUST_NO LBL_ACTNO 11 m LBL AUTH_STAT LBL _RECORD_STAT LBL_BRANCH_CODE LBL_REQUEST_REFERENCE_NO iO Here you can view the following details Branch Code The branch code is displayed from the main Customer Accounts Maintenance screen Customer No The customer identification code CIF of the account holder is displayed from the main Customer Accounts Maintenance screen Account No The account number is displayed from the main Customer Accounts Maintenance screen Authorisation Status Indicate the authorisation status of the debit card by selecting one of the following values e Authorised e Unauthorised Record Status Indicate the record
174. l be picked up from the account class Composite MIS Group The composite type of MIS class will be defaulted from those defined for the customer Cost Code For an account the cost codes will be picked up from the account class 2 3 18 Specifying Change Log Details To invoke the Change Log screen for an account click the Change Log button in the Islamic Management Information System screen 2 88 ORACLE Branch Code Account Change Log Details 10f1 m MIS Class Transaction Date Old MIS Code New MIS Code C Branch Code The current logged in branch code is displayed here Account The current logged in account number is displayed here Specifying Transfer Log Details To invoke the Log screen for an account click the Change Log button in the Islamic Management Information System screen Balance Transfer Log Balance Transter Log Details o Branch Code Product Code Fin Year _ Transaction Date al GLCode MS Class Old MIS Code New MIS Code ajir nd al Ct Here you can capture the following details 2 89 ORACLE Account Number This is the account number of the deposit If you specify an account that is disallowed for your user id and move to the next field the system will throw up an error override The restricted accounts for users ids are maintained in the User Account Class Restrictions screen The system will perform this vali
175. lances before applying weights during profit distribution Exclude from Distribution Check this box to indicate that accounts under this account class should be excluded from profit distribution No of Days For Salary Block Specify the number of days for salary block At the time of salary credit in to a customer account the system will place an amount block for the number of days specified here from the date of salary credit The amount blocked will be equal to the finance installments due during this period Example For single finance installment 2 25 ORACLE No Of Days for Salary Block 15 days Salary credit amount 10000 AED credited on 30 Oct 2009 Finance Installment Amt 5000 AED due on 05 Nov 2009 System will check for the Finance installments falling due till 14 NOV salary credit on 30 Oct 15 The system will put an amount block of 5000 AED with expiry date as due date i e 05 Nov 2009 and Effective date as Application date i e 30 Oct 2009 The created amount block will have amount block purpose code as 05 and Remarks field will be populated with Finance A c Number Note For a given finance account schedule all the applicable component amounts are summed up and a consolidated amount block will be created These amount blocks created by system for hold on salary purpose cannot be amended by users and only can be closed if required for the purpose of doing a manual liquidation for finance prepayment F
176. ller Product Managers Generation of reports 1 3 Organization This manual is organized into the following chapters Chapter 1 About this Manual gives information on the intended audience It also lists the various chapters covered in this User Manual Chapter 2 Creating Islamic Accounts explains how you can create Islamic Deposit Accounts Chapter 3 Creating an Islamic Profit Distribution Product explains to process to create a profit product for Islamic profit distribution 1 3 1 Related Documents e The Core Entities User Manual e The Procedures User Manual e The Settlements User Manual e The Profit and Charges User Manual I ORACLE 1 4 Glossary of Icons This User Manual may refer to all or some of the following icons Icons Function New Copy Save Delete Unlock Print Close Re open Reverse Template Roll over Hold Authorize Liquidate Exit Sign off Help Add row Delete row Option List ORACLE Icons Function e Confirm 9 Enter Query ar Execute Query Refer the Procedures User Manual for further details about the icons 1 3 ORACLE 2 1 2 2 2 Creating Islamic Accounts Introduction As part of capturing customer related information in Oracle
177. m will display an error message on save In case of check replacement the Modulo 9 Validation is done for the new check number while in case of alphanumeric checks the system throws an error message if modulo 9 validation is checked When uploading a positive pay cheque the system will perform a Modulo 9 Validation if Modulo 9 validation is enabled for the product If the validation fails this particular check will not be uploaded The same will be valid in case of Cheque Replacement while for alphanumeric checks system will skip the check and display an error Stale Days If you have specified a positive pay facility for the account you are maintaining then you have to indicate the number of stale days for the transaction If the date of processing happens after the specified stale date then the transaction gives an exception error You have to do an override for this exception Fund Branch Click on the adjoining option list to choose from the list of branches maintained The positive pay parking account will be picked from this branch Deferred Reconciliation Enabling this check box indicates whether or not the Positive Pay account has the Deferred Reconciliation facility Deferred Reconciliation is the facility wnerein a Positive pay cheque which is free of any disparity is cleared by the bank even in the absence of any instruction from the drawer of the cheque The instruction can be deferred Deferred Reconciliation function goes h
178. mer Accounts Detailed screen to invoke this screen interim Transactions Report Interim Transactions Report Debit Amount Generate Message Credit Amount Generate Message Only On Movement Statement Count For The Day Year To Date Statement Count Report Transactions Since Of Account Balance Generate Balance Report Report Transactions Since This screen contains the details necessary for the account generation parameters The message details the balance of the customer account that is under a particular account class The account balances indicate the condition of the customer account for an identified time period 2 3 26 1 1 Specifying Interim Transactions Report Generate Message Check this box to indicate that the periodic interim statement MT942 generation is required for the account This will be defaulted from Account Class Maintenance screen However you can modify it The Consolidated Statement and Generate Message are mutually restricted Generate Message Only on Movement Check this box to indicate that the interim statement generation is required only if additional entries have been posted subsequent to the previous interim statement generation This will be defaulted from Account Class screen however you can modify it Report Transaction Since This section lists all the transactions of the interim account statement which are supposed to be reported This will be defaulted from
179. mer Signatory details screen 2 107 ORACLE If the signatory ID that you specify has not been maintained the System displays an override On confirming the override you will be allowed to save the signatory details An error message is displayed if you enter a duplicate Signatory ID Each time you capture a new Signatory ID at the account level you must identify the relationship of the signatory with the customer Customer Name The system displays the name of the corresponding customer Minimum Number of Signatories Specify the minimum number of signatories necessary to endorse an instrument involving the account Account Message You can capture information about particular signatories These messages could pertain to the name number and the type of signatory your customer is For instance you can capture a message like This signatory is a joint account holder with rights to sign instruments only up US 8000 Signatory Number The system displays values maintained in CIF signatory for the customer number Signatory Name The system displays the corresponding name of the signatory number specified Approval Limit Specify the amount up to which the account signatory can approve for debits 2 108 ORACLE 2 3 26 Specifying Interim Transactions Report Details Interim Transaction reports are maintained through the Interim Transaction Reports screen Click the Interim Transaction Reports button in the Islamic Custo
180. mount field in the Amounts and Dates button in the Islamic Customer Account Maintenance screen 2 3 32 Viewing details of Amounts and Dates 2 118 ORACLE In the Amounts and Dates screen you can view all Financial details of this customer s account along with the details of the previous debit or credit activities However access to all financial information of an account can be restricted for any user The financial details of an account include the account balance the un cleared debit and credit balances the debit and credit turnover and the profit details Click the Amounts and Dates button in the Islamic Customer Accounts Detailed screen Amounts And Dates Branch Code Account Opening Daily Turnover Dr Daily Turnover Cr Current ACY Uncollected Withdrawal Uncollected Funds Blocked Receivable Available Unutilized Amount Total Available Provision Amount Unposted Debit Dr Credit Cr Uncollected Unauthorized Debit Dr Credit Cr Uncollected Cr 2 3 32 1 1 Opening Daily Turnover Dr Daily Turnover Cr Debit Dr Credit Cr Current LCY Accrued Interest Dr Accrued Interest Cr Profit Due Charge Due Previous Date Debit Credit DR Activity CR Activity Unposted Dr Unposted Cr Unposted Turnover Limit Details Current Period Currency Maximum Credit Turnover Allowed Deposited In Current Period
181. n account statements will be generated on e The last working day for months with lt 30 days e For months with 30 days on the 30th if 30th is a holiday on the next working day If you set the statement date to 31 then account statements will be generated on e The 31st for month with 31 days if 31st is a holiday on the next working day e The last working day for months lt 31 days For a fortnightly statement you could specify 1 and 15 For all other cycles account statement will be generated on the last day of that cycle Generate Stat Only On Movement You can indicate that an account statement should be generated for the customer s account only when there has been a movement of funds into the account or when funds have been transferred out of the account For instance let us assume that on the August 21 2001 you have set the account statement generation frequency as Daily for the account LIO20804 On September 5 2001 there has been no movement of funds in the particular account If you have opted for the Generate Only on Movement option the system will not generate a statement message for September 5 2001 If you choose not to enable this option account statements will be generated regardless of whether there has been a movement of funds or not Exclude Same Day Reversal trns from Stmt If you do not wish transactions booked and reversed on the same day to be reflected in the account statement you can specify the prefer
182. n in the following format nnnDnnMnnyY where n stands for a numerical value LCY Amount Before Weights The system displays the LCY equivalent amount of the total account class contribution before applying the applicable weightages Weights The system displays the weighted average balance of the deposits in the amount range and tenor LCY Amount After Weights The system displays the depositors value in a particular account class in LCY after application of weights 3 38 ORACLE Profit Amount Before Fee The system displays the profit amount accrued to the deposits in the amount range and tenor before fee application Mudarabah Fee Your bank recovers some expenses by way of a Mudarib fee which will be recovered as a percentage of the fund profit The system defaults this value from the Weights Maintenance screen Mudarabah Fee LCY The system displays the local currency equivalent value of the Mudarabah fee charged for the account class with currency Adj Mudarabah Fee LCY Specify the Mudarabah fee in local currency Profit After Mudarabah Fee ADJ The system displays the total profit for a particular account class and currency combination after the Mudarabah fee adjustment if any on saving Ann Rate after Mudarabah Fee ADJ The system computes the annualized profit rate based on the profit amount and the deposit value and displays it here Adhoc ADJ Amt You can make an adhoc adjustmen
183. n list displays all valid branch codes maintained in the system You can select the appropriate one 4 25 ORACLE Customer Identification The customer identification CIF of the customer for whom TD needs to be renewed or redeemed is displayed based on the TD account number Term Deposit Account Number Specify the TD Account Number You can also choose the appropriate one from the option list The option list displays the deposit type of accounts maintained in the system The option list does not display auto deposit type of accounts Account Currency The TD currency is displayed here based on the TD account number Account Description A description of the TD is displayed here based on the TD account number Account Balance The account balance is displayed here based on the TD account number Renewal Redemption Choose Renewal option to renew the accounts that are within the grace period days Choose Redemption to redeem the term deposit Note the following e When a term deposit is moved to unclaimed on maturity date you have to manually renew or roll over the same term deposit Once you choose the option Renewal the Term Deposit Account Number field displays those accounts whose balances are moved to unclaimed GL e The accounting entries for redemption renewal are passed only on authorization Redemption Indicate the following details if you have chosen Redemption Redemption Mode Select the
184. n the accounting roles and heads representing the GLs to which the accounting entries for provisioning must be passed for each account status You can maintain this information in the Status Details screen when you define each of the status codes Rebook Provisioning on Status Change In the Status Details screen you can indicate whether provisioning entries for an account must be rebooked when provisioning is done after an automatic status change for the account Rebooking essentially means that fresh provisioning is done after writing back the previous provisioning amount The provisioning batch process when executed not only computes the provisioning amount it also records the current status of the account and checks whether the current status is different from the status that was prevalent when the process was previously executed If so the old provisioning amount is reversed ifthe Rebook Provision option has been set in the Status Details and the entries for the new provisioning amount are booked into the provisioning and write back GLs maintained for the current status in the Status Details If the Rebook Provision has not been set there is no reversal of the old provisioning amount and the differential provisioning entries are passed as usual into the GLs maintained for the new status Specifying Status Rule Details If you have opted for automatic status change for all accounts belonging to an account class you
185. n the button adjacent to Allowed or Disallowed to indicate the list type that you are maintaining 3 1 4 Maintaining Customer Restrictions Customer restrictions are maintained through the Customer Restrictions screen Click the Customer button in the Islamic Profit Distribution Product Maintenance Detailed screen to invoke this screen 3 10 ORACLE Customer Restrictions Product Code Product Description Class Details Class Code Class Description Restriction Type Categories List Disallowed Allowed Customers 10f1 TT Customer Id Restriction T 0O When defining a product you can choose to specify Customer and Category Restrictions either by e Associating the product with a Class e By defining these restrictions specifically for the product in the Customer Restrictions screen Product Code The code of the Charge product for which you are defining preferences is displayed in this field Description Enter a brief description of the product This description will be associated with the product for information retrieval purposes Class Code In Oracle FLEXCUBE you can define a set of customer restrictions as a class You can maintain several restriction classes When creating a product you can associate it with a customer and category restrictions class that best suits your requirement The manner of creating a restrictions class is similar to setting up res
186. ncy is different from the transaction currency the exchange rate used to convert TD currency into transaction currency is displayed here based on the rate maintained for the currency pair 4 30 ORACLE Transaction Amount The amount being liquidated for the TD is displayed in the transaction currency Transaction Currency Specify the currency in which the TD should be liquidated The adjoining option list displays all valid currency codes maintained in the system You can select the appropriate one Narrative Give a brief description for the transaction if required 4 5 4 Authorizing Transaction For the transaction to be authorized click Authorize button The following screen will be displayed rs Authorize Modification Number Modification Status Maker ID Maker Date Stamp Authorization Status View Changes 1 iN A13331A01 2012 03 01 12 26 03 UnAuthorized Remarks Maker Remarks First Checker Remarks Maker Override Remarks Checker Remarks T F Warning Code Warning Description Fields Fi Field Name Old Value New Value The accounting entries for redemption renewal are passed only on authorization 4 31 ORACLE 4 32 ORACLE 4 6 Viewing TD Redemption Details You can view the details of TDs redemption using the Term Deposit Redemption Summary screen To invoke this screen type IASREDMN in the field at th
187. nd Defer Before Month End Days Zakat Product Account Details 10f1 m Account Class Special Condition Only Repopulate at Liquida B You need to maintain the liquidation type as ad hoc Hence you should not specify the liquidation details pertaining to periodic liquidation Refer the section titled Liquidation Related Details in this User Manual for further details Zakat Product You need to check this option 3 2 1 1 Maintaining a rule You need to use the SDE CURR_VD_BALU in order to fetch the amount on which the Zakat needs to be levied and the SDE APPLY_ZAKAT to identify whether the customer account is exempt from Zakat or not You need to maintain the threshold amount and the Zakat percentage as UDEs 3 27 ORACLE Z Profit amp Charges Rule Maintenance Web Page Dialog Apply Profit C on Account Opening Month Rule Identification Oo On Account Closure Month Rule Description Primary Element System Elements User Elements a C user Elements Type Get Latest Oo System Elements Formulas Fields Authorized By Date Time W authorized Date Time Modification Number You need to use the aforementioned SDEs and UDEs to build the rule r Formula Wizard Web Page Dialog Formula Wizard o Expression Case Result Element Functions Operators Logical Operators 3 28 ORACLE 3 2 2 Refer the chapters titled Maintain
188. o the Numerator part of the profit method Months Specify the installment frequency in terms of months Years Specify the number of years that would constitute an year for calculation purpose Dual Currency Deposit Tab Click Dual Currency Deposit tab on the Islamic TD Accounts Maintenance screen The following tab will be displayed Islamic TD Accounts Maintenance Branch Code Customer No Account Customer Name Currency Account Class SD User Reference Main Nominee Deposit Dual Currency Deposit Check List Dual Currency Deposit Linked Currency Currency Option Product Option Contract Reference Exchange Rate Linked Currency Settlement Account Linked Currency GL Fixing Days Yield Enhancement Inception Fair Value Pron charges imoa enanas Reatichons ms stement sont vaders rads accom Snatory To Payout betta change Log Maker Date Time Mod No Checker Date Time Record Status Authorization Status Specify the following details 4 20 ORACLE Dual Currency Deposit You can capture the following details for the deposit Linked Currency This option is defaulted from the account class However you can modify this value Currency Option Product Specify the currency option product from the option list under which the Options Contract has to be created in case of Dual Currency Deposit The option list displays all the Option Products with Product Type CO You ne
189. of each profit period This deferment will allow the inclusion of profit adjustments due to back valued entries posted into the account after the period end date In order to avail of this facility you need to enable the Defer Liquidation option and also mention the number of calendar days by which you wish the profit liquidation for a period to be deferred 3 24 ORACLE The functionality is explained with the help of the following example Example You have enabled the Defer Liquidation option and opted to defer liquidation by 10 days For the period 01 Mar 2003 to 31 Mar 2003 the period code in M03 On 05 Apr 2003 an entry is posted with period code M04 into the CASA for value date 15 Mar 2003 Since profit for MO3 is not yet liquidated profit calculation for M03 is adjusted for this entry The same process is followed for all back valued entries with value dates lying in MO3 posted into the account up to and including 10 Apr 2003 The final adjusted profit is liquidated as part of end of day batch process on 10 Apr 2003 3 1 11 1 Generating customer notice for debit profit Credit profit is liquidated and credited to the account by the System on the liquidation date which may be the end date of the profit period or a deferred date depending on your choice Debit profit is also calculated on the liquidation date If you have specified for an Account Class that debit profit notices have to be generated then the debit profit i
190. omatically calculated and deducted from the accounts to which the chosen IC product is linked If this batch is re run on the same date then the accounts where Zakat has already been liquidated will not be charged again If the batch is run after a day the computation will take place on the Ramadan date Status Change Batch Processing CSDSTBTC For the IA module the Status change batch will be run along with the customer Group and apply worst status change for the customer This batch will use the status change events You can trigger the batches to run before the Common Status Change batch CSDSTBTC The following given batches can be run in any order 3 50 ORACLE e LCEOD e BCAUSTCH e CLBATCH e ICEOD e CIDBATCH e MODBATCH e CASABAT e IAAUTDLY e CSDSTBTC e ICEOD e CLDPROV e MODPROV e CIDPROV If Status Processing is at Individual Contract Level then system will trigger status change based on the Customer Credit rating for the customer of the Contract Account booked The other contracts of the customers in the same Group will not be impacted However if the Status Processing is at CIF Group level individual module LC CL Cl MO CA IA and BC batches will be updating common storage with the derived status of each contract and CIF Group level status will be triggered by the common status change batch The common status change batch will call the individual module function for status change processing 3 51 OR
191. omer group to which the customer belongs based on the total exposure has been maintained in the Exposure Type Category Linkage maintenance then the exposure category of the account is identified If no logic has been maintained you can specify the exposure category in the Islamic Account Class Maintenance screen Event Class Code Specify the event class for which the provisioning accounting entries would be defined Debit Profit Charge Liquidation You must specify the liquidation preferences for debit profit and charges for those accounts classes where profit charge has to be debited from a Receivable GL before actually debiting the customer account This feature is applicable only for the debit profit and any charges on the account calculated through the IC module The preferences that you need to specify are Liquidate Using Receivable Indicates whether receivable tracking is required for IC Debit profit and IC charges Verify Funds Enabling this option indicates that an available balance check should be performed for receivable tracking As a result the System performs the available balance check before debiting the account The available balance also includes the limit amount Verification of funds is applicable only in the case of Auto Liquidation If you leave this option unchecked the System performs a force liquidation regardless of whether the account has sufficient funds or not Debt Notice Enabling this
192. on from the available option list On selection of the account the description gets displayed in the adjacent field At the time of maintaining an instruction you can also specify a condition for displaying the instructions when transactions pertaining to this account are being processed The instruction will be displayed to you when the condition is satisfied 2 3 34 Closing a Islamic Account When you close an account the system will check whether an IC product linked to the account is pending liquidation If an IC Product is pending liquidation you will be prompted to perform the liquidation before closing the account You can click on the Liquidate button to imitate the process whereby the system will calculate all outstanding amounts for all products involving the account and display the same On confirming the details that are displayed the system liquidates the products You will not be required to authorize this action If any provisioning has been done in respect of the account the relevant amount is written back to the GL as specified in the maintenance on Closure 2 122 ORACLE If the account does not have any IC products pending liquidation the system will display list of Close Out modes in the Account Closure Details screen LBL_ACC_CLOS_DET Branch Balance Account Number Interest Closing Date Sequence Number Branch Account Currency Close Mode Details Close Mode Linked Product
193. on list The option list displays only those transaction codes which are enabled for Escrow processing at the Transaction Code Maintenance screen During account class amendment system does not allow you to disable Escrow process for an account class if a Project account has been created using that account class Cash Deposit Limit on Trust Account If you have checked the box Escrow Transfer Applicable you will have to specify the maximum cash that can be deposited in the Trust accounts under this account class Statement Parameters Tab For each Islamic account class that you maintain you have the option of generating account statement details periodically for all customer accounts associated with the account class If you need to generate account statements that would need to be sent across multiple media generated at different frequencies you can define up to three different frequencies at which the statements could be generated with a primary secondary and tertiary frequency Sor If you are defining primary secondary and tertiary statements the frequency for each must be different and unique for instance if you define a monthly primary statement you cannot define a secondary or tertiary statement with a monthly frequency As part of specifying the account statement preferences you can indicate the following for each of the statements whether primary secondary or tertiary 2 8 ORACLE Click Statement Param
194. or multiple Finance instalments No Of Days for Salary Block 15 days Salary credit amount 10000 AED credited on 30 Oct 2009 Finance Installment Amt 5000 AED due on 05 Nov 2009 Finance2 Installment Amt 3000 AED due on 10 Nov 2009 In this case 2 block amount transactions will be placed by system on 30 oct 2009 on Salary credit date in the order of finance installment due date with block amounts No of days for Closing Unauthorized Accounts with No Activity Specify the number of days inactive days allowed for closing unauthorized accounts with no activity No of days for Closing Authorized Accounts with No Activity Specify the number of days inactive days allowed for closing authorized accounts with no activity Cheque Book Preferences Oracle FLEXCUBE provides you with the facility to automatically trigger the reorder of Cheque Books for all accounts reporting to a specific account class However you have the option of changing your preferences at the account level also To facilitate automatic reordering of Cheque Books you have to maintain the following details Cheque Book To indicate that automatic reordering of cheque books should be allowed and for specifying the details for the same you have to check this option If not selected you will not be able to maintain the automatic reordering preferences for the account class 2 26 ORACLE Auto Reorder of Cheque Book You have to select this option to spec
195. ors profit after deducting the Investment Risk Reserve IRR amount 3 6 1 4 Profit Equalization Amount Specify the following details Profit Equalization Amount If credit is selected then the Amount specified in the LCY field and Percentage mentioned in the PEA for dep investment will be added to the total depositor profit amount in case of loss amount will be debited from the PEA GL amp distributed to the depositor If Debit is selected then the Amount specified in the LCY field and Percentage mentioned in the PEA for dep investment will be deducted from the total depositor profit amount In the months that your bank makes more than expected profit you can set aside some profit as Profit Equalization Amount You can use this amount to distribute to the depositors in the months of losses Ley You can also specify the PEA as a fixed amount in the bank s local currency PEA for DEP Investment In the months that your bank makes more than expected profit you can set aside some profit as Profit Equalization Amount You can use this amount to distribute to the depositors in the months of losses Specify the PEA as a percentage of the depositors profit Investment Risk Reserve Specify the following details Credit Debit Indicate whether the IRR amount should be deducted from or added to the depositor s profit Select one of the following options e Credit Choose this to add the IRR amount to the de
196. osit Here you specify deposit specific details Dual In this tab you can maintain details of a dual currency Currency deposit Deposit 4 4 1 Main Tab By default the Main tab is displayed when you invoke this screen The fields in the Main section are as follows 4 10 ORACLE Description This is the description of the account Here you can enter the nature of the account like current savings overdraft and so on If a customer has two or more accounts under one account class you can specify the purpose of that account Account type You have to indicate whether the account is to be opened only by the account holder or whether it can be jointly operated Fund id Specify the id of the fund to be considered for report generation Country Code To define the country limits for each individual country you have to select the country code from the option list available Mode of Operation Select the mode of operation from the drop down list Account Open Date You have to capture the date on which the account was opened Alternate Account Number You have to define an alternate account number for the account you are defining The alternate account number that you specify should be unique for each customer You can capture the old account numbers used by your bank before installing the Oracle FLEXCUBE system The old account numbers would be mapped with the new account numbers This would facilitate quick track
197. oth at a transaction code level as well as at a product level In other words you can decide whether you would like to use the accounts for processing e Debit transactions 2 80 ORACLE e Credit transactions e Both The restrictions maintained for the account class will default to all the accounts that are linked to the account class At the individual account level however you can apply special conditions by changing the restrictions 2 81 ORACLE To maintain the restrictions click the Restriction button in the Islamic Customer Accounts Detailed screen The Products and Transaction Codes Restriction screen will be displayed Products and Transaction Codes Restriction Product Details Product List Allowed Disallowed Special Condition Applicable Not Applicable 10f1 pf Prous descinton own creat Oo Transaction Details Transaction List Allowed Disallowed Special Condition Applicable Not Applicable 10f1 Specifying Product Restriction Special Condition By default the restrictions maintained at the account class level will be displayed here When you define transaction code or product restriction attributes for an account itself rather than for the account class to which it belongs it is referred to as a Special Condition You can apply special conditions by selecting the option Special Condition Applicable at the account level If you opt to defin
198. ount class you can indicate so in the Islamic Customer Accounts Detailed screen by selecting the Lodgment Book option Consolidated Cert Reqd Check this box if you required consolidated certificate Back Period Entry Allowed You can choose to allow the posting of back valued entries into the account by enabling the Back Period Entry Allowed option If you choose not to restrict back period entries you will be allowed to post journal entry transactions to past periods as long as the account is open This specification is defaulted from the Islamic account class linked to the account You can choose to change it for a specific account While posting back valued transactions the System verifies whether the Back Period Entry Allowed option has been enabled for the account If the option has not been enabled an error message is displayed This check is also performed while uploading journal entry transactions ATM Details Specify the following ATM Enabling this check box indicates whether or not the accounts linked to the class will avail the ATM facility Branch Specify the branch at which the Islamic deposit customer is having the account Account Number You can indicate the account number of the Islamic deposit customer One customer can have any number of accounts 2 60 ORACLE The structure of the account number is defined in the customer account mask maintained in the Account Parameters sub screen of the Branc
199. ounts Maintenance screen Button Function Profit This invokes the IC Special Conditions Maintenance screen Charges This invokes the Account level Charges Condition screen Consolidated This invokes the Account level Consolidated Charges Charges Condition screen BIC This invokes the Authorised SWIFT BICs for Customer Account screen Deposits This invokes the Deposits screen Instructions This invokes the Account Operating Instructions Maintenance screen Standing This invokes the Instruction Diary Summary screen Instructions Linked Entities This invokes the Linked Entities screen REG This invokes the REG Details screen Account Status This invokes the Status Details screen Restrictions This invokes the Products and Transaction Codes Restriction screen Currency Limits This invokes the Currency Limits Details screen 2 65 ORACLE Button Function MIS This invokes the Management Information System screen Statement This invokes the Statement Details screen Limits This invokes the Account Limits screen Joint Holders This invokes the Joint Holders screen Fields This invokes the User Defined Fields screen Deposit Instruction This invokes the Deposits Instruction screen Billing Paramete
200. ovided there are no ad hoc liquidation s on an account during the quarter Having the periodic liquidation coincide with the Account Opening Date We have seen how periodic liquidation s can be fixed to begin on a particular date First Liquidation Date and happen at a definite frequency Instead of giving a First Liquidation Date and bringing all the accounts linked to the product to the same liquidation cycle you could opt to liquidate profit for accounts periodically according to a frequency determined by the Account Opening Date For example the liquidation frequency is defined as quarterly for a product starting from the Account Opening Date For each account the periodic liquidation will fall due a quarter from its Account Opening Date Thus there will not be a fixed periodic liquidation date for all accounts linked to the product it will depend on the Account Opening Date of each account Liquidation Before Month End While specifying the Mudarabah profit product preferences if you have set the profit liquidation frequency to a monthly yearly quarterly cycle you can choose to liquidate profit a specified number of days before the month end for all accounts linked to the product 3 21 ORACLE 3 1 10 You have to specify the number of days before which profit should be liquidated The system arrives at the profit liquidation date based on the number of days that you specify Let us assume that you would like to liquidate p
201. p Branch Indicate the branch to which the sweep is carried out Deposit Currency The currency in which the deposit is made Sweep To Account Indicate the account to which the sweep is carried out Sweep Amount This is the deposit amount Seq No The system generated sequence number for the instruction you are maintaining Tenor Tenor for the deposits that are opened under an account class Sweep Multiple Of The sweep can only be in multiples of the sweep specified Minimum Required Balance The minimum balance indicates that only the amounts above this limit will be used for auto creating deposits Source Code The code assigned for the sweep External Reference Number The external reference number Retry Till Date The instructions specified will be invalid after this date Any failed sweeps after this date will not be picked up for processing the next day Start Date 2 104 ORACLE 2 3 24 Specifying Billing Parameters Details Billing parameters are maintained through the Billing Parameters screen Click the Billing Parameters button in the Islamic Customer Accounts Detailed screen to invoke this screen Billing Parameters Branch Code Account Consolidating Branch Consolidating Account Consolidating Currency Billing Liquidation Settlement Branch Settlement Account Settlement Currency Direct Debit Payable Bank Account Name Agreement Id Billing Details 10f1 pmen rrasa PT L
202. pecify the weight for savings accounts falling under the chosen Mudarabah fund Id This field is available only if the product type is specified as Savings In this field you are not allowed to maintain the weight details for the TD and units tenor and weight details will not be allowed to maintain for Savings and current account classes 3 3 1 5 PPO Category Days You can specify the profit distribution frequency in terms of days You can specify any numerical value from 1 to 99 Months You can specify the profit distribution frequency in terms of months You can specify any numerical value from 1 to 12 Years You can specify the profit distribution frequency in terms of number of years Weight You can specify the weights for investment accounts having the particular profit distribution frequency 3 33 ORACLE 3 4 Profit Calculation Batch You can calculate the profit and as well as initiating distribution to depositors and shareholders for the Mudarabah fund using Profit Calc Batch screen You can invoke the Profit Calc Batch screen by typing ICDPRCBT in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button Profit Calc Batch Bank Local CCY Profit Calc Sequence Number Financial Cycle Period Code From To Mudarabah Fund ID Period Type Profit Equalization Amount Profit Equalization Amount Ley PEA for DEP Investment
203. pes e System Data Elements SDEs e User Data Elements UDEs In addition to specifying how the SDEs and UDEs are connected through the formulae you also define certain other attributes for a rule using the Profit and Charges Rule Maintenance screen You can invoke this screen by typing ICDRLMNT in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button Apply Interest Rule Id C On Account Opening Month eri Rule Description C On Account Closure Month Primary Element LM Parameters integrated LM Integrated LM Type x System Elements User Elements E system Elements E User Elements Get Latest E Use Effective Formas Feas Formula ate Input By Authorized By Modification Authorized Date Time Date Time Number Open 5 1 ORACLE You need to specify the following details On Account Opening Month Check this box On Account Closure Month Check this box SDE Maintain the following SDEs e DAYS e YEAR e DEPOSIT_AMOUNT The SDE DEPOSIT_AMOUNT holds the value of the TD account minus the redemption amount UDE Maintain the following UDE e MUDARABAH_RATE Type Select the option Rate from the adjoining drop down list Get Latest Select the option Use Effective from the adjoining drop down list Click Formulas button and invoke the Formulas screen 5 2 ORA
204. plays all the account classes linked to the selected fund Id Bank Local Currency The system defaults the bank local currency here and not the Branch currency The entire profit calculation will be done in this currency Product Type The system will default the product type based on the account class selected on saving the record e Savings e Current e Term Deposits 3 3 1 1 Broken Period Weight You can specify a weight in percentage that should be for calculating the profit when term deposits are redeemed before their maturity dates 3 3 1 2 Mudarib Fee Fee You can specify a fee in percentage that should be used as Mudarib fee for profit allocation calculation for the given pool code account class and currency combination 3 3 1 3 Value Category Amount Slab You can assign a weight to an amount slab For all investment wherein the amount falls in the particular slab the weight specified against the slab will be applicable 3 32 ORACLE Weight You can specify the weight for an investment falling under the specified slab 3 3 1 4 Tenor Category Units You can specify the frequency of the term deposit You can choose from the following option available in the drop down list e Months e Year Tenor You can specify the tenor of the term deposit TD Weight You can specify the weights for Investment accounts having the particular profit distribution frequency Savings Current Account You can s
205. positor s profit e Debit Choose this to deduct the IRR amount from the depositor s profit Ley Specify the IRR amount that should be deducted from the depositor s profit after allocation of PEA and before deduction of the Mudarib fee Alternatively if you have specified the IRR for depositor s investment the system will compute the IRR amount in local currency and display it here when you click the save icon 3 44 ORACLE IRR Specify the amount that should be considered for IRR deduction addition as a percentage of the depositor s profit The IRR amount in local currency will be computed based on this figure Alternatively if you have specified the IRR local currency amount the system will keep this field blank After specifying the IRR local currency even if you specify a value here the system will make it blank upon clicking the save icon Profit Apply Sequence Number When you click the save icon the system defaults the Profit Apply Sequence Number in this field When you click the authorise icon the system will re calculate the profit distributable to Shareholders and depositors and also the system will recalculate the profit and post the final adjustment amounts and the profit rates applicable to the individual accounts will be propagated Note the following e No more changes are allowed in the Profit Distribution Batch screen once the batch is submitted With Period type as Notional yo
206. product would be on 30 April The number of profit days for accounts for which the ad hoc liquidation was performed would be 16 The values for the SDEs applicable will also be picked up over this period For the other accounts the profit days would be 30 and the SDE values picked up would be for the entire 30 day period For a product you specify whether the account closing month has to be included for profit application Whether profit will be applied for the current month during ad hoc liquidation on 15 April in our example depends on this parameter for the product Profit for the current month will be applied during ad hoc liquidation only if the definition is that account closing month should be included for profit application If not the next automatic liquidation will process profit for the entire month First Liquidation On Once the liquidation frequency has been defined you should specify the First Liquidation Date The frequency and the date will be used to arrive at the first and subsequent dates of liquidation for the accounts linked to the product For example your quarterly liquidation cycle may be March June September and December and the liquidation is as of the month end For such a cycle you should indicate 31 March as the date of first liquidation during the year The subsequent dates will be automatically fixed by the system based on the frequency and the first liquidation date Similarly e If you want to liquid
207. r credit transactions after the last liquidation To view the turnovers for the account click the Turnover button The Customer Accounts Turnover Amounts screen is displayed 2 120 ORACLE MTD Account CCY MTD LCY After maintaining the required details you can return to the Amounts and dates screen 2 3 33 Maintaining Other Details for Islamic Deposit Account Using this screen you can maintain the following details for Islamic Deposit Account Maintain Credit Limit Liability details Maintain parameters for Joint Accounts Maintain Transaction Restrictions Maintain Account signatory details Maintain Account Statement details Specifying MIS details for an account Specifying payment and collection limits Specifying Regulation D applicability for a customer account Relationships for Customers For further details refer the chapter Maintaining Customer Accounts in the Core Entities User Manual 2 121 ORACLE Account Operating Instructions Maintenance Date of Last Maintenance Maintenance Instruction Conditions 1 Instructions 1 Conditions 2 Instructions 2 Conditions 3 Instructions 3 Conditions 4 Instructions 4 Conditions Elements Operators Value The sign on branch code is defaulted when you maintain a new instruction The current system date is also displayed You can select the customer account for which you want to maintain an operating instructi
208. racle Corporation and its affiliates will not be responsible for any loss costs or damages incurred due to your access to or use of third party content products or services
209. red A Notice to Receive message MT210 is an advance notification to your account servicing institution that it will be receiving funds that are to be credited to your bank s account with that institution For a nostro account you can specify whether the nostro agent your account servicing institution prefers to receive a Notice to Receive SWIFT message i e MT 210 when it is debited in the case of a funds transfer To indicate that the message MT 210 is to be generated by default whenever the nostro account is the debit account for a funds transfer select the MT 210 Required checkbox in the Customer Accounts Maintenance screen for the relevant nostro account 2 59 ORACLE If you indicate so an MT 210 is generated by default whenever this nostro account is being debited during the posting of accounting entries in any transaction This preference to generate an MT 210 by default can be over ridden when you enter a contract involving a debit to the nostro account Once you have specified this preference for a nostro account you can change it whenever necessary For instance if you have not specified that an MT 210 be generated you can unlock the record and specify the generation of MT 210 Conversely if you have specified that MT 210 generation is applicable you can unlock the record and specify that it is no longer applicable Lodgment Book If you wish to allow orders of lodgment books for all accounts that use this acc
210. redit entry is defined with IC Balance Inclusion option e EXTCHG External Charge You can charge the customer on the basis of the turnover of external transactions with a charge rate as 1 The turnover is always in the account frequency e ACCOUNT OPENING You can charge the customer at the time of opening an account Description Specify the description about charge basis Booking Account Type You have to identify the Booking Account Type depending on the IC product type you are creating If the Booking Account Type is Profit the Profit and Charge will be liquidated into the Profit Booking Account maintained in the IC Special Conditions Maintenance screen However if the Booking Account Type is Charge the Profit Charge will be liquidated to the Charge Booking Account that you identify in the IC Special Conditions Maintenance screen Rule Specify the rule to generate report The adjoining option list displays all valid rules maintained in the system You can choose the appropriate one Rule Description Specify the description about the rule 3 5 ORACLE 3 1 1 Maintaining Accounting Roles Accounting roles are maintained through the Accounting Roles screen Click the Accounting Roles button in the Islamic Profit Distribution Product Maintenance Detailed screen to invoke this screen Accounting Roles Product Code Product Description Class Details Class Code Class Description Roles
211. rency pair Beneficiary Details Indicate the following details Beneficiary Name Specify the name of the beneficiary for the redemption 4 28 ORACLE Passport IC Specify passport details for the beneficiary Narrative Give a brief description for the redemption Address Line 1 to 3 Specify the address of the beneficiary for the redemption 4 5 2 Savings Tab If means of redemption is Savings then click Savings tab Term Deposits Redemption Input Reference Number Branch Code Customer Id Currency Redemption Redemption Mode Redemption Amount Account Number Description Account Amount Action Flag Renewal Redemption Renewal Next Maturity Date Waive Compensation Tenor Days Months Waive Profit Redemption By Redemption By Bank Cheque Savings Savings Branch Savings Account Number Savings Account Currency Exchange Rate Savings Amount Narrative Maker Checker Years Savings General Ledger Bankers Cheque General Ledger Date Time Date Time Mod No Record Status Authorization Status You can capture the following details Savings Account Number Specify the account number into which the TD has to be liquidated The adjoining option list displays all valid savings accounts maintained in the system You can choose the appropriate one Savings Account Currency Based on the account number specified the account currency is displaye
212. rge start advice is to be sent Free Period Specify the number of days after the account opening date which constitute the free banking period for accounts under the class During the free banking period no charges are applied on the account Provisioning Details When you define an account class you can specify whether provisioning is applicable for accounts using the class You can make the following specifications in the Provisioning Details section in the Account Classes screen Required Check this box if provisioning is applicable 2 5 ORACLE Provisioning Frequency Select the frequency at which the provisioning would be done either daily or monthly The frequency you define here is only applicable if you have indicated individual account wise status processing for accounts in the Branch Parameters If you have indicated status processing at Group CIF level then the provisioning batch process executes at the frequency maintained in the Branch Parameters screen for your branch and not at the frequency maintained in the Account Classes screen Provision Currency You can indicate the currency in which the provisioning amount must be calculated either account currency or local currency This specification is defaulted from the preferences for the Islamic account class used by the account and you can alter it if necessary Exposure Category If the logic for deriving the exposure category of the CIF or cust
213. ride Years Profit Sharing Minimum Schedule Days Maximum Schedule Days Minimum Installment Amount Indicate the following details Allowing Auto Rollover of Deposits You can opt to automatically rollover a deposit if it is not liquidated on its maturity date Choose the Auto Rollover option to automatically rollover deposits opened under the account class Term deposits that are open and marked for Auto Rollover will automatically be rolled over during the Beginning of Day operations on the Maturity date You can define the terms and conditions for the new deposit while maintaining the deposit account in the Details for Deposit Type Account screen Close on Maturity Check this field to close the term deposit account on maturity date and transfer the amount to the principal liquidation account If you select this option the principal liquidation account should be an account other than the term deposit account 4 2 ORACLE Auto Extension You can specify whether prepayment needs to be allowed for the deposit accounts before the maturity date of the deposit However if this option is not checked the system will not allow you to redeem the term deposit before the maturity date The system also allows you to indicate whether the deposit created on this account class has to be extended to one more tenure principal only If you check this the term deposit will be closed on maturity after the completion o
214. roduct you have to map these Accounting Roles to the appropriate GLs maintained at your bank e The system allows you to select Close on Maturity box only when you specify the recurring deposit details You have to maintain deposit transaction code as DPN redemption transaction code as RED and prepayment transaction code as TRF for the recurring payments in the Branch Parameters for the Profit and Charges e All recurring deposit payments are part of IC batch beginning of day activity Installment Frequency Specify the following details Move funds on Overdraft Check this option to indicate whether the Recurring Deposit account funds should move to an unclaimed account if it is overdue 4 19 ORACLE 4 4 4 Days Here you have to specify the number of days to be considered in a month for component computation The options available are Actual This implies that the actual number of days is considered for calculation For instance 31 days in January 28 days in February for a non leap year 29 days in February for a leap year and so on 30 EURO In this case 30 days is considered for all months including February irrespective of leap or non leap year 30 US This means that only 30 days is to be considered for profit calculation for all months except February where the actual number of days is considered i e 28 or 29 depending on leap or non leap year The value selected here corresponds t
215. rofit one day before the month end You have to capture the following values in the respective fields Frequency Month 1 Liquidate before Month End Days 1 Consequently profit liquidation for the account associated with the product will be done a day before the month end Therefore in March profit will be liquidated on the 30 in April profit will be liquidated on the 29 However the value date of the profit will be the month end For instance if the profit is liquidated on the 30 of March the Value Date will be 31 of March Similarly if profit is liquidated on the 29 of April the value date will be 30 of April Back Value Recalculation Flag Check this box to indicate that for all accounts associated with this product the recalculation of profit needs to be done and the difference in profit adjusted during the next liquidation as an profit adjustment entry when an accounting entry is passed into the previous liquidation period If you need to link this product to a Term Deposit account class you need to check this box This will help in recalculating profit during partial redemption of a TD Defer Liquidation and Defer Liquidation By Days You may wish to defer the calculation and liquidation of periodic profit on an account for a few days beyond the end date of each profit period This deferment will allow the inclusion of profit adjustments due to back valued entries posted into the acco
216. ropriate icon in the horizontal array of icons in this screen For a profit or charges product in addition to these generic attributes you can specifically define other attributes These attributes are discussed in detail in this chapter You can define the attributes specific to a profit and charges product in the Mudarabah Profit Distribution Product Definition screen and the Profit and Charges Product Preferences screen In these screens you can specify the product type and set the product preferences respectively For further information on the generic attributes that you can define for a product refer the following Oracle FLEXCUBE User Manuals e Products 3 1 ORACLE e Settlements Product Code The code of the Charge product for which you are defining preferences is displayed in this field Description Give an appropriate description for the Product Code defined Product Type By default the product is Profit You will not be able to modify the same You must link the product to a Profit Rule that you have already maintained To recall a Profit Rule identifies the method in which profit is calculated When you apply this profit product on a Mudarabah account or Mudarabah account class profit is calculated for the account according to the method specified in the Profit Rule When you link a Profit Rule to the product the description of the rule will be displayed Slogan Enter a slogan for th
217. rs This invokes the Billing Parameters screen Account Signatory This invokes the Signatory Details screen Interim This invokes the Interim Transactions Report screen Transactions Report Notice This invokes the Notice Preference screen Cards This invokes the Cards Summary screen screen OFAC Check This invokes the External System Details screen Change Log This invokes the View screen 2 66 ORACLE 2 3 5 Specifying Profit Details You can capture details of special condition for the account using the IC Special conditions Maintenance screen To invoke this screen click the Profit button in the Islamic Customer Accounts Detailed screen IC Special Conditions Maintenance Account Details Branch Code Account Calculation Account Profit Booking Account Charge Booking Account Consolidated Charge Account Profit Statement Profit Start Date Charge Start Date Profit Booking Branch Charge Booking Branch Dr Cr Advices Consolidated charge branch Product Details Product Code UDE Currency Waive Profit Generate UDE Change Integrated LM Product Advice IL Product Type Open Effective Date 10f1 gt ON A E UDE Values ld 10f1 gt Di m User Defined Elementid UDE Value Rate Code TD Rate Code hemer The following details are captured here Branch Code The current
218. rule These operators are used in combination with the elements discussed earlier The following is a list of logical operators that you would require to build a status rule AND The conjunction and OR The conjunction or gt Greater than gt Greater than or equal to please note that there is no space between the two symbols lt Less than 2 34 ORACLE AND The conjunction and lt Less than or equal to please note that there is no space between the two symbols lt gt Not equal to please note that there is no space between the two symbols Equal to 2 35 ORACLE 2 2 15 Specifying Amount Block Details The allocation of funds will occur as per the product sequence you maintain in the Amount Block Details screen invoked from the Islamic Account Class Maintenance screen Click the Amt Block button to access this screen Amount Block Details Account Class Description Product Maintenance 10f1 L In this screen you will specify the sequence of products based on which funds will be made available when a credit is posted to an account with a track receivable option The sequence number is automatically generated by the system All authorized products of your bank will be available in the option list On selection of the product the product description will appear alongside Whenever a credit happens
219. ry limits for each individual country you have to select the country code from the option list available Mode of Operation Indicate the mode of operation Choose one of the following options from the drop down list e Single e Jointly e Either Any one or Survivor e Former or Survivor e Mandate Holder Account Open Date You have to capture the date on which the account was opened 2 48 ORACLE Alternate Account Number You have to define an alternate account number for the account you are defining The alternate account number that you specify should be unique for each customer You can capture the old account numbers used by your bank before installing the Oracle FLEXCUBE system The old account numbers would be mapped with the new account numbers This would facilitate quick tracking of the account and generating queries In the Data Entry Module you can input a transaction using the alternate account number instead of the actual account number Clearing Bank Code The clearing bank code for the customer account is generated automatically if you have opted for auto generation in the Branch parameters Clearing Account Number The clearing account number for the customer account is generated automatically if you have opted for auto generation in the Branch parameters The account number is created according to the account mask you have maintained for the branch This will be mandatory and has to comply with length of 9 characters
220. s First Liquidation On Start Date Start From Account Opening Refund Tax on Pre Closure Defer Liquidation Days Defer Before Month End Days Liquidation at Month Ends Back Value Recalculation Flag Defer Liquidation Liquidation Before Month End Zakat Product 10f1 imi Account Class Special Condition Only Repopulate at Liquida Ei Here you can specify preferences for profit calculation and application on the accounts to which this product is applied Account Details You can indicate the TD accounts on which this product should be applied Account Class Specify the account class of Deposit type that you have maintained for creating TDs The adjoining option list displays all valid account classes maintained in the system You can select the appropriate one All TDs created under this account class will inherit the profit parameters maintained in this screen 4 8 ORACLE 4 4 Refer the chapter Creating an Islamic Profit Distribution Product in this User Manual for details about setting up the product Creating Islamic TD You can create a term deposit account using the Islamic TD Accounts Maintenance screen To invoke this screen type IADCUSTD in the field at the top right corner of the Application tool bar and click the adjoining arrow button islamic TD Accounts Maintenance Branch Code Customer No nt Customer Name Currency
221. s Customer List screen will be invoked Account Class Customer List Account Class Description l Category Customer Selection Indicator Allowed Disallowed Customer Categories Customer Catageory IE Cancel In this screen you define the following A list of allowed or disallowed customer categories e A list of disallowed customers if any under the allowed category For an account class you need to specify the customer categories that should be linked to it and also customers within a category who should not be allowed to be linked to this account class Example Requirement You are capturing the features of a Nostro account class called NostroLCY you would like to Associate the customer category called Banks with NostroLCY e Disallow a customer called Midas Bank associated with the customer category called Banks from using the features of this class Grant your customer Morgan Stanley linked to the customer category called Financial Institutions all rights associated with NostroLCY Procedure In the Selection Indicator field click on Allowed since your allowed list is smaller and therefore easier to indicate 1 Highlight and select the Customer Categories called Banks and Financial Institutions in the Available Categories list and click the adjoining arrow 2 Next highlight Financial Institutions and click adjoining arrow against Customers It w
222. s Total PEA GL ADJ Share Holders ADJ Total ADJ Weights in EFF WTS Profit Distributable for Depositors Profit Apply Seq No Maker Checker Total Profit Total Profit ADJ Profit After ADJ Share Holders Depositors Total PEA ADJ Amount Depositors Profit After PEA Total Fee Amount Depositors Profit After Fee Total Adhoc ADJ Amount Depositors Profit After IRR Profit Equalization Ley PEA for DEP Investment Investment Risk Ratio Date Time Credit Debit Mod No Date Time Record Status Authorization Status You can capture the following details in this screen 3 6 1 1 Period Code From The system displays the previous month s period code from which the profit needs to be shared 3 40 ORACLE To The system displays the previous month s period code until which the profit needs to be shared Bank Local Ccy The system displays the local currency of the bank Financial Cycle The system displays the previous month s financial cycle Period Type Specify the type of period for which the profit sharing needs to be done You can choose any of the following options available in the drop down list e Notional e Actual Mudarabah Fund ID You can specify the fund id for which the profit calculation to be done from the option list The option list displays all fund Ids for which the profit has to run for the period codes However if the profit distribution is
223. s for Customer Account screen Click the BIC button in the Islamic Customer Accounts Detailed screen to invoke this screen 2 72 ORACLE Authorized SWIFT BICs for Customer Account Account BIC Codes 10f1 pmj ccoo T oeseroson OO O 0O You can enter the following details in this screen Account Number The system defaults the account number of the customer in this field BIC Code Specify the BIC here You can choose any valid BIC maintained in the BIC Code Maintenance screen Description The system displays the description for the corresponding BIC that you have specified 2 3 9 Specifying Deposits Details Click the Deposit button in the Islamic Customer Accounts Detailed screen to invoke Deposits screen for additional information relating to the handling of the deposit The Deposits screen will be displayed 2 73 ORACLE Auto Deposit Balance Sweep Type Master Account Number Rate You can enter the following details in this screen Auto Deposit Balance This indicates the amount that got auto deposited into the account Sweep Type The drop down list shows the following values e 1 No sweep e 0 Default from A c e 1 Sweep if instructed Master Account No Specify the master account number for the deposit account simulated Rate Select the rate to be applied for the conversion The options available are Buy rate Mid Rate or the Sell Rate 2 3
224. s 2 36 2 2 16 Specifying Statement Details ccsccccscscesccsseeseseescesecssesecncceceeseeceesecaeesecsaeeeeaseaceeeaseeeaeeaeesesaeeseees 2 39 D217 Specifying Notice Details ss sccsisicssscstiiesscasestbecssisias lapeuah ites a oldu dasecdeet gee Eaa 2 42 2 218 Specifying Fi lds Details i ccsssecvssnensesetesisevavceveelaswsduevonvostessbvel sonsacsedutsavbebeveieentevervaluevsateabevseteneaves 2 43 2 2 19 Triggering a batch for accounts eligible for profit sharing ceccsscsessssseseceseeeeeseescesecutesecneeeeesaeenes 2 43 2 3 MAINTAINING ISLAMIC CUSTOMER ACCOUNTS cccccssessessssesseesseesseessseaseessecaseessecasessacassessaaseessaeasesiaeas 2 44 2 3 1 Main Tabene voneseaeseuss teste dsvaes by Seusveasenactetel E E A EA RR EA EEEE 2 48 2 3 2 AUKNA TAD oeiee e tues eet Cause secwtesees dacevoencances EEan e testes teens ou GGasec usin E S Aea 2 55 2 3 3 Nominee Tabiini a i a RE E AE EEEE EAE A EA aR EEEE 2 64 2 3 4 Capturing Additional Details vess ieseseirereiiisur eii sep eoutecs shad Dell aiseee i aein a a enaA 2 65 2 3 5 SPECI VING Profit Details eoii i i AEN R EE E EAEE 2 67 2 3 6 Specifying Charges Details risisti iinei E E E E EEA E ERE 2 69 2 3 7 Specifying Consolidated Charges Details ccccccccesccsssscssesseeseeseesecseeeccesecseeeceeceaeeeceaeeseeseeaeeeenaes 2 71 2 3 8 Specifying BIC Detail ss vwicciscsseae irinari ube EE EEE A EE A EEA EREE EARE 2 72 2 3 9 Specifying Deposits Details sissies ainei AE EAEE AE EAE EREE 2 7
225. s not liquidated immediately but tracked in a Receivable GL for manually debiting to the customer account at a future date You need to specify the Receivable GL to be used for this purpose If you do not then profit for a particular period is liquidated with the value date as the first day of the next period irrespective of your preference for deferring liquidation The functionality of tracking Debit profit in the Receivable GL is explained earlier in this chapter under the heading Identifying the Suspense GL to store debit profit on Customer Accounts 3 1 12 UDE Amounts Currency A User Data Element could be of Amount type when it indicates either a tier structure a slab structure or just an amount that you would want to use in a formula The UDE Currency is the currency in which these amounts will be expressed for the product you are defining When profit is calculated for the accounts the UDE will be taken to be in the currency that you specify here which could be either the local currency or the account currency The following example illustrates how this concept works Example You want to apply profit on the monthly minimum credit balance in Smart Save savings accounts You want to pay profit according to the following tier structure gt 5000 lt 10000 5 gt 10000 lt 20000 5 5 gt 20000 lt 50000 6 gt 50000 7 5 3 25 ORACLE 3 1 13 You would define the limits o
226. s that are sent to the customer by enabling the check box positioned next to the Display IBAN on Advices field If the Display IBAN on Advices check box is disabled you can enable this option by checking the box Consequently the IBAN Account Number will be printed on all customer correspondence Debit Credit advices involving the particular account Because of choosing to print IBAN numbers in the correspondence sent to the customer the Oracle FLEXCUBE account number will be replaced by the IBAN number The lists of SWIFT messages that will include IBAN account numbers are as follows e MT940 Customer Statement Message e MT950 Statement Message e MT900 Confirmation of debit e MT910 Confirmation of Credit While processing incoming payments the system checks to see whether the account involved is an IBAN account If the account is an IBAN account it will be processed with the corresponding Oracle FLEXCUBE account number Secondary A c Statement This refers to the type of statement to be generated periodically by the system for this account You can specify whether you want a detailed or summary statement or if you do not want a statement for this account at all Cycle You can specify the frequency for generating the account statements To specify the frequency of the statements click on the adjoining drop down list The following list is displayed e Annual e Semi annual e Quarterly 2 93 ORACLE e Mon
227. s will be NORM Normal by default The Status Since field will display the current system date that is the date on which the account is maintained in the system The system will update the status whenever a status change occurs Therefore at any point of time this field will display the current status of the account The Since field will reflect the date on which the account moves to the current status Subsequently the system will default the value of CIF Status as available in the Customer Maintenance screen This status is the worst status among all the finances savings accounts and current accounts for the customer in the current branch This is done if you have opted for status processing at the Group CIF level as part of your branch preferences Since The date on which the status of the account is changed to the current status is displayed here Propagate Reporting Details This field indicates whether the reporting lines defined for status movement for the account class that this account reports to must also be applicable to it The following GL s are defined in the Account Class Maintenance for posting account balances when a status movement occurs on any accounts belonging to the account class e The Debit and Credit GL s to which account balances must be posted for movement to each status e The Central Bank Reporting Debit and Credit GL s e Head Office Reporting Debit and Credit GL
228. se GL to Store Debit Profit on Mudarabah Customer Accounts 0 000 3 18 3 1 9 Liquidation Related Details csccscesccssessssssessesecssesscuseenesseescesecasesecsceseessescenesaseasaesacesecaeeseseesneeees 3 18 3 1 10 Refunding Tax on Preclosure of a Term DepoSit cecceccssssesscssesnsesecssesecuseeecnseeseeseeaeesesaeeeeenaseneaees 3 22 3 1 11 Deferring the liquidation of periodic profit on a CASA ccsccessssesecsseseesetieeeecuseeeenseeseeaeeateseseeeeens 3 24 3 1 12 UDE Amounts CUITONCY issis ae nonn Ee Nea ER E EEEE E N EN a aaRS 3 25 3 1 13 Repopulating the UDE values at Rollover osoeesesneneeeneneesereseeeernsrrnresrsrresenresrnsrrnrerrrrresenreeresene 3 26 3 2 CREATING A PROFIT PRODUCT FOR ZAKAT COLLECTION ccccccccccssessssssecececeesensecesececeesssesesececeesenseaeeeeees 3 26 3 2 2 Specifying status codes for an ACCOUNE sccesecssesscssessesscusesscseescesecasesecacesecsseeeesaeeseesesateeesaeeneeeenaes 3 29 3 3 MAINTAINING INVESTMENT WEIGHTG ccsescccececsessssscecececeeseaecesececeessneeecececeeseseaesecececeeesaeseeseeesenseaess 3 31 3 4 PROFIT CALCULATION BAT GH eisiccccccvedssicusechectesds cacueescsdeasdacadeneoeavaesacec EE EE aN a EEEa 3 34 3 5 UPDATING PROFIT CALCULATION cccsesssseeececsesseaesecececeessaaecececeesensaassecececeeseaaeseeececeeneaasaeseeeeeenenseaeeeeess 3 37 3 6 PROFIT DISTRIBUTION BATCH s2ssis cc ieee dicusseccctesaincseceeedsss casdecadeeusesdesndedad essusaasoudencdesesssa
229. sit Tad i sccscccccsccescssecscesscsseescsseessesecsceecsseeseaeesessecasesecseeeecaeeeesaecaeeseeaeeaaeseeneeees 4 20 ORACLE 4 4 5 Capturing Additional Details ccccccccesccsssscsessssseeseeseeseesecssesecsseessssesceseesaeesesaecaeesecaeeseseaeeeseaseaseas 4 22 4 4 6 Specifying Profit Details sisine kinie neasi ia a E E o a S 4 23 4 5 REDEEMING A U D E E E 4 25 4 5 1 Banka Cheque Taby egi E A E E E EE E EE RE 4 28 4 5 2 SAVNES TAD ioner eae a e E e E teed e a E R NEE 4 29 4 5 3 General Ledger Tab sssrinin aai i er E E E E AES 4 30 4 5 4 Authorizing TPANSACHON sissien se ioaea aenea ii iE EN E S 4 31 4 6 VIEWING TD REDEMPTION DETAILS ccccccccccessessssssecececeessnascececeesensaassesececeesesaeaeseceesessaaeaesececeesensnaeeeeees 4 33 47 REDEEMING TD PARTIALLY ccccccccccecsessssscecececsesseaececececeeseaecececeesessuaesesececeeseaeseseceesessaaeaesecseeesensnaeeeeees 4 34 5 ANNEXURE A IC RULE SET UP siissscsssscscsssssscscsssscsscessescascecessssveascsesssasesoeessascessessessesssvecosseauseescesessaeassenes 5 1 5 1 INTRODUCTION aeree ere N S EA Aes du bees cocks OAE OES AASE 5 1 5 2 TC RULE MAINTENANCE oreet ar aaee EN O A AEEA ENEA E AAEE TOENE EA EEE 5 1 5 3 UDE VALUE MAINTENANCE seiirt e a E A AE A nae aE EN a 5 5 5 3 1 TD with CGPuUGliZzati OMties ses cc csscesssevasesonevonssacuuetanis otevesebestsnesusteaweasiesueetuctsvubeucwestebevsbesa se etes RE 5 6 5 3 2 Normal TD with Simple Profit sc seccscccssiwscvsssssoncntev
230. sits screen GL Lines This invokes the GL Lines screen Status Rule This invokes the Status Rule Definition screen Amt Block This invokes the Amount Block Details screen Statement This invokes the Interim Transactions and Balance Report screen Notice This invokes the Notice Details screen Fields This invokes the User Defined Fields screen 2 2 4 Specifying Restrictions Details 2 13 ORACLE You can place restrictions on transactions involving Islamic accounts at the account class level As discussed earlier for customer account these restrictions get defaulted to all accounts that are linked to the Islamic account class But you are allowed to change these restrictions for individual accounts as well 2 14 ORACLE To maintain the restrictions click the Restriction button in the Islamic Account Class Maintenance screen The Account Class Product and Transaction Codes Maintenance screen is displayed Account Class Product and Transaction Codes Maintenance Account Class Product Details Transaction Details Product List Allowed Disallowed Products and Transaction Codes 10f1 Li Exclusion Criteria For Profit Sharing The restrictions can be based on e Products e Transaction Codes Validation of restrictions During maintenance or online operations in the respective contract screens for the restricted transactions when you speci
231. splayed in this screen Description The following details are defaulted from the account class maintenance level However at the account level you are allowed to modify this Advance Profit Check this field to levy the advance profit on the account Note the following e The customer is liable to pay this advance profit in case he she fails to provide the required notice to the bank e The system deducts the advance profit from the credit profit earned by the customer on his her credit balance in the account Monthly Free Amount Specify the amount that the customer can withdraw per calendar month from his her savings account without being liable to pay advance profit Notice Days Specify the number of days before which the customer should notify the bank if he she wants to withdraw an amount more than the Free Amount from his her account 2 42 ORACLE Validity Period Specify the validity period in number of days During this period the customer can do the withdrawal of the amount for which he she notified the bank This screen is applicable only for saving type of account 2 2 18 Specifying Fields Details User defined fields are maintained through the User Defined Fields screen Click the Fields button in the Islamic Account Class Maintenance screen to invoke this screen User Defined Fileds x Field Name Value 1of1 UDF Details 2 2 19 Triggering a batch for a
232. stem if required 2 45 ORACLE You can invoke the Islamic Customer Accounts Detailed screen by typing IADCUSAC in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button Customer Accounts Maintenance Branch Code Customer No Account Customer Name Currency SD User Reference Account Class Main Auxiliary Nominee Check List Description Statuses Dormancy Parameters Account Type Fund Id Country Code Mode of Operation Account Open Date Alternate Account Number Clearing Bank Code Clearing Account Number IBAN Account Number Address Single Joint No Debits No Credits Stop Payments Location Media Linked Deposit Branch Dormant Linked Deposit Account Frozen Zakat Exemption Posting Allowed Status Change Automatic Overdraft Contribute to PDM Exclude from Distribution Options mma ee ce Track Receivable Referral Required IBAN Required Replicate Customer Signature Salary Account Account Set for Closing Closing Date Turnover Limit Preferences Status Details Status Turnover Limit Code Since Propagate Reporting Details Account Auto Closed Account Derived Status Pron caraos consoneied Chrges eic T bepoats nsuctons Stndng instructions Unked Ens RES Account Stats Resticons currency ums mus sateen Limits Jone oters es T beposisstructon Buina Parameters
233. t Code5 For an account the transaction type of MIS class will be picked up from the account class along with the cost codes and pool codes The composite type of MIS class will be defaulted from those defined for the customer These too can be changed 2 21 ORACLE 2 2 9 Specifying Preferences Details To set preferences click the Preferences button in the Islamic Account Class Maintenance screen The Preferences screen is displayed Preferences Preferences Profit Calculation Balance Basis Mudarabah Fund Id Cash Reserve Ratio Limit Check Overdraft Facility Pass Book Facility Track Receivable Account Statistics Exclude Same Day Reversal Transactions from Statement Back Period Entry Allowed No of Days For Salary Block No of Days For Closing Unauthorized Accounts With No Activity No of Days For Closing Authorized Accounts With No Activity Profit Statement Available Balance Check Required Referral Required Status Change Automatic Consolidation for Inward Clearing Profit Charges Track Accrued Interest Debit Credit Advices Posting Allowed Lodgment Book Replicate Customer Signature Cheque Book Preferences Integrated Liquidity Management ATM Reorder Level Reorder No of Leaves Max No of Cheque Rejections Exclude from Distribution Cheque Book Auto Reorder of Cheque Book Preferences are the options or attributes that uniquely distinguish
234. t Status Currency Limits mis Statement Limits Joint Holders Fields Deposits instruction Billing Parameters Account Signatory Interim Transactions Report Notice Cards OFAC Check Change Log Maker Date Time Mod No Checker Date Time Record Status Authorization Status Click Nominee tab in the Islamic Customer Accounts Detailed screen The fields in the Nominee section are as follows Nominee Details Name Specify the name of the nominee Date of Birth Specify the date of birth of the nominee Relationship Specify the customer s relationship with the nominee Address 1 2 3 and 4 Specify the address of address of the nominee Four lines have been provided for this Each line can have a maximum of 35 characters alphanumeric Minor Check this option to indicate that the nominee is a minor Guardian Name Specify the name of the guardian of the nominee if the nominee is a minor You can capture the name of the legal guardian not exceeding 35 characters alphanumeric 2 64 ORACLE 2 3 4 Relationship Specify the nominee s relationship with the guardian Address 1 2 3 and 4 Specify the address of address of the guardian Four lines have been provided for this Each line can have a maximum of 35 characters alphanumeric Capturing Additional Details You can capture additional details for the Islamic Customer Accounts by clicking the following buttons in the Islamic Customer Acc
235. t maintained for the currency it will consider the CRR specified for the account class a whole It deducts the computed cash reserve amount from the account balance before applying weights in profit distribution 3 35 ORACLE The system considers the account balance after deduction of cash reserve ratio for depositor s investment in profit sharing 3 36 ORACLE 3 5 Updating Profit Calculation You can view the details of all account class using Profit Calc Update screen by selecting a record the system populates all the details You can invoke the Profit Calc Update screen by typing ICDPRUPD in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button Profit Calc Update Mudharabah Fund ID Z Mudarabah Fee Period Code Mudarabah Fee LCY Financial Year Adj Mudarabah Fee LCY Product Type Profit After Mud Fee ADJ Amount Slab ADJ Annualized Rate in Tenor Annualized Rate Before ADJ in PPO hts Profit Amount Weights i Ann rate After Adhoch ADJ LCY Amount After Weights FAR i Profit Amt After ADHOC ADJ LCY AMT Before Weights Ann rate after mudfee ADJ TD Type Adhoc ADJ amt Period Type To Period Code Account Class az Account Currency Input By Authorized By Modification Authorized eat Date Time Date Time Number Open The following details will be populated in the screen Account Class
236. t period till partial redemption date by considering the redemption amount as the TD amount for the reduced tenor It applies the broken weight during profit recalculation and arrives at a certain amount say Amount It recalculates the profit for the remaining amount from TD start date till the last liquidation period by considering the remaining amount as TD balance for the original tenor of TD and arrives at another amount say Amount2 In case of TD pay outs the system captures the profit amount paid to the customer till date say Amounts If the profit for the previous periods has been already paid to the customer then the customer will be debited with the difference amount between already liquidated amount till the last liquidation date and the newly recalculated profit for redemption amount and remaining amount This means the customer will be debited with Amount3 Amount1 Amount2 The balance amount after partial redemption will be considered as the new TD with the original TD tenor by the system 4 34 ORACLE 5 1 5 2 5 Annexure A IC Rule Set up Introduction This Annexure lists the Profit and Charge IC rules that need to be maintained for the Islamic TD module of Oracle FLEXCUBE specifically for partial redemption of TD IC Rule Maintenance The components required to calculate profit the principal period and rate are broadly referred to as Data Elements Data elements are of two ty
237. t which affects the annualized percentage of profit Specify the adjustment amount here Profit Amt after ADHOC ADJ The system displays the total amount of profit distributable to the account class after doing the adhoc adjustment Ann rate after ADHOC ADJ The system indicates the annualized percentage of profit after doing the adhoc adjustment Annualized Rate Before ADJ in The system displays the Annualized rate before the before the Mudarib fee PEA and Adhoc adjustment ADJ Annualized Rate in The system displays the final adjusted value of the annualized percentage after Mudarib fee PEA and Adhoc adjustment Non Editable 3 39 ORACLE 3 6 Profit Distribution Batch Profit sharing for a Mudarabah fund is primarily driven by the weights ratio between depositors and shareholders in the fund As mentioned before the weights for deposits are maintained in the Weights Maintenance screen You can capture the weight for shareholders and also compute the profit for depositors and shareholders in the Profit Distribution Batch screen You can invoke the Profit Distribution Batch screen by typing ICDPRABT in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button Profit Distribution Batch Period Code From To Bank Local CCY Financial Cycle Period Type Mudarabah Fund ID Leopulate Total Investment PEA GL IRR GL Share Holders Depositor
238. tails viz Direct Debit Bank Code Account Name and Agreement ID fields e If you choose Manual option then manual liquidation is possible only under the following four modes gt By Cash through retail teller product gt By Clearing through outward clearing product gt By Transfer debit account in CASA module gt By Direct Debit through PC module If the consolidation account is different from the present account then the system uses the liquidation parameters specified at the consolidation account level and liquidation parameters specified if any at this account level is ignored Settlement Account As mentioned above you need to specify the settlement account to enable automatic liquidation of billing For liquidating the billing amount and also for collecting the bill amount the system makes use of the account specified here Maintaining direct debit details If you have maintained the mode of settlement for auto liquidation of bills as Direct Debit instructions you need to specify the following details e Payable Bank Choose the bank from the option list This indicates the bank code of the settlement account e Account Number Specify the account number for the settlement account e Name Specify the name of the debtor e Agreement ID Specify the agreement id on which the DD is to be generated During liquidation the direct debit contract is uploaded into the system in case you have
239. tain a new instruction The current system date is also displayed You can select the customer account for which you want to maintain an operating instruction from the available option list On selection of the account the description gets displayed in the adjacent field At the time of maintaining an instruction you can also specify a condition for displaying the instructions when transactions pertaining to this account are being processed The instruction will be displayed to you when the condition is satisfied 2 75 ORACLE 2 3 11 Specifying Standing Instructions Details Instruction summary are maintained through the Instruction Diary Summary screen Click the Standing Instructions button in the Islamic Customer Accounts Detailed screen to invoke this screen instruction Diary Summary Here you can view the following details e Authorization status e Record status e Instruction number e Unit type e Unit value e Branch code e Instruction e Instruction type 2 3 12 Specifying Linked Entities Details A customer of your bank can have relationships with any other customer of your bank Also a customer of your bank could be a joint account holder with another customer of your bank You can capture these details when you set up the CIF or customer account 2 76 ORACLE For linking a customer account you need to specify details of the relationship for the account Click the Linked Entities
240. the available balance not the current balance while performing the referral checks for all transactions involving the account If a transaction involving the account results in the account moving to overdraft the account and transaction details will be sent to the Referral Queue 2 23 ORACLE Status Change Automatic If you check this option the status of the account will be changed automatically by the system as per the conditions maintained in the Status Rule Definition screen If you do not select this option you have to change the status manually through the Manual Status Change screen These screens are discussed in detail in the subsequent sections of this document This specification will be defaulted to all the accounts reporting to this account class Integrated Liquidity Management Check this box to generate integrated liquidity management ATM If checked it indicates that accounts linked to the class will avail the ATM facility Consolidation for Inward Clearing You need to indicate whether or not consolidation is required for inward clearing transactions in a batch at the Account Class level The indication for this option is carried forward to the Islamic Customer Account Maintenance screen If this option is unchecked here it cannot be checked in the Islamic Customer Account Maintenance screen Profit Charges If checked it indicates that for profit and charges computation the Profit and Ch
241. ther the parent account class is maintained in the fund online If the parent account does not exist the system displays an error message 2 53 ORACLE You cannot close a parent account unless all child accounts are inactive However you can create multiple parent accounts for same fund and customer combination Zakat Exemption When an account is opened in a branch you need to clarify with the customer whether he or she will pay Zakat or will seek exemption Check this box to indicate that the customer seeks exemption from Zakat charge Options Track Receivable During liquidation of finance contracts as well as processing of retail teller contracts if the system detects insufficient funds in the settlement account then you can choose to block the subsequent credit that happens to the settlement account In other words the system will track the account for receivables credits As and when a credit happens the funds will be allocated to the finance or retail teller contract for liquidation If the track receivable option is checked for the account the system will track the receivables for the account if sufficient funds are not available in the account The allocation of funds will happen in a sequence that you specify at the account class level This is explained in the section titled Maintaining Account Classes Referral Required Referral refers to the process of handling customer transactions which force the accounts in
242. thly e Fortnightly e Weekly e Daily On For a weekly statement you specify the day of the week on which account statements should be generated and for fortnightly and monthly statements the dates of the month To specify for weekly statements click on the adjoining drop down list The following list of days will be displayed e Monday e Tuesday e Wednesday e Thursday e Friday e Saturday e Sunday To specify for monthly statements enter a number between 1 and 31 corresponding to the system date If you set the statement date to 30 then account statements will be generated on e The last working day for months with lt 30 days e For months with 30 days on the 30th if 30th is a holiday on the next working day If you set the statement date to 31 then account statements will be generated on e The 31st for month with 31 days if 31st is a holiday on the next working day e The last working day for months lt 31 days For a fortnightly statement you could specify 1 and 15 For all other cycles account statement will be generated on the last day of that cycle Generate Stat Only On Movement You can indicate that an account statement should be generated for the customer s account only when there has been a movement of funds into the account or when funds have been transferred out of the account 2 94 ORACLE For instance let us assume that on the August 21 2001 you have set the account statement generation frequ
243. tion code If you have indicated to allow Dr Transactions for the product ABCD and attempt to post a credit entry the system will seek an override You can continue the transaction despite the restrictions by providing appropriate reasons for the same During maintenance or online operations in the respective contract screens for the restricted transactions when you specify the customer account the system checks whether the account is restricted for the product that has been selected or the debit credit transaction type If so an override is sought when such contracts are saved Cr During transaction processing the system will validate whether any restrictions are placed on the account based on either product and or transaction code If you have indicated to allow Dr transactions for the product ABCD and attempt to post a credit entry the system will seek an override You can continue the transaction despite the restrictions by providing appropriate reasons for the same During maintenance or online operations in the respective contract screens for the restricted transactions when you specify the customer account the system checks whether the account is restricted for the product that has been selected or the debit credit transaction type If so an override is sought when such contracts are saved 2 83 ORACLE Specifying Transaction Restriction Special Condition By default the restrictions maintained at the account class l
244. tions e Pay In By Account e Pay In By GL Escrow Transfer Details Specify the following details 2 62 ORACLE Escrow Transfer Applicable This box is checked by default if the customer account belongs to an account class for which Escrow transfer is enabled This box should be checked for Project Trusted account s only Branch Code Select the branch code in which the Escrow account has to be created from the adjoining option list Escrow Account Select a valid account to be used as an Escrow account from the adjoining option list The list displays all valid accounts based on the selected Escrow branch and the currency of the project account Escrow Percentage Specify the percentage of the credited amount which has to be transferred to the Escrow account The Escrow percentage specified here will be same for all transactions and will not vary for different credits like cash cheque draft etc 2 63 ORACLE 2 3 3 Nominee Tab Customer Accounts Maintenance Branch Code Customer No Account Customer Name Currency SD User Reference Account Class Main Auxiliary Nominee Check List Nominee Details Name Date of Birth Relationship Address1 Address2 Guardian Name Relationship Address1 Address2 Address3 Address3 Address4 Address4 Minor Profit Charges Consolidated Charges BIC Deposits instructions Standing Instructions f Linked Entities REG Accoun
245. titled Deposit_Amount is used Bearing Products In case you choose bearing product as the payment method the system books the TD without liquidating the profit for the account The end of day process accrues the profit and at BOD liquidation will occur based on the maturity date 3 1 8 Identifying the Suspense GL to Store Debit Profit on Mudarabah Customer Accounts Before applying debit profit on personal current accounts you can choose to notify your customers through Debit Profit Notification messages In the interim period profit is debited from a Receivable before actually debiting the customer account While specifying preferences for Profit products you can identify the Receivable GL which is to be used for storing debit profits on a temporary basis Debit profit notification preferences are specifies for an account class through the Mudarabah Account Class Maintenance screen You can specify the Receivable GL only for products linked to rules having debit formulae This feature is applicable only for the debit profit on the account calculated through the IC module Refer the Daily Processing of Profit and Charges for information on End of Day processing for Debiting Receivable GL 3 1 9 Liquidation Related Details Just as you defined the accrual related details for account classes linked to a product you should define liquidation related details as part of preferences for the product You can liquidate profit for
246. to delete your specifications Save your specifications Defining Preferences for Mudarabah Profit Products While creating Mudarabah profit product you identify one rule or profit calculation method that you would like to use to calculate profit for the product In linking a product to a rule you identify how the principal period and rate components are to be picked up from accounts on which the product should be applied You need to click the Preferences button and invoke the Profit Preferences screen to specify the profit accrual and liquidation details for the product These specifications are referred to as Preferences In addition you also make the product applicable on an account by linking an account class or an account itself to the product For a profit product you can define the following preferences e The Mudarabah account class and currency combination on which you would like to apply the product e Accrual related details gt Whether accrual entries for all accounts linked to the product should be passed at the product level If not they will be passed for each account separately gt The frequency at which profit should be automatically accrued gt Whether automatic accruals should always take place on a month end e Liquidation related details 3 13 ORACLE gt The frequency of liquidation gt Whether profit should be applied right from the day the account is opened gt The date on wh
247. trictions for a product as explained below If you would like to associate a customer restrictions class to a product click Default From Class button in the Customer Restrictions screen The product acquires the restrictions defined for the class 3 11 ORACLE If you do not use a class to indicate branch and currency restrictions you should define these restrictions specifically for the product in the Customer Restrictions screen Allowed Disallowed You can specify customer and category restrictions in the form of allowed lists or disallowed lists If you create allowed lists of branches and currencies the product will be applicable only for those categories and customer types that are part of the respective allowed lists On the other hand if you maintain disallowed lists the product will not be applicable for those categories and customer types on the respective disallowed lists You can indicate whether you are maintaining an allowed or a disallowed list type by choosing the appropriate option In Oracle FLEXCUBE you can define a set of customer restrictions as a Customer Restrictions Class You can maintain several restrictions classes of customer categories When creating a product you can associate it with a customer restrictions class that best suits your requirement The procedure for creating a customer restrictions class is similar to setting up customer restrictions for a product as explaine
248. tus hue Artbook Stoner ronce reas Maker Date Time Mod No Checker Date Time Record Status Authorization Status Defining Islamic Account Class includes the maintenance of the following parameters Account Class and Description The Account Class code is a unique code which identifies the class Along with the class code you need to assign an appropriate description to the account class For instance let us assume you are defining a class for deposit account of individuals You could associate the code DEP IND with it Similarly the description that you associate with it could be something like this Deposit accounts of individuals Account Type By default the account type is Deposit You will not be able to modify this option Start Date When you create a Islamic account class you can specify the life span of the account class by indicating the start date The start date for an account class refers to the start date for which creation of new account under the account class is allowed Consequently the option list for Islamic account class in all further transactions screen in Oracle FLEXCUBE will display the account class as of the system date End Date When you create a Islamic account class you can also specify the life span of the account class by indicating the end date 2 2 ORACLE 2 2 1 The end date for an account class refers to the termination date after which creation of
249. u can do what if analysis Mudarabah Rate will not be propagated e Once the Batch is submitted with Actual Period type Derived Mudarabah Rate will be updated to the individual account with effective date as the start date of the period The following example will illustrate the profit sharing process Account number AC00001 Account Currency AED Profit calculation balance basis Monthly Average balance Account monthly average balance 25000 Cash reserve ratio 20 Contribute to PDM Y Exclude from distribution N Account number AC00002 Account Currency AED Profit calculation balance basis Monthly Average balance Account monthly average balance 25000 3 45 ORACLE Cash reserve ratio 20 Contribute to PDM Y Exclude from distribution N Account number AC00003 Account Currency AED Profit calculation balance basis Monthly Average balance Account monthly average balance 20000 Cash reserve ratio 20 Contribute to PDM N Exclude from distribution Y Share holder GL GL00001 GL Currency AED Profit calculation balance basis Monthly Average balance Account monthly average balance 35000 PEA GL PEA00001 GL Currency AED Profit calculation balance basis Monthly Average balance Account monthly average balance 15000 PEA GL Allocation 2222 Mudarib Fee 20
250. unt after the period end date In order to avail of this facility you need to check the Defer Liquidation box and also mention the number of calendar days by which you wish the profit liquidation for a period to be deferred in the Defer Liquidation By Days field Note that you will have to necessarily specify this period if you want to link this profit product to a Term Deposit account class This will help in recalculating profit during partial redemption of a TD Zakat Product If you are setting up a product for collection of Zakat charge you need to check this option Refunding Tax on Preclosure of a Term Deposit Oracle FLEXCUBE provides you the flexibility to refund tax whenever a preclosure of a term deposit takes place in the system However you have the option to charge a compensation on the amount being withdrawn from a term deposit or when a term deposit is closed before its maturity date 3 22 ORACLE To facilitate this feature you have to select the Refund Tax On Preclosure option As a result tax collected on the profit due to the customer will be refunded on preclosure of a deposit Tax will be refunded for the profit that is calculated from the deposit value date till the preclosure date When you process a foreclosure for a term deposit the system will first check whether the Refund Tax On Preclosure option is selected for the profit product that is attached to the term deposit account If selected
251. verifies whether there is any outstanding debit profit or charges on the account You will need to liquidate these before account closure e Anerror log is created to store the error details of accounts for which liquidation could not be performed due to the following reasons e The Verify Funds option is enabled and partial liquidation is performed e The Verify Funds option is enabled and the account has insufficient funds e Accounting entries do not get passed successfully irrespective of whether the Verify Funds option is set or not Refer the End of Day processing for Debiting Receivable GLs section in the Daily Processing of IC chapter of the IC User Manual for details on end of day processes on Auto and Manual liquidation Escrow Details The following Escrow details can be maintained for the account class Escrow Transfer Applicable This box is checked by default when an account is created Uncheck this box if Escrow transfer is not applicable 2 7 ORACLE 2 2 2 Transaction Code Select the Transaction Code to be used for Escrow transfer from the adjoining option list The option list displays only those transaction codes which are enabled for Escrow processing at the Transaction Code Maintenance screen This is a mandatory input if Escrow transfer is enabled for the account class Transaction Code for Reversal Select the transaction code to be used for Escrow Reversal transactions from the adjoining opti
252. volved in such a transaction to exceed the overdraft limit Examples of typical transactions which force an account to move into overdraft are Payment and Collections Funds Transfers Standing Instructions or Clearing transactions The Referral Required option is defaulted from the account class linked to the account However you can change it for a specific account If an account is marked for referral the details of transactions resulting in the account moving into Overdraft will be sent to the referral queue IBAN Required Check this box to indicate whether you required IBAN or not Replicate Customer Signature The signature of the customer gets defaulted from the account class level to account level This value is defaulted only if the customer type is individual with single mode of operation Salary Account Check this option to indicate the salary account which should be selected for finance recovery on salary credit By default this option is unchecked Turnover Limit Preferences Turnover Limit Code The system displays the turnover limit code applicable to the account 2 54 ORACLE 2 3 2 Auxiliary Tab Click Auxiliary tab in the Islamic Customer Accounts Detailed screen section are as follows Islamic Customer Accounts Detailed The fields in the Auxiliary ra a Branch Code
253. xclude them from the profit sharing computation process The system will update the Mudarabah _Rate UDE as Zero with effective date as the start date of the period Maintaining Islamic Customer Accounts You can define Islamic customer accounts for all the customers of your bank through the Islamic Customer Accounts Maintenance screen Each Islamic deposit account that you define is identified with an account number The structure of the account number is based on the account mask you have maintained through the Account Parameters sub screen of the Bank wide Parameters screen The account number can be combination of the CIF Number the Islamic account class currency and any other alphabet s or number s of the account or currency as defined 2 44 ORACLE For an account number you also need to define in this screen other parameters like the account class the type of account joint or single the reporting lines for the account the currency in which transactions can be passed to this account the customer s account limit the check book passbook ATM facility the various statuses applicable to the account and so on Every Islamic account created or modified in Oracle FLEXCUBE needs to be authorized to become effective Whenever a new customer account is created or an existing record is modified the system generates a notification message on the record authorization This notification message can be sent to any external sy
254. y Limits Details 10f1 L In this screen you can enter the following details Account Number The system displays the customer account for which PC limits are being maintained Currency Specify the currency in which the auto exchange limits should be maintained The adjoining option list displays the currency codes maintained in the system You can choose the appropriate one Cr Lmt Amt Specify the credit limit amount in the chosen currency Dr Lmt Amt Specify the debit limit amount in the chosen currency 2 86 ORACLE 2 3 17 Specifying MIS Details To invoke the Management Information System screen for an account click the MIS button in the Islamic Customer Accounts Detailed screen while opening modifying the account The entities defined for the customer will be picked up by default and these entities can be changed Management Information System Branch Code Calc Method Account Rate Type Spread Pool Code Link to Group Account Level MIS Group Rate Code Pool Code Reference Rate Transaction MIS Codes Cost Code Composite MIS Codes Change Log Transfer Log For an account the transaction type of MIS class will be picked up from the account class along with the cost codes and pool codes The composite type of MIS class will be defaulted from those defined for the customer These too can be changed Branch The current logged
255. yping ICDWTMNT in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button Weights Maintenance Mudarabah Fund Id Bank Local Currency Effective Date Currency Account Class Product Type Savings Broken Period Current Weight Term Deposits Fee Fee Value Category l o Tenor Category PPO Category 3 Imfoas moms res Swane l o E montns w s Input By Authorized By Modification Authorized exit Date Time Date Time Number Open Here you can specify the following details Mudarabah Fund Id You can specify the Mudarabah Fund Id for which you wish to maintain deposit weight details from the option list The option list contains all Mudarabah fund ld that are active and authorized 3 31 ORACLE Currency You can specify the currency to maintain deposit weight details from the option list The option list will displays all the currency codes maintained in the system Effective Date You can specify the date from which the weights should be considered for profit calculation and distribution You can also maintain a back valued effective date but not a future date Account Class You can specify the account class for which you wish to maintain weight details from the option list The option list dis

Islamic Accounts User Manual

Contents

Download Pdf Manuals

Related Search

Related Contents