Oracle FLEXCUBE Universal Banking
Contents
1. 2014 Oracle and or its affiliates All rights reserved Oracle and Java are registered trademarks of Oracle and or its affiliates Other names may be trademarks of their respective owners U S GOVERNMENT END USERS Oracle programs including any operating system integrated software any programs installed on the hardware and or documentation delivered to U S Government end users are commercial computer software pursuant to the applicable Federal Acquisition Regulation and agency specific supplemental regulations As such use duplication disclosure modification and adaptation of the programs including any operating system integrated software any programs installed on the hardware and or documentation shall be subject to license terms and license restrictions applicable to the programs No other rights are granted to the U S Government This software or hardware is developed for general use in a variety of information management applications It is not developed or intended for use in any inherently dangerous applications including applications that may create a risk of personal injury If 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 software2. is a Saving Account for which bank levies Advance Interest if the account holder withdraws an amount more than Free Amount lt does batch processing for Notice Accounts daily It closes the notice periods for which validity is expired It does batch processing for Retail Teller contracts When a teller transaction is posted to an account and there are insufficient funds in the account system will save that contract but it will remain uninitiated This batch executed during EOD picks up these uninitiated teller transactions and liquidates them in case full balance becomes available for the transaction account It does batch processing for ELCM currency Revaluation It does revaluation to track changes in exchange rates of currencies involved in the active contracts and collaterals linked to facility EOTVBOD EOTI BOD EOTI EOTI EOTI EOTI EOTI EOTI GE Global It does batch processing for uploading ELCM EOTI Exposure commitments as part of Facility Maintenances ki ORACLE ELBCOLAT GE Global It does batch processing for ELCM collaterals As part Exposure of this batch all the expired collaterals will be taken up EOTI and the their respective limit contribution will be made to zero and the corresponding linked Collateral Pools and Facility will be updated with the latest value ELBUTILS GE Global It does batch processing for updating Value dated EOTI Exposure balances and Exposures as per the maintenanc
3. Creation Customer Modification Additional Address Maintenance Customer Deactivation 2 3 2 Account CASA Account Opening FC Core user creates the customer record On authorization of the customer record the details of the customer will be available in FCUBS system FC Core user maintains additional customer attributes using FC Core Customer Master Maintenance screen On authorization of the record the additional attributes of the customer record will be available in FCUBS system FCUBS user can capture additional address of the customer using MSDCUSAD screen Default customer address is maintained in FC Core During EOD FC Core identifies the customers who do not have any active accounts in any capacity and marks them as Closed with an elapsed time parameterizable from the date of last account closure The following validations are completed in FCUBS before customer deactivation Active Accounts CASA CL against sttb account Active contracts against cstb contraci Customer is involved as a party in LC contract Customer is involved as a party in BC contract Facilities exists for the customer Collaterals exists for the customer PC contracts FC Core user creates CASA accounts On authorization of the record the CASA account will be available in FGUBS system zi ORACLE CASA FC Core user closes CASA account FC Core calls for the necessary Account validations that need to be done in FCUB
4. MIMTHEND MIGCASCD MIDATCOL SEAUTDLY LQ Receivabl e Liquidation LQ Receivabl e Liquidation LS Syndicati on Loans and Commitment S MI Managem ent Information System MI Managem ent Information System MI Managem ent Information System SE SECURIT IES It does batch processing for reversing the liquidated EOTI receivable components for contracts those are reversed during the day This batch may be configured in EOTI stage of EOC operations It does batch processing for generating Charge and EOFI Claim advices to the party on behalf of whom a charge or commission are debited from receivable accounts during the day This batch may be configured in EOFI stage of EOG operations It does batch processing for rebuilding amount due EOTI tables on the participant side based for Syndication contracts A syndication agreement is reached between a borrower and a bank or a financial institution which arranges the syndication The arranger bank identifies one or more banks or financial institutions that pool funds to meet the borrowing reguirements These banks or institutions are known as participants The arranger bank actually disburses the loan after receiving the contributions of the other participants The participants in the syndication share the interest and other income accruing from the loan in the ratio of their participation that was agreed upon at the time of drawing up the loan syndica
5. and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws Except as expressly permitted in your license agreement or allowed by law you may not use copy reproduce translate broadcast modify license transmit distribute exhibit perform publish or display any part in any form or by any means Reverse engineering disassembly or decompilation of this software unless required by law for interoperability is prohibited The information contained herein is subject to change without notice and is not warranted to be error free If you find any errors please report them to us in writing This software or hardware and documentation may provide access to or information on content products and services from third parties Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third party content products and services Oracle Corporation and its affiliates will not be responsible for any loss costs or damages incurred due to your access to or use of third party content products or services ie ORACLE
6. of clearing upload data which are in unprocessed status and creates the clearing transactions based on instrument type and instrument product GIDPRSIF EOTVEOD B Gl Generic It does batch processing for triggering Generic File Interface Interfaces which are maintained for processing during End of Cycle operations U zdi ORACLE GIDBATCH SIAUTOPR SIDIARY SMBOIMHF PCDAGTHD PCBNKUPD PCBATCH PODPURGE Gl Generic Interface Sl Standing Instruction Sl Standing Instruction SM Security Management System PC Local Payments PC Local Payments PC Local Payments PC Local Payments It does batch processing of PC Client Agreement for EOFI Payment Contract Handoff It does batch processing for archival operations of EOTI Generic Interfaces module It updates next run date for all the generic file interfaces It does batch processing for execution of recorded EOTI BOD instructions due on the day for the End of Cycle stage The advices defined for the instructions will be put in Outgoing Message Browser It needs to be configured in both EOTI and BOD stages of End of Cycle operations It does batch processing of Diarized standing EOFl BOD instructions The batch updates the next execution date and next value date in the Diary Master It also inserts a record in the Diary Due based on the type of Instruction based on the type of the Instruction Frequency Event Based It does b
7. refresh checked remain as active After this batch is run then those contracts are updated with the latest rate and the contract is liquidated It does batch processing of sweeping of funds across EOTI BOD accounts in ILM structure This batch may be configured in EOTI and BOD and needs to be enforced as predecessor for ICEOD batch It does batch processing for calculation of System Data EOTI BOD Elements SDE of Intermediaries across modules An intermediary is a third party who offers intermediation services between two trading parties From a software application perspective an intermediary acts as a middleware between the bank and the customer It does batch processing for Structured Deposits EOTI BOD contracts Structured Deposits enable customers to invest in instruments linked to difference asset classes such as interest rates equities commodities foreign exchange and credit without directly investing in the underlying assets Structured Deposits gives an opportunity to the customers to earn higher returns than in a regular savings account It does batch processing for 1 Adhoc Depreciation 2 EOTI BOD Depreciation for BOOK 3 Depreciation for TAX 4 Reset YTD Depreciation for Fixed Asset Contracts It does batch processing of System Dates Handoff It EOFI populates Dates Download table with details of previous working day as well as next six working days mi ORACLE LOEOTI LOEOD LLCASHFW
8. Core and line Increase the available balance of FC Core account Add record into statement tables in FC Core Log the transactions in batch transaction tables in FC Core Mark the transaction as authorized ie ORACLE 2 1 ORACLE 3 Appendix 3 1 List of Batches in Common Batch Framework The following table contains the details of FCUBS batch processes that are part of the FCUBS FC Core integrated batch framework GLUNRYND ACDFINBL GLREPDLY GLFINCLO GLMISVAL GLMISUPD GLMISRCL GLMISDAV ACCREVAL wa sees GL General Ledger GL General Ledger GL General Ledger GL General Ledger GL General Ledger GL General Ledger GL General Ledger GL General Ledger AC Accountin 9 lt does batch processing at Year End Last Working Day in year for collecting data pertaining to the unrealized income booked for contracts during the year when parameter Track Previous Year Profit and Loss Adjustment is checked for the branch lt does batch processing for Automatic Generation of Suspense entry during EOD for balance mismatches Parameters Real Suspense GL Contingent Suspense GL maintained in Branch Parameters would be used to post the balancing entries It does batch processing for daily reposting of FCY entries for income and expense leaf GLs for which it is indicated that entries posted in FCY are to be reposted in LCY It may be configured in EOTI stage
9. Manual gives information on the intended audience It also lists the various chapters covered in this User Manual Chapter 2 Integration Process provides details of integration between Oracle FLEXCUBE Universal Banking and Oracle FLEXCUBE Core system Conventions Used in this Manual Important information is preceded with the symbol Glossary of Icons This User Manual may refer to all or some of the following icons i so La ORACLE Rande Refer the Procedures User Manual for further details about the icons 1 6 Related Documents e Procedures ke ORACLE 2 1 2 2 2 integration Process Common Batch Framework A common batch framework is available for FCUBS and FC Core Refer to the Annexure for list of FCUBS batch processes that are part of the common batch framework Following are the features of the common batch framework e Provision for single click EOD for the integrated system e Ability to configure and run FCUBS batches in multiple streams in parallel e Common UI to invoke batch category and monitor the progress e Ability to group and sequence the batch processes into logical categories and to define the interdependency among the batch processes e Handle different calling mechanisms like proc based or Java based batch routines e Batch reports generation e Parallel execution of shells e Ability to define distribute the batch programs into different categories which need to be executed in a pa
10. Oracle FLEXCUBE Universal Banking FLEXCUBE Core Integration Oracle FLEXCUBE Universal Banking Release 11 5 0 0 0 July 2014 ORACLE FINANCIAL SERVICES La ORACLE Oracle FLEXCUBE Universal Banking FLEXCUBE Core Integration Table of Contents Ie ABOUT THIS VAIN AT siese nos eine ee ee eie ee ee ee ese sie ge se Dei ee Ge ee ee ol ee Ge Ee ie GE ee Ge 1 1 1 1 VM ep ese N N ET A OE EE RE A AE RE OS OO RE NE V WETE 1 1 1 2 AOE ENE N ORN ER NE EN NE RE ON N E ENE AE EE 1 1 1 3 ORE AREA BIO A A A O RE O O O AO ARE ON ME A A O ARE ZOO MERI 1 1 1 4 CONVENTIONS USED IN THIS MANUAL vies sce se es a ese Ge be ed ee SEGE Ge see Ee Ge a Ee iena EG Ge oe Ee Ee GE Ee oe 1 1 1 5 GLOSSARY OF o o a IE oe O O PA C OM A RA IM IVA 1 1 1 6 RELATED DOCUMENTS o ee ee E ee GE Ee ee a ke 1 2 2 UANERUORAMON PERO INO N se cee N RE OE aN i 2 1 Dl COMMON BATCH FRAMEWORK ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ed 2 1 Dd LEAD BASED ORIGINATION ceccscoccsceccsceccsceccsceccscscescscscscescscesescucescsceecscecscnscscesescesescssescesescssscscasenees 2 1 2 3 DYNAMIC ENTITIES aa sees see n si ee ie ee ee ee ie ee ee oa aa ea aa ee aa E ea a ee oba oe kn vaga 2 4 2 3 1 6 ei OE O N RO OP EO O O O O RE OV TEDN 2 5 2 3 2 FRC GOEIE O OE EE OO ER EG ER O V TVE EG 2 5 2 3 3 Online Credit Transaction WoOrkflow ccccccccccssssesseeeeeseeeeeeeeee cece eee AR RR EE ee ee e
11. S The validations would be primarily Closure for the transactions in FCUBS that uses the FC Core account as its settlement account Nostro FCUBS user can maintain Nostro accounts using STDNOSTR screen Account Maintenance In the integrated environment all customer and account related maintenances except module specific maintenances will be disabled in FCUBS Refer to the Annexure for FCUBS maintenances that will be disabled in the integrated environment 2 3 3 Online Credit Transaction Workflow The table below provides details on online credit transaction between FCUBS and FC Core The system validates the following on click of OK e If transaction fails to pass any of the validation in FC UBS or FC CORE the system rejects the transaction If the validations are successful then the transactions are saved only in FCUBS Delete Post The user maintains transaction reference number of existing Input unauthorized transaction in FCUBS and gets the transaction details from the system The transaction entry is deleted from FCUBS on click of OK Authorize The user maintains transaction reference number of existing Post Input unauthorized transaction in FCUBS and gets the transaction details from the system The system does the following on click of OK If the validations are successful in FCUBS and FC Core the system proceeds with further transactions Increases available balance of FC Core acco
12. atch processing of OIM Oracle Identity Management Handoff It soools Flexcube user data to a file in pre configured directory It does batch processing of PC Bank parameters maintenances upload It does batch processing for EOTI BOD 1 identifying all periodic payments and collection instructions that need to be generated on the current date and generating contracts for those instructions 2 identifying all outgoing direct debit transactions satisfying specific conditions and marking the collection status as approved and the contract status as liquidated 3 identifying all outgoing direct debit transactions satisfying specific conditions and marking the contract status as liquidated and automatically generating corresponding new transactions for redispatch 4 identifying all outgoing request for debit transactions satisfying specific conditions and marking the collection status as closed and contract status as liquidated 5 identifies all contracts that meet specific conditions and dispatching them to clearing using the interface system This batch can be configured in both EOTI and BOD stages It does batch processing for purging PC contracts history records after retaining them for period specified at product category level mo ORACLE PDEOD PDBACCRL PDBRADJ REAUTMC REINTCP RESTMUL RESWIFT DEDEPBAT CNDBATCH CN CNDREMSG CN DLTRACER DLEOD GLSTHAND DATESET
13. cessing It may be configured in EOD and BOD It does batch processing for generating Reminder messages for Collections It may be configured in EOTI and BOD It does batch processing of Tracer generation It may be configured in EOFI lt does batch processing of Auto Liquidation of DL contracts It may be configured in EOTI BOD It does batch processing of GL Statement Handoff EOC Group BOD EOTI BOD EOTI BOD EOTI BOD EOTI BOD EOFI EOTI BOD EOFI O o A M FTAUTO FTRTUPDT ILBATCH INDBATCH SFBATCH FABAUDLY IFDATEHO of Day working day IE FT Funds Transfer FT Funds Transfer IL Integrated Liquidity Management IN Intermedia ry SF Structure Deposit FA Fixed Assets IF Interfaces It does batch processing of future valued Fund EOTI BOD Transfer contracts A future valued contract is one that has been stored with a value date in the future and may have rate pickup specifications as of the day you defined for the contract It does following 1 Update the transfer amounts based on the Rate Pick up code or mark contracts as needing a Rate Update on that day 2 Pass Accounting Entries 3 Generate settlement messages and advices based on the message code that you specify It does batch processing of applying latest rates to the EOTI BOD eligible Fund Transfer contracts All the contracts which have been booked as cross currency and the rate
14. d for an account with its primary statement as summary AC Accountin It does batch processing to facilitate GL Reporting EOFI 9 CO Core This batch can be used to mark branch as Not EOTI Services Available during EOD process CO Core It does batch processing to perform Intra day release of Services Uncollected funds for the transactions posted using transaction codes for which Intraday Release option is enabled CO Core It does batch processing for upload of Customer Services Relationship Value Tags in Relationship Pricing module CO O U CO Core It does batch processing to release tanked transactions Services in Beginning of Day stage during End of Cycle operations CS Core It does batch processing for AML Anti Money Laundering System identifies all accounting entries posted for the day which are marked for AML monitoring verifies individual amount limit for the customer group and product category combination and stores this data in the system User will be able to view this data when he generates an AML report using Business Objects CS Core It does batch processing for Escrow Transfers Dormant Account Closure Account class transfer for Customer A c and Customer Minor to Major conversion It needs to be configured in EOTI and BOD CS Core It does batch processing for transactions which are sent to referral queue If any customer account is marked for referral any transaction which forces the account to mo
15. d is saved in the origination application entry stage the status would automatically change from converted to Application under process The user will not be able to change the status manually after this status Lead Corresponding Possible Next Status FCDB Status Status _ H IH a The following table provides the details of statuses applicable to CASA Current Status New Statuses Available New Status Selected New Default Status for Follow Up Follow Up a new record Under Process Additional Doc Required Additional Doc Required Account Opening in Progress Account Opening in Progress Progress Further process is done Rejected Rejected manually Origination in Progress Automatic Account Opening in Progress Further process is done through origination This is the status gets updated automatically once the lead id is linked with Origination reference Origination in Progress Converted Automatic Once the account is successfully opened in Origination this status gets updated automatically Converted Rejected 2 3 Dynamic Entities na ORACLE In the integrated environment the following dynamic entities maintained in FC Core system will be available in FCUBS for corporate transactions e Customer e Account gt CASA gt Retail TD This integration process works irrespective of whether FCUBS and FC Core systems are deployed in the same schema or not 2 3 1 Customer Customer
16. e ELBMAREV EOTI GE Global It does batch processing for ELCM Market Revaluation Exposure It does revaluation to track changes in market price of marketable securities backing collaterals ELBFACLT GE Global It does batch processing for marking all the Line EOTI BOD Exposure Codes Collaterals and Securities which have crossed their Expiry date as Unavailable As part of this batch Intraday utilization for each facility will be set as zero And back Up of line codes utilization and liability details into history Archival will be done CLBATCH CL Retail It does batch processing of calculation accrual auto EOTI BOD Lending liguidation rate revision statements generation automatic status change 8 maturity processing for Loans This batch needs to configured in both EOTI and BOD stages of End of Cycle operations CLDRTHDF CL Retail It does batch processing of Rate Handoff for Loans It EOFI Lending picks up details of User Defined Values maintenance which are authorized on the day and populates loan rate handoff table for CL Interfaces ISCONNET IS Settlement It does batch processing for executing Netting across EOTI BOD Instructions modules ISUPDBCH IS Settlement It does batch processing for upload of BICPLUSIBAN Instructions records ISSGEN IS Settlement It does batch processing for Settlement Message EOTI BOD Instructions generation across modules CGUPLOAD IF Interfaces It does batch processing
17. e ee ee ee ee ee ee RR RR ee ee ee ee ee 2 6 2 3 4 Online Reversal of Credit Transaction WorkflOW ee ee ee RE ee ee Re ee ee ee RE ee ee 2 7 2 3 5 Online Debit Transaction Workflow ee EE ee ee ee AR RR EE ee ee ee ee ee ee ee ee ee RR RE ee ee ee ee ee 2 8 2 3 6 Online Reversal of Debit Transaction Workflow ee ee EE EE ee ee ee AA RR RR EE ee ee ee ee 2 9 z Ar PENDE EE EE AE EE N OE RE EE OE EE N EE EO Ee N 3 1 3 1 LIST OF BATCHES IN COMMON BATCH FRAMEWORK ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee 3 1 3 2 DISABLED MAINTENANCES IN ORACLE FLEXCUBE UNIVERSAL BANKING ee 3 10 La ORACLE 1 1 1 2 1 3 1 4 1 5 1 About this Manual Introduction This document is designed to help acguaint you with the integration among Oracle FLEXCUBE products viz Oracle FLEXCUBE Universal Banking Solutions FCUBS and Oracle FLEXCUBE Core Besides this user manual while maintaining the interface related details you can invoke the context sensitive help available for each field This help describes the purpose of each field within a screen You can obtain this information by placing the cursor on the relevant field and striking the lt F1 gt key on the keyboard Audience This manual is intended for use by the following groups e Backend frontend staff and officers of bank e Oracle FLEXCUBE Implementation teams Organization This manual is organized as follows Chapter 1 About this
18. essing of Rate Handoff for CASA It Maintenance picks up details of Interest and Charge rates of Account Class amp Rate Association Maintenances which are authorized during the day and populates CASA rate handoff tables ST Static It does batch processing for Product Handoff for Maintenance LC BC SI PC CD CL modules It picks up details of Product Maintenances which are authorized during the day and populates Product handoff tables ST Static It does batch processing for Account Class Handoff It Maintenance picks up details of Account Class Maintenances during the day and populates Account Class handoff tables ST Static It does batch processing for Branch Handoff It picks up Maintenance details of Branch Maintenances authorized during the day and populates the branch handoff table ST Static It does batch processing for provisioning When the Maintenance batch is triggered provisioning events SPRO provision and SPWB write back are executed Following processes are done as part of the batch 1 Status processing for accounts 2 Interest and Charges batch process 3 The automatic daily contract update process in loans module SW Switch It does batch processing for Switch Reconciliation EOTI Interface SW Switch It does batch processing for Network Settlements 3 9 of EOC operations EOTI EOFI EOFI EOFI EOFI EOTI EOTI SWMERSET SW Switch It does batch proce
19. ments documents required required When the status is selected as Closed it will be mandatory for the user to select the reason code in the sub screen which will 2 2 Followup Closed Rejected Cannot change the status Additional documents required Closed Rejected Offer generated Followup Closed Rejected Offer Generated Lead Corresponding Possible Next Status FCDB Status Status be populated at the save operation ma Review Offer generated Application Under process When the prospect customer uploads Under process corrected or additional document When the FCUBS user simulates and Offer generated system generates the offer based on requested details When the FCUBS rejects or closed the Rejected lead id When the status is selected as Closed it will be mandatory for the user to select the reason code in the sub screen which will be populated at the save operation When the customer accepts one of the Account generated offers Opening Under Process When a converted loan lead is saved in the Account application entry stage of the origination Opening Under the system will automatically change Process the status of the lead in ORDLEADM to 2 3 Followup Closed Rejected Offer generated Closed Converted Cannot change to any other status In FCUBS the next status that would be allowed to be changed manually will be Closed only If the lea
20. of End of Cycle operations It does batch processing for actual year end processing It can be configured to be executed in End of Cycle operations of Last Working day of the year in EOFI stage It does batch processing for updating MIS value dated balances It does batch processing for updating MIS balances It does batch processing of GL MIS balance transfer upon MIS reclassification for those GLs for which the balance transfer option has been set The transfer is performed taking into account the details stored in the change logs Customer MIS Change Log Account MIS Change Log or Contract MIS Change Log When the transfer is performed the transfer details are stored in the MIS Balance Transfer Log It does batch processing of updating Daily Average MIS balances It does batch processing of revaluation of Internal GLs and Customer Accounts Revaluation accounting is posted in foreign currency with equivalent of LCY EOC Group EOFI EOTI EOTI EOFI EOFI EOFI EOFI EOFI EOTI ORACLE ACSTHAND ACIDPRVL BRNCHGST ACUNCOLB RVTBUPLD POSTDTCH CEBAMLPR CASABAT CSREFQPR oem AC Accountin 9 It does batch processing for Accounting Statement EOFI generation SWIFT account statements are statements generated for NOSTRO type of accounts i e fora bank type of a customer MT940 is generated for an account with its primary statement as detailed and a MT950 is generate
21. ore CASA e Add record into statements table in FC Core e Post the transactions in accounting tables of FC Core e Update line utilization if applicable in FCUBS 2 3 6 Online Reversal of Debit Transaction Workflow Reversal Post Authorization Delete Post Reversal The user maintains transaction reference number of existing authorized transaction in FCUBS and gets the transaction details from the system The system validates the following on click of OK e If transaction fails to pass any of the validation in FC UBS or FC CORE the system rejects the transaction If the validations are successful then the transactions are saved in FCUBS While saving the system does the following gt Puts a hold equal to transaction amount on FC Core account Puts a hold on line with amount if the amount is greater than 0 and transaction amount is greater than Account balance The amount here is Transaction Amount Account Balance The user maintains transaction reference number of existing unauthorized transaction in FCUBS and gets the transaction details from the system The hold from FC Core account and line is removed on click of OK ead ORACLE Authorize The user maintains transaction reference number of existing Post Reversal unauthorized transaction in FCUBS and gets the transaction details from the system The system does the following on click of OK Removes the hold from the account in FC
22. rticular order based on the interdependency e Run batches separately if required e Restart Logic In case of the batch process has been aborted then when it restarts the restart happens from the last commit point for the FCUBS batch programs The restart option is available at the stream as well as branch level to handle the streaming type of implementation e Dual Schema The integrated framework works even if the FC Core and FCUBS systems have separate schemas on the same database In this case the batch framework related components will be available in the FC Core schema e Batch reports are configured across FC Core and FCUBS and can be generated seamlessly Following features are not available in the integrated batch framework e Branch wise batch processing is a feature of FCUBS batch framework It will not be available in the integrated batch framework e Rollback of EOTI feature is supported in FCUBS batch frameworks It will not be available in the integrated batch framework e Ability to stop the batch process is not available in the integrated framework Lead Based Origination Oracle FCUBS FCDB FCCore integration helps the bank to use lead based origination feature The flow of the lead origination process is as follows on ORACLE e The prospect customer selects the product using FCDB portal Current Loans Savings e FCDB system captures the application data and stores it in FC Core using the Lead Managemen
23. ssing for Merchant Settlements EOTI Interface SWDRETBT SW Switch It does batch processing for retrying erroneous EOTI Interface Transactions SWDPURGE SW Switch It does batch processing for Adhoc purge of transaction EOTI Interface data to history table Swi Swi SWDPRCRT SW Switch lt does batch processing for uninitiated RT EOTI Interface transactions SWDCHKBK SW Switch It does batch processing for unprocessed cheque book EOTI BOD Interface requests BRNRECON WB FLEXCU It does batch processing for checking if savings EOTI BE Web EOD branch EOD is completed and returns success if Branch its completed MMAUTDLY MM Money It does batch processing for liquidating Money Market EOTI BOD Market Contract Schedules those are marked for auto liquidation This batch also books new MM contracts as part of Rollover for Spawn Contracts 3 2 Disabled Maintenances in Oracle FLEXCUBE Universal Banking The following table contains the details of maintenances that are disabled in FCUBS when integrated with FC Core Ponte smetane EY alu ORACLE Port eke Em si ORACLE Porto ees Em die ORACLE ORACLE July 2014 Version 11 5 0 0 0 Oracle Financial Services Software Limited Oracle Park Off Western Express Highway Goregaon East Mumbai Maharashtra 400 063 India Worldwide Inquiries Phone 91 22 6718 3000 Fax 91 22 6718 3001 www oracle com financialservices Copyright 2007
24. t screen ORDLEADM and ORSLEADM e Based on the customer inputs and internal processes the bank user the manually updates the status of the lead e The lead after all processing is completed can either be closed or converted e lf the lead is converted then the bank user will operationally open the customer record and account and maintain all the details that are captured in the lead request includes nominee details debit card request etc The status of the lead can be changed time to time while processing the origination You can maintain the reason codes for status changes using ORDSTRMT screen The following table provides the details of statuses applicable to loans Lead Corresponding Possible Next Status FCDB Status Status Follow up Additional documents required All the leads generated from the channel New Application will have the status as New FCUBS user can see the entire list of leads in the lead summary screen When the FCUBS user rejects the lead Rejected When the status is selected as rejected it will be mandatory for the user to select the reason code in the sub screen which will be populated at the save operation The FCUBS contacts the prospect for Under Process further processing The FCUBS user can edit the details provided by the prospect customer based on their interaction After speaking to the prospect customer Additional FCUBS user informs correct or additional docu
25. tion agreement It does batch processing for Month end processing of EOFI Management Information System It may be configured in EOFI stage of EOC operations It does batch processing for Cascading modifications EOTI done in MIS group maintenance during the day In Customer Account screens Product screens and Contract screens user can use defaulting MIS group for populating MIS codes If the MIS group maintenance is changed this batch will do the cascading of the changes to the linked contracts products accounts It does batch processing for MIS data collection It does batch processing for daily processing of events EOTI BOD for Security Settlements Bonds Coupon Payment Redemption Maturities etc and Equities as well as Unrealized Revaluation of Unsettled Buy and Sell Deals and Unrealized Revaluation of Settled Deals This batch may be configured in EOTI and BOD stages oe ORACLE SLBATCH STSTBUPD STDRTHDF STDPRDHE STDAGLHF STBRHAND PROVBCH SWSWREC SWNETSET SL SALARY It does batch processing for Salary credit and loan EOTI CREDIT processing of employees ST Static It does batch processing for automatic status changes Maintenance of Customer Accounts Status movement preferences for the accounts are derived from Account Class preferences and new statuses for the accounts are calculated and applied It may be configured in EOTI stage of EOC operations ST Static It does batch proc
26. transaction reference number of existing Reversal unauthorized transaction in FCUBS and gets the transaction details from the system The transaction entry from FCUBS is deleted and the hold from FC Core account and line is removed on click of OK Authorize FCUBS The user maintains transaction reference number of existing Post Reversal unauthorized transaction in FCUBS and gets the transaction details from the system The system does the following on click of OK e Ifthe validations are successful in FCUBS and FC Core the system proceeds with further transactions eu ORACLE or else reject the transaction Decrease the available balance of FC Core account Remove the hold from FC Core account and from line Add record into statement tables in FC Core Log the transactions in batch transaction tables in FC Core Mark the transaction as authorized 2 3 5 Online Debit Transaction Workflow The user maintains transactions in FCUBS On click of OK the system validates the following e If transaction fails to pass any of the validation in FC UBS or FC CORE the system rejects the transaction If the validations are successful then the transactions are saved in FCUBS While saving the system does the following gt Puts a hold equal to transaction amount on FC Core account Puts a hold on line with amount if the amount is greater than zero and Transaction Amount is greater than Account Balance Amo
27. unt Add record into statement tables in FC Core Log the transactions in batch transaction tables in FC Core ORACLE ma e Mark the transaction as authorized in FCUBS 2 3 3 1 Batch Credit Transaction Workflow The batch for credit transaction is initiated in FCUBS Depending upon the validations the transaction is either rejected or processed The additional validations for credit transactions are done in FC Core Once the transaction is posted in FCUBS FC Core performs the following tasks e Increase available balance of FC Core CASA e Add records into statement table in FC Core e Post the transaction in accounting tables of FC Core 2 3 4 Online Reversal of Credit Transaction Workflow Reversal Post FCUBS The user maintains transaction reference number of existing Authorization authorized transaction in FCUBS and gets the transaction details from the system On click of OK the system validates the following e lf transaction fails to pass any of the validation in FC UBS or FC CORE the system rejects the transaction If the validations are successful then the transactions are saved in FCUBS While saving the system does the following gt Puts a hold equal to transaction amount on FC Core account Puts a hold on line with amount if the amount Is greater than zero and transaction amount is greater than Account balance The amount here is Transaction Amount Account Balance Delete Post FCUBS The user maintains
28. unt Transaction Amount Account Balance Delete Post The user maintains transaction reference number of existing Input unauthorized transaction in FCUBS and gets the transaction details from the system On click of OK the system removes the hold which was put as part of the original transaction from FC Core account and line Authorize The user maintains transaction reference number of existing Post Input unauthorized transaction in FCUBS and gets the transaction details from the system The system does the following on click of OK e Remove the hold which was put as part of original transaction from FC Core account and line Decrease the available balance of FC Core account and update line utilization with total sum equal to transaction amount ae ORACLE Add record into statement tables in FC Core Log the transactions in batch transaction tables in FC Core Mark the transaction as authorized in FCUBS 2 3 5 1 Batch Debit Transaction Workflow The batch for debit transaction workflow is initiated as part of FCUBS Batch When the debit transaction is initiated in FCUBS then FC Core performs additional validations FC Core checks if the fund for the transactions are available in the account If the funds are not available then the amount Is force debited and the transaction is posted Once the transaction is posted in FCUBS FC Core performs the following tasks e Decrease available balance of FC C
29. ve to overdraft will be moved to referral queue and these transactions are either confirmed or reversed in the batch processing Ne ORACLE EOFI EOTI BOD EOTI CSDSTBTC ICEOD ICTDS DEAUTDEP DESWPBAT ADINTYLY ADINTDLY RTAUTDLY ELBCYREV ELBCOMNT CS Core IC interest Charges IC interest Charges IC interest Charges IC interest Charges IC interest Charges IC interest Charges RT Retail Teller GE Global Exposure It does batch processing for triggering CIF Group level status when Status Processing Basis parameter is indicated as CIF Group level for the branch It will call individual module function for status change processing It does batch processing of Automatic Interest and Charges liquidation Automatic Accruals Processing Consolidated charges for customer current saving and deposit accounts It needs be configured in both EOTI and BOD stages of End of Cycle operations It does batch processing for calculation and booking of TDS for customer accounts It needs to be configured in EOTI stage of End of Cycle operations It does batch processing for creating auto deposits for eligible customer accounts It may be configured in EOTI It does batch processing for processing sweeps to break the related auto deposits when saving accounts doesn t have minimum balance required It does batch processing for Notice Accounts yearly Notice Account
30. wa we PD Post Dated Chegues PD Post Dated Chegues PD Post Dated Chegues RE Reconcili ation System RE Reconcili ation System RE Reconcili ation System RE Reconcili ation System DE Data Entry ns ns Collectio Collectio DL Deposit Locker DL Deposit Locker AE Auto End of Day AE Auto End It does batch processing for automatically setting next 3 6 O It does batch processing for liquidating and authorizing Post Dated cheque contracts It may be configured in BOD It does batch processing for interest accruals for Post Dated cheque contracts which are Purchased Discounted It does batch processing for realizing Post Dated cheques which are Purchased Discounted It does batch processing for Automatic Matching of the entries of an external statement with the corresponding entries of an internal statement Nostro Reconciliation It does batch processing of Reconciliation Internal Transaction Upload lt does batch processing of Reconciliation External Statement Upload It does batch processing of Statement Handoff of External Statements uploaded through messaging module SWIFT It does batch processing for automatic sweep out of balances of eligible CASA accounts It does batch processing of collections 1 Loan accounts with amount dues are extracted to Collection module 2 Extracted data from the loans module or the asset details are used for further pro
Download Pdf Manuals
Related Search