Liquidation User Manual
Contents
1. Click Default button to default the values maintained at contract level AR AP Code Specify a valid AR AP code you need for the specified contract reference The adjoining option list displays all valid open and authorized AR AP codes You can choose the appropriate one GL Code Specify a valid GL code you need to assign to specified AR AP code The adjoining option list displays all valid open and authorized Asset or Liability Leaf GLs You can choose the appropriate one If the GL Code is not specified then the system displays the GL code based on the AR AP Code maintained at AR AP Code Maintenance level Branch Code of the current branch is defaulted here Account Currency Specify currency code you need to assign for the account The adjoining option list displays all valid open and authorized currency codes You can choose the appropriate one AR AP Amount Specify a valid amount for the AR AP account Booking Account Specify a valid booking account to book the receivable or payable amount The adjoining option list displays all valid Income and Expense Leaf GLs You can choose the appropriate one Booking Branch Specify branch code of the booking account The adjoining option list displays all valid branch codes You can choose the appropriate one Account Currency Specify currency code of the booking account The adjoining option list displays all valid currency codes You can select the appropriate on2. You can invoke Receivable Payable Online Summary screen by typing LQSTRONL in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button 2 11 ORACLE Receivable Payable Online Summary Contract Reference H AR AP Reference Module E Customer Value Date User Reference Booking Date Receivable branch Receivable Payable Q Search AdvancedSearch Records per page 15 14 4 1 Of 1 py Authorization Status Liquidation Status Contract Reference Reference Module Customer Name A You can search for the AR AP details based by specifying any or all of the following criteria Contract Reference Specify a valid contract reference number to query based on the contract reference The adjoining option list displays all valid contract reference numbers You can choose the appropriate one AR AP Reference Specify a valid AR AP reference linked to the contract to query based on the AR AP reference The adjoining option list displays all valid AR AP reference numbers You can choose the appropriate one Module Specify a valid module in which the contract was created to query based on the module The adjoining option list displays all valid available modules You can choose the appropriate one Customer Spec
3. Main Advice Tracers AR AP Reference 000ZRLQ11248001N 3 Customer E Receivable Payable Receivable Component Party Name Payable Component Description Party Type Value Date Default AR AP Code Booking Account ij Offset Account GL Code B Booking Branch Branch Branch Account Currency Currency Account Currency 4 rz Amount Transaction Code 23 AR AP A o SY R AP Amount Exchange Rate Negotiated Rate Charge Claim Advice Internal Remarks Outstanding Amount External remarks Liquidated On External Remarks Tag72 Liquidation Amount Description External Remarks Tag79 Waive Outstanding Amount Maker DateTime Auth Status Checker Liquidation Status DateTime You can liquidate the components of a contract that have been put into a receivable account 24 ORACLE 2 2 1 Contract Reference Specify a valid contract reference number you need to mark to the Track Receivable or Payable process The adjoining option list displays valid reference numbers of the contracts created in different modules You can choose the appropriate one However the system displays reference number for AR AP records created as part transaction initiated in different modules Book Date The system defaults book date to the current date of the system Ev
4. The system displays the print option screen Here you can set your preferences as to printing the report Click OK button to print the report 4 2 2 Contents of Report The contents of the report have been discussed under the following heads Header The Header carries the title of the report branch code branch date user ID module from which the report has been generated date and time at which the report has been generated and the page number of the report Body You can find the following liquidation event details in the body of the report 4 2 ORACLE Liquidation Specifies the Liquidation Event Code Event Code Liquidation Specifies the liquidation currency Currency Maker Date Specifies the date on which the record was made by the Maker Stamp Liquidation Specifies the Liquidation Reference Number Reference Liquidation Specifies the Liquidation event sequence number ESN Contract Specifies the contract reference number Reference Latest ESN Specifies the sequence number of the latest event Liquidation Specifies the Liquidation status Status Authorization Status Specifies the liquidation authorization status Maker Id Specifies the ID of the maker of the record Checker Id Specifies the ID of the checker of the record Checker Date Stamp Specifies the date on which the checker had authorized the record Liquidation Account Specifies the liquidation
5. account code 4 3 ORACLE 4 3 Transaction Code Liquidation Specifies the Liquidation Branch Branch Liquidation Specifies the value date of the liquidation Value Date Liquidation Specifies the liquidation Transaction Code Liquidation Amount Specifies the liquidation amount Total Amount Specifies the total liquidation amount Outstanding Items Report The Outstanding Items report provides the details of all outstanding liquidation records in both receivable and payable accounts across the modules in Oracle FLEXCUBE This report also helps you retrieve the details of open ended letters of credits This report generates the details based on AR AP code or CIF counterparty You can set the preferences for generation of the report using the Outstanding Items Report screen This report will list all the outstanding item that are booked under receivable To invoke the screen type LORPOS in the field at the top right corner of the Application tool bar and click the adjoining arrow button 4 4 ORACLE Open Ended Letter of Credits Activities All Single Module z Branches All Current Branch AR AP Code Customer Id Date Select Book From Date Book To Date 4 3 1 Report Options You can set your preferences for report generation on this screen Activities All Single Module You can generate this report for a specific module or al
6. choose the appropriate one Click Search button The system displays the following details based on the criteria specified e Reference e Value Date e Module e Booking Date e User Reference e Code e Component e GL Code e Account Currency e Amount e Liquidation Amount e Outstanding Amount e Transaction Code e Offset Account e Offset Branch e Offset Currency e Exchange Rate 2 17 ORACLE 2 5 e Negotiated Rate e Offset Amount e Remarks Generating Liquidation Tracers The system enables you to generate Charge Claim Tracer manually using Tracer Generation screen You can invoke Tracer Generation screen by typing LQDTRGEN the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button Tracer Generation Liquidation Reference H Customer ID Number Account Currency Party Name Amount Tracer Remarks Generate You can maintain the following parameters here Liquidation Reference Number The system defaults the liquidation reference number maintained at AR AP Liquidation level Customer ID The system defaults the customer ID maintained at AR AP Liquidation level Party Name The system defaults the party name maintained at AR AP Liquidation level Account Currency The system defaults the account currency maintained at AR AP Liquidation level Amount The system defaults the am
7. to be generated Suppress Check this box if you need to suppress the advice 2 5 ORACLE Medium Select the medium through which you need to generate the displayed advice The adjoining option list displays all valid media You can choose the appropriate one Priority Select priority in which the advice needs to be generated from the adjoining drop down list This list displays the following values e High Select if you need to generate the advice on high priority e Medium Select if you need to generate the advice on medium priority e Low Select if you need to generate the advice on low priority Note the following e f you are booking a new receivable contract then the system defaults LQCHG_CLAIM_ADV advice e If you are booking a new payable contract then the system defaults LQCHG_PAYADV advice e f you are liquidating a receivable contract then the system defaults CHG_LIQ_DR_ADV advice e f you are liquidating a payable contract then the system defaults CHG LIQ CR ADV advice 2 2 3 Tracers Tab Click Tracers tab to maintain tracer details Receivable Payable Online Contract Reference 23 Book Date Event Code Event Description Module Main Advice Tracers Tracking Event Media Required Start Days Frequency Last Sent Date Maximum Tracers No of Tracers Sent DateTime Auth Status Liqu
8. without notice and is not warranted to be error free If you find any errors please report them to us in writing This software or hardware and documentation may provide access to or information on content products and services from third parties Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third party content products and services Oracle Corporation and its affiliates will not be responsible for any loss costs or damages incurred due to your access to or use of third party content products or services
9. 2 4 1 Authorizing Consolidated Liquidation eese nennen enne 2 16 2 5 GENERATING LIQUIDATION TRACERS ccccccccccessesssstsecececeessaecececeesessaassesececeeseaaeseseceseesseaesececsceesenseaeeeeees 2 18 3 EOD PROGESSIN o 3 1 3 1 INTRODUCTION cies E 3 1 3 2 PROCESSING EOD FOR RECEIVABLE PAY ABLE COMPONENTS sssssssssseeececsesssececececeesenaneeeeeeesensasaeseeses 3 1 3 2 1 LO OTT Funcom E 3 1 3 2 2 LO EOD F nction m 3 1 4 REPORTS 4 1 4 1 INTRODUCTION nanena ee E a E ED E A 4 1 4 2 LIQUIDATION DAILY ACTIVITY REPORT cccccccccecccececececececeseceseecseeesecececessesseessecesesesesesssessessessseuseeeeseeess 4 1 4 2 1 Repor Options MM Em 4 1 4 2 2 Contents Report uiii Rit ete lee rete e e ae E le is 4 2 4 3 OUTSTANDING ITEMS REPORT VARRONE TREE ERR REED EE SS 4 4 4 3 1 Repor Options a Em 4 5 4 3 2 Contents Report iiie te bed Ete A A I SEE E E E E MB Ce pe E ER 4 5 PEE 4 0h19 D die EE 5 1 5 1 TNTRODUCTION MEE 5 1 5 2 ADVICES FOR LQ C ana EFSER 5 1 6 SCREEN GLOSSARY 6 1 6 1 FUNCTION ID LIST i sern a c eee eee Pere r aint Dit tees 6 1 ORACLE 1 1 1 2 1 3 1 4 1 5 Intro
10. AR AP account currency Liquidation On Specify a valid date when you need to liquidate the specified outstanding amount from the adjoining calendar Liquidation Amount Specify the amount you need to liquidate from the displayed outstanding amount The system enables partial or complete liquidation of the outstanding amount Description Specify remarks if any for the liquidation amount Waive Outstanding Amount Check this box if you need to waive the outstanding amount 2 4 ORACLE 2 2 2 Internal Remarks Specify internal remarks for the contract if any External Remarks Specify external remarks for the contract if any External Remarks 72 Specify external remarks you want to specify for Tag72 of the message if any External Remarks Tag79 Specify external remarks you want to specify for Tag72 of the message if any Advices Tab Click Advices tab to maintain advice details Receivable Payable Online Contract Reference 3 Book Date Event Code Event Description Module IE Main Advice Tracers Advice Details 10f1 zi Hion wj Eem ws Maker DateTime Auth Status Checker Liquidation Status DateTime You can maintain the following parameters here Advice Details The following advice details can be maintained Advice The system defaults the name of the advice that needs
11. Head Rate Code Spread Rate At Rate Type J Transaction MIS Pool Code Contract Level MIS Group Transaction MIS 1 Transaction MIS 2 Transaction MIS 3 Transaction MIS 4 Transaction MIS 5 Transaction MIS 6 Transaction MIS 7 Transaction MIS 8 Transaction MIS 9 Transaction MIS 10 3 Interest Method Refinance Rate Pool Code Composite MIS Cost Code1 Cost Code2 Cost Code3 Cost Code4 Cost Code5 Fund MIS MIS Group Composite MIS 1 Composite MIS 2 Composite MIS 3 Composite MIS 4 Composite MIS 5 Composite MIS 6 Composite MIS 7 Composite MIS 8 Composite MIS 9 Composite MIS 10 Fund MIS 1 Fund MIS 2 Fund MIS 3 Fund MIS 4 Fund MIS 5 Fund MIS 6 Fund MIS 7 Fund MIS 8 Fund MIS 9 Fund MIS 10 The system defaults MIS details maintained for the contract 2 2 6 Authorizing Receivable Payable Online Oracle FLEXCUBE facilitates online authorization of AR AP account using Receivable Payable Online Authorization scr
12. Liquidation Oracle FLEXCUBE Universal Banking Release 11 5 0 0 0 July 2014 ORACLE FINANCIAL SERVICES ORACLE Product Table of Contents 1 ABOUT THIS MANDA Y 1 1 1 1 UBS WB BC 1 1 1 2 AUDIENCE M RM E 1 1 1 3 CONVENTIONS USED IN THIS MANUAL eerte ere emen nnnm nnnneses ese ese ese ese ese e ess sese esas etes e ese ases s sese 1 1 1 4 GLOSSARY OR ICONS cel inte vete Pee ure avete cea da VER CR 1 1 1 5 RELATED DOCUMENTS krodis orne rea e env Ete erebes tue Ave Ce a YE ke Perd ve EE CR EE DR ER ER DRYER E Er eae tee DRYER Eds 1 1 2 2 1 2 1 INTRODUCTION P 2 1 2 2 MAINTAINING ONLINE RECEIVABLE PAY ABLE DETAILS eee eene ete esee senes nnus 2 1 2 2 1 TAD X Q 2 2 2 22 AAVICES RR 2 5 2 2 3 LGD ERE RR 2 6 2 2 4 Specifying Events Details uscite 2 7 2 2 2 Assiening MIS Details eee deren e or EN CEP Ea MER Eee e eire Ee e Hee 2 9 2 2 6 Authorizing Receivable Payable Online eese terne eene eene 2 10 2 3 VIEWING ONLINE RECEIV ABLE PAY ABLE 5 2 11 2 4 PROCESSING CONSOLIDATED LIQUIDATION scssssssesececeesessececececsessuesecececeeseaesesececsessaaesececeeeesenseaeeeeess 2 13
13. and Bills under LC FT FTCHG_CLAIM_ADV MT191 Sent to Remitting bank for claiming charges and CL LQCHG CLAIM ADV MT991 For miscellaneous items captured through the AR AP Liquidation Screen Recording a Payable Module Message Type Swift Message Type Description BC BCCHG PAYADV MT499 For Collection LC LCCHG PAYADV MT799 For LC and Bills under LC FT FTCHG PAYADV MT199 Sent to Receiving bank informing Credit of Charges and CL LQCHG PAYADV 999 For miscellaneous items captured through the AR AP Liquidation Screen Liquidation of Receivable Module Message Type Swift Message Type Description BC LC FT CHG LIQ DR ADV MT900 Liquidation Debit advice PC and CL Liquidation of Payable Module Message Type Swift Message Type Description BC LC FT CHG CR ADV MT910 Liquidation Credit advice PC and CL 5 1 ORACLE Liquidation of a Consolidated Receivable Module Message Type Swift Message Type Description BC LC FT DR ADV MT900 Consolidated Liquidation PC and CL Debit advice Liquidation of a Consolidated Payable Module Message Type Swift Message Type Description BC LC FT CHGC LIQ CR ADV MT910 Consolidated Liquidation PC and CL Credit advice 5 2 ORACLE 6 1 Function ID List 6 Screen Glossary The following table lists the fu
14. been generated and the page number of the report Body You can find the following details in the body of the report 4 6 ORACLE Party CIF ID The CIF ID of the counter party Party Name Name of the counter party Party Type The type the counterparty belongs to Account The currency in which the party s account is maintained Currency Module The module for which the record belongs to Amount Tag The amount tag Contact Specifies the contract reference number Reference Description Gives a brief description of the contract Event Code Specifies the event code Booking Date Specifies the booking date of the contract Receivable Specifies the account number of the receivable account Account Number Account Specifies the branch where the account is held Branch Amount Specifies the amount in the outstanding item Value Date Specifies the value date of the record 4 7 ORACLE 5 1 5 2 Introduction 5 Appendix This Annexure contains details of the suggested messages that can be generated for the LQ module The annexure lists details of the suggested messages module wise for LQ Advices The following is a list of modules related advices and the description that are supported for LQ Module Recording a Receivable Module Message Type Swift Message Type Description BC BCCHG CLAIM ADV MT491 For Collection LC LCCHG_CLAIM_ADV MT791 For LC
15. d adaptation of the programs including any operating system integrated software any programs installed on the hardware and or documentation shall be subject to license terms and license restrictions applicable to the programs No other rights are granted to the U S Government This software or hardware is developed for general use in a variety of information management applications It is not developed or intended for use in any inherently dangerous applications including applications that may create a risk of personal injury If you use this software or hardware in dangerous applications then you shall be responsible to take all appropriate failsafe backup redundancy and other measures to ensure its safe use Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws Except as expressly permitted in your license agreement or allowed by law you may not use copy reproduce translate broadcast modify license transmit distribute exhibit perform 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
16. datory program in the EOC stage LQ EOTI Function There are some occasions when you have to reverse a contract on which a receivable component has been liquidated The following is an example Example You issue an LC for Gem Granites on 01 January 1998 for which the charges and commission was debited from a receivable account On 05 January 1998 you liquidate the commission from the customer s account Thereafter say on 07 January 1998 you reverse the LC All the entries for the LC that were passed when the LC was stored including the entries passed into the receivable account will be reversed However the entries that were passed to liquidate the commission from the customer s account which was subsequently done through the liquidation function will not be reversed This entry will be reversed by the LQ EOTI of 07 January 1998 LQ EOD Function A charge claim advice informs the concerned party about a component that is outstanding against them This advice will be generated on the day a contract is booked or when any subsequent amendment for the contract is stored and authorized The generation of this advice is done by the LQ EOD function The advices are put in the Outgoing Messaging Browser by this function You should generate them from the browser 3 1 ORACLE 4 1 4 2 4 Reports Introduction Information on the contracts liquidated and the static maintenance done for the liquidation module is available in
17. displays all valid customer IDs You can choose the appropriate one Contract Reference Specify a valid contract reference number to query based on the contract reference The adjoining option list displays all valid contract reference numbers You can choose the appropriate one User Reference Specify a user reference number of the contract to query based on the user reference The adjoining option list displays all valid user reference numbers You can choose the appropriate one 2 14 ORACLE Module Specify a valid module in which the contract was created to query based on the module The adjoining option list displays all valid available modules You can choose the appropriate one Value Date Specify a valid date to query based on the value date of the liquidation batch from the adjoining calendar Account Currency Specify a valid currency of the account to query based on the account currency The adjoining option list displays all valid currency codes You can choose the appropriate one Receivable Payable Select if the account is a receivable or a payable account to query based on the account type from the adjoining drop down list Booking from Date Specify a valid date from when the liquidation batch was booked to query based on the booking from date of the batch from the adjoining calendar Booking to Date Specify a valid date till when the liquidation batch was booked to query based on the booking to date of the ba
18. duction This manual is essentially designed to guide you through the steps involved in liquidation of contracts maintained in Oracle FLEXCUBE Liquidation of contracts maintained in BC CL FT LC and PC are covered in this module Further you can obtain information specific to a particular 1 About this Manual field by placing the cursor on the relevant field and striking lt F1 gt on the keyboard 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 Managers Financial Controller Product Generation of reports Conventions Used in this Manual Important information is preceded with the symbol Glossary of Icons This User Manual may refer to all or some of the following icons Icons Function X Exit Delete row 28 Option List Related Documents For further information on contracts discussed in the manual refer to the Oracle FLEXCUBE manuals on e Bills and Collections e Retail Lending e Funds Transfer 1 1 ORACLE e Letters to Credit e Payments and Collections 1 2 ORACLE 2 1 2 2 2 Maintenance Introduction Whenever you need to col
19. during the Liquidation of an Account Payable or a Receivable Contract you can click View Error Button to invoke View Error screen which displays the Error code and Error Message for the corresponding Account Payable or a Receivable Contract View Error 1of1 E3 Iv Batch Reference ContractReference AR AP Reference ErorCode Ermortet Failed in Account entries Jv 000ZCLQ12066005 000ITR1120660101 0002RLO1206600 LIQ 0030 Authorizing Consolidated Liquidation Oracle FLEXCUBE facilitates querying for unauthorized Receivable or Payable contracts based on Liquidation Batch Reference Number using Consolidated Liquidation Authorization screen Only the user with authorization rights to Receivable Payable Online records can authorize these records however maker is of the record is not eligible to authorize You can invoke Consolidated Liquidation Authorization screen by typing LQDALIQ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button 2 16 ORACLE Consolidated Liquidation Authorization Liquidation Batch Reference No 10f1 You can query for the record based on the following criteria Liquidation Batch Reference No Specify a valid liquidation batch reference number to query based on the liquidation batch reference The adjoining option list displays all valid liquidation batch reference numbers You can
20. e Offset Account Specify offset account for the specified contract if you want to maintain offset account details at the booking stage The adjoining option list displays all valid account numbers You can choose the appropriate one 2 3 ORACLE Branch Specify branch code of the offset account if you want to maintain offset account details at the booking stage The adjoining option list displays all valid branch codes You can choose the appropriate one Currency Specify currency code of the offset account if you want to maintain offset account details at the booking stage The adjoining option list displays all valid currency codes You can select the appropriate one Transaction Code Specify transaction code for the specified contract The adjoining option list displays all valid transaction codes You can choose the appropriate one Exchange Rate Specify an exchange rate for the specified account currency Negotiated Rate Specify negotiated rate for the account currency if there is a difference in the exchange rate Amount The system displays amount equivalent to the offset currency if the offset account currency is different from the AR AP account and you click Recalculate button Charge Claim Advice Date Specify a valid date when you need to generate Charge Claim Advice from the adjoining calendar Outstanding Amount The system computes the outstanding amount which needs to be liquidated in the
21. een You can invoke Receivable Payable Online Authorization screen by typing LODTRAUT in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button This screen can also be viewed when you click on authorize button after maintaining details in the Receivable Payable Online screen Receivable Payable Online Authorization Contract Details Liquidation Reference Number Event Code Event Date Contract Overrides Input By Generate Message 10f1 conmnes You can query unauthorized LQ contracts and authorize the contract after accepting override messages if any raised at that time of saving You can query based on the following criteria 2 10 ORACLE 2 3 Liquidation Reference Number Specify a valid liquidation reference number of AR AP account The adjoining option list displays all valid reference numbers You can choose the appropriate one Input By The system defaults ID of the maker here Generate Message Check this box to generate message Contract Overrides You can specify the following parameters here Confirmed Check this box to confirm override message displayed if any Overrides System defaults override messages displayed while generating message if any Viewing Online Receivable Payable Details You can view details related to the AR AP accounts using the Receivable Payable Online Summary screen
22. ent Code The system defaults event code to INIT Event Description The system defaults event description to Initiation Module The system defaults module to LQ Main Tab You can maintain the following parameters here AR AP Reference The system defaults a unique liquidation reference number as AR AP reference number Customer Specify a valid name of the customer you need to link the AR AP liquidation The adjoining option list displays all valid open and authorized customer numbers You can choose the appropriate one Receivable Payable Select component type from the options The following options are available for selection e Receivable Select if you need to maintain the component as receivable e Payable Select if you need to maintain the component as payable Component Component assigned to the specified contract reference is defaulted here based on the details maintained at contract level Component Description Description of the displayed component is defaulted here Party Name Specify name of the party for which you need to maintain the receivable or payable details 2 2 ORACLE Party Type Party type of the specified party name is defaulted here based on the details maintained in the system Value Date Specify a valid value date for the specified contract reference from the adjoining calendar The system defaults application date as the value date however you can modify the same
23. idation Status DateTime You can maintain the following parameters here Tracking Event The following advice details can be maintained 2 6 ORACLE 2 2 4 Required Check this box if you require to maintain tracking event Frequency Specify the frequency of tracking the events Maximum Tracers Specify the maximum number of tracers allowed for tracking an event No of Tracers Sent The system defaults the number of tracers which were sent Medium Select the medium through which you need to generate the displayed advice The adjoining option list displays all valid media You can choose the appropriate one Start Days Specify the date from which the tracers has to be sent Last Sent Date The system defaults the last date when the tracking event was sent Specifying Events Details At an event typically you would want to post the accounting entries to the appropriate account heads and generate the required advices When setting up a liquidation contract you can view the accounting entries that have been posted at the various events To do this click Events button in the screen Event Details Liquidation Events 10f1 mm Event Number Event Code Event Description Value Date The system displays the following details of the Events associated with the specified contract which can not be modified 2 7 ORACLE e Event Number e Event Code e Event Descrip
24. ify a valid customer name to query based on the customer The adjoining option list displays all valid customer names You can choose the appropriate one Value Date Specify a valid date to query based on the value date of the contract from the adjoining calendar 2 12 ORACLE 2 4 User Reference Specify a user reference number of the contract to query based on the user reference The adjoining option list displays all valid user reference numbers You can choose the appropriate one Booking Date Specify a valid date to query based on the booking date of the contract from the adjoining calendar Receivable Branch Specify a branch code of the receivable Bank to query based on the receivable branch The adjoining option list displays all valid branch codes You can choose the appropriate one Receivable Payable Select if the account is a receivable or a payable account to query based on the account type from the adjoining drop down list Click Search button The system displays the following details based on the criteria specified e Authorization Status e Liquidation Status e Contract Reference e AR AP Reference e Module e Customer e Party Name e Amount e Liquidated Amount e Receivable Account e AcCCY e Value Date e Event Code e Charge Claim Advice Date e User Reference e Booking Date e Receivable Branch e Booking Branch e Receivable Payable Processing Consolidated Liquidation Oracle FLEXCUBE facilita
25. l the modules in the system If you select Single Module you need to specify the module code in the field below Branches All Current Branch Specify whether the report should with regard to all branches or in the current branch Once you have specified the necessary details click OK button The system displays the print option screen Here you can set your preferences as to printing the report Click OK button to print the report From Date Specify a valid date from when you need to generate the report If not maintained then the system generates all the outstanding records prior to To Date To Date Specify a valid date till when you need to generate the report If not maintained then the system generates all the outstanding records after From Date till the current date Customer No Specify a valid customer number you need to generate report for The adjoining option list displays all valid customer numbers maintained for AR AP You can choose the appropriate one AR AP Code Specify a valid ARAP code you need to generate report for The adjoining option list displays all valid AR AP codes You can choose the appropriate one 4 3 2 Contents of Report 4 5 ORACLE The contents of the report have been discussed under the following heads Header The Header carries the title of the report branch code branch date user ID module from which the report has been generated date and time at which the report has
26. lect an ICCF component availment amount or the collateral amount you debit it from the customer s account On some occasions you may have to debit it from an internal receivable payable GL to be debited from the customer account at a later date The debiting of the receivable or payable account happens at the event for which the commission or charge has to be collected issue of a contract amendment of a contract availment against an contract etc When the customer account has to be debited at a later date you have to perform what is termed as receivable liquidation There are two related functions associated with liquidation e A batch process that reverses the liquidated receivable components for a contract that is reversed during the day the LQ EOTI function e A batch process that generates the charge and commission claim advice to the party on behalf of whom a charge or commission was debited from a receivable account during the day the LQ EOD function Maintaining Online Receivable Payable Details You can pass manual entries into LQ Module to maintain additional entries into AR AP LQ Module in the Receivable Payable Online screen You can invoke Receivable Payable Online screen by typing LQDTRONL in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button P Receivable Payable Online Contract Reference i Book Date Event Code Event Description Module
27. nction id and the function description of the screens covered as part of this User Manual Function ID Function Description LQDALIQ Consolidated Liquidation Authorization LQDCLIQ Consolidated Liquidation LQDTRAUT Receivable Payable Online Authorization LQDTRGEN Tracer Generation LQDTRONL Receivable Payable Online Error Reference source not found Liquidation Daily Activity Report Error Reference source not found Outstanding Items Report LQSTRONL Receivable Payable Online Summary 6 1 ORACLE ORACLE Product July 2014 Version 11 5 0 0 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 2007 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 an
28. ount number maintained at AR AP Liquidation level Tracer Remarks Specify remarks you need to generate for SWIFT or MAIL tracer messages if any 2 18 ORACLE 3 1 3 2 3 2 1 3 2 2 3 EOD Processing Introduction This chapter introduces you to the batches maintained for liquidation of Receivable Payable components at EOD stage As part of Receivable Liquidation batch e For each Receivable entry a record will be created for Charge Claim Advice in Outgoing Browser Respective messages will be recorded based on the module e For each Payable entry a record will be created for Charge Pay Advice in Outgoing Browser Respective messages will be recorded based on the module The messages have to be generated manually from Outgoing Browser Based on the default media of the customer either MAIL or SWIFT message will be generated Processing EOD for Receivable Payable Components The following End of Day processing is done for receivable payable components e A batch process that reverses the liquidated receivable components for a contract that is reversed during the day the LQ EOTI function This function should be defined as a mandatory program in the pre EOC stage e A batch process that generates the charge and commission claim advice to the party behalf of whom a charge or commission was debited from a receivable account during the day the LQ EOD function This function should be defined as a man
29. tch from the adjoining calendar Receivable Payable GL Code Specify GL code of the receivable payable GL to query based on the GL code The adjoining option list displays all valid GL codes You can choose the appropriate one Click Search button The system displays the following details based on the criteria specified e AR AP Reference e Value Date e Module e Booking Date e User Reference e AR AP Code e Component e GLCode e Account Currency e Amount e Liquidation Amount e Outstanding Amount e Transaction Code e Exchange Rate e Offset Amount 2 15 ORACLE 2 4 1 Select contracts you need to add to bulk liquidation and maintain the following parameters Negotiated Rate Specify a valid negotiated rate for queried LQ contract if any Remarks Specify remarks for queried LQ contract if any Offset Account Specify a valid account you need to set as offset account for liquidation The adjoining option list displays all valid account number You can choose the appropriate one Offset Branch Specify code of the branch in which the specified offset account is maintained The adjoining option list displays all valid branch codes You can choose the appropriate one Offset Currency Specify currency you need to assign to the specified offset account The adjoining option list displays all valid currencies You can choose the appropriate one After processing the Bulk Liquidation if there are any errors
30. tes selecting multiple LQ contracts associated with a single customer and contract and initiating bulk liquidation by viewing all the outstanding receivable or payable contracts for the customer of a branch for a specified period of time You can perform the above operation using Consolidated Liquidation screen You can invoke Consolidated Liquidation screen by typing LQDCLIQ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button 2 13 ORACLE Consolidated Liquidation Liquidation Batch Reference No Customer Id Contract Reference No Receivable Payable User Reference Book From Date Module Book To Date Value Date Receivable Payable GL Code Account Currency 10f1 fo AR AP Reference Value Date Module Booking Date AR AP Code GL Code Offset Account Offset Branch Offset Currency After querying the contract you can liquidate the contract and add remarks if any for each LQ contracts before saving You can search for the AR AP details based by specifying any or all of the following criteria Liquidation Batch Reference No Specify a valid liquidation batch reference number to query based on the liquidation batch reference The adjoining option list displays all valid liquidation batch reference numbers You can choose the appropriate one Customer ID Specify a valid customer ID to query based on the customer ID The adjoining option list
31. the form of reports These reports can be generated with information on many parameters outstanding items unreplied tracers etc These reports can be printed spooled on to a disk file or displayed on the screen You can generate the following reports for the LQ module e Liquidation Daily Activity Report e Outstanding Items Report Liquidation Daily Activity Report The Liquidation Daily Activity Report provides information on all liquidation events or a particular event which took place on a specified date You can set the preferences for generation of the report via the Liquidation Daily Activity Report screen To invoke the Liquidation Daily Activity Report screen type LQRPDLY in the field at the top right corner of the Application tool bar and click the adjoining arrow button Open Ended Letter of Credits Activities All 5 Single Module az Branches All Current Branch AR AP Code Customerld Date Select Book From Date Book To Date 4 2 4 Report Options You can set the following preferences for report generation in this screen All Events Single Event Choose whether you want a report on all liquidation events or a single event Event Code Specify the Event Code of the liquidation event which you wish to view as a report 4 1 ORACLE Value Date Specify the value dates for which the report must be generated Once you have specified the necessary click OK button
32. tion e Value Date 2 2 4 1 Defining Accounting Entries To view accounting entries for an event click Accounting Entries in the Events button of the Receivable Payable Online screen Accounting Entries Reference Number undefined Accounting Entries 10f1 m Account Amount Tag Foreign Currency Amount Local Currency Amount od lt Overrides 10f1 You can view the following parameters e Branch e Account e Dr Cr e Amount Tag e Currency e Foreign Currency Amount e Rate e Local Currency Amount e Date e Value Date e Code e Overrides e Override Status ORACLE e Authorized By e Auth Date Stamp 2 2 4 2 Reversing Liquidation Accounting Entries You can reverse the authorized accounting entries that were passed when you liquidated a receivable payable outstanding component of a contract You can reverse the accounting entries passed for the liquidation of an outstanding component of a contract through the Receivable Payable Liquidation screen Specify the Contract Reference Number of the contract All the outstanding components of the contract that were paid from a receivable payable and income expense GL account will be displayed Query the component whose liquidation entries you want to reverse Click Roll over icon on the tool bar The system will prompt you to indicate whether you want to reverse the liquidation en
33. tries passed for the outstanding component or make the component outstanding again If you indicate that the entries should be reversed the accounting entries that were passed earlier will be reversed However you will not be able to liquidate the component at a future date If you indicate that the component should be made outstanding the accounting entries that were passed earlier will be reversed and the component will become outstanding again The component can be liquidated later on You can also mark an Outstanding Liquidation Contract as Reversed This option would be used to waive a particular Receivable Payable Contract When an outstanding liquidation contract is reversed the accounting entries are reversed for the Outstanding Liquidated Amount from the Receivable Payable GL and the Income Expense GL The Income Expense GL will be derived from the Product Event Accounting Entry Definition for the corresponding Amount Tag and Event Code These entries would be passed with the Accounting Reference Number as the AR AP Reference Number 2 2 5 Assigning MIS Details You can associate MIS details with a product in the MIS screen Click MIS button in the Receivable Payable Online screen to invoke it 2 9 ORACLE Contract Reference 000ZRLQ11248001T MIS Group Default Link To Group Input Link To Group Related Reference Related Account Related Account Related Reference MIS
Download Pdf Manuals
Related Search