FGL Integration - Oracle Documentation
Contents
1. 3 1 ORACLE FGL Integration April 2014 Version 11 3 83 02 0 Oracle Financial Services Software Limited Oracle Park Off Western Express Highway Goregaon East Mumbai Maharashtra 400 063 India Worldwide Inquiries Phone 91 22 6718 3000 Fax 91 22 6718 3001 www oracle com financialservices Copyright 2005 2014 Oracle and or its affiliates All rights reserved Oracle and Java are registered trademarks of Oracle and or its affiliates Other names may be trademarks of their respective owners U S GOVERNMENT END USERS Oracle programs including any operating system integrated software any programs installed on the hardware and or documentation delivered to U S Government end users are commercial computer software pursuant to the applicable Federal Acquisition Regulation and agency specific supplemental regulations As such use duplication disclosure modification and adaptation of the programs including any operating system integrated software any programs installed on the hardware and or documentation shall be subject to license terms and license restrictions applicable to the programs No other rights are granted to the U S Government This software or hardware is developed for general use in a variety of information management applications It is not developed or intended for use in any inherently dangerous applications including applications that may create a risk of personal injury If you2. Input functions for maintenances Back office Managers Officers Authorization functions Acronyms and Abbreviations System Unless and otherwise specified it shall always refer to Oracle FLEXCUBE system System Data Element Oracle FLEXCUBE General Ledger General Ledger Organization This document talks about the required maintenance and further processing of data transfer between Oracle FLEXCUBE and FGL This includes the following e Maintaining Bank Parameters e Data Transfer from FGL to Oracle FLEXCUBE e Data Transfer from Oracle FLEXCUBE to FGL 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 1 ORACLE Refer the Procedures User Manual for further details about the icons 17 Related Documents You can refer to the following documents e XML Interface Document e Oracle FLEXCUBE General Ledger User Manual 1 2 ORACLE 2 1 2 2 2 Oracle FLEXCUBE FGL Integration Introduction Oracle FLEXCUBE General Ledger FGL system is the pillar on which various functional components of Oracle FLEXCUBE rest Through this single entity you can consolidate and maintain balances and turnovers of all types of accounts your bank holds In addition FGL helps you retrieve the information on the FGLs maintained for your bank FGL is a standalone general ledger system with the ability to define c
3. use this software or hardware in dangerous applications then you shall be responsible to take all appropriate failsafe backup redundancy and other measures to ensure its safe use Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws Except as expressly permitted in your license agreement or allowed by law you may not use copy reproduce translate broadcast modify license transmit distribute exhibit perform publish or display any part in any form or by any means Reverse engineering disassembly or decompilation of this software unless required by law for interoperability is prohibited The information contained herein is subject to change without notice and is not warranted to be error free If you find any errors please report them to us in writing This software or hardware and documentation may provide access to or information on content products and services from third parties Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third party content products and services Oracle Corporation and its affiliates will not be responsible for any loss costs or damages incurred due to your access t
4. CH PARAMETERS ese es ee ee se ee se ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee 2 2 2 4 DATA TRANSFER FROM FGL TO ORACLE FLEXCUBE ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ed 2 2 2 5 DATA TRANSFER FROM ORACLE FLEXCUBE TO FG Lz ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ed 2 3 2 5 1 AE ee Dara FAG ie ON EE N OE N EN 2 3 2 5 2 BASE oe EE OR EO N ER N OE N 2 4 2 3 3 ee MOS sa BED oisin A A E a 2 5 3 SCREEN GLOSSARY sesscsesccscsccsccsesecscsesecseseoecsescocesesecsesesscsececsesesecseseosesesccsesesecseseoseseseosesessesesessesessosesesees 3 1 3 1 FUN TONIO T eea E E A A eee Ge 3 1 ORACLE 1 1 1 2 1 3 1 4 1 5 1 6 1 About this Manual Introduction This manual is designed to help acquaint you with the integration of Oracle FLEXCUBE and Oracle FLEXCUBE General Ledger FGL system This manual provides you extensive explanations about the maintenances and processing of exchange of data between Oracle FLEXCUBE and FGL Besides this User Manual while maintaining the details you can invoke the context sensitive help available for each field This help encapsulates the purpose of each field within a screen Placing the cursor on the relevant field and striking the lt F1 gt key on the keyboard can obtain information specific to a particular field Audience This manual is intended for the following User User Roles Back office data entry Clerks
5. FGL Integration Oracle FLEXCUBE Universal Banking Release 11 3 83 02 0 April 2014 Oracle Part Number E53607 01 ORACLE FINANCIAL SERVICES FGL Integration Table of Contents ORACLE FLEXCUBE UNIVERSAL BANKING ccccccccccccccccccccccccccccccccccccccccccccccccsccccccccccccccscccsccecces 0 RELEASE TI Douss cosssnsesersesasesdesaiesusJevassdawaucedesuee vesaesudencadevaxsiawasasdesceuacvese 0 L ABOUT THIS MA NEUAT ie es ed se a A a ents 1 1 1 1 INTRODUCTION sanea TETEE OEE EEEE NERE TEE EENE 1 1 1 2 AUDEN E era TEA AEA AEE AEEA AET GE AA AAEE AAT 1 1 1 3 ACRONYMS AND ABBREVIATIONS ccsceccsceccececcececcsceceecscsceceecscesescuceececeecscecscsscscssesceseeceseececescscusescsesees 1 1 1 4 ORGANIZATION aneen Bene es EE E EET EEE EE Ee EG EE 1 1 1 5 CONVENTIONS USED IN THIS MANUAL ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee eed 1 1 1 6 GLOSSARY OF ICONS ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee 1 1 1 7 RELATED DOCUMENTS ees ese ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee 1 2 2 ORACLE FLEXCUBE FGL INTEGRATION esse esssssssse ese ese ees ees ee see se ooo ee ees ees e ese e ee ee ee ee ee ee ee ee ee ee ee 2 1 2 1 WI T a E E RAE 2 1 2 COPE MAINTENANCE S ons ee OE GE ee Se Ge ER N GE GE ee EG Ge NNE 2 1 2 3 MAINTAINING BRAN
6. from FGL SDE Definition General Ledger Information MIS Maintenance gt MIS Classes gt MIS Codes 2 2 ORACLE 2 5 2 5 1 The extracted data gets uploaded into the system The process of data transfer between Oracle FLEXCUBE and FGL takes place during intraday batch process The transfer will be completed before end of day operations begin The FGL data discussed above is a subset of what is required for Oracle FLEXCUBE Hence the extracted data needs to be enriched Data Transfer from Oracle FLEXCUBE to FGL Oracle FLEXCUBE hands off the following information to FGL e Transaction Data e Accounting Entries e Customer MIS Information FGL handoff job extracts the above data from Oracle FLEXCUBE and uploads them into FGL Transaction Data Handoff When a new transaction is created or an existing transaction is modified the system hands off the updated transaction data to FGL FGL stores the received transaction data as Transaction Objects Transaction data handoff will be triggered when the first accounting entry from a transaction comes for authorization in Oracle FLEXCUBE Based on the module of the transaction the system uses appropriate extractor packages and converts the data into record format which is recognized by FGL The system extracts all possible transaction attributes that can be used as SDEs and converts them into record format for handoff The number and nature of the transaction data extracted f
7. hart of accounts You may also use this system to keep a complete track of the ledger balances of your organization FGL interacts with external systems including Oracle FLEXCUBE through web services This enables transfer of information pertaining to transactions general ledgers MIS and accounting entries between these systems Data transfer between Oracle FLEXCUBE and FGL are facilitated by two jobs e FGL Extraction Job Extracts data from FGL e FGL Handoff Job Hands off data to FGL This document guides you through the maintenances and processes required for data transfer between Oracle FLEXCUBE and FGL Core Maintenances The following core maintenance should be in sync with Oracle FLEXCUBE for the FGL Integration e Bank Parameters e Branch Parameters e Financial Cycles Accounting Periods e Transaction Codes e Currency Details e Currency Position Details e MIS Maintenance e Chart of Accounts Refer to Oracle FLEXCUBE General Ledger User Manual for details on maintenances related to FGL 2 1 ORACLE 2 3 Maintaining Branch Parameters To enable data transfer between Oracle FLEXCUBE and Oracle FLEXCUBE General Ledger you need to set certain options at bank parameter level Branch Parameters Preferences Netting Suspense General Ledger Walk In Customer Internal Swap Customer Clearing Account Offset Clearing Account Weekly Holiday 1 Weekly Holiday 2 Clearing Bank Code MIS Group For Currency In
8. o or use of third party content products or services
9. rom each module will be different For example an FT contract may have 20 attributes where as a retail lending account may have 30 40 attributes However FGL receives a maximum of 30 transaction attributes irrespective of the module Along with the accounting entries Oracle FLEXCUBE sends the transaction object reference number generated by FGL for identification Changes in transaction MIS information transaction and composite MIS codes will be handed off to FGL along with the other transaction information 25 ORACLE 2 5 1 1 Mapping Transaction Attributes to SDEs 2 5 2 Transaction attributes extracted from Oracle FLEXCUBE needs to be mapped to a corresponding SDE in FGL User defined fields at the contract level can also be mapped to SDEs You can maintain this mapping using SDE Mapping screen To invoke the screen type IFDSDMAP in the field at the top right corner of the Application toolbar and click the adjoining arrow button SDE Mapping Detailed Module Code Module Description SDE Mapping 10f1 JE FCLSDE Code FGL SDE Id Attribute Name Attribute Description Maker Date Time od No Checker Date Time Record Status Authorization Status You can capture the following details on this screen Module Code Specify the module code You can map the attributes of transactions entered in this module to corresponding SDE from this screen Module Description The system displays the description of the mod
10. terdict Timeout Interval Status Processing Basis Provisioning Frequency Uncolected Funds Basis Minor Age Limit CTs Notification Daye Back Value Details Back Value Days LCY Msg Pret 261100005 E01100003 000000004 171200001 261200003 Interdict Validation Required sl E Deferred Statement Generation Enterprise General Ledger 21 10 Back Valued Check Required FGL Handoff Required Profit and Loss Adjustment Revaluation Split Details Track Prewious Year Profit And Loss Adjustment Revaluation Split Required Suspense Product Maintenance Debit Product Description Credit Product Description CHDP CASH DEPOSIT CHWL CASH WITHDRAWAL International Banking Account Number MASKS Bank Code Account Number FGL Integration LDAP DN Template LDAP OM Template dddddddd aaannnn FGL HandOTf Required cn lt FCCUSR cn User a dr i flex dc com Check this option to indicate that FGL handoff is required for the bank The system will enable data transfer between Oracle FLEXCUBE and FGL only you check this option 2 4 Data Transfer from FGL to Oracle FLEXCUBE FGL extracts information pertaining to general ledger and MIS for Oracle FLEXCUBE This extraction happens whenever one of the following operations happens in FGL Creation of GL Closure of GL Reopening of GL Creation of MIS Class Modification of MIS Class Additionally Oracle FLEXCUBE extracts the following maintenances
11. ule SDE Code Specify the SDE code to be mapped to the transaction attribute Module Transaction Attributes Specify the transaction attribute to be mapped to the selected SDE Depending on the SDE definition and mapping the transaction attributes handed off from Oracle FLEXCUBE will be mapped to the corresponding attribute in FGL Customer MIS Handoff When there is a change in customer MIS information in Oracle FLEXCUBE the details are handed off to FGL On customer authorization the system will identify the MIS change and initiate the handoff process 24 ORACLE 2 5 3 Accounting Entries Handoff During authorization after the transaction data handoff the system will begin handoff of accounting entries Accounting entries will be handed off in record format with AC_ENTRY_SR_NO in the beginning and end of the record For entries into customer accounts system updates the credit and debit GLs along with the current balance of the customer account This is handed off to FGL as an accounting entry pair FGL resolves and passes the accounting entries accordingly Oracle FLEXCUBE does not handoff revaluation position and IB entries to FGL These are resolved in FGL itself 2 5 ORACLE 3 1 3 Screen Glossary Function ID List The following table lists the function id and the function description of the screens covered as part of this User Manual Function ID Function Description IFDSDMAP SDE Mapping Detailed
Download Pdf Manuals
Related Search