Oracle FLEXCUBE Investor Servicing
Contents
1. Synchrono Source Target Action Communicat Host View us System System ion Channel Name Asynchron ous FCDB FCIS Query DB Query IS_DIVIDENDDE Synchro TAILS nous 2 8 ORACLE 3 1 3 2 This chapter contains the following sections Section 3 1 Data Exchange between FCDB and FCIS Section 3 2 Gateway Service Data Exchange between FCDB and FCIS 3 Annexure For details on data exchange between FCDB and FCIS refer to the excel sheet Data_Exchange_Details xlsx This sheet has the following details Source system Pricing module Functional module Transaction group Transaction name Transaction description Target system Target system module Action Source communication Target communication Service name Operation code Queue name Host view name FCDB view name Reconciliation Remarks Response required Reconciliation file name Synchronous asynchronous Format XSD available Gateway XSD name Gateway Service For details on gateway services that are part of the integration between FCDB and FCIS refer to the respective Gateway service documents ORACLE2. e Section 2 1 1 Integration Scope in Oracle FLEXCUBE Direct Banking System e Section 2 1 2 Integration Scope in Oracle FLEXCUBE Investor Servicing System Integration Scope in Oracle FLEXCUBE Direct Banking System This integration enables Oracle FLEXCUBE Direct Banking user customer to perform the following activities e Transactions Buy mutual funds Redeem mutual funds Switch mutual funds e Enquiries Portfolio Order status Fund activity Dividend information e FCDB fetches the following information from FCIS database Unit holders for CIF AMC Funds under specific AMC Fund information Portfolio for unit holder Fund information for portfolio Transactions with transaction reference number Transaction based on status Funds for unit holders ORACLE Dividend AMC details Dividend details AMCs for specific fund Available funds for switch funds within same AMC CIF details Integration Scope in Oracle FLEXCUBE Investor Servicing System The following activities take place in Oracle FLEXCUBE Investor Servicing e Validate and process purchase redemption and switch orders for mutual funds received from FCDB system e Send the transaction status to FCDB after completing the transactions initiated based on the order received e Customer may place multiple orders from the same transaction screen in FCDB However each transaction in a
3. Synchro Source Target Service Operation nous System System Acuan eanan Name Code Asynchr y y Channel y onous FCDB FCIS Creation JMS FCISSub Create Asynchro scription Subscrip nous tion FCDB FCIS Creation JMS FCISStandin Create Asynchro SIP glnstruction Standin nous glnstructio n FCDB FCIS List Unit DB Query IS_MSTUS Synchro Holders ERPORT nous for CIF FOLIO FCDB FCIS List of DB Query Synchro AMC nous FCDB FCIS Funds DB Query Synchro under nous AMC Redeem Mutual Fund The customer can view the mutual funds available to him her for redemption in FCDB screen When the customer places an order for redemption of a fund Oracle FCDB places the details in the respective queue which is picked up and processed by FCIS system After processing the order FCIS places a success failure message in the respective queue which is picked up by FCDB system and displayed to the customer 28 ORACLE 2 4 4 2 4 5 Data Exchange Communi Service synochro Source Target Acti Operation nous ction cation Host View System System Ch Code Asynchro annel Name nous FCDB FCIS Redemp JMS FCISRedemp CreateRe Asynchro tion Cre tion demption nous ation FCDB FCIS List unit DB Query IS _MSTUS Synchro holders ERPORTFO nous for CIF LIO FCDB FCIS List DB Query IS_MST Synchro funds for FUND nous UH IS_MST FUNDTPR
4. combined order is processed individually in FCIS e Send requests for amount blocks and accounting entry postings to FCUBS Host system Data Flow and Integration Patterns The following diagram provides a high level information of the data flow and integration pattern used in FCIS FCDB integration _Unit Holders _ Fund Inquiries Transaction Request and Response Transaction Inquiries Customer Holdings Data Flow Fetch Data Flow Process The following table contains the integration processes and the pattern of each process Integration Process From To Integration Pattern UH details FCIS FCDB Fetch Fund Inquiries FCIS FCDB Fetch ae ORACLE 2 3 2 3 1 2 3 1 1 2 3 2 2 4 Integration Process From To Integration Pattern Transaction requests FCDB FCIS FCIS FCDB Process request response response Transaction Inquiries FCIS FCDB Fetch Customer Holdings FCIS FCDB Fetch Prerequisites This section contains the following topics e Section 2 3 1 Prerequisites in Oracle FLEXCUBE Direct Banking e Section 2 3 2 Prerequisites in Oracle FLEXCUBE Investor Servicing Prerequisites in Oracle FLEXCUBE Direct Banking The prerequisites for this integration in Oracle FCDB are as follows e Execute the appropriate scripts FCDB_FCATFCIS sql to create objects for accessing fund data in Oracle
5. 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 3 Table of Contents T 1 1 EA EENET 1 1 CO feo eke vere 1 1 1 3 Documentation 1 1 AEA A T 1 1 1 5 Acronyms and 1 2 1 6 5 1 2 17 Related Information 1 2 Oracle FCDB FCIS Integration 2 1 2214 2 1 2 1 1 Integration Scope Oracle FLEXCUBE Direct Banking 2 1 2 1 2 Integration Scope in Oracle FLEXCUBE Investor Servicing System 2 2 2 2 Data Flow and Integration 2 2 2 3 PYOrequISiteS 2224 spate Macnee ea iia Mite Ae ae ee 2 3 2 3 1 Prerequisites in Oracle FLEXCUBE Direct 2 3 2 3 2 Pre
6. 15 5 FUNDAMC Switch Mutual Fund Retail customer can switch between funds available to him her Switch option is available only between funds available within the same AMC For further details on fund refer Transaction User Manual of Oracle FLEXCUBE Investor Servicing The customer can view the funds available within the same AMC for switch transaction When the customer places an order for switch between funds Oracle FCDB places the details in the respective queue which is picked up and processed by FCIS system Data Exchange Communi Service Synchro Source Target 2 Operation nous Action cation Host View System System Code Asynchr Channel Name onous FCDB FCIS Switch JMS FCISSwitch Cre Asyn cre ateSwitch chronous ation FCDB FCIS Funds DB Query IS_MSTUS Synchro availa ERPORTFO nous ble for LIO switch Fund Portfolio Details Customer can inquire and view the funds available in the portfolio for a selected entity and user type For further details on User Maintenance refer Unit Holder Maintenance User Manual of Oracle FLEXCUBE Investor Servicing ORACLE When the customer places a request to view the funds portfolio Oracle FCDB makes a query in FCIS database and displays the funds available in the portfolio for the unit holder Data Exchange Source Target Communic Host View Synchronous System System
7. FCIS e Maintain Foreign Server which points to the appropriate Gateway Queues for exchanging messages between Oracle FCDB and Oracle FCIS Parameter Setup The following parameters need to be setup in Oracle FCDB The User ID to be used for exchanging XML messages over Gateway Kindly refer Oracle FLEXCUBE Direct Banking System Handbook Volume V Host Integration Layer for further details Prerequisites in Oracle FLEXCUBE Investor Servicing The prerequisites for this integration in Oracle FCIS are as follows e Maintain user credentials for Oracle FCDB to access the Oracle FCIS application Integration Process This section contains the following topics e Section 2 4 1 Integrating FCDB and FCIS e Section 2 4 2 Buy Mutual Fund e Section 2 4 3 Redeem Mutual Fund e Section 2 4 4 Switch Mutual Fund e Section 2 4 5 Fund Portfolio Details e Section 2 4 6 Order Status e Section 2 4 7 Fund Activity e Section 2 4 8 Dividend Information ee ORACLE 2 4 1 2 4 2 Integrating FCDB and FCIS The integration between FCDB and FCIS enables the customers to buy and redeem the mutual funds and perform related transactions The customer places transaction orders related to mutual funds in FCDB system FCIS system processes the request and sends an appropriate response to FCDB system which is displayed to the customer If there is no response from FCIS within a specific time then time out mess
8. Oracle FLEXCUBE Investor Servicing Direct Banking Integration Oracle FLEXCUBE Investor Servicing Release 12 1 0 0 0 Part Number E67272 01 October 2015 ORACLE Brage FLEXCUBE Investor Servicing Direct Banking Integration ctober 2015 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 2007 2015 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 manageme
9. age is displayed to the customer The customer can check the order status at a later point under the order status inquiry in FCDB system Note Transactions entered using FCIS screens and those received by means of upload gate way are processed in the same manner Transactions received from FCDB are automati cally authorized in FCIS See Annexure on page 1 for the complete list of touch points of the integration process The activities involved in this integration are discussed under the following headings Buy Mutual Fund Customer can place orders to buy single or multiple mutual funds SIP from Oracle FCDB system From FCDB purchase order screen the customer can view and select the funds SIPs available in FCIS database The customer chooses the required AMC and the funds and then places an order for purchase FCDB places the order details in the respective FCIS queue FCIS picks up the details from the queue and processes the purchase order In case of mutual funds purchase FCIS processes the order and passes the necessary entries to FCUBS host system On completion of the transaction FCIS places a success failure message in the respective queue which is picked up by FCDB system and displayed to the customer In case of SIP purchase FCIS creates a standing instruction on the customer account and sends a confirmation message to FCDB system oe ORACLE 2 4 3 Data Exchange
10. anon Name Asynchronous Channel FCDB FCIS Fetch DB Query IS_MSTUSER Synchronous portfolio PORTFOLIO for unit holder FCDB FCIS Fund DB Query IS_MST Synchronous informa FUND IS_M tion for STFUNDTPR portfolio IS_MSTFUN DAMC 2 4 6 Order Status Investor can view the status of the order placed for a fund FCDB makes a query in FCIS database and displays the status of the transaction Data Exchange Communi Synchro Source Target Host View nous System System cation Name Asynchr Channel onous FCDB FCIS Lookup trans DB Query IS_TXNAC Synchro actions with TIVITYDE nous transaction TAILS reference number 2 4 7 Fund Activity Customer can view the fund activity in FCDB system When customer places a request to view the fund activity FCDB system makes a query in the FCIS database and retrieves the fund activity details aa ORACLE 2 4 8 Data Exchange Comm ni Synchronou Source Target s Action cation Host View Name System System Channel Asynchrono us FCDB FCIS Query DB Query 15 Synchronous TYDETAILS Dividend Information The customer can view the dividend information of a fund When customer places a request to view the dividend details FCDB system makes a query in the FCIS database and retrieves the dividend details Data Exchange
11. nt applications It is not developed or intended for use in any inherently dangerous applications including applications that may create a risk of personal injury If you use this software or hardware in dangerous applications then you shall be responsible to take all appropriate failsafe backup redundancy and other measures to ensure its safe use Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws Except as expressly permitted in your license agreement or allowed by law you may not use copy reproduce translate broadcast modify license transmit distribute exhibit perform publish or display any part in any form or by any means Reverse engineering disassembly or decompilation of this software unless required by law for interoperability is prohibited The information contained herein is subject to change without notice and is not warranted to be error free If you find any errors please report them to us in writing This software or hardware and documentation may provide access to or information on content products and services from third parties Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect
12. requisites in Oracle FLEXCUBE Investor 2 3 2 4 66555 deg edie E 2 3 2 4 1 Integrating FCDB 2 4 2 4 2 gt Buy Mutual asses 2 4 2 4 3 Redeem Mutual 2 5 2 4 4 Switch Mutual 2 6 2 4 5 gt Fund 2 6 2 4 6 a a ia 2 7 2 47 PUNO A 2 7 24 8 Dividend 2 8 2 3 1 31 Data Exchange between FCDB 3 1 3 2 5 nan tint 3 1 1 1 1 2 1 3 1 4 1 Preface Introduction This document is designed to help acquaint you with the integration among Oracle FLEXCUBE products namely Oracle FLEXCUBE Investor Servicing FCIS and Direct banking FCDB Besides this user manual while maintaining the interface related details you can invoke the context sen
13. rwise specified it shall always refer to Oracle FLEX CUBE Universal Banking Solutions system FCUBS Oracle FLEXCUBE Universal Banking FCDB Oracle FLEXCUBE Direct Banking FCIS Oracle FLEXCUBE Investor Servicing EOD End of Day SIP Systematic Investment Plan CIF Customer Information File CASA Current and Savings Account FATCA Foreign Account Tax Compliance Act Glossary of Icons This user manual may refer to all or some of the following icons Icons Function Exit Add row Delete row Option List 1 7 Related Information Sources Along with this user manual you may also refer to the following related sources e Gateway web service documents ka ORACLE 2 1 2 Oracle FCDB FCIS Integration The integration between FCDB and FCIS enables bank customers to perform mutual funds transactions online Following are the features of this integration e Enables customer to submit mutual funds transaction requests online from FCDB e Enables customer to view the mutual funds details in accounts summary and consolidated view of FCDB e Harmonizes customer and accounts across core banking investor services and online banking system This chapter contains the following sections e Section 2 1 Scope e Section 2 2 Data Flow and Integration Patterns e Section 2 3 Prerequisites e Section 2 4 Integration Process Scope This section contains the following topics
14. sitive help available for each field This help describes the purpose of each field within a screen You can obtain this information by placing the cursor on the relevant field and striking the lt 1 gt key on the keyboard Audience This manual is intended for the following User User Roles Role Function Back office data entry Clerks Input functions for maintenance related to the interface Back office Managers Officers Authorization functions End of day operators Processing during end of day beginning of day Implementation Partners Provide customization configuration and implementa tion services Documentation Accessibility For information about Oracle s commitment to accessibility visit the Oracle Accessibility Program website at http Awww oracle com pls topic lookup ctx acc amp id docacc Organization This manual is organized into the following chapters Chapter Description Preface gives information on the intended audience It also lists the various Chapter 1 it chapters covered in this User Manual Chapter 2 Oracle FCDB FCIS Integration explains the integration between Oracle FLEXCUBE Universal Banking and Investor Servicing systems Annexure provides the details of data exchange and further reference Chapters sources tl ORACLE Acronyms and Abbreviations Abbreviation Description System Unless and othe
Download Pdf Manuals
Related Search