Home

Clearing User Manual - Oracle Documentation

1. 8 2 ORACLE 9 1 9 Annexure Il Different Currency Combinations Rate Code and Rate Type Pickup Currency 1 Currency 2 Specific Main Currency Specific Offset Currency Specific Offset Currency Specific Main Currency Specific Main Currency k CE Specific Main Currency k Specific Offset Currency Specific Offset Currency k k k 9 1 ORACLE 10 Screen Glossary 10 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 CGDCLGDT Query Clearing Upload CGDQUERY Clearing Transaction Query CGDREMNT Clearing Rejection Reason CGRCHREV Inward Clearing Extract Rejected Entries CGRCLFPS Inward Clearing Extract Forcefully passed Entries CGRCLGPS Inward Clearing Extract Passed Entries CGRCLREF Inward Clearing Extract Failed Entries CGRINCLR Inward Clearing Extract Report CGSQUERY Clearing Transaction Query Summary CLDFNPRD CG Product Definition DEDBNKCD Clearing Bank Codes Maintenance FTDRCST Settlement Details IFDATMMN ARC Maintenance screen STDCLHOL Clearing House Holidays Calendar Maintenance CGDDOCTY Clearing Document Type Maintenance CGDCLRPT Clearing Service Points Maintenance CGDCKCOL Cheque
2. Field Description Data Type INSTRNO Instrument number Number PROD Product code inward String clearing product INSTRCCY Instrument currency String INSTRAMT Instrument amount Number ROUTINGNO Routing Number String The following are the fields which are mandatory for Inward Clearing Field Description Data Type REMACCOUNT Remitter account Number ENDPOINT End point String The following are the fields which are mandatory for Outward Clearing Field Description Data Type BENACCOUNT Beneficiary account Number INSTRDATE Instrument date Date 6 6 ORACLE 7 1 7 2 7 Reports Introduction The report programs available under the Clearing module are explained in this chapter All activities that are performed by the Clearing module are recorded The inputs you have made at different stages are pieced together and can be extracted in the form of meaningful reports as and when you may require them Every day teller doing the financial transactions print hard copy of the reports The reports that can be generated for the clearing Module are as follows e Inward Clearing Extract Report e Inward Clearing Extract Passed Entries e Inward Clearing Extract Failed Entries e Inward Clearing Extract Rejected Entries e Inward Clearing Extract Forcefully Passed Entries Inward Clearing Extract Report This Report lists the all inward clearing records It wi
3. 5 1 ORACLE e The details of accounts or GL s to which offset accounting entries should be posted Typically you would post the accounting entries generated by transactions involving a specific clearing house to an account or GL maintained for the purpose e The details of any charges that your bank would need to collect or levy for the clearing service If you are maintaining ARC details for a product and a specific clearing house sector the details maintained in this screen will be used for posting entries generated by clearing transactions involving the product clearing house sector branch and currency code combination You must maintain ARC details for all possible combinations of products currencies branches and clearing houses sectors Product Type In the ARC Maintenance screen you have to first of all indicate the clearing product for which you are maintaining ARC details Transaction Type Specify the type of transaction for the ARC maintenance This adjoining option list displays all valid transaction types maintained in the system You can choose the appropriate one Currency ARC details are maintained for a product branch currency and clearing house combination Indicate the currency of the combination in the currency field Branch The ARC record is maintained for a Branch Product Type Ccy Account Class Product ARC record can be maintained for a Module specific Product Combinati
4. CGRCLFPS in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button Inward Clearing Extract Forcefully Passed Entries Transaction Date Specify the transaction date 7 5 ORACLE Click OK button to generate the inward clearing extract report click Exit to return to the Reports Browser 7 6 ORACLE The contents of the report are discussed under the following heads Header 7 6 1 Contents of the Report The Header carries the Branch of the report information on the branch and date the ID of the user who generated the report the date and time at which it was generated and the module of the report Body of the report The generated report will be ordered by the batch number and currency The Batch No 4 7 character of Reference Number The Summation will be for Number of entries amount End Point This indicates the end point Clearing Type This indicates the clearing type Remitter Branch This indicates the remitter branch Remitter Account This indicates the remitter account Beneficiary Account This indicates the beneficiary account Cheque Number This indicates the cheque number Entry Number This indicates the entry number Routing Number This indicates the routing number Previous Status This indicates the previous status Current Status This indicates the current statu
5. End Point This indicates the end point Clearing Type This indicates the clearing type Remitter Branch This indicates the remitter branch Remitter Account This indcates the remitter account Beneficiary Account This indicates the beneficiary account Cheque Number This indicates the cheque number Entry Number This indicates the entry number Routing Number This indicates the routing number Payee This indicates the payee Instrument Date This indicates the instrument date Currency This indicates the currency Cheque Amount This indicates the cheque amount 7 4 Inward Clearing Extract Failed Entries This Report lists the failed inward clearing records You can invoke Inward Clearing Extract Failed Entries screen by typing CGRCLREF in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button Inward Clearing Extract Failed Entries Transaction Date Specify the transaction date Click OK button to generate the inward clearing extract report click Exit to return to the Reports Browser 7 3 ORACLE 7 4 1 Contents of the Report 7 5 The contents of the report are discussed under the following heads Header The Header carries the Branch of the report information on the branch and date the ID of the user who generated the report the da
6. Specify the following details Late Reject Days Specify the number of days within which the DD should be generated after late return of cheque Bank Group Specify the bank group Collection Cheque Reporting Format Select the reporting format of the collection cheque from the drop down list Following are the options available in the drop down list e Form e Remittance Letter Level of Invoice Payment for Negotiated Cheque Indicate the level at which you want to invoice the payment for negotiated cheque You can select one of the following options e Centralized e De Centralized Level of Invoice Payment for Non negotiated Cheque Indicate the level at which you want to invoice the payment for non negotiated cheque You can select one of the following options e Centralized 3 6 ORACLE e De Centralized Dispatch Floating Days Specify the number of floating days for which a particular cheque is held by system if it is not marked for dispatch Beyond this system will mark a cheque as LOST City Specify the name of the clearing city Branch Code Specify the branch code 3 1 3 4 Maintaining Clearing Document Types You can specify details of the document type used for clearing in the Clearing Document Type Maintenance screen You can invoke this screen by typing CGDDOCTY in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button Clear
7. IC Inward clearing the system will create the inward clearing transaction e Ifthe instrument type is DD or BC and the product type is not OC Outward Clearing the system will trigger the liquidation process for the DD BC instrument received for clearing e The Clearing batch process will update the status of the clearing upload data in the clearing log data store e Ifthe clearing transaction is created successfully the status will be updated as SUCS in the clearing log data store which can be viewed from the Clearing Log Summary screen e During accounting process the system will fail the transaction based on the conversion error code maintenance for the accounting overrides e These transactions can be processed fail to pass from the Clearing Log Repair screen e If transaction is failed during batch process the system would update the status as ERRR with error code and error description in the clearing log which can be viewed from clearing log summary IFSCLGDT or Clearing Repair Screen CGDCLGDT e You can manually correct the error data from the Clearing Bulk Repair screen 6 5 ORACLE 6 6 1 Provision for populating Clearing Upload The excel upload process exposed by the system can be utilized to upload the clearing data into the clearing log data store The following are the fields which are mandatory for both Inward and Outward Clearing
8. you can choose the transaction amount or Charge 1 or Charge 2 as the basis Currency You can indicate the currency in which the charge amount would be expressed If the transaction currency is different from the charge currency a conversion would be done using the rate code and rate type that you specify for each charge Their Charges For outward clearing checks you can indicate whether the charge is being collected on behalf of the collecting bank If you set this option you need not specify the charge account Since the charge amount would not known upfront you need not specify the amount either Charge Account You can specify the charge account typically the Income GL into which charge related entries are to be posted in the Charge Account field Netting Charge If two or more accounting entries for the same event are to be passed to the same account on the same Transaction Date these entries can be netted You can choose to net charges by choosing this option Transaction Code You can indicate the code using which the accounting entries would be booked for each charge Rate Code and Rate Type While settling charges for cross currency transactions you can choose to debit the customer by applying the mid rate buy rate or by using the buy sell spread over the mid rate Therefore you need to specify the Exchange Rate details for each ARC definition record that you maintain in the system Firstly indicate the R
9. Browser by typing FTDRCST in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button Retail Teller Settlement Details Maintenance Settlement Customer Settlements Route Code Description Product Code Nostro Account 2 Nostro Account Branch laz Intermediary Reimbursment Institution Intermediary 2 a EOE EE DRRR Country laz Country Receivers Correspondent Account With Institution P A a P nony Receiver Country EH Country F Cover Required Sender to Receiver Information Beneficiary Institution EJB Fale E S m Input By DOC7 Date Time Modification Number M Authorized Authorized By Date Time I open This screen contains fields that explore possible routes of the transfer Depending on the type of transfer you are initiating and on the number of banks involved in the transfer you can enter details of the parties involved in the transfer route The country information is captured to enable Mantas to analyze the transactions for possible money laundering activities 6 7 ORACLE For more details on Mantas refer Mantas interface document Route Code This is an identifier for the transfer route that you are creating During a retail teller transaction input you can use this route code to call up the settlement and messaging details that you maintain in this screen Intermediary Reimbu
10. CC will be calculated in the following manner For local and non local checks when the aggregate deposit amount in a day lt 5000 Sch1 Transaction day 1 100 Sch2 Available day 1 400 Sch3 Available day Balance For local and non local checks when the aggregate deposit amount in a day gt 5000 Sch1 Transaction day 1 100 Sch2 Available day 2 400 Sch3 Available day 1 4500 Sch4 Available day Balance For federal or special checks the funds are made available only on the next business day irrespective of the amount deposited and the checks are not considered for Regulation CC scheduling Examples of processing Checks for Req CC in Oracle FLEXCUBE Let us assume that you have maintained an ARC product with the following parameters P1 For Special Checks Normal Float Days 1 Float Days for Large Deposits 1 5 10 ORACLE Float Days for New Accounts 9 P2 For Local Checks e g Routing code 1000 Normal Float Days 2 Float Days for Large Deposits 3 Float Days for New Accounts 11 P3 For Non Local Checks e g Routing code 1200 Normal Float Days 5 Float Days for Large Deposits 6 Float Days for New Accounts 11 Scenario If on a given day only a special check is deposited for 9000 Day 1 next business day availability 9000 Scenario Il If on a given day only a special
11. Cr Closing Balance 40550 Cr 40550 Cr 5 1 2 Specifying Reject Details To specify the reject account details click on the Preferences button in the ARC Maintenance screen Preference Bank Code Local Float Days C Txn Offset Accounting Entry Required Reject Details Reject Account Reject Branch Reject Currency In this screen you can specify the following details Bank Code Specify the bank code of the remitter for the arc resolution Txn Offset Accounting Entry Required Check this box if transaction offset accounting entry is required Local Float Days Specify the number of local float days The specified number of local float days will be considered only if the Local clearing option is checked in the Cheque Deposit screen Reject Branch Specify the branch code of the reject account The adjoining option list displays all the valid reject account branches maintained in the system You can select the appropriate one 5 15 ORACLE Reject Account Specify the GL or account number of the reject account The adjoining option list displays all the valid reject account GL or account numbers maintained in the system You can select the appropriate one Reject Currency Specify the currency of the reject account The adjoining option list displays all the valid reject account currencies maintained in the system You can select the a
12. and it is necessary to store the number of Form or for Remittance Letter in which each cheque was sent The system will create an unique Form number assigned for a unique combination of correspondent bank origin city city where cheque is deposited type of collection cheque The system will create an unique Remittance Letter number assigned for a combination of correspondent bank origin city city where cheque is deposited type of collection cheque Clearing City city where the cheque is drawn Correspondent bank s charges are calculated Correspondent bank s fee other charges plus the IVA which should be paid to the correspondent bank This calculated commission is stored for reporting purposes and liquidation at a later date The system will calculate the expected value for each Form and Remittance Letter Expected value Value of Form or Remittance Letter Correspondent bank s charges IVA Value of Form is the sum of the individual value cheques included in the Form Value of Remittance Letter is the sum of the individual value cheques included in the Remittance Letter The accounting of the Expected value is done on the expected date of payment sent date clearing floating days of correspondent Bank If this due date is a non working day then it will be done the following working day You can invoke the Collection Cheque Correspondence screen by typing CGDDISCH in the field at the top right corner of
13. at the top right corner of the Application tool bar and clicking on the adjoining arrow button ORACLE T Clearing Rejection Code Maintenance X Maker A31561A01 Date Time Checker AJ1561A01 2011 12 30 20 04 19 Date Time n as Aaaa Exit Mod No 2 Record Status Open Authonzation Status Authonzed In this screen you have to specify a reject code and give a description of the same A reject code has to be assigned to every cheque that you reject Select CHQ as the instrument used and check the Charge Applicable box You can also mention a reason for application of charge For all reject codes where charge is applicable a charge basis is automatically created by the system using the rule type in the ICCF Rule Maintenance screen You have to link the charge basis to a charge product in the IC module You can check the box Include for Cheque Return Counter to indicate that the reject code is considered for incrementing the return counter when the cheque comes in for clearing Refer to the Interest and Charges user manual to find out how to create a charge basis If you wish to levy charge for a dishonored check then when marking the check as dishonored specify a reject code that has a charge basis linked to it You can do this in the Interface Clearing Details screen which is explained in the next section On authorization of dishonored checks the system will validate if the reject code associat
14. check is deposited for 4500 Day 1 next business day availability 4500 Scenario Ill If on a given day a special check of 6000 is deposited along with a local check of 1000 Day 1 next business day availability 6000 500 Day2 500 Scenario IV If on a given day a special check of 4000 is deposited along with a local check of 3000 Day 1 next business day availability 4500 Day2 2500 Scenario V If on a given day a special check of 1000 is deposited along with a local check of 6000 Day 1 next business day availability 1500 Day2 4500 Day3 1000 Scenario VI If on a given day only a local check of 4000 is deposited Day 1 next business day availability 100 Day1 400 ORACLE Day 1 next business day availability 100 Day2 3500 Scenario VIl If on a given day only a local check of 9000 is deposited Day 1 next business day availability 100 Day1 400 Day2 4500 Day3 4000 Scenario VIII If on a given day a special check of 3000 is deposited along with a local check of 1000 Day 1 next business day availability 3500 Day2 500 Scenario IX If on a given day a special check of 300 is deposited along with a local check of 3000 Day 1 next business day availability 800 Day2 2500 Scena
15. city of deposit type of collection cheque e If Format to inform or report collection cheques sent is equal to CR the cheques are classified by gt Origin City where the collection cheque was deposited gt Type of collection cheque namely Negotiated or Non Negotiated gt In this case one Remittance Letter should be generated for each correspondent bank for a combination of city of deposit type of collection cheque place where cheque is drawn For instance if there are 3 collection cheques of Non Negotiated type and 5 collection cheques of Negotiated type which are drawn on a correspondent bank but all drawn on different cities and if the correspondent bank agreement indicates generation of Remittance Letter then one Remittance Letter is generated for a unique combination of correspondent bank city of deposit type of collection cheque Clearing City when the drawee Bank is a drawer bank the cheque is not included in the classification process described above For each correspondent Bank the system should display the list of the cheques according to the classification mentioned above The list must contain the cheques pending to be sent 3 15 ORACLE When the user confirms the system will assign a sequence number for Form PL or for Remittance Letter CR showing that the flagged cheques were sent with Form number or Remittance Letter number These cheques are flagged as SENT
16. not considered for large deposit exception Checks given such special availability will not be governed by the Reg CC schedules 5 8 ORACLE Note the following e In case of cash deposits electronic payments and transactions through proprietary non proprietary ATM the next day availability can be enabled through the appropriate transaction code and these transactions must not be considered for Regulation CC e Checks for which collection is doubtful and re deposited checks should be posted using separate products that are not considered for Regulation CC with the desired float for the products being defined in the ARC Maintenance Availability depends upon the specifications in the Clearing House Holiday Maintenance and the Branch Holiday Maintenance The value date is first arrived at using the clearinghouse calendar and if it happens to be a branch holiday it is moved to the next working day During transaction processing the value date for Reg CC availability for the check deposit gets defaulted based on the Credit Account and the ARC Maintenance for the Clearing Product 5 9 ORACLE To specify the Reg CC details click Regulation button in the ARC Maintenance screen The Reg Details screen is opened where you can specify the details C Consider for Regulation cc C Special Availability Large Deposit Float New Account Float The schedule for the availability of funds for check deposits under Reg
17. the booking date for the bank leg of the transaction e The Floating Days to calculate the booking date for the customer leg e The Exchange Rate applicable etc If you process a thousand such outward clearing transactions in a day you would need to repeat these operations as many times By defining outward clearing transactions as a product in Oracle FLEXCUBE and defining standard attributes for it you can simplify the task of processing clearing transactions Every time you process a clearing transaction under a product Oracle FLEXCUBE automatically applies the attributes defined for the product 4 1 ORACLE However if required you can change the inherited attributes at the time of processing Clearing Product Definition Product Code Exchange Rate Variance in Product Description Override Limit Product Type Stop Limit Description Rate Code Slogan Rate Type Preferred Product Group Product Group Description Start Date End Date Remarks Roe To Hoad Events ranch Currency Preterences ms nas Maker Date Time Mod No Checker Date Time Record Status Authorization Status For any product you create in Oracle FLEXCUBE you can define generic attributes such as branch currency and customer restrictions interest details tax details etc by clicking on the appropriate icon in this screen For a loans product in addition to these generic attributes you can specifically define other attributes These attribu
18. will be used to a customer to achieve waiver requirement e During expected value payment system will debit clearing service commission from drawer bank expense account maintained for correspondent bank document type and various payment indicator combinations in clearing product maintenance e During rejection of collection the system will find out charge amount that was waived at the time of cheque deposit The charge amount thus found will be collected from customer account 3 2 3 Dispatching Collection Cheques Oracle FLEXCUBE allows you to generate form or remittance letter on an agreement basis with the correspondent bank This is done on a daily basis For each correspondent bank and based on the correspondent bank agreement table e If Format to inform or report collection cheques sent is equal to PL the cheques are classified by gt Origin City where the collection cheque was deposited gt Type of collection cheque namely Negotiated or Non Negotiated gt In this case one form should be generated for each correspondent bank for a combination of city of deposit and type of collection cheque For instance if there are 3 collection cheques of Non Negotiated type and 5 collection cheques of Negotiated type which are drawn on a correspondent bank and if the correspondent bank agreement indicates generation of Form then one form is generated for a unique combination of correspondent bank
19. 2 Check Deposit Outward 1000 Cr Clearing Chq 2 5 13 ORACLE Transaction Transaction Details Transaction Book Balance Available D amount balance ate 15 Jan 02 Check Deposit Outward 1500 Cr Clearing Chq 3 15 Jan 02 Check Deposit Outward 1750 Cr Clearing Chq 4 15 Jan 02 Check Deposit Outward 5000 Cr Clearing Chq 5 Closing Balance 250 Dr 10000 Dr 16 Jan 02 Check Deposit Outward 1500 Cr Clearing Chq 1 Check Deposit Outward 1000 Cr Clearing Chq 2 Check Deposit Outward 1500 Cr Clearing Chq 3 Check Deposit Outward 1750 Cr Clearing Chq 4 Check Deposit Outward 5000 Cr Clearing Chq 5 Hold Funds Cleared 500 Cr Closing Balance 10500 Cr 9500 Dr 17 Jan 02 Hold Funds Cleared 4750 Cr Closing Balance 10500 Cr 4750 Dr 18 Jan 02 Hold Funds Cleared 4500 Cr Closing Balance 10500 Cr 250 Dr 19 Jan 02 Hold Funds Cleared 750 Cr Closing Balance 10500 Cr 500 Cr 20 Jan 02 Hold Funds Cleared 250 Cr Closing Balance 10500 Cr 750 Cr 21 Jan 02 Hold Funds Cleared 4750 Cr Closing Balance 10500 Cr 5500 Cr 5 14 ORACLE Transaction Transaction Details Transaction Book Balance Available amount balance Date 22 Jan 02 Hold Funds Cleared 5000 Cr Closing Balance 10500 Cr 10500 Cr 25 Jan 02 Cash Deposit 30050
20. 3 1 1 Maintaining Clearing Details of your Bank For Oracle FLEXCUBE to handle clearing transactions you have to capture clearing information at the Head Office of your bank This information would apply to all the branches of your bank You can maintain clearing related information for your bank in the Bank wide Parameters screen invoked from the Application Browser In the Clearing Bank Code field specify the code by which your bank is identified in the Clearing Network you participate in The code you specify for your bank in this screen has to the same as that specified for your bank in the Clearing Bank Code Maintenance screen In addition to specifying the clearing code that identifies your bank you have to specify a Routing Mask for your bank A mask defines the manner in which a Routing Number is generated for your bank It is on the basis of the routing number that Oracle FLEXCUBE processes inward clearing transactions The following is a typical mask format BBBbbbSSS wherein BBB indicates the bank code pbb indicates the branch and SSS indicates the sector to which the branch belongs On the basis of the routing number inward clearing transactions are routed to the appropriate branch of your bank For more details about the Bank wide Parameters screen refer the Core Services user manual Defining Sectors In Oracle FLEXCUBE you can identify specific geographical areas as sectors A s
21. Account Beneficiary Account Instrument Currency Instrument Amount E lt i r Authorization Status Contract Status r Reconcilation Status A Authorized O Open R Reconciled U Unauthorized C Close U Unreconciled V Reverse N Not Applicable You can query the clearing transactions based on the following details Authorization Status Select the authorization status of the transaction you are querying from the drop down list e A Authorized e U Unauthorized Contract Status Select the authorization status of the transaction you are querying from the drop down list e O Open e C Close e V Reverse Reference Number Select the reference number of the transaction you are querying from the option list External Reference Select the external reference of the transaction you are querying from the option list 6 5 ORACLE Product Code Select the product code of the transaction you are querying from the option list Instrument Date Specify the instrument date of the transaction you are querying from the option list Remitter Select the remitter of the transaction you are querying from the option list Beneficiary Select the beneficiary of the transaction you are querying from the option list Remitter Account Select the remitter account of the transaction you are querying from the option list Beneficiary account Select the beneficiary account of the transactio
22. Clearing Oracle FLEXCUBE Universal Banking Release 11 3 83 02 0 April 2014 Oracle Part Number E53607 01 ORACLE FINANCIAL SERVICES Clearing Table of Contents 1 ABOUT THIS MANUAL ju cccsscescscsecsecsnsscsssscsssssesesssnessssnesscssesssssssnssessnesesssessossssessossnesssssessesseesoseeees 1 1 1 1 INTRODUCTION cas cisciscssstasetslsvecitstecs sees rentre eds ne EA AE EE NE ESE EE A A AEEA SREE 1 1 Mids A UDIENGE nn eves sda nn sacs E AEE S A EREE EEEE EER EEE 1 1 13 ORGANIZATION 325 20sc 005s e5s3sveoss aree ER Ea oa EAEE EE A Sae E EEA E OE EERE EAER E EE EE 1 1 l4 RELATED DOCUMENTS riesia staae a osae AE e ESA Sa E AE TANE E E ea EE EEE 1 2 15 GLOSSARY OF ICONS nn ireen bees anaE AEE SE EAE E a E E EE E a AESI EEEE 1 2 2 AN OVERVIEW sccsscsssssssscssescssscsssccsnsssescsssnesssensssccnsssssssssnssssenssscsncesesssssssssssnesssssessosssssossssssessnssoesossossesees 2 1 2 1 INTRODUCTION sssicscaceiecscovcsssiscsvssdecsncssesscsuessecuavds obscuacdvecutesiosdeddes teshceteesesddes tete niet deg sadeeeresedesa c dant ne dues 2 1 3 MAINTAINING REFERENCE INFORMATION mnnenenenennnnenerenenenenenenerenes 3 1 3 1 INTRODUCTION 55523505325 nn te tete en nie ne ent tie ren nt nr Reed tent tee ester need ts 3 1 3 1 1 Maintaining Clearing Details of your Bank sise 3 2 3 1 2 Defino SCCLONS aano mr a E EE E E A E E E O en A E A E RA 3 2 3 1 3 Maintaining Clearing Details of Banks ss 3 3 3 1 4 Maintaining Clearing S
23. Collection CGDDISCH Collection Cheque Correspondence CGDBNKPM Clearing Product Maintenance CGDDOCEX Retention Exception Maintenance CGSPAQRY Parity Process Query 10 1 ORACLE Function ID Function Description CGDREJCD Reject Account Error Code 10 2 ORACLE ORACLE Clearing April 2014 Version 11 3 83 02 0 Oracle Financial Services Software Limited Oracle Park Off Western Express Highway Goregaon East Mumbai Maharashira 400 063 India Worldwide Inquiries Phone 91 22 6718 3000 Fax 91 22 6718 3001 www oracle com financialservices Copyright 2005 2014 Oracle and or its affiliates All rights reserved Oracle and Java are registered trademarks of Oracle and or its affiliates Other names may be trademarks of their respective owners U S GOVERNMENT END USERS Oracle programs including any operating system integrated software any programs installed on the hardware and or documentation delivered to U S Government end users are commercial computer software pursuant to the applicable Federal Acquisition Regulation and agency specific supplemental regulations As such use duplication disclosure modification and adaptation of the programs including any operating system integrated software any programs installed on the hardware and or documentation shall be subject to license terms and license restrictions applicable to the programs No other rights a
24. DATMMN 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 Leg for the Account Class Product aa oe Transaction Type SE ce FN Currency Transaction Details End Point Account Class Product Account Class Branch Bank Float Days Product Type Account Description eae eas El Transaction Code Customer Float Days Working Offset Transaction Debit Account Description Code 2 a Main Transaction Code ENGE T OCA Branch Name i i Management Description Liquidation Product for Information System Customer Group Demand Draft Generate MT101 k Nettin cet See ening Charges Exchange Rate Revaluation Profit Revaluation GL Loss Revaluation GL Charge 1 Charge2 Charge3 Charge4 Charge5 Basis Rate Charge Account Minimum Charge Transaction Code Maximum Charge Charge Type Rate Type Currency Amount Rate Code Description Netting MIS Head Slab Type Interest Basis Their Charge Fields Regulation Input By Authorized By Modification Authorized Exit Date Time Date Time Number Open In the ARC Maintenance screen you primarily define parameters for processing clearing transactions involving a specific product currency and branch combination and involving a specific Clearing House in case of an inward clearing transaction or a Sector in case of an outward transaction Towards this you must specify the following details
25. Date 7 4 ORACLE 7 5 1 7 6 Specify the transaction date Click OK button to generate the inward clearing extract report click Exit to return to the Reports Browser Contents of the Report The contents of the report are discussed under the following heads Header The Header carries the Branch of the report information on the branch and date the ID of the user who generated the report the date and time at which it was generated and the module of the report Body of the report The generated report will be ordered by the batch number and currency The Batch No 4 7 character of Reference Number The Summation will be for Number of entries amount Transaction Branch This indicates the transaction branch Remitter Account This indicates the remitter account Beneficiary Account This indicates the beneficiary account Customer Name This indicates the customer name Cheque Number This indicates the cheque number Value Date This indicates the value date Reject Reason This indicates the reject reason Currency This indicates the currency Amount This indicates the amount Inward Clearing Extract Forcefully Passed Entries The bank will forcefully pass some of the entries which had failed earlier A report is required of how many passed forcefully with details You can invoke Inward Clearing Extract Forcefully passed Entries screen by typing
26. IT for which you can define the following entries Debit Credit Indicator Accounting Role Amount Tag 6 9 ORACLE Debit Credit Indicator Accounting Role Amount Tag Debit Nostro with the collecting bank Check amount Credit Clearing Suspense account Check amount Debit Clearing Suspense account Our charges Credit Income Our charges Step 2 This is the liquidation event for which you can define the following entries Debit Credit Indicator Accounting Role Amount Tag Debit Clearing Suspense account Check amount Credit Customer Check amount Debit Customer Our charges Credit Clearing Suspense account Our charges Debit Customer Collecting bank charges Credit Collecting Bank charge Account Collecting bank charges When clearing charges are collected from the customer after credit Step 1 This is the registration event The following entries can defined for this event Debit Credit Indicator Accounting Role Amount Tag Debit Nostro with the collecting bank Check amount Credit Clearing Suspense account Check amount Step 2 This is the liquidation event The following entries can be defined for this event Debit Credit Accounting Role Amount Tag Indicator Debit Clearing Suspense account Check amount Credit Customer Check amount Debit Customer Our charges Credi
27. Non Local Product Outward Clearing Product 1of1 imi Product Code DocumentType Local Clearing Various Payment Outward Clearing Return Product Clearing Se j Inward Clearing Product 10f1 E Product code Document Type Maker Date Time Mod No Checker Record Status Date Time Authorization Status Here you can specify the following details Bank Code Specify the bank code Internal Product Specify the product that should be used for internal clearing Non Local Product Specify the product that should be used for non local clearing Protest Inward Product Specify the product that should be used for inward clearing of the protested cheque Protest Internal Product Specify the product that should be used for internal clearing of the protested cheque 4 1 2 1 Maintaining Outward Clearing Product You can maintain different outward clearing products using the document type and local clearing 4 6 ORACLE Product Code Specify the product code that should be mapped to the combination of document type and local clearing Document Type Specify the type of the instrument that should be mapped to the specified product code The following are the codes of the documents e Cheque 01 e DD 02 Local Clearing Check this box to indicate that the local clearing should be mapped to the specified product code Outward Clearing Return Products Specify the type of the return produ
28. aft In these cases tax will be recovered from the account to be credited However outward clearing transactions should be exempted from ITF if the cheque collection occurs between accounts of different banks held by the same single holder both remitter and beneficiary accounts belong to same single holder Inward Clearing Transactions ITF is charged on the inward clearing transactions in the following cases e Remitter and beneficiary account holders are different e Either remitter or beneficiary or both accounts are of joint holder type e If the clearing instrument is a DD demand draft In these cases tax will be recovered from the account to be debited However inward clearing transactions should be exempted from ITF if the cheque collection occurs between accounts of different banks held by the same single holder both remitter and beneficiary accounts belongs to same single holder 6 4 ORACLE 6 6 Clearing Batch Process CGUPLOAD CGUPLOAD batch can be configured as intra day batch to process the uploaded clearing data This will process the clearing upload data which are in unprocessed status and creates the clearing transaction based on the instrument type instrument product e Ifthe instrument type is CHEQUE DD or BC and the product type is OC Outward clearing the system will create the outward clearing transaction e Ifthe instrument type is CHEQUE and the product type is
29. ail transactions will be from the product preferences for the currencies involved in the transaction If a record is not maintained for the given product and specific currency combination the system will check for the currency combinations given in Annexure Il If no record is found for all the given combinations the system will pickup the rate code and type from the product definition Indicating the Offset Details You can specify the branch and the offset account or GL into which offset entries are to be booked In case of an inward clearing transaction this would typically be the Liability GL for Inward Checks to which the credit entries would be posted The customer account would be debited In case of an outward clearing transaction this would be the Liability GL maintained for Outward Checks to which the debit entries would be posted The customer in this case would be credited Indicating Transaction Details You can specify the branch and the account number in which the transaction is taking place The account in this field is the customer account In case of inward clearing transactions this account number would be available on upload of clearing transactions Indicating Transaction Codes A unique Transaction Code identifies all transactions in Oracle FLEXCUBE As part of ARC maintenance you can indicate the offset transaction code and the main transaction code You have to choose a transaction code for which the status of th
30. ained e INIT Deposit of Cheque e DCLG Dispatch to Clearing e LIQD Liquidation of Cheque The CGBEOD batch is run for outward clearing to handle the accounting entries on Day 1 and Day 2 The batch is setup to run at the End of Transaction Input Stage to process eligible clearing contracts The system fires INIT event and passes the accounting entries based on the product setup and marks the status of the contracts as Deposited in case of deferred liquidation This happens online during contract booking itself The system fires DCLG event and marks the status as Dispatched on the day of dispatch Book Date Number of Dispatch days The system automatically liquidates all the contracts which are in Dispatched status on Liquidation date Book Date Liquidation Days On Liquidation Date the system reverses the accounting entries passed for INIT and DCLG events i e it passes the REVR event accounting entries and LIQD event accounting entries and marks the status as Liquidated The system picks up the accounting entries setup for the events INIT and DCLG from Clearing Product and LIQD from ARC Maintenance 4 11 ORACLE 4 3 Processing Reversals Reversal of individual clearing entries will be processed automatically by the system in case of any CASA related errors or any other error while processing the individual instruments The CASA Reversal Transaction Code specified in the Clearing Product Preferences
31. ate Code for which different rates can be maintained A list of all the rate codes maintained in the Floating Rates Maintenance screen is displayed in the list You can choose the appropriate code In addition to specifying the Rate Code you have to indicate the Rate Type which should be picked up for exchange rate conversions involving settlement of charges for cross currency transactions You can maintain any one of the following as the Rate Type e Buy e Mid e Sell After identifying the Rate Code and Rate Type you can indicate the basis amount on which charges are to be computed 5 7 ORACLE Amount You have to specify the flat amount only when the charge type is a Flat Amount The flat amount will be collected in the currency that you have specified in the Charge Currency field Rate If you have indicated that the charge should be a percentage of the transaction amount you have to necessarily capture the rate that is to be applied on the transaction amount The rate that you specify will be applied after converting the amount into the Account Currency Interest Basis Interest Computation basis 360 days 365 days etc Minimum and Maximum Charge Amount When the charge type applicable on the transaction is a percentage of the transaction amount you have to capture the minimum and maximum charge amounts that should be applied on the transaction If the charge percentage involving a particular transaction is less than th
32. ated Clearing Entry of which this instrument was a part Rejected transactions can be reprocessed as usual Consolidated Clearing Entry will not be passed while reprocessing rejected transactions The values of Insufficient Funds Reversal Transaction Code and the CASA Reversal Transaction Code can be specified in the Clearing Product Preference screen These fields are applicable only for Inward Clearing products only Each individual transaction Upload table will be marked with the Reference Number generated for passing the Consolidated Clearing Entry and an option indicating whether reversal has been done or not 4 12 ORACLE 5 Introduction Maintaining Account Rate and Charge Details 5 1 Once you have captured the basic information required for processing clearing transactions in Oracle FLEXCUBE you have to maintain information that would be required to process clearing transactions involving a specific product In the Account Rate and Charge ARC Maintenance screen you have to maintain information that will be used to e Route transactions belonging to a specific product branch and currency combination to a specific Clearing House Sector Code e Post accounting entries generated by clearing transactions involving a specific product to specific accounts e Calculate and apply the specified charges The ARC Maintenance screen can be accessed from the Application Browser You can invoke this screen by typing IF
33. cheques If an account does not have sufficient fund to pay commission charges tax the system will forcefully debit the account Commission Waiver The following points need to consider while calculating commission e The calculation of commissions must consider the commission waiver of the customer e The commissions postages and telex could be partially or fully waived e When cheques are returned waivers are not applicable and bank recovers the full commission that was due at the time of deposit e The waiver of commissions postage and telex has an expiration date 3 14 ORACLE e In certain specific cases for clients or employees of the bank or for other cases like credit card payments proceeds of collection cheques are not credited into customer s account but routed through a GL Therefore it must be possible to route Negotiated type of collections through a GL In cases where the collection cheque proceeds are routed through a GL no commissions or taxes or any other charge is collected e The collection cheque transactions will be done using ARC product These products will have to be maintained for different correspondent banks e The charge commission will be defined at ARC product level e The clearing product maintenance will be used to maintain products for negotiated and non negotiated type of cheque e The waiver for customers will be achieved through relationship pricing module in Oracle FLEXCUBE This scheme
34. clearing type and the possible options are e Inward Clearing IW e Internal Clearing IC e Outward Clearing OW Error The system displays the error code Description The system displays the error description You can only perform Close Reopen and Query operations in the screen 6 13 ORACLE 6 5 Querying Clearing Repair Upload Summar You can modify the details for multiple clearing transactions using Query Clearing Upload screen You can use this screen for both inward clearing as well as outgoing clearing transactions and you can also authorize reject clearing transactions in bulk You can invoke this screen by typing CGDCLGDT in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button Query Clearing Upload re m External Reference _ End Point Remitter Account Product _ Remitter Branch 73 Instrument type Beneficiary Account Remitter Account 28 Direction Inward Transaction date FA Currency Rejected Code i Queny Save Au Status x Instrument Number User ID 4 Amount Currency 3 Authorization Status ARARR Clearing Details tof El Source Code instrument type Upload Status Unique Identifier Type Unique Identifier Value Instrument Date Remitter Bank Beneficiary Branch Beneficiary Bank Branch Bank Validate You can query the
35. creen You can invoke this screen by typing CGSPAQRY in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button Parity Process Query Proccesing Date Deposit Slip Number Referential Entry Clearing Reference Number Number Referential Entry Clearing Booking Date Booking Date Referential Entry Amount Clearing Amount Referential Entry Mismatch Details Processing Date Deposit Slip Number Referential Entry Number Referential Booking Date 2 You can enter the following details in this screen Processing Date Specify the batch processing date Deposit Slip Number Specify the deposit instrument number e g cheque number The adjoining option list displays all the valid deposit slip numbers maintained in the system You can select the appropriate one 6 3 ORACLE 6 3 Referential Entry Number Specify the referential entry deposit slip number number The adjoining option list displays all the valid referential entry numbers maintained in the system You can select the appropriate one Clearing Reference Number Specify the clearing contract reference number generated by FLEXCUBE The adjoining option list displays all the valid clearing reference numbers generated You can select the appropriate one Referential Entry Booking Date Specify the date on which the referential entry contract was booked Clearing Booking Date Specify the date on w
36. ct that should be mapped to the outward clearing product If original clearing contract is created only with one cheque a reject clearing contract will be created using the Outward Clearing Return Product If original clearing contract contains multiple cheques the return contract will book only for that cheque using the Outward clearing Return product In Oracle FLEXCUBE if the cheque is returned after the clearing process including the liberation of retention from other bank the depositors account has to be debited to reverse the associated payment For this purpose you need to reverse the cheque deposit manually If the customer account balance is insufficient the reversal transaction will not be allowed In this case the system will wait for one month and will also debit the transit GL Suspense GL and issue a Demand Draft Interbank The DD issuing GL will be picked from the multimode settlement For this you need to maintain Multimode settlement for clearing and settlement mode INS Refer the Maintaining Multi Mode Settlement Details section under the chapter Settlement Service to know more about multimode settlements Various Payment Select the various payment from the drop down list You have the following options e Various Payment e Negotiated e Non Negotiated e Adjustment Transaction e Others Clearing Service Product Specify the clearing service product The adjoining option list displays all the valid me
37. ctorCode CustomerFloatDays BankFloatDays BranchAddress1 Branc Feas Prterences Date Time Date Time Input By Authorized By Modification bone The information you capture in this screen is required to route outward clearing transactions to the appropriate clearing house Every bank participating in the Clearing network is identified with a unique code In this screen capture the code of the participating bank and enter a brief description that will help you easily identify the bank You also have to capture the following information for every branch of a participating bank The Branch Code as identified in the network A brief description of the branch The number of late reject days for generating DD in the case where the cheque is returned late The sector to which it belongs The customer float days The float days for bank and sector code combination The branch address 3 3 ORACLE During outward clearing the retention code will be the sector code You can maintain the retention codes in the sector code maintenance screen Country Specify the country of the bank code This adjoining option list displays all valid country codes maintained in the system You can choose the appropriate one The country information is captured to enable Mantas to analyze the transactions for possible money laundering activities For more details on Mantas refer Mantas interface document You can maintain differe
38. d type of cheque the system will re establish the cheque limits The system will reverse memo accounting and will also reverse accounting entries using outward return product maintained for the bank clearing type document type and various payment indicator combination During BOD the system will scan the unconfirmed or unreturned collection cheques with the status Sent and are overdue for the collection or Pending and are overdue Based on the dispatch float days depending on the processing date will be marked with the status as Lost Identifying End Point Details In Oracle FLEXCUBE clearing houses are also referred to as end points To facilitate error free processing of clearing transactions you need to maintain end point details and map an end point to a clearing house Invoke the End Point Details screen from the Application Browser to maintain end point details You can invoke this screen by typing STDENDPT in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button 3 18 ORACLE End Point End Point End Point Description End Point Literal Clearing House Input By Authorized By Modification Authorized Leu Date Time Date Time Number Open In this screen you achieve two things e Identify an end point with a unique code and description e Map every End Point you are maintaining with a Clearing House Enter a unique co
39. de and a brief description to identify an end point in other words a clearing house In Oracle FLEXCUBE a nine digit number identifies end points and a three digit number identifies clearing houses By mapping an end point to a clearing house you identify the end point captured at the branch as a valid clearing house maintained in Oracle FLEXCUBE 3 19 ORACLE 4 1 4 Maintaining Clearing Products Introduction In this chapter we shall discuss the manner in which you can define attributes specific to a Clearing CG product You can create a clearing product in the CG Product Definition screen You can invoke this screen by typing CLDFNPRD in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button In this screen you can enter basic information relating to a clearing product such as the Product Code the Description etc The advantages of defining a product Let us consider the steps involved in processing an outward clearing transaction for example your customer presents a check drawn on another bank at your bank Your specifications would include the following e The Code of the bank on which the instrument is drawn as identified in the Clearing Network e The Code of the branch on which the instrument is drawn as identified in the Clearing Network e The Clearing Network through which the instrument has been routed e The Floating Days to calculate
40. der In Oracle FLEXCUBE internal clearing transactions the retention day is one 4 2 1 Maintaining Retention Exceptions for Outward Clearing You can create modify remove and query a corporate customer account that requires an exception on retention days in Oracle FLEXCUBE while crediting the funds through outward clearing transaction You can invoke this screen by typing CGDDOCE in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button 4 8 ORACLE Retention Exceptions Maintenance Branch Code Account No Executive Modification Date Document Retention Exception tof HE pe Maker Date Time Checker Date Time Here you can specify the following details Branch Code Specify the branch code of corporate customer whose account should be excluded from retention days for outward clearing contracts Account Number Specify the account number that should be excluded from retention days for outward clearing contracts For this account retention days will be calculated as zero Executive Specify the code of the executive who should be assigned for maintaining the retention exception for the corporate customer Modification Date Specify the date on which the record is created modified Document Type Specify the document type for which the exception is required The adjoining option list displa
41. djoining option list displays all the valid drawee cities maintained in the system You can select the appropriate one Deposit City Specify the branch maintained for the deposit city The adjoining option list displays all the valid deposit cities maintained in the system You can select the appropriate one Document Type Specify the document type The adjoining option list displays all the valid document types maintained in the system You can select the appropriate one Collection Processing Exception Check this box to indicate whether the cheque is of special type or not Routing GL for Exception In case of special clearing specify the routing GL where the proceeds of collection should go Clearing City The system will resolve the clearing city based on the Drawee bank and drawee city Collection Type The system displays the collection type The possible values are Negotiated or Non negotiated 3 13 ORACLE 3 2 2 Correspondent Bank The system displays the correspondent bank Correspondent Branch The system displays the correspondent branch Transaction Reference Number The System will generate transaction reference number for each cheque deposited in Oracle FLEXCUBE The following validations need to be done If collection cheque is deposited to a current account then the system will verify if cheque amount can be covered by active cheque limits linked to the account If cheque amount i
42. e following details Reference Number The system displays the reference number Deposit Slip Number Specify the deposit slip number Account Number Specify the beneficiary account number to which cheques are deposited The adjoining option list displays all the valid account numbers maintained in the system You can select the appropriate one Depositor Name Specify the name of depositor Name of Account Holder Specify the name of the account holder Transaction Branch Specify the transaction branch The adjoining option list displays all the valid transaction branches maintained in the system You can select the appropriate one Total Amount Deposited Specify the total sum of cheque amount of all the cheques deposited 3 12 ORACLE 3 2 1 1 Specifying Cheque Deposit Details Instrument Number Specify the instrument number Instrument Date Specify the instrument date Instrument Amount Specify the instrument amount Drawee Account Number Specify the drawee account number Drawee Bank Specify the drawee bank The adjoining option list displays all the valid drawee banks maintained in the system You can select the appropriate one Drawee Branch Specify the branch maintained for the drawee bank The adjoining option list displays all the valid drawee branches maintained in the system You can select the appropriate one Drawee City Specify the branch maintained for the drawee city The a
43. e minimum charge the system will by default debit the customer account with the minimum charge amount If the charge percentage exceeds the maximum amount the system will debit the customer account with the maximum charge amount The charge amount will be deducted in the currency that you specified in the Charge Currency field MIS Head Specify the MIS Head that is applicable for the charge related accounting entry Description You can indicate a short description for the charge If you have provided a charge it is mandatory to enter the description 5 1 1 6 Specifying Regulation CC Availability for Clearing Products In addition to the accounting entry and charge definition you will also have to maintain the following ARC details to incorporate the Regulation CC requirements Indicate whether Regulation CC rules apply to the product that you are defining Each check deposited will have a nine digit routing number or a four digit routing code associated with it which determines the clearing float days for the check and the funds availability schedule You will have to indicate the Float Days for the product for large deposits gt 5000 For deposits falling within the 5000 range you can specify the float days in the existing Customer Float Days screen Float days for new accounts Indicate that Special Checks that are given the next day availability should not be included in the next day availability calculation and are also
44. e option Cheque Mandatory is checked at the definition By this the system can track the used cheques End Point If you are maintaining ARC details for an outward clearing type product you should specify the branch the currency and the sector code that are part of the combination In addition you should specify the end point or clearing house to which branches in this sector report to and the bank and customer float days If you are maintaining ARC details for an inward clearing type product you should specify the branch currency and end points that form part of the combination From the pick list available in the Clearing House field specify the Clearing House for which you are maintaining ARC details Clearing Houses are also referred to as End Point Codes in Oracle FLEXCUBE Select the End Point Code of the Clearing House in the End Point field 5 4 ORACLE Bank and the Customer Float Days Float days indicate the number of days that are added to the booking date of an outward clearing transaction to arrive at its value date that is the day on which an account is actually debited or credited with funds As part of the ARC Maintenance for a transaction type you have to indicate the Bank and Customer Float days The term bank float days refers to the days that will be used to calculate the value date of the bank leg of a transaction The term customer float days refers to the days that will be used t
45. e process of handling customer transactions which force the accounts involved in such a transaction to exceed the overdraft limit Clearing transactions can force an account to move into overdraft While maintaining the details of a Clearing product you can indicate whether transactions involving the product need to be considered for referral checks Enabling this option indicates whether the product needs to be considered for referral If a product is marked for referral the details of transactions resulting in the account involved in the transaction moving into Overdraft will be sent to the Referral Queue If a clearing transaction breaches the limits the details of all transactions processed during the day will also be moved to the Posted Entries section in the Referral Queue You can choose to accept or reject the transactions The details of the transaction which has breached the limits will be displayed in the Unposted Entries section of the queue For further details on Referrals refer to the Processing Referrals in Oracle FLEXCUBE chapter of the Core Entities manual Defer Liquidation Check this box to defer liquidation of the selected clearing product Defer liquidation is applicable for outward Clearing products If Defer liquidation sets to Y System supports Stage wise accounting Indicating requirement for Referral Clearing transactions can force an account to move into overdraft You can indicate whether inward clearing t
46. ector encompasses the branches of the various banks in the geographical area As part of the maintenance required to process clearing transactions in Oracle FLEXCUBE you need to identify various sectors You can do this in the Sector Code Maintenance screen You can invoke this screen by typing STDSECMT in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button Clearing Sector Code Maintenance ee 0 Sector Code SECO1 Description SECTOR CODE FOR BRA Input ByA19740A401 Authorized ByA19740401 Modification 1 Authorized E Date Time2007 11 27 17 43 54 Date Time2007 11 27 17 43 54 Number R exit 3 2 ORACLE Identify a sector with a unique code In the Description field briefly describe the sector that you are maintaining With the sector code and description that you enter you should be able to identify the sector The sectors are typically maintained at the Head Office 3 1 3 Maintaining Clearing Details of Banks You have to capture clearing details of every bank participating in the Clearing Network in the Clearing Bank Codes Maintenance screen You can invoke this screen by typing DEDBNKCD in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button Bank Code Maintenance Bank Code Clearing Bank Name Clearing Branch Code lt Branch Code Branch Description Se
47. ed with a dishonored check has a charge basis linked to it and process charges accordingly Auto Reject of Inward Clearing Transactions The system automatically rejects the inward clearing transactions in the following cases e If the unique ID type value sent by the other Bank unique ID type and value stored at customer level of the remitter account holder do not match e Ifthe Same Holder selected as M and the remitter account is a joint account holder 6 12 ORACLE 6 4 In such cases the inward clearing transactions will be rejected automatically due to the mismatch of details provided in inward clearing file and details maintained with the debtor bank and ITF is not applicable Maintenance of Reject Account Error code Details You can close the error codes for which the system should not use the Reject Accounts using Reject Account Error Code screen You can open the error codes for which the system should use the Reject Accounts using Reject Account Error Code screen maintained at the ARC level You can invoke this screen by entering CGDREJCD in the field at the top right corner of the Application Toolbar and then clicking the adjoining arrow button Reject Account Error Code Clearing Type Error Error Description Maker Date Time Mod No Checker Record Status Date Time Authorization Status In this screen you can view the following details Clearing Type The system displays the
48. edpbienssigeds 7 2 TA INWARD CLEARING EXTRACT FAILED ENTRIES ccccccccecesecececececececececesecececececacececaceeecesaceeseeeaeesseeeaeeeaes 7 3 7 4 1 Contents of the RepOtt ssis nnes r E EE NEEE I o RE R ENEE A 7 4 7 5 INWARD CLEARING EXTRACT REJECTED ENTRIES cccccccecccecececececececececececececececeeacecececaceesseeaeeeseenaeenaes 7 4 7 5 1 Contents of The REDOTE o 2hcc cisesesssisnsvoosinaenvsnanesesssieteonoviseinapsdeducesistigesedsuienssipeceamsipoeesutasadeapedvbeonssigeds 7 5 7 6 INWARD CLEARING EXTRACT FORCEFULLY PASSED ENTRIES 7 5 7 6 1 Contents Of the Report soiig se tt nn AG SG Sav aaa nent Oued Hat nie 7 7 8 ANNEXURB E ici E AE E EE E A svuscessceavescscese 8 1 8 1 ORDER OF REPLACEMENT OF PARAMETERS WITH WILD CARD ENTRIES ess 8 1 9 ANNEXURER DD ccscicccsesesesssedececssusensneds ssdessensecescesdcesascdesesnetssueudbcdesesechdesousevsesoueceaudeucsesesensseesesessusebecssascossouss 9 1 9 1 DIFFERENT CURRENCY COMBINATIONS RATE CODE AND RATE TYPE PICKUP cccccccececeseseseseseseeeeess 9 1 10 SCREEN GLOSSARY sess cessissscascccssctactvssencdeccsssssteeastssevsesssesssecdscvocscesscboscsssesssesexdecsstedecsseubacesasbacessesseodseass 10 1 101 RUNCTION ED VIS RP aean ss uatwaeudegs ances dosctecdebed ona an usisneageds ee Eaa N aa ao EECA 10 1 ORACLE 1 About this Manual 1 1 Introduction This manual is designed to help you quickly get acquainted wi
49. er October November December Clearing House az Year Populate Holiday Details cc Input By Authorized By Modification Authorized Date Time Date Time Number Open In the Clearing House field specify the clearing house for which you are maintaining holiday details The dates on the calendar are marked in black and red The dates you mark in black are working days and dates you mark in red are holidays Click on a date to change its color Clearing Houses and Clearing House Holidays are typically maintained at the Head Office Refer the chapter Maintaining Clearing Holidays in the Core Services User Manual for details about this screen Maintaining Cheque Collection Details You can carry out cheque collection in bulk using Cheque Collection screen You can invoke this screen by typing CGDCKCOL in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button 3 11 ORACLE Cheque Collection Reference No Transaction Branch Deposite slip number Currency Depositor Name Total Amount Deposited Account Holder Remarks Account No Cheque Deposit Details 10f1 mj Instrument Number Instrument Amount Instrument Date Drawee Account Number Maker ID Checker Id Record Status Maker Date Stamp Checker Date Stamp Authorization Status Specify th
50. ervice Points ss 3 8 3 1 5 Maintaining Clearing Houses and Clearing House Holidays 3 9 3 1 6 Maintaining Clearing House Holidays ss 3 10 3 2 MAINTAINING CHEQUE COLLECTION DETAILS cc scscscseceesesssceeececsessesecececeesenaeeeseceeeesssseaecececeesenseaeeeeess 3 11 3 2 2 Commission Waiver issues merde E inner annee ienesmnnnte nn EE 3 14 3 2 3 Dispaichine Collection Ch ques ssi sante A E E EOE E EERE 3 15 3 24 Confirming or Denying the Collection Cheque sise 3 18 3 2 5 Identifying End Point Details nest a ne einer nn oies sense 3 18 4 MAINTAINING CLEARING PRODUCTS ssssnnneneennennenenerenenenennenerenenessee 4 1 4 1 INTRODUCTION PR E RS 4 1 4 1 2 Maintaining Clearing Product for Mapping Bank Code 4 5 42 MAINTAINING RETENTION DAYS as cacss2cscsses ses e EE states sagcedueesnusievtencavaderadsivstencetebapowsedbtoseetends 4 8 4 2 1 Maintaining Retention Exceptions for Outward Clearing ss 4 8 43 PROCESSING REVERSALS sai tao e ee na E E ses A N EE E EEE EEE Ei 4 12 5 MAINTAINING ACCOUNT RATE AND CHARGE DETAILS ssnnnennneneenee 5 1 5 1 INTRODUCTION E E E E A een nas enne dame g sens nee star de este Sete ne 5 1 5 1 2 Specifying Reject Details sisirin i a need ententes sb stone entente 5 15 6 VIEWING CLEARING TRANSACTIONS enrenennnnnnnnerenennennnennnenenennnnnnnerenenensee 6 1 6 1 INTRODUCTION aieiaeo easvasuposecssestgvansceots Sates sgststcsucede usage onceuts vascaalewsesu cot tenseur niques 6 1 6 1 1 Viewing Bulk Clea
51. es 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
52. hich the clearing contract was booked Referential Entry Amount Specify the deposit slip amount entered by the teller while creating the referential entry contract Clearing Amount Specify the clearing contract Amount You can view the following details in this screen e Clearing Entry Branch e Referential Entry Branch e Clearing Ccy e Referential Entry Ccy e Clearing Account number e Referential Account Number e Deposit Place e Adjustment Amount Querying the Clearing Transactions Summary You can view the processed clearing records through the Clearing transaction screen You can reverse a transaction or input a transaction through this screen Also you can query view the list of transactions with a particular reconciliation status 6 4 ORACLE You can invoke this screen by typing CGSQUERY in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button Clearing Transaction Query Summary Reference Number Product Code Remitter Beneficiary Remitter Account Beneficiary Account Instrument Currency Instrument Amount Bank Code Branch Code External Reference Authorization Status M Contract Status Reconcilation Status Not Applicable VW Search Advanced Search Reset Records per page i am P Goto Page Milk MME wmm Reference Number Product Code Remitter Beneficiary Remitter
53. ication Browser you have to maintain the clearing houses your bank participates in You can invoke this screen by typing STDCLMNT in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button 3 9 ORACLE Clearing House Maintenance Input By Authorized By Modification Authorized Date Time Date Time Clearing House Description Swift Code Number Open Identify every Clearing House you participate in with a unique code In the Description field briefly capture the details of the Clearing House The Clearing House Code and Description you enter should help you easily identify a clearing house Additionally specify a SWIFT code for the clearing house In order to process MT306 MT340 MT 360 and MT361 you need to maintain the following codes as SWIFT Codes for the field 29H 29E and 22B EUTA Target LKCO Colombo PKKA Karachi ROBU Bucharest TRIS Istanbul VNHA Hanoi Maintaining Clearing House Holidays In the Clearing House Holidays Calendar Maintenance screen invoked from the Application Browser you can identify the holidays for the various clearing houses maintained at your bank You can invoke this screen by typing STDCLHOL in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button 3 10 ORACLE 3 2 Clearing House Holiday Maintenance January February March August Septemb
54. ich the correspondent bank charges to a drawer bank Other charges such as Postage and telex Maximum number of the float days of the cheque It differs from bank to bank for the same city That means the days in which the correspondent bank will pay a drawer bank for the cheque sent for payment This payment is done in the drawer bank account in the central bank Format used to inform or report the collection cheques to the correspondent bank letter chart table or both Level for reporting or negotiated purposes and level for Non Negotiated It could be centralized or decentralized This is a preference that is stored at agreement level for generation of reports City code where the correspondent bank can be the correspondent bank for the collection cheques of a drawer bank For each city it is necessary to define where the clearing is made clearing city and the correspondent bank branch code in charge of this process The correspondent bank is assigned based on the Clearing City of the cheque To maintain collection cheque parameters click Preferences button on the Bank Code Maintenance screen The following screen is displayed 3 5 ORACLE v Prererences Clearing Bank Code Preferences Late Reject Days Collection Cheque Parameter Level of Invoice Payment Bank Group Negotiated Centralised Dispatch Floating Days Decentralised Reporting Format Non Negotiated Centralised Decentralised Bank Agreement HE
55. ing Document Type Maintenance na Document Type Instrumenttype Cheque gt Description Maker Date Time Checker Date Time Cancel Here you can specify the following details Document Type Specify a code for the document type The following are the types of the document e Cheque 01 e DD 02 e Inward DD 07 Description Specify a brief description of the document 3 7 ORACLE Instrument Type Select the type of the instrument from the adjoining drop down list The list displays the following values e Cheque e DD e Inward DD Maintaining Clearing Service Points For every collection cheque the system will do a lookup in clearing service point maintenance to check if special handling is required or not In case there is no maintenance available for a combination of drawee bank and drawee city the system will take drawee city as clearing city In case it is found that a cheque requires special clearing then system will check if beneficiary s bank has any correspondence agreement in that clearing city If there are agreements available then system will decide correspondent bank based on following criteria e f a drawer bank is one of the correspondent banks for the city the system should select a drawer bank as the correspondent Bank e Else if there is more than one correspondent bank in the city the system should select the one with less commission for a drawer bank The commission that correspondent ba
56. ing the product the exchange rate variance cannot exceed the rate corresponding to the Rate type by this value Maximum Variance If the rate that is input exceeds the maximum variance defined the system will not allow storing of the contract Example You have specified the normal variance as 3 and the maximum variance as 6 for a product If an exchange rate input for a transaction involving the product varies from the applicable rate maintained for the day by less than 3 the system will NOT display an override message If the exchange rate input for a transaction involving the product varies from the Standard Rate by 3 to 6 Oracle FLEXCUBE will display an override message On confirmation the transaction will be saved The override message will be recorded If the exchange rate input for a transaction involving the product varies from the day s rate by more than 6 Oracle FLEXCUBE will not store the transaction 4 1 1 2 Maintaining Preferences for Clearing You can maintain preferences for clearing through the Preferences screen To invoke this screen click Preferences button in the Clearing Product Definition screen The screen appears as shown below CG Product Definition Preferences Referral Required Insufficient Funds Reversal Consolidation Required CASA Reversal Defer Liquidation Consolidation Transaction Code Dispatch Days Liquidation Days 4 3 ORACLE Referral Required Referral refers to th
57. ion or an entirely different financial institution This field corresponds to Field 57A of S W I F T You can enter one of the following e ISO Bank Identifier Code of the bank e The branch of the Receiver s Correspondent e Name and address of the Receiver s Correspondent e Other identification codes for example account number e Local Clearing Code of the bank 6 8 ORACLE Sender to Receiver Information You can include any message that the Sender wishes to pass on to the Receiver as part of the funds transfer Receiver Intermediary The Receiver Intermediary in a transfer refers to the financial institution between the Receiver and the Account With Institution through which the transfer must pass The Intermediary may be a branch or affiliate of the Receiver or the account with Institution or an entirely different financial institution This field corresponds to field 56a of S W I F T Here you can enter either the e ISO Bank Identifier Code of the bank e Name and address of the Bank e Local Clearing Code of the bank Beneficiary Institution Here you can enter details of the institution in favor of which the payment is made It is in reality the bank that services the account of the Ultimate Beneficiary This field corresponds to Field 58A of S W LF T You will be allowed to make entries into this field only for Bank Transfers when the remitter and beneficiary of the transfer are financial institution
58. ll have all the records irrespective of their status You can invoke Inward Clearing Extract Report screen by typing CGRINCLR in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button Inward Clearing Extract Report Transaction Date Specify the transaction date Click OK button to generate the inward clearing extract report click Exit to return to the Reports Browser 7 2 1 Contents of the Report The contents of the report are discussed under the following heads Header The Header carries the Branch of the report information on the branch and date the ID of the user who generated the report the date and time at which it was generated and the module of the report Body of the report The generated report will be ordered by the batch number and currency The Batch No 4 7 character of Reference Number The Summation will be for Number of entries amount End Point This indicates the end point 7 1 ORACLE Clearing Type This indicates the clearing type Remitter Branch This indicates the remitter branch Remitter Account This indicates the remitter account Beneficiary Account This indicates the beneficiary account Cheque Number This indicates the cheque number Entry Number This indicates the entry number Routing Number This indicates the routing number Payee This i
59. mo products maintained in the system You can select the appropriate one Memo Product Specify the memo product The adjoining option list displays all the valid memo products maintained in the system You can select the appropriate one 4 7 ORACLE Drawer Bank Expense Account Specify the drawer bank expense account number The adjoining option list displays all the valid account numbers maintained in the system You can select the appropriate one 4 1 2 2 Inward Clearing Products You can maintain different inward clearing products for different instruments Product Code Specify the product code that should be mapped to the type of instrument Document Type Specify the type of the instrument that should be mapped to the specified product code The following are the codes of the documents e Cheque 01 e DD 02 4 2 Maintaining Retention Days In Oracle FLEXCUBE outward clearing process depends on the retention days The retention days depend on the following parameters e Number of days required to clear the funds by the clearing house e Number of days required by the bank to clear the funds During clearing contract creation if the Retention Exception Allowed option is checked in the Clearing Document Type Maintenance screen and the transaction account is maintained atthe exception maintenance then retention days will be taken as 0 else it will be derived from Clearing Bank code maintenance or ARC in that or
60. multiple clearing transactions based on the following details External Reference No Specify the external reference of the transaction you are querying This adjoining option list displays all valid external reference numbers maintained in the system You can choose the appropriate one End Point Specify the end point clearing house of the transaction you are querying This adjoining option list displays all valid end points maintained in the system You can choose the appropriate one Remitter Account No Specify the remitter account number of the transaction you are querying This adjoining option list displays all valid external remitter account numbers maintained in the system You can choose the appropriate one Product Specify the clearing product of the transaction you are querying This adjoining option list displays all valid clearing product codes maintained in the system You can choose the appropriate one 6 1 ORACLE Beneficiary Account Specify the beneficiary account you are querying This adjoining option list displays all valid beneficiary account numbers maintained in the system You can choose the appropriate one Transaction Date Enter the transaction date you are querying User Id Specify user Id who input the transaction you are querying This adjoining option list displays all valid user Ids maintained in the system You can choose the appropriate one Status Select the status of the transaction yo
61. n you are querying from the option list Instrument Currency Select the instrument currency of the transaction you are querying from the option list Instrument Amount Select the instrument amount of the transaction you are querying from the option list Bank Code Select the bank code of the transaction you are querying from the option list Branch Code Select the branch code of the transaction you are querying from the option list Reconciliation Status Select the reconciliation status of the transaction you are querying from the option list Click Search button to view the records based on criteria you have selected The following details of the record get displayed e Authorization Status e Contract Status e Reference Number e External Reference e Product Code e Instrument Date e Remitter e Beneficiary e Remitter Account 6 6 ORACLE e Beneficiary account e Instrument Currency e Instrument Amount e Bank Code e Branch Code e Reconciliation Status Refer heading Specifying Clearing Cheque Details in the Utility Payments Manual for further details on Clearing Transaction Query screen 6 3 1 Maintaining Settlement Details You can maintain settlement details for Inward and Outward Direct Credit transactions For details on Inward and Outward Direct Credit transactions refer to the Retail Teller and Retail Branch user manuals Invoke the Settlement Details screen from the Application
62. ndicates the payee Instrument Date This indicates the instrument date Currency This indicates the currency Cheque Amount This indicates the cheque amount Status This indicates the status 7 3 Inward Clearing Extract Passed Entries After authorization all the transactions will come to Clearing Log IFSCLGDT screen Here some transactions will go as error because of lack of funds or other reasons A report is required containing data of how many entries passed You can invoke Inward Clearing Extract Passed Entries screen by typing CGRCLGPS in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button Inward Clearing Extract Passed Entries Transaction Date Specify the transaction date Click OK button to generate the inward clearing extract report click Exit to return to the Reports Browser 7 3 1 Contents of the Report The contents of the report are discussed under the following heads Header The Header carries the Branch of the report information on the branch and date the ID of the user who generated the report the date and time at which it was generated and the module of the report 7 2 ORACLE Body of the report The generated report will be ordered by the batch number and currency Batch No 4 7 character of Reference Number The Summation will be for Number of entries amount
63. ng No Specify the routing number for cheque clearance The adjoining option list displays all routing numbers along with the Branch codes and Bank Codes You can select the appropriate one Click Search button to view the records based on criteria you have selected The following details of the record get displayed Clearing Details e Status e Reject Code e Force Posting e Advice Required e Remitter Account No e Remitter Branch e Instrument Number e Instrument Currency e Instrument Amount e Liquidation Date e Product e Contract Reference e Beneficiary Account e Beneficiary Customer e Same Holder e Unique Identifier Type e Unique Identifier Value e Payee e Routing No e End Point e External Reference e Maker Id e Maker Date Stamp 6 3 ORACLE e Authorization Status e Source Code e Instrument Type e Error Code e Error Params e Upload Status The system displays the following details e Remitter Bank e Beneficiary Bank e Bank Validate e Beneficiary Branch e Branch e Entry No 6 5 1 1 ITF Processing of Clearing Transactions Both the Outward and Inward clearing transactions are subject to ITF Outward Clearing Transactions ITF is charged on the outward clearing transactions in the following cases e Remitter and beneficiary account holders are different e Either remitter or beneficiary or both accounts are of joint holder type e Ifthe clearing instrument is of the type Demand dr
64. ng information relating to other banks you have to maintain clearing information for your bank and the branches of your bank Capture the code that identifies your bank in the Clearing Network To every branch of your bank the Branch Codes maintained in Oracle FLEXCUBE assign the code that identifies it at the Clearing Network The clearing bank code that identifies your bank at the Clearing Network should be the same as that specified in the Bank Wide Parameters screen Also the branch code and sector that identifies a branch at the Clearing Network should be the same as that specified for the branch in the Branch Parameters screen 3 1 3 2 Maintaining Clearing Details of Branch To facilitate automatic clearing of instruments that involve your branch you need to specify clearing related options for your branch To do this you can invoke the Branch Parameters screen from the Application Browser 3 4 ORACLE In the Branch Code for Clearing field indicate the code that identifies your branch in the Clearing Network The code you specify for your branch should be the same as that defined in the Clearing Bank Code Maintenance screen For your branch you must also specify the Sector Code as specified in the Clearing Bank Code Maintenance screen Finally if clearing transactions involving your branch must be routed through another branch specify the Oracle FLEXCUBE branch code of that branch in the Clearing through Branch field On
65. nk charges a drawer bank e f there is more than one correspondent bank in the city with the same commission the system should select a bank which belongs to the same group as that of drawer bank If there are no bank from then any bank can be chosen In case of special clearing the system will not process a collection cheque if there is no correspondence agreement available in a clearing city If a cheque is not marked for sent on dispatch due date i e transaction date of cheque dispatch floating days then the system will mark that cheque as LOST during the next BOD Whenever a cheque is marked as LOST for not dispatching system will reverse all accounting entries for that cheque You can invoke the Clearing Service Points Maintenance screen by typing CGDCLRPT in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button 3 8 ORACLE Clearing Service Points ae Drawer Bank Drawer City Clearing City Maker Date Time Mod No Checker Date Time Record Status exit Authorization Status Drawee Bank Specify the details of the bank where the cheque was drawn Drawer City Specify the name of the city of drawee bank Clearing City Specify the city where clearing should happen for a given combination of drawer bank and city 3 1 5 Maintaining Clearing Houses and Clearing House Holidays In the Clearing House Maintenance screen invoked from the Appl
66. nt Float days for each bank and sector code combination Subsequently you can also maintain float days for customers of each bank and sector combination The float days you define here will be defaulted in the Customer Float Days maintenances screen Refer to the Core Entities user manual under section Maintaining Float Days for Outward Clearing Customer Transactions for further details The system calculates the value date for the clearing transaction in the following manner e Firstly the system checks for the branch code for the clearing transaction clearing product sector code currency of the instrument and the float days for bank and customer maintained in ARC maintenance e Secondly the system checks the maintenance for clearing bank and if the details for the destination sector code bank code and branch code and float days for both customer and bank is maintained these values take precedence over the details in ARC maintenance e Finally system verifies the details maintained in the Customer level float maintenance for the clearing transaction branch code currency sector code clearing product code and the customer group to which the customer belongs to and arrives at the float days to calculate the value date After you maintain the above details for a branch click Add button to capture the details of the next branch 3 1 3 1 Maintaining Details of Branches of Your Bank In this screen in addition to capturi
67. nt amount 3 17 ORACLE 3 2 4 3 2 5 Collection Status The system displays the status of the collection cheque Dispatch Reference Number The system displays the reference number of the dispatch lot During the BOD the system will scan the uncollected funds that are due for collection on the day Each of them will have a dispatch reference number associated to them System will liquidate commission charges and tax on commission due for a dispatch reference number System will use clearing service product maintained for the bank clearing type document type and various payment indicator combination to do accounting If a cheque is not marked for sent on dispatch due date then next day s BOD system will mark that cheque as LOST This will be handled in clearing batch i e CGBATCH Confirming or Denying the Collection Cheque Oracle FLEXCUBE allows you to confirm or deny the collection cheque by changing the cheque status from Sent to Confirmed or Denied For this you need to select the operation type and then fetch the data For non negotiated type of cheque the system will move funds from transaction GL where the credit was happened initially to beneficiary account on confirmation of cheque The system will reverse memo accounting and will also reverse accounting entries using outward return product maintained for the bank clearing type document type and various payment indicator combination For negotiate
68. nts that are presented by your customers or clearing houses Clearing transactions in Oracle FLEXCUBE can be classified into two categories e Inward Clearing transactions e Outward Clearing transactions A third party presenting an instrument drawn on your bank through a clearing house is an example of an inward clearing transaction Your customer presenting an instrument drawn on another bank is an example of an outward clearing transaction 2 1 ORACLE 3 Maintaining Reference Information 3 1 Introduction In order to process clearing transactions automatically you need to maintain some information in Oracle FLEXCUBE Specify the code by which your bank is identified in the Clearing House and define a Routing Mask for generation of routing numbers as part of Bank wide Parameters Maintain Sectors Maintain details of banks participating in the Clearing House Maintain clearing information for the branches of your bank Branch Parameters Maintain Clearing Houses and Clearing House Holidays Identify End Points and map them to the clearing houses maintained Setup Outward and Inward Clearing Products Specify account rates and charge details ARC Maintenance Once you set up this information the appropriate customer and clearing accounts maintained in your bank will automatically be credited or debited depending on the nature of the transaction The sequence is represented diagrammatically as follows 3 1 ORACLE
69. o calculate the value date of the customer leg of a transaction The following example illustrates the implications If you have maintained float days the system will validate the Clearing House Holiday Maintenance also Example You have specified the Bank Float Days as 1 and the Customer Float Days as 2 Assume your customer presents a cheque on 15 May 2002 The cheque is cleared on the same day This means that you would credit your Incoming Check GL bank leg on 16 May 2002 but credit the customer account with the funds only on 17 May 2002 the customer leg You can choose to maintain an ARC Wildcard record for a Branch Currency and Customer combination or for any one or more of these entities Ensure that the wildcard symbol that you are using is a In case of other bank cheques Bank Float days will be one and customer float days will be zero If the Local clearing is checked for clearing contracts the system will default the Local Float Days as Bank Float Days and the customer float days will be zero For calculating Bank value date and Customer value date the following steps are involved e When a chequeis in queue for clearance the time taken for processing depends on the Bank Value Date and Customer value date The system searches for a record in existing Bank code maintenance If a record for the Bank and branch combination is available the customer and bank value date will resolve from
70. on or for a specific Account Class level The ARC pickup is based on Customer Group code in addition to branch product customer transaction currency and customer If an ARC record is not maintained at a branch product customer currency level system checks the ARC record for branch product customer group currency before doing a wild card search The order of replacement of the parameters with wild card entries will be done based on the following order e Branch e Product e Transaction Currency e Transaction Type Customer Group Specify the customer group to define charges This adjoining option list displays all valid customer groups of type charge maintained in the system You can choose the appropriate one Input to this field is mandatory 5 2 ORACLE The ARC resolution logic is as below Sequence Branch Product Acc Currency Customer Customer Product Acc Class Group ount Flag 1 Specific Specific Specific Specific Specific P 2 we Specific Specific Specific Specific P 3 Specific Specific ne Specific Specific P 4 Specific Specific Specific Specific Te P 5 a Specific Specific Specific P 6 oe Specific Specific Specific Na P 7 Specific Specific y Specific Specific P 8 Specific Specific eu ee P 9 La Specific Pe Specific P 10 Specific Specific oe ao io P 11 T Specific Specific ee P 12 Specific Specific Specific pa ie P 13 o
71. ppropriate one 5 16 ORACLE 6 Viewing Clearing Transactions 6 1 Introduction You can view clearing transactions in the Clearing Transaction Query screen where you provide the details of the check instruments as well as the clearing details You can invoke this screen by typing CGDQUERY in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button Clearing Transaction Query Branch Product Code Direction Reference Number Remitter Details Customer Account Country Instrument Details Draft Serial Number Instrument Routing Number Bank Code Branch Code Sector Code Instrument Type Date Details Transaction Date Instrument Date Bank Value Date Customer Value Date Reg CC Detail Remarks MT110 Reconciliation Detail Status Reference Number Entry Number End Point External Reference Beneficiary Details Customer Account Country Account Details Currency Instrument Currency Instrument Amount Account Currency Amount Exchange Rate Document Id Number Late Clearing Document Id Number Date Module Details Module Module Description Reference Number Event Sequence Number Reject Reason Consider For Reg CC Status Special Avail Check Verification Digit Accounting Entries Bulk Clearing Report Input By Date Time Contract Status Authorized By Date Time Transaction Tanked Authorized In the Clea
72. product Chapter 6 Viewing Clearing Transactions gives details about maintaining settlement resolving customer credits for check clearance charges for dishounoured 1 1 ORACLE checks and querying clearing information Chapter 7 Reports provides a list of reports that can be generated in this module and also explains their contents Chapter 8 Annexure I gives information regarding order of replacement of parameters with wild card entries Chapter 9 Annexure II gives information regarding different currency combinations used for rate code and rate type pickup 1 4 Related Documents e Procedures User Manual e Settlements User Manual e Products User Manual e Charges and Fees User Manual e Tax User Manual e Settlements User Manual e User Defined Fields User Manual 1 5 Glossary of Icons Icons Function New Ca Copy Save F Delete G Unlock amp Print Close 8 Re open p Reverse R Template Roll over Hold 1 2 ORACLE E Authorize a Liquidate Exit Sign off a Help Add row Delete row az Option List e Confirm 9 Enter Query Fa Execute Query ORACLE 2 1 2 An Overview Introduction The Clearing module of Oracle FLEXCUBE offers you the facility to process checks DDs and other instrume
73. ransactions involving the product need to be considered for referral checks for exceeding their overdraft limit Check this option to indicate that referral is required Consolidation Required This field is enabled only for inward clearing products Check this option to indicate consolidation for all transactions for a customer in an inward clearing batch is required Any inward clearing product which has Consolidation Required enabled cannot be selected for a manual clearing entry Insufficient Funds Reversal This field is enabled only for inward clearing products The Transaction Code is used to reverse the accounting entry if an individual clearing transaction is reversed from the Referral Queue due to insufficient funds Specify a Transaction Code for reversal If the Transaction Code is left blank the Transaction Code of the original clearing entry will be used for reversal CASA Reversal This field is enabled only for inward clearing products The Transaction Code is used to reverse the accounting entry if an individual clearing transaction is reversed due to any CASA error Specify a Transaction Code for CASA reversal If the Transaction Code is left blank the Transaction Code of the original clearing entry will be used for reversal Only those Transaction Codes which have Cheque Mandatory set as NO in the Transaction Code Maintenance screen will appear for selection Consolidation Transaction Code 4 4 ORACLE You need
74. re 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 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 parti
75. ring Details sizccsectaessyesthssostestecave chasveideesints E E ARRS 6 2 6 2 VAIBWING PARITY DETAILS aice reigi a totes cavaecesasest aceite centaine des determine inerte anses nine sie 6 3 6 3 QUERYING THE CLEARING TRANSACTIONS SUMMARY c sccessssceceessececseseeceesuceecsesaececsesaeeessaeeeesesaeesenneeees 6 4 6 3 1 Maintaining Settlement Details j sesisessvecsageostidisscirts esi a eS iea ee fables 6 7 6 3 2 Resolving Customer Credits for Clearing Checks ss 6 9 6 3 3 Levying Charges on Dishonored Cheque sise 6 11 6 4 MAINTENANCE OF REJECT ACCOUNT ERROR CODE DETAILS ss 6 13 6 5 QUERYING CLEARING REPAIR UPLOAD SUMMARY cccssseceesescecsesuececseneeceesaeeecnesaececeneaeeesaeeecseaeeeeseneees 6 1 6 6 CLEARING BATCH PROCESS CGUPLOAD sise esse 6 5 6 6 1 Provision for populating Clearing Upload ss 6 6 7 REPORTS SEE E E A E E E O A 7 1 7 1 ENTRODUCTION E E E E T 7 1 ORACLE 7 2 INWARD CLEARING EXTRACT REPORT ccccccccececececececececececececacecacecacecacecacseacecacacacacasecasecaeaeseeeaeseseeeaeenaes 7 1 7 2 1 Contents of the Repot t oiisiisassisesesorisecvoneiotsowsesnedesssistdonsvisessepsdagucesnstizeavedvecenssipeceameduoeessidnageapedpbdonssageds 7 1 7 3 INWARD CLEARING EXTRACT PASSED ENTRIES ccccccccecececececececeeecececececeeececececacecaceeeseseseeseesaseeseseaeenaes 7 2 7 3 1 Contents Of The REDOPE wi isc cisesssosasesvonsinessosnaoedosssdstaoeoviseinoonieducesnssiaeavedsncenssipaieameipaeesueasagean
76. ring Transaction Input screen you can view the following e Remitter Details e Beneficiary Details 6 1 ORACLE Bulk Instrument Details Date Details Instrument Amount Viewing Document Identification Number DIN details DIN DIN Date Remarks Regulation CC Availability for Check Deposits Tanked Transaction Country of the remitter Country of the beneficiary Cheque Verification Digit Check this boc to indicate that all the cheque details will be displayed in the Bulk Clearing Report Screen For more information on Tanked Transaction refer Branch Parameters chapter under Core Services module 6 1 1 Viewing Bulk Clearing Details You can view all check details in the Bulk Clearing Details screen You can invoke this by clicking Bulk Clg Details button in the Clearing Transaction Query screen Clearing Transaction Query Buk Cleanng Report Bulk Clearing E Deposit Slip No InstumentNo Bank Value Date Customer Value Date Bank Code Branch Code Sector Code You can view the following details in this screen Instrument No Routing No 6 2 ORACLE 6 2 e Bank Code e Branch Code e Sector Code e Instrument Date e Instrument Amount e Amount in Account Ccy e Bank Value Date e Customer Value Date e Local Clearing Flag e Document type e Cheque Verification Digit Viewing Parity Details You can query the parity process mismatch using Parity Process Query s
77. rio X If on a given day a special check of 300 is deposited along with a local check of 4800 Day 1 next business day availability 800 Day2 4300 Account Statements All the details of the checks deposited on a given day and the funds cleared as per the schedule will be displayed in the account statement For Example let us assume the list of transactions in the month of Januar Cash Deposit of 10000 on Jan 15 2002 Cash withdrawal of 5000 on Jan 3 2002 Check Issued of 15000 on Jan 10 2002 Checks Deposited on 15 of Jan 2002 Check No Routing Code Check Amount 5 12 ORACLE Check No Routing Code Check Amount 2 1000 1000 3 1000 1500 4 1000 1750 5 1100 5000 e Checks Deposited on 16 of Jan 2002 Check Routing Code Check Amount No 1 1000 1500 2 1000 1000 3 1000 1500 4 1000 1750 5 1100 5000 e Cash Deposit of 30050 on Jan 25 2002 Transaction Transaction Details Transaction Book Balance Available amount balance Date 01 Jan 02 Opening Balance 0 0 Cash Deposit 10000 Cr Closing Balance 10000 Cr 10000 Cr 03 Jan 02 Cash Withdrawal 5000 Dr Closing Balance 5000 Cr 5000 Cr 10 Jan 02 Check Withdrawal 15000 Dr Inward Clearing Closing Balance 10000 Dr 10000 Dr 15 Jan 02 Check Deposit Outward 500 Cr Clearing Chq1 15 Jan 0
78. rsement Institution An Intermediary Reimbursement Institution is the financial institution between the Sender s Correspondent and the Receiver s Correspondent through which the reimbursement of the transfer will take place Intermediary The Intermediary in a transfer refers to the financial institution between the Sender and the Account With Institution through which the transfer must pass The Intermediary may be a branch or affiliate of the Sender or the account with Institution or an entirely different financial institution This field corresponds to field 56a of S W I F T Here you can enter either the e ISO Bank Identifier Code of the bank or the e Name and address of the Bank e Local Clearing Code of the bank Receiver s Correspondent The Receiver s Correspondent is the branch of the Receiver or another financial institution at which the funds will be made available to the Receiver This field corresponds to field 54a of S W LF T You can enter one of the following e ISO Bank Identifier Code of the bank e The branch of the Receiver s Correspondent e Name and address of the Receiver s Correspondent Account With Institution An Account With Institution refers to the financial institution at which the ordering party requests the Beneficiary to be paid The Account With Institution may be a branch or affiliate of the Receiver or of the Intermediary or of the Beneficiary Institut
79. ry Required Check this box for posting accounting entries for charges along with main transaction entry By default the system displays the status of this box as checked However you can modify this 5 1 1 4 Indicating Exchange Rate Revaluation You can specify the following details Profit Revaluation GL Specify the profit revaluation GL details Loss Revaluation GL Specify the loss revaluation GL details 5 1 1 5 Defining Charge Details You can define a maximum of five charges A charge can be computed based either on the transaction amount or on an earlier charge amount As part of defining the Charge details for each charge you need to capture the following details Charge Type The Charge Type that should be applied on the transaction It could either be a Percentage of the transaction amount or a Flat Charge Slab Type Whether the Charge computation has to be over different Amount Slabs or Tiers 0 100 10 101 500 15 etc Basis You can indicate the basis amount on which the charge is to be computed 5 6 ORACLE Since you can maintain five different charge amounts the basis amount that you enter could either be the transaction amount or any of the earlier charge amounts For example let us assume you are maintaining Charge 1 The only basis for charge 1 can be the transaction amount While defining Charge 2 you can choose either the transaction amount or Charge 1 as the basis Similarly while defining Charge 3
80. s Payee This indicates the payee Instrument Date This indicates the instrument date Currency This indicates the currency Amount This indicates the amount 7 7 ORACLE 8 1 8 Annexure Order of Replacement of Parameters with Wild Card Entries Branch Product Offset Currency Txn Customer Customer Currency Group Txn Brn Product Ofs CCY Txn CCY Customer Txn Brn Product Ofs CCY Txn CCY Customer Group an Product Ofs CCY Txn CCY Customer x Product Ofs CCY Txn CCY Customer Group Txn Brn Product Txn CCY Customer Txn Bm Product Txn CCY Customer Group Txn Brn Product Ofs CCY 7 Customer Txn Brn Product Ofs CCY Customer Group Txn Brn Product Ofs CCY Txn CCY oe a Product Txn CCY Customer Product Txn CCY Customer Group a Product Ofs CCY 2 Customer a Product Ofs CCY a Customer Group 10 Product Ofs CCY Txn CCY Txn Brn Product 7 Customer Txn Brn Product Customer Group Txn Brn Product Txn CCY a Txn Brn Product Ofs CCY me ea ae Product Customer ae Product a Customer Group a Product Txn CCY a Product Ofs CCY ae tig 8 1 ORACLE Branch Product Offset Currency Txn Customer Customer Currency Group Txn Brn Product ea ee s Product ae ae
81. s MT 100 or MT 202 Here you can enter either e The ISO Bank Identifier Code of the Beneficiary Institution e The Name and Address of the Beneficiary Institution e The Local Clearing Code of the bank If the receiver of funds is the same as the Beneficiary Institution you can specify the bank s own local clearing code 6 3 2 Resolving Customer Credits for Clearing Checks For processing outward clearing checks you need to ensure that e You have maintained the clearing products that would be used for processing the Registration INIT and Liquidation LIQD events e Inthe Demand Drafts Details screen you must associate the statuses used for registration and liquidation with the appropriate product codes Assume you have maintained the products CGOC Registration of Outward Clearing checks and DDLQ Liquidation of Outward Clearing checks You need to associate the status INIT Registration with the product CGOC and LIQD Liquidation with the product DDLQ e The Clearing Required option has not be enabled for the product maintained for the liquidation event in the Demand Draft Details screen e Charges in respect of an outward clearing check transaction could be collected either upfront or after the credit to the customer account The manner in which accounting is done in both cases along with the appropriate ARC maintenance is illustrated below When charges are collected upfront Step 1 This is the registration event IN
82. s completely covered by limits then the system will mark the collection as a negotiated type of collection else non negotiated For balance updation and utilization of cheque limits e f acheque collection is of negotiated type then irrespective of bank or customer level floating days the system will increase available balance and utilization of cheque limits and this is done only after processing is successful e f acheque collection is of non negotiated type then the system will credit transaction account GL maintained at product level During confirmation of cheque the system will debit transaction account GL and credit beneficiary account For re instating utilization of cheque limits for current accounts e Whenever a cheque collection is rejected the system will decrease the utilization of cheque limit for negotiated type of cheque e Whenever a cheque collection is rejected the system will reverse accounting entries using outward return product maintained for the bank clearing type document type and various payment indicator combination e Whenever a cheque collection is not confirmed within floating days of the clearing bank from the date of transaction initiation the system will automatically mark the cheque as Lost and utilization of cheque limits will be reduced For saving type of accounts cheque collection will always be of type non negotiated since there will be no cheque limit available to cover collection
83. screen will be used for reversal due to CASA errors If this Transaction Code is not maintained the Transaction Code used for passing the consolidated clearing entry of which this instrument was a part will be used for reversal The individual transaction will be marked as rejected in this case In case the Force Posting option has been checked in the Interface Clearing Details screen and an individual transaction is posted to a referral queue because of insufficient funds if the Referral option is checked in the Clearing Product Definition screen and the Customer Account Maintenance screen you will have to manually reverse or accept the clearing transaction In such a case the individual clearing transaction will be marked as success In case a reversal needs to be done for a transaction which was part of the consolidated clearing process the transaction will be reversed using the Insufficient Funds Reversal Transaction Code maintained in the Clearing Product Preference screen In case the Transaction Code is not maintained the Transaction Code used for passing the consolidated clearing entry of which this instrument was a part will be used for reversal Charge entries if any will also be reversed using the Transaction Code of the individual clearing transaction In case of any other error the individual clearing transaction will be marked as rejected and the transaction will be reversed using Transaction Code used for passing the Consolid
84. t Clearing Suspense account Our charges Debit Customer Collecting bank charges 6 10 ORACLE 6 3 3 Debit Credit Indicator Accounting Role Amount Tag Credit bank Collecting Bank charge Account Nostro of collecting bank with your Collecting bank charges For the registration product when the charge is collected upfront the ARC Maintenance must be as follows Txn Account Offset Account Charge Account Charge From Account Suspense Nostro Income Transaction Account For the registration product when clearing charges are collected from the customer after credit the ARC Maintenance must be as follows Txn Account Offset Account Charge Account Charge From Account Suspense Nostro For the liquidation product when clearing charges are collected from the customer after credit the ARC Maintenance must be as follows Charge Type Txn Offset Charge Charge From Account Account Account Account Our charges Customer Suspense Income Transaction Account Collecting Bank Customer Suspense Income Transaction charges Account Levying Charges on Dishonored Cheque You can levy charges on dishonored cheques based on the reason for rejection Invoke the Clearing Rejection Code Maintenance screen from the application browser You can invoke this screen by typing CGDREMNT in the field
85. te and time at which it was generated and the module of the report Body of the report The generated report will be ordered by the batch number and currency The Batch No 4 7 character of Reference Number The Summation will be for Number of entries amount End Point This indicates the end point Clearing Type This indicates the clearing type Remitter Branch This indicates the remitter branch Remitter Account This indicates the remitter account Beneficiary Account This indicates the beneficiary account Cheque Number This indicates the cheque number Entry Number This indicates the entry number Routing Number This indicates the routing number Failed Reason This indicates the failed reason Payee This indicates the payee Instrument Date This indicates the instrument date Currency This indicates the currency Amount This indicates the amount Inward Clearing Extract Rejected Entries This Report lists the reject inward clearing records The bank may wish to reverse some of the passed cheques A report is required of how many cheques reversed with details You can invoke Inward Clearing Extract Rejected Entries screen by typing CGRCHREV in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button inward Clearing Extract Rejected Entries Transaction
86. tes are discussed in detail in this chapter You can define the attributes specific to a loans product in the CG Product Definition Main screen and the CG Product Preferences screen In these screens you can specify the product type and set the product preferences respectively For further information on the generic attributes that you can define for a product please refer to the Products User Manual Product Type A product you are creating can belong to either of the following categories e IC for inward clearing of checks e ID for inward clearing of DDs e OC for Outward Clearing These product categories are referred to as product types When you create a product you must specify its type 4 1 1 1 Specifying Exchange Rate Variance A clearing transaction may involve a currency conversion For such transactions the rate corresponding to the Rate Type that you specify for the product will be picked up Cash rate Standard Rate Spot Rate etc are examples of Rate Types When processing a transaction the rate value that is picked up can be changed 4 2 ORACLE You can define the limits within which this change can be made as follows Normal variance The rate variance can exceed the rate maintained for the Rate Type by the value you specify here normal variance In such a case the system prompts the user with an override message before the contract is saved Maximum variance For transactions involv
87. th the Clearing module of Oracle FLEXCUBE It provides an overview to the module and provides information on using the clearing module of Oracle FLEXCUBE You can further obtain information specific to a particular field by placing the cursor on the relevant field and striking lt F1 gt on the keyboard 1 2 Audience This manual is intended for the following User User Roles Role Function Back office clerk Input functions for contracts Back office managers officers Authorization functions Product Managers Product definition and authorization End of day operators Processing during end of day beginning of day Financial Controller Product Managers Generation of reports 1 3 Organization This manual is organized into the following chapters Chapter 1 About this Manual gives information on the intended audience It also lists the various chapters covered in this User Manual Chapter 2 An Overview is a snapshot of the features that the module provides Chapter 3 Maintaining Reference Information gives information on basic information that needs to be maintained in the system before beginning operations in the clearing module Chapter 4 Maintaining Clearing Products describes how you can create a clearing product Chapter 5 Maintaining Account Rate and Charge Details described in this chapter is the procedure to set up accounting rates and charges details for a clearing
88. the Application tool bar and clicking the adjoining arrow button Collection Cheque Correspondence Type of Operation Clearing City Correspondent Bank Collection Type Deposite City Collection Cheque Reporting Type Transaction Ref No Cheque Details 1of1 OR EE instrumentAmount CollectionStatus Specify the following details 3 16 ORACLE Type of Operation Select the type of operation from the drop down list Following are the options available in the drop down list e Send e Confirm e Return e Query Correspondent Bank Specify the correspondent bank name Place of Deposit Specify the city where the cheque was deposited Clearing City Specify the city where the cheque was drawn Type of Collection Select the type of collection from the drop down list Following are the options available in the drop down list e Negotiated e Non Negotiated Collection Cheque Reporting Format Select the format of collection cheque from the drop down list Following are the options available in the drop down list e Form e Remittance Letter Dispatch Reference Number Specify the reference number of the dispatch lot 3 2 3 1 Cheque Details Reference Number The system displays the reference number Deposit Slip Number The system displays the deposit slip number Instrument Number The system displays the instrument number Instrument Amount The system displays the instrume
89. the basis of the Routing Number Mask defined for your bank and your specifications in this screen Oracle FLEXCUBE automatically generates the Routing Number for clearing transactions involving your branch in the Routing Number field This routing number is used to resolve outward clearing transactions For example if you Westside Bank Seattle branch issue a Demand Draft DD that is payable at an outstation branch of say Friendly Neighborhood Bank Nashville based on the routing number the DD if presented at any other bank in Nashville will be sent to Friendly Neighborhood Bank for clearing and not your bank and branch For more details about the Branch Parameters screen refer the Core Services user manual 3 1 3 3 Maintaining Collection Cheque Parameters Oracle FLEXCUBE allows special conditions for the handling of collection cheques For instance in some cases certain banks can have an arrangement with a drawer bank wherein it is agreed that cheques of a particular bank drawn on certain cities should be collected through another city In such cases the system will choose the correspondent bank in that other city independent of the correspondent banking agreement that a drawer bank has for each clearing city For the system to handle the collection cheques and commission to be charged to a client the following must be parameterized for each correspondent bank City of correspondent bank Correspondent bank code Commission wh
90. this maintenance e Ifthe Bank float days and customer float days are not specified there means null values then ARC will be resolved with Branch Code Currency Code Sector Code and Bank Code maintained Float Days Basis Float days applicable for outward clearing customer transactions are defined through the Customer Float Days Maintenance screen The float days can either be considered as e Calendar days indicating that the float days will not be dependent on any holiday maintenance e Working days indicating that the float days will be based on the clearing house calendar and they will be working days on the basis of clearing house calendar You can select the appropriate option which will be used to arrive at the value date for outward clearing customer transactions 5 5 ORACLE For details about defining float days for a customer or customer group refer the Core Entities user manual Netting Charge You have the option to net the accounting entries for the debit leg of the charges along with the main transaction entries Check this box to indicate that the debit leg of the charges is to be netted before passing the accounting entries Leave the box unchecked to pass the entries without netting the charges of the debit leg Generate Transaction Advice Whether an Advice needs to be generated for the Transaction redundant for J2EEBranch might still be used for other Interfaces Transaction Offset Accounting Ent
91. to specify the Transaction Code required for passing a consolidated clearing entry The same Transaction Code should be maintained with Cheque Mandatory option as No in the Transaction Code Maintenance screen Dispatch Days Specify the number of days to be used to calculate the dispatch days from the booking date System uses the local currency calendar to compute the dispatch days from the date of deposit For example if the dispatch days is given as 1 system fires DCLG on the next Local currency working day In case that day is a local holiday then the event is fired on the next business date Liquidation Days Specify the number of days to be used to calculate the liquidation days from the booking date System uses the local currency calendar to compute the liquidation days from the date of deposit For example if the liquidation day is given as 2 the system fires LIQD after 2 Local currency working days In case that day is a local holiday then the event is fired on the next business date Maintaining Clearing Product for Mapping Bank Code You can map the outward and inward clearing products in the Clearing Product Maintenance screen You can invoke this screen by typing CGDBNKPWM in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button 4 5 ORACLE Clearing Product Maintainance Bank Code Protest Inward Product Internal Product Protest Internal Product
92. u Specific Specific a Es P 14 Specific Specific val yy ae P 15 ca Specific tae gt P Bank Code Specify the bank code of the remitter for the arc resolution 5 1 1 1 Indicating Offset Details You can indicate the offset currency to be used for processing FX contracts involving different currency combinations Exchange rate for the contract is based on the rate code and type defined for the currency combination in the Retail Teller product definition Product preference screen Based on the transaction currencies chosen and the exchange rate defined for the currency combination the system will pass the relevant accounting entries The Offset currency field will be enabled for all products and not for account classes The ARC pickup in branch and host will be based on offset currency in addition to branch product transaction currency customer and customer group The order of replacement of the parameters with wild card entries is done in the following order e Branch e Product 5 3 ORACLE 5 1 1 2 5 1 1 3 e Offset currency e Transaction Currency e Allowed Value For FX transactions the second currency from FX screens is used as offset currency for ARC pickup For RT transactions offset currency will also be used for ARC pickup The order of replacement of the parameters with the wild card entries will be as per the matrix given in the Annexure I The Rate code and type pickup in branch and host for the Ret
93. u are querying from the drop down list e Overrides e Unprocessed e Success e Dishonour Return e Error Currency Specify currency of the instrument you are querying This adjoining option list displays all valid currencies maintained in the system You can choose the appropriate one Remitter Branch Specify remitter branch you are querying This adjoining option list displays all valid remitter branches maintained in the system You can choose the appropriate one Remitter Account Currency Specify remitter account currency you are querying This adjoining option list displays all valid remitter account currencies maintained in the system You can choose the appropriate one Instrument No Specify instrument number you are querying Amount Specify the instrument amount you are querying Authorization Status Select the authorization status of the transaction you are querying from the drop down list e Authorized e Unauthorized Instrument Type The system displays the instrument type here and the default value is CHQ 6 2 ORACLE Direction Select the direction of the transaction you are querying from the drop down list e Inward e Outward Reject Code Specify reject reason code for querying This adjoining option list displays all valid reject codes maintained in the system You can choose the appropriate one Force Posting To force the transaction to happen even in case of insufficient funds Routi
94. ys all valid document types maintained in the system Select the appropriate one Retention Exception Allowed Check this box to indicate that the retention exception is allowed for this document 4 9 ORACLE 4 2 1 1 Role to Head Mapping Screen You can maintain accounting roles for clearing products through the Role to Head mapping screen To invoke this screen click Role to Head button in the Clearing Product Definition screen The screen appears as shown below Accounting Roles Product Code Product Description Class Details Class Code Class Description Roles 10f1 jum Accounting Role Role Description Account Head GL Description m The following accounting roles can be maintained e CONT_ACCNT_DUE Contingent Account Due e CONT_ACCNT_PAY Contingent Account Payable e CLRNG_ACCOUNT Clearing Account e CLRNG_OFS_ACCOUNT Clearing Offset Account The following amount tags can be maintained e TXN_AMOUNT Cheque Amount e OFS AMOUNT Cheque Amount 4 2 1 2 Events You can maintain the events for clearing through the Events screen To invoke this screen click Events button in the Clearing Product Definition screen The screen appears as shown below 4 10 ORACLE Events Product Code Product Description Class Details Class Code Class Description Event Details 10f1 0O Accounting Entries Advices The following events are maint

Clearing User Manual - Oracle Documentation

Contents

Download Pdf Manuals

Related Search

Related Contents