Home

Oracle FLEXCUBE Introduction User Manual

1. TPD A type of Education Savings account with special features UTR Unique Transaction Reference Number VE Voucher Entry VRU Voice Recognition Unit Wadiah A Syariah banking Product type using depository concept ZBA Zero Balance Account 166 ORACLE ORACLE Introduction User Manual Oct 2013 Version 5 0 2 0 0 Oracle Corporation World Headquarters 500 Oracle Parkway Redwood Shores CA 94065 U S A Worldwide Inquiries Phone 1 650 506 7000 Fax 1 650 506 7200 www oracle com financial services Copyright O 2013 Oracle and or its affiliates All rights reserved No part of this work may be reproduced stored in a retrieval system adopted or transmitted in any form or by any means electronic mechanical photographic graphic optic recording or otherwise translated in any language or computer language without the prior written permission of Oracle Financial Services Software Limited Due care has been taken to make this document and accompanying software package as accurate as possible However Oracle Financial Services Software Limited makes no representation or warranties with respect to the contents hereof and shall not be responsible for any loss or damage caused to the user by the direct or indirect use of this document and the accompanying Software System Furthermore Oracle Financial Services Software Limited reserves the right to alter modify or otherwise change in any manner the content hereof
2. FETERE M Authorize Authorize a record The user who has specific access rights can mE authorize the record O Inquiry View the authorized records Validation Buttons Click To Commit a transaction Clear the data entered on the screen Close the screen and exit the maintenance transaction Call Timing Click to view the time taken in form request form render and submit event of transaction Help Click l this to view the help related to a particular screen Close Click E to close the current screen Type of fields Information is entered in fields Generally the fields can be Display Fields Entry Fields Date Fields and pick list Display Fields Reserve Calculation Frequency Information in these fields is retrieved calculated by Oracle FLEXCUBE Display fields are shown on screen in grey colour indicating that they cannot be changed Entry Fields Marrative Cash Deposit An Entry Field is an area in which the user can type or enter information This information can be textual numeric or alphanumeric in nature Entry Fields are of two types e Mandatory Fields Information in these fields is mandatory for the process to move ahead e Optional Fields Information in these fields is optional you may or may not enter information in them 36 ORACLE Understanding the Oracle FLEXCUBE User Interface Date Fields LN Process Date 20 03 2008 EI e Date Fields have special s
3. Not Verified Papers Verified Bankground Verified A drop down list box displays a fixed list of available choices e List boxes have scroll bars if there are more choices than what can be displayed at a given time e To invoke the list box click the downward pointing arrow e Select any item from the list 39 ORACLE Understanding the Oracle FLEXCUBE User Interface User Defined Fields This section is used for updating additional details Based on the requirement and the nature of the field you can specify default values and validations for the field Oracle FLEXCUBE validates all entries made to the field against the validations defined for a field For more information refer to User Defined Fields in the Common Screens option in Oracle FLEXCUBE Introduction user manual The user defined fields are available in two layouts The layouts of the UDF depends if the screen is jackbee or classic screens The UDF in classic screens will be as follows Other Transactions User Defined Fields The UDF in jackbee screens will be as follows wasa Click on the appropriate UDF to enter the additional details Session Auto Expiry The system displays session expiry alert if you are inactive for a particular duration Interval 2 which is set by the bank Click anywhere in the dashboard you can reset inactivity duration and auto logout mechanism will not proceed with the logout of current session
4. Unauthorized records from the table To cancel the bank code 1 Select the Cancel mode 2 Type the bank code and press the lt Tab gt key or select it from the pick list 3 Click the Ok button 4 The system displays the message Record Cancelled Click Ok to Continue Cancel action is done by the teller who wants to nullify the action add modify delete or amend done by him on a record and does not want to send the same for authorization This cancel action can be done only by the teller who has done the initial add modify delete or amend 42 ORACLE Standard Maintenance Procedures maintenance When the teller cancels the record the system deletes the Unauthorized record from the table To amend the bank code 1 Select the Amend mode Type the bank code and press the lt Tab gt key or select it from the pick list Modify the relevant information and click the Ok button ARON The system displays the message Record Amended Authorisation Pending Click Ok to Continue Amend action is used by the teller who wants to do further changes to the record which has been modified by him earlier but before authorization by the supervisor System will allow amending of non key fields Key fields cannot be modified or altered When a record is amended system will record the changes in the Unauthorized record in the table Hence till the time of authorization the table would contain 2 rows for the sa
5. 1310 1312 1318 1402 1316 TDS03 TDS10 TDS11 TDS12 TDS14 TDS15 Description Quick Payin By GL Mixed Payin Mixed Redemption TD Redemption Inquiry TD Redemption Inquiry TD Redemption Inquiry Quick Payin By Cash TD Renewal Inquiry Tax Waiver TDS Remittance TDS Inquiry Tax Recovery TD Tax Refund Inquiry on Projected Tax 128 Appendix of Fast Path ORACLE Fast Path 8054 TD020 TD021 TD022 TD028 TD043 TDM05 TDM24 TDM48 TD044 6503 6504 6505 1311 Appendix of Fast Path Description Time Deposit Account Opening TD Account Master Deposit Master TD Nominee Maintenance TD Block Unblock Account Status TD Certificate Printing TD Account CBR Codes Maintenance Lien Master Backdated Interest Rate Change TD Transactions Inquiry Quick Payin By BC Quick Payin by DD Quick Payin By Cheque TD Redemption Inquiry By BC 129 ORACLE Fast Path 1332 1333 1336 PS001 PS002 PS003 PSMO1 TDM55 1302 TD038 MCA07 Appendix of Fast Path Description Quick Redemption By DD Quick Redemption By Reinvesting Existing Account Quick Redemption By Reinvesting To New Account Group Passbook Issue Lost Maintenance Group Passbook Update Inquiry Passbook PIN Maintenance Passbook And Debit Card Account Linkage Call Deposit Notice Maintenance Screen TD Interest Payout Inquiry Top Up In
6. Description Mandatory Numeric 12 Type the cheque number which is present on the MICR line of the instrument When the cheque is deposited into any payee s account the cheque number is used to ensure that the duplicate entries are not made in the system that the same cheque is not deposited multiple times in the system On deposit of every cheque cheque number routing number and drawer account number all the three are present on the MICR line are used to check for the presence of duplicate instrument If duplicate instruments are found cheque deposit will be rejected unless the earlier cheques are all marked as Returned Mandatory Drop Down Select the cheque literal from the drop down list Mandatory dd mm yyyy Type the cheque date This date has to be less than or equal to current posting date This date is used in checking validity of the instrument Instruments become stale if the cheque date is prior to the current posting date by the stale period defined in the Settlement Bank Parameters Fast Path STM59 option Mandatory Numeric Nine Type the routing number of the cheque The routing number is a combination of the bank code the branch code and the sector code from where the instrument was drawn The combination can be obtained from the Routing Branch Maintenance Fast Path STM54 option Routing Number Sector Code Bank Code Branch Code For a deposited cheque this routing num
7. Loan Account Subsidy Plan Maintenance Loan Subsidy Arrear Repayment Inquiry Loan Subsidy Arrear Repayment Inquiry Account Documents Maintenance Loan Interest Adjustment Transaction Loan Entrusted Linkage Adhoc Interest Application Payment Instructions Priority Maintenance Funding Details Screen Loan Maturity Date Extension Entrusted Funds Transfer Reversal of LC BG Loan Arrear Appropriation Inquiry i ORACLE Fast Path LNO19 LN020 LNM20 LN032 Appendix of Fast Path Description Loan Arrear Repayment Inquiry Loan Product Transfer Inquiry Loan Product Transfer Subsidy payments instructions Module Name Collections Fast Path CLN26 CLN28 CLN29 CLN30 CLN32 CLN33 CLN34 CLN35 CLN37 Description Follow up By Collector Authorization by Supervisor Exception Case Marking Group Follow Up Collectorwise Re allocation Reallocation Queuewise Reallocation Individual Temporary Re Allocation Re queue 136 ORACLE Fast Path CLN50 CLN55 CLN62 CLN63 CLN64 CLN70 Description Search Follow Up Query Initiate Repossession Collateral Auctioning Collateral Disposition Customer Sticky Notes Module Name Card Management Fast Path CMO1 CM02 CM03 CM04 CM05 CMO06 CM07 Description Card Maintenance Blank Cards Request Card Status Change Card Activation Card Unblocking Blank Cards Inventor
8. Passbook Issue Lost Maintenance SWIFT Statement Details Special Frequency for Statement Account Addresses Maintenance Funds Transfer Request CASA To CASA Funds Transfer Request CASA To GL Funds Transfer Request GL To CASA Funds Transfer Request iss ORACLE Fast Path 1431 1801 1804 CHM50 ORS42 BAM66 BAM93 BAM82 BAM24 CH039 7115 7116 ECMO2 TD024 Appendix of Fast Path Description Flexible RD deposit by CASA Transfer OBU CASA Funds Transfer Request OBU Miscellaneous GL Transfer Future Dated Funds Transfer Document Details Maintenance Account Reference code xref Direct Debit Transaction Inquiry Business Acquirer Id Linkage Maintenance Account Status Audit Trail Inquiry CASA TD Sweep In Inquire Amount Based Operating Instruction Maintenance Amount Based Account Image Display ECS Mandate Maintenance Tax Absorb Account Maintenance 124 ORACLE Fast Path CH033 STM72 BA988 CI500 1040 8051 1041 CHO11 CHO050 CHM20 PS001 PS002 PS003 PSMO1 Appendix of Fast Path Description Average Quarterly Monthly Balance Inquiry Payee Name Update Account Interest Freeze Maintenance Assisted Account Opening Home Cash Deposit CASA Account Opening Home Cash Withdrawal Account Closure Inquiry Maintenance CASA Billing Transaction Interbranch Settlement Account Maintenance Group Passbook Issue Lost Mainten
9. Click the checkbox to disable this alert for the current session In this case the current session will be expired without any notification if your inactivity duration is equal to value set The session auto expiry screen will be as follows FLEXCUBE Warning Session Auto Expiry You have been inactive for 1541 seconds Your session will expire in 259 seconds show this dialog again current session 40 ORACLE Standard Maintenance Procedures 1 13 Standard Maintenance Procedures The standard procedure for the maintenance s in Oracle FLEXCUBE is explained below A record inside the table on which the maintenance operates has two parts namely A Key This can consist of one or more fields and these together identify a unique record in the table B Parts of the record Other attributes of the record For example in Bank Codes Maintenance the table layout is as follows Bank Code Bank Code Integer Name of Bank 4 KEY Q4 BODY OF RECORD Bank code is a key identifier in the Bank Codes table Each bank code uniquely identifies a bank in the table The attributes of that bank code would be defined in the body of the record All action on the table namely add modify delete amend authorize and view are done using key field s For doing any operations on the maintenance or table the key fields for the respective transaction screen have to be entered In addition to the entities on th
10. Display This field displays the service charge currency Display This field displays the service charge in the local currency If the SC amount has changed system will automatically convert the new SC amount into the local currency Display This field displays amount of Service Charge of the Parent SC in local currency Display The field displays the amount of Service Charge of the Additional SC in local Currency Display Click the Rule link to view the rule details applied for the SC The link is displayed if a rule is applied to the service charge Toggle If the field is marked as Y then that group will get linked and if the field is marked as N then that group will get de linked Display This field displays the selected collection amount Display This field displays the total service charge to be applied in local currency 62 ORACLE Common Screens Column Name Description Rule Details Rule ID Display Original Value Rule Returned Rule Returned Value Final Value Reason This field displays the Rule ID attached to the selected SC An interest rule ID is a unique number which represents the installment rule Display This field displays the original amount of the service charge Display This field displays the rule returned description for the selected service charge Display This field displays the value of the rule returned Display This field displays
11. Ji 01 01 1800 Effective Date Interest Rate 0 00000 Rate Change Parameters Advice Required Rate Change Effect Reschedule Options Record Details Input By Authorised By Last Mnt Date Last Mnt Action Authorised Note If you are using the tree menu to navigate to a particular option the Fast Path is automatically displayed in the Fast Path text box Using My Transaction You can customize the menu based on the transactions which are used on a frequent basis You can drag and drop the transaction from the tree menu in Click My Transaction to view the screens which you have added You can select the check box adjacent to the option name and click W to delete the option from My Transaction 31 ORACLE Understanding the Oracle FLEXCUBE User Interface Fast Path 1501 E ER Customer Id First Name Last Mame Advance M Rule Debug Maintenance Rule Definition Master Mainten b UDE Master Maintenance Demand Draft Details Maintena Using My To Do List You can view the count of Authorized Rejected Transactions For teller the system displays a hyperlink with transactions pending for authorisation Click the link system displays the Search Electronic Journal Fast Path 6006 option with the list of transactions pending for authorisation Now the teller can resend the transaction for auth
12. The system displays the message Authorisation Required Do You Want to Continue The system displays the Authorization Reason screen Enter the relevant information and click the Grant button The system displays the transaction number The transaction number is system generated that uniquely identifies each transaction performed by a teller and can be used for tracking the transaction 44 ORACLE Authorisation Procedures 1 15 Authorisation Procedures You can define the following bank level parameters for authorisation e Parallel Authorization This parameter will allow transaction to be authorised by a same level or higher level user belonging to the same class e Re enter Transaction Amount This parameter will require the authorizer to input the transaction amount before authorizing a transaction done through specific options Authorisation can be broadly classified into following four types 1 Local Authorisation 2 Remote Authorisation 3 Centralised Authorisation 4 Deferred Authorisation 1 15 1 Local Authorisation Local authorisation is used when the authoriser authorises the transaction on the same location PC as that of the person posting the transaction without the person logging off from his session The transaction can be authorized by a user of same level or a higher level belonging to the same class based on the Parallel Authorization parameter value A user can be initiator of a transaction as well as an a
13. country SSN TIN number etc of the selected customer This screen rer Account Number 000000000075 the account Account Branch Head Office 9999 details of the customer Account Currency IDR 360 such as T account Account Title ABDIREZATEA s Account Details Account Product 1 number Customer Name ABDIREZATEA account branch account currency customer name etc 12 ORACLE Hot Key s Alt S Screen Name Amount based Account Image Display Descripti on This screen displays the images on the basis of the details maintaine d in the Amount Based Operatin g Instructio n Maintena nce Fast Path 7116 option Hot Keys Image Amt Rated Oper at eg Dove ru Dao Amount Banned Account Image 13 ORACLE Hot Keys Hot Screen Descripti Image Key Name on s Al GER Duringihe avs H Details course of saro ceme sen mra Maintena banking Mn business it always H T w helps to oe _ knowthe 77 7 profitabilit im y aspect of relationshi p with a customer Using this hot key you can get to know the volume of business associate d with the customer This Y screen gets populated whenever the Alt H is pressed at the Customer ID field This screen displays the details for the selected customer ID based on the CBR Details Maintena nce Fast Path CIM18 option 14 ORACLE Hot
14. encounters reasons requiring central authorization Teller sends the transaction for central authorization Supervisor access the central authorization transaction and authorizes the transaction waiting for authorization Teller resubmits the approved transaction from the Electronic Journal and completes the transaction If auto authorization is enabled Step A Activity By Teller Supervisor Teller Supervisor Activity Description Teller performs online transaction from the branch If system encounters conditions requiring local remote authorization transaction will proceed to step B If system does not encounter any conditions requiring local remote authorization but encounters centralised authorization requirement system will proceed to step D Supervisor approves the transaction using local authorization or remote authorization If local authorization is provided system proceeds for further processing System encounters reasons requiring central authorization Teller sends the transaction for central authorization Supervisor access the Central authorization transaction and authorizes the transaction waiting for authorization 52 ORACLE Authorisation Procedures Teller Activities 1 Enter the relevant information in the transaction screen and click the Ok button 2 The system displays the Authorization Required message box Microsoft Internet Explorer J Authorization Required Do you want to
15. entered a fast path the system will display the following Conventional User Interface Login Info TEDEMO BANK Hender Bank House Branch name length increased for testing reports alignment Themes Change Password Help About Logout Fast Path Customer Search Tree Menu Central Workspace Frequently Used Pending Transactions Transactions 25 ORACLE Understanding the Oracle FLEXCUBE User Interface Front Banking Executive User Interface bI DEMO BANK Head Office Housing Development Finance Corporation Nariman Point Mahatma Gandhi Road Laxmi Niwas Fort HDFC Mumbai India Cash Summary Login Info The Login Info section contains e The local currency of the bank e The name of the user who has logged into the system e The System Date This is the branch posting date e Previous Login Details Click this to view the last login date amp time and the number of unsuccessful attempts made if any Header This appears on top of every page in Oracle FLEXCUBE and contains the following e Name of the bank along with the bank s logo e The name of the branch to which the logged in user is linked Example Head Office Central Office Branch Office1 Branch Office2 etc 26 ORACLE Understanding the Oracle FLEXCUBE User Interface Menu Bar Menu bar contains certain options as shown in the following table Menu Descriptio
16. physical date and time This is the application server date time Last Mnt Action This indicates the last maintenance action which was authorized auto authorised Example Add Modify etc Authorised Indicates if the record in focus is an authorized record or not Modes Available For all maintenances Oracle FLEXCUBE enables various modes These are command buttons and used to perform specific functions The following table explains the individual button and its function Click To Add By Copy Add a new record with the features of an existing record O add Add a new record KO Modify Modify a record The user can modify the record after Je authorization All fields which do not form a part of the key field can be modified Oo Delete Delete a record The user can delete the record after trs authorization The record is deleted from the system and cannot be accessed O Cancel Cancel a record The user can cancel the record before Mewes authorization This will enable cancellation of the earlier changes that have done Example if the cancellation of the last modification was done the record will revert to the last authorized status Amend Amend a record The user who has added or modified the i record can amend it before authorization These amendments shall be taken into consideration when the supervisor authorizes the record 35 ORACLE Understanding the Oracle FLEXCUBE User Interface Click To
17. 00000 Txn Ccy Rate 1 00000 Customer Type Self Customer Category Individual Customer Status Resident Bank Notes 100000 Litas Coins 0 Centas Coins Total Amount 100 000 00 Account Amount Txn Amount Value Date 15 01 2008 User Reference No Narrative Cash Deposit Pin Validation Service Charge Sign Travellers Cheque 8 Click the Grant button to authorize the transaction The system displays the dialog box for confirming amount 9 Enter the amount If the amount entered matches with the transaction amount entered by the teller the authorizer can commit the transaction The authoriser can reject the transaction if required foracte Flexcube Authorization i Amount 100 000 00 10 Click Ok button The system displays the authorization screen 50 ORACLE Authorisation Procedures Oracle Flexcube Authorizati Dual control Reason Comments 11 Enter the relevant information 12 Click Grant button for record authorisation 1 15 3 Centralised Authorisation Centralised authorisation is a security enhancing setup which can be enabled in Oracle FLEXCUBE for providing additional authorizations when predefined reasons are encountered in online transactions by a group of supervisors preferably from those located centrally This level of authorization is subsequent to and
18. 1 00000 From Amount uio To Ccy Amount 84 001 Narrative 1000200000000349 FCY Cash Handling Click on OK button present at the bottom of the screen The system will display the main screen Click on OK button The System will display transaction sequence number on a pop up Click OK 82 ORACLE Customer Search 1 17 Customer Search This option allows you to search for account information based on customer search A list of accounts belonging to that customer is displayed and each record gives the status of that particular account This option would be useful to the user when the customer contacts the bank to check the status of their account and is unable to provide the account number This option has a primary search which is mandatory and secondary refined optional search The user may enter a combination of the values based on the options available in the advance and refined search The numbers of combinations possible are as follows Primary Search Criteria Secondary Search Criteria Customer short name Date of birth Date Incorporated Customer first name Date of birth Date Incorporated National ID Customer IC Date of birth Date Incorporated Customer last name Mobile number Customer first name Home phone IBAN Currency Customer ID IBAN and ATM card number is unique for every customer hence when it is selected as the search string the user has to input exact string to get the record Wi
19. Birth Customer s Combined Total Withdrawal Balance Officer Name Address Search CASA Customer Search Description Display This field displays the full name of the customer The full name of the customer is defaulted from the Customer Addition Fast Path 8053 option For Example If the full name entered in the search criteria is George then Oracle FLEXCUBE will display all the customer s with the name as George along with all the other details Display This field displays the category of a customer For Example Individual Corporate etc Display This field displays the gender of the customer Display This field displays the date of birth of the customer Display This field displays the customer combined balance in local currency For more information refer to Calculation Details 1 at the end of this topic Display This field displays the name of the officer Display This column displays the residential address of the customer Note For better readability understanding the screen shots are provided in 2 separate rows While working in Oracle FLEXCUBE you have to use the horizontal scroll bar to view all the fields 14 SAVINGS REGULAR DAILY BALL 20 SAVINGS REGULAR DAILY BALI Head Office HouINR 0 00 0 00 0 00 0 00 0 00 UNBLOCKED Head Office HouINR 98825 47 98992 00 0 00 0 00 0 00 UNBLOCKED ACCOUNT CLOSED ACCOUNT OPEN REGULAR NORMAL sow NOR
20. Case ca DERE get one 47 1353 Centrales Authoris SOL 51 en REN 58 TEN dE cosas ted inde ke 59 1 15 1 SOP Charge Detalle l u 61 EEE EEE 64 1103 Cheque me 68 ER DA a 69 VIES eee hen 71 1168 User Dannegd eere atv ee toi tet poetis 72 EFE L sec ards hu a ease peda AREER 75 TER Coume ROP ona E I 76 TRI I UII qa 77 EEE EEE EE 80 LES UAE SE EE EE NE ERE ET 83 Te Gs RR EEE EE 98 ER 161 ORACLE Introduction to Oracle FLEXCUBE 1 Introduction to Oracle FLEXCUBE Oracle FLEXCUBE is a comprehensive solution that provides a unified back office processing environment for Corporate Retail and Investment Banking operations with a highly adaptable and scalable modular architecture Oracle FLEXCUBE is designed to offer flexibility to financial institutions for easy adaptability to market needs and also enables banks to improve their overall operational efficiency Oracle FLEXCUBE offers effective control and risk management thus delivering improved performan
21. Loan Account Applicatio P Loan User Defined Sche f Loan Account Repricing Loans Account Renewal P Loans Interest Waiver P Loan Account Address Loans Account Activatio Loan Funds Flow Calcul Loan Account Status Ch gt Clearing e The system displays the transaction screen in the Central Workspace as shown in the following figure 30 ORACLE Fast Path LNMB1 5 SELECTED CUSTOMER Clear gt Global Definitions Transaction Processing gt Walkin Transactions Account Transactions Loan Account Transacti Other Transactions Loan Account Attrib Account Documents Loan Disbursement Account Rates P Loan Approved Miscellaneous Charg P Interest Calculation Loan Commitment F gt Account Schedule Asset Agreement In P Loan Account D P Loan Auto Disbursm Account Payments L P Loan Direct Account P Loan Account Applic Loans Account Rene Loans Interest Waiv Loan Account Addre P Loans Account Activ Advance Loan Account Commi Ra hana p LNMB1 Rate Change _ Additional Document Miscellaneous Loans P Loan Account Payoff P Loan User Defined Sc P Loan Account Reprici Loan Funds Flow Calc P Loan Account Status Understanding the Oracle FLEXCUBE UsSser Interface
22. Mnem Cust Id AccountNo Description Amount State Authori 13 01 2006 11 49 08 9999 TVINEET 29 1001 600075 9999101000001080 INR 6 000 00 Incomplete Ej 3 The system displays all the transactions sent for authorization 4 Click the transaction to view the transaction details 54 ORACLE Authorisation Procedures 5 The system displays the transaction details screen The supervisor cannot modify any details on the screen Account No P SEEMA Account Coy Nr z Txn Coy fin Acct Ccy Rate Txn Coy Rate 1 Amount Account Amt 5 00 Narrative thdrawa E Taventory Details 2 Ok _ Cancel Mark Grant Deny view Back 6 Click the Grant button to authorize the transaction 7 Click the Deny button to deny authorization of the transaction 8 The system displays the Authorization Reasons screen 55 ORACLE Authorisation Procedures Account No M Account ng 3 Txn Coy fine Acct Coy Rate Txn Ccy Rate 1 Amount 6000 Account Amt Narrative j lexcube Web Page Dialog Authorization Reasons Reason SANCTION OBTAINED Comments Overdraft for the account z i tnventory Detalls 2 Ok cancei Mark Grant Deny view Back 9 Select the reason from the drop down list and type the comments 10 Click the Ok button Teller activities after authorization If auto authori
23. Name Beneficiary Addr Narrative User Reference No Danamon Bank v IDR EJ Txn Ccy 1 00000 Txn Ccy Rate 500 00 10 00 10 74 Serial Routing Dh Passport IC a Altamount Road 5525 _ Sale Against Cash USD 47 50000 Common Screens 5585 wr o J dee If you click the Service charge transaction definition tab the system will display the SC common screen The tabs can be disabled using the Transaction Definition Fast Path TC001 option 60 ORACLE Common Screens 1 16 1 Service Charge Details A maximum of five default service charges can be linked to each transaction Screen Pre Requisite e BAM 14 TOTAL LCY 36 00 oe cue ee dle m Field Description Field Name Description Service Charge Display This field displays the default SC which is linked to the transaction 61 ORACLE Field Name Amount CCY Amount Lcy Parent Lcy Addn LCY Rule Applied Collection Mode Collection Mode ccy Total Lcy Common Screens Description Mandatory Numeric 13 Two Type the service charge to be applied By default this field displays the service charge amount in SC currency The SC is defaulted based on the setup If the relevant SC is to be waived type zero in this field
24. Processing Customer ID Change Maintenance Customer Lock Unlock System Customer ID Verification Maintenance Customer ID Verification History Change Customer Anniversary Maintenance Customer Information Maintenance Customer Blacklist Details Modification CTI Customer Search Customer Name and Address Inquiry All Balance Inquiry Contract Details Inquiry 116 ORACLE Fast Path CI999 CIM55 3000 7102 7103 7104 7105 7111 8053 9 CIM11 CIM17 CIM40 CHM52 Appendix of Fast Path Description Customer Zoom Inquiry Customer ID Verification History Inquiry Thumb Print Interface Link Customer Image Unlink Cust Image Authorize Customer Image Display Customer Image Modify Customer Image Customer Addition Customer Master Maintenance Customer Details Maintenance Corporate Customer Details Zengin Short Name Maintenance Customer Document Maintenance 117 ORACLE Fast Path TDS05 ETMO1 1501 CI502 C1503 C1504 BA095 Appendix of Fast Path Description Customer Special Tax Code Maintenance Customer Alerts Registration Assisted Customer Creation Offers Inquiry Create Lead Customer Service Maintenance Account Level Attributes Inquiry Module Name Current And Savings Account Fast Path BA996 1320 CH001 7002 CH031 CH051 Description Product Transfer Maintenance Close Out Balance Inquiry Account Closing Balance
25. Seamless Transaction Delivery over Multiple Channels Oracle FLEXCUBE supports 7x24 non stop convenience banking for all retail transactions through various delivery channels like branches ATMs POS terminals debit cards SWIFT telephone call center and internet Oracle FLEXCUBE branch is designed to be functional even during network failures When communication links are not operational the branch can process the retail transactions in an off line mode All transactions carried out off line are stored at the branch and uploaded to the host automatically for processing whenever the link is re established Offline capability has inbuilt intelligent roll back facility to maintain data integrity Language Support Oracle FLEXCUBE is a multi lingual system which uses the Oracle Translation Manager and other tools for providing the multilingual support Real Time Information The multi level drill down facility allows a user to drill down from an overall view of accounts or contracts to a more detailed view of specific accounts or contracts Flexible Interfaces Oracle FLEXCUBE supports standard ISO 8583 formats thereby ensuring support for all ATM switches using the same It also provides for standard API calls which the external applications of the bank can use for online interface to Oracle FLEXCUBE Oracle FLEXCUBE also provides for batch posting of financial entries from an external system Multi Entity Support Different legal entiti
26. continue Cancel 3 Click the OK button 4 The system displays the Authorization Reason screen Flexcube Authorization Dual control Hold Funds Present Refer to Drawer Account would Overdraw Account Number 000000007260 Available Balance After Transaction 400 40 9 Local Remote Supervisor ID Primary Password Reason Comments Select the Remote option The system displays the list of supervisors Click on the appropriate supervisor o No o The system displays the message Transaction Sent For Authorization Click the Ok button 53 ORACLE Authorisation Procedures 9 The system displays the transaction sequence number Click the OK button Supervisor Activities At Local Branch The supervisor authorises the transaction done by the teller locally or remotely For more information on Local and Remote authorization refer to Local Authorization and Remote Authorization earlier in this chapter At Central Location 1 Navigate to the Centralised Authorization screen using the fast path 4501 2 Transactions to be authorized can be filtered by entering one or more of the following a From Branch and To Branch b Mnemonic c Customer ID d Account No e Teller ID Centralised Authorisation From Branch 792 1 To Branch oso o t Mnemonic fi id t Customer Id Account No 9999101000001080 Teller 1d Txn Date TxnTime Branch UserID SeqNo
27. in addition to the local remote authorization which would have been provided for the transaction to confirm the overrides The predefined reasons are defined in the branch database in an internal table called ba auth reason mast table Centralised authorization is done by a specific transaction which can be accessed only by certain supervisors as identified in the Security Management System SMS setup Supervisors accessing this transaction can identify the transaction s to be authorised by using the from branch transaction code customer id and account number combination The centralised authorization process is divided into the following steps namely If auto authorization is disabled 51 ORACLE Step Activity By Authorisation Procedures Activity Description A Teller Supervisor Teller Supervisor Teller Teller performs online transaction from the branch If system encounters conditions requiring local remote authorization transaction will proceed to step B If system does not encounter any conditions requiring local remote authorization but encounters centralised authorization requirement system will proceed to step D Supervisor approves the transaction using local authorization or remote authorization If local authorization is provided system proceeds for further processing Teller resubmits the approved transaction from the Electronic Journal for transactions sent for remote authorization System
28. or distribution of this software product or any portion of it may res ulti e Click the Click here to login link e Oracle FLEXCUBE displays the login screen as shown in the following figure 4 ORACLE Starting Oracle FLEXCUBE ORACLE FLEXCUBE User Name Password e Enter your identification code in the User Name field and the password assigned to you in the Password field and click Login If either the user ID or the password is incorrect the following screen is displayed Oracle Flexcube A Login Failed Note All the characters you type in the Password field will appear as for security reasons e The system displays the main application window depending upon the nature of user logged in The initial screen menus displayed after login depends on the access rights provided by the Oracle FLEXCUBE security administrator to the template under which the user is registered 5 ORACLE 1 2 Product Features Product Features Flexibility through Standardization Oracle FLEXCUBE s unique Product Definition facility is a manifestation of its flexible design This feature allows a bank to define the various services and elements that the bank would offer under a product to all customers thereby ensuring that all customers are offered the same uniform services Modular yet Integrated The various functional blocks of Oracle FLEXCUBE are built on th
29. required module and select the required option with a mouse click The tree menu structure can be defined using the template task cross reference maintenance Using Menus This section explains the two methods available to navigate to options in Oracle FLEXCUBE They are as follows e Fast Path method e Menu method 27 ORACLE Understanding the Oracle FLEXCUBE User Interface To access an option fast path method e Fast Path is an alphanumeric keyword used to uniquely identify a transaction It is also called a transaction mnemonic e The Fast Path is to be entered in the Fast Path text box provided in the top left corner of the Oracle FLEXCUBE screen as shown in the following figure Fast Pat h BAMDS Go e To access the option type the Fast Path code in the text box and click Go or press ENTER For example enter 8053 in the Fast Path text box and press ENTER the Customer Addition option is displayed as shown in the following figure Customer IC Category CIF Customer 1 Language v Customer ID Ful Name First Name Made Name Last Name Sakstabon Short Name Address Town Cty v Country Nationality Country of Residence E Beth Reg Date e Resi Phone No Customer Education Mobile No Emai ID Gender v Marital Status Ratt Employee 14 Business Profession To navigate to an option menu method e When you login the sys
30. screen 2 The System will display Handle FCY screen as shown below From Ccy To Ccy x From Ccy Rate 2 3 To Ccy Rate 1 From Ccy Amount 0 00 To Ccy Amount 0 00 Narrative FCrcashHandmg og Field Description Field Name Description From Ccy Display This field displays the currency of the account that is debited for the FCY Cash Withdrawal Transaction ACY 80 ORACLE Common Screens Field Name Description To Ccy Display This field displays the local currency This will always be the LCY of the branch From Ccy Display Rate This field displays the FX midrate between the ACY amp LCY To Ccy Rate Display This field displays the LCY Coy rate This value will always be 1 00000 From Ccy Numeric 13 Two Amount Type the value for FCY amount for this the branch teller wants to handover the change to the customer Amount should not be greater than the transaction amount To Ccy Display Amount This field displays the equivalent LCY for the FCY Amount entered in the FCY Amount field Narrative Alphanumeric 40 Type the transaction description As a narrative enrichment the standard narration will be suffixed with FCY Cash Handling lt Account Number debited gt 3 Fill in the required fields 81 ORACLE SO S Os Ot Common Screens From Ccy USD To RMB v From Ccy Rate 700 00000 To Ccy Rate
31. the total group balance c Interest Calculation on the total group account balance d Reduction of overdraft charges NPL Non Performing Loans NRE Non Resident External ODC Outward Direct Credit ODD Outward Direct Debit ODFI Originating Depository Financial Institution The financial institution that processes ACH files on behalf of the Originator through the ACH network Originator ACH context A Company or individual who initiates an ACH transaction The person or organization who had authorized an ODFI to transmit a credit or debit entry to the account of a receiver with an RDFI or if the receiver is also the RDFI to such receiver In some cases the ODFI may also be the originator 164 ORACLE Glossary P amp R Pay and Receivable PAT Pre Authorised Transfers PCL Personal Line of Credit PDD Projected Date of Dormancy PDO Permanent Dividend Order PL Performing Loans PMI Post Maturity Interest PMO Personal Money Orders Post Maturity Period It is the phase of the loan account after the maturity date Loans Theoretically if all the arrears are being paid on time then an account should never get into this phase Due to this reason there is no stage of the schedule associated with this phase of the loan account The interest rates applicable for an account can be different for this period PPF Partial Pay off It is the payment of any principal amou
32. the drawer account number for its correctness Display This field displays the value date of the cheque When a cheque is deposited on an account the system uses the routing number to check the float days from the Endpoint Float Maintenance Fast Path BAM28 option and the working days from the Endpoint Clearing Branch Composite Calendar Fast Path BAM33 option to generate the value date of the cheque The value date is the date on which the cheque is expected to be cleared On the value date the system updates the customer s available balance and credits the account with the cheque amount and reduces the un cleared funds on the account For more information on maintaining value date refer to the Clearing Definitions option in the Definitions User s Guide 66 ORACLE Common Screens Field Name Description Late Clearing Display This field displays the values Y or N for late clearing The options are e Y lfthe late clearing is marked e N If the late clearing is not marked This field displays Y when a customer deposits a cheque after the clearing cut off time is over for current posting date for the selected clearing type The instruments that are deposited in late clearing will be considered as Late for clearing Such instruments will be treated as deposit for the next working date for all value date calculation Chg Commission Display This field is currently not used in any processing Instr Sub ty
33. through the menus to Transaction Processing gt Internal Transactions gt Inquiries gt Search Electronic Journal or My To Do List link provided in the menu option 48 ORACLE com om authorization m Electronic Journal Remote Authorization Teller ID Branch Posting Date 55 1042008 Account No From Sequence No From Txn Time 00 00 00 From Amount tom Mnemonic m Incomplete Transactions Select the Teller ID from the pick list Click the Remote Authorisation option Host Process Date To Sequence No To Txn Time To Amount 30 04 2008 Remote Authorized Transactions 7 a bes 1 1356 15 1006 2001 CH050 2002 CH050 5001 7115 5003 7115 fo 10 000 00 56 00 0 00 0 00 0 00 0 00 SDEVTD3 TDEVIDEA1 TDEVGL1 TDEVGL1 TDEVCASA2 TDEVCASA2 2521 2563 387 387 2505 2505 Authorisation Procedures The system displays the Search Electronic Journal screen Click the Fetch button The system displays all the transactions sent by the teller for Instrument Inventory 7 The system displays the relevant screen 49 Card Cheque Cost De ion in Validation 5 Charc que UDF ET 6 Double click the sequence number in the Seq No column ORACLE Authorisation Procedures h Deposit du z Account No 60000001756440 Feray Account Ccy LTL Txn LTL Account Ccy Rate 1
34. without obligation of Oracle Financial Services Software Limited to notify any person of such revision or changes All company and product names are trademarks of the respective companies with which they are associated
35. 0000575440 General Product omme 10 scheme Benefit 601 Centrine bustineLTL 1122000 0 NORMAL Home Branch Currency Original Bal Outstanding Bal Classification Status Account Rel External Account No Loan Application No IBAN 70000000002440 Term Product Gap 19 Flexischedule Daily 605 Centrine bustineL TL 15000000 NORMAL Field Description Column Name Description Account No Display This column displays the account number of the customer Product Name Display This column displays the product name Product Code Display This column displays the code of the product under which the customer has an account Display This column displays the name of the home branch under which the customer has an account Display This column displays the currency assigned to product under which the account is opened Display This column displays the original balance of the loan account Display This column displays the outstanding balance for the account Display This column displays the status of the account Display This column displays the relation of the customer with the account Display This column displays the external account number Display This column displays the application number of the loan Display This column displays the IBAN number 90 ORACLE Customer Search Search Scheme Benefit This tab displays the details of the RP schemes availed by the selected custome
36. 53 BAM54 BAM94 BAM96 CHM43 ST043 ST044 Appendix of Fast Path Description Download Log Download Service Upload Local File File Upload Status Inquiry Upload Account Balance File Generic External File Upload File Upload GEFU SCHEDULAR SETUP External File Setup External File Processing Upload File Status Inquiry File Upload Inquiry GEFU Cheque Book Issue Upload Load Inward Remittance File Outward Remittance Hand off 160 ORACLE 1 19 Glossary Glossary Glossary Term Description ACH Automated Clearing House It is an electronic payment and information delivery system which transfers dollar amounts and related information between business private and government sectors ADB Average Daily Balance AMB Average Monthly Balance AO Account Officer APS Application Processing System APY Annual Percentage Yield The formual for Annual percentage yield APY 1 r m m 1 100 Where r Rate of interest per annum m Compounding frequency of Times interest is compounded in a Year APYE Anuual Percentage Yield Earned The formula for APYE 100 1 Interest Principal 365 Days in term 1 The Days in Term figure is governed by the Accrual Basis Average Quarterly Balance Back to back loan The loan against TD BCL Business Line of Credit BIC Bank Identification Code Cash pooling The salient features are 1 It is a
37. 61 BAM62 BAM68 BAM72 BAM75 BAM85 BAM92 BA101 Appendix of Fast Path Description Pay Receivable Account Maintenance Bank Master Maintenance Branch Type Maintenance Bank Codes Maintenance Country Definition Product Category Maintenance Account Officer Maintenance Screen Customer Account AO LOB X Ref Islamic Product Attributes Customer City master Maintenance State Codes Maintenance Region Codes Maintenance Department Master Maintenance Custom Functions Maintenance ORACLE Fast Path BA441 BA453 BAM40 BAM78 BAM79 81 5 BAM83 BAM91 BAM98 BAM99 LNM27 TC001 PM002 Appendix of Fast Path Description Global Site Maintenance Parameterized Output Generator Reason Code Maintenance Third Party Company Details Third Party Collection Remittance Company Master Maintenance Billing Master Maintenance MIS Xref Maintenance FIS Bank Params Maintenance Transaction X ref Maintenance GL Codes Cross Ref Maintenance Account Status Event Xref Maintenance Transaction Definition Payments Transaction Definition 208 ORACLE Fast Path PM003 PM004 PM005 PM007 PM008 PM009 PM011 PM012 PM019 PM020 PM021 PM029 PMM01 CHM10 Appendix of Fast Path Description Network Configuration Bank Branch Directory Zone Circle Maintenance Payments Network Adapter Network Master Payment
38. C Coda a Transaction Status v File Name Click on the Lookup button to search the IFSC Code The system displays the following screen 77 ORACLE Common Screens Oracle Flexcube Data Selection Web Page Dialog Field Description Field Name Description Advance Search Mandatory Radio Button Page Click the appropriate option to search the IFSC code The options are e Basic e Advance 78 ORACLE Common Screens Field Name Description IFSC Code Optional Drop Down Alphanumeric 11 Select the condition from the drop down list The options are Contains Does Not Contain Equal to Not Equal To Starts With Ends With Is Blank Type the IFSC Indian Financial System Code code in the adjacent field It is a unique code across the branches of banks in India for NEFT and RTGS Bank Name Optional Alphanumeric 40 Type the name of the bank Branch Name Conditional Alphanumeric 120 Type the name of the branch This field is enabled if the Bank Name is entered Click the Find button The system displays the list of IFSC code for the respective bank and branch name 79 ORACLE Common Screens 1 16 10 Handle FCY This tab is enabled if the controls are defined on the Transaction Definition Screen FP TC001 and when transaction currency selected is FCY in the transaction mnemonic screen 1 Click on Handle FCY Tab present at the bottom of the main
39. IM04 Appendix of Fast Path Description Currency Definition Currency Rates Maintenance Treasury Spread Maintenance Transaction Rate Cross Reference Special Exchange Rate Inquiry Currency Denomination Definition Currency Codes Maintenance Currency Pair Definition CASA Multi Currency Product Package Definition Currency Float Maintenance Nominee Master Maintenance Signature Types Maintenance Business Type Maintenance Profession Codes Maintenance iab ORACLE Fast Path CIMOS3 CIMO5 CIM06 CIM07 CIM08 INM05 BAM12 BAM13 LN060 LNM41 LNM42 LNM81 BAM45 BAM67 Appendix of Fast Path Description Customer Prefixes Maintenance Reporting Group Codes Maintenance Income Slabs Maintenance Relation Master Maintenance Customer Types Maintenance Insurance Claim Status Interest Index Maintenance Interest Index Rates Loan Product Rates Plan Interest Rules Product Interest Attributes Maintenance Rate Change Insurance Master Maintenance Collateral Insurance Cross Ref Maintenance i88 ORACLE Fast Path BAM77 CHM56 LNM98 LNM43 IVMO1 IVM02 IVM03 IVM04 SBMO1 BAM55 BAM73 LMBO1 LMCO1 LMCO05 Appendix of Fast Path Description Insurance Policy Master Maintenance Insurance Xref Maintenance Schedule Type Installment Rules Stock Codes Supplier Codes Inventory Control Branch Cross Reference Maintaining Stock branch Cross Refere
40. In Bal Balance of all Sweep In provider TD accounts Balance of TD account Principal Balance Principal Lien Amount e Linked 2 Way TD Sweep In Bal Balance of all 2 Way Sweep In TD accounts Balance of TD account Principal Balance Principal Lien Amount 97 ORACLE Appendix of Fast Path 1 18 Appendix of Fast Path Module Name Definitions Fast Path ACMO1 ACMO2 ACM03 ACM04 ACM05 ACMO6 ACM11 BS001 BS004 BS007 BS010 BS013 BS020 BS016 BAM89 CHMO1 Description Asset Classification Global Parameters Asset Classification Preferences CRR Codes Maintenance Product CRR Codes Maintenance Asset Classification Plan Maintenance Automatic Write off Bank Parameter Maintenance Product Provision Codes Maintenance Rating Agency Maintenance Rating Group Maintenance Basel II Pick list Maintenance Basel II Securitization Details Maintenance Basel II Customer Details Maintenance BASEL II Data Capture Screen Basel II Account Details Maintenance Reference Directory Bank Code Maintenance CASA Product Master Maintenance T ORACLE Fast Path CHM02 CHM84 CHM04 BA078 BA080 BAM27 BAM28 BAM29 BAM33 BAM41 ST080 STM50 STM54 STM55 Appendix of Fast Path Description CASA Interest Rate Tiers Maintenance CASA Product Attributes Maintenance CASA Bank Parameters Maintenance User Defined Fields Maintenance CBR Pick Lists Ma
41. Information Balance Inquiry Statement Inquiry Account Capitalization History Inquiry 118 ORACLE Fast Path CHO068 7106 014 AC040 BA437 BAM69 CH021 CH070 CHM08 CHM21 CHM24 CHM38 BAM06 CHM45 Appendix of Fast Path Description Amortization Inquiry Account Image Display Account CRR Details Maintenance Asset Agreement Inquiry Account Memo Maintenance Islamic Account Attributes Account Master Maintenance Accident Reason Code Maintenance CBR Codes Maintenance Account Status Maintenance Group Accounts Maintenance Inward Direct Debit Maintenance Direct Debit Registration Account Master Attributes Maintenance nS ORACLE Fast Path CHM51 CHM55 1142 CIM28 SCM08 5004 CH078 CHM35 CHM37 CHO066 CHM06 CHM07 1401 1408 Appendix of Fast Path Description Lucky Account Number Generation Group Definition Maintenance Customer Account Relationship Maintenance Account Operating Instruction Maintainence Account Level SC package Maintenance Cheque Book Request Cheque Status Maintenance Stop Cheque Instructions Cheque Book Issue Maintenance Limit Collateral Inquiry OD Collateral Maintenance OD Limit Master Maintenance Cash Deposit Miscellaneous Customer Credit 120 ORACLE Fast Path 1411 1421 1429 1803 1908 6501 6601 BAM21 ST070 1001 1008 1013 1708 1802 App
42. Key s Alt P F8 Screen Name Descripti on This will enable the user to print the receipt of the transactio n This will enable the user to return to the same screen 15 Image Hot Keys ORACLE Exiting Oracle FLEXCUBE 1 7 Exiting Oracle FLEXCUBE The user needs to follow the correct procedure to exit Oracle FLEXCUBE The user has to log out from the application and then close the browser window To exit Oracle FLEXCUBE 1 Each screen in Oracle FLEXCUBE has the Logout link on the header 2 Click the Logout link 3 The system displays the Logon screen 16 ORACLE Typographical Conventions 1 8 Typographical Conventions This Bold lt Xyz gt Constant width Represents Transaction Screen Name Field Names Check Boxes Button Names Product Name etc Name of a keyboard button Formulae 17 ORACLE 1 9 Using The online help Using Online Help Online Help is the primary source of information for Oracle FLEXCUBE It is a convenient way to look up information about a task you are performing or a feature or dialog box you would like to know more about Help on procedures You can find the common tasks in the TOC tab or you can search text using the Search tab The tree structure of all maintenance s and transactions appearing on the left side of the window are arranged in the same order as the user manual They are segregated as setup definition mai
43. MAL COB Field Description 1N357044006060980000 15 01 2008 15 01 2008 0 600 00 600 00 1N557044006062520000 15 01 2008 15 01 2008 0 98 225 47 98 225 47 Column Name Description CASA Account No Display This column displays the account number of the customer Product Name Display This column displays the product name 86 ORACLE Column Name Product Code Home Branch Currency Available Bal Book Balance Unclear Funds Future Dated Cash Deposit Bills Blocking Code Account Status Classification Status Account Rel Customer Search Description Display This column displays the code of the product under which the customer has an account Display This column displays the name of the home branch under which the customer has an account Display This column displays the currency assigned to product under which the account is opened All the entries are posted in the account in the account currency The exchange rate values are defined and downloaded For example if the currency assigned to a CASA product is USD US Dollar the account opened under that product has USD as its account currency by default Display This column displays the Available Principal Outstanding balance in the account In case of CASA account the available balance under the customer s account will be displayed The amount will be displayed in the currency of the account In case of TD account th
44. Oracle FLEXCUBE Introduction User Manual Release 5 0 2 0 0 Part No E52129 01 ORACLE FINANCIAL SERVICES ORACLE Oracle FLEXCUBE Introduction User Manual Table of Contents index 1 Introduction to Oracle FLEXCUBE 3 KE gs SE ai oni drea 4 1 e cse Ma Loc ROTE etre PS 6 1 3 Funotiarnal OVervi W u u uyu nag Rame dE E aadnk Rcx cudk Ua A Aqu 7 Core EE NE 7 1 3 2 Common Facilities Uu uuu Uu LL LU do iE aa 7 RR On drap da ada 8 EE hb IN sei cf T TS 8 Eee cl rete m 8 Tals Oer OF RE NE 9 ee Te RE NN 10 DON EN uu ua 11 Enung Orate FLEX dcr u a m 16 1 8 T R TR TT LTTE eee aa au 17 EEE 18 1 10 Structure of User Manual Documentation Set eese 21 Tti User Mamual sel 23 1 12 Understanding the Oracle FLEXCUBE User Interface 25 1 13 Standard Maintenance Procedures rat otto saec 41 1 34 Standard Transachon PioSSQOUEBS sioe LL pereo nee ecc Coal sa ect u u Eua cade 44 EET Gs eai ce ERE Cio tua u u Boi ee dup u tl pdt dU Sed ER Ib CE d icu UAE 45 1 151 Local Aut es EE 45 1 15 2 Remote AU SAIN Leddene abo te d
45. Product Task Code Restriction Xref Template Transaction Field Xref Multi Currency Package Definition Additional Dormancy Parameter Maintenance Multi Currency Account Address Maintenance Multi Currency Account Master Maintenance Product IB Transaction Restriction Xref Product to Product Transfer Restriction Xref Product Class to Product Class Fund Transfer Restriction Xref Future Dated RD Account Opening Instruction maintenance RD Drawdown Instruction RD Education Deposit Certificate Maintenance 114 ORACLE Fast Path MCA04 TILO1 Appendix of Fast Path Description RD Account Opening under MCA TIL ID Maintenance Module Name Customer Information File Fast Path 7101 BAM64 C1002 Cl142 Cl162 CIM10 CIM12 CIM13 CIM16 CIM18 CIM19 Description IC No Short Name Change Customer Account Nominee Cross Reference Backoffice User Definition Customer Account Relationship Maintenance Combined Statement Plan Customer NLS Details Maintenance Customer Contact Log Maintenance Customer Memo Maintenance Customer Dormancy Status Maintenance CBR Details Maintenance Customer Blacklist Details 115 ORACLE Fast Path CIM20 CIM21 CIM30 CIM39 CIM42 CIM54 CIM56 CIM57 CIM78 STM81 2000 7004 7100 1001 Appendix of Fast Path Description Investor Services Customer Data Inquire Customer Account Restriction Customer Maturity
46. This field displays the cost rate for the account currency that is defaulted to the mid rate for the currency Mandatory Drop Down Select the currency of the cheque from the drop down list This field by default displays the account currency as the transaction currency While posting the transaction entries to the account the transaction currency is converted into the account currency and for posting the GL entries it is converted into the local currency of the bank Display This field displays the rate at which the transaction currency is converted to the local currency of the bank The teller s right to change the transaction currency rate is configurable at the bank level If such rights are not assigned to the teller this field becomes non editable If the transaction currency and the local currency are same the field takes the default value as 1 which cannot be modified Display This field displays the cost rate for transaction currency that is defaulted to the mid rate for the currency Click the Ok button to accept the inventory details as a part of the transaction Click the Cancel button to reject the inventory details 72 ORACLE Common Screens 1 16 6 User Defined Fields While working with Oracle FLEXCUBE there are additional fields which are required to be used either for convenience or to suit the requirements of the bank The User Defined Fields option allows the user to add fields based on the
47. a new search Calculation Details 1 Customer s Combined Total Withdrawal Balance is be calculated as below e Total Balances of all owned CASA accounts Total Balance Available Balance Minimum Balance Required Hold Balance Sweep In Amount Lien Drawing Powert Advance against uncleared funds Limit Confirmation Amount e Balance of all owned TD accounts Principal Balance Principal Lien Amount e Net Balance of all Sweep in Provider non owned CASA accounts Net Balance Available Balance Minimum Balanc Required Hold Balance Drawing Power Sweep In Amount Lien Confirmation Amount 96 ORACLE Customer Search e Balance of all Sweep In provider non owned TD accounts Principal Balance Principal Lien Amount e Balance of all 2 Way Sweep In Provider non owned TD accounts Principal Balance Principal Lien Amount Calculation Details 2 Combined Total Withdrawal Balance for a given CASA account is calculated as below e Total Balance of a CASA account Total Balance Available Balance Minimum Balance Required Hold Balance Sweep In Amount Lien Drawing Power Adv against uncleared funds Limit Confirmation Amount e Linked CASA Sweep In Bal Net Balance of all Sweep in Provider CASA accounts Net Balance Available Balance Minimum Balance Required Hold Balance Drawing Power Sweep In Amount Lien Confirmation Amount e Linked TD Sweep
48. al Alpghanumeric 20 Type the short name of the customer 93 ORACLE Field Name NLS Name ATM Card Number IBAN Refined Search Mobile No Home Phone Date of Birth Date Incorporated Currency Search Result Customer IC Customer Search Description Optional Alphanumeric 40 Type the last name of the customer Optional Alphanumeric 16 Type the valid ATM card number of the customer Optional Alphanumeric 34 Type the IBAN All the accounts which belong to the IBAN entered are displayed Optional Numeric 30 Type the mobile number of the customer Optional Numeric 15 Type the home phone number of the customer Conditional Pick List dd mm yyyy Select the date of birth of the customer from the pick list It cannot be a future date This field is disabled if data is entered in the Date Incorporated field Conditional Pick List dd mm yyyy Select the date of incorporation from the pick list This field is disabled if data is entered in the Date of Birth field Conditional Drop Down Select the currency as an additional search criteria with IBAN from the drop down list This field is enabled if the search criteria are IBAN The currency details are maintained in the Currency Codes Maintenance Fast Path BAM56 option Display This column displays the identification code of the customer A customer IC along with customer type is a unique method of customer i
49. an click the Negotiate button to get a better exchange rate as compared to the current rate The Treasurer can view the exchange rate change request using the Treasury Negotiation Worklist Fast Path BA030 option The treasurer has the right to reject or negotiate the exchange rate 75 ORACLE Common Screens 1 16 8 Document Receipt This screen is displayed at the end of some transactions For example While using the Future Dated Cash Deposit Fast Path 1411 option at the end of the transaction the system will display the Document Receipt screen It is used to print the details of the transaction Document Reciept Documents Receipt Field Description Field Name Description Sr No Display This field displays the serial number Doc Id Display This field displays the document Id Description Display This field displays the description Printed Display This field displays the whether the transaction details have been printed or not 76 ORACLE Common Screens 1 16 9 IFSC Lookup The IFSC code is a unique identification code for the branches across a bank It is used for NEFT and RTGS transactions Branch Code 9999 8 User Id B Start Date End Date 30 06 2008 81 Payment Type Payment Transaction Code J Amount Min 0 00 Amount Max 99 999 999 999 00 Account Number Network Id RTGS NEFT Ref No IFS
50. ance Group Passbook Update Inquiry Passbook PIN Maintenance Passbook And Debit Card Account Linkage 125 ORACLE Fast Path 1501 CH058 1420 PSM02 CH082 MCA12 MC141 PS005 MCA03 MCA06 MCA08 BAM59 MCA70 Appendix of Fast Path Description Cash Deposit CASA Interest Adjustment Transaction RD Installment Payment Inquiry Passbook MCA Linkage Maintenance Dormant CASA Account Reactivation Maintenance Multi Currency Account Additional Details Maintenance Multi Currency Account Customer Relationship Maintenance Passbook Multi currency account linkage Multi Currency Account Opening CASA Account Opening under MCA Multi Currency Package Transfer Product Class Ccy Rate Cross Reference Account Relationship Manager Maintenance 126 ORACLE Appendix of Fast Path Module Name Time Deposit Fast Path 1337 TD029 TD039 7020 TD023 TD031 TD037 TD040 TD041 TD042 TD050 TD070 TDM07 1007 Description TD Interest Payout Inquiry TD Interest Adjustments TD Multiple Payout Instructions TD Balance Inquiry TD Rates History Inquiry TD Audit Trail Inquiry TD Account Ledger Inquiry TD Maturity Amount History TD Deposit Certificate Inquiry Interest and Principal Payment History TD Interest Inquiry Discounted Time Deposit Inquiry Investment Calculator Quick Payin By CASA 127 ORACLE Fast Path 1021 1356 1358
51. ber is used by the system to determine the float days and thus the value date of the instrument For an inward clearing cheque this routing number should belong to the bank The order in which the codes in the routing number are to be entered is determined by the set up using the Settlement Bank Parameters screen Display This field displays the bank name to which the cheque belongs corresponding to the bank code extracted from the routing number 65 ORACLE Common Screens Field Name Description Branch Display This field displays the branch name from where the cheque is drawn corresponding to the branch code and bank code extracted from the routing number Sector Display Drawer Acct No Value Date This field displays the clearing sector name to which the cheque branch belongs corresponding to the sector code extracted from the routing number Sector Codes are defined using Sector Codes Maintenance Fast Path BAM41 option Mandatory Numeric 16 Type the account number on which the cheque is drawn The drawer account number is the account number of the person who has issued the cheque The drawer account number which is generally printed on the cheque leaf is the account from where the funds will come into the beneficiary account If the cheque is drawn on a different bank the drawer account number will not be validated by the system If the cheque is drawn on your own bank the system will validate
52. ccount Profile If the user clicks on this option the system displays the Account Transactions Inquiry Fast Path LNM10 option Commissions Etc If the user clicks on this option the system displays the SC History for Account Inquiry Fast Path SCM05 option Unclear Funds If the user clicks on this option the system displays the Cheque Status Inquiry Fast Path STO66 option Loan Enquiry If the user clicks on this option the system displays the Loans Balance Inquiry Fast Path 7026 option Click the Next Search button in the Selected Customer grid to start a new search To perform advance customer search 1 2 Click the Advance option in the Selected Customer grid You can enter the single search string or combination of search string as explained in the introduction The system displays the Advance Search screen 92 ORACLE Customer Search Search Advance Search Search Criteria Customer Id Account No National Id First Name s Last Name Short Name NLS ATM Card Number IBAN Refined Search Mobile Home Phone Date of Birth m JES Date Incorporated US Currency Find Reset Close Search Results 50 record s found SDBBASE1 1603956 SHEELA INDIVIDUAL 12 12 1960 123 5 603964 SAM INDIVIDUAL 12 12 1960 123333 Cer 28901 604209 SIGITA GASPARAVICIENE INDIVIDUAL 01 01 1965 3746041414 Ce
53. ce and reliable customer service It is a highly modular system that allows the bank to choose the set of functional modules to suit the line of operations of the bank Oracle FLEXCUBE is a multi currency system built on a powerful base of a flexible architecture It uses one of the most reliable and leading technology platforms Oracle FLEXCUBE is developed on Client Server distributed architecture which uses the Oracle or DB2 relational database and offers unlimited freedom to the bank to choose any leading UNIX or IBM or Windows NT Windows 2000 based hardware premium on line transaction processing system efficiently services the high volume retail transactions Oracle FLEXCUBE has capabilities on the NLS both at the database level and presentation level Oracle FLEXCUBE is already available in languages like English Japanese Portuguese and Arabic 3 ORACLE Starting Oracle FLEXCUBE 1 1 Starting Oracle FLEXCUBE You require the necessary rights and privileges to start the Oracle FLEXCUBE software To start Oracle FLEXCUBE e Click Start point to Programs and click Internet Explorer f Go e Type the Oracle FLEXCUBE URL in the Address bar and click For example the address may look like http server01 Flexcube e Oracle FLEXCUBE displays the screen as shown in the following figure ORACLE FLEXCUBE Click here to login ORACLE Oracle Flexcube Copyrights amp 2 Warning This softwar Unauthorised reproduction
54. ch as tax applicable SC charges etc are levied based on the customer type Display This column displays the date of birth of the customer Display This column displays the mobile number of the customer Display This column displays the home phone number of the customer Display This column displays the home branch of the customer The branch in which the customer account is opened Display This column displays the mailing address of the customer 3 Double click the record to view the account details for the selected customer 95 ORACLE Customer Search Search 605590 custor KK RAO INDIVIDUAL raph MALE 01 01 1970 Fhoto nce 17 998 968 70 FastPath la Customer Details s SELECTED CUSTOMER Customer Id 603965 First Name Signature Last Name First Teller 123 ABC COLABA Mumbai Iz Find Clear Advance ALL TRANSACTION X Transaction Processing los I Term Deposit t Loans IL Scheme Benefit Global Definitions 60000000037440 BS FIZINIAMS ASMENIMS LTL 1 Centrine bustineLTL 0 0 0 60000000462440 5 FIZINIAMS ASMENIMS LTL 1 Centrine bustineLTL 0 0 4 Doubleclick the record to view the list of Related Transaction Refer to the customer search procedure for more details explained above in this option 5 Click the Next Search button in the Selected Customer grid to start
55. code representing the inventory Stock Sub Type Display This field displays the sub type of the instrument Instrument Type Display This field displays the instrument type of the inventory Ccy Code Display This field displays the currency of the inventory This is defaulted from the transaction screen 69 ORACLE Common Screens Field Name Description Issuer Code Display This field displays the issuer code of the inventory This is defaulted from the transaction screen Total Amount Display This field displays the total amount for which the inventory is being purchased This is defaulted from the transaction screen Denomination Details Denm Display This field displays the denomination detail that is defaulted from the Stock Codes Maintenance Fast Path IVM01 option for the particular issuer and particular currency Series Number Mandatory Numeric 10 Type the series number of the inventory which is to be purchased Start Number Mandatory Numeric 10 Type the start number of the inventory belonging to the respective series number which is to be purchased End Number Display This field displays the end number that is calculated by the system depending upon the start number and quantity Quantity Display This field displays the quantity of the inventory which is purchased Click the Ok button to accept the inventory details as a part of the transaction Click the Cancel button to reject th
56. cts Clearing Account X Reference Inquiry Unchecked Instruments Inquiry Check Inward Clearing Instruments Payment Value Date Clearing ICC Data Entry OCC Batch Data Entry Cheque Collection Processing 149 ORACLE Appendix of Fast Path Fast Path Description 5522 Batch Micr SrinoXref Data Entry 8323 Maintained Issued Instruments BA990 Clearing Inquiry ST067 Collection Purchase Inquiry ST074 Remittance Inquiry STM57 MICR Number Maintenance STM71 Unmatched DHN Blacklist Customer Deletion 7120 Late Clearing Maintenance ST001 Value Date Clearing Process ST002 Value Date Clearing Inquiry STO23 Outward Clearing ST037 Reverse Authorized Batches STO60 Immediate Credit ST061 Float Extension 150 ORACLE Fast Path ST066 57072 STM62 STM63 1009 1025 1026 1409 5511 6575 7782 7783 8003 8004 Appendix of Fast Path Description Cheque Status Inquiry Global Float Extension Late Clearing Inquiry Late Clearing Marking Maintenance TC Sale Against Account Bill Payment Advance Payment against Credit Card TC Purchase Against Account Consolidated Remittance Data Entry Batch Bill Payment By Cheque Bankers Cheque Inquiry Demand Dratt Inquiry TC Purchase Walk in Customer FX Purchase Walk in 151 ORACLE Appendix of Fast Path Fast Path Description 8203 FX Sale Walk in 8204 TC Sale Walk in Customer 8205 TC Sale Against GL 8301 Banker s Cheque Sa
57. d Change Secondary Password Audit Trail Financial Transactions Inquiry Audit Trail Inquiry for Non Financial Txns BA Audit Tasks Maintenance Inquire 157 ORACLE Fast Path BAM10 SM11A SMMO02 SMMO03 SMMO09 SMM12 SMM13 Appendix of Fast Path Description Restricted Account Maintenance Inquiry On Logged In Users User Profile Maintenance Task Profile Maintenance User Prohibited Password Maintenance User Class Cross Reference Maintenance Template Transaction Limits Module Name Service Charge Fast Path SCM02 SCM03 SCM05 SCM06 Module Name Bills Description SC Package for Customer SC Package Changes at Account SC History for Account Inquiry SC Package Linkage to Code Task Fast Path Description 158 ORACLE Fast Path BIMO1 BIMO2 BIMOS 4 5 BI001 Appendix of Fast Path Description Drawee Risk Card Maintenance Court Master Maintenance Branch Court Cross Reference Maintenance Bill Parameters Maintenance Bills Processing Maintenance Bills Data Entry Module Name System Operations Fast Path BA093 BA094 5504 5531 8889 8890 Description Calendar Holiday Maintenance Calendar Propagation Maintenance Download Upload Status Inquiry Download Upload File Download Scheduler Maintenance Cluster Maintenance 159 ORACLE Fast Path 8891 8892 7239 7240 8893 BA450 BA452 BAM
58. d Authorize Inquiry For more information on the procedures of every mode refer to Standard Maintenance Procedures To add bank parameter 1 Type the fast path TDMO4 and click Go or navigate through the menus to Global Definitions gt TD gt TD Bank Parameters Maintenance 2 The system displays the TD Bank Parameters Maintenance screen TD Bank Parameters Maintenance Field Description 3 Click the Add button W General Ledger 4 Enter the bank code and press the lt Tab gt key N 5 Enter the GL details and the interest rate details 8 Oracle Flexcube Reports Disclaimer B Click the OK button 7 The system displays the message Record Added Authorization Pending Click the OK button lt gt B toc 8 The new bank parameter is added once the record is authorised Search E Glossary e To locate another topic navigate using the tree menu TOC provided on the left pane and click the topic name link OR Click the Search button on the menu bar and type the related word or fast path in the Search field Click the button The system displays the related topics 18 ORACLE Using Online Help To perform a search e Inthe Help window click the Search button e Enter the text you want to search in the text box located in the left pane and click the Search er button You can also enter the text in inverted commas if you want to match the exact search criteria The search string e
59. d in the Customer Information File User Manual e Management Information System e Reports 1 3 2 Common Facilities e Inventory Management Inventory definitions are explained in the Definitions User Manual Inventory maintenance s are explained in the Back Office User Manual 7 ORACLE Functional Overview e Fund Transfer Fund Transfer transactions are explained in the Current and Savings Account User Manual e Service Charges Service Charges definitions are explained in the Definitions User Manual Service Charges maintenance s are explained in the Back Office User Manual e NPA Management Asset Classification definitions are explained in the Definitions User Manual Asset Classification maintenance s are explained in the Back Office User Manual e Collateral Management Collateral definitions are explained in the Definitions User Manual Collateral maintenance s are explained in the Back Office User Manual e Collection Transactions This module is used to keep track of the follow up of delinquent accounts It maintains the records of the follow up made to the customer including details like actions taken result of the action next action expected to be taken etc 1 3 3 Consumer Lending Suite Retail Loan Accounts Loan definitions are explained in the Definitions User Manual Loan maintenance s are explained in the Loan User Manual 1 3 4 Deposit Accounts e Savings and Current Account CASA definitions are
60. dentification across the bank covering all branches Based on the combination the system can identify the customer as an existing customer even when the customer opens a new account in another branch A social security number passport number birth certificate or corporate registration can be used as a customer IG 94 ORACLE Field Name Customer ID Full Name Customer Type Date of Birth Mobile No Home Phone Home Branch Postal Address Customer Search Description Display This column displays the ID of the customer A customer ID is an identification number generated by the system after customer addition is completed successfully This running number unique to a customer across the system is generated after the system has identified the Customer IC and Customer Category combination to be non existent in the system This ID is used for searching and tracking the customer in the system Display This column displays the full name of the customer The full name of the customer is defaulted from the Customer Addition Fast Path 8053 option The search is based on the customer s full name For Example If the full name entered in the search criteria is George then Oracle FLEXCUBE will display all the customer s with the name as George along with all the other details Display This column displays the category of the customer For example Individual Corporate etc Further processing su
61. dix of Fast Path Description Incoming Pymt Auth Screen RTGS NEFT Beneficiary Master Maintenance Module Name Payments UBS Fast Path PCM04 PCM05 PCM07 PCM08 PCM09 PCM10 PCM12 PCM13 PCM25 PCM26 PCM33 Description PM PC Product Definition and Preferences PM Bank Directory Maintenance Product Date Cutoff Maintenance Reject code Maintenance Product Cutoff Maintenance Clearing Network Maintenance Network Calendar Maintenance Beneficiary Maintenance RTGS NEFT Payment Inquiry Screen RTGS NEFT Incoming Payment Repair RTGS NEFT Outgoing Payment Authorization 140 ORACLE Fast Path PCM34 PCM35 PCM40 PCM41 PCM42 2955 2956 2957 Appendix of Fast Path Description RTGS NEFT Outgoing Payment Release Screen RTGS NEFT Incoming Payment Authorization PC Incoming Message Browser PC Outgoing Message Browser PC Process Exception RTGS Outgoing Payment Initiation Customer RTGS Outgoing Payment Initiation Bank NEFT Outgoing Payment Initiation Module Name Safe Deposit Box Fast Path 1701 1720 8057 SB001 SB002 Description Rent Payment Inquiry SDB Close Out Balance Inquiry Safe Box Allotment Safe Box Usage Log Customer Waitlist 141 ORACLE Fast Path 5B003 SB004 Appendix of Fast Path Description Safe Box Usage And Payment Inquiry Account Closing Balance Information Module Name General L
62. dure is defined in the manual Use the Standard Maintenance Procedure section in this manual to get the broad contours of procedures to be adopted The first step of the procedure gives the modes to access the transaction screen The screen can be accessed in the following two ways e Fast Path Type the fast path in the search field in the tree menu of Oracle FLEXCUBE and click the Go button Refer to the Fast Path in the Understanding the Oracle FLEXCUBE User Interface option 23 ORACLE User Manual Structure e The tree menu access path Transaction Screen The transaction or maintenance screen which is displayed in the procedure The transaction screen is explained in the Central Workspace section in the Understanding the Oracle FLEXCUBE User Interface option Tab Screen In case the maintenance screen has more than one tab each of the tabs is defined separately The tab screens are the different sections of a transaction screen The tab screens are explained in the Understanding the Oracle FLEXCUBE User Interface option Field Description The explanation of the fields in the transaction and tab screens The explanation gives the following points e Mandatory Optional Conditional Whether the field is mandatory optional or based on some other field i e conditional e Field Type The type of the field For e g Numeric Alphanumeric Drop Down Pick List etc e Field Size The maximum characters that can be entered in t
63. e balance is displayed as the principal balance The principal balance is the original amount of the Term Deposit The amount will be displayed in the currency of the account In case of Loan account the balance is displayed as O S Balance The O S balance is the outstanding amount of the loan The amount will be displayed in the currency of the account Display This column displays the book balance of the account Display This column displays the uncleared amount for the account Display This column displays the future dated cash deposit amount Display This column displays the Display This column displays the blocking code Display This column displays the status of the account Display This column displays the classification status of the account Display This column displays the relation of the customer with the account 87 ORACLE Customer Search Column Name Description IBAN Display This column displays the IBAN number Account Open Date Display This column displays the date on which the account is opened Account Activation Display Date Relationship Date No of Months Since Account Activation Combined Total withdrawal Balance ACY Combined Total withdrawal Balance LCY Search Term Deposit This column displays the date on which the account is registered in the name of the account holder and debit transactions are allowed Display This column displays the dat
64. e concept of Service Based Architecture At the core of this architecture is a set of common services called the Core System All front end functional modules utilize the common services offered by the Core System Ease of Use Oracle FLEXCUBE offers a user friendly and intuitive graphical user interface The client end software is Windows based and browser front end Almost all operations except user data input are mouse based Flexibility to Incorporate Change The fundamental design objective of Oracle FLEXCUBE as its name suggests is to allow the tailoring of business to suit varied and dynamic market needs Oracle FLEXCUBE is an application designed to easily respond to these changes by setting or resetting various product or global parameters without requiring a change in the software or extensive redesigning in product profile Security The Security Management System SMS in Oracle FLEXCUBE is in line with industry standards The whole range of operations in Oracle FLEXCUBE is performed in virtually impregnable high security conditions Relationship Banking Oracle FLEXCUBE incorporates a sophisticated Customer Information System CIS that enables true relationship banking Detailed information personal demographic employment financial corporate etc about all customers is stored centrally in the CIS It can provide a relationship statement which is a combined statement for all the accounts related to the customer
65. e inventory details 70 ORACLE Common Screens 1 16 5 Cost Rate Details As part of the Branch Profitability requirements cost rates needs to be captured transaction and account currency wise for FX transactions Outgoing Payment Transaction Message SUG Account Ccy INF Acct Coy Rate T Acct Ccy Cost Rate Txn INR Txn Ccy Rate l 10 Txn Cost Rate Field Description Field Name Description Account Display Coy This field displays the currency assigned to the product at the product level under which the loan account is opened All the entries posted in the account are in the account currency The exchange rate values must be defined and downloaded For example if the currency assigned to a Loan product is USD US Dollar the account opened under that product has USD as its account currency by default 71 ORACLE Field Name Common Screens Description Acct Ccy Rate Acct Ccy Cost Rate Txn Ccy Txn Ccy Rate Txn Ccy Cost Rate Display This field displays the rate at which the account currency is converted to the local currency of the bank The teller s right to change the account currency rate is configurable at the bank level If such rights are not assigned to the teller this field becomes non editable If the account currency and the local currency are same the field takes the default value as 1 which cannot be modified Display
66. e on which customer s relation with account is registered or modified For example This will be the date on which the account is opened with ownership as SOW or the date on which customer is linked to an account with ownership of either JAF JAO or JOF JOO Display This column displays the number of months since the account is activated Display This field displays the combined balance for the given CASA account in account currency For more information refer to Calculation Details 2 at the end of this topic Display This field displays the combined balance for the given CASA account in local currency For more information refer to Calculation Details 2 at the end of this topic 0 Resident Products Head Office s UNBLOCKED ACCOUNT OPEN REGLLAR oW 08417094099993720000 30 01 2008 Field Description Column Name Description Account No Display This column displays the account number of the customer Product Name Display This column displays the product name Product Code Display This column displays the code of the product under which the customer has an account 88 ORACLE Column Name Home Branch Currency Original Bal Book Balance Blocking Code Account Status Account Rel IBAN Account Open Date Account Activation Date Relationship Date No of Months Since Account Activation TD Linkage Flag Customer Search Description Display This column di
67. e screen each of the record inside Oracle FLEXCUBE has some additional fields to be used internally by the system namely 1 Flg mnt status Maintenance Status Can be A for Flag Authorized or Null 2 Cod mnt action Maintenance Action Code Dat last mnt Last Maintenance Date Cod last mnt makerid Last Maker ID Cod last mnt chkerid Last Checker ID For example the standard procedures for the Bank Codes Maintenance option are as follows To add a bank code by copy 1 Select the Add mode Select the Add By Copy check box Type the existing bank code and press the lt Tab gt key The system displays the details of the bank code which is already maintained Modify the required fields and click the Ok button The system displays the message Record Added Authorisation Pending Click Ok to Continue gt 41 ORACLE Standard Maintenance Procedures To add a bank code 1 Select the Add mode Type the bank code and press the lt Tab gt key Enter the bank code integer and bank name and click the Ok button gt The system displays the message Record Added Authorisation Pending Click to Continue To modify the bank code 1 Select the Modify mode Type the bank code and press the lt Tab gt key or select it from the pick list Modify the relevant information and click the Ok button ARON The system displays the message Record Modified Authorisation Pending Click Ok to Continue T
68. edger Fast Path 1094 1321 6312 GLMO1 GLM02 GLMOS GLM04 GLM13 GLM17 GLM20 GLM35 Description GL To GL Funds Transfer Request Close Out Withdrawal by GL ODC Against GL Account Voucher Entry Chart of accounts MIS Class Maintenance GL Transactions and Movements Inquiry Period Code Maintenance GL Parameter Definition Enterprise GL Cross Reference Maintenance Implemented GL Cross Ref 142 ORACLE Fast Path GLM36 GLM37 GLM50 1005 1060 1460 1905 Appendix of Fast Path Description GL Posting Flag Maintenance GL Cost Centre XRef Maintenance Oracle GL Transactions Inquiry Miscellaneous GL Transfer Dr Cr GL Miscellaneous Debit Against Cash GL Miscellaneous Credit Against Cash Cross Cost Center Miscellaneous GL Transfer Dr Cr Module Name Relationship Pricing Fast Path CH067 CIM50 CIM51 CIM52 RLOO1 RL002 Description CASA Interest Inquiry Relationship Value Tag Definition Customer Group Definition Maintenance Customer Group Inquiry Applicable Customer Groups UDE Master Maintenance Rule Definition Master Maintenance 143 ORACLE Fast Path RLO10 RP001 RP002 RP003 RP004 RP010 RP011 RP015 Appendix of Fast Path Description Rule Debug Maintenance Scheme Definition Maintenance Eligibility Criteria Maintenance Benefit Plan Maintenance Interest Variance Package Maintenance Elig
69. endix of Fast Path Description Future Dated Cash Deposit RD Installment Payment by Cash Flexible RD Deposit by Cash OBU CASA Account Credit Cross Cost Center Miscellaneous Customer Credit Cheque Deposited on Savings Account Postdated Cheque Deposit Immediate Credit for Advance Cash Deposits Cheque Purchase Cash Withdrawal Miscellaneous Customer Debit CASA Cheque Withdrawal Cross Cost Center Miscellaneous Customer Debit OBU CASA Account Debit 121 ORACLE Fast Path 1055 CHM31 CHM32 CHM33 CHM39 CHM40 1010 1014 1080 1432 8318 BA030 CH077 CHMO09 Appendix of Fast Path Description Hold Funds Request Standing Instruction Maintenance Sweep Out Maintenance Hold Funds Maintenance Sweep In Maintenance Sweep in Sweep out Priority Maintenance Banker s Cheque Sale Against Account DD Sale Against Account Record Confirmation Transaction Flexible RD Redemption TT Sale Against Account Treasury Negotiation Worklist Confirmation Transaction Maintenance Ch JPA Account XRef Maintenance 122 ORACLE Fast Path CHM47 CHM48 CHM57 TDS13 7010 7013 7030 CH032 CHM34 CHM36 1006 1091 1092 1093 Appendix of Fast Path Description Account Cheque Purchase Limit Maintenance Account Level Variance Maintenance Bank Assurance Account Details Casa Tax Refund Passbook Update Passbook Balance Cheque Digit Inquiry
70. es can be defined as entity in Oracle FLEXCUBE It supports different local currency for each bank entity This also supports different local languages from same instance of application Oracle FLEXCUBE supports batch runs for multiple banks in parallel 6 ORACLE Functional Overview 1 3 Functional Overview Common Facilities 3rd Interfaces cev Tra ll A 7 Oracle FLEXCUBE seamlessly offers a complete range of functional modules for Retail Banking This section provides the list of all modules coming under the Oracle FLEXCUBE umbrella and the corresponding part of the user manual under which they are defined Transactions under each module could be broadly classified as definition transactions and operational maintenance transactions On a broad level maintenances have a non financial effect and the transactions result in a financial impact As the nature of users using these maintenance s and transactions are different they have been placed in different parts of the user manuals to aid in proper usage 1 3 1 Core Modules e Clearing Clearing definitions are explained in the Definitions User Manual Clearing maintenances are explained in the Settlement and Clearing User Manual e General Ledger GL Definitions are explained in the Definition User Manual e Customer Information System Customer Information definitions are explained in the Definitions User Manual Customer Information maintenance s are explaine
71. explained in the Definitions User Manual CASA maintenance s and transactions are explained in the Current and Savings Account User Manual e Recurring Deposits Accounts RD definitions are explained in the Definitions User Manual RD maintenance s and transactions are explained in the Current and Savings Account User Manual e Term Deposits and Certificate of Deposit Term Deposits definitions are explained in the Definitions User Manual Term Deposits maintenance s and transactions are explained in the Term Deposits User Manual 1 3 5 Application Security The application security maintenance s and transactions are explained in the Back Office User Manual 8 ORACLE Order Of Usage 1 4 Order Of Usage The order of usage of the user manuals is as follows ORDER OF USAGE Oracle FLEXCUBE Introduction v Definitions v BROP v Y Y Y Y CIF CASA TD Loans Collections CM Payments SDB GL RP Y Y Y Y Y Y Y Y Y Y Y STL amp CLG v Back Office Operations Bills User Manual is optional 9 ORACLE Software Requirements 1 5 Software Requirements Production Servers Database Server Retail Application Server Branch Server Client Workstations Retail Report Server Software AIX 5 3 Oracle 10g Enterprise Edition 10 1 0 4 SQL Plus AIX 5 3 OR Windows 2003 Enterprise Server Oracle Client 10G 10 1 0 Oracle 10G Application Server Release 3 OR WebSphere Application Se
72. g a transaction the system displays various authorisation reasons depending on certain conditions For example Account is dormant Hold funds present Premature Redemption of Term Deposit etc Refer the Authorisation Reason screen 58 ORACLE Common Screens 1 16 Common Screens This topic includes the details of the following screens available in Oracle FLEXCUBE Service Charges Details Instrument Details Cheque Details Inventory Details Cost Rate Details User Defined Fields Negotiate Document Receipt IFSC Lookup Handle FCY Common Screen refers to those screens which could find an appearance in most of the transactions having a financial impact For all those transactions that require input or modification of default Service Charges or Inventory details or Cheque Details or Traveler s Cheque the screen mentioned shall be used The service charge inventory details and cheque details screens are invoked when the respective tabs on the transaction screen is clicked The display of these respective tabs is dependant upon the setup For example in the following figure the Service Charge Details tab is enabled The Service Charges transaction definition option can be attached to options like Cash Deposit Fast Path 1401 GL Miscellaneous Debit against Cash Fast Path 1060 etc 59 ORACLE Bank Code Chq Ccy Cheque Ccy Rate Cheque Amount Charges Lcy Total Amount BC Date Micr No Bebeficiary
73. he User ID and details of the transaction initiator as a user cannot be the maker and checker for the same transaction A user can be an initiator of a transaction as well as an authorizer for same transaction type but will not have the right to authorize transaction initiated by him Only an initiator can change the authorizer for a transaction if the request for authorization is unanswered The remote authorisation process is divided into three stages Teller Activities 1 Enter the relevant information in the transaction screen and click the Ok button 2 The system displays the Authorization required message box 47 ORACLE Authorisation Procedures Microsoft Internet Explorer 2 A Authorization Required Do you want to continue 3 Click the OK button 4 The system displays the Authorization Reason screen Oracle Flexcube Authorizati x Dual control C Local Remote First Previous fi jag 1 2 3 4 5 Mext Last 59 4564 N SANAND ANAND SUP ID N TANAND ANAND VIEW ID N TYINAYSO BROP 50 N Cancel Select the Remote option Select the authoriser ID to whom the transaction is to be sent for authorisation from the User Id column drop down list 7 The system displays the message Transaction sent for Authorization Click the Ok button Supervisor Activities The authoriser can view only those transactions which are sent to him her for authorization 1 Type the fast path 6006 and click Go or navigate
74. he field This is applicable for numeric and alphanumeric fields only e General Description It explains the function of the field Mandatory Optional Conditional Field Type Reds General Description Field Description Field Name Address Mandatory Alphanumeric 35 Typethe mailing address of the customer The address can be mentioned in three lines City Mandatory Pick List Select the name of the city where the customer s mails should be sent from the pick list State Mandatory Pick List Select the name of the state where the customer s mails should be sent from the pick list Country Mandatory Drop Down Select the name of the country where the customer s mails should be sent from the drop down list 24 ORACLE Understanding the Oracle FLEXCUBE User Interface 1 12 Understanding the Oracle FLEXCUBE User Interface The Oracle FLEXCUBE is designed for extreme ease of use taking advantage of the browser based User Interface To navigate in Oracle FLEXCUBE proper understanding of the interface is essential This section illustrates the various parts of the Oracle FLEXCUBE interface and their uses There are two types of user interface e Conventional User Interface e Front Banking Executive User Interface The user interface which is displayed at the time of login is configured during the template level settings After the user has logged into the system and selected a transaction from the menu or
75. his enables modification of an authorized record in the table System would allow modification of non key fields Key fields cannot be modified or altered When a record is modified system will make another copy of the record in the table The changes done on the record would reside in the Unauthorized record with the same key Hence till the time of authorization the table would contain 2 rows for the same key field namely Authorized record and Unauthorized record When the authorizer authorizes the changes the system would delete the Authorized record from the table and replace the same with the Unauthorized record and change the status to Authorized To delete the bank code 1 Select the Delete mode Type the bank code and press the lt Tab gt key or select it from the pick list Click the Ok button The system displays the message Record Deleted Authorisation Pending Click Ok to Continue ARON This enables physical deletion of an authorized record in the table When a record is marked for deletion system will make another copy of the record in the table The changes done on the record would reside in the Unauthorized record with the same key Hence till the time of authorization the table would contain 2 rows for the same key field namely Authorized record and Unauthorized record When the authorizer authorizes the deletion the system would delete the Authorized and
76. ibility Scheme Linkage Customer Scheme Linkage Eligibility Debug Maintenance Module Name Branch Operations Fast Path 6006 6010 7008 7012 7015 Description Search Electronic Journal View Teller Errors Last Ten Transactions Account No Check Digit Inquiry Teller Transactions Summary 144 ORACLE Fast Path 7017 7040 7041 7050 7122 BAM95 6001 6002 6005 6009 9888 6201 6203 7551 Description Batch Status Inquiry Teller Totals Position Branch Totals Position Old to New Account Inquiry Cross Rate Inquiry Branch Batch Status Inquiry Batch Open Branch Batch Close Branch Batch Confirm Force Close Branch Batch Setting Initial Cash Cash Balancing TC Balancing Book Shortage 145 Appendix of Fast Path ORACLE Appendix of Fast Path Fast Path Description 7552 Book Cash Overage 9001 Open Teller Batch 9005 Close Teller Batch 9007 Buy Cash from Vault 9008 Sell Cash to Vault 9003 Open Vault Batch 9006 Close Vault Batch 9009 Buying Cash from Central Bank 9010 Sell Cash to Central Bank 5514 Change Data Entry Batch User 5515 List Batch Status 9800 Print Spooled Documents BA995 Single Account Transfer BA999 Bulk Account Transfer 146 ORACLE Fast Path 7175 7778 7779 7780 7781 BAM16 6202 8007 IV003 4501 BA123 TILO2 9012 9013 Appendix of Fast Path Description Report Request Ad
77. ield Description 3 Click the Add button 4 Enterthe signature code and the type of the signature 5 Click the Ok button B The system displays the message Record Authorized Click Ok to Continue Click the Ok button B Toc Search E Glossary 19 ORACLE Using Online Help Use of other tools available on the help header Back Click the button to return to the last help page you viewed Forward Click the PP button to view the help option which you were initially working on Refresh Click the button to refresh the current page which you are using Expand All Click the button to expand all the data added in drop down hot spots Collapse All Click the E button to close all the data added in drop down hot spots Glossary In the Help window click the Glossary button This will display the list of glossary available in the help 20 ORACLE Structure of User Manual Documentation Set 1 10 Structure of User Manual Documentation Set The user manual is divided into the following sub sections namely Description Oracle FLEXCUBE Introduction r Data Administrator Customer Information File Customer Service Personnel Current and Savings Account Time Deposit Liabilities Servicing Personnel E Collections Credit Personnel Liabilities Servicing personnel Retail Credit Personnel Card Management Branch Managers Tellers BackOffice Operations ATM and CARDS team 21 Understand u
78. intenance Calendar For Endpoint Endpoint Float Maintenance End Point Master Maintenance Composite Calendar Generation Sector Master PDC Discounting Parameters Maintenance Clearing Branch Cross Reference Routing Branch Maintenance Clearing Minimum Maintenance T ORACLE Fast Path STM56 STM58 STM60 STM64 STM70 STM97 BAM37 BAM39 BAM63 BAM74 BAM84 CLNOO CLNO1 CLNO2 Appendix of Fast Path Description Site Reject Code Xref Instrument Type Xref ACH Branch Cross Reference Maintenance Clearing Type Maintenance Routing Number Details Correspondence Bank Master Maintenance Collateral Codes Details Collateral Codes Maintenance Product Collateral Linkage Collateral Header Maintenance Financial Security Maintenance Workflow Master Collector Group Master Collector Master 100 ORACLE Appendix of Fast Path Fast Path Description CLN03 Supervisor Allocation CLN04 Queue Definition CLN05 Queue Allocation CLN06 Action Result Setup CLN07 Next Action Setup CLN08 Action Allocation CLN09 Filter Definition CLN10 Special Code Setup CLN11 Promise Setup CLN13 Result Workflow Master CLN18 Action Workflow State Master CLN19 Warehouse Setup XF001 Collection Parameters Maintenance BA091 Currency Rate Maintenance m ORACLE Fast Path BAM25 BAM26 BAM31 BAM32 BAM34 BAM48 BAM56 BAM65 CH099 BAM90 BA438 CIMO1 CIMO2 C
79. ion BAIB2 IB Bill Company Details Maintenance BAIB3 IB Customer Application Billing Information Maintenance 154 ORACLE Appendix of Fast Path Fast Path Description BAIB4 IB Bank Params Maintenance BAIB5 IB Block Transfer Across Products BAIB6 IB Transaction Customer Relationship Cross Reference Module Name POS Fast Path Description POSO1 POS Acquirer POS ID Maintenance POSO02 POS Bank Params Maintenance Module Name IVR Fast Path Description TBSO1 TBS Bank Params Maintenance TBS02 TBS Acquirer POS ID Maintenance TBS03 IVR TIN Request Module Name Inventory Fast Path Description 9019 Transfer Stocks 155 ORACLE Appendix of Fast Path Fast Path Description IV001 Stock Transaction IV002 Stock Adjustment IV011 Stock Inquiries IV005 Inventory PIN Maintenance IV012 Sell of inventory IVM10 Multi Currency Package Stock Code Cross Reference IV004 Inventory Lost report Register maintenance MCA80 Inquiry of sold issued inventory 156 ORACLE Appendix of Fast Path Module Name Security Management System SMS Fast Path 7011 752 753 755 756 757 758 766 767 768 769 AT002 BA777 BAM04 Description Event Log Inquiry Reset Primary Password Enable Disable Users Modify Login Status User Prohibited Password Inquiry for Logged in Users Inquiry for Password Secondary Password Expiry Date Reset Secondary Password Change Primary Passwor
80. is the file extract given out from FLEXCUBE to other software IBAN International Bank Account Number It is a unique account number that is used to identify a customer s account in a financial institution internationally ICP Interest Compensation Pooling Requirement IDC Inward Direct Credit IDD Inward Direct Debit IFSC Indian Financial System Code IOA Interest On Arrears IOI Interest Only Installment IPI Interest and Principal Installment IRR Internal Rate of Return ISB Inter System Bridge General Ledger JAF Joint and First 163 ORACLE Glossary JAO Joint and Other JFAB Joint Finance Asset Buy JOF Joint Or First JOO Joint or Other LLP Loan Loss Provisioning LO Local Office LOB Line of Business LTS Loan Transaction Services Mudharabah A Syariah banking product type using profit sharing concept NACHA National Automated Clearing House Association The Electronic Payments Association A non profit trade association which forms the cooperative foundation for the ACH network system through a network of Regional Payments NEACH New England Automated Clearing House NEFT National Electronic Funds Transfer Nisbah Bonus Profit sharing portion Nisbah for Mudharabah Product Bonus for Wadiah product NLS National Language Support Notional Pooling This is the facility to group customer s accounts for a Liquidity Management b Passing the transactions using
81. ld card search is supported for the search based on Customer short name Customer first name customer last name and national Id Customer IC For Example Search by date of birth date incorporated If the user enters the DOB date incorporated as 01 01 1965 DD MM YYYY and it is entered along with the advance search criteria of first name as George then Oracle FLEXCUBE will fetch all the records where the registration date or the date of birth of a customer is 01 01 1965 and the first name is George The search result will be as follows Custo Custome First Custom DOB Regi ATMcard Postal mer r ID Name er Type stration number Address IC date 8159 600918 George Individu 01 01 196 44793705 28 Billstreet N al 5 21504778 ew York 1253 315789 George Corpora 01 01 196 61763528 25 Billstreet te 5 45789887 New York 4789 678215 George Corpora 01 01 196 50791248 18 Hamilton te 5 32594578 street New York 83 ORACLE Customer Search Definition Prerequisites e 8053 Customer Addition To perform customer search 1 Type the user name and password to login 2 The system displays the Oracle FLEXCUBE screen Oracle FLEXCUBE Fast Path Go Customer Memo Photo Signature gt Global Definitions No Records Found gt Transaction Processing 3 Enter the search string in the Selected Customer grid and click the Find button The system display
82. le Against Cash 8302 Banker s Cheque Sale Against GL 8305 DD Sale Against Cash 8306 DD Sale Against GL 8307 BC Liquidation Inquiry 8310 DD Liquidation Inquiry 8314 BC Status Inquiry 8315 DD Status Inquiry 8316 TT Issue Walkin 8317 TT Issue GL 8319 TT Liquidation Inquiry 152 ORACLE Fast Path 8322 8324 8325 5525 EC004 8326 Appendix of Fast Path Description TT Lost Status Inquiry BC Status Inquiry DD Revalidate Remittance Printing Scanning of ECS Passed Rejected Records Unclaimed BC DD Status Inquiry Module Name FLEXCUBE Core Banking Non Performing Assets Management Fast Path ACO001 AC002 AC003 AC004 ACM07 AC008 Description Account Classification Preferences CRR Inquiry Account Provision Account WriteOff Provisioning Parameters at Bank level for Loans and Overdrafts Provision Inquiry and Modification for Loans and Overdraft Module Name Collaterals 153 ORACLE Appendix of Fast Path Fast Path Description BA433 Collateral To Accounts Inquiry BA434 Account To Collateral Inquiry BAM46 Collateral Propagation BAM47 Application Collateral Delink Module Name ATM Fast Path Description ATMO1 ATM Bank Params Maintenance ATMO2 ATM Acquirer POS ID Maintenance BA092 Auto Relock Time Maintenance ATMOS ATM Cash Replenishment from Branch Vault 4 Cash Replenishment by Third Party Module Name Channel Fast Path Descript
83. me key field namely Authorized record and Unauthorized record When the authorizer authorizes the changes the system would delete the Authorized record from the table and replace the same with the Unauthorized record and change the status to Authorized To authorize the bank code 1 Select the Authorize mode 2 Type the bank code and press the lt Tab gt key or select it from the pick list 3 Click the Ok button 4 The system displays the message Record Authorized Click Ok to Continue Authorize action is done to accept the action add modify delete or amend done on a record When a record is authorized system will delete the existing Authorized row and change the status of the Unauthorized record to Authorized To view the bank code 1 Select the Inquiry mode 2 Type the bank code and press the Tab key or select it from the pick list 3 The system displays the bank code details 43 ORACLE Standard Transaction Procedures 1 14 Standard Transaction Procedures The procedure for the transactions in Oracle FLEXCUBE is explained below The key fields for the respective transaction screen have to be entered For example the standard procedure for the Cash Deposit is as follows To deposit cash in CASA account 1 2 Ox Dr eo Type the account number and press the lt Tab gt key Select the Txn Ccy from the drop down list and type the Txn Amount and click the Ok button
84. ment It is the premature liquidation of the loan account by paying lumpsum amount to clear all the liabilities EFS Early and Final Settlement Endpoint The clearing house is called the Endpoint 162 ORACLE Glossary EOP End of Period EPI Equated Periodic Installment Escheatment It is the law that requires banks to submit the monies funds from bank accounts that are considered unclaimed abandoned property no customer initiated transactions unless the owner acknowledges the existence of the account The monies funds must be sent to the appropriate state according to that states unclaimed abandon property law FCC PE Flexcube Corporate Payment Engine Final Settlement It is the liquidation of the loan account on or after maturity date by paying the final installment due Float days Float is the number of days after which credit is given The Bank s Float is the number of days after which credit is given to the bank by the clearing house The Customer s Float is the number of days after which the Bank gives credit to the customers Floor and Ceiling Rates The minimum and maximum interest rates allowed for accounts under the product can be set for fixed and floating interest rates Whenever interest index rate changes beyond this range the changes are not given effect GEFU Generic External File Upload Hand off It
85. multi tiered sweep 2 Accounts will be grouped together to form a sweep in sweep out hierarchy thus sweep out instructions will be maintained for the account in layers with hierarchy specified 3 When funds are insufficient in the sub accounts funds will be provided by sweep in from the lead account to sub account as long as the balance is available in the Lead provider account 4 Excess funds will be swept from sub account to lead account at EOD Catch up interest accrual This represents accrual of interest from last interest accrual date to the processing date excluding the current date Category FLEXCUBE for core banking divides the batch processing into multiple categories Each category internally contains one or more Shells Category is an internal grouping of shells There are 3 main categories which are executed for any bank These are Cut off changes the system date End of day EOD amp BOD Beginning of day CBR Central Bank Reporting 161 ORACLE Glossary CCD Central Clearing Division CDS Cash Dispenser System Clearing Branch The branch which does the centralized clearing Clearing Minimum The maintenance of a minimum clearing amount for each type of instrument in each currency deposit of an instrument for an amount less than the specified amount will be given immediate credit Concentration account Provider Account This account is the S
86. n Themes Click this link to select the available colour for screen layout Change Password Click this link to change the password For more information please refer to Change Primary Password Fast Path 768 option in Back Office User Manual Help Click this link to view Oracle FLEXCUBE Online Help About Click this link to view Oracle FLEXCUBE version details Logout Click this link to log out from Oracle FLEXCUBE Product Logo The logo rotates in the right hand side of the transaction screen if the connection of the branch with the host is up Customer Search This section is used for basic customer search For more details refer to the Customer Search option in the Oracle FLEXCUBE Introduction User Manual Cash Summary This section displays the cash summary for a teller The details include the cash currency code the current cash status and the over limit and under limit for the cash balance Cash summary will get refreshed after every financial transaction performed by the teller Fast Path Fast Path is a facility provided in Oracle FLEXCUBE to navigate to a particular option using an alphanumeric hotkey Each maintenance or transaction is allotted a unique hotkey using which the user can invoke the same without going through the menu structure thereby enabling quick access to the transaction Tree Menu All the options in Oracle FLEXCUBE are arranged module wise and in a hierarchical form You can navigate to the
87. n 28913 604231 SIGITA GASPARAVICIENE INDIVIDUAL 01 01 1965 3746041414 Aly 28914 604232 SIGITA GASPARAVICIENE INDIVIDUAL 01 01 1965 3746041414 Alyl 28915 604234 SIGITA GASPARAVICIENE INDIVIDUAL 01 01 1965 3746041414 Alyl 28916 604235 SIGITA GASPARAVICIENE INDIVIDUAL 01 01 1965 3746041414 All 29001 604300 SIGITA GASPARAVICIENE INDIVIDUAL 01 01 1965 3746041414 Cer 29013 604311 SIGITA GASPARAVICIENE INDIVIDUAL 01 01 1965 3746041414 Alyl 29014 604313 SIGITA GASPARAVICIENE INDIVIDUAL 01 01 1965 3746041414 Alyl 4 1 js 2 3 4 s Field Description Field Name Description User can enter any of the following search criteria mentioned below Customer Id Account No National Id First Name Last Name Short Name Optional Numeric 10 Type the customer ID in this field A customer ID is an identification number generated by the system after customer addition is completed successfully This running number unique to a customer across the system is generated after the system has identified the Customer IC and Customer Category combination to be non existent in the system This ID is used for searching and tracking the customer in the system Optional Numeric 16 Type the account number of the customer Optional Alphanumeric 30 Type the national ID of the customer Optional Alphanumeric 40 Type the first name of the customer Optional Alphanumeric 40 Type the last name of the customer Option
88. nce Safe Box Product Inventory Cross Reference Channel Limit Maintenance Bank Customer Limit Maintenance Bank Limit Setup Customer Limit Setup Multi limit Plan Setup ORACLE Fast Path LMRO1 LMS01 LMS02 LMS03 LMS04 LMS05 LMS07 LMS08 LMS09 LNM11 BA655 BAM44 LNM18 LNM22 Appendix of Fast Path Description Credit Concentration And Exposure Limits Maintenance Limit Inquiry Bank Network Maintenance Limit Manual Transfer Limit Transfer Rule Multi limit Plan Setup Casa Loan Account Exemptions Customer Regulatory Information Loan Convertability Option Product Master Maintenance Calendar For Loan Rescission TD Maturity Reminder Plan Maintenance Loan Bank Parameters Maintenance Loan Plan Deduction Maintenance 185 ORACLE Fast Path LNM90 ORS25 ORS35 ORS41 BA090 BA089 BA316 BA317 BA318 BA431 BA435 BA436 BAM02 Appendix of Fast Path Description Loan Commitment Fee Plan Maintenance Producer Setup Document Plan Code Maintenance Document Code Maintenance Bank Calendar Maintenance Corporate Calendar Maintenance Village Master Centre Master Group Code Master LOB Master Branch Product Cross Reference Line of Business LOB Branch Cross Reference Local Office Master Maintenance Branch Master Maintenance 188 ORACLE Fast Path BAMO7 BAM08 BAM17 BAM20 BAM35 BAM60 BAM
89. nsaction being executed General Information For most of the transactions there are certain fields which are common Some of these fields are key to access the relevant record The display of other information in the respective fields depends upon the unique value entered in the key field For example Account Number Customer Name etc For most transactions the user has to specify the Account Number and the details associated with that Account Number are displayed Tab Screen Certain transactions are made up of a number of sub sections The tab screens are these separate sub sections Depending on the nature of the transaction the user selects the appropriate tab screen and enters the details required in that tab screen or the system automatically displays the subsequent tab screen depending on the sequence of the transaction 34 ORACLE Understanding the Oracle FLEXCUBE User Interface Transaction Information This section may or may not be found in all transactions The specific details to be entered or displayed for a particular transaction are displayed in this section of the Central Workspace Record Details This contains the audit related information of the record in focus This part contains the following fields Field Description Input By The ID of the user who has added the record Authorised By The ID of the user who has authorised the record Last Mnt Date The addition or maintenance of the record was done on this
90. nt before the same becomes due The amount paid is less than the total amount of principal outstanding Product Expiry Date It is the date beyond which no new accounts can be opened under a given product PSS Profit Sharing System RDFI Receiving Depository Financial Institution The financial institution where the receiver of an ACH entry holds an account Receiver ACH context The individual or Company that holds an account at RDFI i e an individual organization or other entity that has authorized an originator to initiate a credit or debit entry to a transaction account held at RDFI Reminder Plan It is a plan for generating reminders to be sent to customers when arrears are not paid A reminder plan can be linked to one or more products Repayment Appropriation SPLOIC stands for S Service Charge arrear P Penalty Sequence SPLOIC arrears L Legal fees O Outgoing type of arrear Interest Arrears C Principal arrears Routing Number It is the number printed on the cheque also called MICR number Magnetic Ink Character Recognition This number facilitates faster clearance of the instrument It can be configured to have the following information Bank code Sector Branch Code RPA Repayment Pending Appropriation advance payment 165 ORACLE Glossary RTGS Real Time Gross Settlement RVT Relationship Value Tagging Schedule The repayment plan for an accoun
91. ntenance s and operational transactions To get Help e Click the Help link on the header or press lt F1 gt or click button from transaction or maintenance inside Oracle FLEXCUBE to view the Oracle FLEXCUBE Help Depending on the option you are currently working the online help will display the relevant topic on the right panel This online help will be opened in a separate window TOC Qbear 4 ORACLE FLEXCUBE Aversion Number oracle FLEXCUBE Introduction Definitions Bl Master Definitions Bl Currency Definitions M Securities Definitions E Customer Definitions B CASA Definitions QATO Definitions 7j TDM04 TD Bank Param 5 TDMO1 TD Product Mas 55 TD060 TD Product Rate Bl Tax Definitions BIRD Definitions BlLoan Definitions interest Rate Rule Definitior Bl Limit Management M Collateral Definitions insurance Definitions Basset Classification Defini Clearing Definitions M inventory Definitions H Remittance Definitions Service Charge Definitions Central Bank Reporting Defi M User Defined Fields other Definitions M Current and Savings Account IB Time Deposit Loans Settlement and Clearing Bl customer Information File B Relationship Pricing Blaack Branch Operations TDM04 TD Bank Parameters Maintenance The two important entities that are defined in TD Bank Parameters Maintenance are Suspense General Ledgers General Ledger entrie
92. ntered in the inverted commas is not case sensitive For example Account number the system displays the related topics e List of topics that contain part or whole search criteria are displayed Click the relevant topic name e The selected topic is displayed in the right pane with the search criteria highlighted e Click the x button to remove the highlight e To search for a word in the selected topic enter the text in the Search box and click the ps button The required text is highlighted and displayed in the right pane Search CESAR p ORACLE pm Signature Types Maintenance Rank Title The user can maintain the signature type for individual customers using the Signature Types Maintenance option Authorized records from this maintenance will populate the 1 EU e pick list in the Customer Addition Fast Path 8053 option CIM09 Customer Note The system automatically authorizes this transaction 2 Information Master Maintenance ich s le Guster Definition Prerequisites Addition Not Applicable 4 Appendix of Fast Path Modes Available Add Modify Delete Inquiry For more information on the procedures of every mode refer to Standard Maintenance Procedures To add the signature type 1 Type the fast path CIMOT and click Go or navigate through the menus to Global Definitions gt Customer gt Signature Types Maintenance 2 The system displays the Signature Types Maintenance screen Signature Types Maintenance LJ F
93. o column whose state is Auth Granted 6 The system displays the relevant screen 57 ORACLE Authorisation Procedures Cash Deposit Account No 60000001756440 agros Account Coy Txn Cey LTL Account Cey Rate 1 00000 Txn Ccy Rate 1 00000 Customer Customer Category Customer Status Bank Notes 100000 Litas Coins 0 Centas Coins 0 Total Amount Account Amount 1 0 Txn Amount ee Value Date User Reference No Narrative Cash Deposit ome ae T s Service Charge ignature Travellers Chequ 7 Click the Submit button to post the transaction The system displays the transaction sequence number Click the Ok button 10 The system displays the documents screen 1 15 4 Deferred Authorisation Deferred authorisation is used for maintenance transactions The transaction will be allowed to be authorized by a user of same level or a higher level belonging to the same class based on the Parallel Authorization parameter value A User can be initiator of a transaction as well as an authorizer for same transaction type but will not have the right to authorize transaction initiated by him her Any checker will be able to see unauthorized maintenance transactions requiring deferred authorization in authorize mode For more information refer to Standard Maintenance Procedures in the Oracle FLEXCUBE Introduction User Manual Note While authorisin
94. omer Tax Codes Maintenance 111 ORACLE Fast Path TDS06 TD060 TDMO1 TDM04 UDFO1 UDF02 BAM88 TDS04 TDS07 STM73 STM74 STM75 STM98 STM20 Appendix of Fast Path Description Tax Parameters Maintenance TD Product Rate Maintenance TD Product Master TD Bank Parameters Maintenance User Defined Fields UDF Task Code Linkage Branch Attribute Maintenance Tax Waiver Criteria Maintenance Tax Acknowledgement Details Maintenance Return Cutoff Maintenance Restricted Clearing Types Maintenance Scan Reject Pass Disable Maintenance IC OC Clearing Type Cross Reference Local Bank Codes Maintenance 112 ORACLE Appendix of Fast Path Fast Path Description EC005 ECS Cutoff Marking Maintenance ECMO1 ECS Company Details Maintenance ECMOS3 ECS Central Bank Reject Code Xref PM038 Payment Window Period Modification PM039 Payment Transaction Attributes PROO1 Tier Look up Definition PR002 Rate Chart Maintenance PR003 Rate Chart Validity Maintenance PR004 Margin Codes Setup PR005 Discount Rate setup PR006 Evaluation Parameter Setup PR007 Evaluation Rule Maintenance PR008 Preferential Rate Chart PR009 Pricing Lookup Maintenance 113 ORACLE Fast Path PRO10 LNM51 BA121 SMM21 MCAO1 BAM19 MCA10 MC021 BA124 BA125 BA126 CHM86 CHM65 CHM25 Appendix of Fast Path Description Subsidy Margin Codes Setup Loan Product CASA Product Xref for Offset
95. orization to a different supervisor if required For supervisor it will display a hyperlink with count of transactions pending for authorization Click the link system displays the Search Electronic Journal Fast Path 6006 option with the list of transactions pending for authorization Now the supervisor can perform further operations on the listed transactions 32 ORACLE Understanding the Oracle FLEXCUBE User Interface Customer Id First Name Last Name SAC ON Transactions Pending 1 33 ORACLE Understanding the Oracle FLEXCUBE User Interface Central Workspace This is the operational area where the contents of every transaction or maintenance are displayed The following figure provides a detailed explanation of various elements that constitute the Central Workspace Screen Name External System Code ADORCHANGE Address Change File Type adrFileDefn General Information Processor Format EXTRACT v Close Help rameters Gefu Setup GL setup Call Timing Output Template Deferred Auth Requred v Tab Screen Relative Path XFF File Output File Helper Class Output Folder Helper Class ap ext resp acct opel Record Details Input By Authorized By Last Mnt Date Last Mnt Action Authorized TAJAY sasay 16 07 2007 00 00 00 Authorize Record Details Modes Available Screen Name This is the name of the tra
96. pe Mandatory Drop Down Select the instrument sub type from the drop down list The values in the drop down are defaulted from the Site Instrument Type field maintained in the Instrument Type Xref Fast Path STM58 option Click the Ok button to apply the new or modified service charges to the transaction Click the Cancel button to reject the instrument details 67 ORACLE Common Screens 1 16 3 Cheque Details OBU CASA Funds Transfer Request amp E Cheque Cheque No 988766566 Cheque Date 10 4 2008 Field Description Field Name Description Cheque No Mandatory Numeric 12 Type the cheque number issued on the From Account System will validate the cheque to confirm if it has been issued on the From account and is in unpaid status Cheque Date Mandatory dd mm yyyy Type the date of the cheque The system will default to the branch date If the date is modified the same should be less than the branch date Click the Ok button to accept the cheque details as a part of the transaction Click the Cancel button to reject the cheque details 68 ORACLE Common Screens 1 16 4 Inventory Details Inventory Details Stock Code T w Stock SubType Standard v Instrument Type Ccy Code Issuer Code STATE BANK OF INDI Total Amount Denomination Details Field Description Field Name Description Stock Code Display This field displays the stock
97. quiry Time Deposit Account Opening under MCA Module Name Loans Fast Path 1413 LN045 Description Loans Disbursement Inquiry Loan Disbursement Reversal 130 ORACLE Fast Path LN521 LNM44 LN046 LN057 LNO65 LNO89 LN090 LN101 LNM32 LNM33 LNM34 LNM35 LNM38 LNM39 Appendix of Fast Path Description Account Schedule Disbursement Schedule Post Dated Cheques Maintenance Loan Direct Account Opening Loan Product Promotional Interest Rates Loan Account Repricing Revision Loan Account Commitment Schedule Details Maintenance Loans Account Status Change Additional Document Maintenance Loan Account Address Maintenance Loan Collateral Link Maintenance Loan Account Master Attributes Maintenance Loan Approved Amount Maintenance Loan Account Application Details Maintenance m ORACLE Fast Path LNM83 LNM99 1067 1069 1412 AC005 LNM37 7026 INO20 LN022 LNO23 LN500 LN501 LN502 Appendix of Fast Path Description Account Rates Loan Account CBR Details Loan Full Payoff Inquiry Loan Recission Inquiry Loan Refund Inquiry Automatic Write off Account Maintenance Loan Account Payoff Notice Maintenance Loan Balance Inquiry Insurance Premium Inquiry Interest Calculation Inquiry Amortization Inquiry Installment Calculator Loan Funds Flow Calculator Loans Event Simulation Maintenance 132 ORACLE Fas
98. r Deposit Loans seme Benet 1 ODTOD CSINT CASA 47 TEST 1 30 11 2007 30 11 2009 INPRGRS ODTOD CSINT CF40 10 CLAWBACK AUTO PROVISION 30 11 2007 30 11 2009 INPRGRS Field Description Column Name Description Scheme Name Display This column displays the scheme name Benefit Type Display This column displays the type of the benefit scheme Product Name Display This column displays the product name Start Date Display This column displays the date from which the scheme was applied to the account End Date Display This column displays the date till which the scheme will applied to the account Status Display This column displays the status of the scheme Variance Rate Display This column displays the variance rate Int Type Display This column displays the interest type 4 Double click the record to view the list of Related Transaction Related Transaction If the user double clicks on the CASA account number the system displays the following pop up e Client Profile If the user clicks on this option the system displays the Customer Information Master Maintenance Fast Path CIM09 option e Statement If the user clicks on this option the system displays the Statement Inquiry Fast Path CH031 option e Account Profile If the user clicks on this option the system displays the Account Master Maintenance Fast Path CH021 option e Commissions Etc If
99. rious GL accounts Relationship Managers Customer Support Officers Branch Managers Tellers Clearing and Remittance Security Administrators BackOffice Operations Branch Tellers who are responsible for operations on branch server Data Centre Operations Personnel 22 to be used in various modules track their movement do periodic reconciliation etc Provide pricing at the customer level Perform branch operations vault operations teller operations various inquiry transactions and adhoc report generation Perform clearing operations transaction posting remittance instruments operations and bill payments Define SMS entities and operations perform GL operations collateral definitions and linkage manage inventory SC linkage maintenance Download service maintenance and operations Asset classification amp operations file upload operations Define bills and their operations courts and their linkage to various branches Branch Server operations and Data centre operations ORACLE User Manual Structure 1 11 User Manual Structure The user manual covers all the aspects of Oracle FLEXCUBE The structure of the user manual is as follows CIMA Corporate Customer Details Option Name 1 4 CIM17 Corporate Customer Details Field Descripton The Corporate Customer Details option r corporate customers such as Ine history business eformaton and sharehoden nformaton manda
100. rver 5 1 IBM MQ Server 6 Windows 2003 Enterprise Server Crystal Reports Professional Version 10 Oracle Client 10G 10 1 0 IIS 6 0 Microsoft SOAP Toolkit 2 0 MS XML 4 0 IBM MQ Client 6 Windows XP Professional SP1 Internet Explorer 6 0 Microsoft SOAP Toolkit 2 0 MS XML 4 0 Windows 2003 Enterprise Server Crystal Enterprise Version 11 Crystal Reports Developer Edition 11 10 ORACLE Hot Keys 1 6 Hot Keys Hot Keys are the shortcut keys which can be invoked by the user to navigate through various screens Some of the examples are Cash Deposit Fast Path 1501 option allows the user to navigate through Balance Inquiry Alt B Customer Name and Address Inquiry Alt C Account Details Alt A etc Hot Screen Descripti Image Key Name on s Alt Balance This kap B Inquiry screen sert Me displays RR anotada the ERER tare weena Bs begt account details of ta Adv manat unchd unes Line vert bosch Fee Cnt Pm the ER Ios RR savings Marce gang I Amos and wee Com crim checking MT ER account balances such as the available balance nucleated balance current book balance passbook balance net nn balance etc 11 ORACLE Hot Key s Alt C Alt A Screen Name Customer Name And Address Inquiry Account Details Hot Keys Descripti Image on This screen displays the details such as the name address city
101. s Package External Payment Product Transaction Code Cross Reference Payment Global Parameters Counterparty Master Maintenance Mandates Network Calendar Float Configuration Payment Site Reject Code Xref RD Product Rates Maintenance 109 ORACLE Fast Path CHM11 9 BAM23 BAM38 BAM80 762 BA026 SMMO1 SMM04 SMMO05 SMMO06 SMMO08 SMM14 SMM16 Appendix of Fast Path Description RD Grace Days Maintenance Issuer Maintenance Lost TC Details Maintenance Demand Draft Details Maintenance Bank Remittance Maintenance Menu Language Cross Reference Customer Account Access Code Template Profile Maintenance Class Profile Maintenance Menu Language Cross Ref Maintenance Template Access Rights Maintenance Prohibited Password Maintenance Template Securities Settings Reports Access Rights Maintenance 118 ORACLE Fast Path SMM17 SMM18 SMM19 BAM14 BAM15 BAM18 BAM19 BAM22 SCMO1 SCM04 SCM09 BAM30 BAM51 BAM76 Appendix of Fast Path Description Access Code Maintenance Access Domain Maintenance Transaction Group Code Maintenance Service Charge Code Maintenance Transaction Mnemonic Codes Maintaining Event Master Rule Definition Maintenance Maintaining UDE Master SC Package Definition SC Variances Maintenance SC Product XRef Maintenance Tax Codes Maintenance Additional Tax Maintenance Product Cust
102. s are automatically passed in FLEXCUBE Retail However in certain exceptional cases the system fails to pass the GL entries automatically In such cases GL posting is done automatically by the system into the suspense GLs defined at the bank parameter level The bank would have to manually reconcile these GLs Penalty Interest Parameters The penalty interest rate values will be derived from the Bank Parameters Maintenance if the penalty interest rate to be charged has been defined as Bank Level while defining the product You can specify an interest index and a variance that has to be levied as penalty at the account level Penalty applicable due to partial withdrawal can be done in two ways for all TD products at the bank level namely Absolute Method The absolute penalty can be defined as a fixed rate or floating rate Fixed interest rate is defined in Net Penalty Interest Rate field Floating interest rate is defined by selecting the corresponding interest index code in Net Penalty Index field Incremental Method Penalty can be defined as reduction in applicable TD interest rate This reduction can be either in the form of variance as defined in Incremental Penalty Interest Variance or index code as defined in Incremental Penalty Index The standard penalty routine uses the incremental method Definition Prerequisite BAMOS Bank Master Maintenance GLMO2 Chart of Accounts Modes Available Add Modify Cancel Amen
103. s the account details for the selected customer For example Enter a search string in the Customer ID field 84 ORACLE Search Fast Path gt Global Definitions Transaction Processing Customer Search Field Description Search O n lt 606251 4 Customer Memo me PAUL SMITH 4 INDIVIDUAL raph FEMALE 13 07 1980 Photo Signature a 999 400 00 First tell 3 22 PARK PLAZA Mumbai z 06062510000017 SAVINGS REGULAR DAILY BAL1 HEAD OFFICE 1000000 00 0 00 0 00 0 00 0 00 UNBLOCK Er o 0 Field User can enter any of the following search criteria from the SELECTED CUSTOMER section mentioned below Customer Id First Name Last Name Customer Id Optional Numeric 10 Type the customer ID in this field A customer ID is an identification number generated by the system after customer addition is completed successfully This running number unique to a customer across the system is generated after the system has identified the Customer IC and Customer Category combination to be non existent in the system This ID is used for searching and tracking the customer in the system Optional Alphanumeric 40 Type the first name of the customer Optional Alphanumeric 40 Type the last name of the customer Display This field displays the customer ID 85 ORACLE Field Name Customer Name Category Gender Date of
104. sage of Oracle FLEXCUBE and its manuals online help screen menu layouts transaction maintenance procedures authorization procedures common screens acronyms used Define various static data entities required for basic Oracle FLEXCUBE operations across all modules Create new customers and maintain various customer level entities Create new accounts and link customers to it define funds management such as Standing Instruction Sweep Out Sweep In Overdrafts Account Operations Statement Attributes and Interest Attributes Create new accounts and link customers to it create account operations lien maintenance and certificate printing Link loan operations collateral define interest attributes Identify the delinquent advances accounts and initiate necessary follow up actions Create new card types and link accounts to it Modify the card status and other card operations ORACLE Description Payments Safe Deposit Box General Ledger Relationship Pricing Branch Operations Settlement and Clearing Back Office System Operations Structure of User Manual Documentation Set Tellers Supervisors Branch Manager Back Office Operations Safe Deposit Box Users Customer Support Officers Send and receive fund and related messages to from any external entity outside the bank Safe deposit box allotment rent recovery and maintenance GL Personnel Branch and Head Define va
105. specifications Based on the requirement and the nature of the field you can specify default values and validations for the field Oracle FLEXCUBE validates all entries made to the field against the validations defined for a field TD Interest Payout Inquiry Account No 0000000 07 75 Amar SINGH Account Ccy NR Txn iR v Acct Ccy Rate 1 0000 Txn Cey Rate a 40000 Deposit No 4 Int Payout Amount nd Tax Calculated po Net Interest Payout ae Txn Amount 0 0 s User Reference No 1 Narrative TD Interest Payout By Cash u Other Transactions User Defined Fields ok cancel If you click the User Defined Fields tab the system will display the User Defined Fields screen 73 ORACLE Common Screens Limit Breached Back Field Description Field Name Description Limit Breached Display This field displays the status as Y if the limit amount is breached Click the Validate button to validate the UDF details 74 ORACLE Common Screens 1 16 7 Negotiate Negotiation Exchange Rate 1234 99000 Comments New Exchange Rate Reo En Field Description Field Name Description Exchange Rate Display This field displays the current exchange rate Comments Optional Alphanumeric 256 Type the comments if any New Exchange Display Rate This field displays the exchange rate after it has been negotiated You c
106. splays the name of the home branch under which the customer has an account Display This column displays the currency assigned to product under which the account is opened Display This column displays the original balance of the TD account Display This column displays the book balance of the account Display This column displays the blocking code Display This column displays the status of the account Display This column displays the relation of the customer with the account Display This column displays the IBAN number Display This column displays the date on which the account was opened Display This column displays the date on which the account is registered in the name of the account holder and debit transactions are allowed Display This column displays the date on which customer s relation with account is registered or modified For example This will be the date on which the account is opened with ownership as SOW or the date on which customer is linked to an account with ownership of either JAF JAO or JOF JOO Display This column displays the number of months since the account is activated Display This column displays if any of the TD accounts are linked to the selected CASA account number TD accounts can be linked to CASA accounts as Sweep In provider or 2 Way Sweep In provider 89 ORACLE Customer Search Search Loans CASA Eterm Deposit 7000
107. t Path LN522 LNM10 LNM49 1065 1066 1068 1430 BAM50 BAM57 INO10 INO17 LN444 BAM52 SY001 Appendix of Fast Path Description Account Schedule Inquiry Account Transactions Inquiry Payment Appropriation Simulation Loan Installment Payment Inquiry Loan Partial Payoff Inquiry Loan Advance Payment Inquiry Backdated Refund Of Transaction Common Billing Transactions Interest Adjustment Transaction Insurance Premium Remittance Insurance Coverage Maintanence Miscellaneous Charges Waiver Third Party Account Address Maintenance Guarantee Inquiry i33 ORACLE Fast Path BA460 BAM49 LN050 LNO61 LN027 LN056 LN026 LN051 LN062 LN079 LNM52 LNM31 7001 1078 Appendix of Fast Path Description Loan Employee Account Inquiry Reminders History Inquiry Loan Billing Transactions Customer Initiated Rollover Agreement Based Account Inquiry Split Loan Account Opening Loan Agreement Balance Inquiry Loan Account Offset Account Xref Loan Account Overridable Attributes Maintenance Account Variance Maintenance Quote for Economic Cost Account Payments Instructions Fee Collection Before Disbursement Loan Contribution Payin 134 ORACLE Fast Path 1074 LNM56 1063 1102 LN323 LN058 LNM70 LN071 LN031 BA070 LN055 1103 BAM71 LN063 Appendix of Fast Path Description Loan Settlement Payout
108. t based on various parameters It helps the customer to plan in advance for repayment SEPA Single Euro Payment Area Shell The batch process in FLEXCUBE for core banking is done at the lowest level in programs called as shells A shell handles a particular type of activity like interest accrual interest posting etc Single Maturity Deposit Time Deposits where no instruction is maintained for the maturity date and the deposit amount is required to be transferred to the TD matured GL Slave Account Target Account This account is the Sweep in Beneficiary Account and the funds are swept from the Concentration Provider account SOW Sole Owner Stage It is a part of schedule Various stages can be defined like IOI IPI EPI etc A schedule is typically made up of more than one stage SWIFT Society for Worldwide Interbank Financial Telecommunication Syariah Account It is a type of account defined for Islamic Banking Product Syariah Banking It is same as Islamic Banking Some of the Syariah products are Current Savings TD and Loans The difference with the conventional product is that the interest is not paid to the customer and it is shared with the customer It is called Nisbah Profit Sharing Customer is also liable to pay tax out of Nisbah TAN No Tax Deduction and Collection Account Number Third Party accounts These are accounts whose records exist outside FLEXCUBE
109. tatus in Oracle FLEXCUBE e Normally one would enter the date in the field using dd mm yyyy format e For ease of use Oracle FLEXCUBE has provided a Calendar function in every date field e The calendar allows you to choose a date rather than enter it in the field e select a date from a calendar in a date field follow the steps given below To select a date from the Calendar e Click SF with the mouse to activate the calendar e Oracle FLEXCUBE displays a calendar as shown below 3 Calendar February 2008 Sun Mon Tue Wed Thu Fri Sat 1 2 3 4 5 6 7 8 9 105 Sie 1125 E135 SiS ME EC NBT 1195 zz 227 522 4 257 1 25 2279 28 29 e Click the relevant date The date gets populated in the date field e Click OR to navigate to the previous or next year respectively e Click OR to navigate to the previous or next month respectively To move within a workspace e Click the field where you want to go OR e Press lt Tab gt to move clockwise from one field to another or lt Shift gt lt Tab gt to move counter clockwise Pick List A field that has the LJ button adjacent to it is a pick list e You can enter the value in the field by selecting it from the pick list 37 ORACLE Understanding the Oracle FLEXCUBE User Interface e To see the pick list available for any field click the J button that appears adjacent to the field e For example to select the name of the Country click J adjacent to
110. tem displays the Tree Menu in the left pane as shown in the following figure 28 ORACLE Understanding the Oracle FLEXCUBE User Interface SELECTED CUSTOM Customer Id First Name Last Name Advance gt Global Definitions gt Transaction Processing e All the options available to the user are grouped in a hierarchical form in the left pane To display a sub option in the left pane click the gt icon next to the option OR double click the option For example on the tree menu navigate to Transaction Processing gt Account Transactions gt Loan Account Transactions gt Rate Change as shown in the following figure 29 ORACLE Understanding the Oracle FLEXCUBE User Interface SELECTED CUSTOME Customer Id First Name Last Advance Transaction Processing gt Walkin Transactions me Account Transactions Loan Account Transactions me Other Transactions P Loan Account Attributes Account Documents Mai Loan Account Commitm Loan Disbursement Rev Account Rates Rate Change b Coa PPrUuveu Al Additional Document Ma Miscellaneous Charges Loan Commitment Fee P Account Schedule P Miscellaneous Loans Dr P Asset Agreement Inquiry Loan Account CBR Details P Loan Auto Disbursments P Loan Account Payoff No Account Payments Instr Loan Direct Account Op P
111. the Country field as shown in the following figure Country L e Oracle FLEXCUBE displays the pop up screen as shown in the following figure First Previous fi Next Last AMERICA AUSTRALIVA BANGLADESH CHINA INDIA INDIA1 Indonesia SRILANKA japan e When you click the mouse pointer over a particular record it gets highlighted Double clicking the highlighted record will automatically populate the field as shown in the following figure Country INDIA 53 38 ORACLE Understanding the Oracle FLEXCUBE User Interface Frame _ Sex Female A frame is a rectangular box mostly with a title that is used to group related fields on a screen For example e The adjacent figure displays a section with Marital Status as its title e It has two fields viz Status and No of Spouses Radio Button Male C Female A radio button is a group of two or more choices that are mutually exclusive that is you can select only one For example if there are two radio buttons only one of them can be active e To select a radio button click the radio button Check box Global P Keep In Office FI A check box is a toggle switch You can click the check box to indicate Yes on the option or you can click the check box again to indicate No e Inthe Yes state you will see a tick mark inside the box e Inthe No state the box remains empty Drop down list Reason for Verification
112. the final value of the service charge after the rule has been applied Final Value Original SC Value Rule Returned Value Display This field displays the reason for charging of SC Click the Ok button to apply the new or modified service charges to the transaction 63 ORACLE Common Screens 1 16 2 Instrument Details Instrument Details amp L Clearing Type Local 3 day float v Cheque 1 Cheque Literal Local Cheque Deposit _ Cheque Date 5 Routing No 1001001 Bak ro ss C Drawer Acct No 000000002220 Branch 1001 CANARAL Value Date 5 2508 Sector 201 Java Late Clearing iN Chg Commission Yes vi Instr Sub type 00 Crossed Cheque Field Description Field Name Description Clearing Type Mandatory Drop Down Select the clearing type from the drop down list The bank can set up multiple clearing types where cheques that are required to be cleared at different times of the day are deposited so that they can be treated differently All processes for a cheque from outward clearing running of value date and marking late clearing etc takes place on the basis of the clearing type Refer to the Clearing Type Maintenance Fast Path STM64 option in Definitions User s Guide 64 ORACLE Field Name Cheque No Cheque Literal Cheque Date Routing No Bank Common Screens
113. the user clicks on this option the system displays the SC History for Account Inquiry Fast Path SCM05 option e Unclear Funds If the user clicks on this option the system displays the Cheque Status Inquiry Fast Path STO66 option 91 ORACLE Customer Search Future Dated Cash Deposits If the user clicks on this option the system displays the Immediate Credit for Advance Cash Deposits Fast Path BAM21 option Bills If the user clicks on this option the system displays the Bills Processing Maintenance Fast Path BIMO5 option Hold Funds If the user clicks on this option the system displays the Hold Funds Maintenance Fast Path CHM33 option Balance Enquiry If the user clicks on this option the system displays the Balance Inquiry Fast Path 7002 option If the user double clicks on the TD account number the system displays the following pop up Statement If the user clicks on this option the system displays the TD Account Ledger Inquiry Fast Path TD037 option Account Profile If the user clicks on this option the system displays the TD Account Master Fast Path TD020 option TD Enquiry If the user clicks on this option the system displays the TD Balance Inquiry Fast Path 7020 option If the user double clicks on the Loan account number the system displays the following pop up Statement If the user clicks on this option the system displays the Account Transactions Inquiry Fast Path LNM10 option A
114. tory FieldName Description Search Criteria Entities to be The defined description ofthe fields Definition Prerequisites 8053 Customer Addition Modes available for maintenance Modes Available Add Modtty Delete Inquiry For more efomaton on the procedures of every mode referto itandard Maintenance Procedures te customer details in CIM17 and cick Go or navgate through the menus to Transaction Transactions gt Corporate Customer Details ine Corporate Customer Details screen The procedure Corporate Customer Details Transaction Screen Full Name 5 Type the search stang and press the Tab key and select the customer from the pick The name of the transaction screen brief introduction about the broad contours of the transaction is described in this section Definition Prerequisites The entities to be defined before maintaining the option For example Signature Types have to be defined before adding a customer in Oracle FLEXCUBE Modes Available The modes those are available to maintain the transaction in case of maintenance transaction For more information refer to the Modes Available section in the Understanding the Oracle FLEXCUBE User Interface option Procedures The process used to operate the transaction is mentioned Depending upon the nature of the maintenance only the important sub proce
115. uthorizer for same transaction type but will not have the right to authorize the transaction initiated by him Only posting transaction screens have option for Local authorization Re entry of amount is not possible for local authorization 1 Enter the relevant information in the transaction screen and click the Ok button 1 The system displays the Authorization required message box Microsoft Internet Explorer 2 Authorization Required Do you want to continue 3 Click the OK button to continue 4 The system displays the Authorization Reason screen 45 ORACLE Authorisation Procedures Oracle Flexcube Authorization 5 Select the Local option 6 Enter the appropriate user name and password 46 ORACLE Authorisation Procedures Oracle Flexcube Authorizal Premature Redemption of Term Deposit Local Remote Supervisor ID ISSHWETALI Primary Password 0000000 Comments court order 4 bs 7 Click the Grant button and the transaction will be authorised 1 15 2 Remote Authorisation Remote authorisation is used when the person posting the transaction has sent the transaction for authorisation to a remote location within his branch The authoriser list includes user name along with the user ID and login status The transaction will be allowed to be authorized by a user of similar level or a higher level based on the Parallel Authorization parameter value The list will not have t
116. vice Report Status Inquiry Report Print All Tellers Advice Report Cancel Request Report Cancel All Tellers Report Control Maintenance Inventory Balancing Book or Cancel Overage Shortage Inventory Inter Branch Transfer Centralised Authorisation Payment Verification Mandate Maintenance Link Delink TIL ID Buy Cash from Teller Buy Inventory from Teller 147 ORACLE Appendix of Fast Path Module Name Settlement and Clearing Fast Path 6560 1511 5521 CHM41 STO31 ST032 ST036 ST042 5505 5506 6511 6512 6520 6602 Description Online Cheque Return Inquiry MICR Header Entry Batch Inward Clearing Cheque Data Entry Inward Cheque Status Inquiry Load Inward MICR File Authorise Inward Clearing Batches Reconcile Outward MICR File Load Central Bank File Batch Consolidated Cheque Data Entry Batch Data Entry Outward Settlement and Clearing Consolidated Cheque Deposit Consolidated Cheque Batch Data Entry Cheque Deposited To GL Postdated Cheque Data Entry Batch 148 ORACLE Fast Path 6619 STO77 ST078 ST033 ST034 St035 ST038 ST062 ST075 ST076 5 099 6565 6566 6806 Appendix of Fast Path Description Postdated Cheque Cancellation Postdated Cheque Discounting Postdated Cheque Discounting Cancel Inward Clearing Process Scanning Rejected Instrument Scanning of Passed Instrument Bulk Scan Inward Reje
117. weep in provider account and funds will be swept to the beneficiary target account Contracted interest rate Rate of interest at the time of TD booking CRR Credit Risk Rating Daily Periodic Rate It is the interest rate linked to the account divided by the number of days in a year as determined by the interest accrual basis set DCN Data Communication Network Deduction Plan It is a plan for affecting deductions for an account during disbursement A deduction plan can be linked to one or more products Thus all the accounts under a given product will have the same deduction plan DIN Debtor Identification Number DLC Date Last Contact Document Plan It is a plan for listing the documents to be collected from an account document plan can be linked to one or more products DPD Days Past Due Draw down It is a method of repayment of loan arrears In this method a loan account is linked to a savings account Whenever there is an arrear in the loan account the system tries to draw down sufficient funds from the savings account to cover the outstanding arrears The drawdown is typically initiated by the loans module in contrast to a standing instruction which is initiated by a Savings module Additional features to the draw down method is by defining that partial draw down is allowed or by letting the loans module raise an earmark on the Savings account Early Settle
118. y Card Master Setup 137 Appendix of Fast Path ORACLE Fast Path CM08 CMO09 CM10 CMS01 CM12 CM13 CMMO1 CM14 Appendix of Fast Path Description Card Account Product Link Setup Card Maintenance Card and Random Number Status Change Card Maintenance Customer Card Maintenance Card Muti Currency Account Linkage Card MCA Linkage Maintenance Card Type Master Module Name Payments Fast Path 2030 2031 2032 2035 2037 Description Outgoing Payment Transaction Initiation Outgoing Payment Transaction Message SWIFT Outgoing Payment Message Domestic Outgoing Payment Initiation Credit Card SEPA Outgoing Payment Initiation Credit Card 138 ORACLE Fast Path 2039 2041 2042 PM010 PM023 PM025 PM026 PM027 PM030 2055 2056 2057 PM033 PM034 Appendix of Fast Path Description Cross Border Outgoing Payment Initiation Credit Card Outgoing Payment Initiation Against GL Outgoing Payment Initiation Against CASH Mandate Revocation Payment Transaction Authorization Payment Transaction Inquiry Incoming Payment Repair Queue Outgoing Payment Repair Queue Non Financial messages RTGS Outgoing Payment Initiation Customer RTGS Bank Payment NEFT Outgoing Payment Initiation RTGS NEFT Outgoing Pymt Auth Screen RTGS NEFT Outgoing Pymt Release Screen 139 ORACLE Fast Path PM035 PM037 Appen
119. ze is not enabled the person posting the transaction teller is expected to submit the transaction for posting from the Electronic Journal screen or Incomplete Transactions screen after the authorizer has authorized the transaction 1 Type the fast path 6006 and click Go or navigate through the menus to Transaction Processing Internal Transactions Inquiries Search Electronic Journal The system displays the Search Electronic Journal screen Click the Electronic Journal option Click the Fetch button The system displays all the transactions performed by the teller 56 ORACLE Authorisation Procedures Teller ID TSRINIVASAN Branch Posting Date Host Process Date fsojo4jz008 gm Account No From Sequence No To Sequence No pss From Txn Time To Txn Time 23 59 59 From Amount To Amount 999 999 999 999 99 Mnemonic Incomplete Transactions 7 Remote Authorized Transactions 7 6 1401 18 47 01 06049420000012 INR Incomplete 1 000 00 TSRINIVASA Click to print 5 1401 17 52 46 06049420000012 INR Sent 1 000 00 TSRINIVASA Click to print 4 1401 17 51 10 06049410000019 Cancelled 0 00 TSRINIVASA Click to print 3 18051 18 39 45 06056900000019 Sent 0 00 TSRINIVASA Click to print 2 8053 12 24 50 Sent 0 00 TSRINIVASA Click to print 1 9001 17 53 26 Success 0 00 TSRINIVASA Click to print ro Card Change Pin 5 Double click the sequence number in the Seq N

Oracle FLEXCUBE Introduction User Manual

Contents

Download Pdf Manuals

Related Search

Related Contents