Home

Integrated Liquidity Management User Manual

1. Accounting Role Amount Tag Dr Cr Indicator PHR1 ACCR 2 ILIQ Debit PHR1 BOOK 2 ILIQ Credit PHR1 TPBL 3 TAX Credit PHR1 BOOK 3 TAX Debit PHR1 TPBL ADJ 3 TAX ADJ Credit PHR1 BOOK 3 TAX ADJ Debit 6 5 2 Pool Reallocation 6 5 2 1 IACR Interest Accrual Accounting Entries Accounting Role Amount Tag Dr Cr Indicator PLC1 PNL 1 IACR Debit PLC1 ACCR 1 IACR Credit PLC1 PNL ADJ 1 IACR ADJ Debit PLC1 ACR ADJ 1 IACR ADJ Credit PLC1 PNL 2 IACR Credit PLC1 ACCR 2 IACR Debit PLC1 PNL ADJ 2 IACR ADJ Debit PLC1 ACR_ADJ 2 IACR_ADJ Credit 6 5 2 2 ILIQ Interest Liquidation Accounting Entries Accounting Role Amount Tag Dr Cr Indicator PLC1 ACCR 1 ILIQ Credit PLC1 BOOK 1 ILIQ Debit PLC1 ACQUIRED 1 IACQUIRED Credit PLC1 BOOK 1 IACQUIRED Debit ORACLE Accounting Role Amount Tag Dr Cr Indicator PLC1 ACQUIRED 2 IACQUIRED Debit PLC1 BOOK 2 IACQUIRED Credit PLC1 ACCR 2 ILIQ Debit PLC1 BOOK 2 ILIQ Credit PLC1 TPBL 3 TAX Credit PLC1 BOOK 3 TAX Debit PLC1 TPBL_ADJ 3 TAX ADJ Credit PLC1 BOOK 3 TAX ADJ Debit 6 5 3 Normal Debit and Credit Interest You can set up event wise accounting entries and advices for the product as suggested below 6 5 3 1 IACR Interest Accrual Accounting Entries Accounting Role Amount Tag Dr Cr Indicator NINT PNL 1 IACR Debit NINT ACCR 1 IACR Credit NINT PNL ADJ 1 IACR ADJ Debit NINT ACR ADJ 1 IACR ADJ Credit NINT PNL
2. eere nennen trennen rennen 7 13 7 3 3 Interest on deposits for NRI customers seen nennen trennen teen trennen rennen 7 13 7 3 4 Recurring deposit interest product nn enne enne nennen nennen trennen rennen 7 13 T4 CICRATESMAINTENANCGE steroid cerei e dre eI eee eee E pen 7 14 SCREEN GLOSSARY 1 2 1 8 1 8 1 FUNCTION ID DIST in tee ese Ne E ER EUN cce noha 8 1 1 About this Manual 1 1 Introduction This manual is designed to help acquaint you with the Integrated Liquidity Management module of Oracle FLEXCUBE This manual provides answers to specific features and procedures that you need to be aware of for the module to function successfully Besides this User Manual while maintaining the interface related details you can invoke the context sensitive help available for each field This help encapsulates the purpose of each field within a screen Placing the cursor on the relevant field and striking the F1 key on the keyboard can obtain information specific to a particular field 1 2 Audience This manual is intended for the following User User Roles Role Function Back office data entry Clerks Input functions for maintenance related to the interface Back office Managers Officers Aut
3. RETE 3 7 3 5 1 Maintaining IC Special Conditions for Customer Accounts eee 3 8 3 6 MAINTAINING PRODUCT EVENT CLASS amp ACCOUNTING 8 3 10 3 6 1 Defining Accounting Entries for Event 3 11 3 6 2 Associating Branch to Event Class iiu eer e e erede 3 12 3 7 GROUP CODE MAINTENANGE ere IRR EE DEDERE ans UU n unes 3 13 3 7 1 A Note on Back Valued Transactions a eene oska 3 15 3 8 MAINTAINING THIRD PARTY ese e ise ese r r r r ne er r 3 16 3 9 MAINTAINING ACCOUNT 5 77 7 gt 3 18 3 9 1 Indic ting Account Details et ete esha se ob aha t U Du 3 19 3 9 2 Maintaining Sweeping Parameters eese eene o nn enne ener nene nenne entrent ene 3 20 3 9 3 Indicating Pooling Parameters eese eene o enne 3 21 3 9 4 Closing Accounts an Account Structure eese eee ener trennen rennen 3 22 3 9 5 Creating Group Account Linkages esee eene nennen rennen 3 23 3 9 6 Maintaining Sweeping Eligible Balance eese entrent rennen 3 24 602522546046 aaa Q SG resi eua dos ev uu go reo Fe opone eee Pos e do EUR o 4 1 4 1 INTRODUCTION eeiam eU Cc eM Ed 4 1
4. UE dU a pend dm aate 5 1 5 2 2 Contents Of the Report es O d RES 5 2 ANNEXURE A ACCOUNTING ENTRIES 0 4 U esee s eta sone ta ss 6 1 6 1 ACCOUNTING ENTRIESFOR ILM erecto iet n 6 1 0 2 EVENTS eoe teer eti RR Die ODER oo 6 1 0 3 AMOUNT TAGS eite tete ie testo aet edic UR ER e DEDIMUS 6 1 6 4 ACCOUNTING ROLES DER Ie OI RR e E IERI 6 1 6 5 EVENT WISE ACCOUNTING ENTRIES FOR PRODUCTS sseseseeeee eee enne nnne sete 6 3 6 5 1 Poot Header te ay ecd eR tee d Ee ie er dr Sha Qa ener 6 3 6 5 2 Pool Realloc tion be ye feeit tige enne regu iie fl 6 4 6 5 3 Normal Debit and Credit Interest i e eh ete o eee Sh wives 6 5 ANNEXURE B IC RULE SET UP 7 1 7 1 INTRODUCTION si na toit et t GO M DRE IR e RERO iei rem 7 1 7 2 IC RULEMAINTENANCE in D REESE LR ii 7 1 7 2 1 Pool 77 2 REPE 7 2 7 2 2 Pool Realloc tion 7 6 7 2 3 Normal Debit and Credit Interest 7 9 1 3 UDEMAEUEMAINTENANGE oreet teret dee i eee Ore dee eerte ee RE Eden 7 12 7 3 1 Interest on term deposit payable quarterly eese eese eene nennen trennen rennen 7 12 7 3 2 Interest on term deposit payable
5. ILDBRPRM ILM Branch Parameters Maintenance ILDGRPCD Integrated Liquidity Management Group Code Maintenance ILDGRPLN Account Group Linkage Maintenance ILDMIRAC Mirror Accounts Maintenance ILDSWEEP Account Structure Maintenance ILRTQURY Account structure Report ISDBICDI BIC Code Details ISDINSTR Settlement Instructions Maintenance MSDADVFT Advice Format Maintenance MSDMSFMT Message Media Format Maintenance MSDMSTYP Message Type Maintenance MSDMTUDF STP Rule Maintenance MSDPRMAP Message Product Mapping Maintenance 8 1 ORACLE Function ID Function Description MSDSTPRF STP Preferences Maintenance STDACCLS Account Class Maintenance STDCIF Customer Maintenance STDCUSAC Customer Accounts Maintenance 8 2 ORACLE ORACLE Integrated Liquidity Management 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 documenta
6. JJ Country x Input By PKR1 Date Time Modification Number L Authorized Authorized By Date Time open 4 7 ORACLE 4 10 Maintaining Retail Teller Products You can invoke the Retail Teller Product Maintenance screen by typing DEDRTPRM in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button Retail Teller Product Details Product Code Product Description Report Module RT Retail Teller Product Type Description Slogan Product Group Product Group Description Start Date End Date Remarks MIS UDF BranchiCurrency Restriction Maker Checker Date Time Date Time Exchange Rate Variance in 4 8 Override Limit Stop Limit Rate Code Rate Type Preferred Mod No Record Status Authorization Status ORACLE 4 11 Maintaining ARC Details You can invoke the ARC Maintenance screen by typing IFDATMMN in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button ARC Maintenance Branch Offset Details Main Legforthe Transaction Leg v Account Class Product Branch transaction Transaction Type Account proci Transaction cy Currency GH Transaction Details Account Class Product Account Class Branch Q Product Type Account Float D
7. Name Value Geographic Country Nationality Language Exposure Location External Reference Customer Category Customer Classification Exposure Category FX Netting Customer Status LBL ELCMCUSTNO KYC Status Media SSN CIF Status Since KYC Reference Frozen Deceased Whereabouts Unknown CRM Customer Mailers Required CLS Participant Issuer Customer Treasury Customer Joint Customer MT920 Relationship Pricing Staff Is ELCM Customer croup ms vont siang isto maa ernes rex moos cs raza Domest T raressona issuer caras ne account Maker Checker Date Time Date Time Mod No Record Status Authorization Status 51 Apart from serving as a means to collect basic information about a customer the Customer Information Maintenance screen also reflects the hierarchy existing between a Parent company and its various subsidiaries The subsidiaries take on the Customer Number of the parent company as their Liability number 3 7 ORACLE 3 5 1 Maintaining IC Special Conditions for Customer Accounts The Customer Accounts Maintenance screen is used to create accounts for a given Customer using the desired account class and currency combination You can invoke the Customer Accounts Maintenance screen by typing STDCUSAC in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button Customer Account
8. 3 3 Maintaining Customer Spreads 3 3 1 For a given customer and currency pair you can define buy and sell spreads in different tenors in days The system defaults the spread to zero if you have not maintained any spread for a customer You can maintain spreads for a customer in the Customer Currency Spread Maintenance Screen You can invoke the Customer Currency Spread Maintenance screen by typing CYDCUSPR in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button Customer Currency Spread Maintenance Branch Customer E Spread Definition Currency1 laz Currency2 Customer Spread Details M Tenor Buy Spread Sale Spread s Input By Authorized By Modification Authorized Date Time Date Time Number Open Maintaining SDEs In order to calculate interest Oracle FLEXCUBE uses components called data elements that provide the required data System Data Elements SDEs are values such as the balance in an account or the number of transactions in a day This information is constantly updated in the system and is readily available for computation of interest These values can only be picked up by the system while applying interest User cannot indicate what the value of an SDE should be The following SDEs will be used in IC Processing SDE System Data Description Elements ILBD ULT DR BAL Captures the book dated Debit balance
9. 3 2 Interest on term deposit payable monthly You need to maintain values for the following UDEs under this product TD RATE PENALTY RATE TAX RATE 7 3 3 Interest on deposits for NRI customers You need to maintain values for the following UDEs under this product TD RATE1 TD RATE2 TD RATES TD RATE4 IN1 CA 2 CA CA 4 TAX RATE 7 3 4 Recurring deposit interest product You need to maintain values for the following UDEs under this product TD RATE1 TD RATE2 TD RATES TD RATE4 PREPAYMENT RATE OVERDUE AMOUNT TAX RATE 7 13 ORACLE 7 4 Rates Maintenance You can maintain rate codes for branches using the Interest amp Charges 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 Interest 8 Charges Branch Availability Maintenance Rate Code Branch Restrictions Allow Disallow Branch Specific Rates DOC004 Authorized By Modification Authorized Cancel Date Time Date Time Number Open Cancel You need to maintain the following rate codes for all branches of your bank PERIODIC 1 e 2 PERIODIC 3 e 4 e PENALTY 1 e PENALTY 2 e PENALTY 3 e PENALTY 4 TAX RATE e PREPAY PERIODIC 1 PERIODIC 2 PERIODIC 3 PERIODIC 4 PENALTY 1
10. 4 2 MAINTAINING BIC CODES USED IN MIRROR ACCOUNT 4 1 4 3 MAINTAINING MESSAGE MEDIA 4 2 4 4 MAINTAINING ADVISE FORMATS 4 2 4 5 MAINTAINING MESSAGE TYPES eee ln cree eoe eh eae epe ete etus eae ee coe dpa etes pugne i 4 4 4 6 MAINTAINING STP R LES 4 4 4 7 MAINTAINING STP PREFERENCES ccccccccccccececesececececececesesesesesesssssssesesesssssesesssssssssesssssesssssssesssssssseseseesess 4 5 4 8 MAINTAINING UPLOAD SOURCE PREFERENCES ccccccccccecececesecececesecesecesecesssecesesececesesesecssessseessesseseseeeseess 4 6 4 9 MAINTAINING RETAIL TELLER SETTLEMENT 5 4 7 4 10 MAINTAINING RETAIL TELLER 4 8 4 11 MAINTAINING ARC DETXIES eiit teer eb eae ete eee ee cere eb Ree pe ke pa NE eae pe 4 0 4 12 MAPPING PRODUCTS c etcetera eiae tee ier eee 4 10 4 13 MAINTAINING SETTLEMENT INSTRUCTIONS 4 11 4 14 EOD BATCH MAINTENANCE 5 8 s r ee ese ese ese ese r r r r r r r r r terenne 4 11 4 15 MAINTAINING MANDATORY PROGRAM FOR ILBATCH DURING END OF TRANSACTION INPUT 4 12 gt 4 15 1 Maintaining Mandatory Program for ICEOD during End of Transaction 4 13 4
11. Account Amount The value date and posting date for the entries will be the date on which the sweep is actually executed ORACLE 4 19 If a sweep cannot be executed because of any reason the system stores the information for reporting 4 19 3 EOD Processing for Sweeps All sweeps will be single currency sweeps During EOD Based on the choice of Sweep Type the system will process as follows gt Sweep In The minimum balance to be maintained in the Child Account is considered as Amount This sweep will be affected only if the account balance at EOD falls below this number The funds will be swept into the child account from the parent gt Sweep Out The maximum balance to be maintained in the child account is considered as the Amount This sweep will be affected only if the account balance at EOD is above this number The funds will be swept out the child account to the parent gt Target Balance The Target Balance for the Child Account is considered as the Amount The funds will be moved or out of the child account in order to maintain the Target balance at EOD System will perform the sweep only if there are sufficient funds in the parent account to perform the sweep Credit balance in the account as well as unused OD limit in the parent account would be treated as balance available for sweeping if you have chosen the option OD Limit Available for the Parent Account The system will reverse the swee
12. Cancel Mandatory Batch Program Maintenance Branch 000 Function Identification Module Sequence Number Description P End Of Cycle Group Transaction Input Error Handling Stop Automatic End Of Day O End Of Transaction Input and Run Emergency Program Continue with Automatic End End Of Financial Input Of Day End Of Day O Beginning Of Day Frequency Daily Number Of Days Holiday Rule Dont Execute 7 Run Date Execution Layer Database Job Code application Description Predecessors Input By PKR1 Date Time Modification Number M authorized Authorized By Date Time m Open 4 14 ORACLE 4 15 4 Maintaining Mandatory Program for Batch processing ILMBCCC1 Branch 000 Module End Of Cycle Group Transaction Input End Of Transaction Input e End Of Financial Input End Of Day Beginning Of Day Function Identification a Sequence Number Description Error Handling e Stop Automatic End Of Day and Run Emergency Program O Continue with Automatic End Of Day Frequency Daily Number Of Days Holiday Rule Dont Execute v Run Date 5 Execution Layer Database Job Code a Application Description Predecessors L predecessors 2 Fields By PKR od ed Cancel B 0 Ope 4 15 5 Maintaining Mandatory Prog
13. End Of Financial Input End Of Day Q Beginning Of Day Frequency Daily v Holiday Rule Dont Execute v Execution Layer O Database Q Application Function Identification Sequence Number Description Error Handling Number Of Days Run Date Job Code Description Stop Automatic End Of Day and Run Emergency Program Continue with Automatic End Of Day predecessors Input By PKR1 Date Time Authorized By Date Time Modification Number Ri Authorized m Open IC batch should only if ILBATCH is successful Hence in ICEOD mandatory program you need to maintain the field predecessor as ILBATCH so that the IC Batch will not run if ILBATCH fails 4 13 ORACLE 4 15 2 Maintaining Mandatory Program for ILBATCH during BOD andatorv Ba oara aintenance Branch 000 Function Identification a Module a Seguence Number Description End Of Cycle Group Transaction Input Error Handling Stop Automatic End Of Day O End Of Transaction Input and Run Emergency Program Continue with Automatic End O End Of Financial Input OfDay O End Of Day Q Beginning Of Day Frequency Daiy Number Of Days Holiday Rule Dont Execute Run Date E gt Execution Layer Database Job Code a Q Application Description C Predecessors Fields
14. Flag Defer Liquidation Liquidation Before Month End Integrated LM Product Debit Interest Notification Integrated LM Type Receivable General Ledger Account Details Redemption Advice Required 10f1 ria ETT Special Condition Only Repopulate at Liquida You can input the following details in this screen Integrated LM Choose this option if you want to use the product for Integrated Liquidity Management processing Integrated LM Type Specify the type of System Account to which the product ought to be linked It can be e Pool Leader Indicates that the Rule will apply to Header accounts in a structure e Pool Reallocation Indicates that the rule will apply to Parent and Child Accounts below the Header Account 3 6 ORACLE Refer the chapter Annexure A Accounting Entries in this User Manual for suggested products 3 5 Maintaining Customers You can invoke the Customer Maintenance screen by typing STDCIF in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button Customer Customer No Short Name Branch Code Full Name Main Auxiliary Personal Corporate Director Check List Address For Correspondence Name Address1 SWIFT Code Fax Credit Rating Group Code Charge Group Clearing Group Tax Group Joint Venture Individual Corporate Bank Private Customer Unique Identifier
15. ILDBRPRM in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button 3 12 ORACLE ILM Branch Parameters Maintenance Branch Parameters Branch Code Branch Name Event Class Jobs Frequency Min Multi branch ILM structure Maker Date Time Mod No Checker Date Time Record Status Authorization Status You are required to input the following details Event Class Choose the event class that you wish to associate to the branch Multi branch ILM structure Check this option to indicate that multi branch ILM structure is applicable for this branch In case you wish to modify the option by un checking it the system allows it only if there are no existing active groups for the multi branch Job Frequency Min Specify the frequency for the processing of MBCC Jobs for a branch The default value of Jobs Frequency is 30 3 7 Group Code Maintenance In Oracle FLEXCUBE you can bring together several accounts to form a Group for ILM processing You can then link this group code to the Header Account maintained as part of Account Structure In Oracle FLEXCUBE group codes allow you to uniquely identify a given account structure for ILM processing You can invoke the Integrated Liquidity Management Group Code Maintenance screen by typing ILDGRPCD in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button
16. LOC Branch amp Account System displays the branch and account of the LOC account on specifying LOC account details Scheme Indicate the type of structure for which the link is being defined The following types are possible e Sweep Indicates that the level of the structure is Sweep in which movement of funds is physical e Pool Indicates that the level of the structure is Pool in which movement of funds is notional Note the following e You can maintain Pool Structure only for a single level e You cannot have maintain a Sweep structure on top of a pool structure Interest Reallocation Check this option to allow interest to be re allocated to this account Maintaining Sweeping Parameters Specify the following details Sweep Type This indicates the sweep type of the parent and child account The sweep type can be either of the following Debit Sweep Out Credit Sweep In 3 20 ORACLE 3 9 3 Target Balance Agreement Priority Specify the priority of the child account to automatically sweep the amount from or to the main account This balance transfer occurs at EOD and BOD Base Amount The amount depends on the sweep type that you have selected e f the sweep type is Debit the Amount indicates the balance in the account that should trigger a sweep out of funds The sweep transaction will be executed if the balance in the account becomes greater than this amount e f the sweep type is Cr
17. back period from today s date while calculating BVT date For instance to indicate 30 Days input Days as BVT Unit and 30 in the BVT Duration fields Similarly to indicate 2 months the BVT Unit should be Months and the BVT Duration 2 Note the following e f the Sweep basis is Book Dated back value dated transaction is not allowed e While maintaining a new Group the system will validate whether the ILM Applicable option is checked in the ILM Branch Parameters screen A Note on Back Valued Transactions The system rebooks the sweeps in case of physical pooling and adjusts the interest amount that had been accrued and settled in the accounts when you input a transaction with a back value date In case of a change in the Account Structure in the interim between the Back Value Transaction BVT date and current date the system uses the account structure existing on the execution days The following points need to be kept in mind for BVT Processing e tis performed only for sweeps and pools which are value based e The corresponding System Account active on the Effective Date is considered for a back valued transaction to an account If BVT falls on a holiday then BVT is considered only from the next working day as there will not be any value dated record in system account for holidays e processing involves replaying the sweep from the least date of the BVT which means that the Contributions
18. can be calculated by checking the Pool Benefit box at the Group level A change in UDE values does not impact the resolution of System Accounts since both the UDEs and the UDE values are taken from the corresponding Customer Account of each System Account The UDE values are maintained in the Node and the same is picked up for interest calculation If the UDE values are changed for an effective date the IC calculations will be based on the new UDE value as on that effective date A back valued change in a UDE value leads to a back valuation for the following e relevant System Account and the corresponding subsequent System Accounts The Pool System Accounts to which the UDE belonged to as of the UDE effective date till date For ILM type of products the Balance SDEs used for the calculation of the Pool System Accounts are the consolidated pool balance and for the System Accounts it is the System Accounts independent balances For non ILM type of products the balances are taken from the customer accounts The System Account interests which are affected by BVT are recalculated and will be compared with the interest posted during that period The adjustment entry to the System Account will be the difference of interest computed and interest posted The adjustment entry due to BVT is maintained in the corresponding Booking Account of the System Account maintained in the Account Structure Maintenance If the interest calculat
19. from the adjoining drop down list Days in a Month Select Actuals from the adjoining drop down list Days in a Year Select Actuals from the adjoining drop down list Accrual Required Check this box Interest Method Default from Currency Definition Check this box Rounding Required Check this box Click Formula Wizard button and invoke the Formula Wizard screen cae ORACLE Specify the following expressions Case Result DLY NET BAL M lt 0 DLY NET BAL M DR RATE DAYS 365 100 Formula 2 Specify the following details Book Flag Select Booked from the adjoining drop down list Periodicity Choose Daily from the adjoining drop down list Debit Credit Select Credit from the adjoining drop down list Days in a Month Select Actuals from the adjoining drop down list Days in a Year Select Actuals from the adjoining drop down list Accrual Required Check this box Interest Method Default from Currency Definition Check this box Rounding Required Check this box Click Formula Wizard button and invoke the Formula Wizard screen In this screen you need to maintain the following expressions Case Result DLY NET BAL gt 0 DLY NET BAL M CR RATE DAYS 365 100 uns ORACLE 7 3 UDE Value Maintenance You can maintain UDE values for the rules using the Interest amp Charges User Data Element Maintenance screen You can in
20. in the link HACC PACC2 whereas Parent Account in 2 CACC Maintaining Sweeping Eligible Balance Click on Amounts amp Dates section in Customer Account Maintenance screen to view the current days Sweep Eligible Balance which is available for Sweep Out Interest Calculation 3 24 ORACLE 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 Auto Deposit Balance Sweep Eligible Balance Unposted Debit Dr Credit Cr Uncollected Unauthorized Debit Dr Credit Cr Uncollected Cr Opening Daily Turnover Dr Daily Turnover Cr Debit Dr Credit Cr Current LCY Accrued Interest Dr Accrued Interest Cr Interest 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 3 25 ORACLE 4 1 Introduction 4 Other Maintenance Apart from the maintenances mentioned in previous sections if Multi Bank Cash Concentration facility is allowed the following maintenances need to be done during implementation This is necessary only if they have not been maintained earlier 4 2 Maintaining BIC Codes us
21. not applicable for a group if any of the account structure closes and BVT falls in that period Creating Group Account Linkages You can link the account structure to the group codes that you have maintained in the Account Group Linkage Maintenance screen You can invoke the Account Group Linkage Maintenance screen by typing ILDGRPLN in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button Account Group Linkage Maintenance Account Group Linkage Branch Header Account z Currency 1 Effective date Group Code DOCO04 Authorized By Modification Authorized Date Time Date Time Number Open this screen you need to specify the following 3 23 ORACLE 3 9 6 Header Account The system will display the parent accounts maintained as part of account structure maintenance Select the account which you want to link to the group Effective Date Indicate the date on which the structure under the group should come into effect Group Code Indicate the group code to which you want to link the account structure For example the following structure may be defined for a Group Code GRP HACC Header Account PACC1 Child to HACC 1 Child to PACC1 PACC2 Child to HACC CACC2 Child to PACC2 Child to PACC2 In the above structure PACC2 is the Child Account
22. of the pool header in this Data element during the IC calculation process ILBD ULT CR BAL System populates the book dated Credit balance of the pool header in this data element during the IC calculation process ILVD ULT DR BAL System populates the value dated Debit balance of the pool header in this data element during the IC calculation process ILVD ULT CR BAL System populates the value dated Credit balance of the pool header in this variable during the IC calculation process 3 3 ORACLE SDE System Data Description Elements ILBD CP DR CONT This data element captures the Compensated contribution of the book dated Debit balance ILBD CR CONT This data element captures the Compensated contribution of the book dated Credit balance ILVD CP DR CONT This data element captures the Compensated contribution of the value dated Debit balance ILVD CR CONT This data element captures the Compensated contribution of the value dated Credit balance ILBD DR CONT This data element captures the Non Compensated contribution of the book dated Debit balance ILBD NCP CR CONT This data element captures the Non Compensated contribution of the book dated Credit balance ILVD NCP DR CONT This data element captures the Non Compensated contribution of the value dated Debit balance ILVD NCP CR CONT This data element captures the Non Compensated contribution of the value dated Credit balanc
23. 15 2 Maintaining Mandatory Program for ILBATCH during BOD essere 4 14 4 15 3 Maintaining Mandatory Program for ICEOD during BOD seen 4 14 4 15 4 Maintaining Mandatory Program for Batch processing 4 15 4 15 5 Maintaining Mandatory Program for Batch processing 07 4 15 4 15 6 Maintaining Mandatory Program for Batch processing ILRMJOBS sse 4 16 4 16 IC PROCESSING FOR ACCOUNT 5 4 16 4 17 INTEGRATED LIQUIDITY MANAGEMENT PROCESSING 4 17 4 18 VALIDATION OF ACCOUNT STRUCTURE ennt nets tranh E EEE ES ENET E EEE 4 18 4 19 END OF DAY PROCESSING EE IDE aaa We RE AERE RE cuero tn 4 18 4 19 1 Generating System ACCOUN Sirisiri iinan kieu iia Ee thee thee thee teen teste etre enne nennen nnne 4 18 4 19 2 Sweeping and Pooling ieri arina aaee S bct epe 4 19 4 19 3 BOD Processing fOr Sweeps cx 4 20 4 194 Processing for Notional Pooling Structures eese eene nennen rennen 4 20 4 19 5 Batch process for Sweep Eligible Balance esee 4 20 jUn sn s s not 5 1 5 1 INTRODUCTION pH Eaa E N a a S S E E E SEE OESR aE 5 1 3 2 ACCOUNT STRUCTURE REPOR Poranna i e E RO RR e PO iss 5 1 5 2 1 Report
24. 2 IACR Credit NINT ACCR 2 IACR Debit NINT PNL ADJ 2 IACR ADJ Debit NINT ACR ADJ 2 IACR ADJ Credit 6 5 ORACLE 6 5 3 2 ILIQ Interest Liquidation Accounting Entries Accounting Role Amount Tag Dr Cr Indicator NINT ACCR 1 ILIQ Credit NINT BOOK 1 ILIQ Debit NINT ACQUIRED 1 IACQUIRED Credit NINT BOOK 1 IACQUIRED Debit NINT ACQUIRED 2 IACQUIRED Debit NINT BOOK 2 IACQUIRED Credit NINT ACCR 2 ILIQ Debit NINT BOOK 2 ILIQ Credit 6 6 ORACLE 7 1 7 2 7 Annexure B IC Rule Set up Introduction This Annexure lists the Interest and Charge IC rules that need to be maintained for the Integrated Liquidity Management module of Oracle FLEXCUBE It also gives the UDEs and rates for which values need to be maintained IC Rule Maintenance The components required to calculate interest the principal period and rate are broadly referred to as Data Elements Data elements are of two types 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 Interest 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 On Account Opening Month Rule Identification On Account Closur
25. 3 18 ORACLE Integrated Liquidity Management Group Code Maintenance Group Code C Pool Benefit Branch intraday Sweep Group Code Reverse Sweep E BVT Applicable BVT Unit Months v BVT Duration Description Sweep Basis Book Dated Effective date E DOC004 Authorized By Modification Authorized Date Time Date Time Number Open You can input the following details in this screen Group Code and Description Enter a unique code to identify the group code in the system Enter a brief description Effective Date Specify the date from which the group will become active in the system You will not be allowed to input Back Valued Dates BVT here Sweep Basis You need to indicate if the sweep should be performed on Book Dated balance or Value Dated Balance for the entire structure falling under the group If BVT support is required it must have Value Dated option Pool Benefit If you select this option interest re allocation is carried out for the child accounts involved in the group Reverse Sweep Indicate whether reverse sweeps should be performed during BOD batch BVT Applicable Specify if BVT processing is applicable for a group BVT Unit Indicate the unit the system should consider while calculating the BVT date This can be Days Months 3 14 ORACLE 3 7 1 BVT Duration This indicates the number of BVT units allowed as
26. 9 End of Day Processing 4 19 1 Generating System Accounts An account can play the role of child or parent in an account structure For this purpose and to help in the processing of corrections such as back value dated transactions Oracle FLEXCUBE creates system accounts This helps the system to identify the role of the account in a structure at any point of time The resolution for generation of system accounts is as follows e system identifies all the active groups the branch to which the accounts are linked in Account Structure Maintenance The system also identifies all the accounts in the Account Structure e system identifies the ultimate parent account or Header Account linked to the group in a structure creates System Accounts for the given structure The system accounts are created for every account system assigns level called System Account level apart from the level of the account in the structure that you have maintained For instance in the illustration explained under the section Linking Account Structure to Group Code the Account Structure for the Group GRP is maintained as Child Account Parent Account IL Relation HACC GRP C HACC HACC P PACCI HACC C PACC2 HACC C PACCI PACCI P PACC2 PACC2 P CACC1 PACCI C CACC2 PACC2 C CACC3 PACC2 C The System Account is created for the above mentioned Account Structure as follows 4 18 ORACL
27. Booking Tax Payable Currency Flag Tax Amount Option Method Decimals Units Booked M Actuals From Currency Definition Account C interest Method Default C Book Tax To Expense Periodicity Days in a Year Daily Actuals Rounding Required You need to maintain two booked and two tax formulae Formula 1 Specify the following details Book Flag Select Booked from the adjoining drop down list Periodicity Choose Daily from the adjoining drop down list Debit Credit Select Debit from the adjoining drop down list Days in a Month Select Actuals from the adjoining drop down list Days in a Year Select 365 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 7 3 ORACLE Formula Wizard Formula Wizard Element Functions Operators v Logical Operators v Specify the following expressions Case Result ILVD UTL DR BAL gt 0 ILVD ULT DR BAL DR RATE DAYS 36500 Formula 2 Specify the following details Book Flag Select Booked from the adjoining drop down list Periodicity Choose Daily from the adjoining drop down list Debit Credit Select Credit
28. CCR 2 PLC1 ACQUIRED 1 PLC1 ACQUIRED 2 PLC1 ACR ADJ 1 PLC1 ACR ADJ 2 PLC1 PNL 1 PLC1 PNL 2 PLC1 PNL ADJ 1 PLC1 PNL ADJ 2 PLC1 BOOK 1 PLC1 BOOK 2 PLC1 BOOK 3 PLC1 TPBL 3 PLC1 TPBL_ADJ 3 NINT PNL 1 NINT ACCR 1 NINT PNL ADJ 1 NINT ACR ADJ 1 NINT ACQUIRED 1 NINT ACQUIRED 2 NINT PNL 2 NINT ACCR 2 NINT PNL ADJ 2 NINT ACR ADJ 2 NINT BOOK 1 NINT BOOK 2 ORACLE 65 Event wise Accounting Entries for Products You can set up various IC products for liquidity management Some representative products are listed below e Pool Header e Pool Reallocation e Normal Debit and Credit Interest 6 5 1 Pool Header You can set up event wise accounting entries and advices for the product as suggested below 6 5 1 1 IACR Interest Accrual Accounting Entries Accounting Role Amount Tag Dr Cr Indicator PHR1 PNL 1 IACR Credit PHR1 ACCR 1 IACR Debit PHR1 PNL ADJ 1 IACR ADJ Credit PHR1 ACR ADJ 1 IACR ADJ Debit PHR1 PNL 2 IACR Debit PHR1 ACCR 2 IACR Credit PHR1 PNL ADJ 2 IACR ADJ Debit PHR1 ACR ADJ 2 IACR ADJ Credit 6 5 1 2 ILIQ Interest Liquidation Accounting Entries Accounting Role Amount Tag Dr Cr Indicator PHR1 ACCR 1 ILIQ Credit PHR1 BOOK 1 ILIQ Debit PHR1 ACQUIRED 1 IACQUIRED Credit PHR1 BOOK 1 IACQUIRED Debit PHR1 ACQUIRED 2 IACQUIRED Debit PHR1 BOOK 2 IACQUIRED Credit ORACLE
29. E Account IL Relation As System Account Account Level System Account Level HACC Parent T3 2 1 HACC Header T4 2 2 PACC1 Child T1 2 3 PACC2 Child T2 2 3 PACCI Parent S3 3 1 PACCI Header S4 3 2 2 Parent S6 3 1 PACC2 Header S7 3 2 CACC1 Child 51 3 3 CACC2 Child S2 3 3 CACC3 Child S5 3 3 The System Account will have the same account Class currency and customer ID as that of the customer account The attributes defined in the Account Structure Maintenance are carried forward for the corresponding System Accounts 4 19 2 Sweeping and Pooling During End of Day EOD process you can execute the sweep process for integrated liquidity management When you execute this process based on your specifications funds are swept between accounts in a structure That is In a multi tiered sweep structure sweeps of a lower level will be done before the sweeps of a higher level System identifies the level of the System Accounts and the contribution of each account to its respective Pool is calculated This information is stored at the Account System Account Effective Date level For Notional Pooling structures the system consolidates balances of all accounts that are part of the Notional Pooling structure and calculates the pool balance For sweeping structures system will also post accounting entries as follows Contributing Account Amount Receiving
30. Integrated Liquidity Management Oracle FLEXCUBE Universal Banking Release 11 3 83 02 0 April 2014 Oracle Part Number 52607 01 ORACLE FINANCIAL SERVICES Integrated Liquidity Management 1 2 3 Table of Contents ABOUT THIS MANUAL a a 1 1 1 1 INTRODUCTION es ahustayan ananas EERE Sa gui eS 1 1 1 2 AUDIENCE Z aie REI emma enm ba tite 1 1 1 3 ORGANIZATION E e Rueda ERN NIA 1 1 1 4 RELATED DOCUMENTS sau asal n DD tace mei 1 2 1 5 GE OSSARYORIG NS rusi amal emendam uiu 1 2 INTEGRATED LIQUIDITY MANAGEMENT AN OVERVIEW 2 1 2 1 INTRODUCTION 2 5 detecte ee ec ee tes ee cac te phe e d eec ee et e d ecd es 2 1 MAINTAINING PARAMETERS FOR INTEGRATED LIQUIDITY MANAGEMENT 3 1 3 1 INTRODUCTION EA 3 1 3 2 MAINTAINING ACCOUNT GLASSES 3 2 3 3 MAINTAINING CUSTOMER 5 5 3 3 3 3 Maintaining S DES nc a sce Ee Eno b eater ERG ELSE alu 3 3 3 3 2 Maintaining YDE Spa eh eter i 3 4 3 4 CREATING INTEREST amp CHARGES 5 3 5 3 4 1 Creating Interest amp Charges Products iui eee e a 3 5 3 5 MAINTAINING CUSTOMERS 5 un
31. Modification Authorized Date Time Date Time Number Open 4 16 IC Processing for Account Structures Interest resolution for customer accounts with non integrated LM IC products is carried out by the System at the time of saving the accounts In the case of customer accounts with integrated LM type of IC product System Account records for the customer accounts are created after the account structure has been maintained The system accounts are created on the basis of their account type Header and Reallocation and are resolved in a similar manner to customer accounts The following points need to be considered for IC processing e Header Account is identified on the basis of system account level e Details of dates for liquidation accrual calculation and previous liquidation for the various ILM type products linked to a customer account are stored when a new system account is created The Account Type of the System Account and the ILM type of formula determine how interest is computed and if the accounting entries for accrual or liquidation should be suppressed or not e The re allocation interest is computed on the basis of the respective IC condition that is associated with each System Account Type This is based on Child Account s contribution to the Parent Account e Value dated contribution of the Child Account to from the Parent Account is kept track of 4 16 ORACLE e interest amount for the System Accounts
32. RATE 100 2 Formula 4 Specify the following details Book Flag Select Tax from the adjoining drop down list Periodicity Choose Periodic from the adjoining drop down list Debit Credit Select Debit from the adjoining drop down list Days in a Month Select Actuals from the adjoining drop down list Days in a Year Select 365 from the adjoining drop down list Rounding Required Check this box Click Formula Wizard button and invoke the Formula Wizard screen In this screen you need to maintain the following expressions Case Result FORMULA2 gt 0 ROUND FORMULA2 HTAX_RATE 100 2 Pool Reallocation 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 7 6 ORACLE ILVD CP CR CONT ILVD CP DR CONT CR CONT ILVD DR CONT UDE Maintain the following UDEs CDR RATE RATE RATE For each of the UDEs select the option Rate from the adjoining drop down list Get Latest For each of the UDEs select the option Use Effective from the adjoining drop down list Click Formulas button and invoke the Formulas screen You need to maintain two booked and one tax formulae Formula 1 Specify the following details Book Flag Select Booked from the adjoining dro
33. anch Branch Description Message Type Queue z Product Product Description Cover Required No Direction Flag Incoming m On No Beneficiary Suspense O Repair Input By Authorized By Modification Authorized Date Time Date Time Number Open 4 10 EJ ORACLE 4 13 Maintaining Settlement Instructions You can invoke the Settlement Instruction Maintenance screen by typing ISDINSTR in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button Counterparty a Module az Counterparty CIF v Product Code Currency Sequence Number Branch Relations Receive Branch Branch Cover By Account s las ACC H begun L Charges Details Ourselves Currency a Currency O Beneficiary Payment By vi Payment By O Shared PayParties Receiver Parties CoverParties Clear Details Cover Details Other Details Intermediary Reimbursement Institution Intermediary Country RTGS Payment RTGS Network Input By Authorized By Modification Authorized Date Time Date Time Number Open 4 14 EOD Batch Maintenance Screens You are required to maintain the following sequence for ILM batches that nee
34. and Pool Balances of the System Accounts are calculated afresh The balances in all accounts of the structure are reworked and the sweeps carried out again for each of the previous sweep having the same value date e The value dated balances of the Parent Account as well as the Child Accounts in the Account Structure are updated e n Customer Account Statements only the back value transaction will be available on the date that it was posted The system follows the following process for replaying sweeps 1 It omits BOD processing for the least back value date only and continues till the current processing date It then identifies the value dated balance of the current processing date for the corresponding System Account and carries out the EOD processing 2 Fora particular Effective Date it calculates Sweep Amount for the corresponding System Accounts 3 Itfetches the entry posted for the BVT date from the Sweep Log and compares it with the Sweep Amount that has been calculated currently 4 Ifthe Sweep Amounts are equal no entry is posted 5 lfthe Sweep Amounts are different it reverses the entry that was posted for the BVT date SWBK and the corresponding entry that was used during BOD to reverse the entry above Reverse sweep booking RSBK 3 15 ORACLE 6 Reversal of Reverse Sweep RSWR entry gets posted during reversal of RVSW 7 ltinputs a new entry whose booking date is the processing date of the BVT and whose value dat
35. ays Basis Calendar End Point Bank Float Days Description Transaction Code Customer Float Days Working T i Offset Transaction Debit Account Transaction Account Description Code Branch Name Main Transaction Code Description Charge From Account Transaction Account Management f Liquidation Product for Information System Demand Draft Generate MT101 C Netting Charges Exchange Rate Revaluation Profit Revaluation GL Loss Revaluation GL Charge1 Charge2 Charge3 Charge4 Charges Basis Rate Charge Account fi Minimum Charge Transaction Code Maximum Charge Charge Type Rate Amount Currency Rate Code Description Netting MIS Head Interest Basis Slab None C Their Charge Dalsie Input By Authorized By Modification Authorized Date Time Date Time Number Open 4 9 ORACLE 4 12 Mapping Products You can invoke the Message Product Mapping Maintenance screen by typing MSDPRMAP in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button Product Mapping Detailed Br
36. d to be run for any branch which is enabled for ILM 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 At EOTI Stage ILRMJOBS ILBATCH CEOD At BOD Stage ILBATCH ICEOD ILMBCCC1 ILMBCCC2 The various mandatory programs are show below 4 11 ORACLE 4 15 Maintaining Mandatory Program for ILBATCH during End of Transaction Input Mandatory Batch Program Maintenance Branch 000 Function Identification Module z Sequence Number Description End Of Cycle Group O Transaction Input Error Handling End Of Transaction Input O End Of Financial Input O End Of Day Q Beginning Of Day Frequency Daily Number Of Days Holiday Rule Dont Execute v Run Date Execution Layer Database Job Code Q Application Description Predecessors L Predecessors e Stop Automatic End Of Day and Run Emergency Program Continue with Automatic End OfDay Input PKR1 Date Time Modification Number Authorized Authorized By Date Time m Open 4 12 ORACLE 4 15 1 Maintaining Mandatory Program for ICEOD during End of Transaction Input Mandatory Batch Program Maintenance Branch 000 Module End Of Cycle Group Transaction Input End Of Transaction Input O
37. dify it as well as the Header Account linkages You can also move accounts from one structure to another and if the account being moved is a Parent Account all the child accounts associated with it are moved to the new structure However you cannot make a back value dated change to an Account Structure Every change in an Account Structure or a Group Account linkage leads to the creation of new System Accounts for the accounts in the Group This results in the system closing the existing System Account for the accounts But the closed records are retained to enable the system to track the history of the Account Structure and are stored based on their Effective Dates Closing Accounts in an Account Structure The following steps explain how to close an account in a given account structure Let us assume that in the structure shown below we need to close account P2 and attach account C2 directly to H1 The steps to be followed for the closure e Child Account C2 is closed first You can query to find out the child accounts of a given parent account say P2 Subsequently account P2 is closed e Account C2 is now freshly linked with H1 After the structure change has been carried out the new structure appears as shown below 3 22 ORACLE 3 9 5 In the new structure i e after the change account C2 will have new System Account associated with it BVT is
38. e IL DR EFF RATE This data elements represents the effective Debit interest rate IL CR EFF RATE This data elements represents the effective Credit interest rate 3 3 2 Maintaining UDEs User Data Elements UDEs are elements such as Interest or Tax rate the values for which are provided by the User The following User Data Elements UDE can be specified in IC Rule Maintenance Debit Rate for Pool Balance e Credit Rate for Pool Balance e Inter Bank Rate Tax Rate 3 4 ORACLE 3 4 Creating Interest amp Charges Rules 3 4 1 You can use the SDEs and UDEs that you have previously defined to create formula to be used by the system for interest calculations in the Interest amp Charges Rule Maintenance screen You can invoke the Interest amp Charges Rule Maintenance screen by typing ICDRLMNT in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button Apply Interest Rule Id Account Opening Month cription Rule Description C Account Closure Month Primary Element LM Parameters Integrated LM Integrated LM Type M System Elements User Elements 8 BSE System Elements TI User Elements Type Get Latest o Amount Use Effective romans ins Formu at Input By Authorized By Modification Authorized Date Time Date Time Number Open You are required
39. e Month Rule Description ee LM Parameters Primary Element Integrated LM Integrated LM Type System Elements usertiments s System Elements User Elements Type Get Latest Formulas Fields Formula Rate Date Exit Date Time Ope For details about the screen refer the chapter Maintaining Interest Rules in the Interest and Charges User Manual You can maintain rules for the following e Pool Header e Pool Reallocation ORACLE e Normal Debit and Credit Interest 7 2 1 Pool Header Specify the following details On Account Opening Month Check this box On Account Closure Month Check this box SDE Maintain the following SDEs DAYS e LVD ULT CR BAL e ULT DR BAL UDE Maintain the following UDEs HDR RATE HCR RATE HTAX RATE Type For each of the UDEs select the option Rate from the adjoining drop down list Get Latest For each of the UDEs select the option Use Effective from the adjoining drop down list Click Formulas button and invoke the Formulas screen dos ORACLE Formulas Formula Number Debit Credit Tax Category Tax Description Calculation Parameters Basis Percent Basis Amount Option Method Decimals Units Debit Accruals Required Local Currency Basis L0 v Book Flag Days in a Month
40. e PENALTY 2 e PENALTY 3 PENALTY 4 TAX RATE fs ORACLE PREPAY RATE For the aforesaid rate codes you need to maintain rates and effective dates in the Interest and Charges Rate Input screen You can invoke the Interest 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 Input By Authorized By Modification Date Time Date Time Number Open These rates are picked up by the TD module while processing interest applicable on a TD account Refer the chapter Floating Rate Codes for IC Module for details about rate maintenance a ORACLE 8 Screen Glossary 8 1 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 CODUPLDM Upload Source Preferences Maintenance CSDACTCL Events Class Maintenance CYDCUSPR Customer Currency Spread Maintenance DEDRTPRM Retail Teller Product Maintenance EIDMANPR Mandatory Batch Program Maintenance FTDRCST Retail Teller Settlement Details Maintenance ICDPRMNT Interest amp Charges Product Maintenance ICDRLMNT Interest amp Charges Rule Maintenance IFDATMMN ARC Maintenance
41. e is the BVT date This entry is entered into the Daily Log 8 It then updates the post sweep balances for a combination of Account Effective Date System Account Every time a physical sweep is executed the system stores the credit balance and the unused OD limit in the Parent Account before and after the sweep 3 8 Maintaining Third Party Accounts A Third Party Account is an account which is located in another bank which is not part of your bank but is part of the Liquidity Management Account Structure maintained with your bank The funds can be moved from or to the Third Party accounts To establish a relationship between the accounts in Oracle FLEXCUBE and the third party accounts you first need to maintain a mirror account of such accounts as normal CASA accounts in Oracle FLEXCUBE and then capture the parameters of the Third Party Accounts in the Mirror Accounts Maintenance Screen The Mirror accounts can be created at your branch in the country where the Third Party Account is located your branch in the country where the Header account of the Group is located The funds to be moved to from the Third Party Account will be routed through this CASA account The Mirror Account will be used to capture parameters for message generation The balance information obtained from the Third Party Bank will be stored in the Mirror Account The Third Party Account details are maintained in the Mirror Accounts Maintenance screen You can i
42. ed cannot be posted due to the closure of the booking account maintained for the System Account in the Account Structure then the system will post the interest entry to the suspense account maintained The System Accounts considered for calculation are those which e belong to the current period belong to the last period and e enabled for BVT back value transaction processing The reallocation of interest depends on the interest conditions based on the Value Dated Sweep Amounts set up on the Child Accounts The system obtains the interest rates for calculating re allocation interest from the UDEs specified in IC Maintenances The interest so derived on the contribution of the child accounts is re allocated to the respective child accounts 4 17 Integrated Liquidity Management Processing The subsequent sections of this chapter explains the various processes real time intra day and end of day performed by the system as part of ILM processing 4 17 ORACLE 4 18 Validation of Account Structure The system automatically validates the account structure that you have maintained You can run this batch process anytime during the day to check the validity of account structures If you have modified the account structure details you need to manually run the validation The system will execute the validation batch as part of ILM Processing Intra day or End of Day for all account structures which have not been validated 4 1
43. ed in Mirror Account maintenance You can invoke the BIC Code Details screen by typing ISDBICDI in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button BIC Code Details Bank Id Code Bank Name Customer Number Bank Address 1 Bank Address2 Bank Address3 SWIFT Key Telex Key SWIFT Key Arrangement Relations Sub Type Code BEI Indicator Payment Message Multi Customer Credit Transfer Yes No O Mail Keys asl 103 Preferred C Black listed CI CUG Member C Multi Customer Credit Transfer Maximum Size in Bytes Request for Transfer Input By Date Time Generate MT101 Authorized By Date Time C Remit Member C Update during upload C Generate 102 No of Transaction per Message Modification Number Authorized Open 4 1 ORACLE 4 3 Maintaining Message Media Formats You can invoke the Message Media format Maintenance screen by typing MSDMSFMT in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button Message Media Format Maintenance Message Format Module Message Type Media Product Branch Format Currency Input B DOCUMENT2 Authorized By Modification Authorized Number Cancel Date Time Date Time Open 4 44 Maintaining Advise Formats You can invo
44. edit the Amount indicates the balance in the account that should trigger a sweep in of funds The sweep transaction will be executed if the balance in the account goes below this amount e f the sweep type is Target Balance the Amount indicates the minimum balance that is to be left behind in the Child Account after the sweep is performed A value of zero indicates Zero Balancing sweeps Multiples Amount This indicates the multiples amount in which the system performs sweeps Example Let us assume the following e Available amount in account 900 e Base Amount 100 e Multiples amount 250 In this case the system works out the amount to be swept as follows 900 mod 900 100 250 100 900 50 100 750 Indicating Pooling Parameters Specify the following details Rate Type This indicates the exchange rate type that would be used by the system to convert child account balances to the currency of the parent account The system will not allow you to specify the rate type if you have specified the scheme as Sweep as the system supports only single currency sweeps Spread Indicator Specify which spread will be applicable Mid or Buy Sell The system default value is Mid If you choose the Buy Sell option the system applies the Buy rate when debiting the customer account and the Sell rate when crediting the customer account 3 21 ORACLE 3 9 4 After defining the account structure you can mo
45. erences screen Preferences Preferences Limit Check Overdraft Facility Pass Book Facility Track Receivable Account Statistics Exclude Same Day Reversal Transactions from Statement Back Period Entry Allowed Interest Statement Available Balance Check Required Referral Required Status Change Automatic Integrated Liquidity Management ATIM Project Account 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 Cheque Book Preferences Reorder Level Reorder No of Leaves Max No of Cheque Rejections You are required to input the following details in this screen Integrated LM Consolidation for Inward Clearing Interest Charges Track Accrued Interest Debit Credit Advices Posting Allowed Lodgment Book Replicate Customer Signature Cheque Book Auto Reorder of Cheque Book Check this option to indicate that accounts created under this Account Class should be part of an ILM Structure If the option is checked the system creates system accounts internal accounts for each account that is linked in a pool sweep structure and tracks the balances on both the actual accounts as well as these system accounts It also calculates interest on these system accounts Interest on accounts that are not part of an account structure are calculated on the actual customer account 3 2 ORACLE
46. field at the top right corner of the Application tool bar and clicking on the adjoining arrow button Account Structure Maintenance Account Third Party Account Branch az Account Account Type Child Effective date Parent Branch amp Account Booking Branch amp A Account al LOC Branch amp Account LH Scheme Sweep Interest Reallocation Pooling Parameters Rate STANDARD 22 Spread Indicator Mid Rate Base Amount 0 00 Multiple Amount 1 00 Sweeping Parameters Sweep Type Debit Priority Input BYDOCUMENT2 Authorized By Modification Authorized Date Time Date Time Number Open You can define the following parameters as part of maintaining the account structure for ILM processing Indicating Account Details Specify the following details Third Party Account If the account that you have specified is a mirror account of an account held with another bank you need to indicate it by selecting this option If you select this option the system will allow you to select the Technical CASA account that is linked as part of Third Party Accounts Maintenance Account First you need to specify the account main or affiliate account which has to be part of the account structure You can also specify a LOC account as an associate account Accou
47. from the adjoining drop down list Days in a Month Select Actuals from the adjoining drop down list Days in a Year Select 365 from the adjoining drop down list Accrual Required Check this box Rounding Required Check this box 74 ORACLE Click Formula Wizard button and invoke the Formula Wizard screen In this screen you need to maintain the following expressions Case Result ILVD UTL CR BAL gt 0 ILVD ULT CR BAL RATE DAYS 36500 Formula 3 Specify the following details Book Flag Select Tax from the adjoining drop down list Periodicity Choose Periodic from the adjoining drop down list Debit Credit Select Debit from the adjoining drop down list Days in a Month Select Actuals from the adjoining drop down list Days in a Year Select Actuals from the adjoining drop down list Rounding Required Check this box Tax Category Select TAXAPPLIC from the adjoining drop down list Basis Percent Specify 100 as the basis percent Local Currency Basis Check this box Tax Payable Currency Flag Specify Local Currency here Basis Amount Option Select Currency Default from the adjoining drop down list Click Formula Wizard button and invoke the Formula Wizard screen In this screen you need to maintain the following expressions ORACLE 7 2 2 Case Result FORMULA1 gt 0 ROUND FORMULA1 HTAX_
48. horization functions 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 Integrated Liquidity Management An Overview offers an introduction to the module and its features Chapter 3 ntegrated Liquidity Management Maintenance explains how to maintain certain parameters before defining account structures for integrated liquidity management process Chapter 4 Integrated Liquidity Management Other Maintenance explains the other maintenances that need to be done during implementation process Chapter 5 Heports give a detailed account of report generation from this module and the contents of such reports Chapter 6 Annexure A Lists the Accounting Entries for Interest and Charge Product applicable for the Integrity Liquidity Management module Chapter 7 Annexure A Lists the Interest and Charge rules that need to be maintained for the Integrity Liquidity Management module 1 1 ORACLE 1 4 Related Documents The Procedures User Manual 1 5 Glossary of Icons This User Manual may refer to all or some of the following icons Icons Function New Copy m Save Delete 5 Unlock Print E Close uS Re open a Reverse EJ Template a Roll o
49. icator Accounting Role Amount Tag SWBK DR CHILD CR CONT SWBK CR PARENT CR CONT SWBK CR CHILD DR CONT SWBK DR PARENT DR CONT RVSW DR PARENT CR CONT RVSW CR CHILD CR CONT RVSW DR CHILD DR CONT RVSW CR PARENT DR CONT 3 6 1 Defining Accounting Entries for Event You can indicate the accounting entries that should be passed at an event in the Accounting Entries section of the Events Class screen This section is invoked by clicking the Accounting Entries button As part of the Accounting Entry details of an event you should specify the following details e accounting role The amount tag If a debit or a credit e transaction code Accounting Role If accounting entries are to be passed for an event you have to indicate the different Accounting Roles At an event in the life cycle of a deal involving a product to which you associate the class the appropriate entries will be passed under the specified Accounting Roles The adjoining option list displays a list of all the available accounting roles Amount Tag The amount i e the available balance booking dated balance etc that is to be posted for an event is referred to as the Amount Item The tag associated with an Amount Item is the Amount Tag The adjoining option list displays a list of the amount tags that are maintained in the system You can choose a tag by double clicking on it ORACLE Debit Credit You ha
50. ke the Advise Format Maintenance screen by typing MSDADVFT the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button 4 2 ORACLE Advice Format Maintenance Format Language Form Type Import File Import Lines Columns Format Text Message Format M Module Message Type Input By Date Time Media Branch Currency Product Authorized By Date Time Modification Authorized Number exit Open ORACLE 4 3 45 Maintaining Message Types You can invoke the Message Type Maintenance screen by typing MSDMSTYP in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button Message Maintenance Module Message Type Description Priority Normal Maximum Message Count Swift Messages SWIFT Message Type Consolidated Message Type DOCO04 Date Time Authorized By Date Time For Product Setup Generate at input Show in product Modification Authorized Number Open 46 Maintaining STP Rules You can invoke the STP Rule Maintenance screen by typing MSDMTUDF in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button STP Main
51. nt Type You need to indicate whether the account that you have specified is a main account or secondary account The account type defines the relationship between the accounts e Select the option Parent to indicate that the account is the main account in the hierarchy e Select the option Child to indicate that the account is a secondary account in the hierarchy Oracle FLEXCUBE allows more than one child accounts to the main account You will not be able to link the accounts at the same level in an account structure 3 19 ORACLE 3 9 2 If you de link a parent account from a structure or link it to another parent in the same structure the associated child accounts linked to it will also follow the parent account Effective Date You need to indicate the date from which the account structure is available in the system for ILM processing However if Intraday Sweep Batch is run for the branch for any group you cannot change the structure on the same effective date Parent Account This is applicable only if you are maintaining a child account You need to indicate the parent account for the child here You cannot link child account to more than one parent account Booking Account You need to indicate the account to which the interest amount is to be booked during interest reallocation after interest is calculated The booking account linked to the account should have the same currency as the account
52. nvoke the Mirror Accounts Maintenance screen by typing ILDMIRAC in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button Mirror Accounts Maintenance Third Party Accounts Branch Code 000 Start Time MT920 Start Time Hour MT920 Start Time Min MT920 Mirror Account External Account Currency End Time MT920 Technical Account z End Time Hour MT920 Location z End Time Min MT920 BIC Code MT920 Generation Frequency Route Code Generation Frequency Hour MT920 Account Current Balance Cutoff Time MT101 Cutoff Hour MT101 Cutoff Min MT101 Balance Updated On Cutoff Time MT103 Cutoff Hour MT103 Cutoff Min MT103 DOC004 Authorized By Modification Authorized Number Cancel Date Time Date Time Open You need to maintain the following parameters in this screen 3 16 ORACLE Mirror A c This indicates the account number in Oracle FLEXCUBE External A c You need to indicate the account number in the third party bank Currency The system defaults the account currency Technical A c This indicates the CASA account linked to the mirror account Location This indicates the location of the third party bank BIC Indicate the BIC Code of the third party bank Route Code Specify the route code based on which the system will pick up the settlement instructions fr
53. om ARC settlement instructions maintenance for third party accounts for the generation of payment messages Account Current Balance The system will display the balance of the external account sent by the last MT 942 message Balance Update On The system displays the date on which the last MT942 message was received Start Time MT920 Here indicate the time at which the first MT920 message for a day should be generated End Time MT920 You need to specify the time at which the last MT920 message for a day should be generated MT920 Generation Frequency Here you need to indicate the interval in hours at which MT920 should be generated Cutoff Time MT101 You need to indicate the time at which MT101 should be generated for sweeping in funds from the Third Party Account Cutoff Time MT103 You need to indicate the time at which MT103 should be generated for sweeping out funds from the Parent Account 3 17 ORACLE 3 9 Maintaining Account Structures In Oracle FLEXCUBE you can define a structure for the various accounts participating in the ILM process and set up a hierarchy for the accounts establish the relationships or links among the accounts that are to be part of the Group 3 18 ORACLE 3 9 1 You need to define the account structure and the hierarchy for ILM processing in the Account Structure Maintenance screen You can invoke the Account Structure Maintenance screen by typing ILDSWEEP in the
54. ook Flag Select Tax from the adjoining drop down list Periodicity Choose Periodic from the adjoining drop down list Debit Credit Select Debit from the adjoining drop down list Days in a Month Select Actuals from the adjoining drop down list Days in a Year Select 365 from the adjoining drop down list Rounding Required Check this box Click Formula Wizard button and invoke the Formula Wizard screen In this screen you need to maintain the following expressions Case Result FORMULA2 gt 0 ROUND FORMULA2 CTAX_RATE 100 2 Normal Debit and Credit Interest 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 VD DLY CR BAL M YEAR 7 9 ORACLE UDE Maintain the following UDEs e NORMAL_RATE1 e NORMAL_RATE2 AMOUNT1 e TAXI Type For each of the UDEs select the option Rate from the adjoining drop down list Get Latest For each of the UDEs select the option Use Effective from the adjoining drop down list Click Formulas button and invoke the Formulas screen You need to maintain two booked formulae Formula 1 Specify the following details Book Flag Select Booked from the adjoining drop down list Periodicity Choose Daily from the adjoining drop down list Debit Credit Select Debit
55. ow button Upload Source Preferences Maintenance Source Code Error Handling O On Override Ignore v Post Upload Status Authorized Purge Days Calendar C Allow Deferred Processing Allow EOD with Deferred C Allow Delete Input By Authorized By Date Time Date Time 4 6 Module Code On Exception Reject Modification Number az Authorized exit Open ORACLE 49 Maintaining Retail Teller Settlement Instructions You can invoke the Retail Teller Settlement Details Maintenance screen by typing FTDRCST in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button Retail Teller Settlement Details Maintenance Settlement Customer Settlements Route Code Description Product Code a Nostro Account Nostro Account Branch a Intermediary Reimbursment Institution Intermediary 9 amaa Country Country Receivers Correspondent Account With Institution a F8 eere gt 3 I cJ Receiver es Country 58 Country 57 Cover Required Sender to Receiver Information Beneficiary Institution m in w a o a
56. p down list Periodicity Choose Daily from the adjoining drop down list Debit Credit Select Debit from the adjoining drop down list Days in a Month Select Actuals from the adjoining drop down list Days in a Year Select 365 from the adjoining drop down list Rounding Required Check this box Click Formula Wizard button and invoke the Formula Wizard screen You need to maintain three booked and three non booked formulae d ORACLE Formula 1 Specify the following expression Case Result ILVD CP DR CONT ILVD CP DR CONT ILVD DR CONT ILVD DR CONT gt 0 RATE DAYS 36500 Formula 2 Specify the following details Book Flag Select Booked from the adjoining drop down list Periodicity Choose Daily from the adjoining drop down list Debit Credit Select Credit from the adjoining drop down list Days in a Month Select Actuals from the adjoining drop down list Days in a Year Select 365 from the adjoining drop down list Rounding Required Check this box Click Formula Wizard button and invoke the Formula Wizard screen In this screen you need to maintain the following expressions Case Result ILVD CP CR CONT ILVD CP CR CONT ILVD NCP CR CONT ILVD CR CONT gt 0 RATE DAYS 36500 ORACLE 7 2 3 Formula 3 Specify the following details B
57. ps for which the Reversal option has been selected 4 19 4 Processing for Notional Pooling Structures The processing for Notional Pooling structures is as follows In case of Notional Pooling NP funds are actually not moved across accounts However the value dated balances of the Child accounts are kept track of Notional Pooling is performed only for a single level A single level NP structure can be defined above a multi level sweeping structure Notional Pooling is an EOD process where system consolidates balances of all accounts that are part of the NP structure and calculates the Pool Balance The system converts the Child Account balances to Parent Account currency This is done in order to arrive at the ultimate Pool Balance in terms of the Parent Account currency 4 19 5 Batch process for Sweep Eligible Balance To determine the Contribution Amount the ILM batch considers the Sweep Eligible Balance instead of the Available Balance Example Account Balance 2 000 00 Sweep InEligible Balance 500 00 Sweep Eligible Balance 1 500 00 The Sweep Ineligible Balance is populated from E Gifts DEUPLOAD interface based on the AIP Eligible value as Y or Any record with AIP Eligibility set to increases the Sweep InEligible balance by that amount 4 20 ORACLE 5 1 5 2 5 2 1 5 Reports Introduction Reports provide details of various events in the life of a specific contract or across contrac
58. 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 Oracle 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
59. ram for Batch processing ILMBCCC2 L2 Mandatory Batch Program Maintenance Branch 000 Module End Of Cycle Group Transaction Input O End Of Transaction Input End Of Financial Input End Of Day Q Beginning Of Day Frequency Daily Holiday Rule Dont Execute EH Execution Layer Database Application Function identification Sequence Number Description Error Handling e Stop Automatic End Of Day and Run Emergency Program Q Continue with Automatic End Number Of Days Run Date Job Code Description OfDay Predecessors 0 Predecessors Input By PKR1 Date Time Authorized By Date Time Modification Number l Authorized El open 4 15 ORACLE 4 15 6 Maintaining Mandatory Program for Batch processing ILRMJOBS Mandatory Batch Program Maintenance Branch Function Id il Module Sequence Number Description End Of Cycle Group Txn Input Error Handling Stop Automatic End Of Day O End of Txn Input and Run Emergency i Program okn pit O Continue with Automatic End of Day End Of Day Beginning of Day Frequency Daily Number Of Days Holiday Rule Do Not Execute Run Date e Execution Layer Database JobCode Q Application Sub Stage 1 Description Predecessors Wi Predecessors Input By Authorized By
60. ranch code branch date user ID module from which the report has been generated date and time at which the report has been generated and the page number of the report Body You can find the following details in the body of the report Branch Code The code that identifies the branch Account The account number for which the corresponding details are provided Account Type The type of corresponding account Effective Date The effective date of the corresponding account 5 2 ORACLE 6 1 6 2 6 3 6 4 6 Annexure A Accounting Entries Accounting Entries for ILM This Annexure lists the suggested event wise accounting entries that can be set up for the Interest and Charge product applicable for the Integrated Liquidity Management module of Oracle FLEXCUBE Events You need to set up the following events for an Interest product Event Code Event Description ILIQ Interest Liquidation IACR Interest Accruals Amount Tags The following amount tags are available e ACR e ACR ADJ ILIQ ACQUIRED e TAX e TAX ADJ Accounting Roles The following accounting roles are available PHR1 ACCR 1 PHR1 ACCR 2 PHR1 ACQUIRED 1 PHR1 ACQUIRED 2 PHR1 ACR ADJ 1 PHR1 ACR ADJ 2 PHR1 PNL 1 PHR1 PNL 2 PHR1 PNL ADJ 1 PHR1 PNL ADJ 2 PHR1 TPBL 3 PHR1 BOOK 1 PHR1 BOOK 2 PHR1 BOOK 3 ORACLE PHR1 TPBL ADJ 3 PLC1 ACCR 1 PLC1 A
61. s Maintenance Branch Code Account Currency SD User Reference Main Auxiliary Nominee Check List Description Account Type Single Joint Country Code Mode of Operation Account Open Date Alternate Account Number Clearing Bank Code Clearing Account Number IBAN Account Number Address Location Media Dormancy Parameters Credit Debit Manual Any Customer No Customer Name Account Class Private Customer Statuses Status Details No Debits No Credits Stop Payments Dormant Frozen Posting Allowed Status Change Automatic Overdraft Status Since Account Derived Status Propagate Reporting Details Account Auto Closed Options Turnover Limit Preferences Turnover Limit Code Track Receivable Referral Required IBAN Required Replicate Customer Signature Salary Account Project Account consona heroes a natactons sanding mstactons onse Entues sc accounts Retnenon currency ms is statement mss kore Fieras Depos instruction mo Parameters Account Santor terim Transactons Repor Notes caras statistics Change Log Maker Checker Date Time Date Time Mod No Record Status Authorization Status Click Interest button in Customer Account Maintenance screen to invoke IC Special Conditions Maintenance sub screen where you can maintain IC special condi
62. tenance Message Type Field Name 00 004 Authorized Date Time Date Time Field Type Field Logic lt lt lt lt s lt lt lt lt lt lt lt oj F9 o Fo o Fo o Feo o Fro o o 9 o 9 o Fo O 9 Modification Authorized Number Open 4 4 ORACLE 4 7 Maintaining STP preferences You can invoke the STP Preferences Maintenance screen by typing MSDSTPRF in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button STP Preferences Branch Code Branch Name Message Type Post Upload Status Authorized When No Beneficiary Use Suspense On Override Ignore On Error Reject Record Input By Authorized By Modification Authorized Date Time Date Time Number Open 4 5 ORACLE 4 8 Maintaining Upload Source Preferences You can invoke the Upload Source Preferences Maintenance screen by typing CODUPLDM in the field at the top right corner of the Application tool bar and clicking on the adjoining arr
63. tion 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 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
64. tions for ILM accounts 3 8 ORACLE Special Conditions Maintenance Account Details Account Calculation Account Booking Account C interest Statement Required C Dr Cr Advices Charge Booking Account z Product Details Product az User Defined Element Currency ILE Interest Start Date Interest Booking Account Branch Charge Booking Branch Charge Start Date T C waive C Generate UDE Change Advise Open Interest SDE User Defined Element Id Rate Code 3 5 1 1 IC Special Conditions The system displays the following fields on the basis of your choice in the IC Rule and IC Product screens Integrated LM The system defaults the value specified in the product screen from based on product selected from the option list Integrated LM Type The system displays the value on the basis of your choice in the IC Rule and IC Product screens 3 9 ORACLE 3 6 Maintaining Product Event Class amp Accounting Entries When you define an Events Class you choose first of all the set of events that would belong to the class Events are usually unique to a module The events that you would like to include in an Events Class can be identified through the Events Accounting Entries and Advices Class Maintenance screen This screen is invoked from the Application Browser You can in
65. to input the following detail in this screen Integrated LM Choose this option if you want to use the product for Integrated Liquidity Management processing Integrated LM Type Specify the type of System Account to which the product ought to be linked It can be e Pool Leader Indicates that the Rule will apply to Header accounts in a structure e Pool Reallocation Indicates that the rule will apply to Parent and Child Accounts below the Header Account Refer the chapter Annexure B IC Rule Set up in this User Manual for suggested IC rules Creating Interest amp Charges Products You can invoke the Interest And Charges Interest Product Preferences screen by clicking Preferences button on the Interest And Charges Product Maintenance screen You can invoke the latter by typing ICDPRMNT in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button 3 5 ORACLE interest Product Preferences Product Code Description Accrual UDE Currency Product Level Accrual Day Frequency Cycle Calculation and Liquidation Payment Method Bearing Discounted Amount Block for Discount Days Months Year Start From Account Opening Refund Tax on Pre Closure OD interest reversible LM Parameters First Liquidation On Start Date Defer Liquidation Days Defer Before Month End Days Liquidation at Month Ends Back Value Recalculation
66. ts at a specific point of time For every module in Oracle FLEXCUBE you can generate reports This chapter details out the reports that you can generate from Integrated Liquidity Management module of Oracle FLEXCUBE You can generate the following report for the Integrated Liquidity Management module e Account Structure Report Account Structure Report Account structure report provides information on the type of account and effective date of each account You set preferences as to generation of the report using Account Structure Report screen To invoke the screen type ILRTQURY in the field at the top right corner of the Application tool bar and click the adjoining arrow button Account structure Report Group Code Group Code az ok exit Report Options You can set your preferences for report generation on this screen Group Code Specify the group code for which you are generating the report The option list displays all valid group codes maintained in the system Choose the appropriate one Once you have specified the group code click OK button The system displays the print option screen Here you can set your preferences as to printing the report Click OK button to print the report 5 1 ORACLE 5 2 2 Contents of the Report The contents of Account Structure report have been discussed under the following heads Header The Header carries the title of the report b
67. ve already specified the type of account to which an entry should be passed and the tag which identifies the amount available balance booking dated balance etc that should be passed In this field you must indicate if the amount is to be debited from credited to the specified account Choose the Debit or Credit indicator Transaction Codes Every accounting entry in Oracle FLEXCUBE involves a Transaction Code that describes the nature of the entry This code and its description will identify the original sweep book reverse booking and their corresponding reversals The Transaction Code for both legs of the transaction would be the same The table below illustrates the accounting entries for each event that you need to set up for the liquidity management module Event Debit Credit Indicator Accounting Role Amount Tag SWBK DR CHILD CH CONT SWBK CR PARENT CR CONT SWBK CR CHILD DR CONT SWBK DR PARENT DR CONT RVSW DR PARENT CR CONT RVSW CR CHILD CR CONT RVSW DR CHILD DR CONT RVSW CR PARENT DR CONT Refer to the Modularity User Manual for further information on setting up accounting details 3 6 2 Associating Branch to Event Class After you define the accounting entries that need to be passed for a set of events you need to associate the event accounting entries to the branches of your bank You can invoke the ILM Branch Parameter Maintenance screen by typing
68. ver Jl Hold Authorize Liquidate m Exit Sign off Help Add row Delete row ORACLE ORACLE 2 Integrated Liquidity Management An Overview 2 1 Introduction Liquidity Management refers to the services your bank provides to its corporate customers thereby allowing them to optimize interest on their checking current accounts and pool funds from different accounts Your corporate customers can therefore manage the daily liquidity in their business in a consolidated way Customers need to define account structures which form the basis of liquidity management account structure reflects the hierarchical relationship of the accounts as well as the corporate strategies in organizing accounts relationships Liquidity management services are broadly classified as under e Sweeping where physical funds are moved in account structure from child to parent or parent to child e Pooling where funds are not physically moved in and out of accounts Instead the account balances are notionally consolidated and interest computations carried out on such notional balances The Integrated Liquidity Management ILM module in Oracle FLEXCUBE supports a multi branch multi currency liquidity management structure using architecture of System Accounts This enables the system to keep track of balances in accounts in the structure calculate interest on the accounts in the structure as well as track the histor
69. voke the Events Class Maintenance screen by typing CSDACTCL in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button Events Class Maintenance Class Code Description Module Module Description Event Class I Event Code Event Description accouning nies nis Input By Authorized By Modification Authorized exit Date Time Date Time Number Open You can maintain the following details in this screen Class Code An Events Class is identified with a unique Code and a Description This indicates the name of the event class to which the events for ILM processing will be linked Description You need to enter a brief description for the class code Module Events are usually unique to a module Specify the module as IL to define the events for Liquidity Management module Events Description Once you specify the class code and module click on add icon The system will display the events associated with the Integrated Liquidity Management module The following events are available for the integrated liquidity management module 3 10 ORACLE e SWBK Sweep Booking RVSW Reverse of Sweep Booking RALL Reverse ALL Book Reverse Sweep The table below illustrates the accounting entries for each event that you need to set up for the liquidity management module Event Debit Credit Ind
70. voke 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 Interest amp Charges User Data Element Maintenance MEA Product Code Account Class Branch Code Currency Code Effective Date gt Rule Description Description Accrual Frequency User Element Amounts Currency Description Product Accruals Rate Chart Allowed Liquidation Frequency Days Months Years User Data Elements 1 18 M User Element User Element Value Rate Code TD Rate Code DOC004 Authorized By Modification Authorized kasi Date Time Date Time Number Open Cancel 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 Interest on term deposit payable quarterly e Interest on term deposit payable monthly e Interest on deposits for NRI customers e Recurring deposit interest product 7 3 1 Interest on term deposit payable quarterly You need to maintain values for the following UDEs under this product TD_RATE1 TD RATE2 TD RATE3 TD RATE4 pas ORACLE CA IN1 CA 2 CA CA IN4 TAX RATE 7
71. y of the sweep pool structure System accounts are internal accounts created by the system based on the role played by an account in an Account Structure This document is broadly classified into two sections as follows e Maintenance required for ILM EOD Batch operations and sequence 2 1 ORACLE 3 Maintaining Parameters for Integrated Liquidity Management 3 1 Introduction You need to maintain certain parameters before you define account structures for integrated liquidity management process They are e Account class e Customer Spreads e Maintenance e IC Rule Maintenance e IC Product Maintenance Customer Maintenance e Customer Account Maintenance e Transaction Code e Product Event class and Accounting entries for ILM ILM Branch parameters Maintenance e Group Code Maintenance e Third Party Account Maintenance if Multi Bank Cash Concentration is implemented e Account Structure Maintenance e Group Account Linkage e Other Maintenances 3 1 ORACLE 3 2 Maintaining Account Classes You can use the Account Class feature in Oracle FLEXCUBE to create a set of accounts which have the same characteristics You can invoke the Account Class Maintenance screen by typing STDACCLS in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button Click on the Preferences button in the Account Class Maintenance screen to invoke the Pref

Integrated Liquidity Management User Manual

Contents

Download Pdf Manuals

Related Search

Related Contents