Integrated Liquidity Management Version-11.0 9NT1316
Contents
1. avs Hobdmy Laie 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 The Header Account is identified on the basis of system account level 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 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 Value dated contribution of the Child Account to from the Parent Account is kept track of The interest amount for the System Accounts can be calculated by checking the Pool Benefi2. in Ur ime Eins asp Mart 1 31 INTEGRATED LIQUIDITY MANAGEMENT PROCESSING 1 32 2 944 Vatdauon pr oret Eu lp M DES 1 32 DA TEO En icc C 1 33 2 6 1 GENET GIN NATI IST E 1 33 ORACLE 2 6 2 CN 1 34 2 6 3 LODI TOF 3S EEEE EE 1 35 2 6 4 Processing Tor Notional Pooling Structures 505 svete mactussibacamiestachienshoacwndemacuubeidaceniestachenlsacdassactucasdass 1 35 REPORT e M H T 3 36 3 1 T 3 36 AC OUNT C TRE B S renee rer om ne reer err er eset tr reser er 3 36 3 23 QO TOUS 3 36 3 22 DTI RETE aaa ehor ieia aeria 3 37 ORACLE 1 1 1 2 1 3 1 3 1 1 About this Manual 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 eac
3. Field Type Field Logic CONSOL VALUE CONSOLO CUR VALUE OCCVALUE AV VALUE TAGVALUE SENDER VALUE SENDERQ INTERMEDIARY VALUE TAGVALUE P TAG_20 VALUE TAGVALUE COVERFLAG DECLARE L_TYPE 2 e Input By ADIFCJ Date Time 0 17 33 17 Modification Number 1 open Authorized By ADIFCJ Date Time 10 17 33 18 authorized 1 23 ORACLE 2 3 6 Maintaining STP preferences You can invoke the STP Preferences Maintenance screen by typing MSDSTPREF in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button STP Preferences Maintenance Web Page Dialog Branch Code CHO a Branch Mame BANK OF Message Type MT1O3 Post Upload Status Authorised When Beneficiary Use Suspense On Override jore On Error Reject Record Input MUNUSERS Date Time 7 3 2000 1 3 Modification Mumber 1 Open Authorized By MLIRLISER Date Time 372000 18 25 27 thorized 2 3 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 arrow button Upload Source Preferences Maintenance Web Page Dialog Source Code AZ Module Code FT Error Handling Override gnore On
4. 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 1 3 ORACLE The following SDEs will be used in IC Processing SDE System Data Description Elements ILBD ULT DR BAL Captures the book dated Debit balance 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 ILBD CP DR CONT This data element captures the Compensated contribution of the book dated Debit balance ILBD CP CR CONT This data element captures the Compensated contribution of the book dated Credit balance ILVD CP CR CONT This data element captures the Compensated contribution of the value dated Credit balance ILBD NCP DR CONT This data element captures the Non Compensated contribution of the book dated
5. 2 3 15 Maintaining Mandatory Program for ILBATCH during BOD 2 Mandatory Batch Program Maintenance Webpage Dialog Branch IL9 Module IL End Of Cycle Group Transaction Input End Of Transaction Input End Of Financial Input End Of Day Beginning Of Day Frequency Holiday Rule Predecessors predecessors Fields Input By OFSSSIMAK1 Date Time 11 30 2007 16 49 52 Authorized By OFSSSIAUTH1 Date Time 11 30 2007 17 11 07 2 3 16 Maintaining Mandatory Program for ICEOD during BOD Sits E Function Identification ILBATCH Description EOC Operations Integrated Liquidity Management IL Batch Sequence Number 1 Error Handling Stop Automatic End Of Day and Run Emergency Program Continue with Automatic End Of Day Number Of Days Run Date Modification number 2 Bl Authorized 2 Mandatory Batch Program Maintenance Webpage Dialog Branch IL9 Module IC End Of Cycle Group Transaction Input End Of Transaction Input End Of Financial Input End Of Day Beginning Of Day Frequency Holiday Rule Predecessors predecessors Fields input By OFSSSIMAK1 Date Time 11 30 2007 16 50 36 Authorized By OFSSSIAUTH1 Date Time 11 30 2007 17 07 34 Function Identification ICEOD Description Batch Operations Interest amp Charges Batch Sequence Number 3 Error Handling Stop Automatic End Of Day and Run Emergency Program Continue with Automatic End Of Day Number Of Da
6. 4 M T EEEE E O O E 1 5 2 2 9 Creating dThierestc NU SEO e n aiaiai 1 5 2 20 Creating Interest amp Charges FroduCiS usan cose es eames 1 6 22 2 4 GARE ee een eee a eee ree ere ene rene Tee ree reer ME reer 1 7 2 2 8 Maintaining IC Special Conditions for Customer Accounts essssssss n 1 7 2 2 9 Maintaining Product Event Class amp Accounting 1 8 2 2 10 Associating Branch to Event Class 1 11 2 2 11 Group Code 1 11 2 2 12 Maintaining Third Party 1 14 2 2 13 Maintaining Account 5 1 16 2 2 14 Closing Accounts in an Account Structure eene enne eene nnne eene 1 19 2 2 15 Creating Group Account Linkages 1 20 OTTER MAINTE Qc ic NT 1 21 Zod Maintaining BIC codes used in Mirror Account maintenance 1 21 2 3 2 Maintaining Message Media cece cece EEE EERE 1 22 2 3 3 Maintdining Advise Formals sectas tai onsite 1 22 2 3 4 Message TYPES ces Du
7. 6 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 The system identifies all the active groups in 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 e The 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 Parent Account LAN LAN The System Account is created for the above mentioned Account Structure as follows Account IL Relation As System Account Account Level System Account 1 33 ORACLE Account IL Relation As System Account Account Level System Account Level PACC1 Child PACC2 Child The System Account wi
8. 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 balance 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 ILVD CP DR CONT This data element captures the Compensated contribution of the value dated Debit balance ORACLE 2 2 4 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 e Debit Rate for Pool Balance e Credit Rate for Pool Balance e nter Bank Rate e Tax Rate 2 2 5 Creating Interest amp Charges Rules 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 8 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 E Interest amp Charges Rule Maintenance Web Page Dialog Apply Inter
9. Local Currency r Product Code Accrual Product Level Payment Method Bearing Accural Day Discounted Frequency ss m Cycle Mane Calculation Liquidation Days First Liquidation On 12 28 71 333 Months 1 Liquidation at manth ends Year Start Date 11 28 1388 Start From Account Opening Back Value Recalculation Flag Deter Liquidation Deter Liquidation Days w Liquidation Before Month End Liquidation Before Month End 2 Days Refund Tax Preclasure Frequency LM Parameters Integrated LM Integrated Lh Type zj Debit Interest Hotification Receivable General Ledger E 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 1 6 ORACLE 2 2 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 E Customer Maintenance Web Page Dialog Customer No MARKT Liability Number MARKT Type
10. 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 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 ORACLE Interest Reallocation Check this option to allow interest to be re allocated to this account 2 2 13 2 Maintaining Sweeping Parameters opecify 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 e Debit Sweep Out e Credit Sweep In e Target Balance Agreement Base Amount The amount depends on the sweep type that you have selected e 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 the sweep type is Cre
11. adjoining arrow button Retail Teller Product Maintenance Web Page Dialog Exchange Rate Variance in Product Code JBPT Override Limit Product Module RT Stop Limit Retail Teller Rate Code Rate Product Type OT Rate Type STANDARD Others Description Test Product for MT101 gen Product Slogan Test Product for MT101 gen Product Group MISC a Miscellaneous Transactions Start Date 04 Jul 00 2 End Date 1274 Remarks Input By JAGADISH Date Time 04 Jul 00 09 54 52 Modification Number 1 Iv Open Authorized By JAIALITH Date Time 04 Jul 00 10 07 05 Iv Authorized 1 25 ORACLE 2 3 10 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 Web Page Dialog Offset Details Branch z Branch Main Leg for the Branch Name Account 4 9999 transaction Management Information Transaction Type Transaction Details system Description ANY CUSTOMER e Branch Debit Account Account Class Product Account Class Account Charge From Account Product Type Transaction Code End Point Account Class Product JBPT Offset Transaction Code Description Description Test Product for MT101 Trerisaction Cada Bank Float Days Float Days Basis Calender Customer Float Days Working Liquidation P
12. 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 opecify 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 ORACLE BVT Duration This indicates the number of BVT units allowed as 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 Ifthe 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 2 2 11 1 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 inp
13. 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 in 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 sweeps for which the Reversal option has been selected 2 6 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
14. 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 2 2 11 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 ORACLE You can invoke the IL 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 IL Group Code Maintenance Web Page Dialog Group Code Branch Pool Benefit Group Cade intraday Sweep Description Reverse Sweep Sweep Basis Dated z BVT Applicable Effective date BWT Unit Months BT Duration Fieldz Input By Date Time Modification Number Open Authorized By Date Time Autharized 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
15. invoked from the Application Browser You can invoke 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 1 8 ORACLE 2 2 9 1 F Events Class Maintenance Web Page Dialog Accounting Entries Advices Input By St Ln Tie 14 3 7 Mockticsiion Number 1 B Authorized 54 Daie Time 1439 01 thorized 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 e SWBK Sweep Booking e RVSW Reverse of Sweep Booking e RALL Reverse ALL Book Reverse Sweep 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 s
16. ACC2 CACC2 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 Maintaining BIC codes used 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 Ji BIC Code Details Web Pape Dialog Preferred LV Indicabor Eme eter nte ATS at Perymeni Curbara Credit 1 21 ORACLE 2 3 2 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 E Hessaze Media Format Maintenance Web Fage Dialog Message Format Module Ac AZ Media SFT Message Type A amp CST REG Product ALL Branch ALL Currency ALL Format REG Input By BAN Date Time 3732008 Authorized By Modification Humber 1 Date Time 3 3 20 08 vE pen mn Authorized 2 3 3 Maintaining Advise Formats E Advice Format Maintenance Web Page Dialog You can invoke the Advise Format Maintenance screen by typing MSDADVFT in the field at the top
17. CLE Click Interest tab in Customer Account Maintenance screen to invoke IC Special Conditions Maintenance sub screen where you can maintain IC special conditions for ILM accounts E IC Special Conditions Maintenance Web Page Dialog Account Details Interest Start Date Charge Start Date Branch Interest Booking Branch Account Charge Booking Branch Calculation Account Interest Booking amp ccount Charge Booking amp ccount interest Statement Product Details Product UDE Currency Integrated LM ILM Type UDE Values Dates Effective Date Open 2 2 8 1 IC Special Conditions Dr Cr Advices Waive Product Generate UDE Change Advice Open 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 2 2 9 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
18. CLE Cutoff Time MT103 You need to indicate the time at which MT103 should be generated for sweeping out funds from the Parent Account 2 2 13 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 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 field at the top right corner of the Application tool bar and clicking on the adjoining arrow button 3 Account Structure Maintenance Web Page Dialog Account Third Party Account Branch Account Account Type Child Effective date Parent Branch amp amp ccount Booking Branch amp Account Scheme Sweep Interest Reallocation Sweeping parameters Pooling parameters Sweep ebit Rate Type Paus Ami Spread Indicator Mid Rate Multiple Amount Input By Date Time Modification Number Bi Open Authorized By Date Time mi Authorized You can define the following parameters as part of maintaining the account structure for ILM processing 2 2 13 1 Indicating Account Details opecify the following details Third Party Account If the account that you have specified is a mir
19. Desa du 1 22 2 3 3 MONA STP e 1 23 2 3 6 Maintaining STI VC 1 24 2 3 7 Maintaining Upload Source 1 24 2 3 8 Maintaining Retail Teller Settlement Instructions cece cece cece cece cece cece nennen 1 25 239 Maintaining Retail Teller tiom hun ata uso ti a 1 25 200 Maninin ARC Details ae Eei 1 26 ZOJT INAS PEOUMCLV 1 26 2 3 12 Maintaining Settlement Instructions ccccccccccccccccccccceccee cece cece cece 1 27 22449 HOD Lateh Maintenance SCFOOHS oerte titre todo e o docet a 1 27 2 3 14 Maintaining Mandatory Program for ILBATCH during End of Transaction 1 26 2 3 15 Maintaining Mandatory Program for ILBATCH during 1 29 2 3 16 Maintaining Mandatory Program for ICEOD during 1 29 2 3 17 Maintaining Mandatory Program for Batch processing ILMBCCCI ss 1 30 2 3 18 Maintaining Mandatory Program for Batch processing 2 1 30 2 3 19 Maintaining Mandatory Program for Batch processing ILRMJOBS ssssss 1 31 IC PROCESSING FOR ACCOUNT STRUCTURES
20. Exception Reject Post Upload Status Authorized Purge Daye Calender Allow Deferred Processing Allow EOD with Deferred Allow Delete Input By SANZ Date Time 7 372 Modification Number 1 Open Authorized By SAMA Date Time 7 3 2000 18 35 13 iw Authorized 1 24 ORACLE 2 3 8 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 Web Page Dialog Customer Settlements Route Code JAIROLITE Description Test Route for MT101 Gen 9 Product Code JBPT az Nostro Account 1234567890 a Nostro Account Branch B1 a Intermediary Reimbursment Institution Intermediary 4123456 4799999 Receivers Correspondent Account With Institution ej e e ej aze aze e Receiver z Cover Required Sender to Receiver Information Beneficiary Institution e s Input By JAGADISH Date Time 04 Jul 00 11 13 04 Modification Number 2 iv Open Authorized By Date Time 04 Jul 00 11 20 45 authorized 2 3 9 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
21. Integrated Liquidity Management Version 11 0 INT1316 ORACLE FCUBSV UM 11 0 0 0 0 0 0 January 2010 Oracle Part Number E51712 01 ORACLE FINANCIAL SERVICES ORACLE Document Control Author Documentation Team Group UBPG Created on October 01 2008 Revision No Final EBEN Updated by Documentation Team Reviewed by Approved by Software Quality Development Testing teams Assurance Team Updated on January 04 2010 Reviewed on January 04 Approved on January 04 2010 2010 1 1 12 1 3 2 1 2 2 2 9 2 4 2 5 2 6 Integrated Liquidity Management Table of Contents TS IAI D BEL rc 1 1 MISTER OD UNO PN m 1 1 AD Gr P ee 1 1 TON RN S 1 1 1 3 1 DOCET ie ed sacked ee HIN 1 1 1 3 2 COIS UE 1 1 INTEGRATED LIQUIDITY MANAGEMENT AN INTRODUCTION 1 1 BISTROT OCI OI C 1 1 MAINTAINING PARAMETERS FOR INTEGRATED LIQUIDITY MANAGEMENT 1 1 2 2 1 I AQ 1 2 202 Manainn Customer 0 45 7 1 3 2 2 3 D DIVIDIDO T seen 1 3 2 2
22. 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 Z Customer Accounts Maintenance Webpage Dialog Branch Code 19 Customer No IL9000542 Account 000001 Customer Name NESTLE CO Currency GBP SD User Reference Account Class ILM002 Main Auxiliary Nominee Statuses Description No Debits Account Type Single No Credits Joint Stop Payments Mode Of Operation Dormant Amounts And Dates Account Open Date 11 30 2007 Alternate Account Number 000001 Frozen Posting Allowed eC eA Clearing Bank Code Status Change Automatic Clearing Account Number 000001 OverDraft m Status Details IBAN Account Number Status NORM Address Since 11 30 2007 Propagate Reporting Details Account Derived Status Options Restrictions Currency Limits Statement Limits Joint Holders interest Charges Consolidated Charges BIC Deposits instructions Standing instructions Linked Entities REG Account Status Fields Deposits instruction Billing Parameters Account Signatory Interim Transactions Report Notice Maker OFSSSIMAK1 Date Time 12 3 2007 12 25 10 Mod No Authorized Checker OFSSSIAUTHS Date Time 12 3 2007 15 49 23 ORA
23. Short Name kernel Full Name Branch Code CHO Individual C Corporate Bank Main Auxiliary Personal Corporate Custom Address For Correspondence Unique Identifier Mame kernel Name Frozen Address Mangalore Value Deceased Bangare Whereabouts Unknown Karnataka Country JAP Nationality JAP CRM Customer Language ENG Swift Code BANKGBOO Exposure USA Fax Location Mailers Required CLS Participant issuer Customer Treasury Customer Joint Customer Relationship Pricing Group Code Xref MARKT Media Charge Group Customer Category Individual SSN 587 78 4564 Clearing Group Customer Classification CIF Status Tax Group Exposure Category Since Vwithhnldinn Tax net Customer MARKT Joint MIS Standing Instructions Linked Entities Text Image Group IRA Limits CLS Restrictions UDF Domestic Professional Issuer Input By 2 Date Time 7 3 2000 11 52 59 Modification Number 5 E open Authorized By RAC2 Date Time 7 3 2000 11 53 04 j Authorized 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 2 2 8 Maintaining IC Special Conditions for Customer Accounts The Customer Accounts
24. ature 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 ORACLE Event Debit Credit Indicator Accounting Role Amount Tag Refer to the Modularity User Manual for further information on setting up accounting details 2 2 10 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 ILDBRPRM in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button E Branch Parameters Maintenance Web Page Dialog Branch Parameters Branch Event Class Jobs Frequency Min 30 Multi branch ILM structure Input By Date Time Modification Number open Authorized By Date Time El Authorized 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
25. d 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 e belong to the last period and e are 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 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 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 1 32 ORACLE 2 6 End of Day Processing 2
26. d in a retrieval system adopted or transmitted in any form or by any means electronic mechanical photographic graphic optic recording or otherwise translated in any language or computer language without the prior written permission of Oracle Financial Services Software Limited Due care has been taken to make this document and accompanying software package as accurate as possible However Oracle Financial Services Software Limited makes no representation or warranties with respect to the contents hereof and shall not be responsible for any loss or damage caused to the user by the direct or indirect use of this document and the accompanying Software System Furthermore Oracle Financial Services Software Limited reserves the right to alter modify or otherwise change in any manner the content hereof without obligation of Oracle Financial Services Software Limited to notify any person of such revision or changes All company and product names are trademarks of the respective companies with which they are associated
27. dit 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 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 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 2 2 13 3 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 ORACLE 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 After defining the account struc
28. e corresponding System Account and carries out the EOD processing 2 Fora particular Effective Date it calculates Sweep Amount for the corresponding System Accounts 3 I tfetches the entry posted for the BVT date from the Sweep Log and compares it with the oweep Amount that has been calculated currently 4 fthe Sweep Amounts are equal no entry is posted 5 Ifthe 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 ORACLE 6 Reversal of Reverse Sweep RSWR entry gets posted during reversal of RVSW 7 It inputs a new entry whose booking date is the processing date of the BVT and whose value date 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 2 2 12 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 accou
29. ection is invoked by clicking the Accounting Entries button 1 9 ORACLE As part of the Accounting Entry details of an event you should specify the following details e The accounting role e The amount tag e 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 Debit Credit You have 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 n
30. est V On Account Opening Month Rule Identification LLM1 On Account Closure Month Rule Description ILM TEST LM Parameters Primary Element 9 Integrated LM System Elements User Elements Li System Elements B User Elements Type Get Latest Ej TD pavs E CR BAL RATE2 Rate DR BAL Formula Wizard Fields Formulas Input By 51 Date Time 7 3 2000 14 36 21 Modification Number 4 E Open Authorized 51 Date Time 7 3 2000 14 36 21 jo Authorized You are required 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 1 5 ORACLE 2 2 6 Creating Interest amp Charges Products You can invoke the Interest And Charges Interest Product Preferences screen by typing CDPRMNT the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button E Interest And Charges Interest Product Preferences Web Page Dialog Description CREDIT INTEREST OF LIDE Amounts Currency
31. f the account structure closes and BVT falls in that period 2 2 15 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 EE Group Linkage Maintenance Web Page Dialog Account Group Linkage Branch CHO Header Account 210001 Effective date 7 3 2000 Group Code LGRP1 laz Input By JSK Date Time Modification Number Authorized By Date Time In this screen you need to specify the following 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 1 20 ORACLE 2 3 2 3 1 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 CACC1 Child to PACC1 PACC2 Child to HACC CACC2 Child to PACC2 CACC3 Child to PACC2 In the above structure PACC2 is the Child Account in the link HACC PACC2 whereas Parent Account in P
32. fy 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 3 36 ORACLE 3 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 branch 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 3 37 ORACLE ORACLE Integrated Liquidity Management January 2010 Version 11 0 Oracle Corporation World Headquarters 500 Oracle Parkway Redwood Shores CA 94065 U S A Worldwide Inquiries Phone 1 650 506 7000 Fax 1 650 506 7200 www oracle com financial services Copyright 2010 Oracle Financial Services Software Limited All rights reserved No part of this work may be reproduced store
33. h 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 Audience This manual is intended for the following User User Roles Back office data entry Clerks Input functions for maintenance related to the interface Back office Managers Officers Authorization functions Organization This manual is organized into the following chapters Chapter1 About this Manual gives information on the intended audience It also lists the various chapters covered in this User Manual Chapter2 ntegrated Liquidity Management An Introduction offers an introduction to the module and its features Chapter 3 Reports gives a detailed account of report generation from this module and the contents of such reports Related Documents The Procedures User Manual 1 3 2 Glossary of Icons This User Manual may refer to all or some of the following icons ORACLE Re open Reverse Template Liquidate Sign off Add Refer the Procedures User Manual for further details about the icons ORACLE 2 Integrated Liquidity Management An Introduction 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 dai
34. ll 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 2 6 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 Account Amount The value date and posting date for the entries will be the date on which the sweep is actually executed If a sweep cannot be executed because of any reason the system stores the information for reporting 1 34 ORACLE 2 6 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
35. ly liquidity in their business in a consolidated way Customers need to define account structures which form the basis of liquidity management The 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 history 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 Maintenance required for ILM EOD Batch operations and sequence 2 2 Maintaining Parameters for Integrated Liquidity Management You need to maintain certain parameters before you define account structures for integrated liquidi
36. n Settlement Instructions Maintenance Web Page Dialog Branch CHO la Module AL z Counterparty ORDBANO1 Product Code ALL Counterparty BIC Sequence Number Currency USD a Relations Receive Branch CHO Branch CHO a Cover Required Account 110001 Account ACCOUSDS4 Cover By Currency USD Currency USD a Charges Details Ourselves Payment By Message Payment By Message Benificiary Shared ay Parties Pay Parties Receiver Parties Cover Parties Clear Details Cover Detials Other Details Intermediary Reimbursement Institution Intermediary 09 4 RTGS Payment RTGS Network Input By VENL1 Date Time 7 3 2000 15 03 35 Modification Number 1 iv Open Authorized By YENU1 Date Time 7 3 2000 15 04 10 iv Authorized 2 3 13 EOD Batch Maintenance Screens You are required to maintain the following sequence for ILM batches that need to be run for any branch which is enabled for ILM At EOTI Stage ILRMJOBS e ILBATCH e ICEOD At BOD Stage e ILBATCH e ICEOD e ILMBCCC1 e LMBCCC2 The various mandatory programs are show below 1 27 ORACLE 2 3 14 Maintaining Mandatory Program for ILBATCH during End of Transaction input Mandatory Batch Program Maintenance Webpage Dialog Branch IL9 Function Identification ILBATCH Module IL Description EOC Operations Integrated Liq
37. nts 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 Third Party Accounts Maintenance screen You can invoke the Third Party 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 E Web Page Dialog Third Party Accounts Start Time MT920 Branch Code Mirror amp c External A c Currency Technical Location BIC Code Route Code A c Current Balance Balance Updated On Start Time Hour MT920 Start Time Min MT920 End Time MT920 EndTime Hour MT920 EndTime Min MT920 MT920 Generation Freq Generate Frequency Hour MT920 Cutoff Time MT101 Cut Off Hour MT101 Cut Off Min MT101 Cutoff Time MT103 Cut Off Hour MT103 Cut Off Min MT103 Input B
38. right corner of the Application tool bar and clicking on the adjoining arrow button Format ACST INT REG Language ENG _ jai Lines az Columns Form Type ADY Import File Format Text LOOP _LINE_ Message Format essage edia Module M Type Media 23 5 INT REG Branch Currency Product 2z ALL AZ ALL AZ ALL a Input By BAN Date Time 3 3 2008 Modification Number 1 Date Time 3 3 2008 Authorized By a Open a Authorized 2 3 4 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 1 22 ORACLE Message Type Maintenance Web Page Dialog Module AC z Message Type 4CST_INT_REG Description 820 generation s Priority Swift Messages For Product Setup Swift Message Type Generate at input Consolidated Message Type Show in product Input Date Time Modification Humber Open Authorized By Date Time Authorized 2 3 5 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 Rule Maintenance Web Page Dialog Message Type MT103 Field
39. roduct for Demand Draft Netting Charges Generate MT101 Generate Transaction Advice Currency az CHARGED CHARGE2 CHARGES CHARGE4 CHARGES Basis Rate Charge Account Minimum Charge Transaction Code Maximum Charge Charge Type Rate Type Currency Amount Rate Code AZ Description Netting MIS Head Slab Type one Interest Basis Their Charge Input By J amp GADISH Date Time 04 Jul 00 14 34 17 Modification Number 2 open Authorized By Date Time 04 Jul 00 14 35 30 authorized 2 3 11 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 2 Message Product Mapping Maintenance Web Page Dialog Branch CHO z Branch Description BANK OF INDIA e Message Type MT1O3 z Queue SWIFT a Product FINC Product Description INCOMING CUSTOMER Cover Required Direction Flag Incoming On Number Beneficiary suspense Repair Fields Input B SHASHANKAL Date Time 7 3 2000 12 55 11 Modification Mumber 1 Open Authorized By Date Time 3 2000 12 57 19 v Authorized 1 26 ORACLE 2 3 12 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 butto
40. ror 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 ORACLE Account First you need to specify the account main or affiliate account which has to be part of the account structure Account 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 You will not be able to link the accounts at the same level in an account structure 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 o You cannot link a child
41. 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 1 35 ORACLE 3 1 3 2 3 2 1 3 Reports Introduction Reports provide details of various events in the life of a specific contract or across contracts 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 can 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 gl Account Structure Report Webpage Dialog Group Code Group Code EWIN1 Report Options You can set your preferences for report generation on this screen Group Code Speci
42. t box at the Group level 1 31 ORACLE 2 5 2 5 1 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 The relevant System Account and the corresponding subsequent System Accounts e 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 calculated cannot be poste
43. tion 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 o Interest on accounts that are not part of an account structure are calculated on the actual customer account 1 2 ORACLE 2 2 2 Maintaining Customer Spreads 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 Spread Maintenance screen You can invoke the Customer Spread Maintenance screen by typing CYDCUSPR in field at the top right corner of the Application tool bar and clicking on the adjoining arrow button E Customer Spread Maintenance Web Page Dialog Branch CHO Customer 4ACSO01CST Spread Definition Point Currency1 USD Currency2 GBP Customer Spread Details O Tenor Buy Spread Sale Spread 7 2 Input By MSK1 Date Time 7 3 2000 14 25 18 Modification Number 1 open Authorized By MSK1 Date Time 7 3 2000 14 25 19 j Authorized 2 2 3 Maintaining SDEs In order to calculate interest Oracle FLEXCUBE uses components called
44. ture you can modify 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 2 2 14 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 are e Child Account C2 is closed first You can query to find out the child accounts of a given parent account say P2 e Subsequently account P2 is closed e Account C2 is now freshly linked with H1 ORACLE After the structure change has been carried out the new structure appears as shown below In the new structure i e after the change account C2 will have a new System Account associated with it is not applicable for a group if any o
45. ty management process They are e Account class e Customer Spreads e C SDE Maintenance e C Rule Maintenance e C Product Maintenance e Customer Maintenance e Customer Account Maintenance e Transaction Code e Product Event class and Accounting entries for ILM 1 1 ORACLE e 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 2 2 1 Maintaining Account Classes You can use the Account Class feature in Oracle FLEXCUBE to create a set of accounts which have the same characteristics Click on the Preferences button in the Account Class Maintenance screen to invoke the Preferences screen Preferences Web Page Dialog Cheque Book Preferences Preferences Cheque Book Auto Reorder of Cheque Feorder Level Limit Check Crverdratt Facil y Pass Book Facility Track Recen abies Humber Leaves Account Statistics Same Day Reversal transactione trom Stabermernd Back Period Entry ABorvwed Consolidation for maand Clearing interes Charges Track Accrued Dr Cr Advices Lodagment Book mierezi Statement Avi Bal Check Regd Referral Required Status Change automatic inetgrated LM You are required to input the following details in this screen Integrated LM Check this op
46. uidity Management IL Batch Sequence Number End Of Cycle Group Transaction Input Error Handling Stop Automatic End Of Day and Run Emergency Program Continue with Automatic End End Of Financial Input Of Day End Of Day Beginning Of Day End Of Transaction Input Frequency Da Number Of Days Holiday Rule Dont Execute Run Date Predecessors predecessors Fields Input By OFSSSIMAK1 Date Time 12 6 2007 18 23 18 Modification number 3 Authorized Authorized By OFSSSIAUTHS Date Time 12 6 2007 18 25 53 BE Open B Mandatory Batch Program Maintenance Webpage Dialog Branch 1 9 Function Identification ICEOD Module IC Description Batch Operations Interest amp Charges Batch Sequence Number 2 End Of Cycle Group Transaction Input Error Handling Stop Automatic End Of Day and Run Emergency Program Continue with Automatic End End Of Financial Input Of Day End Of Day Beginning Of Day End Of Transaction Input Frequency Daih Number Of Days Holiday Rule jont Execute Run Date Predecessors Predecessors ILBATCH Fields Input By OFS8SSIMAK1 Date Time 12 6 2007 18 23 52 Modification number 4 Authorized Authorized By OFSSSIAUTHS Date Time 12 6 2007 18 26 28 B open 1 28 ORACLE IC batch should run only if ILBATCH is successful Hence ICEOD mandatory program you need to maintain the field predecessor as ILBATCH so that the IC Batch will not run if ILBATCH fails
47. ut 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 15 performed only for sweeps and pools which are value based e corresponding System Account active on the Effective Date is considered for 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 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 In 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 th
48. y Date Time Modification Number Open Authorized By Date Time Authorized ORACLE You need to maintain the following parameters in this screen 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 opecify the route code based on which the system will pick up the settlement instructions from 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 ORA
49. ys Run Date Modification number 1 Iv Authorized 1 29 ORACLE 2 3 17 Maintaining Mandatory Program for Batch processing ILMBCCC1 datory Batch Program Maintenance Web Pape Dialog Function identification MBCCCT Description Operations Integrated Li Sequence Number i Transaction input Erroe Harding Stop Automalic End Of Dey End Of Transaction input Prog M Continue with Automatic End End Of Financial input On Dar Enel Ot Day Beginning Day Predecessess d Mandatory Hatch Program Maintenance Web Pape Dialog Function identification LMBCCC laz Description Operations integrated Lic 2 Transaction input Error Farina Step Automaic End Dey aii and Fun Emergency Program End Transaction input Continue with Adomas End End Of Financial Input Ot Day End Of Das Begnning Of Day 1 30 ORACLE 2 3 19 Maintaining Mandatory Program for Batch processing ILRMJOBS 2 4 d Mandatory Batch Program Maintenance Web Page Dialog Function identification g Fu ker Description Operations LM 510p MEC Tamince Number End Of Cycie Group Input Error Hancling Automatic End Ct Day Run Emergency Program Continue with Automatic End C4 Fireinciw ingot Day End Cd Day Ears Day End Of Transaction input Fr
Download Pdf Manuals
Related Search