Home

Oracle FLEXCUBE Wealth Management Interface User Manual

1. 2 8 2 5 3 Penalty on Term Deposits errer trow ne ren denn an n 2 9 2 5 4 Loan and Liability Information essen 2 11 2 5 5 Term Deposit Rollover sese 2 13 2 5 6 Segmentation Status Information senes 2 14 3 Oracle FCPB FCUBS Interface 3 1 Introduction Dea tte hei ane 3 1 3 2 Details of Data Received from Oracle FCUBS to Oracle FCPB 3 1 3 3 Defining Interface Details from FCUBS to FCPB 3 1 3 4 Transferring Data using XML Files eme 3 2 3 4 1 Creating Customer 3 2 3 4 2 Modifying Customer 3 6 3 4 3 Client Suspended Status 3 7 3 4 4 Broker Data iste i rre enn aX REEERE aao 3 8 3 4 5 CASA Account 3 9 3 4 6 Customer CASA Account Balances 3 11 3 447 CASA Closure Modification 3 12 3 4 8 TD Account Creation iiis enne treni tna had tha poa nnn n 3 13 3 4 9 TDY Modification oisi lace tus 3 16 3 4 10 TD Pre Mature Withdrawal essen 3 17 34 11 TD Rollover
2. Field Column Field ui Name Table Name Data Type Length Position HEADER VARCHAR2 3 1 AC_REF_ TDVWS_TD_MA AC_EN NUMBER 10 1 NO TURITY_DETAILS TRY_SR_NO CUST NO TDVWS TD MA CUSTOM VARCHAR2 9 11 TURITY DETAILS ER NO CUST NA TDVWS MA CUSTOM VARCHAR2 105 20 TURITY DETAILS ER NAME1 TD ACC TDVWS TD MA ACC VARCHAR2 20 125 TURITY DETAILS ACC TDVWS TD MA ACCOUNT VARCHAR2 6 145 CLASS TURITY DETAILS CLASS TRN DT TDVWS TD MA TRN DT DATE 10 151 TURITY DETAILS LCY AMO TDVWS TD MA AMOUNT NUMBER 22 161 UNT TURITY DETAILS DR CRA TDVWS TD MA AC NO VARCHAR2 20 183 CC TURITY_DETAILS 2 7 ORACLE 2 5 2 AC CCY TDVWS TD MA AC CCY VARCHAR2 203 TURITY DETAILS REC STAT TDVWS TD MA RECORD S VARCHAR2 206 TURITY DETAILS TAT TXN TDVWS TD MA TRANSAC VARCHAR2 207 TYPE TURITY DETAILS TION TYPE TRAILER VARCHAR2 1 Daily Accrued Interest on Term Deposits FCUBS hands off the details of the accrued interest on the term deposits to Oracle FCPB on a daily basis This handoff happens only for the customers whose segment code and segment status are defined in the system Note Discounted TD s accrual record will not be sent to Oracle FCPB Interest Liquidation for Discounted TD s will be sent upfront in TD Maturity with interest liquidation file To enable handoff of this data from FCUBS
3. Address MST BROKER Address Line 1 ADDRLN1 Address2 MST BROKER Address Line 2 ADDRLN2 Address3 MST BROKER Address Line ADDRLN3 2s ORACLE 3 4 5 3 4 5 1 CASA Account Creation The details of online notifications for CASA Account Creation are given below Process Flow The following steps are involved in the process 1 The Frequency of this notification would be one time migration and daily incremental online The asset type of products like current and savings account CASA would be created by FCUBS and the details would be handed off to FCPB CA New Customer Account Notify MSG service would be used by FCUBS to hand off the account details to FCPB The CASA Account would be created for customers whose status is Active It is not opened for a Contact person Once the notification message is received from FCUBS on the creation of CASA Account the account details would be inserted into CRM CLIENT BANK ACCOUNT Once the account is created no updates would be done to PMS PORTFOLIO HOLDING table The Holdings would only be updated after receiving the CASA Balance Update Notification FCUBS Element Name FCPB Column Name Description as per the XML Updation in CRM CLIENT BANK ACCT BANK ACC ID CRM ACC CLIENT BANK ACCT CLIENT ID CRM CLI CUSTNO ENT BANK ACCT Cli ent id is based on External which is being sent as CUSTNO CCY
4. Message Id External System Queues BBE In Queue Response Queue Fields FTP Parameters Input By Authorized By Modification Date Time Date Time Number Authorized Open Specify the following details External System Specify a name for the external system This should be the same as the source in an incoming message For this integration you need to specify FCDB Description Specify a brief description of the external system For further details on defining external system refer to the chapter External System Maintenance of Gateway user manual Maintaining Queues Incoming messages are routed through a messaging queue You need to maintain the different user queues to which incoming messages will be directed Users with appropriate privileges are allowed to access a particular queue 6 96 ORACLE 6 3 To invoke the Message Queue Maintenance screen type MSDQUEUE in the field at the top right corner of the application tool bar and click the adjoining arrow button Queue Maintenance New Enter Query Queue Description Collection Queue Swift Message Queue Message Code Input By Authorized By Modification Date Time Date Time Number L Authorized Open Specify the following details Queue Specify a unique name to id
5. Table Field eae Field Name Data Length Position ACC TDVW T ACCOUNT CLASS VARCHAR2 6 145 CLASS D DE TAILS TRN DT TDVW T TRN DT DATE 10 151 D DE TAILS LCY AMOU TDVW T AMOUNT NUMBER 22 161 NT D DE TAILS DR CR AC TDVW T AC NO VARCHAR2 20 183 C D DE TAILS AC CCY TDVW T AC CCY VARCHAR2 203 D DE TAILS REC STAT TDVW T RECORD STAT VARCHAR2 1 206 D DE TAILS TXN TYPE TDVW T TRANSACTION VARCHAR2 9 207 D DE TYPE TAILS TRAILER VARCHAR2 1 Loan and Liability Information FCUBS hands off the details of loan accounts to Oracle FCPB This handoff happens only for the customers whose segment code and segment status are defined in the system The handoff file contains the following details of the loan accounts maintained in FCUBS e Principal outstanding amount e Maturity date e Interest rate e Tenor of the loan e Accrued amount e Amount paid e Last paid date To enable handoff of this data from FCUBS you need to define the interface details as given in the following table Field Value Interface Code CLOLNDTL Interface Type Outgoing 2 11 ORACLE From System FCUBS To System FCPB Dateformat YYYYMMDD File Mask U B S _ P R O D B L D M Y h m s E N D Whentorun End of Transaction input Frequency Daily Character Set ASCII Format Delimited Del
6. Communication Channels The communication between Oracle FCUBS and FCDB happens in two ways e Incase of online transactions involving booking of a contract or account in Oracle FCUBS the communication happens by way of XML interchange e Incase of batch uploads for single debit multiple credit the communications happen via database views for inquiries and via database tables for batch uploads The XSDs provide the templates for validation of the XML files exchanged between the systems 6 55 ORACLE 6 2 6 2 1 6 2 2 Maintenances In order to enable the integration between FCUBS and FCDB you need to do certain maintenances in FCUBS Maintaining External Systems You need to define FCDB as an external system in order to enable communication between FCDB and Oracle FLEXCUBE Integration Gateway You can define external system details using the External System Maintenance screen To invoke this screen type GWDEXSYS in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button External Systems New Enter Query External System Correlation Pattern External System Request Messageld Description Message Exchange Pattern Queue Request Message InputOnly Default Response Queue Response Message FullScreen Dead Letter Queue F XSD Validation Required Mi Repo
7. Interface Request XSD Request Host Response Interface XSL XSD Name XSL Calculator for ST CreateTD CalculateTD CalculateTD ST CreateTD Term Deposit CustAcc Req Maturit Maturit CustAcc Res maturity Full MSG xsd yAmtReq xsl yAmtResp xsl Full MSG xsd amount Services and Operations associated with XSDs The list of XSD files and the services and operations associated with each XSD is given below XSD names Services Operations ST CreateCustAcc Req Full MSG xsd FCUBSAccService CreateCustAcc AccStmt Adhoc Query Req MSG xsd FCUBSAccFinService RequestAccStmt TDStmt Adhoc Query Req MSG xsd FCUBSTDFinService RequestTDStmt CA StopPaymentsNew Req Full MSG XSD CA CreateStopPayments Req Full MSGxsd FCUBSAccService CreateStopPayments DDTransaction Create Req Full MSG xsd FCUBSDDService CreateTransaction FTContract Create Req Full MSG xsd FCUBSFTService CreateContract SIContract Create Req Full MSG xsd FCUBSSIService CreateSIContract FTContract Create Req Full MSG xsd FCUBSFTService CreateContract SIContract Create Req Full MSG xsd FCUBSSIService CreateSIContract FTContract Create Req Full MSG xsd FCUBSFTService CreateContract SIContract Create Req Full MSG xsd FCUBSSIService CreateSIContract PC ClosePCMaint Req Full MSG xsd FCUBSPCService ClosePCMaint SIContract Close Req Full
8. FIELD MANDAT LEN NAME DESCRIPTION ORY COLUMN TABLE NAME GTH NAME PHONE W Work Phone NO E TELE STT 10 ORK PHONE M CUST PRO FESSIONAL EMAIL Email NO E MAIL STT 255 M CUST PER SONAL GENDER Gender M YES SEX STT 1 Male F M CUST PER Female SONAL DOB Date OF Birth NO DATE OF STT 10 BIRTH M CUST PER SONAL TAX ID Income Tax ID YES TAX ID STTM CORP DI 105 RECTORS CLI Client Segment YES CUST SEG STTM CUS ENT SEG MENT CO TOMER DE OCCUPA Occupation YES DESIGNA STT 105 TION TION MS CUST PRO FESSIONAL CLIENT Client IT type YES CUSTOM STTM CUS 1 TYPE ER TYPE TOMER HOME BRA Branch code of YES LOCAL BR STTM CUS 3 NCH the customer ANCH TOMER ACQ DATE Acquisition NO NULL Date BANKER Banker Code YES BANK CO STTM BANK 4 DE ADDR LINE Mailing NO MST 105 1 Address 1 ADDRESS M CUST AD DRESS ADDR LINE Mailing NO MST 105 2 Address 2 ADDRESS2 M CUST AD DRESS ADDR LINE Mailing NO MST 105 3 Address 3 ADDRESS3 M CUST AD DRESS STATE State of the NO NULL MAILING Mailing address 2 16 ORACLE FCUBS FIELD MANDAT LEN NAME DESCRIPTION ORY COLUMN TABLE NAME GTH NAME COUN Country of the NO COUNTRY MST 3 TRY MAIL mailing address M CUST AD ING DRESS ZIP MAIL Zip code ofthe NO NULL ING mailing address ADDR LINE Home Address YES ADDRESS STTM CUS 105 1 1 LINE1 TOMER ADDR LINE Home Address
9. Transaction Group Transaction Name Database Views XSD names Trade Finance View Export Let ters of Credit fcc vw lcvw cont prod summary fcc vw lcvw avail ments fcc vw lcvw con tract clauses fcc vw lcvw docu ments fcc vw lcvw drafts fcc vw lcvw parties fcc vw msvw cust a ddress fcc vw lcvw contract fcc vw bcvw con tract summary fcc vw lcvw contract fcc Ictb amn d vals master Trade Finance Attach Docu ments Trade Finance View Attached Documents Trade Finance View Import Bills fcc vw bcvw con tract master fcc vw cfvw charge settlement fcc vw BCTBS CONTRACT DISC fcc vw bcvw con tract parties FCC VW BCTBS CONT SHIP INFO fcc vw bcvw con tract docs fcc vw FCC BCT B CON MASTER fcc vw CON TRACT SUMMARY fcc vw lcvw cont msgs 6 77 ORACLE Transaction Group Transaction Name Database Views XSD names Trade Finance View Export Bills fcc vw bcvw con tract master fcc vw cfvw charge settlement fcc vw bcvw con tract parties FCC VW BCTBS CONT SHIP INFO fcc vw bcvw con tract docs fcc vw BCTBS CONTRACT DISC fcc vw FCC BCT B CON MASTER fcc vw BCVW CON TRACT SUMMARY fcc vw lcvw cont msgs Trade Finance Collections Direct Collection Initiation BC CreateContract Req Full MSG xsd Trade Fin
10. 240 ORACLE FCUBS FIELD MANDAT LEN NAME DESCRIPTION ORY COLUMN TABLE NAME GTH NAME CUSTOM Status of the NO CIF STA STTM CUS 20 ER STA customer TUS TOMER TUS UDF NUM UDF NUM 1 NO FIELD VAL CSTM FUNC 150 1 _1 TION USER DEF FIELDS UDF NUM UDF NUM 2 NO FIELD VAL CSTM FUNC 150 2 2 TION USER DEF FIELDS UDF NUM UDF NUM 3 NO FIELD VAL CSTM FUNC 150 3 3 TION USER DEF FIELDS UDF NUM UDF NUM 4 NO FIELD VAL CSTM FUNC 150 4 4 TION_USER DEF_FIELDS UDF_NUM_ UDF NUM 5 NO FIELD_VAL CSTM_FUNC 150 5 _5 TION USER DEF FIELDS UDF TXT 1 Guardian name NO LEGAL GU STT 105 It is manda ARDIAN M CUST PER tory if minor flag SONAL is UDF TXT 2 UDF TXT2 NO FIELD VAL CSTM FUNC 150 T7 TION USER DEF FIELDS UDF TXT 3 UDF TXT 3 NO FIELD VAL CSTM FUNC 150 _8 TION USER DEF FIELDS UDF TXT 4 UDF TXT 4 NO FIELD VAL CSTM FUNC 150 _9 TION_USER DEF_FIELDS UDF TXT 5 UDF TXT 5 NO FIELD VAL CSTM FUNC 150 _10 TION_USER DEF_FIELDS UDF_ NO FIELD VAL CSTM FUNC 150 DATE 1 _11 TION USER DEF FIELDS UDF NO FIELD VAL CSTM FUNC 150 DATE 2 12 TION USER DEF FIELDS 2 21 ORACLE FCUBS FIELD DESCRIPTION MANDAT COLUMN TABLE NAME ORY GTH NAME UDF NO FIELD VAL CSTM FUNC 150 DATE 3 13 TION USER DEF FIELDS
11. AMT CCY ACCOUNT CCY CLIENT ID CUSTNO SUB PORTFOLIO ID TERM ACNO Updation in PMS PORTFOLIO HOLDING TOTAL ACQ COST Reduce the TD Buy Cost by PMS PORTFOLIO HOLD the PAR Amt received i e ING by the REDEMPTION AMT MAR Reduce the TD Mar KET VALUE PMS PORT ket Value by the PAR Amt FOLIO HOLDING received i e by the REDEMPTION AMT VALUE DATE PMS PORT CHECKERDT FOLIO HOLDING ORACLE 3 4 11 3 4 11 1 Updation in PMS TD HOLDINGS DETAILS BALANCE Reduce the BALANCE by the PAR Amt received i e by the REDEMPTION AMT TD Rollover The details of TD Rollover interface are given below Process Flow The following steps are involved in the process 1 The Frequency of this notification would be daily incremental EOD 2 Time Deposit which are of Rollover type would be auto rolled over in FCUBS and the details would be handed off to FCPB as a part of FCUBS BOD in a new file format Rollover Format 3 Even manual Rollovers performed by Operations at FCUBS end would be sent to FCPB using the same XML Rollover Format 4 Once the Rollover notification message is received from FCUBS the transaction details would be inserted into PMS TRANSACTION and updated in PMS PORTFOLIO HOLDING and PMS TD HOLDING DETAILS tables 5 Onrollover PMS PORTFOLIO HOLDING table would be updated for Market Value and Settled MktValue columns with the rollover amount But the TOTAL
12. idt tento gel ERR 3 18 3 5 Data Transfer using File Upload Mechanism 3 21 3 5 1 TD Maturity along with Interest Liquidation 3 21 3 5 2 Daily Accrued Interest on 3 22 3 5 3 Penalty on TD applicable in case of pre mature partial withdrawal and pre mature complete withdrawal 3 23 3 5 4 Loan and Liability Information sss 3 24 3 6 Segment Upgrade Downgrade Interfaces 3 25 3 6 1 Customer File Upload Segmentation 3 26 3 6 2 Customer Account File Upload Segmentation Upgrade 3 26 3 6 3 Customer Balances File Upload Segmentation Upgrade 3 27 3 6 4 Customer TD Deals File Upload Segmentation Upgrade 3 27 3 6 5 Customer Online Notification Segmentation Downgrade 3 28 3 7 ASSUMPTIONS iis S 3 28 4 Oracle FCPB FCDB Interface 4 1 4 1 introd ctionz 4o nec Oe IERI OI IUE DE 4 1 4 1 1 Rules for Single Sign On from Oracle FCDB to 4 1 4 1 2 Investment Portfolio Details from FCPB to 4 1 5 Oracle FCDB FCPB Interface 5 1 DU
13. Transaction Administration Oracle Nam Transaction Description Transaction FLEXCUBE in UBS Module Exchange Rate This function displays No FOREX Inquiry exchange rate between cur rency pairs Change PIN This transaction allows the No business user to change their password Corporate This function allows user to No Authorization authorise a transaction initi ated by another user of that customer SMS Help on This function allows user to No Message For seek help for message for mats mats used to send request using SMS banking SMS help is local to FCDB 6 1 1 Additional Interfaces Following are the additional transactions supported by Oracle FCUBS Oracle FCDB Integration Transaction Interface Request Id Interface Description Operation Name Name Name Peerto Peer Hold or RRPPPO03 This interface is used to CreateAmtBIk Payment Block block a given amount if the beneficiary is not registered Peerto Peer Debit RRPPPO03 This interface is used for CreatePC Payment account and customer debit and Contract credit GL credit to GL if the benefi ciary is not registered Peerto Peer Debit RRPPPO03 This interface is used for CreatePC Payment account and making final payment Contract credit bene from customer to the account beneficiary Peer to Peer Reverse Working While initiating the pay Payment Amount through a ment if the transaction timer amount was credited to G
14. FCDB_FCPB SEND FCAT_REST_CON TEXT FCPB context used for unmarshelling FCDB F CPB SEND FCAT REST METHOD FCPB customer folio URL invoking method e g GET POST FCDB FCPB SEND FCAT REST URL FCPB customer folio URL ORACLE 6 1 6 Oracle FLEXCUBE Universal Banking Direct Introduction Banking Integration Oracle FLEXCUBE Direct Banking is a multichannel e banking platform with support for customer touch points like Internet mobile phones and PDAs This system is based on Java Standard Edition Java SE and Oracle Java Enterprise Edition Java EE platforms Oracle FLEXCUBE Universal Banking Oracle FLEXCUBE Direct Banking integration provides for exchange of data between the two systems This enables the users of Oracle FCDB to access the information stored in Oracle FCUBS application This manual explains the prerequisites required for the integration of FCUBS and FCDB It also describes various types of information that are in the scope of integration and the channels through which such information are processed The transactions supported by this integration are given below Transactions administrator to view the transactions done by various business users Transaction Administration Name Transaction Description Transaction FLEXCUBE UBS Module Account Setup This transaction allows a Cor Yes porate administrator to view amp modify ac
15. tiate Domestic Transfer options available in UK BACS CHAPS Faster UK 6 37 ORACLE Transaction Administration Oracle Transaction Description Transaction FLEXCUBE UBS Module View Standing This function displays Stand No Funds Transfer Instructions ing Instructions configured in Payment and the host banking system Collections Cancel Standing This function allows user to No Funds Transfer Instructions cancel Standing Instructions Payment and configured in the host banking Collections system View Pending This function allows user to No Funds Transfer Transfers view transactions which are Payment and schedule to be executed Collections accounted on future date Cancel Pending This function allows user to No Funds Transfer Transfers cancel transactions which are Payment and schedule to be executed Collections accounted on future date Linked Account This function allows user to No NA Setup link an external account for funds Transfer using random deposit confirmation Move Money In This function allows user to ini No Payments amp Col To Linked tiate a direct debit from regis lections PC Accounts tered linked account Move Money out This function allows user to ini No Payments amp Col To Linked tiate a transfer to registered lections PC Accounts linked account Savings Plans This plan allows userto setup No Payments amp Co
16. 3 4 2 3 4 2 1 3 4 2 2 e Then you have to navigate to the Segment Association screen and fill in the other details like Segment Upgrade Status etc e FCPB will accept the Customer Creation Notification successfully only if the above workflow is followed Modifying Customer Data If there are any modifications at FCUBS end a full screen response notification is sent to FCPB with the amended details Process Flow The following steps are involved in the process The closure of CIF is also communicated from FCUBS to FCPB On receipt of this closure intimation from FCUBS the status of the customer changes to Closed 1 Any change in Segment either Segmentation Upgrade or Downgrade is also expected as a part of Customer Modification To support this an additional element the Customer Segmentation Status is sent to FCPB which would have values Segment Upgrade U or Segment Downgrade D and Segment Reupgrade R 2 Ifthe Segmentis modified in FCUBS then FCPB updates the Client Seg column with the new Segment Code in CRM CLIENT MASTER Hence the role of that customer changes based on the new segment by first identifying the Role ID with NAME Segment s name from SMS ROLE and then identifying User id of the Customer from SMS APP USER The system then updates SMS USER ROLE table for that User Id with the ROLE Id for the new Segment Updating Crm Client Master Table The customer status in FCPB gets up
17. After a NEW transaction is received on Booking a TD with a particular TD reference number any other NEW transaction with the same reference number and same client should be rejected with the reason Duplicate Booking transaction with same reference number already exists After a NEW transaction is received on Booking a TD with a particular TD reference number any other MAT or PAR transaction for the same reference number with Transaction Date earlier than Booking Date should be rejected with reason This is a new transaction cannot be a SELL This rejection logic is in built in the Transaction Processor of FCPB which rejects SELLs without having a BUY After a NEW transaction is received on Booking a TD with a particular TD reference number any other INT transaction for the same reference number with Transaction Date earlier than Booking Date should be rejected with reason Corporate Action cannot happen with new Client ID Portfolio ID Instrument ID or Subfolio ID This rejection logic is in built in the Transaction Processor of FCPB which rejects Corporate Actions like INT without having Holdings for that CPIS Whenever a PAR Transaction is received the system should first check if the PAR amount is more than the remaining balance principal and if PAR Amount is greater than the Balance The system should reject the record with the reason Withdrawal amount cannot be greater than remaining ba
18. Im 1 ri 5 r D v m v n r r ri r Ei r r E E D r r v n r 2 r iv D 5 v ai r 2 5 L r r Save Clear Automatic Login Creation for New Customer Whenever a customer is created in FCPB via the Create Customer XML from FCUBS a script is executed to auto generate the Login ID of the customer This script makes an entry in the SMS APP USER table and assigns a Role to the customer which is same as one s Segment after appropriate transaction transformation to FCPB s specific Segment Codes For supporting this Roles are created for every segment These roles are mapped as Customer Roles and the names of these roles are identical to the Segments maintained Identifying Customer Currency and Creation of Portfolios Customer s Currency Code is an essential field while creating a customer without which a portfolio cannot be created in FCPB The Create Customer Notification from FCUBS also contains the Customer for all Wealth Customers Portfolios in FCPB get auto created on creation of a new Customer with this Customer CCY as the Portfolio Currency as well Directory Details for Corporate Clients Currently for corporate clients FCPB supports only a single Director s details x ORACLE 3 4 1 2 Notification XML For Customer Creation or modification FCUBS sends the notification with the appropriate Namespace and Notif c
19. INSTRU MENT CCY PMS PO RTFOLIO HOLDING CCY TOTAL ACQ COST PMS PORTFO LIO HOLDING The TD deposit amount would be populated TDAMT MAR KET VALUE PMS PO RTFOLIO HOLDING The TD deposit amount would be populated TDAMT CLIENT ID PMS T D HOLDINGS DE TAILS CUSTNO SUB PORTFOLIO ID ACC PROD will have values like time deposit call deposit etc ACCLS the same val ues to be in sync with those values in FCPB CURRENCY CCY MATURITY_DATE MATDT INT_RATE INTEREST_RATE under lt Tddetails gt sub node TENOR DFTENOR TENOR_DM to be Will be defaulted to D days since defaulted to days FCUBS would be sending the tenor details in days BOOKING_DATE ACCOPENDT Spread_Bps In Account Class for TD Product define a UDF with FLDNAME as SPREAD while creat ing the TD Class and the FIELD_VALUE for this UDF will contain the Spread ORACLE 3 4 9 3 4 9 1 User HOHEADRMONE Current Login 07 05 2012 2 21 Home Customer Financial Planning Order Mgmt Mgmt Master Reports Tools My Workspace Logout Customer Portfolio Maintenance Portfolio RM Managed EE CASA 2 TimeDep Type ccv Amount of Total Total GBP 86 896 33 10096 View Portfolio Modify Delete Add Portfolio Last Transaction Date in the Portfolio 31 12 2012 erm Deposit GBP Term Deposit GBP o p
20. Manual Rollover P TDs or Recurring Deposit TDs where again the Interest is credited to TD A C The limitation here is that in UBS full uplift is allowed to the extent of Principal Interest Liquidated Interest Accrued since last liquidation However in FCPB since Partial Full uplift is allowed only to the extent of Balance Outstanding Principal such withdrawals would get rejected in FCPB TD Modification FCPB would be referring to the UDE named TERM RATE to pick up modified Interest Rate in TD Modification Hence in IC product preference screen Main Interest Rate UDE field should be maintained mandatorily as TERM RATE UDE for FCUBS and FCPB integration Autorollover with Segmentation limitation There is a limitation in case an operator segments a customer on a particular date and on the next date any of this customer s TDs get Auto Rolled over Such Rollover XMLs currently fail to be accepted by FCPB because the Segmentation details of the TDs booked have not yet been sent to PB at the time the Autorollover XML has reached FCPB Whatthis means is that RMs Bank Operators need to be made aware that if they are integrating with FCPB then if they are expecting an Autorollover anytime between next Calendar Date and Next Business Date this will take care of Holidays in between today s date and Next Business Date also then they should not be segmenting the Customer today They should operationally ensure that such custo
21. 24 6 NO AMO 22 CLTB_AC EST P paid BER UNT COUNT SC AID SET HEDULES TLED LAST Last DAT NO EVEN 8 CLTB AC Last liqui NT interest E T DA COUNT dation DATE date TE ENTST DI event hap ARY pened date HOLD Hold NUM 24 6 NO AMO 22 CLTB This will AMOUN amount BER UNT COUNT bederived T FINA STER from NCE AMOUNT D _FI MINU NANCED S AMOUNT AMO DIS UNT BURSED DIS BURS ED Customer TD Booked File Format The format of the customer TD booked file is given below FIELD DESCRIP LEN MANDAT SAMPLE NAME TION TYPE GTH ORY REMARKS VALUES CLI External Varchar 10 Yes ENT customer D ID TRAN Trantype Varchar 15 Yes Could be NEW for Booking E PAR for Partial Uplift or RNW for Rollover 2 27 ORACLE FIELD DESCRIP LEN MANDAT SAMPLE NAME TION TYPE GTH ORY REMARKS VALUES ACCO Acountno Varchar 16 Yes UNT NO TRAN Transac Date Yes _DAT tion date E AMOU Amount Number 24 6 Yes Could be BookingAMt or PARAMt NT For PAR TranType or Rollover AMt for RNW tranType CUR Currency Varchar 3 Yes RENC Y MAT Maturity Date Yes Could be MatDt for Booking OR DATE date New MatDt for Rollovers TENO Tenor Number 10 Yes R INT R Interest Number 23 6 NO Has been made non mandatory ATE rate as FCUBS request but Should be mandato
22. AUTH SIGN H Home number of the NO TELE STT OME authorized signatory PHONE M CORP DIRECTORS AUTH SIGN Tax identified of the NO TAX ID STT X ID authorized signatory M CORP DIRECTORS AUTH SIGN R Relationship of the NO EL authorized signatory AUTH SIGN Type of the authorized NO TYPE signatory NATIONALI Nationality of the author NO NATIONAL STT TY COUN ized signatory ITY M CORP TRY CODE DIRECTORS 2 30 ORACLE FCUBS MANDA FCUBS FIELD NAME DESCRIPTION TORY Column Tabla Name AUTH SIGN A Address of the author NO ADDRESS STT DDRESS ized signatory _LINE1 M_CORP_ DIRECTORS AUTH_SIGN_C Country Address of the NO ADDR_CO STT OUNTRY authorized signatory UNTRY M_CORP_ DIRECTORS AUTH_SIGN_D Country Address of the NO NULL OMICILE authorized signatory Customer FATCA File Format The format of the customer FATCA handoff file is given below FCUBS MANDA FCUBS FIELD NAME DESCRIPTION TORY Column Table Name LINKED_CLI External client id of cus YES CUSTOM STTM CUS ENT ID tomer ER NO TOMER FCPB CLI FCPB Client Id of cus NULL ENT ID tomer In case if external ID is does not provided in this file then process cus tomer upload based on FCPB CLIENT ID US INDICIA US INDICIA PRESENT NO US INDI STT CIA M CUST FATCA FATCA ID FATCACLASSIFICA NO FATCA STT TION to be arrived CLASFCN M CUST based on values
23. Customer Mail Box Services Customer Electronic Form Services Customer Form amp User Manual Services Downloads Customer Force Change Pass Services word Customer Site Map Services Customer Frequently Asked Services Questions Customer News Services Customer ATM Locator Services Customer Branch Locator Services Customer Ad hoc Statement AccStmt Adhoc Query Services Request CASA amp Req MSG xsd Accounts TD TDStmt Adhoc Query Req MSG xsd Customer Stop and Unblock CA StopPaymentsNew Services Cheque Request Req Full MSG XSD Accounts CA CreateStopPay ments Req Full MSG xsd 6 63 ORACLE 6 3 3 Transaction Transaction Name Database Views XSD names Group Customer Cheque Status fcc vw cheque sta Services Inquiry tus inquiry Accounts fcc vw cavw ch ck details fcc vw cat m stop payments Customer Cheque Book fcc vw mstcorpo CA CreateCheckBook Services Request rate Req Full MSG xsd Accounts FLEXCUBE Direct Banking Corporate Transfer and Payments The transactions and the respective database view XSD are as follows Transaction Group Transaction Name Database Views XSD names Transfer and Payments Main tenance Source Beneficiary Linkage mstsourcebene linkage Core Services Global Beneficiary Mapping Qualification not required FCDB transaction Admin SEPA Transfers SEPA Card Pay ments PC CreatePCMa
24. For further details on the fields on Interface Definition screen refer to the section Specifying Interface Definition Details under chapter Generic Interface of Generic Interface user manual Defining Component Details As part of interface definition you need to capture specific component details for both handoff and upload Click Component Details button on the Interface Definition screen Component Details Component Linkage Serial Number Component ComponentType Parent Relation Batch By Field Where Claus Header el m Component Field Linkage Serial Number Field Field Type Default Data Type Length Column Name Object Name Message Character You can capture the details of the header body and footer under Component Linkage section Below that under Component Field Linkage section you can define the details pertaining to table columns field type field length field name and other relevant details For more details of the fields on this screen refer the chapter Generic Interface in the Generic Interface User Manual i ORACLE 2 3 2 4 FATCA Interface between Oracle FCUBS and FCPB As part of the GIDPRSIF batch Oracle FCUBS hands off FATCA Foreign Account Tax Compliance Act related data to FCPB This batch is part of the
25. ORACLE Transaction Administration Oracle Transaction Description Transaction FLEXCUBE UBS Module Switch Mutual This function allows user to No Fund buy the mutual fund units of a mutual fund scheme Order Status This function displays order No status for Mutual Funds trans actions Fund Activity This function displays transac No tion activity happened in selected fund Dividend Infor This function displays dividend No mation information for a selected fund My Accounts This function displays the No CASA Retail summarized view of the Term Deposit accounts held by the cus Consumer Lend tomer ing Loans amp Deposits Module My Cheques This function displays the No CASA cheques status Stop Cheque This function allows user to No CASA block a cheque payment or revoke the stop payment instruction issued earlier Contract Deposit This function displays the No Corporate Details summary and details of Term Deposits deposit accounts contracts held by user Loan Details This function displays the No Consumer Lend details of the selected loan ing account like loan product details disbursed amount outstanding balance details Change Pass This transaction allows the No word business user to change their password Credit Card This function displays details No Details of the Credit cards hold by the user Credit Card This function displays the
26. Pay Order International International Transfers MT101 Transfer request SEPA Direct Debits SEPA Credit transfer Internal Remittance UK Payments For internal funds transfer Beneficiary details are verified with the Host The Beneficiary data is main tained in FCDB No View Limits Utili zation This function allows user to view the limits allocated to them and their current utilisa tion No Change Limits This function allows user to change the existing limits allot ted by the bank No Global Benefi ciary Mainte nance This transaction allows the bank administrator to Create modify and delete Generic and restricted beneficiaries The transaction also allows the bank administrator to delete public and private beneficiar ies by the business users Yes Setup Account Structure This function allows setup Notional Pooling or Sweep Instructions by creating Cash management account struc ture No Integrated Liquidity Man agement Modify Account Structure This function allows to Modify Notional Pooling or Sweep Account Structure No Integrated Liquidity Man agement 6 21 ORACLE Transaction Administration Oracle Transaction Description Transaction FLEXCUBE UBS Module View Account This function allows to Delete No Integrated Structures Notional Pooling or Sweep Liquidity Man
27. Statements This function allows user to view the MT 940 statement received by him The registra tions for viewing statement shall be done in the FCDB No SWIFT Exchange Rate Inquiry This function displays exchange rate between cur rency pairs No FOREX Alerts Registra tion This function allows the users to register for various alerts Alerts are generated and based on specific event and send to the user User shall be able to register for both FCDB and Host spe cific alerts Registration data is main tained in FCDB No E Statement Subscription This function allows user to subscribe unsubscribe for e statement The registrations details are maintained at FCUBS and the statement FCUBS generates and sends the statement as per registra tion details No CASA Islamic CASA Term Deposits Islamic Deposits Loans Islamic Loans Subscribe for other channels This function allows user to Subscribe for other available channel from Internet banking login Registration details are main tained in FCDB No ORACLE Transaction Name Transaction Description Administration Transaction Oracle FLEXCUBE UBS Module Deactivate Channel User This function allows user to deactivate a channel tempo rarily for a predefined time period Details are maintained in FCDB No Lock Transac tion Password This function allows user t
28. This function displays list of the ATMs the bank have A link to the ATM locator pre pared by the bank is provided No Branch Locator This function displays list of the branches the bank have A link to the Branch locator pre pared by the bank is provided No 6 33 ORACLE Transaction Administration Oracle Transaction Description Transaction FLEXCUBE UBS Module Ad hoc State This function generates No CASA Islamic ment Request account statement request for CASA Retail CASA amp TD CASA and term Deposit Term Deposits account for a specified period Stop and This function allows user to No CASA Islamic Unblock Cheque block a cheque payment or CASA Request revoke the stop payment instruction issued earlier Cheque Status This function displays the No CASA Islamic Inquiry cheques status CASA Cheque Book This function allows user to No CASA Islamic Request request a chequebook CASA Debit Card This function displays debit No Generic Inter Details card details faces Open Additional This function allows user to No CASA Islamic CASA Account open a new CASA account by CASA debiting existing CASA account Online Cus This function allows user to No CASA Islamic tomer and open an online CASA account CASA Account Open and register for FCDB ing Reminders Transaction allows Business No Interactions user to register for personal reminde
29. UDF NO FIELD VAL CSTM FUNC 150 DATE 4 14 TION USER DEF FIELDS UDF NO FIELD VAL CSTM FUNC 150 DATE 5 15 TION USER DEF FIELDS Customer Account File Format The format of the customer account file is given below FIELD DESCRI LEN FCC COL ac TABLE Fcubs NAME PTION GTH UMNS NAME Remarks RY TH T EXT External 10 YES CUST NO 9 STT CLI client id M CUST ENT ID ACCOUNT T BANK Bank 16 YES CUST AC 20 STT ACCT ID account NO M CUST id ACCOUNT T ACCT Account 1 YES ACC_STA 4 STT STATUS status TUS M_CUST_ ACCOUNT T_ACCT_ Account 5 YES ACCOUNT 6 STT SUB sub type CALSS M CUST TYPE ACCOUNT T CURR Currency 3 YES CCY 3 STT M CUST ACCOUNT T ACCT Account 50 YES BRANCH 3 STT BRANCH branch CODE M CUST ACCOUNT T MICR MICR 24 NO NULL T ACCT Account 5 YES ACCOUNT 1 STT S Sav TYP type TYPE M CUST ings U ACCOUNT Current T_SALES_ Salerep 50 NO NULL REP ID resenta tive id 2 22 ORACLE FIELD DESCRI LEN Bine FCC COL wa TABLE Fcubs NAME PTION GTH UMNS NAME Remarks RY TH T OP Sale 50 NO NULL PORTUNI oppurtin TY_ID ity id OPEN Opening YES AC_OPEN 8 STT ING DATE date DATE M CUST ACCOUNT CLOS Closing NO AC SET 8 STT ING DATE date CLOSE M CUST DATE ACCOUNT T ACCT Address 200 YES ADDRESS 105 STT ADDRESS 1 M CUST ACCOUNT T ACCT Addr
30. e Creation modification or closure of customer information e Creation of Brokers customer under the customer category Broker in FCUBS e Modification of term deposit account in FCUBS e Premature withdrawal redemption before maturity date of the term deposit amount Note Online Notification for TD redemption through 1317 redemption screen is not supported e Rollover of Term deposit account in FCUBS e Creation of Recurring deposit account in FCUBS e Customer creation under BROKER category e Amendment of the segmentation code net worth amount net worth currency and customer currency of customer Segmentation e Amendment of the segmentation status from Upgraded to Downgraded and Re Upgraded to Downgraded es ORACLE Note Notification will be fired only for segmented customer That is when the segment status and segment code for the customer are not null Customer status cannot be modified to downgrade on the same day of upgrade The details of online notification processed from FCUBS are given below Instance Operation Service XSD Name Code TD account NOTIF TD T QuerycustAc FCUBSAccSer TD NewAc creation DACC NEW countDetails vice count Notify MSG xsd TD Account NOTIF TD QuerycustAc FCUBSAccSer TD NewAc modification MOD PB countDetails vice count Notify MSG xsd TD prema QueryTDRe FCUBSAccSer IC QueryTDRe ture wit
31. fcc vw longop tions fcc vw lcvw cont prod summary fcc vw lcvw avail ments fcc vw bcvw contract summary fcc shortoptions fcc vw assetsportfolio Accounts CASA Interest Rate Inquiry 6 3 5 FLEXCUBE Direct Banking Corporate Bill Payments The transactions and the respective database view XSD are as follows Transaction Transaction Database Views XSD names Group Name Bill Payments Register Biller fcc vw biller info Bill Payments Delete Biller Bill Payments Pay Bills Utility Payment Create Req Full MSG xsd 6 3 6 FLEXCUBE Direct Banking Corporate Bulk Payments The transactions and the respective database view XSD are as follows Transaction Transaction Database Views XSD names Group Name Bulk Mainte Bulk Data Diction nance ary Bulk Mainte Bulk Enrichment nance Definition Bulk Mainte Bulk Template nance Definition Bulk Mainte Bulk File Template nance Definition Bulk Mainte File Control Defi nance nition 6 68 ORACLE 6 3 7 Transaction Transaction Database Views XSD names Group Name Bulk Mainte Bulk Registration nance Bulk Mainte User BTID Map nance Bulk Mainte Update File Status nance Bulk Transac tions Bulk File Uploads Internal Transfer FTContract Create Req Full MSG xsd Bulk Transac tions Bulk File Uploads Domestic Trans fer PCContract Create Req Full MSG xsd Bulk Transac tions Bulk File Uploads Internati
32. COST column and derived fields in Cust CCY Household CCY CCY etc should remain untouched as it should continue to indicate the original booked TD s Principal Balance 6 PMS TRANSACTION table would also store the renewal details with Transaction Type RNW as mentioned above The Bid Ask indicator column in Pms Transaction table for a Rollover TD would be a B buy 7 PMS TD Holdings Details table would also be updated for BALANCE same as Rollover Amount MATURITY DATE being sent in the Rollover XML INT RATE being sent in the Rollover XML and Rollover Type 8 PMS TD Holdings Details table should not be updated for Booking Date and it should continue to reflect the same date as the original TD Booking Date 9 nterest Amount would also be mentioned in the Rollover XML and if this value is not blank Transaction Processor would create an INT transaction in PMS Transaction and update Holdings fields related to Interest like Dividend Interest and its Fx converted fields 10 As part of the EOD after the Rollover none of the MAT INT records for the Rolled over TD are available in the UBS TDMAT File FCUBS Element Name as per FCPB Column Name Description the XML Updation in PMS TRANSACTION TRAN DATE Indicating Rollo RENEWAL DATE ver Date TRAN TYPE to be RNW defaulted to RNW us ORACLE FCPB Column Name Description FCUBS Element Name as per the XML AMOUNT In
33. CRM CLI CCY ENT BANK ACCT ACCT TYP CRM CLI Use existing logic of populat ENT BANK ACCT ing PROD_ID and Instru ment ID to identify ACC ACCT SUB TYPE ACCTYPE to be parame terized with values like S C BANK ID should be defaulted to value in BANK ID of MST BANKS It is assumed that only one branch of FCPB client like BMO BDB is going to be main tained in the table ORACLE ACCT STAT should be defaulted to A ACCT ADDRESS respective address as in ADDRESS column of MST BANKS table for the respective BANK ID USE IN TRADING should be defaulted to Y BANK NAME respec tive name as in NAME column of MST BANK table PREFFERED should be considered to be 1 if CASA account currency is equal to bank base currency and for other denominated accounts and any ongoing receipt of CASA accounts denominated in bank base currency would be defaulted to 0 PORTFOLIO ID CRM CLIENT BANK ACCT For deriving the portfolio id the logic should be as follows For non Heldaway Internal accounts from pms cli ent portfolio for a particular cli ent select the portfolio id as the portfolio whose Default Portfolio having the same portfolio type as mentioned in ref instrument type table for Instrument Type CASA The crm client bank account table would also store this same portfolio id for Asset accounts for easy reference and retrieval Bank
34. MSG xsd FCUBSSIService CloseSIContract IL CreatelLSweep Req Full MSG xsd FCUBSILService CreatelL Sweep IL ModifyILSweep Req Full MSG xsd FCUBSILService ModifylL Sweep IL CreatelLGroup Req Full MSG xsd FCUBSILService CreatelL Group IL DeletelL Group Req Full MSG xsd FCUBSILService DeletelL Group LC Contract Create Req Full MSG xsd FCUBSLCService CreateContract 6 100 ORACLE XSD names Services Operations LC CreateAmendConfirm Req Full MSG xsd FCUBSLCService CreateAmendConfirm BC CreateContract Req Full MSG xsd FCUBSBCService CreateContract BC CreateContract Req Full MSG xsd FCUBSBCService CreateContract BC CreateContract Req Full MSG xsd FCUBSBCService CreateContract LC CreateAmendConfirm Res Full MSGxsd FCUBSLCService CreateAmendConfirm LC ConfirmAmendConfirm Res Full MSG xsd FCUBSLCService ConfirmAmendConfirm CA CustAcc Bal Notify MSG xsd FCUBSCAService CA CustAccStat Notif xsd FCUBSCAService CGReject Notif MSG xsd FCUBSCGService CGStoppayment Notif MSG xsd FCUBSCGService TD NewAccount Notify MSG xsd FCUBSTDService FTContract Notif MSG xsd FCUBSFTService AccStmt Adhoc Query Req MSG xsd FCUBSAccFinService RequestAccStmt TDStmt Adhoc Query Req MSG xsd FCUBSTDFinService RequestTDStmt CA StopPaymentsNew Req Full MSG XSD CA CreateStopPayments Req Full MSG xsd FCUBSAccService CreateSto
35. Name as per the XML Updation in CRM CLIENT MASTER Client status If Frozen is Y then client status would be Frozen made as S provided if already available sta tus is A Or if Frozen is N then client status would be made as A provided the already available status for the client is S Broker Data The Broker data is handed off to FCPB using the XML format similar to Customer Creation The details of online notifications for Broker are given below Process Flow The following steps are involved in the process 1 online notification NOTIF CO CUSTOMER NEW broker and update the MST Broker table The Frequency of this notification would be one time migration and daily incremental The broker is created in FCUBS and sent to FCPB The notification message for broker creation would be same as of create customer If Customer Category is mentioned as BROKER then FCPB will identify the same as The modification notification XML message for broker modification would be same as of customer modification notification NOTIF CO CUSTOMER MOD FCPB Column Name Description FCUBS Element Name as per the XML Broker name MST BROKER First Name FULLNAME if FULLNAME not available then FIRSTNAME Broker code MST BROKER Broker code CUSTNO This tag would help in identify ing if the CIF Notification is of broker or not CCATEGORY In case of broker it would be broker or B
36. Name CCY Buy Price Units Buy Cost Market Price Market Value of Total Profit Loss Profit Loss Liquid ME INR 54 125 6 750 55 6 875 10 84 125 1 85 2 Liquid INR 55 1 028 56 540 55 S6 540 89 16 0 0 00 Total INR 63 290 63 415 100 125 0 2 Note e sub constituent information can be seen by clicking on the instrument name hyperlink by clicking on the Market Value hyperlink the source details are provided e Industry Market Capitalization analysis is only for Equity and not other asset classes The investment portfolio of the customer is then displayed in the accounts summary section in the Integrated dashboard 42 ORACLE 5 1 5 2 5 Oracle FCDB FCPB Interface Introduction Oracle FLEXCUBE Direct Banking Oracle FLEXCUBE Private Banking integration allows Oracle FLEXCUBE Direct banking business user to view and manage their investment portfolio available with Oracle FLEXCUBE Private Banking application using Single Sign On SSO with Oracle FLEXCUBE Direct Banking application Hence the business users shall be able to access FCPB application through FCDB login This functionality is only available to the Retail Customers of the bank This document mentions all the prerequisites required for this integration This SSO login enables the business user to access his wealth portfolio through Oracle FLEXCUBE Direct Banking within the same session Once Oracle FLEXCUBE Private Banking is launched fro
37. Term Deposit open TD NewAccount Notify MSG xsd UBS Alerts Term Deposit Status change Notifi cation UBS Alerts Funds Transfer Contract Notification FTContract Notif MSG xsd UBS Alerts Utility Payment Transaction Notifica UPTransaction Notif MSG xsd tion UBS Alerts Account Balance Notification CA CustAcc Bal Notify MSG xsd UBS Alerts Account Status Change Notification CA CustAccStat Notif xsd UBS Alerts Clearing Reject Notification CGReject Notif MSG xsd UBS Alerts Stop Payment Notification CGStoppayment Notif MSG xsd UBS Alerts Term Deposit open TD NewAccount Notify MSG xsd UBS Alerts Term Deposit Status change Notifi cation UBS Alerts Funds Transfer Contract Notification FTContract Notif MSG xsd UBS Alerts Utility Payment Transaction Notifica UPTransaction Notif MSG xsd tion ORACLE 8 Function ID Glossary G M GIDIFIDP seres 2 MSDQUEUE 57 GWDEXSYS 56 8 1 ORACLE
38. This Inquiry function allows No Inquiry the Seller to specify the Draw down Amount required for Financing from the bank The Drawdown details are e mailed to the pre notified e mail ids of the Bank User s Stock Agent This function allows user to No Transaction view investors transaction Inquiry over the accounts Investor s This function allows user view No Account Inquiry account balance details of his investors Investor s This function allows user view No Account Open account opening status of his ing Inquiry investors Initiate Letters of This function allows user to ini No Letter of Credit Credit tiate issuance of Letter of Credit 6 24 ORACLE Transaction Transaction Description Administration Oracle FLEXCUBE Name Transaction UBS Module Amend Letters This function allows user to ini No Letter of Credit Credit tiate amendment to Letter Of Credit View Import Let This function displays the No Letter of Credit ters of Credit Import Letter of Credits View Export Let This function displays export No Letter of Credit ters of Credit letter of credit Attach Docu This function allows user to No ments attach the trade related docu ments The attached documents are maintained in the FCDB data base and a FCDB administra tive user can view the documents View Attached This function allows user to Yes Documents view the attached tra
39. This function displays the No Corporate Details summary and details of Term Deposits deposit accounts contracts held by user Open Contract This function allows user to No Corporate Deposit open new Term deposit Deposits Account Contract 6 17 ORACLE Transaction Transaction Description Administration Oracle FLEXCUBE Name Transaction UBS Module Open Term This function allows user to No Retail Term Deposit Islamic open new Term Deposit Deposits Account The new accounts can be opened with Single or Joint ownership Amend Term This function allows user to No Retail Term Deposit Islamic amend the maturity and inter Deposits est instructions of existing Term deposit Account Redeem Term This function allows user to No Retail Term Deposit Islamic redeem an existing term Deposits deposit Source Benefi This transaction allows bank Yes ciary Linkage administrator to map a debit beneficiary account for a source account This mapping is used for fixed domestic funds transfer by business user As per this requirement a source can be mapped with only one beneficiary account Global Benefi This transaction allows the Yes ciary Mapping bank administrator to map restricted beneficiaries to busi ness users SEPA Card Pay This function allows user to No ments payment using a credit card through SEPA network Demand Draft This function allows user to No Demand Draft request for a do
40. and triggers the handoffs to FCPB As a part of this interface the following files will be generated whenever the customer segmentation status is upgraded Customer File FCUBS will generate outgoing files for the upgraded customers and the account details of the corresponding primary account holder will be handed off to FCPB Customer Account File FCUBS will generate outgoing files for the CASA accounts of the upgraded customers and the corresponding open accounts will be handed off to FCPB Customer Balances CASA File FCUBS will generate outgoing files for the CASA accounts and the balance of the upgraded customers The balance details of the corresponding open accounts will be handed off to FCPB Customer Balances Loan File FCUBS will generate outgoing files for the Loan accounts and the balance of the upgraded customers The active loans of the corresponding customers will be handed off to FCPB Customer TD Booked amp Rollover File FCUBS will generate outgoing files for the TD accounts which underwent the following changes as of segmentation date Booked Rollover Partial Redemption The following details are sent to the FCPB Details of all open TD accounts Partial redeemed TD details TD renewal details Customer TD Interest Liquidation Penalty File Segment Upgrade Details FCUBS will generate outgoing files at BOD for the TD accounts undergoing the following changes as of segmen
41. end of day operations Once a customer gets upgraded as per the segmentation rules FCUBS generates a handoff file to FCPB Subsequently the customers will receive an online notification The system generates the following handoff files during EOD operations The Customer Master File This file contains the following information related to FATCA e Information available in the FATCA related fields e field information related to Director in the existing customer master file will be removed as part of the batch Such details will form a part of the Directors hand off file The interface code for Customer Master File UBS SEG CUSTOMER CSV is IFCUSSEG Directors File Any field information related to Director will form a part of the Directors hand off file This file supports one to many relationships between customer and directors The interface code for Directors UBS SEG AUTH SIGN CSV is IFCUSCOR Customer FATCA Classification File This file contains FATCA classification details of the customers The interface code for Customer FATCA Classification file UBS SEG CUST FATCA CSV is IFFATCA Processing Online Notifications FCUBS sends an online notification to Oracle FCPB at the following occasions e Creation of term deposit account in FCUBS e Premature withdrawal redemption before maturity date of the term deposit amount e Creation of customer accounts in FCUBS e Change in the balance in the customer accounts
42. folio which is used by FCDB to create FCPB jar This jar is added to FCDB server class path along with other external jars Message Process All the messages shared between FCPB and FCDB follow a specific XML format The following steps are involved 1 The incoming message sent from FCPB also has a specific XML format All the tags available in the request are mandatory The value for tag udfValue when tag udfName is fldextsystems must be PB 2 The response message is then sent from FCDB after session validations 3 After the response message is sent the customer folio response is received from FCPB Day 0 Parameters There are few DAY 0 parameters maintained for this SSO integration PARAMETER NAME PARAMETER VALUES lt identity gt lt usertype gt PWM EXTER FCPB Dashboard URL exposed by FCPB NAL URL lt identity gt lt user FCDB server port This is sent for authenti type gt PWM REMOTE_PORT cation lt identity gt lt user FCDB server IP address This is sent for type gt PWM REMOTE_ADDRESS authentication 9 ORACLE PARAMETER NAME PARAMETER VALUES lt identity gt lt usertype gt WEALTH_DIMEN TIONS_ID List of dimension s id which configured at entity and user type level identity WEALTH_DIMENTIONS_ID List of dimension s id which configured at entity level This is only check when there is no configuration at entity and user type level
43. function allows user to Locator loacte the nearest STM Branch based on the current location of the yser Financing This function allows user to No Details view all the relevant details of the Islamic finance accounts 6 45 ORACLE Transaction Administration Oracle Name Transaction Description Transaction FLEXCUBE UBS Module Own Account This function allows user to No Funds Transfer Transfers transfer funds between own FT CASA accounts within the bank Internal Trans This function allows user to No Funds Transfer fers transfer the funds to any other FT CASA account or GL account within the bank Domestic Trans This function allows user No Payments amp Col fers transfer the funds to accounts lections PC in other banks using domestic payment network Register Biller This function allows user to No Utility Payments register the Billers maintained UP in Oracle FLEXCUBE Univer sal Banking Module Pay Bills This function allows user to No Utility Payments pay the bills to registered bill UP ers Buy Funds This function allows user to No buy the mutual fund units of a mutual fund scheme Sell Redeem This function allows user to No Fund redeem the mutual fund units of a mutual fund scheme Switch Fund This function allows user to No buy the mutual fund units of a mutual fund scheme View Fund Port This function displays Mutual No folio fund portfol
44. get updated via online notifications Processes then get triggered to copy Settled Market Value from Market Value column in PMS PORTFOLIO HOLDINGS since CASA Instrument Type does not require any separate Settlement For Liabilities Balances which are being sent in the SEG PRODBL file while updating the Amount column in PMS Prod Bal table if the Amount provided in the Prod Bal file for LIABILITY type of Prod ID is a positive value it is updated with a negative sign in the Prod Bal table so that in the Networth portlet of Customer Dashboard it gets deducted from Investment Portfolio value to display the Total value Customer TD Deals File Upload Segmentation Upgrade Once a customer gets upgraded as per the segmentation rules FCUBS will generate an EOD file handoff for all customer TD deals to be uploaded into FCPB Following are the different File uploads which would be sent by FCUBS For TD three types of files would be received by FCPB as a result of Segmentation Upgrade BaEKaAgions Deals for new Bookings Partial Uplift and Rollovers called TD DEAL Since it is acommon format being proposed for all the 3 transaction types certain fields would be mandatory for specific Tran_types Example Spread is mandatory only for Booking Transaction Type and not for PAR or RNW Similarly Rollover Type is mandatory only for RNW transaction types Since these are post settled deals which are indicative of the fact that the advice has a
45. ini No Payments amp Col tiate a SEPA Credit Transfer lections PC International This function allows user to No Funds Transfer Drafts request for a International FT Draft MT 101 Trans This function allows user to No Funds Transfer fers send a MT101 request and FT instruct the account servicing institution to transfer funds to a third party account after debit ing an account maintained with them through SWIFT Stop Payment of This function allows a stop No Demand Draft Demand Draft payment request for a domes tic as well as international demand drafts issued earlier These transactions have to be processed offline and adminis trator needs to update the sta tus of the request ORACLE Transaction Administration Oracle Transaction Description Transaction FLEXCUBE UBS Module Stop Payment of This function allows a stop No Funds Transfer Wired Transfer payment request for a transfer wired earlier These transactions have to be processed offline and adminis trator needs to update the sta tus of the request Uk Payments This function allows user to ini No tiate Domestic Transfer options available in UK BACS CHAPS Faster UK Internal Remit This function allows user to ini No tance tiate transfer between accounts of different entity View Standing This function displays Stand No Funds Transfer Instructions ing Instructio
46. or call deposit instrument id and instrument type would be populated details in FCPB FS CASA JIncludeinhold ings Rel2 1 section 8 TRN DT Tran Date Yes Interest Liq uidation Date Pen alty Charg ing Date LCY AMOUNT Amount Yes Interest Penalty AC NO Indicates Dr Cr AcctNum NO ber n ignored AC CCY Amt YES RECORD STAT ignored NO 2 29 ORACLE MANDA SAMPLE FIELD NAME DESCRIPTION TORY REMARKS VALUES TRANSAC Tran Type Yes Interest TION TYPE Penalty Corporate Directors File Format The format of the corporate directors file is given below FCUBS MANDA FCUBS FIELD NAME DESCRIPTION TORY Column Table Name LINKED CLI External client id of cus YES CUSTOM STTM CUS ENT ID tomer ER NO TOMER FCPB CLI FCPB Client Id of cus NULL ENT ID tomer AUTH SIGN First Name of the author NO DIREC STT NAME ized signatory TOR NAM M CORP E DIRECTORS AUTH SIGN L Last Name of the author NO NULL NAME ized signatory AUTH SIGN D Date of birth of the NO NULL OB authorized signatory MOBILE COUN Mobile international NO 15 STT TRY CODE country code of the D NO M CORP authorized signatory DIRECTORS AUTH SIGN Mobile number of the NO MOBILE MOBILE authorized signatory NUMBER PH HOME CO Telephone international NO TEL IS STT UNTRY CODE country code of the D NO M CORP authorized signatory DIRECTORS
47. order to enable the interface you need to define the interface details for Oracle FCPB in FCUBS You can define the format details and properties of interface files using Interface Definition screen To invoke this screen type GIDIFTDF in the field at the top right corner of the Application tool bar and click the adjoining arrow button Interface Definition E3 Enter Query Branch Code Interface Type Incoming v File Mask CRC Required CRC Algorithm az CRC File Mask CRC File Path Justification Date Number Text Frequency Type Week Day Month Date Last Run Date Next Run Date External System az FormatType Fixed 7 File Path H Data Log Required Commit Fetch Frequency Date Format YYYYMMDD No Of Executions Day Duplication File Check Required For Current Date Padding Character Date Number Tex Pre Message AUDF Post Message AUDF Interface Code Delimiting Character When To Run Trigger Type Confirmation File Mask Confirmation File Path Incoming Function Id Processed File Mask Default Action On Override Outgoing Interface Incoming File Mask Log Output Parallel Process Parallel Process Confirmation File Required E Mandatory Manual New v Reject 7 Suppress Start Reference Parallel Process Required No
48. particular date for further processing Daily Accrued Interest on TD FCUBS uses CSV Format to send the daily accrued interest details 3 22 ORACLE 3 5 3 The processing logic for the same is mentioned below reaS hile Insertion in Respective Tables Format PMS PORTFOLIO HOLD PMS TD HOLDING DE INGS TAILS CUST NO Client ld Client Id SHORT NAME Ignored ignored ACC Sub portfolio id Sub Portfolio Id ACCOUNT CLASS Based on Account class Prod whether it is TD or call deposit instrument id and instrument type would be pop ulated details in FCPB FS CASA Includeinholdings Rel2 1 section 8 ACCRUED AMOUN Accrued Int Accr Int T ENT DATE Value Date LAST INT ACC DATE CCY Instrument_CCY Currency RECORD_STAT Ignored Account_Status PROD Ignored Ignored Penalty on TD applicable in case of pre mature partial withdrawal and pre mature complete withdrawal FCUBS supplies applicable Penalty details in the TD MATURITY file handoff itself It would be sent immediately in case of a pre mature full withdrawal not as part of EOD process But in case of pre mature partial withdrawal it would be sent as part of maturity EOD when the complete amount is withdrawn The processing logic is mentioned below Fields in File Format Insertion in Tables PMS_TRANSACTION for PEN txn CUSTOMER_NO Client Id CUSTOMER 1 Ignored ACC Sub portfoli
49. 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 Contents NER ionis PP 1 1 1 1 o iere ER o eni tal ee tl qe aat eo cani te SER 1 1 1 2 AUdIence ie cte it RE e EU teet et ue tesis 1 1 1 38 Documentation Accessibility 1 1 1 47 Orcus c E 1 1 1 5 Acronyms and 1 2 1 6 Terminology ht ee ee ati hints eda nnnm ian 1 2 13 Glossar coss eed e taedia e DEED eat 1 3 2 Oracle FCUBS FCPB Interface nna 2 1 2 1 ntfoductiOn z rede E epe EE UD itu tetas 2 1 2 1 1 Details Handed off from FCUBS to Oracle FCPB 2 1 2 2 Defining Interface Details for Oracle 2 2 2 2 1 Defining Component 2 3 23 FATCA Interface between Oracle FCUBS and 2 4 2 4 Processing Online Notifications 2 4 2 5 Defining Interface Details for Data 2 6 2 5 1 Term Deposit Maturity with Interest Liquidation 2 6 2 5 2 Daily Accrued Interest on Term
50. steps are involved in the process 1 online FCPB on the same The Frequency of this notification would be one time migration and daily incremental Whenever there is a pre mature withdrawal of the deposit amount FCUBS would notify The notif code to be used by FCUBS would be NOTIF ICREDM FCPB will insert the TD or CD transaction details for PAR type of transaction into PMS TRANSACTION Based on the notif code the system identifies the type and updates Tran Type in PMS TRANSACTION as PAR The Bid Ask Indicator for PAR transactions would be S which means Transaction Processor should handle PAR like a Sell transaction Since the amount received in the PAR transaction will be the Withdrawn principal the balance Principal will have to be calculated as balance previous balance from PMS TD HOLDINGS DETAILS withdrawal amount and updated in PMS PORTFOLIO HOLDING with Buy Cost and Market Value and all related fields like ACQ COST CL also reduced accordingly Also PMS TD HOLDINGS DETAILS to update fields like balance with the current balance principal after the partial withdrawal FCPB Column Name Description FCUBS Element Name as per the XML Updation in TRANSACTION TRAN TYPE to be defaulted to PAR Would be populated based on the xsd notification ser vice received from FCUBS AMOUNT REDEMPTION AMT VALUE DATE Tran Date CHECKERDT
51. table so that in the Networth portlet of Customer Dashboard it gets deducted from Investment Portfolio value to display the Total value Current Login 07 05 201 User HOHEAD Customer Financial Planning Order Mgmt Txn Mgmt Reports Tools My Workspace Logout Customer Dashboard 4 aad 2 655 775 00 175 000 00 ate Unrealized P L P L ROR Portfolio Value 0 00 0 00 48 175 00 23 62 63 00 0 00 0 00 0 00 Total INR 2 480 775 00 Self Managed si 0 00 7 Pending Deals Total INR 2 703 950 00 2 655 775 00 2 655 775 00 48 175 00 1 78 3 71 fPorfolobyInstrument Group OT ffssues Tasks lees fie Interaction System Alerts OUND NO PORTFOLIO ALERTS FOUND Segment Upgrade Downgrade Interfaces Whenever a customer is upgraded to PWM set of segments all his Accounts Balances TDs etc would be sent to FCPB as EOD File Handoffs For Retail Customers who have not been assigned a Segment or Upgraded even once no notifications or EOD File Handoffs would be sent to FCPB Also once a customer is downgraded the CIF Modification online interface would be sent by FCUBS to FCPB to inform about this downgrade In this case FCPB would update the Client_Status as S Suspended in CRM_CLIENT_MASTER table It also updates the newly introduced column Status_Description with description as Suspended due to Downgrade fro
52. the transactions available to the user and allows the user to understand the sitemap Yes Maintain Bulle tins This function allows the bank administrator to add and view bulletins Yes ORACLE Transaction Name Transaction Description Administration Transaction Oracle FLEXCUBE UBS Module Alerts Registra tion This function allows the bank administrator to register a user for various alerts Alerts are generated and based on spe cific event and send to the user User shall be able to register for both FCDB and Host spe cific alerts Registration data is main tained in FCDB Yes Register Reports This transaction allows the bank administrator to register the reports for both bank administrators as well as busi ness users for download view at a later stage Yes Map Reports To User This transaction allows the bank administrator to assign reports to business user User Manual Downloads This function allows the bank administrator to manage forms and user manuals for down loads Yes View Reports This transaction allows the bank administrator to register the reports for both bank administrators as well as busi ness users for download view at a later stage Yes Manage Timer Services This function allows bank administrator to set change timer services This is system maintenance transaction and any unexpected change m
53. user to register for personal reminders These reminders shall be saved registered at central repository at the Host third party provider No Interactions Mailbox Con versations Transaction allows all interac tion to be maintained in a cen tral repository Interaction includes all communication between the business user and bank users like customer services additional services grievances etc No Interactions 6 8 ORACLE Transaction Name Transaction Description Administration Transaction Oracle FLEXCUBE UBS Module Mailbox Alerts Transaction allows all interac tion to be maintained in a cen tral repository Interaction includes all communication between the business user and bank users like customer services additional services grievances etc No Interactions Mailbox Tasks Transaction allows all interac tion to be maintained in a cen tral repository Interaction includes all communication between the business user and bank users like customer services additional services grievances etc No Interactions Mailbox Attach ment Facility to enable users to attach files to the mail being sent This enhancement is available across the Internet Mobile and Tablet banking channels No Interactions Account Details This function displays the account details like Account Holder details Product details Account Paramet
54. vw cloutstanding bal FCC vw CLiInstall mentPaidUnpaid 6 94 ORACLE Transaction Transaction Database Views XSD names Group Name Islamic Financing Financing Settle fcc vw clfrequency ment fcc vw claccount fcc vw cloutstanding bal fcc vw clprinperyear fcc vw clintperyear fcc vw clinterest fcc vw clinstallment fcc vw clarrearamt fcc vw clliq VW CLinstall mentPaidUnpaid fcc vw cltb acct ad v payment fcc vw clt CI CreatePay b amount paid ment Req Full MSG xsd Islamic Financing Financing fcc vw cltxnaccoun Account Activity tactivity fcc vw claccount Islamic Financing Financing Profit fcc vw clloanrates Rates Inquiry 6 3 22 Oracle FLEXCUBE Direct Banking Retail Mutual Funds Mutual Funds The transactions and the respective database view XSD are as follows Transaction Group Transaction Name Database Views XSD names Mutual Funds Fund Statement Request Mutual Funds View Portfolio Mutual Funds Fund Information Mutual Funds Buy Mutual Fund Mutual Funds Redeem Mutual Funds Mutual Funds Switch Mutual Fund Mutual Funds Order Status Mutual Funds Fund Activity 999 ORACLE 6 3 23 Transaction Group Transaction Name Database Views XSD names Mutual Funds Dividend Information Oracle FLEXCUBE Direct Banking Originations Originations The transact
55. wish to authorise the transaction No 6 30 ORACLE Transaction Name Transaction Description Administration Transaction Oracle FLEXCUBE UBS Module Reissue Trans action Password This function allows user to send a request issuing trans action password These transactions have to be processed offline and adminis trator needs to update the sta tus of the request No Activate Debit Card This function allows user to send a request to activate the debit card These transactions have to be processed offline and adminis trator needs to update the sta tus of the request No Apply for ATM Debit Card This function allows user to send a request for ATM Debit Card issuance These transactions have to be processed offline and adminis trator needs to update the sta tus of the request No Reset ATM Debit Card PIN This function allows user to send a request for changing the ATM Debit Card Pin change These transactions have to be processed offline and adminis trator needs to update the sta tus of the request No Hotlist Debit card This function allows user to send a request to host list a debit card These transactions have to be processed offline and adminis trator needs to update the sta tus of the request No Account Closure This function allows user to send a request for closing an account These transactions
56. Administration Oracle Name Transaction Description Transaction FLEXCUBE UBS Module Bulk File This function allows bulk Yes Payments amp Col Uploads upload of domestic transfers lections PC Domestig Mans The authorisation types sup fer ported are 1 File level Auth File Level Reject 2 Record Level Auth Record Level Reject Bulk File This function allows bulk Yes Funds Transfer Uploads Inter upload of international trans FT national Funds fers The authorisation types sup ported are 1 File Level Auth File Level Reject 2 Record Level Auth Record Level Reject Bulk File View This function allows user to Yes view the bulk files uploaded Change Limits This function allows user to No change the existing limits allot ted by the bank Ad hoc State This function generates No ment Request account statement request for Loans Loans and Islamic Finance account for a specified period Transaction This function allows user to No REHvIUIGS View Initiated Transactions View Use Drafts amp Templates Register for This function allows the user No MT940 Account to register for the accounts for Statements which they wish to view MT 940 account statement The account is registered in FCDB only The same account need to be registered in Host for getting MT940 statement View MT940 This function allows user to No SWIFT Statements view the MT 940 statement received by him The registr
57. CDB and FCPB Oracle FLEXCUBE Universal Banking Direct Banking Integration explains the prerequisites required for the integration of FCUBS and FCDB It also describes various types of information that are in the scope of integration and the channels through which such information are processed Chapter 6 Oracle FLEXCUBE Direct Banking Universal Banking Notifications con Chapter 7 tains the list of notifications Function ID Glossary has alphabetical listing of Function Screen ID s used Chapter 8 in the module with page references for quick navigation 1 5 Acronyms and Abbreviations Abbreviation Description System Unless and otherwise specified it shall always refer to Oracle FLEX CUBE Universal Banking Solutions system FCUBS Oracle FLEXCUBE Universal Banking Services FCDB Oracle FLEXCUBE Direct Banking FCPB Oracle FLEXCUBE Private Banking EOD End of Day Licensee The LICENSEE is the Financial Institution Application Services Pro vider or the Bank which has licensed the Oracle FLEXCUBE Direct Banking application and shall rollout the solution to its customers as an internet and or mobile banking channel Implementer The IMPLEMENTER is the Implementation Partner Vendor Application Service Provider or the LICENSEE themselves who is responsible for rolling out configuring extending or developing on Oracle FLEXCUBE Direct Banking DB PB Oracle FLEXCUBE
58. DEFAULT STTM CUS 12 M MODE communication MEDIA TOMER mode CLIENT Client category YES CUSTOM STTM CUS 10 CATEGORY ER CATE TOMER GORY CLIENT Client Classifi YES CUST STTM CUS 20 CLASSIFI cation CLASSIFI TOMER CATION CATION MINOR Flag indicating YES MINOR STT 1 FLAG if minor M CUST PER SONAL BIRTH PLA Place of Birth NO PLACE OF STT 100 CE BIRTH M CUST PER SONAL COB COU Country of birth NO BIRTH CO BIRTH COUN 3 NTRY ID UNTRY TRY DOMICILE Domicile Coun NO D COUN STTM CUS 3 try details TRY TOMER SIG Visited US in VST US STT 1 NIF STY I last 3 years REV M CUST PER N USA YN SONAL 2 18 ORACLE FCUBS FIELD MANDAT LEN NAME DESCRIPTION ORY COLUMN TABLE NAME GTH NAME POA FLAG Power of Attor NO PA IS STT 1 ney flag If POA SUED M CUST PER flag is Y SONAL FCPB should consider the holder details and update Sig natory type in CRM AU THOR IZED SIGNAT ORY table as PA AUTH SIG NO PA HOLD STT 105 N FNAME _ M CUST PER First name of r E SONAL the Power of Attorney Holder AUTH SIG Last name of NO NULL N LNAME the Power of Attorney Holder AUTH SIG Date of birth of NO NULL N DOB the Power of Attorney Holder AUTH SIG Mobile interna NO NULL N MOBILE tional country code of the guardian Power of Attorney Holder AUTH SIG Mobile number NO NULL N HOME of the Power of Attorney Holder PH
59. Deactivation of Credit Card Credit Cards Supplementary Card Request Credit Cards Activate Credit Card 6 3 20 Oracle FLEXCUBE Direct Banking Retail External Payment Interface Ex ternal Payment Interface The transactions and the respective database view XSD are as follows Iransueuen Transaction Name Database Views XSD names Group External Payment Merchant Mainte fcc mstaccount Interface nance fcc vw sttb ac count External Payment External Payment FTContract Create Interface Req Full MSG xsd 991 ORACLE 6 3 21 Oracle FLEXCUBE Direct Banking Retail Loans Loans The transactions and the respective database view XSD are as follows Transaction Group Transaction Name Database Views XSD names Conventional Loans Loan Details fcc vw clfrequency fcc vw claccount fcc vw cloutstanding bal fcc vw clprinperyear fcc vw clinterest fcc vw clinstallment fcc vw clarrearamt fcc vw clliq FCC VW CLInstall mentPaidUnpaid fcc vw cltb acct ad v payment fcc vw clt b amount paid Conventional Loans Loan Schedule fcc vw clschedule fcc vw vw CLiInstall mentPaidUnpaid Conventional Loans Loan Repayment Inquiry fcc vw claccount FCC vw clliqcomp settled fcc vw clliq fcc vw cloutstanding bal vw CLiInstall mentPaidUnpaid 6 92 O
60. Deposits scheme additional details of the scheme are displayed Term Deposit This function displays transac No Retail Term Activity tion happened in the Term Deposits deposit account for specified Structured search criteria The activity Funds Deposits can be downloaded in PDF CSV format Open Term This function allows user to No Retail Term Deposit Con open new Term Deposit Deposits ventional Account The new accounts can be opened with Single or Joint ownership Amend Term This function allows user to No Retail Term Deposit Con amend the maturity and inter Deposits ventional est instructions of existing Term deposit Account Redeem Term This function allows user to No Retail Term Deposit Con redeem an existing term Deposits ventional deposit Structured This function allows user to No Structured Deposit Sub subscribe for Structured Term Funds Deposits scription Deposit schemes opened for subscription by bank 6 35 ORACLE Transaction Administration Oracle Transaction Description Transaction FLEXCUBE UBS Module View Subscrip This function displays the No Structured tion Status structured Term deposit sub Funds Deposits scription status like whether Subscription amount is blocked Term deposit is cre ated etc Contract Deposit This function displays the No Corporate Details summary and details of Term Deposits deposit accounts contr
61. Direct Banking Oracle FLEXCUBE Private Bank ing SSO Single Sign On 1 6 Terminology The following terms and terminology is used within the documents to explain underlying processes components actions actors etc Ve ORACLE Term Definition Business A Business Service or a Transaction Service is a coarse grained compo Service nent that delivers a particular service contract The Service Interfaces and that make up the contract are each implemented by their particular Service Endpoints POJO A Plain Old Java Object POJO is exactly what it says The term is used to differentiate these simple objects from more specific or complex types such as EJB classes For example when creating an EJB a specific class must implement the Session Bean interface However that class will often delegate much of its functionality to one or more POJOs to aid maintainability and reuse of func tionality Service A Service Implementation is a concrete implementation of a Service Inter Implemen face tation or Service Endpoint Service A Service Interface is a cohesive set of Service Methods that are grouped Interface together in the anticipation that they will be commonly used together by a consumer For example the Service Interface for the Funds Transfer Service would contain a set of Service Methods that perform different types of immediate money transfer between two accounts Service A Service
62. E JntrodUctionsss s eie ie oe die ide etie eii RM aa dE 5 1 5 2 Session Management zirraren aaa I A EE R AEAEE AAE AEEA RENKO EAEE 5 1 53 Customer Follo e d N A ri A dde 5 2 5 4 Message PrOCeSS caste sagas rea do tocado arp Fe ge dons 5 2 5 5 Day 0 Parameters eed dene 5 2 6 Oracle FLEXCUBE Universal Banking Direct Banking Integration 6 1 o Antroduction c i reete en eot ea 6 1 6 1 1 Additional seen 6 53 6 1 2 Communication Channels syprina 6 55 6 2 Maintenarices iiie e eet Haniel 6 56 6 2 1 Maintaining External Systems sse nnne 6 56 6 2 2 Maintaining 6 56 6 3 Processing Messages 6 57 6 3 1 Oracle FLEXCUBE Direct Banking Base Core 6 58 6 3 2 Oracle FLEXCUBE Direct Banking Corporate Customer Services 6 61 6 3 3 FLEXCUBE Direct Banking Corporate Transfer and Payments 6 64 6 3 4 FLEXCUBE Direct Banking Corporate Account Inquiries 6 67 6 3 5 FLEXCUBE Direct Banking Corporate Bill Payments 6 68 6 3 6 FLEXCUBE Direct Banking Corporate Bulk Payments 6 68 6 3 7 FLEXCUBE Direct Banking Corporate Term Deposits 6 69 6 3 8 Oracle FLEXCUB
63. E Direct Banking Corporate Cash Management Cash Manage ment 6 71 6 3 9 Oracle FLEXCUBE Direct Banking Corporate Factoring E Factoring 6 71 6 3 10 FLEXCUBE Direct Banking Corporate Foreign Exchange Foreign Exchange 6 72 6 3 11 Oracle FLEXCUBE Direct Banking Corporate Loans Loans 6 72 6 3 12 Oracle FLEXCUBE Direct Banking Corporate Supply Chain Financing Supply Chain 6 75 6 3 13 Oracle FLEXCUBE Direct Banking Corporate Trade Finance Trade Finance 6 76 6 3 14 Oracle FLEXCUBE Direct Banking Retail Customer Services 6 80 6 3 15 Oracle FLEXCUBE Direct Banking Retail Bill Payments 6 84 6 3 16 Oracle FLEXCUBE Direct Banking Retail Bulk Payments 6 84 6 3 17 Oracle FLEXCUBE Direct Banking Retail Account Inquiries 6 85 6 3 18 Oracle FLEXCUBE Direct Banking Retail Transfer and Payments 6 85 6 3 19 Oracle FLEXCUBE Direct Banking Retail Credit Cards Credit Cards 6 90 6 3 20 Oracle FLEXCUBE Direct Banking Retail External Payment Interface External Payment Interface 6 91 6 3 21 Oracle FLEXCUBE Direct Banking Retail Loans Loans 6 92 6 3 22 Oracle FLEXCUBE Direct Banking Retail Mutual Funds Mutual Funds 6 95 6 3 23 Oracle FLEXCUBE Direct Banking Originations Originations 6 95 6 3 24 Oracle FLEXCUBE Direct Banking Retail Corporate Term Deposits 6 97 6 4 Services and Operations
64. EXCUBE Private Wealth Management screens Wealth Management tab would be provided on the FCDB Customer dashboard which will allow a wealth management customer to access the FCPB application The integrated system will also provide the aggregated holdings of the customer from the FCPB system under each investment category Rules for Single Sign On from Oracle FCDB to FCPB 1 Session Management will remain independent between FCPB and FCDB i e Once the user navigates to FCPB system from FCDB system FCPB session will be created and managed by FCPB There would be no inter dependency of sessions on either of systems 2 The customers will not be able to access FCDB transactions when logged into FCPB 3 While enabling a customer for private wealth management in host UBS the relevant CIF details will be sent to the FCPB system as EOD file handoff as explained in FCPB FCUBS interface details 4 If due to any reason synchronization of customers enabled for Wealth Management access between FCPB amp host system FCUBS is not available and business user tries to access the PWM menu via FCDB the session will be forwarded to FCPB and FCPB will display the error messages 5 You are not authorized to view the Wealth Management Portfolio Please contact the Bank s Administrator for more details 6 FCPB will have a one to one mapping between UBS customer id and user id in FCPB application FCPB System will authenticate and dis
65. FCPB there would be no separate file to be sent specially for Segmentation Upgrade The same process of sending Accrued Interest file as explained in earlier section on Daily Accrued Interest on TD would be sent to capture the Accrued Interest by FCPB FCUBS will only send Active TDs as part of Segmentation Upgrade handoffs No Accrued Interest for Closed Matured TDs would be sent Subsequent lifecycle of these deals will be via online notifications as is present today Customer Online Notification Segmentation Downgrade Once a customer gets downgraded as per the segmentation rules FCUBS will generate an online Customer Modification notification with the status as D or Downgraded Even if a customer gets downgraded subsequent flow of deal information account notifications balances notifications will continue to flow into FCPB from FCUBS After a downgrade FCPB would update the Client Status as S for Suspended in CRM Client Master and default a newly introduced column in CRM Client Master called Status Description with Suspended due to Downgrade from Core Banking System Suspended customers in FCPB are not allowed to place orders or trade i e place Deals though their Portfolio Details can be viewed via Portfolio Maintenance Analysis screens etc Once a customer gets downgraded it may also happen that the same customer gets re upgraded later In such cases though FCUBS would send the online notification of re upgrade v
66. FCPB using Field Access Controller The FAC framework of FCPB also supports you to maintain certain fields as Mandatory or Non Mandatory for Demographics screen Fields which are mandatorily from FCUBS should be setup as Mandatory in FCPB via FAC screen for Demographics Similarly fields which are non mandatory or not available in FCUBS need to be setup as Non Mandatory in FCPB via FAC screen for Demographics Such fields need to be updated by the RM in FCPB via Demographics screen with the actual values The following fields in FCPB are not available in FCUBS e Occupation e Communication Mode e Preferred Language for Statement e Introducer Name e Contact Number e Client Notes e Zip e State e Taxld e Gender e Client Classification e Location Restriction to Modify FCUBS Fields using Field Access Controller You are not allowed to modify the fields that are mandatorily received from FCUBS like Customer Name Address Status Segment etc However you can modify the fields which are exclusively maintained by FCPB fields which are not maintained by FCUBS like Client as ORACLE Entity Hobbies Preferred Communication Mode etc The Implementer handles this using the Field Access Controller Framework of FCPB EOD Master User Admin Authorization Reports My Workspace Logout Master Bank Related Field Access Controller r Im r n v m r ri r v r m
67. Full MSG xsd Transfer and Pay ments Demand Draft DDTransaction Cre ate Req Full MSG xsd Transfer and Pay ments International Transfers FTContract Create Req Full MSG xsd Transfer and Pay ments International Drafts FTContract Create Req Full MSG xsd Transfer and Pay ments View Demand Draft fcc vw istm in str txn fcc vw con tract master Transfer and Pay ments Stop Payment of Demand Draft fcc vw istm in str txn fcc vw con tract master Transfer and Pay ments Stop Payment of Wired Transfer Transfer and Pay ments Uk Payments Transfer and Pay ments View Standing Instructions fcc vw standing in str details Transfer and Pay Cancel Standing fcc vw standing in PC ClosePCMaint ments Instructions str details Req Full MSG xsd SIContract Close Req Full MSG xsd Transfer and Pay View Pending fcc vw pending ments Transfers transfer 6 86 ORACLE Transaction Group Transaction Name Database Views XSD names Transfer and Pay ments Cancel Pending Transfers FTContract Cancel Req FullMSG XSD For Own Internal Inter national and Interna tional Draft PCContract Reverse Req Full MSG xsd For Domestic SEPA Move Money Out and Move Money In Virtual Banking Linked Account Setup ST ModifyCustomer Req Full MSG xsd Virtual Banking Mov
68. HOME Telephone PA HOLD STT 10 COUN Code of home ER TEL IS M CUST PER TRY CODE telephone num D SONAL ber of the Power of Attor ney holder AUTH SIG Telephone NO PA HOLD STT 20 N HOME number of the ER TELN M CUST PER Power of Attor SONAL ney holder AUTH SIG Tax identifier of NULL 15 N TAX ID the Power of Attorney Holder 2 19 ORACLE FCUBS FIELD MANDAT LEN NAME DESCRIPTION ORY COLUMN TABLE NAME GTH NAME AUTH SIG Relationship of NO NULL 5 N REL the Power of Attorney Holder AUTH SIG Type of the NO NULL 3 N TYPE Power of Attor ney Holder AUTH SIG Country of the NO NULL 20 N DOMI Power of Attor CILE ney Holder NATIONALI Nationality PA HOLD STT 3 TY COUN Country ID of ER NA M CUST PER TRY CODE the Power of TIONALTY SONAL Attorney holder AUTH SIG Address of the PA HOLD STT 105 N AD Power of Attor ER ADDR M CUST PER DRESS ney holder SONAL AUTH SIG Address Coun PA HOLD STT 3 N COUN try ID of the ER AD M CUST PER TRY Power of Attor DR COUN SONAL ney holder TRY LOCATION Location code NO NULL details of cus tomer EXT PORT UBS Invest NO PORTFO SETM PORTFO 16 FOLIO ID ment portfolio LIO ID LIO MASTER ID REG COU Registered NO R COUN STT 3 NTRY ID country for the TRY MS CUST COR corporate PORATE INCORP C Incorporated NO INCORP C STT 3 OUN country for the OUNTRY MS CUST COR TRY ID corporate PORATE
69. Instructions agement Create Parent This function allows creating No Integrated and Group Link Cash Management instruction Liquidity Man age group and mapping the cash agement management instructions Unmark account This function allows to Delete No Integrated as Parent Parent account linkage from Liquidity Man the Group agement Assignment This function displays the list No Enquiry of Invoices which are assigned by the seller Credit Limit This displays the details ofthe No Enquiry Credit Limits provided to differ ent Buyers by the Seller s Bank Financing This displays the list of No Enquiry Invoices which are financed by the bank under various Factor ing products Invoice Enquiry This displays the list of No Invoices presented to the bank by the Seller Repayment This displays the list of No Enquiry Invoices which are financed by the bank under various Factor ing products Initiate Deal This function allows user to No FOREX Booking book a Spot or Forward deal for Buying or Selling Currency View deals This function allows user to No FOREX view the deals booked earlier Deals in Cross This function allows user to No FOREX Currency Trans book a Spot or Forward deal actions for Buying or Selling Currency Loan Details This function displays the No details of the selected loan account like loan product details disbursed amount outstanding balance details Consumer Lend ing 6 22 ORACLE
70. L and beneficiary fails to register in a given period then this interface is used to reverse the credited amount to the customer s account 6 53 ORACLE Transaction Interface Operation Request Interface Description Name Peer to Peer Release Working While initiating the pay Payment Hold If ben througha ment if the transaction eficiary timer amount was blocked and doesn t reg the beneficiary fails to isters in register in a given period given num then this interface is ber of days used to unblock the held amount Peer to Peer Unsubscribe RRUPBO2 For unsubscribe peer ClosePTPBen Payment Beneficiary beneficiary Peer to Peer Modify Peer P2P_MOD Business user can mod ModifyPTP Payment Beneficiary IFY BENE ify beneficiary account Ben details Admin can mod ify email and mobile number Peer to Peer P2P Benefi Check whether given Payment ciary details P2P BENE email id exists at the DETAIL UBS end If yes Fire reo pens Bene else create Bene Peer to Peer P2P create P2P CRE Create Bene CreatePTP Payment Bene ATE BENE Ben Peer to Peer P2P Reo P2P REO Reopen Bene ReopenPTP Payment pen Bene PEN BENE Ben Peer to Peer P2P P2P RE Release amount hold CreatePC Payment RELEASE LEASE AM Contract AMOUT OUT BLOCKEDs BLOCKED If bene Registers within given period of time Peerto Peer P2P DEBIT P2P DEB Debit GL amp
71. Ll Total GBP 93 894 85 495 05 2 697 4 TD Modification The details of TD Modification Notifications are given below Process Flow The following steps are involved in the process 1 Ifan incorrect interest rate is entered by the operations person in FCUBS while booking a TD the same can be corrected in FCUBS by invoking the TD Booking screen This triggers a TD modification event which is sent via an XML interface to FCPB The Notification Code for such an operational modification event is NOTIF CODE NOTIF TDMOD PB NOTIF CODE 2 n 1 product preference screen ICDPRMNT Main Interest Rate UDE field should be maintained mandatorily as TERM RATE UDE for FCUBS and FCPB integration This UDE TERM RATE would be referred by FCPB to pick up the Modified Rate in TD Modification XML and updated in FCPB s INT RATE column in PMS TD HOLDING DETAILS FCPB Column Name Description FCUBS Element Name as per the XML PMS TD HOLDINGS DETAILS MATURITY DATE MATDT INT RATE UDE with value TERM RATE TENO DFTENOR Therefore for any modification notification received from FCUBS it should refer to these columns and update it with approriate values shown in the XML for that particular CPIS CUSTNO ACC 99 ORACLE 3 4 10 TD Pre Mature Withdrawal 3 4 10 1 The details of Customer CASA Account Balances Notifications are given below Process Flow The following
72. Man Modify IL ModifyIlL Sweep agement Account Struc Req Full MSG xsd ture Cash Man View Account cc vw iltm account agement Structures Cash Man Create Parent fcc vw iltm group ac ILGroup IL CreatelL agement and Group count link Group Req Full Linkage MSG xsd fcc vw iltm group code Cash Man Unmark IL DeletelL Group agement account as Req Full MSG xsd Parent Oracle FLEXCUBE Direct Banking Corporate Factoring E Factoring The transactions and the respective database view XSD are as follows Transaction Group Transaction Name Database Views XSD names E Factoring Assignment Enquiry E Factoring Credit Limit Enquiry E Factoring Financing Enquiry E Factoring Invoice Enquiry E Factoring Repayment Enquiry 6 71 ORACLE 6 3 10 FLEXCUBE Direct Banking Corporate Foreign Exchange Foreign Ex change The transactions and the respective database view XSD are as follows Transaction Transaction Database Views XSD names Group Name Foreign Initiate Deal Book FXContract Create Exchange ing Req Full MSG xsd Foreign View deals fcc vw fxdeal de Exchange tails Foreign Deals in Cross FXContract Create Exchange Currency Transac Req Full MSG xsd tions 6 3 11 Oracle FLEXCUBE Direct Banking Corporate Loans Loans The transactions and the respective database view XSD are as follows Transaction Group Transaction Name Dat
73. Method takes the form of a Java method implemented by the Method Service Implementation and the Service Delegate The consumer of the service will invoke one or more Service Methods to help perform part of a business process Extension The Extension Schema is a term used for the separate database schema Schema as deployed by Oracle FLEXCUBE Direct Banking to allow IMPLEMENT ERS to extend the Oracle FLEXCUBE Direct Banking application as per their needs 1 7 Glossary of Icons This user manual may refer to all or some of the following icons Icons Function Exit El Add row 1 Delete row zl 7 Option List Te ORACLE 2 Oracle FCUBS FCPB Interface 2 1 Introduction Oracle FLEXCUBE Private Banking FCPB helps banks financial institutions and wealth management service providers deliver advisory driven solutions The services include portfolio management management of multiple asset classes and advisory services The interface between FCUBS and FCPB enables the exchange of information related to day to day transactions and maintenances FCUBS generates the required data for exchange in ASCII format and places the files in a predefined directory in the database server This directory is accessible by FCPB The data types permitted in a handoff file are given below Data Type Description Text Text fields can have alphanumeric characters as per the length
74. NT IT TYPE REF SEGMENT PBS LANGUAGE SUPPORT etc implementation team has to synch up with FCUBS and maintain Transaction Transformation in FCPB for such entities Role Setup in FCPB based on Segments Supported by the Bank Roles would have to be created for every segment which are mapped as Customer Role and the name of these roles would be identical to the Segment Whenever a customer is created in FCPB via the Create Customer XML from FCUBS a script is executed to auto create the Login Id of the customer and makes an entry in SMS APP USER table The Role given to the customer would be the same as his Segment after appropriate transaction transformation to FCPB s specific Segment Codes For supporting this Roles would have to be created for every segment which are mapped as Customer Role and the name of these roles would be identical to the Segment Segmentation Upgrade Files Since FCUBS has the capability to run multiple EODs in different branches and Head Office in order to avoid multiple Segmentation Upgrade Files being sent by each branch for same customer or even for different customers FCUBS has configured sending the Segmentation Upgrade files as part of Head Office s EOD Process only This process will therefore collate data for all newly upgraded customers across all Branches and send Customer Master Prod Bal Accounts CASA TD Deals in single consolidated files for each entity interface no matter where the TD Deal Account origi
75. No Statement Credit Card Statement Account Details This function displays the No CASA account details of selected CASA account 6 44 ORACLE Transaction Administration Oracle Name Transaction Description Transaction FLEXCUBE UBS Module Account Activity This function displays the No CASA account activity for specified search criteria for selected CASA Account Ad hoc State This function generates No CASA ment Request account statement request for CASA amp TD CASA account for a specified period Term Deposit This function displays details No Retail Term Details of the selected Term Deposit Deposits Structured Funds Deposits Redeem Term This function allows user to No Retail Term Deposit Con redeem an existing term Deposits ventional deposit Delete Biller This function allows user to No delete the biller registered ear lier Biller details are maintained in FCDB and deletion of a biller is also within FCDB Cheque Book This function allows user to No CASA Request request a chequebook Exchange Rate This function displays No FOREX Inquiry exchange rate between cur rency pairs Mail Box This function allows business No user interact with bank admin istrator user using FCDB inter nal messaging facility Corporate This function allows user to No Authorization authorise a transaction initi ated by another user of that customer ATM Branch This
76. ORACLE Oracle FLEXCUBE Wealth Management Interface User Guide Oracle FLEXCUBE Universal Banking Release 12 0 3 0 0 Part No E53393 01 April 2014 Oracle FLEXCUBE Wealth Management Interface User Guide April 2014 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 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 n
77. OfRecords No Of Parallel Process ComponentDetails Incoming File Names Input By Authorized By Date Time Date Time Modification Number You need to define the interface details External System L Authorized Open Specify code that identifies the external system The interface details defined on this Screen are applicable to the interface between FCUBS and the external system selected here For FCPB interface you need to specify FCPB as the external system Interface Code Specify a unique code that identifies the interface between the above external system and FCUBS Interface Type Select the interface type from the following options e Incoming Select this for interfaces that upload data into FCUBS 2 2 ORACLE 2 2 1 e Outgoing Select this for interfaces that facilitate handoff of data from FCUBS File Mask Specify the file mask for the outgoing interface file The system decides the name of the handoff file based on the file mask defined here Format Type Select the message format type Choose one of the following format types based on the data length e Fixed Select this format type if the interface data is within fixed width e Delimited Select this format type if the interface data is in delimited format If you select Delimited the system enables the field Delimiting Character File Path Specify the directory in which the interface file is stored
78. RACLE Transaction Transaction Database Views XSD names Group Name Conventional Loan Settlement fcc vw clfrequency Loans fcc vw clac count fcc vw clout standingbal fcc vw clprinper yearfcc vw clintper year fcc vw clinter est fcc vw clinstall ment fcc vw clarrear amt cc vw clliq VW CLinstall mentPaidUnpaid fcc vw cltb acct ad v payment fcc vw clt b amount paid Conventional Loan Account fcc vw claccount Loans Activity fcc vw cltxnaccoun tactivity Conventional Loan Interest fcc vw clloanrates Loans Rates Inquiry Conventional Loan Calculator CL Save AccSim Loans Req Full Msg xsd Conventional Mortgage Calcu MO Save AccSim Loans lator Req Full Msg xsd 6 93 ORACLE Transaction Group Transaction Name Database Views XSD names Islamic Financing Financing Details fcc vw clfrequency fcc vw fcc vw cloutstanding bal fcc vw clprinperyear fcc vw clintperyear fcc vw clinterest fcc vw clinstallment fcc vw clarrearamt fcc vw clliq VW CLinstall mentPaidUnpaid fcc vw cltb acct ad v payment fcc vw clt b amount paid Islamic Financing Financing Sched ule fcc vw clschedule fcc vw claccount FCC vw CLiInstall mentPaidUnpaid Islamic Financing Financing Repay ment Inquiry fcc vw claccount FCC VW clliqcomp settled fcc vw clliq fcc
79. SD names Group Customer Transaction Activities Services Customer Register for MT940 fcc vw pctb con Services Account Statements tract master Customer View MT940 State fcat vw swift bic Services ments directory fcc vw d ly msgs in 940 Customer Exchange Rate fcc vw mstfxrate Services Inquiry Customer Alerts Registration fcat vw mstcorpo Services rate fcc vw mstac count Customer E Statement Sub fcc vw acct estate MS ModifyMSAccAdd Services scription ment details Req Full MSG xsd MS CreateMSAccAdd Req Full MSG xsd IA ModifylACustAcc Req Full MSG xsd ST ModifyCustAcc Req Full MSG xsd Customer Subscribe for other Services channels Customer Deactivate Channel Services User Customer Lock Transaction Services Password Customer Change Limits Services Customer Reissue Transaction Services Password Customer Request Processing Services Customer Open Additional fcat_vw_mst ST CreateCustAcc Req Services CASA Account branch fcc vw m Full MSG xsd Accounts stproductclasses fcc sttms accls c balances fcc st vw aclass currenci es Customer Register Reports fcat vw mstcorpo Services rate 6 62 ORACLE Transaction Transaction Name Database Views XSD names Group Customer Account Closure Services Customer Download Reports Services Customer Preferences Services Customer Account Preference Services Customer Session Summary Services
80. SO for Channels System Mainte nance Multilingual Data Input System Mainte nance Monitor Timer Ser vices Customer Mainte nance View Customer Transactions Core Corporate Administrator Customer Profile Core Corporate Administrator Authorisation Man dates Maintain User List Manage Rules Core Corporate Administrator Bulk Registration Core Corporate Administrator User BTID Map Core Corporate Administrator View Audit Log User Maintenance Terminate User Session User Maintenance Print Welcome Let ter Password Virtual Banking Customer Account Opening Manage ment Core Corporate Administrator Role maintenance Core Corporate Administrator User maintenance 6 58 ORACLE Transaction Transaction Name Database Views XSD names Group Role Maintenance Create Role Role Maintenance Modify Role Role Maintenance Delete Role Role Maintenance View Role User Maintenance Create User fcat vw mstcorpo rate User Maintenance Modify User fcat vw mstcorpo rate User Maintenance Activate User User Maintenance Deactivate User User Maintenance Lock User User Maintenance Unlock User User Maintenance Delete User User Maintenance Revoke User User Maintenance View User User Maintenance Reset password Custo
81. Ser Mail Box vices Customer Ser Electronic Form vices Customer Ser Form amp User Man vices ual Downloads Customer Ser Change Pass vices word Customer Ser Force Change vices Password Customer Ser Site Map vices Customer Ser Frequently Asked vices Questions Customer Ser News vices Customer Ser ATM Locator vices Customer Ser Branch Locator vices Customer Ser Ad hoc State AccStmt Adhoc vices Accounts ment Request Query Req MSG xsd CASA amp TD TDStmt Adhoc Query Req MSG xsd Customer Ser Stop and Unblock CA StopPayments vices Accounts Cheque Request New Req Full MSG XSD CA CreateStopPay ments Req Full MSG xsd Customer Ser Cheque Status fcc vw cheque sta vices Accounts Inquiry tus inquiry fcc vw cavw chck details fcc vw cat m stop payments Customer Ser Cheque Book fcc vw mstcorporate CA CreateCheck vices Accounts Request Book Req Full MSG xsd 6 82 ORACLE Transaction Transaction Database Views XSD Names Group Name Customer Ser Debit Card Details fcc vw mstbranch vicer AgcouniS fcc vw debit card master Customer Ser Open Additional fcat vw mstbranch ST CreateCustAcc vices Accounts CASA Account fcc vw mstproduct classes fcc stt ms accls ccy balanc es fcc stvw a class currencies Req Full MSG xsd Customer Ser vices Virtual Banking Online Customer and Account Opening fcc vw sttms linke dacc det
82. T DETAILS MICR CLVW LOAN MICR VARCHAR2 10 129 INT DETAILS RSLDVAL CLVW LOAN RESOLVED VAL NUMBER 22 139 INT DETAILS UE TENOR CLVW LOAN TENOR NUMBER 22 161 INT DETAILS ACCRAM CLVW LOAN ACCRAMT NUMBER 22 183 T INT DETAILS LTINACDT CLVW LOAN LAST INT AC VARCHAR2 10 205 INT DETAILS CR DATE AMTSTLD CLVW LOAN AMTSTLD NUMBER 22 215 INT DETAILS LTPMTDT CLVW LOAN LAST DT VARCHAR2 10 237 INT DETAILS ACTADD CLVW LOAN ACCT ADDRESS VARCHAR2 10 247 INT DETAILS HLDAMT CLVW LOAN HOLD AMOUNT NUMBER 22 257 INT DETAILS TRAILER VARCHAR2 3 1 Term Deposit Rollover FCUBS hands off the details of manual and automatic rollovers of term deposits to Oracle FCPB This handoff happens only for the customers whose segment code and segment status are defined in the system The Notification contains the following details of the TD accounts maintained in FCUBS e Branch e Deposit account number e Old maturity date New maturity date ORACLE 2 5 6 Renewal date Rollover type Total interest on the TD Principal Rollover amount Balance interest paid out during rollover Interest rate Tenor Customer number Currency Segmentation Status Information When a customer segmentation status is updated to Upgraded as per the segmentation rules FCUBS generates an End Of Day EOD and Beginning Of Day BOD files handoff for the corresponding customers
83. TER D BANK Bank VAR 16 YES CUST 20 STT ACCT account CHA M CUST A D id R NO CCOUNT account id PROD 1 product 5 YES PRO 4 CLTB_AC D id CHA DUCT COUNT_MA R _COD STER E BOOK booking DAT YES BOO 8 CLTB_AC YYYYM ING date E K_DA COUNT_MA MDD for DATE TE STER mat VAL value DAT YES VAL 8 CLTB_AC YYYYM UE date E UE COUNT MA MDD for DATE DATE STER mat AMOUN amount NUM 24 6 YES AMO CLTB AC T BER UNT COUNT MA FINA STER NCE D CCY ID Cur VAR 3 YES CUR 3 CLTB_AC rency CHA REN COUNT MA R STER MATU Maturity DAT NO MATU 8 CLTB_AC YYYYM RITY_ date E RITY COUNT_MA MDD for DATE _DAT STER mat E ACCT_ Account VAR 5 YES L 1 Default SUB sub type CHA Value L TYPE R Loan INT_RA interest NUM 24 6 NO UDE CLTB AC TE rate BER VALU COUNT UD E E VALUES TENOR tenor NUM 10 YES NULL CLTB AC BER COUNT MA STER 226 ORACLE FIELD DESCRI TYP MAN EGO FCC Table FCC NAME PTION E er DAT NG name Remarks H ORY UMN TH ACCR_I Accrued NUM 24 6 NO ACC CLTB_AC NT interest BER RUE COUNT_SC D_AM HEDULES OUN T LAST Last DAT NO EVEN 8 CLTB AC Last NT AC interest E T DA COUNT accrual CR paid TE ENTST DI event hap DATE ARY pened date INTER interest NUM
84. Transaction Administration Oracle Transaction Description Transaction FLEXCUBE UBS Module Loan Schedule This function displays repay No Consumer Lend ment schedule of selected ing loan account The repayment schedule contains the instal ment components like princi pal interest charges and outstanding instalment amount Loan Repayment This function displays various No Consumer Lend Inquiry repayments received for the ing selected loan account Loan Settlement This function allows partial or No Consumer Lend full pre payment of the ing selected loan account Loan Account This function displays the No Consumer Lend Activity transactions happened ing through selected loan account The transaction activity can be downloaded in PDF CSV Loan Interest This function displays interest No Consumer Lend Rates Inquiry rates for various loan prod ing ucts Loan Calculator This function displays sched No Consumer Lend ule for a loan amount for ing select interest Mortgage Calcu This function displays sched No Mortgage Loans lator ule for a loan under Mortgage for select interest Financing This function displays the No Consumer Lend Details details of the selected Islamic ing Islamic finance account like product details disbursed amount outstanding balance details Financing This function displays repay No Consumer Lend Schedule ment schedule of selected ing I
85. Upgrade files at EOD for Broker Thus resulting in a failure while uploading such Customer Segmentation Upgrade files in FCPB as this Broker as a customer is not created in FCPB SETUP Needed for Enabling Customer Creation Interface from FCUBS Mapping of Client IT Type Segment Status Client Classification and Client Category in FCPB FCPB has capability to define various types of Client IT Types like Individual Corporate NRI etc These values are to be maintained in FCPB with the same values that are being maintained at FCUBS during Implementation Similarly Client Category Client Status are also maintained suitably in REF Tables of both FCPB and FCUBS systems These tables are then synched up via Transaction Transformation screen so that FCPB s internal names and values are mapped to FCUBS s names The important tables and screens to be synched up between FCUBS and FCPB are mentioned below Tables Screen Name Navigation REF CLIENT SEG Client Segment Master CRM Related Client Seg ment REF CLIENT STATUS To be updated directly in the database REF CLIENT IT TYPE Client IT Type Master gt CRM Related Client IT Type REF CLIENT CLASSIFICATION To be updated directly in the database ORACLE REF CLIENT CATEGORY Client Category Master CRM Related Client Cate gory PREF LANG CODE To be updated directly in the database Handling of Mandatory fields in FCUBS and
86. User This transaction allows bank administrator to Unlock a locked user Yes Delete User This transaction allows bank administrator to Delete a user Yes 6 3 ORACLE Transaction Administration Oracle Name Transaction Description Transaction FLEXCUBE UBS Module Revoke User This transaction allows bank Yes administrator to Revoke a deleted user View User This transaction allows bank Yes administrator to view user details Reset password This transaction allows bank Yes administrator to reset pass word for a user Customer Pro This function allows bank Yes file Initiate administrator to create a cus tomer profile Modify Cus This function allows bank Yes tomer Profile administrator to modify a cus tomer profile Customer This function allows bank Yes Account Setup administrator to map accounts to a customer Linked Cus This function allows bank Yes tomer Account administrator to link two Setup accounts and map the accounts of the linked cus tomer User Account This function allows bank Yes Setup administrator to map accounts to a user View Customer This function allows bank Yes Profile administrator to view a cus tomer profile Disable Enable This function allows bank Yes Customer Profile administrator to lock Unlock a customer profile Maintain User This function allows bank Yes Lists administrator to maintain list of th
87. XCUBE UBS Module Cheque Book This function allows user to No CASA Islamic Request request a chequebook CASA Term Deposit This function displays details No Retail Term Details of the selected Term Deposit Deposits Account If deposit is created 4 Structured using a Structured deposit Funds Deposits scheme additional details of the scheme are displayed Term Deposit This function displays transac No Retail Term Activity tion happened in the Term Deposits deposit account for specified Structured search criteria The activity Funds D it can be downloaded in PDF CSV format Open Term This function allows user to No Retail Term Deposit Con open new Term Deposit Deposits ventional Account The new accounts can be opened with Single or Joint ownership Amend Term This function allows user to No Retail Term Deposit Con amend the maturity and inter Deposits ventional est instructions of existing Term deposit Account Redeem Term This function allows user to No Retail Term Deposit Con redeem an existing term Deposits ventional deposit Structured This function allows user to No Structured Deposit Sub subscribe for Structured Term Funds Deposits scription Deposit schemes opened for subscription by bank View Subscrip This function displays the No Structured tion Status structured Term deposit sub Funds Deposits scription status like whether Subscription amount is blocked Term deposit is cre ated etc Contract Deposit
88. YES ADDRESS STTM CUS 105 2 2 LINE3 TOMER ADDR_LINE Home Address YES ADDRESS_ STTM_CUS 105 3 3 LINE2 TOMER STATE State of the NO NULL ME Home address COUN Country of the YES COUNTRY STTM CUS 3 TRY HOME Home address TOMER ZIP HOME Zip code ofthe NO NULL Home address ADDR LINE Work Address 1 NO E AD STT 105 1 DRESS1 MS CUST PRO FESSIONAL ADDR LINE Work Address 2 NO E AD STT 105 2 DRESS2 MS CUST PRO FESSIONAL ADDR LINE Work Address 3 NO E AD STT 105 3 DRESS3 MS_CUST_PRO FESSIONAL STATE WO State of the NO NULL RK work address COUN Country of the NO NULL TRY WORK work address ZIP WORK Zip code ofthe NO NULL work address FAX FAX interna NO FAX IS STT 10 HOME tional country D NO M CUST PER UNTRY CO code SONAL DE FAX Fax Number NO FAX NUM STTM CUS 105 BER TOMER 2 17 ORACLE FCUBS FIELD MANDAT LEN NAME DESCRIPTION ORY COLUMN TABLE NAME GTH NAME NATIONAL Nationality If YES NATIONAL STTM CUS 3 ITY Customer type ITY TOMER STT is I Individ INCORP C MS CUST CORP ual Nationality OUNTRY ORATE required to be provided If Customer type is C Corporate Country of Incorporation to be provided LANGUAGE Preferred lan YES LAN STTM CUS 3 guage of the GUAGE TOMER customer CCY 1 Customer Cur YES PORTFO SETM PORTFO 3 rency LIO C LIO MASTER CY CODE PREF COM Preferable YES
89. a tions for viewing statement shall be done in the FCDB 6 29 ORACLE Transaction Name Transaction Description Administration Transaction Oracle FLEXCUBE UBS Module Exchange Rate Inquiry This function displays exchange rate between cur rency pairs No FOREX Alerts Registra tion This function allows the users to register for various alerts Alerts are generated and based on specific event and send to the user User shall be able to register for both FCDB and Host spe cific alerts Registration data is main tained in FCDB No E Statement Subscription This function allows user to subscribe unsubscribe for e statement The registrations details are maintained at FCUBS and the statement FCUBS generates and sends the statement as per registra tion details No CASA Islamic CASA Term Deposits Islamic Deposits Loans Islamic Loans Subscribe for other channels This function allows user to Subscribe for other available channel from Internet banking login Registration details are main tained in FCDB No Deactivate Channel User This function allows user to deactivate a channel tempo rarily for a predefined time period Details are maintained in FCDB No Lock Transac tion Password This function allows user to lock their own transaction password Allows the user to lock the transaction pass word if user do not
90. abase Views XSD names Loans Loan Details fcc vw clfrequency cc vw claccount fcc vw cloutstanding bal fcc vw clprinperyear fcc vw clinterest fcc vw clinstallment fcc vw clarrearamt fcc vw clliq FCC VW CLinstall mentPaidUnpaid fcc vw cltb acct ad v payment fcc vw clt b amount paid Loans Loan Schedule fcc vw clschedule fcc vw FCC vw CLiInstall mentPaidUnpaid 6 72 ORACLE Transaction Group Transaction Name Database Views XSD names Loans Loan Repayment Inquiry fcc vw FCC vw clliqcomp settled fcc vw clliq fcc vw cloutstanding bal FCC vw CLInstall mentPaidUnpaid Loans Loan Settlement fcc vw clfrequency fcc vw clac count fcc vw clout standingbal fcc vw clprinper yearfcc vw clintper year fcc vw clinter est fcc vw clinstall ment fcc vw clarrear amt fcc vw clliq FCC VW CLinstall mentPaidUnpaid fcc vw cltb acct ad v payment fcc vw clt b amount paid Loans Loan Account Activity fcc vw claccount fcc vw cltxnaccoun tactivity Loans Loan Interest Rates Inquiry fcc vw clloanrates Loans Loan Calculator CL Save AccSim Req Full Msg xsd Loans Mortgage Calcu lator MO Save AccSim Req Full Msg xsd 6 73 ORACLE Transaction Group Transaction Name Databa
91. account for all transactions My Accounts This function displays the No CASA Retail summarized view of the Term Deposit accounts held by the cus Consumer Lend tomer ing Loans amp Deposits Module Financing This function allows user to No Details view all the relevant details of the Islamic finance accounts Own Account This function allows user to No Funds Transfer Transfers transfer funds between own FT CASA accounts within the bank My Cheques This function displays the No CASA cheques status Change Pass This transaction allows the No word business user to change their password 6 47 ORACLE Transaction Administration Oracle Name Transaction Description Transaction FLEXCUBE UBS Module Account Details This function displays the No CASA account details of selected CASA account Account Activity This function displays the No CASA account activity for specified search criteria for selected CASA Account Ad hoc State This function generates No CASA ment Request account statement request for CASA amp TD CASA account for a specified period Term Deposit This function displays details No Retail Term Details of the selected Term Deposit Deposits Structured Funds Deposits Redeem Term This function allows user to No Retail Term Deposit Con redeem an existing term Deposits ventional deposit Contract Deposit This function display
92. actions ised transactions in mobile banking Mailbox Attach Facility to enable users to No Interactions ment attach files to the mail being sent This enhancement is available across the Internet Mobile and Tablet banking channels Mailbox Attach Facility to enable users to No Interactions ment attach files to the mail being sent This enhancement is available across the Internet Mobile and Tablet banking channels International This function allows user No Funds Transfer Transfers transfer the funds to accounts FT in other banks in other coun tries Credit Card Pay This function allows the user No ments to pay the credit card dues Beneficiary This function allows user to No Funds Transfer Maintenance register for beneficiaries for later reuse for following pay ments transactions Internal Account Transfer International Account Transfer Domestic Fund Transfer The Beneficiary data is main tained in FCDB Payment and Collections 6 50 ORACLE Transaction Administration Oracle Transaction Description Transaction FLEXCUBE UBS Module My Scheduled With this transaction user shall No Funds Transfer Transfers be able to view both Pending Payment and Transfers and Standing Collections Instructions set on the account for all transactions Credit Card This function displays details No Details of the Credit cards hold by the user Cr
93. acts held by user Open Contract This function allows user to No Corporate Deposit open new Term deposit Deposits Account Contract Open Term This function allows user to No Retail Term Deposit Islamic open new Term Deposit Deposits Account The new accounts can be opened with Single or Joint ownership Amend Term This function allows user to No Retail Term Deposit Islamic amend the maturity and inter Deposits est instructions of existing Term deposit Account Redeem Term This function allows user to No Retail Term Deposit Islamic redeem an existing term Deposits deposit Global Benefi This transaction allows the Yes ciary Mainte bank administrator to Create nance modify and delete Generic and restricted beneficiaries The transaction also allows the bank administrator to delete public and private beneficiar ies by the business users Own Account This function allows user to No Funds Transfer Transfers transfer funds between own FT CASA accounts within the bank Internal Trans This function allows user to No Funds Transfer fers transfer the funds to any other FT CASA account or GL account within the bank Multiple Internal This function allows user to ini No Funds Transfer Transfer tiate the multiple internal transfer transactions from one screen FT 6 36 ORACLE Transaction Administration Oracle Transaction Description Transact
94. ails fcc vw pctb con tract master ST CreateCustomer Req Full MSG xsd ST CreateCustAcc Req Full MSG xsd ST ModifyCustAcc Req Full MSG xsd PCContract Create Req Full MSG xsd PC CreatePCCli entAgg Req Full MSG xsd ST ModifyCustomer Req Full MSG xsd Customer Ser vices Reminders Customer Ser vices Mailbox Conver sations Customer Ser vices Mailbox Alerts Customer Ser vices Mailbox Tasks Customer Ser vices Mailbox Attach ment 6 3 15 Oracle FLEXCUBE Direct Banking Retail Bill Payments The transactions and the respective database view XSD are as follows Transaction Group Transaction Name Database Views XSD names Bill Payments Register Biller fcc vw biller info Bill Payments Delete Biller 6 83 ORACLE Transaction Group Transaction Name Database Views XSD names Bill Payments Pay Bills Utility Payment Cre ate Req Full MSGxsd 6 3 16 Oracle FLEXCUBE Direct Banking Retail Bulk Payments The transactions and the respective database view XSD are as follows Transaction Group Transaction Name Database Views XSD names Bulk Maintenance Bulk Data Diction ary Bulk Maintenance Bulk Enrichment Definition Bulk Maintenance Bulk Template Definition Bulk Maintenance Bulk File Template Definiti
95. al Banking as per the account statement scheduling parame ter Account Over This function displays the No CASA Islamic view summarized Asset Liability CASA Retail view of the balances grouped Term Deposit under different Currencies of Islamic Term the accounts held by the cus Deposits Con tomer sumer Lending Loans Islamic finance amp Corpo rate Deposit Modules Consolidated This function displays the No CASA Islamic Position summarized Asset Liability of CASA Retail different type of relationships Term Deposit like CASA TD Loans Securi Islamic Term ties Shares Options and Deposits Con trade instruments of the sumer Lending mapped customers The func Loans Islamic tion also provide graphical finance amp Corpo representation of asset and rate Deposits liabilities Module Trade Finance CASA Interest This function displays the No Rate Inquiry interest rate for Savings prod ucts ORACLE Transaction Administration Oracle Transaction Description Transaction FLEXCUBE UBS Module Register Biller This function allows user to No Qualification not register the Billers maintained required FCDB in Oracle FLEXCUBE Univer transaction sal Banking Module Delete Biller This function allows user to No delete the biller registered ear lier Biller details are maintained in FCDB and deletion of a biller is also within FCDB Pay Bills This f
96. amend Bills Discrepancy ments and discrepancies Look Up Mainte This function allows user to No nance maintain basic look ups related to trade These look ups maintained can later be used by the users while initiat ing respective transactions The look up data is maintained in FCDB database Line Limits This function displays the vari No Extended Limits ous limit lines available for and Collateral customer in the user Management Trade View This function allows the bank Yes Documents administrator to view docu ments attached by business users under various trade transactions Trade Attach This function allows the bank Yes Documents administrator to attach docu ments on behalf of business users under various trade transactions Account Sum This function displays the No CASA Islamic mary summarized view of the CASA Retail accounts held by the cus Term Deposit tomer Islamic Term Deposits Con sumer Lending CL Islamic finance amp Corpo rate Deposits Module 6 26 ORACLE Transaction Name Transaction Description Administration Transaction Oracle FLEXCUBE UBS Module Account Activity This function displays the account activity for specified search criteria for selected CASA Account The account activity can be downloaded in MT940 PDF CSV OFX and QIF format No CASA Islamic CASA Account State ment Inquiry This function displays the gen erated acco
97. ance Export Collection Initiation BC CreateContract Req Full MSG xsd Trade Finance Export Bill Collec tion Under LC fcc vw lcvw cont prod summary fcc vw lcvw avail ments fcc Ictb amn d vals master fcc vw lcvw con tract clauses fcc vw lcvw docu ments fcc vw lcvw drafts fcc vw lcvw parties fcc vw msvw cust a ddress fcc vw lcvw con tract BC CreateCon tract Req Full MSGxsd Trade Finance Initiate Bank LC Contract Create Guarantee duct fft Req Full MSG xsd fcc vw bctms fft ma ster 6 78 ORACLE Transaction Group Transaction Name Database Views XSD names Trade Finance Outward Guaran tee Amendment fcc vw lcvw cont prod summary fcc vw lcvw avail ments fcc Ictb amn d vals master fcc vw lcvw parties fcc vw cfvw charge settlement fcc vw lctbs ffts fcc vw MST PRODUCTLCBG duct fft fcc vw bctms fft master LC CreateAmend Confirm Res Full MSG xsd Trade Finance View Outward Guarantee fcc vw lcvw cont prod summary fcc vw lcvw avail ments fcc vw pro duct fft fcc vw lcvw parties fcc vw cfvw charge settlement fcc vw lctbs ffts fcc vw MST PRODUCTLCBG fcc Ictb amn d vals master Trade Finance Customer Accept ance Customer Accept ance for Export LC amendments fcc vw b
98. and following is the expected Operational workflow to be followed for the same Ifa customer is created in FCUBS via the STDCIAD screen and later if such a customer is designated as a Wealth customer via the Segmentation screen then the Bank Operations user should remember that the STDCIFAD screen does not have RM Field which is a mandatory important field for FCPB integration 980 ORACLE Hence the user has to first go to the Modify Customer screen UBS and enter the RM Id Then go to the Segment Association screen and fill in the other details like Segment Upgrade Status etc Only if the above workflow is followed Customer Creation notification would be accepted by FCPB successfully FAC Setup to support Create Customer from FCUBS All Mandatory Fields coming from FCUBS should be kept non modifiable in FAC for Demographics screen This is to make sure that user is not allowed to modify any of the fields which are mandatorily being sent by FCUBS and present in the Create Customer XML like External Id Home Address Status Acquisition Date Segment etc However the user should be allowed to modify any field which is exclusively maintained by FCPB and not by FCUBS like Client Entity Hobbies Preferred Communication Mode etc or even non mandatory fields like Occupation Work Address First Name etc These fields need to keep modifiable in FAC and Demographics screen These should be handled by the Impleme
99. associated with XSDs 6 99 Oracle FLEXCUBE Direct Banking Universal Banking Notifications 7 1 3 1 ntroduction ccce dett tr ie dettes terrae d i tado pe in d Rina enn 7 1 7 22 NOUUTICATIONS at dietetic 7 1 7 2 1 Oracle FLEXCUBE Direct Banking Corporate Customer Services 7 1 F nction ID 055 te ARA op seer 8 1 1 1 1 2 1 3 1 4 1 Preface Introduction This document is designed to help acquaint you with the interface among various Oracle FLEXCUBE products viz Oracle FLEXCUBE Universal Banking Solutions FCUBS Private Banking FCPB and Direct Banking FCDB This manual explains the maintenances required for the exchange of data and the type of data being transferred between e FCUBS and FCPB e FCPB and FCUBS e FCPB and FCDB e FCDB and FCPB This User Manual explains the extensibility features and provides insight into the design guidelines and principles for external parties to leverage and develop the required extensions in a non invasive way to the primary features and functionality of the application Besides this User Manual while maintaining the interface related details you can invoke the context sensitive help available for each field This help encapsulates the purpose of each field within a screen You can obtain this information by placing the cursor on th
100. ate interface details to enable handoff of the following details e maturity with interest liquidation e Daily accrued interest on TD e Penalty on TD e Loan and Liability Information The maintenances required for enabling the data upload are discussed under the following headings Term Deposit Maturity with Interest Liquidation On the maturity date of a term deposit FCUBS hands off the term deposit maturity details to Oracle FCPB In addition to that the system also hands off the interest details after interest liquidation This handoff happens only for the customers whose segment code and segment status are defined in the system To enable the data handoff from FCUBS you need to define the interface details as given in the following table Field Value Interface Code STOIMDTL Interface Type Outgoing From System FCUBS To System FCPB Dateformat YYYYMMDD ORACLE File Mask oen Whentorun Beginning of day Frequency Daily Character Set ASCII Format Delimited Delimiter File Header record length 3 Default value HDR Body Record Length 36 File Footer record length 3 default value TLR Numeric padding Left padding with Zeros Text padding Left padding with spaces Datalog Required Yes CRC Required No Triggering System In Component Details sub screen you need to maintain the following details
101. ay impact processing of FCDB Application partially com pletely Yes Manage Applica tion Messages This function allows bank administrator to change appli cation messages Yes ORACLE Transaction Name Transaction Description Administration Transaction Oracle FLEXCUBE UBS Module Configuration Properties This function allows bank administrator to set change configuration properties This is system maintenance trans action and any unexpected change may impact process ing of FCDB Application par tially completely Yes View System Log This function allows bank administrator to view system logs Yes Host Interface Log This function allows bank administrator to view host interface logs Yes Entity Manage ment This transaction allows a bank administrator to configure a new entity Yes Advance Search This transaction allows a Help Desk user to search the busi ness user The click on the user starts the session for selected user and helpdesk user is able to view transac tions of the business user Yes Session Man agement Wrap session Create Session This transaction allows a Help Desk user to end session of a selected user The click on the wrap up ends the session of existing business user and helpdesk user can start a new session for any other business user Yes Reminders Transaction allows Business
102. be modified only if no transactions have yet happened on that CASA account which means that once FCPB receives a CASA Balance Notification there is no possibility of modifying the CUSTNO for that CASA account However if a CASA account has been created with 0 balance and a few days later FCUBS user realises that an error has occurred in mapping the CUSTNO then one may change the Customer Number which will trigger a Modification XML for CASA Account For this scenario FCPB also updates its own CRM CLIENT BANK ACCOUNT table with the new modified CUSTNO TD Account Creation Following types of transactions related to TD are sent by FCUBS TD Transaction Types e NEW New FD e PAR Withdrawal e Interest Payout e MAT Maturity Transfer e PEN Penalty ORACLE 3 4 8 1 RNW Rollover Whenever a TD gets booked in FCUBS it is sent to FCPB by Online Notification The details of TD Account Creation Notification interface are given below Process Flow The following steps are involved in the process 1 The Frequency of this notification would be one time migration and daily incremental online Time Deposit would be created by FCUBS and the details will be handed off to FCPB TD New Account Notify MSG notification service would be used by FCUBS to hand off the TD account details to FCPB Once the notification message is received from FCUBS for creation of TD Account the account details would be i
103. bscrip tion Status fcc vw sft m cust subscription Contract Deposit Contract Deposit Details fcat vw mstldprod uct fcat vw mstld productdetails fcc vw coy defn fcc vw cst m prod disallow fcat vw tenureinter estdtls fcat vw mst branch fcc vw cstm product fcat vw mstinterest comp fcat vw maturityin structions Contract Deposit Open Contract Deposit LDContract Master Req Full MSG xsd Term Deposits Open Term Deposit Islamic fcc_vw_mstproduct classes IA CreatelATD CustAcc Req Full MSG xsd Term Deposits Amend Term fcc vw msttddetails IA ModifyIATD Deposit Islamic fcc vw ictm tdpay CustAcc Req Full out details MSG xsd fcc vw ictm tdpay in details fcc vw mst std de tails 6 70 ORACLE Transaction Group Transaction Name Database Views XSD names Term Deposits Redeem Term Deposit Islamic fcc vw msttddetails fcc vw ictm tdpay out details fcc vw ictm tdpay in details fcc vw mst std de tails IA CreateRedemption Req Full MSG xsd Oracle FLEXCUBE Direct Banking Corporate Cash Management Cash Management The transactions and the respective database view XSD are as follows Transaction Transaction Database Views XSD names Group Name Cash Man Setup Account IL CreatelL Sweep agement Structure Req Full MSG xsd Cash
104. count setup for their users SSO for Chan Provision to allow for single Yes nels login and authentication cre dentials user id login pass word and transaction password for all channels that are part of a group Multilingual Data Business users should be able Yes Input to input data in the application as per their preferred lan guage Monitor Timer This function allows bank Yes Services administrator to monitor timer Services View Customer This function allows bank Yes ORACLE Transaction Administration Oracle Nam Transaction Description Transaction FLEXCUBE UBS Module Customer Profile This transaction allows a Cor Yes porate administrator to view amp modify their own customer profile using Modify Profile View Profile User Account Setup Authorisation This function allows Corpo Yes Mandates Main rate administrator to set tain User List authorisation mandates for Manage Rules their users Bulk Registration This function allows Corpo Yes rate administrator to set up bulk registrations User BTID Map This function allows Corpo Yes rate administrator to map unmap User BTID View Audit Log This function allows Corpo Yes rate administrator to view audit logs of their own users Terminate User Session Print Welcome Letter Pass word Customer This function allows bank Yes Account Open administrator to view details ing Management and update KYC s
105. credit Bene CreateAmtBlk Payment GL CREDIT IT_GL_ Receiver s Leg BENE CREDIT_B ENE Account Origination RRORGO9 This helps to submit the initiate Opening BPEL initi request on BPEL Pro ate request cess Account Origination GETORI This helps to fetch whole detailedquery Opening BPEL for GAPP application of BPEL Query request 6 54 ORACLE Transaction Interface Operation Name Name Request Interface Description Name Account Origination RRORGO09 This helps to modify the complete Opening BPEL for BPEL request on par Final submit ticular stage request Account Leads Sub RRORG6O This helps to submit CreateF Opening mit RRORG61 application to core bank CDBLead RRORG62 ing RRORG63 RRORG64 RRORG65 Account Leads GETLEA This helps to fetch the QueryF Opening Query DAPP whole lead application CDBLead Account Leads Mod RRORG122 This helps to modify the ModifyF Opening ify Offer lead request CDBLead Acceptance RRORG123 and Addi tional Docu ment Account View for RRORG32 This helps to identify the NA Opening Existing Cus already loaded tomer Docu ment Redeem TD Redemp Gets the redemption Term Deposit tion simula details for premature full tion redemption It fetches penalties and charges and total redemption amount os of the date Open Term Calculator Calculates the maturity Deposit for Term amount for the TD Deposit maturity amount
106. cvw con tract master fcc vw bcvw con tract parties FCC VW BCTBS CONTRACT DISC fcc vw contract fcc vw lcvw cont prod summary Confirm Res Full LC ConfirmAmend MSG xsd Trade Finance Customer Accept ance Customer Accept ance for Bills Dis crepancy 6 79 ORACLE Transaction Group Transaction Name Database Views XSD names Trade Finance Look Up Mainte nance Trade Finance Line Limits fcat vw mstliability fcc vw mstcorporate fcat vw mstlinelimits fcat vw txnlinedetail fcc vw getm lia b cust Core Services Trade View Doc uments Core Services Trade Attach Documents 6 3 14 Oracle FLEXCUBE Direct Banking Retail Customer Services The transactions and the respective database view XSD are as follows Transaction Group Transaction Name Database Views XSD Names Customer Ser vices Change Limits Customer Ser vices Accounts Ad hoc State ment Request Loans Customer Ser vices Transaction Activ ities Customer Ser Register for vices MT940 Account Statements Customer Ser View MT940 fcat vw swift bic di vices Statements rectory fcc vw d ly msgs in 940 Customer Ser vices Exchange Rate Inquiry fcc vw mstfxrate Customer Ser vices Alerts Registration fcat vw mstcorpo rate fcc vw m
107. d P2P NA PC PC Reopen ReopenPTP ReopenP2 ReopenPT ReopenP2P Bene Ben Req PBeNefici PBen Res BeNeficiary Full aryMainte Full MainteResp MSG xsd Request x MSG xsd onse xsl sl P2P NA PC claimPaym PC RELEASE CreateContr entsP2PR CreateCont claimPayme AMOUT act Req Full equest xsl ract Res ntsP2PResp BLOCKEDs MSG xsd Full onse xsl MSG xsd P2P DEBIT NA CA claimPaym CA claimPayme GL CREDIT CreateAmtBl entsP2PR CreateAmt ntsP2PResp BENE k Req Full equest xs Blk Res onse xsl MSGxsd Full MSG xsd 6 3 19 Oracle FLEXCUBE Direct Banking Retail Credit Cards Credit Cards The transactions and the respective database view XSD are as follows Transaction Transaction Name Database Views XSD names Group Credit Cards Credit Card Summary Credit Cards Credit Card Statement Credit Cards Credit Card Details Credit Cards Credit Card Payments Credit Cards Register Credit Card Credit Cards Modify Supplementary Card Limit Credit Cards Apply for Credit Card Credit Cards Credit Card Hot Listing Credit Cards Change Credit Card Bill ing Cycle 6 90 ORACLE Transaction Transaction Name Database Views XSD names Group Credit Cards Change Credit Limit Credit Cards Register De register Auto Payment Credit Cards Credit Card ATM PIN Change Credit Cards Credit Card Replace ment Credit Cards
108. d Payments Main tenance View Limits Utiliza tion Transfer and Payments Main tenance Change Limits Core Services Global Beneficiary Maintenance 6 66 ORACLE 6 3 4 FLEXCUBE Direct Banking Corporate Account Inquiries The transactions and the respective database view XSD are as follows Transaction Transaction Database Views XSD names Group Name Accounts Account Details fcat vw accountde tails vw mstac count Accounts Dashboard Widget Manage ment Overall View Account Sum fcat vw mstaccount mary Accounts Account Details fcat vw accountde tails vw mstac count Accounts Account Activity fcat vw txnaccountac tivity fcat vw accountde tails fcc vw mstaccount fcc vw actb vd bal Accounts Account State fcat vw acct stmt ment Inquiry summary fcat vw acct stmt de tails fcc vw loan stmt summary Overall View Account Overview fcc vw stt ms cust account fcc vw sttms ac count class fcc vw cltbs ac count master fcc vw cltbs ac count schedules fcc vw clproduct fcc vw txntdcontracts fcat vw mstldproduct 6 67 ORACLE Transaction Transaction Database Views XSD names Group Name Overall View Consolidated fcc vw stt Position ms cust account fcc vw claccount fcc vw cloutstanding bal
109. d in FCDB infra structure NO interface with host system is expected Force Change This transaction forces the No Password user to change the password as per password policy defined Site Map This function displays all the No transactions available to the user and allows the user to understand the sitemap Frequently This function displays Fre No Asked Questions quently Asked Questions FAQ and their answers A link to the FAQs prepared by the bank is provided News This function displays latest No news and events for bank A link to the news prepared by the bank is provided ATM Locator This function displays list of No the ATMs the bank have A link to the ATM locator pre pared by the bank is provided Branch Locator This function displays list of No the branches the bank have A link to the Branch locator pre pared by the bank is provided Ad hoc State This function generates No CASA Islamic ment Request account statement request for CASA Retail CASA amp TD CASA and term Deposit Term Deposits account for a specified period Stop and This function allows user to No CASA Islamic Unblock Cheque block a cheque payment or CASA Request revoke the stop payment instruction issued earlier Cheque Status This function displays the No CASA Islamic Inquiry cheques status CASA ORACLE Transaction Administration Dracle Name Transaction Description Transaction FLE
110. date DATE Account VAR 5 YES ACCOU 6 STT SUB sub type CHA NT M CUS TYPE R CLASS T AC COUNT INT RA interest NUM 24 NO AMT 22 ICT TE rate BER 6 RATE B UDE VALS TENOR tenor NUM 10 YES NULL BER 224 ORACLE LE LE FIELD DESCRIP TYPE N FCCC IN a FCC NAME TION GT OLUMN GT Remarks RY name H H ACCR Accrued NUM 24 NO AMT 22 ICT This will NT interest BER 6 B_EN be sum of TRIES total credit interest accrued for that product includes all credit formula associ ated to it LAST Last inter DATE NO LAST A 8 ICT NT AC est paid CCR D B AC CR T C PR DATE INTER interest NUM 24 NO AMT 22 ICT This will EST PA paid BER 6 B EN be sum of ID TRIES total credit interest liqui dated for the prod uct includes all credit formula associ ated to it LAST Last inter DATE NO LAST A 8 ICT NT est date CCR D B AC DATE T C PR HOLD Hold NUM 24 NO ACY 22 STT AMOUN amount BER 6 BLOCK M_CUS T ED AM T AC OUNT COUNT is ORACLE Customer Balance Loan File Format The format of the customer loan balance file is given below FIELD pescri LEN MAN FCC_ LE ECC Table Fcc NAME PTION E GT DAT Ne name Remarks H ORY UMN TH CLI Clientid VAR 10 YES CUS 9 CLTB_AC ENT ID CHA TOM COUNT MA R ER I S
111. dated i e Client Status in CRM CLIENT MASTER based on the following xml attributes e CUSTSEGSTATUS e TXNSTAT e FROZEN Rules for updating the Client Status in FCPB Will b mark d CLOSED Tf TXNSTAT i is e Client status will be updated as Suspended in FCPB if CUSTSEGSTATUS is D or FROZEN is Y e Customer Status will be Active if TXNSTAT is or CUSTSEGSTATUS or R or FROZEN is N e other status results in an updation failure and an the error message will be sent as Not a valid Customer status 1 Anew column called Status Description is introduced in CRM CLIENT MASTER and it gets updated as mentioned below e If Segment Status in the Modification XML is Upgrade U in CUSTSEGSTATUS Tag FCPB defaults this column with description as Activated customer due to Upgrade from Core Banking System e If Segment Status in the Modification XML is Reupgrade R in CUSTSEGSTATUS Tag FCPB defaults this column with description as Activated customer due to Re upgrade from Core Banking System e If Segment Status in the Modification XML is Downgrade D in CUSTSEGSTATUS Tag FCPB defaults this column with description as Suspended customer due to Downgrade from Core Banking System as ORACLE 3 4 2 3 3 4 3 3 4 3 1 2 If Segment Status in the Modification XML is Closed C in TXNSTAT Tag FCPB defaults this column with description as Closed customer due to Closure
112. de related documents The attached documents are maintained in the FCDB data base and a business user can view the documents View Import Bills This function displays Import No Bills and Collec Bills for collections tions View Export Bills This function displays Export No Bills and Collec Bills for collections tions Direct Collection This function allows user to ini No Bills and Collec Initiation tiate Direct collection of the tions bills Export Collec This function allows user to ini No Bills and Collec tion Initiation tiate Export collection of the tions bills Export Bill Col This function allows user to ini No Bills and Collec lection Under tiate Export collection of the tions LC bills under a LC Initiate Bank This function allows user to ini No Letter of Credit Guarantee tiate the Bank Guarantee Application Outward Guar This function allows user to No Letter of Credit antee Amend ment amend a existing Bank Guar antee Application 6 25 ORACLE Transaction Transaction Description Administration Oracle FLEXCUBE Name Transaction UBS Module View Outward This function displays Bank No Letter of Credit Guarantee Guarantees Customer This function allows user to No Letter of Credit Acceptance for acceptance of the amend Export LC ments and discrepancies amendments Customer This function allows user to No Acceptance for acceptance of the
113. dicating Rollo ROLLOVER AMT ver Amount VALUE DATE Indicating Rollo ver Date AMT CCY Rollover CCY CCY CLIENT ID CUST NO INTEREST AMOUNT TP to create a ACCR INT BAL Txn INT based on this value SUB PORTFOLIO ID TD Reference ACC Number Updation in PMS PORTFOLIO HOLDING SUB PORTFOLIO ID PMS PORTFO LIO HOLDING To be referred just for identify ing the CPIS record and NOT for updation CLIENT ID PMS PORT FOLIO HOLDING To be referred just for identify ing the CPIS record and NOT for updation MARKET VALUE AND SETTLED MKTVALUE PMS PORTFO LIO HOLDING The TD rollover amount would be populated ROLLOVER AMT VALUE DATE PMS PORTFO LIO HOLDING Updation in 8 HOLDINGS DETAILS CLIENT ID PMS T D HOLDINGS DETAILS SUB PORTFOLIO ID ACC PROD_ID it will have val ues like time deposit call deposit etc BALANCE ROLLOVER AMT CURRENCY MATURITY DATE NEW MAT DATE ORACLE FCPB Column Name Description FCUBS Element Name as per the XML INT RATE INT RATE TENOR TENOR TENOR DM to be defaulted to days ROLLOVER TYPE ROLLOVER TYPE 3 4 11 2 Business Rules and Validations for TD interfaces Only Active transactions for TD are handled using the interface and Transaction Delete would not be handled Rules for Handling TD Interfaces are Mentioned Below 1
114. domestic transfers lections PC Domestic Trans the authorisation types sup fer ported are 1 File level Auth File Level Reject 2 Record Level Auth Record Level Reject Bulk File This function allows bulk Yes Funds Transfer Uploads Inter upload of international trans FT national Funds fers The authorisation types sup ported are 1 File Level Auth File Level Reject 2 Record Level Auth Record Level Reject Bulk File View This function allows user to Yes view the bulk files uploaded Bulk Authorisa This function allows user to No tions authorise the bulk files uploaded by means of File Level Authorisation Record Level Authorisation Ad hoc State This function generates No Loans and ment Request Loans account statement request for Loans and Islamic Finance account for a specified period Islamic Loans ORACLE Transaction Name Transaction Description Administration Transaction Oracle FLEXCUBE UBS Module Transaction Activities This function allows user to View Initiated Transactions View Authorized Transactions View Use Drafts amp Templates No Register for MT940 Account Statements This function allows the user to register for the accounts for which they wish to view MT 940 account statement The account is registered in FCDB only The same account need to be registered in Host for getting MT940 statement No View MT940
115. e Customer xist as follows Document docs 1 ORT B PROCESS DOCS 2 CATEGORY MAINT 6797 ORACLE 6 3 24 Oracle FLEXCUBE Direct Banking Retail Corporate Term Deposits Transaction Group Transaction Name Database Views XSD names Term Deposits Term Deposit fcc vw msttddetails Details fcc vw ictm tdpay out details fcc vw ictm tdpay in details fcc vw mst std de tails Term Deposits Term Deposit Activ fcat vw txnaccoun ity tactivity fcat vw accountde tails fcc vw mstaccount fcc vw actb vd bal Term Deposits Open Term Deposit fcc vw mstproduct ST CreateTD Conventional classes CustAcc Req Full MSG xsd Term Deposits Amend Term fcc vw msttddetails ST ModifyTD Deposit Conven fcc vw ictm tdpay CustAcc Req Full tional out details MSG xsd fcc vw ictm tdpay in details fcc vw mst std de tails Term Deposits Redeem Term Deposit Conven tional fcc vw msttddetails fcc vw ictm tdpay out details fcc vw ictm tdpay in details fcc vw mst std de tails IC CreateTDRe dem Req Full MSG xsd Structured Term Deposits Structured Deposit Subscription fcc vw s d scheme details SF CreateSFSub Req Full MSG xsd Structured Term Deposits View Subscription Status fcc vw sft m cust subscription 6 98 ORACLE Transaction Group Transaction Name Database Views XSD names Contract Deposit C
116. e Money In To Linked Accounts PCContract Create Req Full MSG xsd Virtual Banking Move Money out To Linked Accounts PCContract Create Req Full MSG xsd Virtual Banking Savings Plans PC CreatePCMaint Req Full MSG xsd Transfer and Pay ments Collection and Remittance Inward Remittance Inquiry fcc vw inward rem mitance Transfer and Pay ments Collection and Remittance Outward Remit tance Inquiry fcc vw out ward remmitance Transfer and Pay ments Collection and Remittance Domestic Collec tion Inquiry fcc vw fcy collec tion inq Transfer and Pay ments Collection and Remittance FCY Collection Inquiry fcc vw collec tion inq Transfer and Pay ments Mainte nance Beneficiary Mainte nance fcc vw mstaccount fcc vw sttb account Transfer and Pay ments Mainte nance View Limits Utiliza tion Transfer and Pay ments Mainte nance Change Limits 6 87 ORACLE Transaction Transaction Database Views XSD names Group Name Core Services Global Beneficiary Mapping 6 3 18 1 Additional Transactions The additional transactions supported by the integration under this module and the details of XSD and XSL files are given below 9 89 ORACLE Transaction Peer to Peer Payment Request Response Interface View Request Hos
117. e relevant field and striking the F1 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 www oracle com pls topic lookup ctx acc amp id docacc Organization This manual is organized into the following chapters About this Manual gives information on the intended audience It also lists the various chapters covered in this User Manual t1 ORACLE Oracle FCUBS FCPB Interface deals with the maintenances required for Chapter 2 the interface and its further processing Oracle FCPB FCUBS Interface deals with the maintenances required in Chapters FCPB to exchange information between FCUBS and FCPB Oracle FCPB FCDB Interface deals with the maintenances required in Chapisr4 FCPB to exchange information between FCPB and FCDB Oracle FCDB FCPB Interface deals with the maintenances required in FCDB to exchange information between F
118. e user within a customer based on the roles and responsibilities Manage Rules This function allows bank Yes administrator to setup authori sation mandates ORACLE Transaction Administration Oracle Nam Transaction Description Transaction FLEXCUBE M UBS Module Transaction This function allows bank Yes Activities administrator to view and authorise the transactions done by the administrators Transaction Sta This function allows bank Yes tus Change administrator to update the transactions which has not reached final stage of cycle Request Pro Bank administrator shall able Yes cessing to process this service request and Release Transactions for which release is configured This will be controlled through he Business Process Flow Engine BPFE Manage Policies This transaction allows bank Yes administrator to maintain poli cies for User ID and Pass words View Audit Log This function allows bank Yes administrator to view audit logs of different users Transaction Cut This function allows the bank Yes Off administrator to maintain working window for different transactions Deal Timer and This transaction allows bank Yes Cut Off administrator to set deal tim ers for currency pairs Transaction This function allows the bank Yes Black Out administrator to maintain blackouts for different transac tions Global Limits This function allows the bank Yes Package administ
119. edit Card Last This function displays the last No N Trxns N transactions for a Credit Card Credit Card Hot This function allows user to No listing send a request for hot listing card and to issuance of new credit card These transactions have to be processed offline and adminis trator needs to update the sta tus of the request Registerfor SMS This transaction allows the No Banking user to register for SMS bank ing Deregister for This transaction allows the No SMS Banking user to de register for SMS banking Change default This transaction allows the No Account user to de register for SMS banking Account Sum This function displays the No CASA Retail mary summarized view of the Term Deposit accounts held by the cus Consumer Lend tomer ing Loans amp Deposits Module Account Details This function displays the No CASA account details of selected CASA account Last N Transac This function displays the Last No CASA tions N Transactions for a CASA account No of transactions is configured as day 0 activity Ad hoc State This function generates No CASA ment Request CASA amp TD account statement request for CASA account for a specified period 6 51 ORACLE Transaction Administration Oracle Transaction Description Transaction FLEXCUBE UBS Module Term Deposit This transaction displays sum No Retail Term Summary marized view of al
120. ent schedule contains the instal ment components like princi pal interest charges and outstanding instalment amount Loan Repayment This function displays various No Consumer Lend Inquiry repayments received for the ing selected loan account Loan Settlement This function allows partial or No Consumer Lend full pre payment of the ing selected loan account Loan Account This function displays the No Consumer Lend Activity transactions happened ing through selected loan account The transaction activity can be downloaded in PDF CSV Loan Interest This function displays interest No Consumer Lend Rates Inquiry rates for various loan prod ing ucts Loan Calculator This function displays sched No Consumer Lend ule for a loan amount for ing select interest Mortgage Calcu This function displays sched No Mortgage Loans lator ule for a loan under Mortgage for select interest Financing This function displays the No Consumer Lend Details details of the selected Islamic ing Islamic finance account like product details disbursed amount outstanding balance details 6 42 ORACLE Transaction Name Transaction Description Administration Transaction Oracle FLEXCUBE UBS Module Financing Schedule This function displays repay ment schedule of selected Islamic finance account The repayment schedule contains the instalment components like principal profit percent age char
121. entify the queue uniquely throughout the system For Oracle FCUBS Oracle FCDB integration you need to maintain the following queues Queue Name Purpose MDB_QUEUE_REQUEST Online transaction request MDB_QUEUE_RESPONSE Online transaction response NOTIFY_DEST_QUEUE_FCDB Notification from Oracle FCUBS Description Specify a brief description of the queue Collection Queue Check this box to indicate that the queue that you are maintaining is a collection queue Message Code Specify the codes of various messages that will be routed to this queue Once you have specified the above details save the maintenance Processing Messages Oracle FLEXCUBE Direct Banking gets the details of transactions and operations from the database views of Oracle FLEXCUBE Universal Banking 5497 ORACLE 6 3 1 The details of such transactions and the related database views and XSDs in Oracle FLEXCUBE Universal Banking are detailed under the following headings The details are organized based on the Oracle FCDB modules For further information on each transaction and the related module in Oracle FCUBS refer to the section Introduction in this chapter Oracle FLEXCUBE Direct Banking Base Core The transactions and the respective database view XSD are as follows Transaction Group Transaction Name Database Views XSD names Core Corporate Administrator Account Setup User Maintenance S
122. er Client Indicator CRM CLIENT BANK ACCT Should be defaulted updated to B for all CASA TD records which r being inserted updated from FCUBS Core Banking system Acct branch Branch code Acct country id Country code ORACLE 3 4 6 3 4 6 1 Acct description ADESC if the description is more than 20 char then FCPB should truncate it to the extent of 20 char and populate the same Opening Date ACCOPENDT User HOHEADRMONE Current Login 07 05 2012 2 21 PM Home Customer FinancialPlanning Order Mgmt Txn Mgmt Master Reports Tools My Workspace Logout Customer gt Portfolio gt Maintenance Portfolio Summary Parke Davis Nam Description Type ccv Amount C Heldaway Heldaway 9 Portfolio RM Managed of Total Instrument Type Amount nna s 7 C RM Managed RM Managed TimeDep C Self Managed Self Managed Total Ik Lb Total INR 2 578 067 31 10096 View Portfolio Modify Delete Add Portfolio Last Transaction Date in the Portfolio 05 12 2012 No ccv Available Balance Hold Amount Total Balance As on Date Total INR 2 426 277 63 0 2 426 277 63 Customer CASA Account Balances Notification The details of Customer CASA Account Balances Notifications are given below Process Flow The following steps are involved in the process 1 The Frequency of this notification would be one time migration and daily i
123. ers Account Balances details of unclear funds of selected CASA account No CASA Islamic CASA Dashboard Widget Manage ment Business users will be pro vided with a new transaction through which the business user shall be able to enable or disable widgets to be dis played on their dashboard screens of each channel to which they have access sepa rately No Account Sum mary This function displays the summarized view of the accounts held by the cus tomer No CASA Islamic CASA Retail Term Deposit Islamic Term Deposits Con sumer Lending Loans Islamic finance amp Depos its Module ORACLE Transaction Administration Oracle Name Transaction Description Transaction FLEXCUBE UBS Module Account Details This function displays the No CASA Islamic account details like Account CASA Holder details Product details Account Parameters Account Balances details of unclear funds of selected CASA account Account Activity This function displays the No CASA Islamic account activity for specified CASA search criteria for selected CASA Account The account activity can be downloaded in MT940 PDF CSV OFX and QIF format Account State This function displays the gen No CASA Islamic ment Inquiry erated account statement for CASA Loans the selected account Account Islamic finance statement is to be generated by Oracle FLEXCUBE Univer s
124. ess 200 NO ADDRESS 105 STT ADDRESS line 1 2 M CUST 1 ACCOUNT T ACCT Address 200 NO ADDRESS 105 STT ADDRESS line 1 3 M CUST 2 ACCOUNT T ACCT Account 100 NO LOCA 15 STT CITY city TION M CUST ACCOUNT T ACCT Account 3 NO NULL COUN country TRY ID id T HLD A Held 1 YES N 1 DEFAULT CCT_YN away VALUE accoutn N YN T_ACCT_ Accound 20 NO AC_DESC STT DESCRIP descrip M_CUST_ TION tion ACCOUNT Customer Balance CASA File Format The format of the customer balance file is given below LE LE FIELD DESCRIP ypg Ps FCC C N ind FCC NAME TION GT OLUMN GT Remarks RY name H H CLI Client id VAR 10 YES CUST 19 STT ENT ID CHA NO M CUS R T AC COUNT 2 23 ORACLE LE LE FIELD DESCRIP TYPE N geile C IN a FCC NAME TION GT OLUMN GT Remarks RY name H H BANK Bank VAR 16 YES CUST 20 STT ACCT accountid CHA AC_NO M_CUS D R T_AC account id COUNT PROD product id VAR 5 YES PROD 4 ICT Interest D CHA B EN Product R TRIES associ ated One account can have multiple interest product BOOK booking DATE YES AC OP STT ING date EN M CUS DATE DATE T AC COUNT VAL value date DATE YES 8 Default UE Value DATE Applica tion date AMOUN amount NUM 24 YES ACY A 22 STT T BER 6 VL BAL M CUS T AC COUNT CCY ID Currency VAR 3 YES CCY 3 STT CHA M CUS R T AC COUNT MATU Maturity DATE NO NULL RITY
125. ession validation is SessionServicelnterface SessionService getSession This service is invoked over through Webservice over SOAP The following Webservice URL is exposed by FCDB for session validation al ORACLE 5 3 5 4 5 5 https lt ipaddress gt lt port gt service services ServiceEndPoint This service validates the combination of Session ID J Session ID Customer Id and User s Login entity ID as per the session maintained in Oracle FLEXCUBE Direct Banking For sample request and response messages and corresponding schema definitions for the XML kindly refer section 5 Customer Folio Account Summary Transaction and Widget in Oracle FLEXCUBE Direct Banking displays the customer folio maintained at Oracle FLEXCUBE Private Banking For viewing customer folio in Oracle FLEXCUBE Direct Banking Oracle FLEXCUBE Private Banking exposes Restful Web Services The URL for the customer folio URL is https lt ipaddress gt lt port gt rest rest customerHoldingService customerHoldings amp clientld 0 Oracle FLEXCUBE Direct Banking invokes the above URL to get the response from Oracle FLEXCUBE Private Banking in an XML format This response is unmarshalled into java object using context and supported jar of FCPB Context is configured as Day Zero parameter in FCDB The instrument types to be displayed on FCDB dashboard and transaction are also maintained as a day zero parameter in FCDB FCPB shared XSDS for customer
126. exchange rate between cur rency pairs Mail Box This function allows business No user interact with bank admin istrator user using FCDB inter nal messaging facility Corporate This function allows user to No Authorization authorise a transaction initi ated by another user of that customer Credit Card This function displays details No Details of the Credit cards hold by the user Credit Card This function displays the No Statement Credit Card Statement Buy Fund This function allows user to No buy the mutual fund units of a mutual fund scheme Sell Redeem This function allows user to No Fund redeem the mutual fund units of a mutual fund scheme Switch Fund This function allows user to Yes buy the mutual fund units of a mutual fund scheme View Fund Port This function displays Mutual No folio fund portfolio group by the mutual fund schemes sub scribed by user 6 49 ORACLE Transaction Administration Oracle Name Transaction Description Transaction FLEXCUBE UBS Module Order Status This function displays order No status for Mutual Funds trans actions ATM Branch This function allows the user No Locator iPhone of an iPhone to locate the Browser only nearest ATM Branch based on the current location Redeem Term This function allows user to No Retail Term Deposit Islamic redeem an existing term Deposits deposit Prelogin Trans Provision to have non author No
127. f co customer mod When the customer details are modified the txnstat would be O and in case of closure the txnstat would be C On receiving closure notification from FCUBS the CIF status in FCPB will stand closed Client Suspended Status The details of online notifications for Suspended Status Client are given below Process Flow The following steps are involved in the process 1 The Frequency of this notification would be one time migration and daily incremental online If the customer is suspended for a temporary time period the status of such customer is updated as Frozen in FCUBS and on receipt of notification xml the customer status in FCPB gets updated as S Suspended status This notification comes in the same way as any other modification notification from FCUBS The same XML message gets transmitted with the Frozen attribute being marked as Y Similarly if the Frozen status is revoked at FCUBS it is again communicated to FCPB via customer modification notification XML with the Frozen attribute being marked as N In this case the client status in FCPB reverted back to A active status provided the already available status of client is S 37 ORACLE 3 4 4 3 4 4 1 5 The notification message for communicating that the customer being Frozen would be NOTIF CO CUSTOMER MOD and txnstat would be O in this case FCUBS FCPB Column Ds Element Name Description
128. fer and Payments Stop Payment of Wired Transfer Transfer and Payments Uk Payments Transfer and Payments Internal Remittance Transfer and Payments View Standing Instructions fcc vw stand ing instr details Transfer and Cancel Standing fcc vw stand PC ClosePCMaint Req Payments Instructions ing instr details Full MSG xsd SIContract Close Req Full MSG xsd Transfer and View Pending fcc vw pending Payments Transfers transfer 6 65 ORACLE Transaction Group Transaction Name Database Views XSD names Transfer and Payments Cancel Pending Transfers FTContract Cancel Req FullMSG XSD For Own Internal Interna tional and International Draft PCContract Reverse Req Full MSG xsd For Domes tic SEPA Move Money Out and Move Money Transfer and Payments Col lection and Remittance Inward Remittance Inquiry fcc vw in ward remmitance Transfer and Payments Col lection and Remittance Outward Remit tance Inquiry fcc vw out ward remmitance Transfer and Payments Col lection and Remittance Domestic Collec tion Inquiry fcc vw fcy collec tion inq Transfer and Payments Col lection and Remittance FCY Collection Inquiry fcc vw fcy collec tion inq Transfer and Payments Main tenance Beneficiary Mainte nance fcc vw mstac count fcc vw sttb ac count Transfer an
129. from Core Banking System If Segment Status in the Modification XML is Frozen Y in FROZEN Tag FCPB defaults this column with description as Suspended customer due to Frozen Status received from Core Banking System Any change in Segment either Segmentation Upgrade or Downgrade is also expected as a part of Customer Modification To support this one more additional element the Customer Segmentation Status is sent to FCPB which would have values Segment Upgrade U Segment Downgrade D and Segment Reupgrade If the Segment is modified in FCUBS then FCPB updates the Client Seg column with the new Segment Code in CRM CLIENT MASTER Hence the role of that customer changes based on the new segment by first identifying the Role ID with NAME Segment s name from SMS ROLE and then identifying User id of the Customer from SMS APP USER and updating SMS USER ROLE table for that User Id with the ROLE for the new Segment The Customer Modification XML includes the fields Segment Branch ID Banker ID Client Status and Portfolio ID The details of online notifications for Suspended Status Client are given below Process Flow The following steps are involved in the process 1 3 The Frequency of this notification would be one time migration and daily incremental online For modification and closure there would be a special notification message For modification and closure the notif code would be noti
130. ges and outstanding instalment amount No Consumer Lend ing Islamic Financing Repayment Inquiry This function displays various repayments received for the selected Islamic finance account No Consumer Lend ing Islamic Financing Settle ment This function allows partial or full pre payment of the selected Islamic finance account No Consumer Lend ing Islamic Financing Account Activity This function displays the transactions happened through selected Islamic finance account The transac tion activity can be down loaded in PDF CSV No Consumer Lend ing Islamic Financing Profit Rates Inquiry This function displays interest rates for various Islamic finance products No Consumer Lend ing Islamic Cl Fund Statement Request This function allows user to request statement for selected mutual funds for an adhoc period No View Portfolio This function displays Mutual fund portfolio group by the mutual fund schemes sub scribed by user No Fund Information This function displays various mutual funds scheme details which are available for sub scription No Buy Mutual Fund This function allows user to buy the mutual fund units of a mutual fund scheme No Redeem Mutual Funds This function allows user to redeem the mutual fund units of a mutual fund scheme No 6 43
131. h CREDM demption vice dem Res Full drawal MSGxsd IC QueryTDRe dem Req IO MSGxsd TD rollover NOTIF T QueryTDRollover FCUBSTDSer ST QueryT D ROLLOVER vice DRollover Req IO MSG xsd ST QueryT DRollover Res Full MSG xsd CASA NOTIF QuerycustAc FCUBSAccSer CA NewCus account CA CUSTAC countDetails vice tomerAccount creation C NEW Notify MSG xsd CIF authori NOTIF CO C QueryCustomer FCUBSCus ST ModifyCus zation USTOMER_ tomerService tomer Notify modifica MOD MSG xsd tion Clo sure Broker cre NOTIF_CO_C QueryCustomer FCUBSCus ST NewCus ation USTOM tomerService tomer Notify ER_NEW MSG xsd CASA NOTI QuerycustAc FCUBSAccSer TD AccStat account FY AC BAL countDetails vice Notif xsd balance change Customer NOTIF P Customer crea creation B CUSTOMER tion under Bro ker category ORACLE 2 5 2 5 1 Segmenta NOTIF P CUSTSEGCD tion code B CUSTOMER Net worth NOTIF P NETWORTH Amount B CUSTOMER Net worth NOTIF P NET Currency B CUSTOMER WORTHCCY customer NOTIF P CUSTCCY currency B CUSTOMER Segmenta NOTIF P CUSTSEGSTA tion status B CUSTOMER TUS New tags CUSTSEGCD CUSTSEGSTATUS NETWORTH NETWORTHCCY and CUSTCCY will be available in the notification XSD Defining Interface Details for Data Handoff FCUBS hands off the details of maintenances and transactions to Oracle FCPB for processing You need to maintain separ
132. hat the Bank will create only one Investment Portfolio for each Customer and hence multiple Portfolio IDs will not be supported at FCUBS end Note FCPB must pick CUSTOMER MASTER SEGUP csv file first and then CASA AC COUNT CREATE SEGUP csv before picking up any other feeds from shared location Customer Account File Upload Segmentation Upgrade Once the customer gets upgraded as per the segmentation rules FCUBS will generate an EOD file handoff for these Customer Accounts to be uploaded into FCPB Subsequent modifications to these Customer Accounts then get updated via online notifications The Customer s preferred address would be sent to FCPB from FCUBS as a part of the CASA Account creation modification XML notification as well as via Segmentation Upgrade file Since Acct Address is a part of the Branch setup screen and not part of the FCUBS CASA Account screen the Address cannot be sent Hence FCPB must ignore these address fields and it should default CASA Account related tables with Home Bank s Address as maintained in MST BANK table 9 80 ORACLE 3 6 3 3 6 4 Customer Balances File Upload Segmentation Upgrade Once a customer gets upgraded as per the segmentation rules FCUBS will generate an EOD file handoff for these customer balances to be uploaded into FCPB Separate files for CASA Balances and Liabilities Balances would be sent by FCUBS Subsequent modifications to these customer balances then
133. have to be processed offline and adminis trator needs to update the sta tus of the request No 6 31 ORACLE Transaction Name Transaction Description Administration Transaction Oracle FLEXCUBE UBS Module Request Pro cessing This function allows business users to release the transac tion after re verification post final authorisation This trans action can also be used to tank a transaction temporarily within FCDB if required No Register Reports This transaction allows the user to register and schedule various reports for download view at a later stage Registration data is main tained in FCDB and gets inte grated with Oracle Publisher No Download Reports This transaction allows the user to download view a report generated as per the registrations Registration data is main tained in FCDB amp integration with Oracle Publisher No Preferences This function allows user to set different preferences for accessing FCDB application User preference data is main tained in FCDB No Account Prefer ence This function allows user to set different preferences for accessing FCDB application User preference data is main tained in FCDB No Session Sum mary This function displays activity details of business user done in last N Sessions No Mail Box This function allows business user interact wi
134. heritis Account TD or call deposit TDorcall deposit class whether it instrument id and instrument id and is TD or call instrument type instrument type deposit instru would be popu would be popu ment id and lated details in lated details in instrument type FCPB FS FCPB FS would be popu CASA Includein CASA JIncludein lated details in holdings Rel2 1 holdings Rel2 1 FCPB FS section 8 section 8 CASA cludeinholdings _ Rel2 1 section 8 TRN DT Tran Date Tran Date Value Date Maturity Date LCY AM Amount Amount Dividend Inter Mat Princi OUNT est pal new field to be intro duced AC NO Indicates Dr Cr Indicates Dr Cr ignored ignored AcctNumber n AcctNumber n ignored ignored AC Amt Instrument Currency RECORD ignored ignored ignored Account sta STAT tus TRANS Tran Tran ignored ignored ACTION Type should be Type should be TYPE defaulted to MAT defaulted to INT PEN Addi BIDASK_IND field would be defaulted TOTAL BALANCE tional as S COST MAR field would Attributes KET VALUE be made as ACCRUED zero ACQ COST CL ACQ COST PF ACQ COST SC would be made as zero FCUBS system sends the TD maturity related details as a part of their BOD process to ensure that the data of the TDs maturing on that particular date or TDs which have INTEREST transactions liquidated on that date should be received by FCPB on the BOD of that
135. ia the Customer Modification XML at EOD it restricts the Segmentation Upgrade set of files and does not send the same to FCPB If FCUBS sends these files after re upgrade they would get rejected as duplicates in FCPB Once FCPB receives such a Modification XML wherein Status is changed to Active Re upgrade for a customer who is currently in Suspended status in FCPB FCPB would update the status in CRM CLIENT MASTER back to Active and also update the Status Description column to Re upgrade from Core Banking System Once the status is Active the customer would be able to do all activities permitted in FCPB for active customers like placing of orders and transactions etc Assumptions 1 It is assumed that FCUBS EOD process would run and get completed before triggering the FCPB EOD process All the Interface related processing for Segmentation Upgrade Recon that is required to be handled by FCPB would be triggered as a part of FCPB s EOD process 2 Create Customer with From FCUBS Mode Create Customer Menu would be removed in FCPB so that customer creation only happens from FCUBS Common REF tables in FCPB and FCUBS have to be synchronized via Transaction Transformation screen so that FCPB s internal names values are mapped to FCUBS s names These are REF CLIENT SEG REF CLIENT STATUS REF CLIENT IT TYPE REF CLIENT CLASSIFICATION REF CLIENT CATEGORY 3 In FCUBS customers can be created quickly via the STDCIFAD screen also
136. ification Customer Ad hoc Statement AccStmt Adhoc Query Req Services Request CASA amp TD MSG xsd Accounts TDStmt Adhoc Query Req MSG xsd Customer Stop and Unblock CA StopPaymentsNew Req Full Services Cheque Request MSG XSD Accounts CA CreateStopPayments Req Full MSG xsd Customer Mailbox Attachment Services 6 3 18 Oracle FLEXCUBE Direct Banking Retail Transfer and Payments The transactions and the respective database view XSD are as follows Transaction Transaction Group Name Database Views XSD names Core Services Global Beneficiary Maintenance Qualification for Internal Account transfer Other trans action do not require the Host interface Transfer and Pay ments Own Account Transfers FTContract Create Req Full MSG xsd SIContract Create Req Full MSG xsd Transfer and Pay ments Internal Transfers FTContract Create Req Full MSG xsd SIContract Create Req Full MSG xsd 6 85 ORACLE Transaction Group Transaction Name Database Views XSD names Transfer and Pay ments Multiple Internal Transfer FTContract Create Req Full MSG xsd SIContract Create Req Full MSG xsd Transfer and Pay ments Domestic Trans fers PC CreatePCMaint Req Full MSG xsd SEPA Transfers SEPA Credits PC CreatePCMaint Req Full MSG xsd SEPA Transfers SEPA Card Pay PC CreatePCMaint ments Req
137. imiter d File Header record length 3 Default value HDR Body Record Length 36 File Footer record length 3 default value TLR Numeric padding Left padding with Zeros Text padding Left padding with spaces Datalog Required Yes CRC Required No Triggering System In Component Details sub screen you need to maintain the following details Field Field Name Table Name Column Name Data Type Length Position HEADER VARCHAR2 3 1 CUSTID CLVW LOAN CUSTOMER ID VARCHAR2 35 1 INT DETAILS ACCNO CLVW LOAN ACCOUNT NUM VARCHAR2 35 2 INT DETAILS BER PRODAC CLVW LOAN DR PROD AC VARCHAR2 20 36 INT DETAILS PROD CLVW LOAN PRO VARCHAR2 4 56 INT DETAILS DUCT CODE BOOKDT CLVW LOAN BOOK DATE VARCHAR2 10 60 INT DETAILS VALDT CLVW_LOAN_ VALUE DATE VARCHAR2 10 70 INT DETAILS PRNOUT CLVW LOAN PRNOUTSTAND NUMBER 22 80 AMT INT DETAILS ING 2 12 ORACLE 2 5 5 Field Field Table Name Column Name Data Type Length Position CCY CLVW LOAN CURRENCY VARCHAR2 3 102 INT_DETAILS MATDT CLVW_LOAN_ MATURITY_ VARCHAR2 10 105 INT DETAILS DATE ACCSTAT CLVW LOAN ACCOUNT STA VARCHAR2 1 115 INT DETAILS TUS ACSUB CLVW LOAN SUB VARCHAR2 10 116 TYP INT DETAILS TYPE ACCBRN CLVW LOAN DR ACC BRN VARCHAR2 3 126 IN
138. in billing cycle of credit card These transactions have to be processed offline and adminis trator needs to update the sta tus of the request No Change Credit Limit This service request allows a user to request for change in Credit limit of a credit card These transactions have to be processed offline and adminis trator needs to update the sta tus of the request No Register De reg ister Auto Pay ment This service request allows a user to request for register de register for auto payment of a credit card These transactions have to be processed offline and adminis trator needs to update the sta tus of the request No 6 40 ORACLE Transaction Name Transaction Description Administration Transaction Oracle FLEXCUBE UBS Module Credit Card ATM PIN Change This service request allows a user to request for new ATM PIN for a credit card These transactions have to be processed offline and adminis trator needs to update the sta tus of the request No Credit Card Replacement This service request allows a user to request for replace ment of a credit card These transactions have to be processed offline and adminis trator needs to update the sta tus of the request No Deactivation of Credit Card This service request allows a user to request for deactiva tion of a credit card These transactions have to be processed offli
139. int Req Full MSG xsd Transfer and Payments Demand Draft DDTransaction Create Req Full MSG xsd Transfer and Payments International Trans fers FTContract Create Req Full MSG xsd Transfer and Payments View Demand Draft fcc vw istm in str txn fcc vw con tract master Transfer and Payments Own Account Transfers FTContract Create Req Full MSG xsd SIContract Create Req Full MSG xsd Transfer and Payments Internal Transfers FTContract Create Req Full MSG xsd SIContract Create Req Full MSG xsd 6 64 ORACLE Transaction Group Transaction Name Database Views XSD names Transfer and Payments Multiple Internal Transfer FTContract Create Req Full MSG xsd SIContract Create Req Full MSG xsd Transfer and Payments Domestic Transfers PC CreatePCMaint Req Full MSG xsd Transfer and Payments Fixed Domestic Transfers PC CreatePCMaint Req Full MSG xsd Transfer and Payments SEPA Direct Debits PC CreatePCMaint Req Full MSG xsd Transfer and Payments SEPA Credits PC CreatePCMaint Req Full MSG xsd Transfer and International Drafts FTContract Create Payments Req Full MSG xsd Transfer and MT 101 Transfers FT CreateMt101 Req Payments Full MSG xsd Transfer and Payments Stop Payment of Demand Draft fcc vw istm in str txn fcc vw con tract master Trans
140. io group by the mutual fund schemes sub scribed by user Order Status This function displays order No status for Mutual Funds trans actions Redeem Term This function allows user to No Retail Term Deposit Islamic redeem an existing term Deposits deposit Prelogin Trans Provision to have non author No actions ised transactions in mobile banking 6 46 ORACLE Transaction Transaction Description Administration Oracle FLEXCUBE Name Transaction UBS Module Mailbox Attach Facility to enable users to No Interactions ment attach files to the mail being sent This enhancement is available across the Internet Mobile and Tablet banking channels International This function allows user No Funds Transfer Transfers transfer the funds to accounts FT in other banks in other coun tries Credit Card Pay This function allows the user No ments to pay the credit card dues Beneficiary This function allows user to No Funds Transfer Maintenance register for beneficiaries for Payment and later reuse for following pay Collections ments transactions Internal Account Transfer International Account Transfer Domestic Fund Transfer The Beneficiary data is main tained in FCDB My Scheduled With this transaction user shall No Funds Transfer Transfers be able to view both Pending Payment and Transfers and Standing Collections Instructions set on the
141. ion Explains handing off of details related to Customer created in FCUBS to FCPB e CASA Account Creation Explains handing off of details related to CASA Account created in FCUBS to FCPB e TD Account Creation Explains handing off of details related to TD Accounts created in FCUBS to FCPB e Loans and Liability Information Explains handing off of details related to loans created in FCUBS to FCPB Details of Data Received from Oracle FCUBS to Oracle FCPB The details of the Interface Modules for Customer CASA Liabilities and TD are as given below Entity Action Frequency Source Target CIF Authorization Modification Closure Add On line FCUBS FCPB Broker Data Add On line FCUBS FCPB CASA Account Creation Add On line FCUBS FCPB CASA Account Balances Add On line FCUBS FCPB TD Account Creation Add On line FCUBS FCPB TD Premature Withdrawal Add On line FCUBS FCPB TD Maturity with Interest Liquidation Add Batch FCUBS FCPB Daily Accrued Interest on TD Add Batch FCUBS FCPB Penalty on TD Add Batch FCUBS FCPB Loan and Liability Information Add Batch FCUBS FCPB Defining Interface Details from FCUBS to FCPB Any FCUBS FCPB interface originating from FCPB is driven by the flag FCUBS INTERFACE FLAG zY in REF BANK PARAMS However currently since we are only supporting Customer CASA TD interfaces originated from FCUBS are supported hence the value is main
142. ion FLEXCUBE UBS Module Domestic Trans This function allows user No Payments amp Col fers transfer the funds to accounts lections PC in other banks using domestic payment network SEPA Credits This function allows user to ini No Payments amp Col tiate a SEPA Credit Transfer lections PC SEPA Card Pay This function allows user to No ments payment using a credit card through SEPA network Demand Draft This function allows user to No Demand Draft request for a domestic Draft or pay order International This function allows user No Funds Transfer Transfers transfer the funds to accounts FT in other banks in other coun tries International This function allows user to No Funds Transfer Drafts request for a International FT Draft View Demand This function allows viewing all No Demand Draft Draft the domestic and international demand drafts and paying orders issues to a customer Stop Payment of This function allows a stop No Demand Draft Demand Draft payment request for a domes tic as well as international demand drafts issued earlier These transactions have to be processed offline and adminis trator needs to update the sta tus of the request Stop Payment of This function allows a stop No Wired Transfer payment request for a transfer wired earlier These transactions have to be processed offline and adminis trator needs to update the sta tus of the request Uk Payments This function allows user to ini No
143. ions supported by the integration under this module and the details of XSD and XSL files are given below 6 96 ORACLE Transaction Account Opening Request Response Interface View Request XSD Host Response Host Name Name Name Interface XSD Name Interface XSL XSL Origination NA ST CreateF OrigSaving ST CreateF OrigSaving BPEL initi CDBSavings sAccountAp CDBSav sAccountAp ate request Req Full plicationReq ings Res plicationRes MSG xsd xsl Full 5 MSG xsd Origination NA ST QueryF OrigSaving ST QueryF OrigSaving BPEL for CDBSavings sAccDetailed CDBSav sAccDe Query Req lO QueryReq xsl ings Res IO tailedQueryR request MSG xsd MSG xsd es xsl Origination NA ST ModifyF OrigSaving ST ModifyF OrigSaving BPEL for CDBSavings sAccountAp CDBSav sAccountAp Final sub Req Full plicationReq ings Res plicationRes mit request MSG xsd 5 Full 5 MSG xsd Leads Sub NA CreateF CreateF CreateF CreateF mit CDBLead Re CDBLead CDBLead R CDBLead q xsd Req xsl es xsd Res xsl Leads NA QueryF QueryF QueryF QueryF Query CDBLead Re CDBLead CDBLead R CDBLead q xsd Req xsl es xsd Res xsl Leads Mod NA ModifyF ModifyF ModifyF ModifyF ify Offer CDBLead Re CDBLead CDBLead CDBLead_R Acceptance q xsd Req xsl Res xsl es xsd and Addi tional Docu ment View for fcc vw Tables used Existing orig e from UBS ar
144. is also communicated from FCUBS to FCPB On receipt of this closure intimation from FCUBS the status of the customer changes to Closed 7 Updates based on Client IT Type e If Client IT Type is Corporate Director Sub node in FCUBS may or may not have values itis not mandatory for FCUBS to fill in the director details at the time of corporate customer creation If the value is available FCPB populates it in CRM AUTHORISED SIGNATORY table with Signatory Type as A as mentioned in mapping sheet If not available then the system will not fill it This is not a mandatory field from FCPB s perspective e If Client IT Type is Minor Y then FCUBS provides the Guardian details In that case first name in CRM AUTHORISED SIGNATORY with Signatory Type as G would be filled in e If Client IT Type is Individual then there is no concept of authorized signatory So there will be no entry in CRM AUTHORISED SIGNATORY table 8 In FCUBS customers can also be created quickly using the STDCIFAD screen The Operational workflow is as follows e customer is created in FCUBS via the STDCIFAD screen and later if such a customer needs to be designated as a Wealth customer via the Segmentation screen then the Bank OPS user should remember that the STDCIFAD screen does not have an RM ID Field which is a mandatory field for FCPB integration e Hence you have to first navigate to the Modify Customer screen in FCUBS and enter the RM ID ORACLE
145. ism In addition to the online interface mechanism there is certain data which is expected to be received from FCUBS as part of file upload The list is as given below e Maturity along with interest liquidation e Daily Accrued Interest on TD e Penalty on TD applicable in case of pre mature partial withdrawal and pre mature complete withdrawal e Loan and Liability Information TD Maturity along with Interest Liquidation FCUBS system uses the CSV Format to send the TD maturity related details Maturity and Interest liquidation are separate records in the same file The same interest file format is also used in case of interest payment for pre mature full withdrawal and also in case of pre mature partial withdrawal The processing logic is mentioned in the below table Insertion in Respective tables Fields in PMS PORTFO 5 the file LIO HOLDING OLDING DE ION for MAT txn TION for INT txn or PEN txn TRAN Can be stored as be stored as Ext Tran or Ext Tran Ref REFNO Ext Tran Idn or Ext Tran Ref CUS Client id Client id Client id Client id TOMER NO CUS ignored ignored ignored ignored TOMER NAME1 ACC Sub_portfolio_id Sub_portfolio_id Sub portfolio id Sub portfo lio id 5 21 ORACLE 3 5 2 ACCOUN Based on Account Basedon Account Based on Prod id CLASS class whether itis class whet
146. l recurring transfer from register lections PC external account Inward Remit This function displays remit No Funds Transfer tance Inquiry tance received from other Payment and banks Collections Outward Remit This function displays remit No Funds Transfer tance Inquiry tance sent to the other banks Payment and Collections Domestic Collec This function displays status No Collections tion Inquiry the domestic cheques send for collection FCY Collection This function displays status of No Collections Inquiry the International cheques send for collection 6 38 ORACLE Transaction Name Transaction Description Administration Transaction Oracle FLEXCUBE UBS Module Beneficiary Maintenance This function allows user to register for beneficiaries for later reuse for following pay ments transactions Internal Transfer Domestic Transfer Demand Draft International Drafts International Transfers SEPA Credit transfer SEPA Card Payments UK Payments For internal funds transfer Beneficiary details are verified with the Host The Beneficiary data is main tained in FCDB No View Limits Utili zation This function allows user to view the limits allocated to them and their current utilisa tion No Change Limits This function allows user to change the existing limits allot ted by the bank No Global Benefi ciary Mapping This transacti
147. l the term Deposits rot available to the cus Structured Funds Deposits Term Deposit This function displays details Yes Retail Term Details of the selected Term Deposit Deposits Structured Funds Deposits Loan Details This function displays the No Consumer Lend details of the selected loan ing account like loan product details disbursed amount outstanding balance details Own Account This function allows user to No Funds Transfer Transfers transfer funds between own FT CASA accounts within the bank Internal Trans This function allows user to No Funds Transfer fers transfer the funds to any other FT CASA account or GL account within the bank Register Biller This function allows user to No Utility Payments register the Billers maintained UP in Oracle FLEXCUBE Univer sal Banking Module Pay Bills Bill This function allows user to No Utility Payments Payment pay the bills to registered bill UP ers Delete Biller This function allows user to No delete the biller registered ear lier Biller details are maintained in FCDB and deletion of a biller is also within FCDB Cheque Book This function allows user to No CASA Request request a chequebook Cheque Status This function displays the No CASA Inquiry cheques status Stop and This function allows user to No CASA Unblock Cheque block a cheque payment or Request revoke the stop payment instruction issued earlier 6 52 ORACLE
148. lance principal Backdated INT PAR or MAT transactions should be allowed by the system so long as it doesnt fail the other rules as mentioned in rules 2 3 4 above For the specified currency given along with the transaction if system does not find FX Rate maintained for Instrument Currency against with either Customer Currency Portfolio Currency Household Currency then system should reject with the reason No FX Rate available for specified currencies If default Portfolio is not found for the client then system should reject with the reason No default portfolio exists for the client If no Instrument of type TD is setup for the specified currency then system should reject using reason No Instrument exists for the specified currency If no relevant setup for Instrument and the specified currency is present then system should reject with the reason No Instrument ALT MST BANKING PROD ALT setup exists for the Instrument with specified currency 320 ORACLE 3 5 3 5 1 10 There should be no validation related to Transaction Date falling on a Holiday and no rejection should be done even if the transaction date is a System Currency Exchange holiday 11 All typical reject reasons in Enrichment procedures should be handled like mandatory field checks giving reject reasons like Invalid Amount Invalid Date Invalid A C No Invalid Transaction Type etc Data Transfer using File Upload Mechan
149. lready been generated and sent across to the customer FCPB will not generate advices for the same Spread is also one of the expected fields in the Segmentation Upgrade format for TD Booking To capture Spread in BPS at FCUBS end the Account Class for TD Product is created with a UDF with FLDNAME as SPREAD and the Field_Value for this UDF will contain the Spread This Field_Valule would also be sent in the Segmentation Upgrade file Transactions for Interest Penalty and Maturity Called TD DEALMAT The same format would be used for EOD batch handoff and customer upgrade handoff for the TD Maturity Interest Penalty file FCUBS will only send Active TDs as part of Segmentation Upgrade handoffs No Closed Matured TD Bookings or any other transactions Holdings regarding Matured TDs would be sent For NEW PAR RNW INT MAT and PEN records received as part of Segmentation Upgrade system updates the Settlement Flag as in PMS TRANSACTION Processes then get triggerred to copy Settled Market Value from Market Value column in PMS PORTFOLIO HOLDINGS since TD Instrument Type does not require any separate Settlement Since this is indicative of the fact that the advice has already been generated and sent across to the customer FCPB will not generate advices for the same d ORACLE 3 6 5 3 7 Holdings level file with Accrued Interest as of Date for TD Since Accrued Interest is already sent everyday as a part of EOD from FCUBS to
150. m Direct Banking the sessions behave independent i e even if the business user logs out of Oracle FLEXCUBE Direct Banking Oracle FLEXCUBE Private Banking session stays alive as per the session management policy set for Oracle FLEXCUBE Private Banking The same also holds true if Oracle FLEXCUBE Direct Banking session has been terminated The Investment portfolio of the customer is also displayed in the Account Summary Widget and Account Summary Transaction if the customer is wealth enabled in FCDB and has a wealth portfolio in Oracle FLEXCUBE Private Banking system Session Management For Single Sign On between Oracle FLEXCUBE Direct Banking and Oracle FLEXCUBE Private Banking it is required that a new session be created in Oracle FLEXCUBE Private Banking whenever the user clicks on the Wealth Management link in Oracle FLEXCUBE Direct Banking Oracle FLEXCUBE Direct Banking invokes the Oracle FLEXCUBE Private Banking URL once the user clicks on the Wealth Management link Following parameters are passed from FCDB to FCPB for the link invocation 10 IPADDRESS PORT DEVICE TYPE SESSIONID JSESSIONID USER AGENT USERID ENTITYID Upon invocation of the Oracle FLEXCUBE Private Banking URL Oracle FLEXCUBE Private Banking verifies the validity of the request by invoking a session validation business service exposed by Oracle FLEXCUBE Direct Banking The service invoked for such s
151. m Core Banking System Suspended customers in FCPB are not allowed to place orders or trade though their Portfolio Details can be viewed via Portfolio Maintenance Analysis screens etc as per currently existing functionality in FCPB Note Even if a customer gets downgraded subsequent flow of TD deal information account no tifications balances notifications will continue to flow into FCPB from FCUBS If the downgraded customer gets re upgraded in FCUBS then the CIF Modification online interface would send the Status as Re upgraded R This would prompt FCPB also to update the status back to A Active and activate the customer for all normal activities in FCPB like Order Placement etc In case of such re upgrades FCUBS does not send the set of files related to portfolio and other handoffs as part of the EOD Segmentation Upgrade to FCPB Additional Validations to Customer Creation screen to support Segmentation Upgrade 1 FCUBS would validate that when CIF creation is done for first time the segment status cannot be Downgrade Ts ORACLE 3 6 1 3 6 2 2 Ifthe RM or any other user who is creating the CIF decides to leave the segment related fields blank then those customer data would not be handed off to FCPB 3 FCUBS would also validate that once a customer is downgraded later the status can only be changed to re upgrade It is assumed that no closed CASA account details would be handed off by FCUBS as a
152. mer Mainte nance Customer Profile Initiate fcat vw mstcorpo rate Customer Mainte nance Modify Customer Profile fcat vw mstcorpo rate Customer Mainte nance Customer Account Setup fcc vw mstaccount Customer Mainte nance Linked Customer Account Setup fcc vw mstaccount Customer Mainte nance User Account Setup Customer Mainte nance View Customer Pro file Customer Mainte nance Disable Enable Customer Profile Authorization Maintain User Lists Mandates Authorization Manage Rules Mandates 6 59 ORACLE Transaction Group Transaction Name Database Views XSD names Transaction Activi ties Transaction Activi ties Transaction Dash board Transaction Status Change Transaction Dash board Request Processing Core Mainte Manage Policies nances Core Mainte View Audit Log nances Core Mainte Transaction Cut Off nances Core Mainte Deal Timer and Cut nances Off Core Mainte Transaction Black nances Out Core Mainte Global Limits Pack nances age Core Mainte Transaction Pass nances word Configuration Core Mainte Role Subject map nances ping Core Mainte Calendar Mainte nances nance Core Services Mail Box Core Services Preferences Core Services Change Password Core Services Session Summary Core Services Site Map Co
153. mers are segmented on the Next Business Date Future Dated TD Booking limitation In this release there is a limitation on opening TDs with account opening date in future FCPB rejects any booking with future booking date Hence in FCUBS if a TD is booked with pay in through Cheque and after considering Floating Check Clearing days as say 2 days the account opening date will consider the next business day which would be in the future An enhancement may be taken up by FCPB in the future to allow such future dated TDs also Zero Balance TD limitation In FCUBS TDs be created with 0 balance i e Recurring Deposit TDs etc wherein the Booking Amount is credited later When such TD Booking XMLs are sent to FCPB FCPB is accepting the TD and creating a Zero Booking Amount for the TD This will however create a problem when customer tries to withdraw the TD in UBS later and this PAR XML will be rejected by FCPB saying PAR amount cannot be greater than Balance Principal Customer Creation Modification For corporate clients in this release FCPB can support only 1 Director and his details If more than 1 director is input in FCUBS FCPB is having capability to show only first one ORACLE 4 1 4 Oracle FCPB FCDB Interface Introduction Oracle FLEXCUBE Private Banking FCPB is integrated with Oracle FLEXCUBE DIRECT BANKING FCDB This integrated system will provide a single sign on to users for accessing Oracle FL
154. mestic Draft or pay order International This function allows user No Funds Transfer Transfers transfer the funds to accounts FT in other banks in other coun tries View Demand This function allows viewing all No Demand Draft Draft the domestic and international demand drafts and paying orders issues to a customer Own Account This function allows user to No Funds Transfer Transfers transfer funds between own CASA accounts within the bank FT ORACLE Transaction Administration Oracle Name Transaction Description Transaction FLEXCUBE UBS Module Internal Trans This function allows user to No Funds Transfer fers transfer the funds to any other FT CASA account or GL account within the bank Multiple Internal This function allows user to ini No Funds Transfer Transfer tiate the multiple internal FT transfer transactions from one screen Domestic Trans This function allows user No Payments amp Col fers transfer the funds to accounts lections PC in other banks using domestic payment network Fixed Domestic This function allows user No Payments amp Col Transfers transfer the funds to accounts lections PC in other banks for fixed accounts using domestic pay ment network SEPA Direct This function allows user to ini No Payments amp Col Debits tiate a SEPA Direct debit lections PC transaction SEPA Credits This function allows user to
155. n The details of Customer CASA Closure Modification Notifications are given below Process Flow The following steps are involved in the process 1 Once a CASA Account gets closed in FCUBS the same should get reflected in FCPB NOTIF CA CUSTACC MOD XML would be used to handover the CASA closure details to FCPB When the txnstat tag reads as C it indicates that the CASA account is closed 2 The Notification Code for CASA Modification Closure will be NOTIF CUSTACCMOD PB FCPB Column Name Description a Pane a9 CRM_CLIENT_BANK_ACCT TXNSTAT C Bank_Acct_id ACC Client id is based on External 1 CUSTNO which is being sent as CUSTNO Acct Stat should change to C 912 ORACLE 3 4 8 Closing Date Should be defaulted as Current Business Date on receipt of TXNSTAT as 3 CASA Accounts modified in FCUBS for the following fields would also trigger a Modification XML and the system updates following fields in FCPB FCPB Column Name Description FCUBS Element Name as per the XML CRM CLIENT BANK ACCT TXNSTAT O Bank_Acct_id ACC Acct_CCY CCY Acct_Sub_ Type ACCTYPE Update Client id based on External Id which CUSTNO is being sent as CUSTNO Opening Date ACCOPENDT Acct Branch Branch Code Acct Country id Country Code Acct Description ADESC Note The CUSTNO can
156. nated TS ORACLE 10 11 12 13 14 15 16 17 18 19 TD Booking Only Fixed Interest Type of TDs and of Simple Interest Type would be supported in this release No Floating TDs or Compound Interest Type would be supported Dual Currency Deposits would also not be supported in this Release TD Rollover Only Rollover Types of Principal or Principal Interest would be supported in this release Special Amount Rollovers would not be supported Recurring Deposit TDs In this release Top Up event for Recurring Deposits would not be supported by FCPB Recurring Deposits expects that an automatic top up of the Deposit Booking Amount is performed by FCUBS as per the pre determined top up frequency which should trigger a new XML Notification with the top up amount mentioned This Notification workflow is not available in the current release between FCUBS and FCPB Discounted TDs workflow in FCUBS Discounted TDs are those wherein Interest is paid upfront to the Customer FCUBS would be sending this INT transaction as a part of BOD of the Business Date after the Booking Date Also Accrued Interest sent daily for such Discounted TDs would be 0 everyday till 1 day prior to Maturity Date TD with Interest Liquidation to TD A C In this release there is a limitation to support TDs where Interest Liquidation is to TD Account instead of CASA Account Such TDs are either capitalized non capitalized TD or Autorollover
157. ncremental online Any changes in the CASA Balances of the customer will be notified by FCUBS to FCPB 3 The notification code used by FCUBS to communicate the change in the customer balances would be NOTIFY AC BAL 4 On account balance notification the PMS PORTFOLIO HOLDING table is populated with the Market Value and Total Acq Cost columns based on the balances received in the notification message FCUBS Element Name as per FCPB Column Name Description the XML SUB PORTFOLIO ID CASA Account no CUST AC NO PMS PORTFO LIO HOLDING ORACLE 3 4 7 3 4 7 1 FCUBS Element Name as per FCPB Column Name Description the XML Client id PMS PORTFO CIF ID CUSTNO LIO HOLDING INSTRUMENT CCY Currency ofthe CASA CCY PMS PORTFO Account LIO HOLDING VALUE DATE The date of receipt of Since it is online notification the PMS PORTFO the balances XML would be received as and LIO HOLDING when the balances are updated So the date of receipt of the XML notification would be populated as value date TOTAL ACQ COST Actual Balance ACBALANCE PMS PORTFO including unclear bal LIO HOLDING ances MARKET VALUE Balance available to ACAVLBAL PMS_PORTFO LIO_HOLDING be spent HOLD_AMOUNT PMS_PORTFO LIO_HOLDING The current balance minus available bal ance would give the blocked hold amount ACBALANCE ACAVLBAL CASA Closure Modificatio
158. ne and adminis trator needs to update the sta tus of the request No Supplementary Card Request This service request allows a user to request for a new sup plementary credit card These transactions have to be processed offline and adminis trator needs to update the sta tus of the request No Activate Credit Card This service request allows a user to request for activation of a credit card These transactions have to be processed offline and adminis trator needs to update the sta tus of the request No Merchant Main tenance This transaction allows bank administrator to register vari ous merchant vendor to whom online Funds transfer facility is to be provided Merchant information will be stored within the FCDB only amp will not be sent to the host Yes 6 41 ORACLE Transaction Administration Oracle Name Transaction Description Transaction FLEXCUBE UBS Module External Pay This transaction allows users No Funds Transfer ment to make the payment to vari FT ous registered merchant ven dor online Reconciliation is not supported Loan Details This function displays the No Consumer Lend details of the selected loan ing account like loan product details disbursed amount outstanding balance details Loan Schedule This function displays repay No Consumer Lend ment schedule of selected ing loan account The repaym
159. ns configured in Payment and the host banking system Collections Cancel Standing This function allows user to No Funds Transfer Instructions cancel Standing Instructions Payment and configured in the host banking Collections system View Pending This function allows user to No Funds Transfer Transfers view transactions which are Payment and schedule to be executed Collections accounted on future date Cancel Pending This function allows user to No Funds Transfer Transfers cancel transactions which are Payment and schedule to be executed Collections accounted on future date Inward Remit This function displays remit No Funds Transfer tance Inquiry tance received from other Payment and banks Collections Outward Remit This function displays remit No Funds Transfer tance Inquiry tance sent to the other banks Payment and Collections Domestic Collec This function displays status of No Collections tion Inquiry the domestic cheques send for collection FCY Collection This function displays status of No Collections Inquiry the International cheques send for collection 6 20 ORACLE Transaction Name Transaction Description Administration Transaction Oracle FLEXCUBE UBS Module Beneficiary Maintenance This function allows user to register for beneficiaries for later reuse for following pay ments transactions Internal Transfer Domestic Transfer Domestic Demand Draft
160. nserted into PMS TRANSACTION PMS PORTFOLIO HOLDING and PMS TD HOLDING DETAILS tables Once the account is created the PMS PORTFOLIO HOLDING table is populated with Client Id TD Account No Market Value and Total Acquisition Cost columns with the deposit amount PMS TRANSACTION table would also store the details as mentioned above The Bid Ask indicator would be maintained as B for the newly created TD account PMS TD HOLDINGS DETAILS table would also store details like Client ID Portfolio ID Sub Portfolio ID Instrument ID Prod ID Balance Currency Maturity Date Int Rate Tenor Tenor Dm Account Status and Booking Date Based on the XSD service used by FCUBS in transmitting the data to FCPB the Tran Type would be populated PM8 TRANSACTION table The Tran Type would be inserted as NEW in the PMS TRANSACTION table On insertion of the record in PMS TRANSACTION table advice would be generated for TD Account creation FCUBS Element Name FCPB Column Name Description as per the XML TRAN DATE ACCOPENDT TRAN TYPE to be Would be populated based on the defaulted to NEW xsd notification service received from FCUBS AMOUNT TDAMT AMT_CCY CCY CLIENT_ID CUSTNO SUB PORTFOLIO ID ACC SUB PORTFO ACC LIO ID PMS PORT FOLIO HOLDING s ORACLE FCPB Column Name Description FCUBS Element Name as per the XML CLI ENT ID PMS PORT FOLIO HOLDING CUSTNO
161. ntation team using Field Access Controller screen and framework in FCPB Create Customer for BROKER If Customer Category is BROKER then even though the Segment is BLANK FCUBS would send an online Customer Creation Notification to FCPB and FCPB would enter the details for a Broker in MST Broker table We assume that nobody would enter Segment in FCUBS screen for Broker category and in case if it is done by mistake there would be Segmentation Upgrade files generated at EOD even for Broker which would result in rejection of these records in FCPB Hence for BROKER Category Segment should not be filled in the FCUBS screen Banker Id from FCUBS would be the Same as Wealth Department s RM This is an assumption we are making that the same RM would service the customer from Core Banking and FCPB side Because that s the only way we can map a customer s Primary RM after receiving Banker Code from FCUBS as a part of Customer Creation interface Similar assumption is being made on Customer s Unit Home Branch Since FCUBS would be sending the customer s branch the Branch Unit Hierarchy in FCUBS and FCPB is assumed to be synchronized and the same Synchronization of other REF tables Few REF tables need to maintain same values in FCUBS and FCPB and this should be considered as a pre requisite for every Implementation These are viz REF CURRENCY REF COUNTRY CRM UNIT MASTER CRM BANKER etc For certain other tables like REF CLIENT CATEGORY REF CLIE
162. o lock their own transaction password Allows the user to lock the transaction pass word if user do not wish to authorise the transaction No Change Limits This function allows user to change the existing limits allot ted by the bank No Reissue Trans action Password This function allows user to send a request issuing trans action password These transactions have to be processed offline and adminis trator needs to update the sta tus of the request No Request Pro cessing This function allows business users to release the transac tion after re verification post final authorisation This trans action can also be used to tank a transaction temporarily within FCDB if required No Open Additional CASA Account This function allows user to open a new CASA account by debiting existing CASA account No CASA Islamic CASA Register Reports This transaction allows the user to register and schedule various reports for download view at a later stage Registration data is main tained in FCDB and gets inte grated with Oracle Publisher No ORACLE Transaction Name Transaction Description Administration Transaction Oracle FLEXCUBE UBS Module Account Closure This function allows user to send a request for closing an account These transactions have to be processed offline and adminis trator needs to update the sta t
163. o id ACCOUNT CLASS Based on Account class whether it is TD or call deposit instrument id and instrument type would be populated S TRANSACTION TYPE Tran Type should be defaulted to PEN 3 23 ORACLE TRN DT Tran Date LCY AMOUNT Amount ACC CCY Amt CCY AC NO Bank Acct id RECORD STAT Ignored 3 5 4 Loan and Liability Information FCUBS uses CSV Format to hand off the loan and liability information All the relevant fields are inserted into PMS PROD BAL table An entry is also made in CRM CLIENT BANK ACCT as well The details are mentioned below The processing logic is mentioned below Fields in File Format Insertion in Respective Tables CRM CLIENT BANK ACCT CUSTOMER ID Client id ACCOUNT NUMBER BANK ACCT ID PROD Acct Typ ACCT ADDRESS Ignore ACCT ADDRESS and default Address from MST BANK For a liability product the portfolio id would not be populated in CRM CLIENT BANK ACCT as it is currently being followed in the application While updating the Amount column in PMS PROD BAL table if the Amount provided in the Prod Bal file for LIABILITY type of Prod ID by referring MST BANKING PROD table s ASSET IND as 17 is a positive value it is updated with a negative sign FCUBS would be sending Loan Liability Amounts as positive and hence these are inserted as negative 3 24 ORACLE 3 6 values in the PROD BAL
164. ode The namespace is decided by the implementer at the time of implementation and NOTIF CODE would be NOTIF PB CUSTOMER Note There is no difference in Namespace or NOTIF CODE for Creation and Modification of a customer Process Flow The following steps are involved in the process 1 Onreceipt of Customer New CIF AUTH NOTIFICATION XML from FCUBS the customer gets created in FCPB and the various tables get populated to store customer data like CRM CLIENT MASTER CRM CLIENT PREFERENCES CRM CLIENT ADDRESS etc and CIF status gets updated to Active 2 Oncetheclient status becomes active the default portfolio for the client gets created This is a customized script since different Banks would have different requirements for creating default portfolios i e specific Portfolio Types like RMM SLF HLD etc 3 Any modifications that are initiated at FCPB like risk profiling and other details for which FCPB is the owner are automatically updated in FCPB and are not sent to FCUBS for any further authorization 4 The COMPLIANCE REQUIRED YN flag in REF BANK is maintained as N so that the modifications via Demographics screen will not be sent to Compliance etc and status of Customer can be made Active immediately 5 When any modifications are made in the CIF demographic data in FCUBS like address email a full screen response notification is sent back to FCPB with the amended details 6 Theclosure of CIF
165. on Bulk Maintenance File Control Defi nition Bulk Maintenance Bulk Registration Bulk Maintenance User BTID Map Bulk Maintenance Update File Status Bulk Transactions Bulk File Uploads Internal Transfer FTContract Create Req Full MSG xsd Bulk Transactions Bulk File Uploads Domestic Trans fer PCContract Create Req Full MSG xsd Bulk Transactions Bulk File Uploads International Funds Transfer FTContract Create Req Full MSG xsd Bulk Transactions Bulk File View 6 3 17 Oracle FLEXCUBE Direct Banking Retail Account Inquiries The transactions and the respective database view XSD are as follows fication Transaction XSD Names Group Views UBS Alerts Account Balance Noti CA CustAcc Bal Notify MSG xsd 6 84 ORACLE Transaction Transaction Name Database XSD Names Group Views UBS Alerts Account Status CA CustAccStat Notif xsd Change Notification UBS Alerts Clearing Reject Notifi CGReject Notif MSG xsd cation UBS Alerts Stop Payment Notifica CGStoppayment Notif MSG xsd tion UBS Alerts Term Deposit open TD NewAccount Notify MSG xsd UBS Alerts Term Deposit Status change Notification UBS Alerts Funds Transfer Con FTContract Notif MSG xsd tract Notification UBS Alerts Utility Payment Trans UPTransaction Notif MSG xsd action Not
166. on allows the bank administrator to map restricted beneficiaries to busi ness users Yes Credit Card Summary This function displays sum mary of the Credit cards hold by the user No Credit Card Statement This function displays the Credit Card Statement No Credit Card Details This function displays details of the Credit cards hold by the user No Credit Card Pay ments This function allows the user to pay the credit card dues No 6 39 ORACLE Transaction Name Transaction Description Administration Transaction Oracle FLEXCUBE UBS Module Register Credit Card This function allows the user to register for existing credit cards held by them for access ing through FCDB No Modify Supple mentary Card Limit This function allows the user to modify the limit of the sup plementary credit cards No Apply for Credit Card This service request allows a user to request for a new credit card These transactions have to be processed offline and adminis trator needs to update the sta tus of the request No Credit Card Hot Listing This service request allows a user to request for blocking a credit card These transactions have to be processed offline and adminis trator needs to update the sta tus of the request No Change Credit Card Billing Cycle This service request allows a user to request for change
167. onal Funds Transfer FTContract Create Req Full MSG xsd Bulk Transac tions Bulk File View Bulk Transac tions Bulk Authorisa tions FLEXCUBE Direct Banking Corporate Term Deposits The transactions and the respective database view XSD are as follows Transaction Group Transaction Name Database Views XSD names Term Deposits Term Deposit Details fcc vw msttddetails fcc vw mst std de tails Term Deposits Term Deposit Activity fcat vw txnaccoun tactivity fcat vw accountde tails fcc vw mstaccount fcc vw actb vd bal Term Deposits Open Term Deposit Conven tional fcc vw mstproduct classes ST CreateTDCustAcc Req Full MSG xsd 6 69 ORACLE Transaction Group Transaction Name Database Views XSD names Term Deposits Amend Term Deposit Conven tional fcc vw msttddetails fcc vw ictm tdpay out details fcc vw ictm tdpay in details fcc vw mst std de tails ST ModifyTDCustAcc Req Full MSG xsd Term Deposits Redeem Term Deposit Conven tional fcc vw msttddetails fcc vw ictm tdpay out details fcc vw ictm tdpay in details fcc vw mst std de tails IC CreateTDRedem Req Full MSG xsd Structured Term Deposits Structured Deposit Subscrip tion fcc vw sd scheme details SF CreateSFSub Req Full MSG xsd Structured Term Deposits View Su
168. ontract Deposit Details fcat vw mstldprod uct fcat vw mstld productdetails fcc vw oytm defn fcc vw cst m prod disallo w fcat vw tenurein terestdtls fcat vw mstbranch fcc vw cstm prod uct fcat vw mstinterest comp fcat vw maturityin structions Contract Deposit Open Contract Deposit LDContract Mas ter Req Full MSG xsd Term Deposits Open Term Deposit Islamic fcc vw mstproduct classes IA CreatelATD CustAcc Req Full fcc vw ictm tdpay in details fcc vw mst std de tails MSG xsd Term Deposits Amend Term fcc vw msttddetails IA ModifyIATD Deposit Islamic fcc vw ictm tdpay CustAcc Req Full out details MSG xsd fcc vw ictm tdpay in details fcc vw mst std de tails Term Deposits Redeem Term fcc vw msttddetails IA CreateRe Deposit Islamic fcc vw ictm tdpay demption Req out details Full MSG xsd Additional Interfaces The transactions supported by the integration under this module and the details of XSD and XSL files are given below Transaction Redeem Term Deposit Interface Request XSD Request Host Response Pier Name Name Interface XSL XSD Name XSL TD Redemp IC CreateT RedeemTDMa RedeemTDMa IC CreateT tion simulation DRedem Req turityDtlReq xs turityDtIRes xsl DRedem Res Full MSG xsd Full MSG xsd 6 99 ORACLE 6 4 Transaction Open Term Deposit
169. osits FCUBS hands off to Oracle FCPB the details of penalties applied on term deposits This handoff happens only for the customers whose segment code and segment status are defined in the system To enable handoff of this data from FCUBS you need to define the interface details as given in the following table Field Value Interface Code STOIMDTL Interface Type Outgoing ORACLE Field Value From System FCUBS To System FCPB Dateformat YYYYMMDD File Mask EDU Whentorun Beginning of day Frequency Daily Character Set ASCII Format Delimited Delimiter File Header record length 3 Default value HDR Body Record Length 36 File Footer record length 3 default value TLR Numeric padding Left padding with Zeros Text padding Left padding with spaces Datalog Required Yes CRC Required No Triggering System In Component Details sub screen you need to maintain the following details Table Field Field Name Column Name Data Type Length Position HEADER VARCHAR2 1 AC REF TDVW AC ENTRY SR NO NUMBER 10 1 D DE TAILS CUST NO TDVW T CUSTOMER NO VARCHAR2 9 11 D_DE TAILS CUST_NAM TDVW_T CUSTOM VARCHAR2 105 20 E D_DE ER NAME1 TAILS TD ACC TDVW T ACC VARCHAR2 20 125 D DE TAILS 2 10 ORACLE 2 5 4
170. ot 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 to third party content
171. pPayments FTContract Create Req Full MSG xsd FCUBSFTService CreateContract SIContract Create Req Full MSG xsd FCUBSSIService CreateSIContract FTContract Create Req Full MSG xsd FCUBSFTService CreateContract SIContract Create Req Full MSG xsd FCUBSSIService CreateSIContract FTContract Create Req Full MSG xsd FCUBSFTService CreateContract SIContract Create Req Full MSG xsd FCUBSSIService CreateSIContract DDTransaction Create Req Full MSG xsd FCUBSDDService CreateTransaction MO Save AccSim Req Full Msg xsd FCUBSMOService SaveAccSim 6 101 ORACLE 7 Oracle FLEXCUBE Direct Banking Universal Banking Notifications 7 1 Introduction Oracle FLEXCUBE Universal Banking Oracle FLEXCUBE Direct Banking integration provides for exchange of data between the two systems This enables the users of Oracle FCDB to access the information stored in Oracle FCUBS application This chapter contains the list of notifications 7 2 Notifications 7 2 4 Oracle FLEXCUBE Direct Banking Corporate Customer Services Transaction XSD names UBS Alerts Account Balance Notification CA CustAcc Bal Notify MSG xsd UBS Alerts Account Status Change Notification CA CustAccStat Notif xsd UBS Alerts Clearing Reject Notification CGReject Notif MSG xsd UBS Alerts Stop Payment Notification CGStoppayment Notif MSG xsd UBS Alerts
172. part of segmentation upgrade files Only online notifications are planned for CASA creation and modification and any field level change of CASA would trigger a modification Note As a part of customer upgrade files FCUBS will not send any modification of accounts It s a one time hand off of all the accounts for the upgraded customer The set of interfaces files for Segmentation Upgrade Downgrade are detailed in the below sections Customer File Upload Segmentation Upgrade Once a customer gets upgraded as per the segmentation rules FCUBS sends an online notification based on which customer gets created in FCPB FCUBS also generates an EOD file handoff for these customers and sends it to FCPB Subsequent updates to these customers will be received via online notifications Whenever a customer is created in FCPB a script is executed which auto creates the Login ID of the customer and makes an entry in SMS APP USER table The Password field in SMS APP USER will be updated as blank and will not have any significance since FCPB expects SSO for Customers from FCDB The Role given to the customer would be the same as his Segment after appropriate transaction transformation to FCPB s specific Segment Codes For supporting this Roles would have to be created for every segment which can be mapped as Customer Role and the name of these roles would be identical to the Segment EXT Portfolio Id In the current Rel12 0 FCPB assumes t
173. play relevant information for the CIF Customer Id that is passed from FCDB Investment Portfolio Details from FCPB to FCDB The integrated system enables the user to view the Holdings Investment data available in FCPB if the logged in user is a Wealth Customer and has wealth portfolio in FCPB The data is presented for all portfolio types i e Overall set of portfolios like RM Managed Self Managed Held Away and Discretionary The FCPB system displays the holding for a customer grouped by Instrument Type as shown in the below screenshot This data will be passed on to FCDB via the interface The integrated 4 ORACLE system excludes fetching the details for instrument Types like CASA and or TD which are already present in the FCDB core banking system ORACLE User HOHEAD Current Login 07 05 2012 3 21 PM Last Login 07 FLEXCUBE janking Home Customer Financial Planning Order Mgmt Txn Mgmt Reports Tools My Workspace Logout Customer gt Portfolio gt Analysis Category Instrument Type Portfolio Type E Balance Sheet gt Go finstrument Type Sandy Kumar nuum Instrument Type Buy Cost Market Value of Total Profit Loss Profit Loss Pie Chart Corpus 1 186 710 00 1 186 710 00 94 93 0 00 A 0 00 MutualFund 63 290 00 63 415 00 5 07 125 004 0 20 Total INR 1 250 000 00 1 250 125 00 100 0096 125 004 0 0196 one finstrument Type Details MutualFund
174. provided FATCA by FCUBS consider as it is assuming that there would be synch between both the systems RECALCI Recalcitrant NO RECALCI STT TRANT TRANT M CUST FATCA EIN EIN NO CUST EIN STT M CUST FATCA DATE OF IS ISSDATE NO EIN IS STT SUE SUE DT M CUST FATCA 2 31 ORACLE FCUBS MANDA FCUBS FIELD NAME DESCRIPTION TORY Column Tabla Name Name DATE OF EX EXPDATE NO EIN EXPI STT PIRY RY DT M CUST FATCA TIN TIN NO CUST TIN STT M CUST FATCA TIN DATE OF TIN EXPIRY DATE NO TIN EXPI STT EXPIRY RY DT M CUST FATCA GIIN GIIN NO TIN EXPI STT RY DT M CUST FATCA COMMENTS User Comments NO REMARKS STT M CUST FATCA EFFECTIVE FCPB Effective date of NULL DATE FATCA classification should get auto popu lated as current business date in FCPB NOT EXPECTED FROM FCUBS SHOULD BE BLANK 2 32 ORACLE 3 1 3 2 3 3 3 Oracle FCPB FCUBS Interface Introduction Oracle FCPB FCUBS interface has been primarily designed to enable the exchange of information between FCPB and FCUBS in terms of day to day transactions and maintenances for certain entities like Customer Creation CASA Account Creation TD Accounts Creation Transactions and Balances related to Loans and Liabilities This chapter deals with the following interface and the explanation of the same from FCPB setup perspective e Customer Creat
175. rator to maintain limit packages Transaction This transaction allows the Yes Password Con bank administrator to config figuration ure the transactions which shall require transaction pass word ORACLE Transaction Name Transaction Description Administration Transaction Oracle FLEXCUBE UBS Module Role Subject mapping This transaction allows the bank administrator to map the subject defined for the pur pose of mail messaging with the roles Only those adminis trators get the mail who are having access to the relevant role Yes Calendar Main tenance This transaction allows the bank administrator to setup calendar i e marking weekly holiday and other holidays This transaction is also used for set up of Currency holi days This is applicable for third party implementations where host does not provide the working business days Yes Mail Box This function allows bank administrator to view and reply for various communication done by business user using FCDB internal messaging facility Yes Preferences This function allows user to set different preferences for accessing FCDB application Yes Change Pass word This transaction allows bank administrator to change their own password Yes Session Sum mary This function displays activity details of the user done in last N Sessions Yes Site Map This function displays all
176. re Services Maintain Bulletins Core Services Alerts Registration fcat vw mstcorpo rate fcc vw mstac count Core Services Register Reports Core Services Map Reports To User 6 60 ORACLE 6 3 2 Transaction Group Transaction Name Database Views XSD names Core Services User Manual Down loads Core Services View Reports System Mainte nance Manage Timer Ser vices System Mainte nance Manage Application Messages System Mainte nance Configuration Prop erties System Mainte nance View System Log System Mainte nance Host Interface Log System Mainte nance Entity Management Help Desk User Advance Search Help Desk User Session Manage ment Wrap ses sion Create Session Oracle FLEXCUBE Direct Banking Corporate Customer Services The transactions and the respective database view XSD are as follows Transaction Transaction Name Database Views XSD names Group Customer Reminders Services Customer Mailbox Conversa Services tions Customer Mailbox Alerts Services Customer Mailbox Tasks Services Customer Mailbox Attachment Services Customer Ad hoc Statement Services Request Loans Accounts 6 61 ORACLE Transaction Transaction Name Database Views X
177. rs These reminders shall be saved registered at central repository at the Host third party provider Mailbox Con Transaction allows all interac No Interactions versations tion to be maintained in a cen tral repository Interaction includes all communication between the business user and bank users like customer services additional services grievances etc Mailbox Alerts Transaction allows all interac No Interactions tion to be maintained in a cen tral repository Interaction includes all communication between the business user and bank users like customer services additional services grievances etc 6 34 ORACLE Transaction Administration Dracle Transaction Description Transaction FLEXCUBE UBS Module Mailbox Tasks Transaction allows all interac No Interactions tion to be maintained in a cen tral repository Interaction includes all communication between the business user and bank users like customer services additional services grievances etc Mailbox Attach Facility to enable users to No Interactions ment attach files to the mail being sent This enhancement is available across the Internet Mobile and Tablet banking channels Term Deposit This function displays details No Retail Term Details of the selected Term Deposit Deposits Account If deposit is created Structured using a Structured deposit Funds
178. ry for Booking IntRate or Rollover IntRate for RNW tranType EXTE external Varchar 40 No Since FCUBS does not have any RNAL tran id separate Transactionld for TD TRA and only uses TD Ref Number N ID this should be sent as NULL BLANK TRAN TranSta Varchar 1 Yes No need to send CLOSED _STA tus TDs only Active TDs to be sent TUS SPRE Spreadin Number 24 6 Yes Only for Floating we have AD BPS Spread Fixed Deposit only has Customer Level Spread Bala to get back ACCO Product Varchar 5 Yes UNT_ altid CLAS S ROLL Rollover Varchar 1 Yes Mandatory for Can be P or OVER Type rollover Trans P l as Rollo actionType ver Type E oNLY 2 28 ORACLE FIELD DESCRIP LEN MANDAT SAMPLE NAME TION TYPE GTH ORY REMARKS VALUES INTER Interest Number 24 6 No This indicates EST Amt for the Interest to AMOU Rollover be paid to cus NT P type tomer on the RolloverDate for a P type of Rollover Customer TD Interest Liquidation Penalty File Format The format of the customer TD interest liquidation penalty file is given below MANDA SAMPLE FIELD NAME DESCRIPTION TORY REMARKS VALUES TRAN REF NO Can be stored as Yes Ext Tran Idn or Ext Tran Ref CUSTOM Client id Yes ER NO CUSTOM ignored NO ER ACC Sub portfolio id Yes ACCOUNT Based on Account Yes CLASS class whether it is TD
179. s function allows user to No delete the biller registered ear lier Biller details are maintained in FCDB and deletion of a biller is also within Pay Bills This function allows user to No Utility Payments pay the bills to registered bill UP ers Bulk Data Dic This function allows bank Yes tionary administrator to create compo nents of bulk file template Bulk Enrichment This function allows bank Yes Definition administrator to create compo nents of bulk file template Bulk Template This function allows bank Yes Definition administrator to create bulk template definition Bulk File Tem This function allows bank Yes plate Definition administrator to create bulk file template File Control Defi This function allows bank Yes nition administrator to create compo nents of bulk file template Bulk Registration This function allows bank Yes administrator to register BTID User BTID Map This function allows bank Yes administrator to map unmap a BTID to a user Update File Sta This function allows bank Yes tus administrator to update status of a bulk file which is to be pro cessed by a third party appli cation Bulk File This function allows bulk Yes Funds Transfer Uploads Inter nal Transfer upload of internal transfers The authorisation types sup ported are 1 File Level Auth File Level Reject 2 Record Level Auth Record Level Reject FT 6 28 ORACLE Transaction
180. s the No Corporate Details summary and details of Term Deposits deposit accounts contracts held by user Loan Details This function displays the No Consumer Lend details of the selected loan ing account like loan product details disbursed amount outstanding balance details Internal Trans This function allows user to No Funds Transfer fers transfer the funds to any other FT CASA account or GL account within the bank Domestic Trans This function allows user No Payments amp Col fers transfer the funds to accounts lections PC in other banks using domestic payment network Register Biller This function allows user to No Utility Payments register the Billers maintained UP in Oracle FLEXCUBE Univer sal Banking Module Pay Bills This function allows user to No Utility Payments pay the bills to registered bill ers UP 6 48 ORACLE Transaction Administration Oracle Nam Transaction Description Transaction FLEXCUBE UBS Module Delete Biller This function allows user to No delete the biller registered ear lier Biller details are maintained in FCDB and deletion of a biller is also within FCDB Cheque Book This function allows user to No CASA Request request a chequebook Stop Cheque This function allows user to No CASA block a cheque payment or revoke the stop payment instruction issued earlier Exchange Rate This function displays No FOREX Inquiry
181. se Views XSD names Islamic Financing Financing Details fcc vw clfrequency fcc vw fcc cloutstanding bal fcc vw clprinperyear fcc vw clintperyear fcc vw clinterest fcc vw clinstallment fcc vw clarrearamt fcc vw clliq VW CLInstall mentPaidUnpaid fcc vw cltb acct ad v payment fcc vw clt b amount paid Islamic Financing Financing Sched ule fcc vw clschedule fcc vw claccount FCC vw CLInstall mentPaidUnpaid Islamic Financing Financing Repay ment Inquiry fcc vw FCC VW clliqcomp settled fcc vw clliq fcc vw cloutstanding bal FCC vw CLInstall mentPaidUnpaid 6 74 ORACLE 6 3 12 Transaction Group Transaction Name Database Views XSD names Islamic Financing Financing Settle ment fcc vw clfrequency fcc vw claccount fcc cloutstanding bal fcc vw clprinperyear fcc vw clintperyear fcc vw clinterest fcc vw clinstallment fcc vw clarrearamt fcc vw clliq VW CLInstall mentPaidUnpaid fcc vw cltb acct ad v payment fcc vw clt b amount paid Cl CreatePayment Req Full MSG xsd Islamic Financing Financing Account Activity fcc vw cltxnaccoun tactivity fcc vw claccount Islamic Financing Financing Profit Rates Inquiry fcc vw clloanrates Oracle FLEXCUBE Direct Banking Corporate S
182. slamic Islamic finance account The repayment schedule contains the instalment components like principal profit percent age charges and outstanding instalment amount Financing This function displays various No Consumer Lend Repayment repayments received for the ing Islamic Inquiry selected Islamic finance account 6 23 ORACLE Transaction Administration Oracle Transaction Description Transaction FLEXCUBE UBS Module Financing Settle This function allows partial or No Consumer Lend ment full pre payment of the ing Islamic selected Islamic finance account Financing This function displays the No Consumer Lend Account Activity transactions happened ing Islamic through selected Islamic finance account The transac tion activity can be down loaded in PDF CSV Financing Profit This function displays interest No Consumer Lend Rates Inquiry rates for various Islamic ing Islamic finance products Payment Notifi This Inquiry function allows No cation Inquiry the Seller to View the Value dated Payment details done by the Buyer Purchase Order This Inquiry function allows No Assignment the Seller to Assign the Pur chase Order details uploaded by the Buyer The Seller selects the Purchase Order to be assigned and the details are e mailed to the pre speci fied e mail ids of the Bank User s Draw Down
183. specified for the field Numeric Numeric fields contain the following information Amounts This type of fields contain digits 0 9 and a decimal separator The number of decimal digits is driven by the currency maintenance of FCUBS Numbers without decimals This type of fields contain digits 0 9 only Numbers with decimals This type of fields contain digits 0 9 and a dec imal separator However these digits do not represent amounts For example exchange rates of currencies may contain decimal Date Dates are represented in YYYYMMDD format For instance March 30 2012 is represented as 20120330 2 1 1 Details Handed off from FCUBS to Oracle FCPB Oracle FLEXCUBE hands off the following details to Oracle FCPB Entity Action Frequency Core Security TD Account Creation Add On line Core TD Premature Withdrawal Add On line Core CASA Account Creation Add On line Core CIF Authorization Modification Closure Add On line Core Broker Data Add On line Core CASA Account Balances Add On line Core Segmentation Information Add On line Core TD Maturity with Interest Liquidation Add Batch Core 2 ORACLE 2 2 Daily Accrued Interest on TD Add Batch Core Penalty on TD Add Batch Core Loan and Liability Information Add Batch Core Segmentation Status Information Add Batch Core Defining Interface Details for Oracle FCPB In
184. stac count 6 80 ORACLE Transaction Group Transaction Name Database Views XSD Names Customer Ser vices E Statement Sub scription fcc vw acct estate ment details fcc vw loanacct est mnt details MS ModifyMSAc cAdd Req Full MSG xsd MS CreateMSAc cAdd Req Full MSG xsd IA ModifylACustAcc Req Full MSG xsd ST ModifyCustAcc Req Full MSG xsd Customer Ser vices Subscribe for other channels MS CreateMSAc cAdd Req Full MSG xsd Customer Ser vices Deactivate Chan nel User IA ModifylACustAcc Req Full MSG xsd Customer Ser vices Lock Transaction Password ST ModifyCustAcc Req Full MSG xsd Customer Ser vices Reissue Transac tion Password Customer Ser Activate Debit vices Card Customer Ser Apply for ATM vices Debit Card Customer Ser vices Reset ATM Debit Card PIN Customer Ser vices Hotlist Debit card Customer Ser vices Account Closure Customer Ser vices Request Process ing Customer Ser vices Register Reports fcat vw mstcorpo rate Customer Ser Download vices Reports Customer Ser Preferences vices Customer Ser vices Account Prefer ence 6 81 ORACLE Transaction Transaction Database Views XSD Names Group Name Customer Ser Session Summary vices Customer
185. t Response Host Name Names XSD Name Interface XSD Name Interface XSL XSL Hold or CA confirmP2 CA confirmP2P Block CreateAmtBI PRequest CreateAmt Response xs k Req Full 5 BIk Res MSG xsd Full MSG xsd Debit PC confirmP2 PC confirmP2P account and CreateContr PRequest CreateCont Response xs credit GL act Req Full xsl ract Res MSG xsd Full MSG xsd Debit PC confirmP2 PC confirmP2P account and CreateContr PRequest CreateCont Response xs credit bene act Req Full xsl ract Res account MSGxsd Full MSG xsd Reverse fcc vw p2p Amount reverseam t Release fcc pcvws Hold If p2p amt bl beneficiary k detail doesn t registers in given number of days Unsubscribe PC PC Beneficiary ClosePTPBe ClosePTP ClosePTPB ClosePTPBe n Req Full BenReque en Res nResponse x MSG xsd st xsl Full sl MSG xsd Modify Peer PC PC Beneficiary ModifyPTPB ModifyP2P ModifyPTP ModifyP2Pb en Req Full BeneRequ Ben Res eneRespons MSG xsd est xsl Full e xsl MSG xsd P2P NA NA Beneficiary fcc vw pct details ms p2p be nef details 6 89 ORACLE Request Response Interface View Request Host Response Host Name Names XSD Name Interface XSD Name Interface XSL XSL P2P create NA PC PC CreateP2PB Bene CreateP2PB CreateP2P CreateP2P eNeficiaryMa eNeficiaryMa BeNeficiar BeNeficiary inteRespons inte Req yMainteRe Mainte e xsl Full quest xsl Res Full MSGxsd MSG xs
186. tained as l ORACLE 3 4 3 4 1 3 4 1 1 In FCUBS we can assign Segments to customers Based on certain factors the RM in FCUBS decides whether a Retail customer is eligible for a Wealth Segment and if eligible upgrades the customers to such a segment Whenever a customer is upgraded to Wealth set of segments all his Accounts Balances TDs etc would be sent to FCPB as EOD File Handoffs For Retail Customers who have not been assigned a Segment or Upgraded even once the system will not send any notifications or EOD File Handoffs to FCPB Transferring Data using XML Files FCUBS sends XML based online notifications for Customer creation modification CASA account creation modification and TD creation transactions to FCPB for the Segmented Customers only It does not send any XML notifications for retail customers that are not allotted any Segment in FCUBS Creating Customer Data Whenever a customer is created in FCUBS with customer type as Individual or Corporate and if the Segment is also defined notifications will be sent by FCUBS via an online notification XML to FCPB If Customer Category is defined as Broker with Segment not being mentioned blank FCUBS will send an online Customer Creation Notification to FCPB FCPB would create the details for a Broker in Broker Master Table If the Segment is not mentioned for the Broker created in FCUBS due to any reason then the system will generate Segmentation
187. tation date Interest liquidation Penalty The following TD details are sent to FCPB 28 ORACLE 2 5 6 1 TD with interest liquidation TD with penalty entries for partial redemption Segment Upgrade File Formats The formats of the above files are given below Customer File Format The format of the customer file is given below FCUBS MELD DESCRIPTION MANDAT COLUMN TABLE NAME EEN NAME ORY GTH NAME EXTER External client YES EXT_REF_ STTM_CUS 20 NAL ID id of customer NO TOMER FCPB CLI FCPB Client ID NULL 10 ENT ID of customer SALUTA Salutation YES CUSTOM STT 30 TION ER PRE M CUST PER FIX SONAL FIRST NA First Name YES FIRST NA STT 105 ME ME M CUST PER SONAL MID Middle Name NO MID STT 105 DLE NAME DLE NAME M CUST PER SONAL LAST NAM Last Name NO LAST NAM STT 105 E E M CUST PER SONAL PHONE RE Telephone NO TEL IS STT 10 SI COUN international D NO M CUST PER TRY CODE country code SONAL PHONE HO Home Phone NO TELE STT 105 ME PHONE M CUST PER SONAL MOBILE A Mobile interna NO 5 STT 10 DDN COU tional country D NO M CUST PER NTRY COD code SONAL E PHONE Mobile Phone NO MOBILE STT 22 MOBILE NUMBER M CUST PER SONAL PHONE OF Office Tele NO NULL 3 C COUN phone interna TRY CODE tional country code 2 15 ORACLE FCUBS
188. tatus of the users who have registered online and opened customer online Applicable for Virtual Banking Role mainte This transaction allows a Cor Yes nance porate administrator to man age roles for their own customer id ORACLE Transaction Name Transaction Description Administration Transaction Oracle FLEXCUBE UBS Module User mainte nance This transaction allows a Cor porate administrator to man age users for their own customer id for the following Create User Modify User Activate User Deactivate User Lock User Unlock User Delete User Revoke User View User Reset Password Yes Create Role This transaction allows bank administrator to create a role Yes Modify Role This transaction allows bank administrator to modify a role Yes Delete Role This transaction allows bank administrator to delete a role Yes View Role This transaction allows bank administrator to view a role Yes Create User This transaction allows bank administrator to create a user Yes Modify User This transaction allows bank administrator to modify a user Yes Activate User This transaction allows bank administrator to activate a user Yes Deactivate User This transaction allows bank administrator to deactivate a user Yes Lock User This transaction allows bank administrator to Lock a user Yes Unlock
189. th bank admin istrator user using FCDB inter nal messaging facility No 6 32 ORACLE Transaction Name Transaction Description Administration Transaction Oracle FLEXCUBE UBS Module Electronic Form This function allows user to write a query to the bank for a particular transaction using e mail messaging Predefined queries are displayed to the user based on the transaction type No Form amp User Manual Down loads This function allows user to download the documents like User Manuals application forms to be downloaded from common location shared over the Bank Internet Site The Files to be downloaded are maintained in FCDB infra structure NO interface with host system is expected No Change Pass word This transaction allows the user to change the password as per password policy defined No Force Change Password This transaction forces the user to change the password as per password policy defined No Site Map This function displays all the transactions available to the user and allows the user to understand the sitemap No Frequently Asked Questions This function displays Fre quently Asked Questions FAQ and their answers A link to the FAQs prepared by the bank is provided No News This function displays latest news and events for bank A link to the news prepared by the bank is provided No ATM Locator
190. unction allows user to No Utility Payments pay the bills to registered bill UP ers Bulk Data Dic This function allows bank Yes tionary administrator to create compo nents of bulk file template Bulk Enrichment This function allows bank Yes Definition administrator to create compo nents of bulk file template Bulk Template This function allows bank Yes Definition administrator to create bulk template Definition Bulk File Tem This function allows bank Yes plate Definition administrator to create bulk file template File Control Defi This function allows bank Yes nition administrator to create compo nents of bulk file template Bulk Registration This function allows bank Yes administrator to register BTID User BTID Map This function allows bank Yes administrator to map unmap a BTID to a user Update File Sta This function allows bank Yes tus administrator to update status of a bulk file which is to be pro cessed by a third party appli cation ORACLE Transaction Administration Oracle Name Transaction Description Transaction FLEXCUBE UBS Module Bulk File This function allows bulk Yes Funds Transfer Uploads Inter upload of internal transfers FT nal Tank The authorisation types sup ported are 1 File Level Auth File Level Reject 2 Record Level Auth Record Level Reject Bulk File This function allows bulk Yes Payments amp Col Uploads upload of
191. unt statement for the selected account Account statement is to be generated by Oracle FLEXCUBE Univer sal Banking as per the account statement scheduling parame ter No CASA Islamic CASA Con sumer Lending CL Islamic finance CASA Interest Rate Inquiry This function displays the interest rate for Savings prod ucts No Spend Analysis Transaction allows display in a graphical format of the spend analysis of a customer across various accounts held with the bank for a default period Such a default period should be configurable at a system level No Interactions FCPB SSO and Dashboard Allows business user to view investment details from Oracle FLEXCUBE Private Wealth management and also pro vide single sign on facility to users to access FCPB No Dashboard Widget Manage ment Business users will be pro vided with a new transaction through which the business user shall be able to enable or disable widgets to be dis played on their dashboard screens of each channel to which they have access sepa rately No Register Biller This function allows user to register the Billers maintained in Oracle FLEXCUBE Univer sal Banking Module No Utility Payments UP 6 27 ORACLE Transaction Administration Oracle Nam Transaction Description Transaction FLEXCUBE UBS Module Delete Biller Thi
192. upply Chain Financing Supply Chain The transactions and the respective database view XSD are as follows Transaction Group Transaction Name Database Views XSD names Supply Chain Payment Notification Inquiry Supply Chain Purchase Order Assignment Supply Chain Draw Down Inquiry Supply Chain Stock Agent Transac tion Inquiry Supply Chain Investor s Account Inquiry Supply Chain Investor s Account Opening Inquiry 6 75 ORACLE 6 3 13 Oracle FLEXCUBE Direct Banking Corporate Trade Finance Trade Fi nance The transactions and the respective database view XSD are as follows Transaction Group Transaction Name Database Views XSD names Trade Finance Initiate Letters of Credit fcc vw L CVWS PRODUCT SUMMARY fcc vw LCTBS CO TERMS LC Contract Create Req Full MSG xsd Trade Finance Amend Letters of Credit fcc vw lcvw cont prod summary fcc vw lcvw avail ments fcc Ictb amn d vals master LC CreateAmend Confirm Req Full MSG xsd Trade Finance View Import Let ters of Credit fcc vw lcvw cont prod summary fcc vw lcvw avail ments fcc vw lcvw con tract clauses fcc vw docu ments fcc vw lcvw drafts fcc vw lcvw parties fcc vw msvw cust a ddress fcc vw lcvw contract fcc vw bcvw con tract summary fcc Ictb amn d vals master 6 76 ORACLE
193. us of the request No Download Reports This transaction allows the user to download view a report generated as per the registrations Registration data is main tained in FCDB amp integration with Oracle Publisher No Preferences This function allows user to set different preferences for accessing FCDB application User preference data is main tained in FCDB No Account Prefer ence This function allows user to set different preferences for accessing FCDB application User preference data is main tained in FCDB No Session Sum mary This function displays activity details of business user done in last N Sessions No Mail Box This function allows business user interact with bank admin istrator user using FCDB inter nal messaging facility No Electronic Form This function allows user to write a query to the bank for a particular transaction using e mail messaging Predefined queries are displayed to the user based on the transaction type No ORACLE Transaction ian Administration Name Transaction Description Transaction FLEXCUBE UBS Module Form amp User This function allows user to No Manual Down download the documents like loads User Manuals application forms to be downloaded from common location shared over the Bank Internet Site The Files to be downloaded are maintaine
194. you need to define the interface details as given in the following table Field Value Interface Code DLACCRNT Interface Type Outgoing From System FCUBS To System FCPB Dateformat YYYYMMDD File Mask IM IK D M Y h m s E N D Whentorun End of Transaction input Frequency Daily Character Set ASCII Format Delimited Delimiter File Header record length 3 Default value HDR Body Record Length 36 File Footer record length 3 default value TLR Numeric padding Left padding with Zeros ORACLE 2 5 3 Field Value Text padding Left padding with spaces Datalog Required Yes CRC Required No Triggering System In Component Details sub screen you need to maintain the following details Field Field zT Table Name Column Name Data Type Length Position CUSTNO ICVW ACCRU CUST NO VARCHAR2 9 1 AL DETAILS SHRTN ICVW ACCRU SHORT NAME VARCHAR2 20 10 M AL DETAILS ACC ICVW ACCRU ACC VARCHAR2 20 30 AL DETAILS ACCL ICVW ACCRU ACCOUNT VARCHAR2 6 50 AL DETAILS CLASS ACRAMT ICVW ACCRU ACCRUED AM NUMBER 22 56 AL DETAILS T ENTDT ICVW ACCRU ENT DT VARCHAR2 10 78 AL DETAILS CCY ICVW ACCRU CCY VARCHAR2 3 88 AL DETAILS PROD ICVW ACCRU PROD VARCHAR2 4 91 AL DETAILS HEADER VARCHAR2 1 TRAILER VARCHAR2 1 Penalty on Term Dep

Oracle FLEXCUBE Wealth Management Interface User Manual

Contents

Download Pdf Manuals

Related Search

Related Contents