Oracle Financial Services Data Integration Hub Pack Extension for
Contents
1. 11 3 MAPPING THE OFSAA USER TO FCUBS USER 5 12 4 LOGGING INTO FCUBS OFSAA INTERFACE raa 15 5 PREREQUISITES FOR DEPLOYING OFSAA FCUBS 5 17 6 DEPLOYING OFSAA FCUBS CONNECTORS USING REFRESH FCUBS INTERFACE MENU 21 7 UNDEPLOYING OFSAA FCUBS CONNECTORS USING REFRESH FCUBS INTERFACE MENU 24 Tal Deploying Upgraded So urce Version iuc cio ttr E e ere p e eet 24 7 2 Changes in ODI External Data Store Settings ssssssssssseeeeeeeeeeeneeennen nenne 24 8 420 0000 0 aon ei ig ra Cu A RH C E D c CAD n 26 8 1 listo GASA table Siess 26 9 CONSUMER LENDING CL MODULE eee 28 9 1 uictor tox cde n 28 10 COREMODBD LE 1 5 5 Dock da aaa Cu vu dC ox cx du gu Dc ck Ye tus ebur a eL ax n Rd Dd Cd Qa i OC AC ERR DD 30 10 1 Histor CORE Tables eie nete ete i er evt Ete Ee 30 11 ENTERPRISE LIMITS AND COLLATERAL MANAGEMENT2. ORACLE OFS DIH Foundation Pack Extension for FCUBS User Manual 1 4 Current Account and Savings Account e All the personal and business addresses email IDs and phone numbers associated with an account e List of branch transactions e account ledger and transactions on OD accounts Interest rates of CASA and OD accounts Consumer Lending e All the personal and business addresses email IDs and phone numbers associated with an account e Loan contract transactions details Repayment schedules of contracts like loan mortgages OD and credit cards Term Deposit e Term deposit product processor and term deposit ledger table details Enterprise Limits and Collateral e Details of the collaterals submitted by the customer for Management various loan contracts Customer credit line details e Market value and original value of the collaterals General Ledger e book parameters and the list of GL items available in FCUBS GL balance of the customer Interbank correspondent transactions of a customer Foreign Exchange Forex account transaction data of a customer e Foreign exchange contracts of a customer e Exchange rates between two currencies Money Market e Borrowing records of the customer e Money market transaction data Extraction process for tables of Flexcube module FIS is used as the gateway in the FCUBS OFSAA integration FCUBS internally uses FIS framework compon
3. 14 ORACLE OFS DIH Foundation Pack Extension for FCUBS User Manual 4 Logging into FCUBS OFSAA Interface Access the FCUBS OFSAA Interface using your login credentials User ID and password The built in security system ensures that you are permitted to access the window and actions based on the authorization only BEATLES Financial Services Analytical Applications Language US English User ID Password Login After logging into the application select Interface for Oracle Flexcube Universal Banking System from the applications drop down list Note You should be mapped at least any one of the FCUBS user groups in order to get the application in the drop down ORACLE Financial Services Analytical Applications Applications Object Administration System Configuration amp Identity Management Inbox 4 Data Integration Hub Data Integration Hub Financial Services Data Foundation Administration Application Data Interface Financial Services Data Integration Hub Administration Application Data Interface Interface for Oracle Flexcube Universal Banking System m zi t d Data Mapping Orchestration Interface for Oracle Banking Platform iaaio Interface for Oracle Data Relationship Management Interface for Oracle Fusion Accounting Hub Execution Refresh The FCUBS OFSAA landing page is displayed below 15 ORACLE OFS DIH Foundation Pack Extension for FCUBS Use
4. 17 ORACLE OFS DIH Foundation Pack Extension for FCUBS User Manual Settings gt Settings Definition Mode gt ODI Agent ODI User ODI Password Master Repository DB User Master Repository DB Password Master DB Driver Master DB Connection Work Repository SUPERVISOR 9955 DIHDEV ODI oracle jdbc OracleDriver jdbc oracle thin 10 184 135 6 1521 FSDFDB DIHREP amp Project Settings Project Folder Agent URL OFSAA_CONNECTORS FCUBS_OFSAA http 10 184 203 153 6789 oraclediagent 4 Asource named FCUBS STAGE SRC is present in External Data Store under DIH Application Select the entry which is present as FCUBS STAGE SRC and click Edit ORACLE Financial Services Analytical Applications Applications Object Administration System Configuration amp dently Management Inbox Select Applications Data integration Hub gt Data Mapping gt External Data Store Franca Senvcos Data integration Hub 4 Tk Data integration Hue 4 IB Administrator External Data Store Actu cz senings Name El Puttsunpubiish Connectors 19 Data intertace 4 lil Data Mapping E Parameters V FCUBS STAGE extemal Date store STAGE SRC ER extemal Data Descriptor connector Orchestration B Execution ing Hub ORACLE OB jebc oracle 610 184 133904521 FAH C
5. EDD is AATB MIT ISSUER MAST For Connector Con Flx Mitigant Master The ADI is Mitigant Master ADI Subtype EDD is MITIGANT MAST For Connector Con Fix Mitigants The ADI is Mitigants ADI Subtype EDD is MITIGANTS For the above connectors refer the file ELCM for FCUBS Column name and the Target Logical Name 35 ORACLE OFS DIH Foundation Pack Extension for FCUBS User Manual 12 Foreign Exchange FX module Foreign exchange or Forex is the conversion of one country s currency into that of another In a free economy a country s currency is valued according to factors of supply and demand In other words a currency s value can be pegged to another country s currency such as the U S dollar or even to a basket of currencies A country s currency value also may be fixed by the country s government However most countries float their currencies freely against those of other countries which keep them in constant fluctuation 12 1 List of FX tables For Connector Con Flx Forward Exch Rates The ADI is ADI Subtype Borrowings EDD is FWD EXCHG RATES For Connector The ADI is Forex Account Transaction ADI Subtype EDD is AATB FOREX TXNS For the above connectors refer the file FX for FCUBS Column name and the Target Logical Name 36 ORACLE 13 13 1 For the above connectors refer the file GL for FCUBS Column name and the Target Logical Name General Ledger
6. Applications Interface for Oracle Flexcube Universal Banking System gt FCUBS Data Mapping gt External Data Descriptor Interface for Oracie Flexcube universal Banking System M p 14 UAM External Data Descriptor sot Date 08082014 4 E FCUBS administration Search EE fBReresn rcues imertace Exiemal Data Store Name 19 Name 4 pata Mapping Sau 2 External Data Descriptor 9s m3 120164 C Jump fo page R Name Desenpiion Etema Data Store Externat Data Store _ Status Last Modified Date Last Modified By Connectors AATB_ACCOUNTING_ENTRIES FCUBS Stage table for Accounting Enties FCUBS STAGE SRC ORACLE DB Saved 07 13 2015 19 02 00 DIHUSER 4 B orcnestraton EX ACCT ADDRESS FCUBS Stage table for Account Address FCUBS_STAGE_SRC ORACLE DB Saved 0712015 190200 DIHUSER Beaten Maintenance ACCI EMAIL ADOR FCUBS Stage table for Account Eman Address FCUBS STAGE SAC Saved 07132015 180200 DIHUSER 2f E AATB ACCT MITIGANT MAP FCUBS Stage table for Account Mingant Map FCUBS STAGE SRC Saved 07132015 190200 DIHUSER T _ FCUBS Stage table for Account Phone FCUDS STAGE SRC ORACLE Saved 07112015 190200 DINUSER SS AKTE STATUS MAST FCUBS Stage table for Account Status Master FCUBS STAGE SRC ORACLE DE Saved 07132015 19 0200 DMUSER M Baten Scheduler AATB_BORROWINGS_TXNS FCUBS Stage table for Customer Account Borrowing
7. Complete the ODI settings using Settings option in DIH Application menu before deploying the interface 2 Selectthe entry which is present and click Edit Low USEngis v OFSAD v ORACLE Financial Services Analytical Applications System Configuration amp identity Management Inbox integration Hub gt Administration gt Settings Settings As of Date 08082014 Settings 5 1 01 Jump to page 7 ODI User a Master Repostory DE User Master DB Driver Master DB Connection Work Repository 7 Project 7 supervisor DIHDEV 001 REPO oracle ibc OracieDnver thin 910 154 13561521 5 DIHREP OFSAA CONNECTORS DRM OFSAA Parameters Data Store lil extemal Data Descriptor 3 The ODI settings screen is displayed Update the setting information correctly before proceeding to the deployment of FCUBS interface connectors Settings Menu Values Required Example ODI User User Name used for Login to ODI SUPERVISOR ODI Password ODI Password for the ODI user to login odipassword Master Repositorty DB Schema User Name created Master Repository DB User for ODI DIHDEV ODI REPO Master Repository DB Password Master Repositorty DB Schema Password dbpassword Master DB Driver Oracle Driver Use the Default oracle jdbc OracleDriver jdbc oracle thin 10 184 135 6 1521 DI Master DB Connection Oracle Database JDBC URL HDB Work Repository Repository used inside ODI DIHREP
8. ELCM MODULE ci rua acia xci arae diaaa 34 iti Listof EEGM Tables e ux bete eee hte eeu uhi 34 12 FOREIGN EXCHANGE FX MODULE 22 eaae aa red accu enar cna 36 Page ii ORACLE OFS DIH Foundation Pack Extension for FCUBS User Manual Ted ISO FA tables rage NE rer e iaaii de 36 13 GENERAL LEDGER GL 2 37 isto GLbtableS inerte e UR 37 14 MONEY MARKET MM MODULE 4 4 4 02 0201 11 2 01 4121 4 44 4 001 1 11001 1114 110 38 14 1 LAST OT MM tables lt ec trei re vav eg teu xen 38 15 TERM DEPOSIT TD MODULE 39 39 Page iii ORACLE OFS DIH Foundation Pack Extension for FCUBS User Manual Preface Audience Following are the intended audience for the FCUBS user guide ETL Developers ETL Developers from the IT Department of the financial services institution who do the data sourcing Business Analysts The business analysts from the IT Department of the financial services institution who do the mapping of the tables Prerequisites Data
9. Integration Hub should be installed OFSAA FCUBS Interface should be installed Oracle Data Integrator environment for executing the interfaces Related Information Sources Along with this user manual you can also refer to the following documents OTN documentation Library e Oracle Financial Services Data Integration Hub User Guide 8 0 1 0 0 e Oracle Financial Services Data Integration Hub Applications Pack Installation Guide Release 8 0 1 0 0 e Oracle Flexcube UBS OFSAA Integration guide Acronyms Acronym Description DIH Data Integration Hub Ul User Interface ODI Oracle Data Integrator ADI Application Data Interface KM Knowledge Module EDD External Data Descriptor Apps Application CASA Current And Savings Account CL Consumer Lending ORACLE OFS DIH Foundation Pack Extension for FCUBS User Manual Acronym Description ELCM Enterprise Limits and Collateral Management FX Foreign Exchange GL General Ledger MM Money Market TD Term Deposit FIS FLEXCUBE Information Server EOFI End of Financial Input ORACLE 1 1 Introduction to FCUBS to OFSAA Interface Overview of DIH Interface Data Integration Hub DIH enables to load the data from the source systems to the OFSAA staging tables through logical interfaces known as Application Data Interfaces ADI DIH provides a set of User Interfaces UI which is used to define and ma
10. Relation ADI Subtype EDD is Customer Country Relation 30 ORACLE OFS DIH Foundation Pack Extension for FCUBS User Manual For Connector Con Flx Cust Details The ADI is Customer Details ADI Subtype EDD is AATB CUST DETAILS For Connector Con Flx Cust Education Master The ADI is Customer Education Master ADI Subtype EDD is AATB CUST EDUCATION For Connector Con Flx Cust Email Address The ADI is Customer Email Address ADI Subtype EDD is CUST EMAIL ADD For Connector Con Flx Cust Emp Type Mast The ADI is Customer Employment Type Master ADI Subtype EDD is CUST EMPLOYMENT For Connector Con Flx Cust Identi Doc The ADI is Customer Identification Document ADI Subtype EDD is CUSTID DOC For Connector Con Fix Cust Master The ADI is Customer Master ADI Subtype EDD is CUST MAST For Connector Con Flx Cust Phone The ADI is Customer Phone ADI Subtype 31 ORACLE OFS DIH Foundation Pack Extension for FCUBS User Manual EDD is AATB CUST PHONE For Connector Con Flx Cust Relationships The ADI is Customer Relationships ADI Subtype EDD is CUST RLTNSP For Connector Con Flx Cust To Cust Rel The ADI is Customer To Customer Relationships ADI Subtype EDD is 05 CUST RLTN For Connector Con Flx Cust Type Master The ADI is Customer Type Master ADI Subtype EDD is CU
11. S After the deployment is complete the Deployment Successful message is displayed ORACLE Financial Services Analytical Applications le Applications Object Administration System Configuration amp Identity Management Inbox Select Applications Interface for Oracle Flexcube Universal Banking System gt FCUBS Administration gt Refresh FCUBS Interface Interface for Oracle Flexcube Universal Banking System v OFSAA FCUBS Interface Refresh 4 18 interface for Oracle Flexcube Universal Banking System Source Application Details 4 B FCUBS Administration Source Applicaton Name Oracle Flexcube Universal Banking System Refresh FCUBS Interface Source Applicaton Version 2030 e 4 Data Mapping 18 External Data Descriptor Selected Version _Undepioy B Connectors 4 Orchestration Batch Maintenance 4 EB Execution Batch Execution 8 Information 12501 Webpage Dialog Tb Batch Scheduler z 5 ERB Batch Monitor 6 Navigate to External Data Descriptor and Connectors under FCUBS Data Mapping for checking the deployed EDDs Connectors and the Mappings 22 ORACLE OFS DIH Foundation Pack Extension for FCUBS User Manual US Engksh OFSAD ORACLE Financial Services Analytical Applications Applications Object Administration System Configuration amp identity Management inbox Select
12. TXNS For the above connector refer the file TD for FCUBS Column name and the Target Logical Name 39 ORACLE OFS DIH Foundation Pack Extension for FCUBS User Manual Oracle Financial Services Data Integration Hub Foundation Pack Extension for Oracle Flexcube Universal Banking Interface User Manual Release 8 0 1 0 0 Oracle Corporation World Headquarters 500 Oracle Parkway Redwood Shores CA 94065 U S A Worldwide Inquiries Phone 1 650 506 7000 Fax 1 650 506 7200 www oracle com financial_services Copyright 2015 Oracle Financial Services Software Limited All rights reserved No part of this work may be reproduced stored in a retrieval system adopted or transmitted in any form or by any means electronic mechanical photographic graphic optic recording or otherwise translated in any language or computer language without the prior written permission of Oracle Financial Services Software Limited Due care has been taken to make this User Manual and accompanying software package as accurate as possible However Oracle Financial Services Software Limited makes no representation or warranties with respect to the contents hereof and shall not be responsible for any loss or damage caused to the user by the direct or indirect use of this User Manual and the accompanying Software System Furthermore Oracle Financial Services Software Limited reserves the right to alter modify or otherwise change in any manner t
13. the attached sheet FCUBS OFSAA Data Transfer Details xls The file FCUBS OFSAA data transfer details has the following details e Source System e Target System e Data Transferred e Source System Module e FCUBS Staging Table Name e Extraction Package Name e Target System Table Name e Extraction Routine e Data Included in the Extraction 1 6 List of Flexcube modules The modules used in Flexcube are as follows e CASA e CL CORE e e FX e GL e MM e TD 10 ORACLE OFS DIH Foundation Pack Extension for FCUBS User Manual 2 Flexcube OFSAA Interface Architecture In this data flow environment diagram the data is extracted from FCUBS to the FCUBS landing zone This data with the help of DIH Connectors is loaded to DIH ADI which in turn is mapped to the OFSAA Staging table Flexcube DIH ADI Customer Account FCUBS Landing OFSAA Staging STG LOAN m Lad Lx Lt a ct r 11 ORACLE OFS DIH Foundation Pack Extension for FCUBS User Manual 3 Mapping the OFSAA User to FCUBS User Groups User group mapping enables you to map user s to specific user group which in turn is mapped to a specific Information Domain and role Every User Group mapped to the infodom should be authorized Else it cannot be mapped to users User Group Map screen displays fields such as User ID Name and the corresponding Mapped Groups You can view and modify the existing mappings wit
14. to Undeploy All is displayed Click Yes to proceed ORACLE Financial Services Analytical Applications Applications Object Administration System Configuration amp Identity Management Inbox Select Applications Interface for Oracle Flexcube Universal Banking System v Interface for Oracle Flexcube Universal Banking System gt FCUBS Administration gt Refresh FCUBS Interface OFSAA FCUBS Interface Refresh 4 18 Interface for Oracle Flexcube Universal Banking System Source Application Details 4 E FCUBS Administration Source Applicaton Name Oracle Flexcube Universal Banking System Refresh FCUBS Interface Source Applicaton Version zi loy Selected Version 4 Data Mapping B EB External Data Descriptor Deploy Selected Version ER Connectors 4 orchestration J Batch Maintenance 4 8 Execution Batch Execution Batch Scheduler Batch Monitor V view Log Are you sure you want to Undeploy tg 3 After the undeployment is complete the Successfully Deployed All message is displayed ORACLE Financial Services Analytical Applications Applications Object Administration System Configuration amp Identity Management Inbox Select Applications Interface for Oracle Flexcube Universal Banking System FCUBS Administration Refresh FCUBS Interface Interface for Oracle Flexcube Universal Banking System b OFSAA FCUBS Inte
15. 7130015 190200 DIHUSER Connector to load Customer Account Borrowings ASTB_MM_BORROWINGS FCUBS_STAGE_SRC 07 13 2015 190200 Connector to in Transacton B AATB_BORROWINGS Con Cust Connector to load Customer Account Current and S FCUBS STAGE SRC Saved 07 13 2015 19 0200 Con Fix Cust Acci Tan Connector to load Customer Account Transaction Ci AATB CASA TXNS FCUBS STAGE SRC Saved 071130015 190200 IF Con Fk FX Connector to load Customer Account FX Contacts AATB FX CONTRACTS FCUBS STAGE SRC Saved 07 13 2015 18 02 00 FCUBS Connectors 23 ORACLE 7 7 1 7 2 Undeploying OFSAA FCUBS Connectors Using Refresh FCUBS Interface Menu You can use the Undeploy All button to undeploy the connectors Use the undeploying feature in the following scenarios Deploying Upgraded Source Version If there is an upgraded source application FCUBS available you can undeploy the existing version of the connector and redeploy the same by selecting the available upgraded source version The current available source version for FCUBS connector supports FCUBS version 12 0 3 0 Note You can deploy only one source version at a time You need to upgrade the source undeploy the version and deploy the required version Changes in ODI External Data Store Settings If there is a change in the ODI External
16. Borrowings EDD is AATB MM BORROWINGS For Connector Con Flx Cust Acct Borr Txns The ADI is Customer Account Transaction ADI Subtype Borrowings Transaction EDD is BORROWINGS TXNS For Connector Con Flx Cust Acct MM The ADI is Customer Account ADI Subtype Money Market Contracts EDD is AATB MM CONTRACTS For Connector Con Flx Cust Acct MM Txns The ADI is Customer Account Transaction ADI Subtype Money Market Transactions EDD is AATB MM CONTRACTS TXNS For Connector Con Dealer Master The ADI is Dealer Master ADI Subtype EDD is AATB DEALER MAST For the above connectors refer the file MM for FCUBS Column name and the Target Logical Name 38 ORACLE OFS DIH Foundation Pack Extension for FCUBS User Manual 15 Term Deposit TD Module Term Deposit is a deposit held at a financial institution that has a fixed term These are generally short term with maturities ranging anywhere from a month to a few years When a term deposit is purchased the lender the customer understands that the money can only be withdrawn after the term has ended or by giving a predetermined number of days notice 15 1 List of TD tables For Connector Con Flx Cust Acct TD The ADI is Customer Account ADI Subtype Term Deposit EDD is AATB TD CONTRACTS For Connector Con Flx Cust Acct TD Txn The ADI is Customer Account Transaction ADI Subtype Term Deposits Transactions EDD is TERMDEPOSITS
17. CUST CLSFCTN FCUES Stage lable for Customer Classification Mas FCUBS_STAGE_SRC ORACLE DB 07132015 190200 DIHUSER AATB CUST COUNTRY FCUBS Stage table for Customer Country Relator FCUBS STAGE ORACLE DB 0732015 190200 DIMUSER FCUBS External Data Descriptor US Englsh OFSAD ORACLE Financial Services Analytical Applications Applications Object Administration System Configuration 8 Identity Management Inbox Select Applications Interface for Oracle Fiexcube Un versai Banking System gt FCUBS Data Mapping gt Connectors Interface tor Orscie Flexcube Universal Banking System 4 RB interface tor Oracle Flexcube Universa Banking System Sica bi OR 4 B rcues Administration B Retes FCUBS 4 pata mapping UE E Connector ia 1 20162 i au de li Externa Data Descriptor TLEN D Jump to page Name EDD merna Data Store Name Stas Last Date Lest Modified By connectors Fix Accounting Entries Connector to load Accounting Entries AATB_ACCOUNTING ENTRIES FCUBS_STAGE_SRC 07 13 2015 19 0200 DIHUSER 4 orcnestraton Con Fix Account Address Connector to load Account Address ARTB ACCT ADDRESS FCUBS STAGE SRC 077132015 190200 DINUSER Con Fic Account Emad Address Connector to Account Eman Address AATE ACCT EMAIL ADOR FCUBS STAGE SRC 07120018 188200
18. DIMUSER A B execution 17 Account Mgant Map Connector to load Account Mibgant Map AATE ACT MITIGANT FCUBS STAGE SRC 0730015100200 DIMUSER Connector lo load Account Phone 07 Riesen Execution Connector to lead Account Status Maser ean Scheduler Connector fo Branch Master AATB_BRANCH MAST FCUBS STAGE SRC 07 13 2015 190200 DIHUSER Baten Montor fF Con_Fi_Branch_Transacions Connector to toad Branch Transactions SRC BRANCH TXNS FCUBS STAGE SRC 0713445 199200 DIHUSER View Log Con Fix Collaterais Connector to load Collaterals STAGE COLLATERALS FCUBS STAGE SRC 07 13 2015 19 02 00 DIHUSER fF Con Fix Colaterai Master Connector to toad Colateral Master ARTB COLLATERAL MAST FCUBS STAGE SRC 07132015 180200 DIMUSER Con Fix Contact Master Connector to toad Contact Master AATB_CONTACT_MAST FCUBS STAGE SRC Saved 07 13 2015 19 0200 DIHUSER Con Fix Country Master Connector to load Country Master AATB COUNTRY 5 FCUBS STAGE SRC Saved 07 13 2015 190200 DIHUSER Con Fix Cr Facility Detats Connector to load Credit Facility Detalis CR LINE DETAILS FCUBS STAGE SRC Saved 077132015 190200 DIHUSER Con Cr Facility Master Connector to load Credit Facility Master CR LINE 5 FCUBS STAGE SRC Saved 07 13 2015 190200 DIMUSER Con Fk Cr Type Mast Connector to load Credit Facility Type Master CR LINE TYPE MAST FCUBS STAGE Saved 0
19. Data Store settings then you can undeploy the connectors Modify the settings and redeploy to obtain the latest connector settings Note You cannot undeploy the connectors if any of the Connector External Data Descriptor is in published mode Unpublish all the Connector External Data Descriptor before proceeding with undeployment Follow the below steps to undeploy 1 Click Undeploy All to undeploy the Connector version ORACLE Financial Services Analytical Applications Applications Object Administration System Configuration amp Identity Management Inbox Select Applications Interface for Oracle Flexcube Universal Banking System gt FCUBS Administration gt Refresh FCUBS Interface Interface for Oracle Flexcube Universal Banking System Y OFSAA FCUBS Interface Refresh 4 I interface for Oracle Flexcube Universal Banking System Source Application Details 4 8 FCUBS Administration Source Applicaton Name Oracle Flexcube Universal Banking System B Refresh FCUBS Interface Source Applicaton Version 4 ll cues Data Mapping EB External Data Descriptor Deploy Selected Version Undeploy All Ba Connectors 4 B orchestration J Batch Maintenance 4 8 Execution T Execution Ib Batch Scheduler Batch Monitor V view Log 24 OFS DIH Foundation Pack Extension for FCUBS User Manual ORACLC OFS DIH Foundation Pack Extension for FCUBS User Manual 2 Amessage Are you sure you want
20. FCUBS STAGE ORACLE DB Saved 07122015 190200 DIHUSER Baten Monitor AKT BRANCH MAST FCUBS Stage table for Branch Master FCUBS STAGE SRC ORACLE Saved 077122015 190200 DMUSER M vevios AKTE FCUBS Stage table for Customer Account Curent FCUES STAGE SRC ORACLE 073 2015 990202 DHUSER EJ AATB CASA TXNS FCUBS Stage table for Customer Account Cument andj FCUBS STAGE SRC ORACLE DB 077132015 190200 DIHUSER AATB COLLATERAL MAST FOUBS Stage table for Collateral Master FGUBS_STAGE_SRC ORACLE DB 07 13 2015 19 0200 DIHUSER E AATB CONTACT MAST FCUBS Stage table for Contact Master FCUES STAGE SRC ORACLE DE 07 13 2015 190200 DIHUSER E aars country mast FCUBS Stage table for Country Master FCUBS STAGE SRC ORACLE DE 07132015 190200 DIHUSER LINE DETAILS FCUBS Stage table for Credit Dotais 85 STAGE SRC ORACLE 077132015 190200 DIMUS E une MAST FCUES Stage table for Credit Facikty Master FCUBS STAGE SRC ORACLE 07 13 2015 190200 DIHUSER E ER UNE TYPE MAST FCUBS Stage ale for Cre Type Masieri FUBS STAGE SAC ORACLE F7 AATB CUSTID DOC FGUBS Stage table for Customer identificaton Doc FCUBS_STAGE_SRC ORACLE DB 971132015 190200 DIMUSER CUST ADDRESS FCUES Stage table for Customer Address FCUBS STAGE SRC ORACLE DE 071302015 190200 DIMUSER
21. GL Module List of GL tables For Connector Con Flx Accounting Entries The ADI is Accounting Entries ADI Subtype EDD is AATB ACCOUNTING ENTRIES For Connector Con Flx General Ledger Data The ADI is General Ledger Data ADI Subtype EDD is AATB GL DATA For Connector Con Flx General Ledger Master The ADI is General Ledger Master ADI Subtype EDD is AATB GL MASTER For Connector Con Flx GL Book Master The ADI is GL Book Master ADI Subtype EDD is AATB GL BOOK MAST For Connector The ADI is Interbank Transactions ADI Subtype EDD is INTERBANK TXNS OFS DIH Foundation Pack Extension for FCUBS User Manual A general ledger is a complete record of financial transactions over the life of a company The ledger holds account information that is needed to prepare financial statements and includes accounts for assets liabilities owners equity revenues and expenses 37 ORACLE OFS DIH Foundation Pack Extension for FCUBS User Manual 14 14 1 Money Market MM Module MM is a segment of the financial market in which financial instruments with high liquidity and very short maturities are traded Money market securities consist of negotiable certificates of deposit banker s acceptances U S Treasury bills commercial paper municipal notes federal funds and repurchase agreements List of MM tables For Connector Con Flx Cust Acct The ADI is Customer Account ADI Subtype
22. Interface 4 Eh Data Mapping Parameters IB Extena Data Store External Data Descriptor connector gt OB orchestration Berecution 7 Navigate to DIH Application select Administration menu and click Refresh Target Datastores This will refresh all the available target data stores 19 ORACLE OFS DIH Foundation Pack Extension for FCUBS User Manual ORACLE Financial Services Analytical Applications Applications Object Administrebon System Configuration 8 Identity Management Inbox irn cilc ind Dota integration Hub gt gt Refresh Financial Services Data integration Hub B e 4 E integration Hub Rete 4 B Administration senos Retresh ADI Retresh Target Datastores 4 Refresh AD Retesh Target Datastores I Retresh ADI 102 Retresh Target Datastores Connectors 185 Application Data Interface 4 Bh Data Mapping H Parameters bremal Data Store Data Rh connector orcnestration 20 ORACLC OFS DIH Foundation Pack Extension for FCUBS User Manual 6 Deploying OFSAA FCUBS Connectors Using Refresh FCUBS Interface Menu After the pre requisites are complete you can deploy the FCUBS connectors that map the multiple file EDD s to the corresponding ADI s by using Refresh FCUBS Interface menu This creates the corresponding External Data Descriptor and Connectors inside Data Mapping Menu of the FCUBS Interface 1 Navi
23. Oracle Financial Services Data Integration Hub Foundation Pack Extension for Oracle Flexcube Universal Banking Interface User Manual 8 0 1 0 0 ORACLE FINANCIAL SERVICES Page i ORACLE OFS DIH Foundation Pack Extension for FCUBS User Manual TABLE OF CONTENTS RRS C 4 IN dlienee dub e ad e b 4 Prereguisiles s 4 Related Information SOUNCES corr E orn ce EO HER TAPER eae Geers 4 PACHOMYNMS aves cacti CETTE TTD ODD LTD DETTO LLL 4 1 INTRODUCTION TO FCUBS TO OFSAA INTERFACE en 6 1 1 Overview of DIH Interface 6 1 2 Data 7 1 3 Integration Scope in Oracle FLEXCUBE Universal Banking System 7 1 4 Extraction process for tables of Flexcube module eese 8 1 5 Data Transfer from FCUBS to 9 1 6 Listof Flexcube modul68 25 itio 9 2 FLEXCUBE OFSAA INTERFACE ARCHITECTURE
24. ST TYPE For Connector Con Flx Exchange Rates The ADI is Exchange Rates ADI Subtype EDD is XCHNGE RATE HIST For Connector Con Flx Financial Year Master The ADI is Financial Year Master ADI Subtype EDD is FINYEAR MAST For Connector Con Flx Geography Master The ADI is Geography Master ADI Subtype EDD is AATB GEOGRAPHY MAST For Connector Con Flx Marital Status Master 32 ORACLE OFS DIH Foundation Pack Extension for FCUBS User Manual The ADI is Marital Status Master ADI Subtype EDD is AATB MARITAL STAT For Connector Con Flx Prod Category Master The ADI is Product Category Master ADI Subtype EDD is PROD MAST For Connector Con Flx Prod Master The ADI is Product Master ADI Subtype EDD is AATB PRODUCT MAST For Connector Con Flx Prod Type Master The ADI is Product Type Master ADI Subtype EDD is AATB PRODTYPE MAST For Connector Con Fix Transaction Master The ADI is Transaction Master ADI Subtype EDD is TXN MASTER For the above connectors refer the file CORE for FCUBS Column name and the Target Logical Name 33 ORACLE OFS DIH Foundation Pack Extension for FCUBS User Manual 11 Enterprise Limits and Collateral Management ELCM Module Financial institutions face multiple challenges while assessing their exposure levels to customers entities or industry sectors Moreover the usage of multiple prod
25. e management using the available customer data This integration is achieved by handing off FCUBS core banking data with OFSAA through FLEXCUBE Information Server FIS and DIH OFS DIH Foundation Pack Extension for FCUBS User Manual ORACLE 1 2 1 3 Data flow OFS DIH Foundation Pack Extension for FCUBS User Manual FCUBS Landing Area Staging Area Processing Area Result Area Finance Results Store The procedures are packaged within FCUBS which populates data from various tables in FCUBS to several landing area tables after execution Essentially a 1 1 mapping is done between the landing area table EDD and OFSAA staging area table ADI Most of the calculations and transformations are done within these extraction routines The DIH connector pulls data from the landing tables and populates the same in the staging area tables Integration Scope in Oracle FLEXCUBE Universal Banking System The following integration activities take place in Oracle FLEXCUBE Universal Banking System Module Core Entities Hand off Details Customer address phone numbers and email IDs Customer education and employment details Customer marital status Customer relationship details Details of organizations that are the customers Exchange rate information Details of all geographical locations and transaction channels of the bank Details of the loan product category and list of all products
26. ents to extract data and stores the data in the staging tables of FCUBS During End of Financial Input EOFI batch the module wise data in FIS are extracted to staging tables in FCUBS FCUBS provides a control table to indicate successful data extraction OFSAA pulls the data from the tables in FCUBS using the DIH connector If source and target systems are in the same database then data from source staging table are transformed and loaded to fact and dimension tables in target system using synonyms If the source and target systems are in different database then data from source staging table are loaded to target staging table using ORACLE OFS DIH Foundation Pack Extension for FCUBS User Manual transportable table spaces The transfer or extraction of data from FCUBS to OFSAA differs based on the staging tables as follows Master table Incremental data between two extraction dates are transferred Maintenances and contract tables Entire transaction data are transferred in each extraction Transaction table Data related to the transactions created on the extraction date transferred 1 5 Data Transfer from FCUBS to OFSAA The core banking data in Oracle FCUBS are transferred to OFSAA using FIS The data in FCUBS staging tables are mapped to FIS staging table During end of day the core banking data are sent to FIS OFSAA then picks the data from FIS through DIH For details on data transfer from FCUBS to OFSAA refer to
27. gate to the FCUBS application interface 2 Select Administration and click Refresh FCUBS Interface ORACLE Financial Services Analytical Applications Applications Object Administration System Configuration amp Identity Management Inbox Select Applications interface for Oracie Flexcube Universa Banking System gt FCUBS Administration Interface for Oracle Flexcube Universal Banking System M 4 FCUBS Administration 4 BW intertace for Oracle Flexcube Universal Banking System FCUBS Administration 4 Administration fl retresn FCUBS Interface B Refresh FCUBS Interface 4 Data Mapping Depioy Undepiey FCUBS Imertace ER Extomal Data Descriptor Ie connectors 4 m Orchestration Batch Maintenance 4 B Execution Batch Execution UP patch Scheduter Batch Mondor LS View Log 3 Selectthe Source App Version FCUBS Version 12 0 3 0 from the drop down menu 4 Click Deploy Selected Version ORACLE Financial Services Analytical Applications Applications Object Administration System Configuration amp Identity Management Inbox Select Applications Interface for Oracle Flexcube Universal Banking System gt FCUBS Administration gt Refresh FCUBS Interface Interface for Oracle Flexcube Universal Banking System v OFSAA FCUBS Interface Refresh 4 18 Interface for Oracle Flexcube Universal Banking System Source Application Details 4 FCUBS Administration Source Applicaton Name Oracle Flexc
28. he content hereof without obligation of Oracle Financial Services Software Limited to notify any person of such revision or changes All company and product names are trademarks of the respective companies with which they are associated 40
29. hin the User Group Maintenance screen To access User Group Mapping navigate to and click Identity Management section For details on mapping user to user groups refer to OFSAAI User Guide in OTN documentation library Seeded User Groups for OFSAA FCUBS Interface Name Description User mapped to this group will have access to all the menu items for entire FCUBS Application FCUBS Admin The exclusive menu s which are available only to this group users are FCUBS Administration FCUBS Data Mapping User mapped to this group will have access to FCUBS Data Mapping Menu FCUBS Operator User mapped to this group will have access to Orchestration and Execution Menu ORACLE Financial Services Analytical Applications System Configuration amp identity Management 4 Financial Services Analytical Applications Infrastructure Adminstration ud Configuration qm up ction eat pesca Configure Maintain the OFSAA seh Workflow amp Process Orchestration Worktow and Process Orchestration Identity Management 12 ORACLE OFS DIH Foundation Pack Extension for FCUBS User Manual Financial Services Analytical Applications ORACLE Security Management EH User Administrator User User Group Map User Maintenance User User Group E User Group Maintenance User User Group Map 31 User Group Domain E User Group Role User D Name J Map User Group Folder Role amp User Re
30. instate User User Group Map System Administrator Search and Filter RB 1 747 4 User ID Name ce Ka erue F GUEST Guest Login User Activity Report j OFSAD OFSAD F User Profile Report jm Enable User OFSAN OFSAN E OFSOP OFSOP SYSADMN System Administrator SYSAUTH System Authorizer gt OFSAD Mapped Groups User User Group Mapping Screen Windows Internet Explorer User User Group User User Group Map gt User User Group _ Search User Groups Members DIH Admin DIH Data Mapping DIH Execution DRM Admin DRM Analyst DRM Operator FAH Admin FAH Analyst FAH Operator FCUBS Admin FCUBS Analyst FCUBS Operator FSDF Admin FSDF Analyst javascriptfn hier brow 13 ORACLE OFS DIH Foundation Pack Extension for FCUBS User Manual User User Group Mapping Screen Windows Internet Explorer User User Group Map User User Group Map gt User User Group Map gt Search User Groups Members Selected Members DIH Admin FCUBS Admin DIH Data Mapping DIH Execution DRM Analyst DRM Operator FAH Analyst FAH Operator FCUBS Analyst FCUBS Operator FSDF Admin FSDF Analyst FSDF Data Modeler FSDF Operator OBP Admin javascript addSelectedValue
31. intain External Data Descriptors EDD Application Data Interfaces and also map the EDDs and ADIs through Connectors The mappings can be one to one one to many and many to many The source systems that supply data include the core banking systems rating systems modeling systems and so on In the absence of DIH the data from the source systems are extracted transformed and loaded ETL process to the physical tables in Oracle Data Integrator ODI With DIH the ETL activity is not replaced but DIH serves as an abstract logical layer to the physical tables in Oracle Data Integrator ODI Oracle Financial Services Analytical applications OFSAA enables financial institutions to measure and meet risk adjusted performance objectives cultivate a risk management culture lower the costs of compliance and regulation and improve customer insight Oracle FLEXCUBE Universal Banking FCUBS supports the changing landscape of retail corporate and investment banking needs with strong transaction banking and Islamic banking capabilities The current FCUBS OFSAA interfaces transfers all key data elements across various modules within FCUBS to OFSAA Common Staging Area CSA The integration between the Oracle FCUBS and the OFSAA enables the financial institutions to get insight to customer patterns based on the data captured in core banking achieve end to end improvement in business delivery achieve effective performance and risk fre
32. ion ADI Subtype Over Draft Accounts Transactions EDD is AATB OD ACCTS TXNS For Connector Con Flx Account Address The ADI is Account Address 26 ORACLE OFS DIH Foundation Pack Extension for FCUBS User Manual EDD is AATB ACCT ADDRESS For Connector Con Flx Account Email Address The ADI is Account Email Address EDD is AATB STG ACCOUNT EMAIL ADDR For Connector Con Flx Account Phone The ADI is Account Phone EDD is ACCT PHONE For Connector Con Flx Account Status Master The ADI is Account Status Master EDD is AATB ACCT STATUS 5 For the above connectors refer the file CASA for FCUBS Column name and the Target Logical Name 27 ORACLE OFS DIH Foundation Pack Extension for FCUBS User Manual 9 1 Consumer Lending CL Module Consumer Lending is an amount of money lent to an individual usually on a non secured basis for personal purpose Consumer loans are monitored by government regulatory agencies for their compliance with consumer protection regulations such as the Truth in Lending Act List of CL tables For Connector Con Flx Cust Acct Loan The ADI is Customer Account ADI Subtype Loan Contracts EDD is AATB LOAN CONTRACTS For Connector Con Flx Cust Acct Loan Txn The ADI is Customer Account Transaction ADI Subtype Loan Contracts Transactions EDD is AATB LOAN CONTRACT TXNS For Connector Con Flx Payment Schedule The ADI is Payment Schedule ADI Subtype EDD i
33. onnection ORACLE D8 gocoracie tin Q0 184 13390 1521 FCUBS ORACLE DE jdbc orache Min 10 124 133 90 1521 5 Provide the details of FCUBS schema user name and password where you have the Landing Tables of FCUBS Application Refer to DIH User manual for more details on External Data Store settings 18 ORACLE OFS DIH Foundation Pack Extension for FCUBS User Manual gt External Data Store gt External Data Store Edit Mode gt External Data Store Name Stage Source for Fiexcube Universal Banking Description Type ORACLE URL piocoracie thn 310 184 133 90 1521 FCUBS User FCUBS SCHEMA Pasa word t Test Connection 6 Navigate to DIH Application select Administration menu and Click Refresh ADI Menu This will refresh all the Application Data Interfaces and creates the Application Data Interfaces for all the staging tables present in the model which is being uploaded in the same Infodom Xov USEngish OFSAD ORACLE Financial Services Analytical Applications Applications Object Adminstration Configuration amp identity Management inbox Select Applica Data integration Hub gt Administration gt Refresh Francal ata Integration Hub Refresh 4 n Data integration Hub 4 Administration Bow serere Datastores mm Refresh ADI Retesh Target Datastores JE getresh aot Brrerean Datastores gt EJ Pusistvunpubish Connectors ER Application Data
34. r Manual ORACLE Financial Services Analytical Applications Applications Object Administration System Configuration amp identity Management inbox Select Applications interface for Oracie Flexcube Universal Banking System Interface tor Oracle Flexcube Universal Banking System Connectors f r OFSAA Ovade Flexcisbe Universal Banking System 4 B intertace tor Oracle Flexcube Universal Banking System 4 Administraton p E Fcuns Administration b FCURS Data Mapping ER Retesh FCUBS Interface FCUBS Administration FCUBS Data Mapping Detars mapping Data Descriptor BA Connectors 4 fh orchestration Ri catch Maintenance 4 B Batch Execution Wt osten seneauier W vew Log Orchestration Fxecution Orchectrahion Execution 16 ORACLE OFS DIH Foundation Pack Extension for FCUBS User Manual 5 Prerequisites for Deploying OFSAA FCUBS Connectors The deployment process requires the below actions to be performed as prerequisites Ensure that these requirements are met before starting the deployment using Refresh FCUBS interface menu e The user must be mapped to the user group FCUBS Admin in order to get the Refresh FCUBS Interface menu e The user should have mapped to DIH Admin and DIH Data Mapping user groups to configure the Oracle Data Integrator ODI settings and External Data Store respectively Follow the below steps 1
35. rface Refresh 4 Interface for Oracle Flexcube Universal Banking System Source Application Details 4 FCUBS Administration Source Applicaton Name Oracie Flexcube Universal Banking System 8 Refresh FCUBS Interface source Appicaton version El 4 f FCUBS Data Mapping S EB External Data Descriptor Deploy Selected Version 8 Connectors 4 TE orchestration Batch Maintenance 4 EB Execution Batch Execution E Information 12511 Webpage Dialog Tb Batch Scheduler 18 Batch Monitor View Log 25 ORACLE 8 CASA Module OFS DIH Foundation Pack Extension for FCUBS User Manual Currents and Savings Account CASA is an attempt to combine savings and checking accounts to entice customers to keep their money in the banks It is more prominent in Middle and 8 1 Southeast Asia List of CASA tables For Connector Con Flx Cust Acct Casa The ADI is Customer Account ADI Subtype CASA Contracts EDD is CASA For Connector Con Flx Cust Acct OD The ADI is Customer Account ADI Subtype OD Accounts EDD is AATB OD ACCTS For Connector Con Branch Transactions The ADI is Branch Transactions ADI Subtype EDD is SRC BRANCH TXNS For Connector Con Flx Cust Acct Casa Txn The ADI is Customer Account Transaction ADI Subtype CASA Transaction EDD is AATB CASA TXNS For Connector Con Flx Cust Acct OD Txn The ADI is Customer Account Transact
36. s PAYMENT SCHEDULE For Connector Con Flx Account Address The ADI is Account Address ADI Subtype EDD is ACCT ADDRESS For Connector Con Flx Account Email Address The ADI is Account Email Address ADI Subtype EDD is AATB STG ACCOUNT EMAIL ADDR For Connector Con Flx Account Phone The ADI is Account Phone 28 ORACLE OFS DIH Foundation Pack Extension for FCUBS User Manual ADI Subtype EDD is AATB ACCT PHONE For Connector Con Flx Account Status Master The ADI is Account Status Master ADI Subtype EDD is AATB ACCT STATUS MAST For the above connector refer the file CL for FCUBS Column name and the Target Logical Name 29 ORACLE OFS DIH Foundation Pack Extension for FCUBS User Manual 10 CORE Module 10 1 List of CORE tables For Connector Con Flx Branch Master The ADI is Branch Master ADI Subtype EDD is AATB BRANCH MAST For Connector Con Flx Contact Master The ADI is Contact Master ADI Subtype EDD is CONTACT MAST For Connector Con Flx Country Master The ADI is Country Master ADI Subtype EDD is AATB COUNTRY MAST For Connector Con Flx Cust Address The ADI is Customer Address ADI Subtype EDD is CUST ADDRESS For Connector Con Flx Cust Class Mast The ADI is Customer Classification Master ADI Subtype EDD is CUST CLSFCTN For Connector Con Flx Cust Country Relation The ADI is Customer Country
37. ube Universal Banking System 85 Refresh FCUBS Interface Source Applicaton Version 4 Data Mapping B Extemal Data Descriptor BA Connectors 4 TE Orchestration Deploy Selected version W Batch Maintenance 4 Execution Batch Execution 8 Batch Scheduler 18 Batch Monitor View Log 5 A message Are you sure you want to Deploy the Selected Version is displayed Click Yes to proceed ORACLE OFS DIH Foundation Pack Extension for FCUBS User Manual ORACLE Financial Services Analytical Applications Applications Object Administration System Configuration amp Identity Management Inbox Select Applications Interface for Oracle Flexcube Universal Banking System FCUBS Administration Refresh FCUBS Interface Interface for Oracle Flexcube Universal Banking System OFSAA FCUBS Interface Refresh 4 18 interface for Oracle Flexcube Universal Banking System Source Application Details 4 B FCUBS Administration Source Applicaton Name Oracle Flexcube Universal Banking System Refresh FCUBS Interface Source Applicaton Version 12030 Iz 4 FCUBS Data Mapping Iib External Data Descriptor Deploy Selected Version Undeploy An Ba connectors 4 Orchestration Batch Maintenance 4 Execution T Batch Execution 5 Warning 12521 Webpage Dialog fb Batch Scheduler Batch Monitor view Log Are you sure you want to Deploy the Selected Version
38. uct processors to manage lines of businesses prevents financial institutions from gaining a consolidated view of their exposure Oracle FLEXCUBE ELOM integrates with the existing IT application landscape and offers you a single source for managing online real time exposure across the enterprise Its process centric architecture enables centralized collateral management enterprise wide limits definition and tracking for effective exposure management as well as resource utilization List of ELCM tables For Connector Con Flx Account Mitigant The ADI is Account Mitigant Map ADI Subtype EDD is For Connector Con Collateral Master The ADI is Collateral Master ADI Subtype EDD is COLLATERAL MAST For Connector Con Fix Collaterals The ADI is Collaterals ADI Subtype EDD is AATB STAGE COLLATERAL For Connector Con Flx Cr Facility Details The ADI is Credit Facility Details ADI Subtype EDD is AATB CR LINE DETAILS For Connector Con Flx Cr Facility Master The ADI is Credit Facility Master ADI Subtype 34 ORACLE OFS DIH Foundation Pack Extension for FCUBS User Manual EDD is AATB CR LINE MAST For Connector Con Flx Cr Facility Type Mast The ADI is Credit Facility Type Master ADI Subtype EDD is AATB CR LINE TYPE MAST For Connector Con Mitigant Issuer Master The ADI is Mitigant Issuer Master ADI Subtype
Download Pdf Manuals
Related Search