Home

Oracle FLEXCUBE Introduction User Manual

1. This column displays the total outstanding amount Display This column displays the booking date or loan commencement date Display This column displays the date on which the first disbursement taken Display This column displays the maturity date for loan Display This column displays the account status Display This column displays any user defined status ORACLE Treasury CASA Corporate Loan Bill Details Branch Code Contact Reference Drawer Drawee Bill Currency Bill Amount Bill Amount in Maturity Date LC Reference Number Outstanding Purchase Amount Name LCY Amount 0 p LC Details LC Contract LC Amount in LC Current Application Benefidary Issuing Advising Bank Branch Code Contract Reference Issue Date LC Currency PE LC Tolerance LCY Feri Expiry Date aa 960 960NELC170310005 31 01 2017 INR 20 500 00 20 500 00 20500 01 05 2017 FGDT ENT LKJ ENT 1 nl Guarantee Details Guarantee Guarantee Guarantee Guarantee Claim Expiry Application Bene Branch Code Contract Reference Guarantee Type Issue Date ma rase Amountin LCY Outstanding Expiry Date Date Name Field Description Column Name Description Bill Details Branch Code Display This column displays the branch code of the contract Contract Reference Display This column displays the contract reference number Drawer Drawee Display Name Bill Currency Bill Amount Bill Amount in LCY Maturity Date
2. CHM36 1006 1840 2842 1091 1092 Description Account Level Variance Bank Assurance Account Details Casa Tax Refund Passbook Update Passbook Balance Cheque Digit Inquiry Passbook Issue Lost Maintenance SWIFT Statement Details Special Frequency for Statement Account Addresses Maintenance Funds Transfer Request Funds Transfer Request FW FCR Funds Transfer Request UBS CASA To CASA Funds Transfer Request CASA To GL Funds Transfer Request ORACLE Fast Path 1093 1431 1801 1804 CHM50 ORS42 BAM66 BAM93 BAM82 BAM24 CH039 7115 7116 ECMO2 Description GL To CASA Funds Transfer Request 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 ORACLE Fast Path TD024 CH033 STM72 BA988 BA007 CI500 1040 1041 CH050 CH022 CH501 CHM58 CH012 CHM30 Description Tax Absorb Account Maintenance Average Quarterly Monthly Balance Inquiry Payee Name Update Account Interest Freeze Maintenance Old New Account Inquiry Assisted
3. Parent Lcy Display This field displays amount of Service Charge of the Parent SC in local currency Addnl LCY Display The field displays the amount of Service Charge of the Additional SC in local Currency Rule Applied 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 Total Lcy Display Column Name This field displays the total service charge to be applied in local currency Description Rule Details Rule ID Original Value Rule Returned Rule Returned Value Final Value Display 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 the final value of the service charge after the rule has been applied Final Value Original SC Value Rule Returned Value ORACLE Column Name Description Reason 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 ORACLE Instrument Details Instrument Details DUE Cle
4. 47 50000 Cheque Amount o Charges Ley 10 00 Total Amount BC Date Serial No Micr No Routing No Bebeficiary Name John Passport JIC No asses Beneficiary Addr Altamount Road User Reference No 555 Narrative BC Sale Against Cash a en CUS ECS LCD ee CT vo J og cose clear 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 1 1 4 Service Charge Details A maximum of five default service charges can be linked to each transaction ORACLE UE HOME f R SERVICE TAX 10 00 INR 10 00 0 00 0 00 Rule CESS 0 20 INR 0 20 0 00 0 00 Rule OTAL LCY Field Description Field Name Description Service Charge Display This field displays the default SC which is linked to the transaction Amount 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 CCY Display This field displays the service charge currency ORACLE Field Name Description Amount Lcy 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
5. BAO79 TD Product Transfer Auto Customer Type Update BAM64 Customer Account Nominee Cross Reference C1002 Backoffice User Definition Cl141 Customer To Customer Relation Cl145 Customer Account Group Movement Details Cl162 Combined Statement Plan CIM10 Customer NLS Details Maintenance CIM12 Customer Contact Log Maintenance CIM13 Customer Memo Maintenance CIM15 Customer Type Xref For Primary Customer ID Change CIM16 Customer Dormancy Status Maintenance CIM18 CBR Details Maintenance U National Language Support ORACLE Fast Path CIM19 CIM20 CIM21 CIM24 CIM30 CIM39 CIM42 CIM45 CIM46 CIM47 CIM48 CIM54 CiM56 CIM57 Description Customer Blacklist Details Investor Services Customer Data Inquire Customer Account Restriction Customer MIS Details Customer Maturity Processing Customer ID Change Maintenance Customer Lock Unlock System Group Master Maintenance RM Master Maintenance Customer Group Maintenance Account Group Maintenance Customer ID Verification Maintenance Customer ID Verification History Change Customer Anniversary Maintenance ORACLE Fast Path CIM79 CIM78 ETMO1 STM81 2000 7004 7100 BA008 CI001 CI502 CI503 CI504 CI999 CIM55 Description Eligibility Criteria Maintenance for Customer Type Updation Customer Information Maintenance Customer Alerts Registration Customer Blacklist Details Modif
6. Currency AmountFinanced Amount Disbursed Outstanding Amount Book Date INR 25000 25000 4 25000 Value Date N 31 01 2017 31 01 2017 3 Commitment Details Branch Code Product Code Account No Description Currency AmountFinanced Amount Disbursed Outstanding Amount Book Date Value Date Mortgage Branch Code Product Code Account No Description Currency AmountFinanced Amount Disbursed Outstanding Amount Book Date Value Date Mat r Leasing Branch Code Product Code Account No Description Currency AmountFinanced Amount Disbursed Outstanding Amount Book Date Value Date Mat r Syndicate Loan Details Branch Code Product Code Account No Description Currency AmountFinanced Amount Disbursed Outstanding Amount Book Date Value Date Mat Field Description Column Name Description Branch Code Display This column displays the branch code of the contract Product Code Display This column displays the product code Account No Display This column displays the account number of the customer Description Display This column displays the description for the product Currency Display This column displays the account currency Amount Financed Display This column displays the amount which is financed Amount Disbursed Display This column displays the actual disbursed amount Outstanding Display Amount Book Date Value Date Maturity Date
7. Display This field displays all the customer memos one below the other ORACLE Field Name Customer Instructions Message Number of unresolved conversations Search CASA Description Display This field displays the customer Instructions which are maintained as part of Customer Instruction Maintenance Display This field displays the message of happy birthday to the customer in case if customer s birthday is on the particular day For example Happy Birthday Anwar Ali Display This field displays the number of unresolved conversations based on the number of customer conversations which are open or not closed The customer conversations can be initiated using FCDB or Customer Contact Complaint Log CIM12 option 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 FE om Deposit Loans RD Funds Projection Account Details Account No Product Currency Branch Available Bal Book Balance Undear Funds Account Status Classification Status 010000000816010005 Savings Account LINR 60 FORT MUN 1 97 337 52 97 689 52 0 00 ACCOUNT OPEN REGULAR NORMAL 010000000837410005 Savings Account LINR 60 FORT MUN 0 00 0 00 0 00 ACCOUNT OPEN REGULAR NORMAL INR Total 1 97 337 52 Account Rel SOW JAF gt Field Descript
8. LNM34 LNM35 LNM38 LNM39 LNM83 LNM99 1061 1062 1071 1067 1069 1412 AC005 LNM37 Description Loan Collateral Link Maintenance Loan Account Master Attributes Maintenance Loan Approved Amount Maintenance Loan Account Application Details Maintenance Account Rates Loan Account CBR Details Fee Collection before Disbursement Fee Refund before Disbursement Loan Adhoc Fee Collection Inquiry Loan Full Payoff Inquiry Loan Recission Inquiry Loan Refund Inquiry Automatic Write off Account Maintenance Loan Account Payoff Notice Maintenance ORACLE Fast Path 7026 INO20 LNO22 LNO23 LN500 LN501 LN502 LN522 LNM10 LNM49 1065 1066 1068 1430 Description Loan Balance Inquiry Insurance Premium Inquiry Interest Calculation Inquiry Amortization Inquiry Installment Calculator Loan Funds Flow Calculator Loans Event Simulation Maintenance 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 ORACLE Fast Path Description BAM50 Common Billing Transactions BAM57 Interest Adjustment Transaction INO10 Insurance Premium Remittance INO17 Insurance Coverage Maintanence LN444 Miscellaneous Charges Waiver BAM52 Third Party Account Address Maintenance SY001 Guarantee I
9. Mnemonic fi Ce Customer Id Account No 101000001080 Teller Id Txn Date TxnTime Branch UserID SeqNo Mnem Cust Id Account No Description Ccy Amount State Authori 13 01 2006 11 49 08 9999 TVINEET 29 1001600075 9999101000001080 Ro INR 6 000 00 Incomplete The system displays all the transactions sent for authorization Click the transaction to view the transaction details The system displays the transaction details screen The supervisor cannot modify any details on the screen ORACLE Cash Withdrawal Account No Amount 6 000 QI Account Amt 6 000 00 Narrative f ash Wahdrawa or Jeans 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 ORACLE Account No f i M Al Account Coy ng 3 Txn Coy fine 2 Acct Coy Rate Txn Coy Rate 1 Amount 6900 Account Amt Narrative j Fexcube Web Page Dialog Authorization Reasons Reason SANCTION OBTAINED Comments Overdraft for the account z E LTRVentOry Details ok cancel Mark Grant Deny View Back i 9 Select the reason from the drop down list and type the comments 10 Click the Ok button Teller activities after authorization If auto authorize is not enabled the person posting the transaction teller is exp
10. NSF Reject Log Inquiry Return Cutoff Maintenance Scan Reject Pass Disable Maintenance ECS Cutoff Marking Maintenance Module Name BackOffice Fast Path AC001 AC002 AC003 AC004 ACMO7 Description Account Classification Preferences Account Classification Inquiry Account Provision Account WriteOff Provisioning Parameters at Bank level for Loans and Overdrafts ORACLE Fast Path AC008 BA433 BA434 BAM46 BAM47 ATMO1 ATM02 BA092 BAIB2 BAIB3 BAIB4 BAIB5 BAIB6 POS01 Description Provision Inquiry and Modification for Loans and Overdraft Collateral To Accounts Inquiry Account To Collateral Inquiry Collateral Propagation Application Collateral Delink ATM Bank Params Maintenance ATM Acquirer POS ID Maintenance Auto Relock Time Maintenance IB Bill Company Details Maintenance IB Customer Application Billing Information Maintenance IB Bank Params Maintenance IB Block Transfer Across Products IB Transaction Customer Relationship Cross Reference POS Acquirer POS ID Maintenance ORACLE Fast Path POS02 POS04 TBSO1 TBS02 TBS03 5504 5531 8889 8890 8891 8892 7239 7240 8893 Description POS Bank Params Maintenance POS BIN Xref Maintenance TBS Bank Params Maintenance TBS Acquirer POS ID Maintenance IVR TIN Request Download Upload Status Inquiry Download Upload File Download Scheduler Mainten
11. Status and No of Spouses ORACLE 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 ORACLE Check box Global F Keep In Office F 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 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 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
12. Travellers Cheque Close clear 5 Double click the sequence number in the Seq No column whose state is Auth Granted 6 The system displays the relevant screen ORACLE Cash Deposit Account No 60000001756440 faenav Account Coy Txn Cey LTL Account Cey Rate 1 00000 Txn Cey Rate 1 00000 Customer Type Customer Category Customer Status Bank Notes Litas Coins Centas Coins Total Amount Account Amount Txn Amount Value Date f15 01 200 User Reference No Narrative Cash Deposit 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 1 3 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 authoris
13. ORACLE Fast Path 7041 7050 7122 BAM95 6001 6002 6005 6009 9888 6201 6203 7551 7552 9001 Description 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 Book Cash Overage Open Teller Batch ORACLE Fast Path 9005 9007 9008 9003 9006 9009 9010 5514 5515 9800 BA995 BA999 7775 7778 Description Close Teller Batch Buying Cash from Vault Sell Cash to Vault Open Vault Batch Close Vault Batch Buying Cash from Central Bank Sell Cash to Central Bank Change Data Entry Batch User List Batch Status Print Spooled Documents Single Account Transfer Bulk Account Transfer Report Request Advice Report Status Inquiry ORACLE Fast Path 7779 7780 7781 BAM16 Description Report Print All Tellers Advice Report Cancel Request Report Cancel All Tellers Report Control Maintenance Module Name Settlement and Clearing Fast Path 6560 1511 5521 CHM41 STO31 ST032 ST036 ST039 ST042 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 Batc
14. ACM11 ACM12 ACM22 BS001 BS004 BS007 BS010 BS013 BS019 BS020 BS016 BAO11 BA012 BA013 BA014 CH099 Description Product Provision Codes Maintenance Universal NPA Crr Code Maintenance Provision Plan Maintenance Rating Agency Maintenance Rating Group Maintenance Basel II Pick list Maintenance Basel Securitization Details Maintenance Basel II Customer Details Maintenance Basel II Collateral Data Maintenance BASEL II Data Capture Screen Basel II Account Details Maintenance Spend Class Maintenance Spend Analysis Preferences Maintenance Spend Rule Maintenance Spend Rule Configuration CASA Multi Currency Product Package Definition ORACLE Fast Path CHMO1 CHMO2 CHM04 CHM70 CHM84 BA078 BA080 BAM27 BAM28 BAM29 BAM33 BAM41 ECMO3 Description CASA Product Master Maintenance CASA Interest Rate Tiers Maintenance CASA Bank Parameters Maintenance Employer Code and Product Code Cross Ref CASA Product Attributes Maintenance User Defined Fields Maintenance CBR Pick Lists Maintenance Calendar For Endpoint Endpoint Float Maintenance End Point Master Maintenance Composite Calendar Generation Sector Master ECS Central Bank Reject Code Xref Central Bank Reporting The clearing house is called the Endpoint ORACLE Fast Path Description ST080 PDC Discounting Parameters Maintenance STM50 Clearing
15. Access Code Template Profile Maintenance Class Profile Maintenance Menu Language Cross Ref Maintenance ORACLE Fast Path SMM06 SMM08 SMM14 SMM16 SMM17 SMM18 SMM19 SMM22 BAM14 BAM18 BAM19 BAM22 SCMO1 SCM04 Description Template Access Rights Maintenance Prohibited Password Maintenance Template Securities Settings Reports Access Rights Maintenance Access Code Maintenance Access Domain Maintenance Transaction Group Code Maintenance Template Access Rights for File Upload Service Charge Code Maintenance Maintaining Event Master Rule Definition Maintenance Maintaining UDE Master SC Package Definition SC Variances Maintenance User Defined Entity ORACLE Fast Path SCMO9 BAM30 BAM51 BAM76 TDS04 TDS06 TDS07 TDO60 TDMO1 TDM04 UDFO1 UDF02 Description SC Product XRef Maintenance Tax Codes Maintenance Additional Tax Maintenance Product Customer Tax Codes Maintenance Tax Waiver Criteria Maintenance Tax Parameters Maintenance Tax Acknowledgement Details Maintenance TD Product Rate Maintenance TD Product Master TD Bank Parameters Maintenance User Defined Fields UDF Task Code Linkage Module Name Customer Information File Fast Path 7101 Description IC No Short Name Change ORACLE Fast Path Description 7117 Bulk Authorization Cancellation of Images 7118 Delete Customer Image
16. Account Opening TD020 TD Account Master TDO21 Deposit Master TD022 TD Nominee Maintenance TD028 TD Block Unblock Account Status TD043 TD Certificate Printing TDM05 TD Account CBR Codes Maintenance TDM24 Lien Master TDM25 TD Duplicate Receipt Issue ORACLE Fast Path TDM48 TD044 6503 6504 6505 1311 1828 2828 1332 1336 1824 2824 BAIB7 TD689 Description Backdated Interest Rate Change TD Transactions Inquiry Quick Payin By BC Quick Payin by DD Quick Payin By Cheque TD Redemption Inquiry By BC TD Redemption Inquiry TD Redemption Inquiry Quick Redemption By DD Quick Redemption By Reinvesting To New Account Quick Payin By CASA FW FCR Quick Payin By CASA UBS Customer Prod Cross Reference Customer Deposit Inquiry ORACLE Module Name Loans Fast Path 1413 LNO45 LN521 LNM44 LNO46 LNO57 LNO65 LNO89 LNO90 LN101 LN323 LNM31 LNM32 LNM33 Description Loans Disbursement Inquiry Loan Disbursement Reversal 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 Account Documents Maintenance Account Payment Instructions Additional Document Maintenance Loan Account Address Maintenance ORACLE Fast Path
17. Account Status This column displays the total outstanding amount Display This column displays the booking date or loan commencement date Display This column displays the date on which the first disbursement taken Display This column displays the maturity date for loan Display This column displays the account status ORACLE Column Name User DefinedStatus Commitment Details Branch Code Product Code Account No Description Currency Amount Financed Amount Disbursed Outstanding Amount Book Date Value Date Maturity Date Account Status User DefinedStatus Mortgages Branch Code Product Code Account No Description Currency Description Display This column displays any user defined status Display This column displays the branch code of the contract Display This column displays the product code Display This column displays the account number of the customer Display This column displays the description for the product Display This column displays the account currency Display This column displays the amount which is financed Display This column displays the actual disbursed amount Display This column displays the total outstanding amount Display This column displays the booking date or loan commencement date Display This column displays the date on which the first disbursement has done Display This colu
18. Amount Display This column displays the regular installment amount of the RD account Maturity Date Display This column displays the maturity of the RD account Account Status Display This column displays the status of the account Status of the account can be ACCOUNT OPEN REGULAR ACCOUNT OPEN NO CREDIT ACCOUNT OPEN NO DEBIT etc Account Rel Display This column displays the relationship of the customer with the account Search Loans ORACLE FS Fn Proicction CASA Term Deposit Account Details 1 Account No Product Currency Branch Outstanding Bal Other Arrears Maturity Date Classification Status Loan Application No Account Rel 5000000030922970000 Loan Product 1 INR 240 SANDOZ 1524100 0 00 30 08 2017 NORMAL LNMAT3081610 SOW 50000 123370000 Loan Product 1 INR 240 SANDOZ 0 0 00 01 01 1950 NORMAL LNMAT1235631 sow 50000 141170000 Loan Product 1 INR 240 SANDOZ 0 0 00 01 01 1950 NORMAL LNMAT3081618 sow 5000000031284870000 Loan Product 1 INR 240 SANDOZ 10040 98 0 00 02 09 2017 NORMAL 14160 SOW 50000 341770000 Loan Product 1 INR 240 SANDOZ 175860 66 0 00 02 09 2017 NORMAL In1563212322 SOW 50000 1270000 Loan Product 1 INR 240 SANDOZ 1658742 65 0 00 30 08 2017 NORMAL LNMAT563 SOW 5000000032145270000 Loan Product 1 INR 240 SANDOZ 0 0 0001 01 1950 NORMAL LN30815 SOW a Field Description Column Name Description Account No Display This column displays the account number of
19. Branch Cross Reference STM54 Routing Branch Maintenance STM55 Clearing Minimum Maintenance STM56 Site Reject Code Xref STM58 Instrument Type Xref STM60 ACH Branch Cross Reference Maintenance STM64 Clearing Type Maintenance STM70 Routing Number Details STM74 Restricted Clearing Types Maintenance The branch which does the centralized clearing The maintenance of a minimum clearing amount for each type of instrument in each currency A deposit of an instrument for an amount less than the specified amount will be given immediate credit 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 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 ORACLE Fast Path STM82 STM83 STM97 STM98 BAM37 BAM39 BAM63 BAM74 BAM84 CLNOO CLNO1 CLNO2 CLNO3 CLNO4 Description Drawer Name and Issuing Bank Update Bulk Authorization Drawer Update Correspondence Bank Master Maintenance IC OC Clearing Type Cross Reference Collateral Codes Details Collateral Codes Maintenance Product Collateral Linkage Collateral Header Maintenance Financial Securit
20. Deal Rate 960FSB1170310075 B 31 01 2017 USD 50 00 31 01 2017 JINR 3085 0031 01 2017 31 01 2017 1 Al r Money Market Details Branch Code risk Currency Amount Tenor Book Date Value Date Maturity Date Type 960 960MBIL 1703 INR 1050 190 31 01 2017 31 01 2017 01 05 2017 BORROW 1 All r Security Portfolio KE rlobeseeen Curenoy bedde Corpus account SHELPeStOn ACE Ser op r Derivatives Ard Buy Sell In Leg Currency n pres el Out pel Book Date Value Date Maturity Date Type 0 p r OTC Options Peri Currency Contract Number Contract Amount Strike Price Renh Option Premium Her Buy Sell Tenor Book Date 0 p r ETD Protfolio Details Reference Devon D 4 gt Field Description Column Name Description Foreign Exchange Details Contract Reference Display This column displays the contract reference number Buy Sell Display This column displays the type of transaction that is Buy or Sell Book Date Display This column displays the date on which the transaction is booked ORACLE Column Name Bought Currency Bought Amount Bought Value Date Sold Currency Sold Amount Sold Value Date Deal Date Money Market Details Branch Code Contract Reference Currency Amount Tenor Book Date Value Date Maturity Date Type Security Portfolio Portfolio Reference Portfolio Description Currency Description Display This column displays the currency for buying of transaction Display This column dis
21. 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 ORACLE Fast Path 1821 2821 1008 1013 1826 2826 1708 1802 1055 CHM31 CHM32 CHM33 CHM39 CHM40 Description Cash Withdrawal Cash Withdrawal UBS Miscellaneous Customer Debit CASA Cheque Withdrawal CASA Cheque Withdrawal FW FCR CASA Cheque Withdrawal UBS Cross Cost Center Miscellaneous Customer Debit OBU CASA Account Debit Hold Funds Request Standing Instruction Maintenance Sweep Out Maintenance Hold Funds Maintenance Sweep In Maintenance Sweep in Sweep out Priority Maintenance ORACLE Fast Path 1010 1825 2825 1014 1827 2827 1080 1432 1650 8318 BA030 CH077 CHMO9 CHM47 Description Banker s Cheque Sale Against Account BC Sale Against A c FW FCR BC Sale Against A c UBS DD Sale Against Account DD Sale Against A c FW FCR DD Sale Against A c UBS Record Confirmation Transaction Flexible RD Redemption CASA Billing Transactions TT Sale Against Account Treasury Negotiation Worklist Confirmation Maintenance Ch JPA Account XRef Maintenance Account Cheque Purchase Limit Maintenance ORACLE Fast Path CHM48 CHM57 TDS13 7010 7013 7030 CH032 CHM34
22. Enter the bank code integer and bank name and click the Ok button 5 D The system displays the message Record Added Authorisation Pending Click Ok to Continue To modify the bank code 1 Select the Modify mode Type the bank code and press the lt Tab gt or lt Enter gt key or select it from the pick list Modify the relevant information and click the Ok button 5 oO D The system displays the message Record Modified Authorisation Pending Click Ok to Continue This 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 or lt Enter 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
23. FON ORACLE 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 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 or lt Enter 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 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 2 Type the bank code and press the lt Tab gt or lt Enter gt key or select it from the pick list 3 Modify the relevant information and click the Ok button 4 The system displays the
24. LC Reference Number Outstanding Amount Purchase Amount LC Details Branch Code This column displays drawer name in case of import bills and drawee name in case of export bills Display This column displays the currency of the bill Display This column displays the bill amount Display This column displays the bill amount in local currency Display This column displays the maturity date of the bill Display This column displays the LC reference number in case of Bills under LC Display This column displays the bill due amount Display This column displays the purchase discount amount Display This column displays the branch code of the contract ORACLE Column Name Description Contract Reference Display This column displays the contract reference number Issue Date Display This column displays LC issue date LC Currency Display This column displays the LC currency LC Contract Display Amount This column displays the LC contract amount LC Tolerance Display This column displays the tolerance amount LC Amount in LCY Display This column displays the LC amount in local currency LC Current Display Availability This column displays the LC current availability Expiry Date Display This column displays the expiry date Applicant Display Beneficiary Name Issuing Advising Bank Name Guarantee Details Branch Code Contract Reference Guarantee Type Issue Da
25. MANMEET CIF03 MANMEET CIF04 MANMEET CIFOS MANMEET CIF06 MANMEET FCDB MANVA PATIL MANOJ MANMEET MEMO MANMEET TEST Customer Type INDIVIDUAL INDIVIDUAL INDIVIDUAL INDIVIDUAL INDIVIDUAL INDIVIDUAL INDIVIDUAL INDIVIDUAL INDIVIDUAL INDIVIDUAL 4 Date of Birth 31 12 1990 16 02 1990 25 02 1993 22 02 1990 18 02 1991 07 02 1989 12 12 1989 31 10 1988 16 02 1988 12 02 1988 Mobile No 1111111111 6666548741 7777777777 964584751 9865745896 9985451224 7895461231 9856320145 Home Phone 54152546 4 Mesa Field Description Field Name Description User can enter any of the following search criteria mentioned below ORACLE Field Name Customer Id Account No Customer IC Short Name NLS Name IBAN ATM Card Number Refined Search Mobile No Home Phone Date of Birth Date Incorporated Currency Description 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 14 Type the account number of the customer Optional A
26. Outgoing Payment Initiation Credit Card 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 18i Single Euro Payment Area ORACLE Fast Path PM033 PM034 PM035 PM036 PM037 PM043 PMO44 PMO45 PMO46 Description RTGS NEFT Outgoing Pymt Auth Screen RTGS NEFT Outgoing Pymt Release Screen Incoming Pymt Auth Screen RTGS Incoming Payment For Semi Authorized RTGS NEFT Beneficiary Master Maintenance NEFT Outgoing Pymt Auth Screen NEFT Outgoing Payment Release Screen NEFT Incoming Pymt Auth Screen NEFT Incoming Payment For Semi Authorized Module Name Safe Deposit Box Fast Path 1701 1720 8057 SB001 Description Rent Payment Inquiry SDB Close Out Balance Inquiry Safe Box Allotment Safe Box Usage Log ORACLE Fast Path Description 5B002 Customer Waitlist SB003 Safe Box Usage And Payment Inquiry SB004 Account Closing Balance Information Module Name General Ledger Fast Path Description 1094 GL To GL Funds Transfer Request 1321 Close Out Withdrawal by GL 6312 ODC Against GL Accou
27. 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 Sequence SPLOIC SPLOIC stands for S Service Charge arrear P Penalty arrears L Legal fees O Outgoing type of arrear I 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 RVT Relationship Value Tagging ORACLE S Schedule The repayment plan for an account 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 r
28. 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 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 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 ORACLE 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 Path BAMOS so e To access the option type the Fas
29. button 2 The system displays the Authorization Required message box Microsoft Internet Explorer u Authorization Required Do you want to continue 3 Click the OK button 4 The system displays the Authorization Reason screen ORACLE Flexcube Authorization Dual control Hold Funds Present Refer to Drawer Account would Overdraw Account Number 000000007260 Available Balance After Transaction 400 40 Local O Remote Supervisor ID Primary Password Reason Comments ONO 9 Select the Remote option The system displays the list of supervisors Click on the appropriate supervisor The system displays the message Transaction Sent For Authorization Click the Ok button 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 2 Navigate to the Centralised Authorization screen using the fast path 4501 Transactions to be authorized can be filtered by entering one or more of the following a From Branch and To Branch b Mnemonic ORACLE c Customer ID d Account No e Teller ID Centralised Authorisation From Branch 0782 UNIT To Branch fraa Higher
30. click the sequence number in the Seq No column 7 The system displays the relevant screen ORACLE h Deposit amp W x Account No 60000001756440 enay Account Coy LTL Txn Cey LTL Account Cry Rate 1 00000 Txn Ccy Rate 1 00000 Customer Type Self Customer Category In Customer Status Bank Notes 100000 Litas Coins 0 Centas Coins 0 Total Amount Account Amount Txn Amount Value Date User Reference No Narrative Cash Deposit d h Pin R Denomination Instrument Inventory Pin Validation Service Charge Signature Travellers Cheque Gun oe vew mr 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 nn x Amount 100 000 00 10 Click Ok button The system displays the authorization screen ORACLE Oracle Flexcube Authorization 11 Enter the relevant information 12 Click Grant button for record authorisation ORACLE Centralised Authorisation Centralised authorisation is a security enhancing setup which can be enabled in Oracle FLEXCUBE for providing additional authoriza
31. displays the account number of the customer Display This column displays the description for the product Display This column displays the account currency Display This column displays the amount which is financed Display This column displays the actual disbursed amount Display This column displays the total outstanding amount Display This column displays the booking date or loan commencement date Display This column displays the date on which the first disbursement taken ORACLE Column Name Description Maturity Date Display This column displays the maturity date for loan Account Status Display This column displays the account status User DefinedStatus Display This column displays any user defined status Syndicated Loan Details Branch Code Product Code Account No Description Currency Amount Financed Amount Disbursed Outstanding Amount Book Date Value Date Maturity Date Account Status User DefinedStatus Search Trade Display This column displays the branch code of the contract Display This column displays the product code Display This column displays the account number of the customer Display This column displays the description for the product Display This column displays the account currency Display This column displays the amount which is financed Display This column displays the actual disbursed amount Display
32. 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 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 ORACLE The system displays the Search Electronic Journal screen Select the Teller ID from the pick list Click the Remote Authorisation option i e ON Click the Fetch button The system displays all the transactions sent by the teller for authorization Teller ID ALL E Electronic Journal Remote Authorization Branch Posting Date 55 04 2008 Host Process Date 30 04 2008 Account No From Sequence No 1 To Sequence No From Txn Time 00 00 00 To Txn Time From Amount 0 00 To Amount Mnemonic Bi Incomplete Transactions 7 Remote Authorized Transactions 7 1 1356 10 000 00 SDEVTD3 2521 15 1006 56 00 TDEVIDEA1 2563 2001 CHOSO 0 00 TDEVGL1 387 2002 CHOSO 0 00 TDEVGL1 387 5001 7115 0 00 TDEVCASAZ 2505 5003 7115 0 00 TDEVCASAZ 2505 Fr rd Change Pin heq t Rat Instrument Inventory Si Signature Card Cheque Cost Rate el ion in Validation 5 ge rav ces 6 Double
33. further processing Teller resubmits the approved transaction from the Electronic Journal for transactions sent for remote authorization 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 Teller resubmits the approved transaction from the Electronic Journal and completes the transaction If auto authorization is enabled Step Activity By Activity Description ORACLE Step Activity By Activity Description A 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 B Supervisor Supervisor approves the transaction using local authorization or remote authorization If local authorization is provided system proceeds for further processing C Teller System encounters reasons requiring central authorization Teller sends the transaction for central authorization D Supervisor Supervisor access the Central authorization transaction and authorizes the transaction waiting for authorization Teller Activities 1 Enter the relevant information in the transaction screen and click the Ok
34. maturity Display This column displays the sum total of all active principal liens on the deposit Display This column displays the status of the deposit Status of the deposit can be ACCOUNT OPEN REGULAR ACCOUNT MATURED etc Display This column displays the relationship of the customer with the account ORACLE Search RD CASA Term Deposit FE 046 proiesion r Account Details Account No Product Currency Branch Available Bal eten Maturity Date Account Status Account Rel 5040000000441112001 RD FLOATING PENINR 240 SANDOZ 2 500 00 2 500 00 02 09 2017 ACCOUNT OPEN REGULAR SOW 4 240 SANDOZ 2 000 00 2 000 00 02 09 2018 ACCOUNT OPEN REGULAR SOW INR Total 4 500 00 Field Description Column Name Description Account No Display This column displays the account number of the customer Product Display This column displays the code and name of the product under which the customer has an account Currency Display This column displays the currency assigned to product under which the account is opened In case the customer has accounts in multiple currencies then the accounts have to be ordered as per the currency and the total of the balances is displayed for each currency Branch Display This column displays the code and name of the home branch under which the customer has an account Available Bal Display This column displays the available balance of the RD account Installment
35. of interest at the time of TD booking CRR Credit Risk Rating D 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 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 A 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 ORACLE 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 E Early Settlement 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 hou
36. product to all customers thereby ensuring that all customers are offered the same uniform services ORACLE Modular yet Integrated The various functional blocks of Oracle FLEXCUBE are built on the 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 emp
37. system displays the Account Transactions Inquiry Fast Path LNM10 option Account 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 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 2 The system displays the Advance Search screen Search Advance Search r Search Criteria Customer Id Short Name ATM Card Number Refined Search Account No NLS Name Customer IC IBAN Mobile No Date of Birth Home Phone Date Incorporated Currency Es se co Search Results 38 record s found Customer IC CIFO1 CIFO3 ICIFO4 CIFO5 CIFO6 CCFCDB CUS2 CUST12 MEMOTEST TESTMANN 603910 603911 603912 603913 603915 603926 603950 603995 604059 604065 Customer ID Full Name MANMEET CIFO1
38. the centralized operations for invoking a manual download of an entity or entities to the branches 1 Select the appropriate Entity from the pick list 2 Select the appropriate location from the drop down list 3 Select the destination branch from the drop down list to which you want to download the product 4 Click the Download button The system downloads the product to the respective branch ORACLE ORACLE ORACLE Version Number ORACLE FLEXCUBE Core Banking India Release11 6 0 0 0 ORACLE Glossary A 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 AQB Average Quarterly Balance Back to back loan The loan against TD BCL Business Line of Credit C Cash pooling The salient features are 1 It is a multi tiered sweep 2 Accounts will be grouped
39. the transaction screen ORACLE 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 the inventory details ORACLE 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 See Account Cecy INR Acct Coy Rate 10 Acct Coy Cost Rate Txn
40. the user has logged into the system and selected a transaction from the menu or entered a fast path the system will display the following Conventional User Interface Menu Bar Product Logo 7 Login Info TE DEMO BANK Header Fast Path Customer Search Tree Menu Central Workspace Frequently Used Transactions Pending Transactions 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 ORACLE 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 e Menu Bar Menu bar contains certain options as shown in the following table Menu Description 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
41. 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 ORACLE 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 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 A 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 Sweep in provider account and funds will be swept to the beneficiary target account Contracted interest rate Rate
42. unique method of customer identification 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 IC 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 such as tax applicable SC charges etc are levied based on the customer type Display This column displays the date of birth of the customer D
43. 068 7106 8051 AC014 AC040 BA437 BAM69 CHO21 CHO070 CHM08 CHM21 CHM24 CHM38 Description Account Capitalization History Inquiry Amortization Inquiry Account Image Display CASA Account Opening 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 ORACLE Fast Path BAMO6 CHM45 CHM51 CHM55 Cl142 CIM28 SCM08 5004 CH078 CHM35 CHM37 CH066 CHM06 CHMO7 Description Direct Debit Registration Account Master Attributes Maintenance 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 ORACLE Fast Path 1401 1822 2822 1408 1411 1421 1429 1803 1908 6501 6601 BAM21 ST070 1001 Description Cash Deposit Cash Deposit FW FCR Cash Deposit UBS Miscellaneous Customer Credit Future Dated Cash Deposit RD Installment Payment by Cash Flexible RD
44. 1 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 r 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 Customer Search This option allows you to search for account information based on customer details A list of accounts belonging to the customer is displayed 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 ORACLE 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 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 Wild 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
45. Account Opening Home Cash Deposit Home Cash Withdrawal CASA Billing Transaction CASA External Banking Facility Online Trading Hold Inquiry Cheque Mandate Maintenance CASA Tax Deduction Inquiry BAC Master Maintenance ORACLE Fast Path 5056 Cl142 CH043 Description Statement Request Customer Account Relationship Maintenance Fund s Projection Module Name Time Deposit Fast Path 1337 TD029 TD039 7020 TD023 TD030 TDO31 TD037 TD040 TDO41 Description TD Interest Payout Inquiry TD Interest Adjustments TD Multiple Payout Instructions TD Balance Inquiry TD Rates History Inquiry External Lien History Inquiry TD Audit Trail Inquiry TD Account Ledger Inquiry TD Maturity Amount History TD Deposit Certificate Inquiry ORACLE Fast Path TD042 TD050 TDO70 TDMO7 1007 1021 1356 1358 1310 1312 1318 1402 1316 TDS03 Description Interest and Principal Payment History TD Interest Inquiry Discounted Time Deposit Inquiry Investment Calculator Quick Payin By CASA 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 ORACLE Fast Path Description TDS10 TDS Remittance TDS11 TDS Inquiry TDS12 Tax Recovery TDS14 TD Tax Refund TDS15 Inquiry on Projected Tax 8054 Time Deposit
46. Coy INR Txn Ccy Rate 10 Txn Ccy Cost Rate Field Description Field Name Description Account Display Ccy 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 ORACLE Field Name 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 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
47. Oracle FLEXCUBE Core Banking Introduction User Manual Release 11 6 0 0 0 Part No E65544 01 October 2015 ORACLE ORACLE Introduction User Manual October 2015 Oracle Financial Services Software Limited Oracle Park Off Western Express Highway Goregaon East Mumbai Maharashtra 400 063 India Worldwide Inquiries Phone 91 22 6718 3000 Fax 91 22 6718 3001 www oracle com financialservices Copyright 2015 Oracle and or its affiliates All rights reserved Oracle and Java are registered trademarks of Oracle and or its affiliates Other names may be trademarks of their respective owners U S GOVERNMENT END USERS Oracle programs including any operating system integrated software any programs installed on the hardware and or documentation delivered to U S Government end users are commercial computer software pursuant to the applicable Federal Acquisition Regulation and agency specific supplemental regulations As such use duplication disclosure modification and adaptation of the programs including any operating system integrated software any programs installed on the hardware and or documentation shall be subject to license terms and license restrictions applicable to the programs No other rights are granted to the U S Government This software or hardware is developed for general use in a variety of information management applications It is not developed or intended for use in any inherently d
48. The UDF in classic format Other Transactions User Defined Fields An alternative UDF format r ge Click on the appropriate UDF to enter the additional details Session Auto Expiry ORACLE 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 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 F bent show this dialog again in current session 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 e KEY pe BODY OF RECORD Bank code is a
49. account A document plan can be linked to one or more products ORACLE Fast Path ORS41 BA316 BA317 BA318 BA431 BA435 BA436 BA456 BA524 BAMO2 BAM17 BAM20 BAM59 BAM60 Description Document Code Maintenance Village Master Centre Master Group Code Master LOB Master Branch Product Cross Reference Line of Business LOB Branch Cross Reference BAO Inquiry screen Product Code Product Type Cross Reference Local Office Master Maintenance Branch Type Maintenance Bank Codes Maintenance Branch Restricted for Online Registration for Net Banking Product Category Maintenance may Line of Business ORACLE Fast Path BAM61 BAM62 BAM68 BAM71 BAM72 BAM75 BAM85 BAM88 BAM92 CHM59 CIM58 STM20 BA101 BA441 Description Account Officer Maintenance Screen Customer Account AO LOB X Ref Islamic Product Attributes Category Master Maintenance Customer City master Maintenance State Codes Maintenance Region Codes Maintenance Branch Attribute Maintenance Department Master Maintenance Hold Type Maintenance Picklist Master Local Bank Codes Maintenance Custom Functions Maintenance Global Site Maintenance 15 Account Officer ORACLE Fast Path BA453 BAM05 BAMO7 BAM40 BAM78 BAM79 BAM81 BAM83 BAM89 BAM91 BAM98 BAM99 ECMO1 LNM27 Description Parameterized Out
50. ance Cluster Maintenance Download Log Download Service Upload Local File File Upload Status Inquiry Upload Account Balance File ORACLE Fast Path BA450 BA452 BAM53 BAM54 BAM94 BAM96 CHM43 ST043 ST044 1005 1060 1460 1905 Description Generic External File Upload GEFU 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 Miscellaneous GL Transfer GL Miscellaneous Debit Against Cash GL Miscellaneous Credit Against Cash Cross Cost Center Miscellaneous GL Transfer Dr Cr a 21 Generic External File Upload It is the file extract given out from FLEXCUBE to other software ORACLE Fast Path Description 9019 Transfer Stocks IV001 Stock Transaction IV002 Stock Adjustment IV011 Stock Inquiries 7011 Event Log Inquiry 752 Reset Primary Password 753 Enable Disable Users 755 Modify Login Status 756 User Prohibited Password 757 Inquiry for Logged in Users 758 Inquiry for Password 766 Secondary Password Expiry Date 767 Reset Secondary Password 768 Change Primary Password ORACLE Fast Path 769 AT002 BA777 BAM04 BAM10 SM11A SMMO2 SMM03 SMMO9 SMM12 SMM13 SCMO2 SCM03 SCM05 Description Change Secondary Password Audit Trail Inqui
51. angerous applications including applications that may create a risk of personal injury If you use this software or hardware in dangerous applications then you shall be responsible to take all appropriate failsafe backup redundancy and other measures to ensure its safe use Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws Except as expressly permitted in your license agreement or allowed by law you may not use copy reproduce translate broadcast modify license transmit distribute exhibit perform publish or display any part in any form or by any means Reverse engineering disassembly or decompilation of this software unless required by law for interoperability is prohibited The information contained herein is subject to change without notice and is not warranted to be error free If you find any errors please report them to us in writing This software or hardware and documentation may provide access to or information on content products and services from third parties Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third party content products and services Oracle Corporation and it
52. ansaction 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 procedure 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 ORACLE Transaction Screen The tree menu access path 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 tab 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 Mandatory Optional Conditi
53. ar balance of the account Account Status Display This column displays the status of the account The status of the account can be ACCOUNT OPEN REGULAR ACCOUNT OPEN NO CREDIT ACCOUNT OPEN NO DEBIT etc Closed accounts should not be displayed Classification Display Status This column displays the classification status of the account For asset type of products the classification status of the account which is derived based on the CRR code should be displayed Account Rel Display This column displays the relation of the customer with the account Search Term Deposit casa Account Details 3 Uncollected Uncollected Account No Deposit No Product Currency Branch Principal Balance Maturity Date Rate of Interest Principal net Lien Amount 1005 Payout at maturity INR 240 SANDOZ 50000 31 08 2017 22 0 00 0 00 0 00 ACCO 1005 Payout at maturity INR 240 SANDOZ 1500 30 08 2017 22 0 00 0 00 0 00 ACCO 1012 FD Bimonthly IntereINR 240 SANDOZ 100000 30 08 2017 22 0 00 0 00 1 00 000 00ACCO 503000000042142 1012 FD Bimonthly IntereINR 240 SANDOZ 1000 30 08 2017 22 0 00 0 00 0 00 ACCO INR Total 0 00 0 00 Deposit Status Account Rel gt ACCOUNT OPEN REGULAR SOW ACCOUNT OPEN REGULAR SOW ACCOUNT OPEN REGULAR SOW ACCOUNT OPEN REGULAR SOW Credit Risk Rating ORACLE Field Description Column Name Description Account No Display This colum
54. aring Type Local 3 day float v Cheque No 1 Cheque Literal Local Cheque Deposit v Chi Date Bios que Date lzom3r2000 ES Routing No fronts Bank 100 Canara Drawer Acct No 000000002220 Branch 1001 CANARA1 Value Date jo1josj2008 Sector 201 Java Late Clearing N Chg Commission Yes vi Instr Sub type 00 Crossed Cheque v 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 ORACLE Field Name Description Cheque No 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 dupli
55. b 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 Transaction Information ORACLE 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 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 E Add By Copy Add a new re
56. cate instrument If duplicate instruments are found cheque deposit will be rejected unless the earlier cheques are all marked as Returned Cheque Literal Mandatory Drop Down Select the cheque literal from the drop down list Cheque Date 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 Routing No 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 number 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 It is the number printed on the cheque also called MICR number Magnetic Ink Character Recognition This number facilitates faster clearance of the
57. ce Insurance Xref Maintenance CASA Multi Currency Product Package Definition Insurance Claim Status Interest Index Maintenance Interest Index Rates Loan Product Rates Plan Interest Rules Product Interest Attributes Maintenance Rate Change ORACLE Fast Path LNM88 IVMO1 IVMO2 IVMO3 IVMO4 SBMO1 BAM55 BAM73 LMBO1 LMCO1 LMCO5 LMRO1 LMSO01 LMS02 Description Loan Product Repricing Revision Maintenance Stock Codes Supplier Codes Inventory Control Branch Cross Reference Maintaining Stock branch Cross Reference Safe Box Product Inventory Cross Reference Channel Limit Maintenance Bank Customer Limit Maintenance Bank Limit Setup Customer Limit Setup Multi limit Plan Setup Credit Concentration And Exposure Limits Maintenance Limit Inquiry Bank Network Maintenance ORACLE Fast Path LMS03 LMS04 LMS05 LMS07 LMS08 LMS09 BA655 BAM44 LNM11 LNM18 LNM22 ORS25 ORS35 Description Limit Manual Transfer Limit Transfer Rule Multi limit Plan Setup Casa Loan Account Exemptions Customer Regulatory Information Loan Convertability Option Calendar For Loan Rescission TD Maturity Reminder Plan Maintenance Product Master Maintenance Loan Bank Parameters Maintenance Loan Plan Deduction Maintenance Producer Setup Document Plan Code Maintenance It is a plan for listing the documents to be collected from an
58. 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 ORACLE 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 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 000000030775 Emar SINGH Account Cey INR Txn Cey INR Ml Acct Coy Rate 100006 Txn Cey Rate D
59. cord with the features of an existing record O add Add a new record O Modfy Modify a record The user can modify the record after authorization All fields which do not form a part of the key field can be modified O Delete Delete a record The user can delete the record after be authorization The record is deleted from the system and cannot be accessed Cancel Cancel a record The user can cancel the record before an J 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 record can amend it before authorization These amendments shall be taken into consideration when the supervisor authorizes the record PS een O Authorize Authorize a record The user who has specific access rights can authorize the record ORACLE Click To O Inquiry View the authorized records zA 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 Li this to view the help related to a particular screen Close Click x to close the current screen Type of fields Information is entered
60. ct name like FLEXCUBE FLEXCUBE Retail and FCR are implied as Oracle FLEXCUBE This document is not warranted to be error free nor subject to any other warranties or conditions whether expressed orally or implied in law including implied warranties and conditions of merchantability or fitness for a particular purpose We specifically disclaim any liability with respect to this document and no contractual obligations are formed either directly or indirectly by this document This document may not be reproduced or transmitted in any form or by any means electronic or mechanical for any purpose without our prior written permission Oracle is a registered trademark of Oracle Corporation and or its affiliates Other names may be trademarks of their respective owners ORACLE IS THE INFORMATION COMPANY Downloading Procedure Fast Path 8892 Once an entity is defined in the FLEXCUBE Retail you need to download the entity to the respective branch using the Data Download option The user with specific access rights can download the product When the automatic download is enabled the system will automatically download the entity entities at the pre configured time provided the link to the branch server is up at that time In case the link is down at the time of download the download process will create an output file in a pre designated directory in the FLEXCUBE application server The following procedure needs to be followed by the operator at
61. d only for the accounts where the customer holds a primary relationship Display This column displays the beneficiary account for the SI or Loans Drawdown instructions Display This column displays the transaction details The transaction details is the nature of the instruction or the narrative that is provided during SI setup In case of loans drawdown instruction Loans Drawdown should be displayed Display This column displays the debit credit flag If the Account Number field is a beneficiary then this flag will display Dr ORACLE Column Name Description Amount Display This column displays the outflow inflow amount as per the instruction In case of Loans Drawdown the outstanding amount as per the schedule plus the unpaid arrears if any need to be shown 4 This column displays the date of the execution of the customer instruction The range of such instructions displayed will be 1 month from the current date 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 Client Profile If the user clicks on this option the system displays the Customer Information Master Maintenance Fast Path CIMO9 option Statement If the user clicks on this option the system displays the Statement Inquiry Fast Path CH031 option Account Profile If the user clicks on this opt
62. 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 or lt Enter gt to move clockwise from one field to another or lt Shift gt lt Tab gt to move counter clockwise T 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 ORACLE 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 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 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 ORACLE Frame Sex O Male O 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
63. dpoint 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 ORACLE Field Name Description Late Clearing Display This field displays the values Y or N for late clearing The options are e Y Ifthe 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 type 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 butt
64. e Authorized Batches STO60 Immediate Credit ST061 Float Extension ST066 Cheque Status Inquiry STO72 Global Float Extension STM62 Late Clearing Inquiry STM63 Late Clearing Marking Maintenance 1009 TC Sale Against Account 1025 Bill Payment 1026 Advance Payment against Credit Card ORACLE Fast Path 1409 5511 6575 7782 7783 8003 8004 8203 8204 8205 8301 8302 8305 8306 Description TC Purchase Against Account Consolidated Remittance Data Entry Batch Bill Payment By Cheque Duplicate BC Print Duplicate DD Print TC Purchase Walk in Customer FX Purchase Walk in FX Sale Walk in TC Sale Walk in Customer TC Sale Against GL Banker s Cheque Sale Against Cash BC Issue Against GL DD Sale Against Cash DD Sale Against GL ORACLE Fast Path 8307 8309 1833 2833 8310 1838 2838 8314 8315 8316 8317 8319 8322 8324 Description BC Liquidation Inquiry BC Liquidation BC Liquidation BC Liquidation Against A c UBS DD Liquidation DD Liquidation DDLiquidation BC Status Inquiry DD Status Inquiry TT Issue Walkin TT Issue GL TT Liquidation TT Lost Status Inquiry BC Revalidate ORACLE Fast Path 8325 5525 EC004 8326 CHO71 STM73 STM75 EC005 Description DD Revalidate Remittance Printing Scanning of ECS Passed Rejected Records Unclaimed BC DD Status Inquiry
65. e operations ORACLE 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 Fred Descripton Field Name e amar aemp enaa bis EE roh mandatory Searc Criteria Entities to be The defined description of the fields Definition Prerequisites 8053 Customer Addition Modes available for maintenance Modes Available Add Modtty Delete Inquiry For more nfomaton on the procedures of every mode eter to tandard Maintenance Procedures in CIMI7 and cick Go or navigate through the menus 10 Transaction tomer Transactions gt Corporate Customer Details 3 the Corporate Customer Details screen The procedure Corporate Customer Details a Transaction Screen Full Name 4 Select tne search crtena tomine drop down ist 5 Type the search stang and press the lt Tab gt key and select the customer from the pick ist Option Name The name of the transaction screen A 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 that are available to maintain the transaction in case of maintenance tr
66. ected 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 gt Internal Transactions gt Inquiries gt 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 ORACLE Account No From Sequence No From Txn Time From Amount Mnemonic Incomplete Transactions Branch Posting Date 80 0472008 fel Host Process Date To Sequence No To Txn Time To Amount ooaj ES 2099 23 59 59 9 999 999 999 999 99 Remote Authorized Transactions 7 6 1401 18 47 01 06049420000012 INR Incomplete 1 000 00 TSRINIYASA 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 8051 18 39 45 06056900000019 Sent 0 00 TSRINIVASA Click to print 2 8053 12 24 50 Sent pes 0 00 TSRINIVASA Click to print 1 9001 17 53 26 Success 0 00 TSRINIVASA Click to print FE Card Change Pin Cheque Cost Rate Denomination Instrument Inventory Pin Validation Service Charge Signature
67. efinition User Manual e Customer Information System Customer Information definitions are explained in the Definitions User Manual Customer Information maintenance s are explained in the Customer Information File User Manual e Management Information System e Reports ORACLE 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 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 ORACLE Consumer Lending Suite Retail Loan Accounts Loan definitions are explained in the De
68. emittance Tax Absorb Account Maint TD Interest Adjustments TD Account CBR Codes Mai gt Transfer gt Remittance gt SDB Account Transactions gt CASA Account Transactions gt Payment Transactions gt Walkin Transactions Collection Transactions gt Customer Transactions gt Internal Transactions gt Global Definitions ORACLE e The system displays the transaction screen in the Central Workspace as shown in the following figure Fast Path T0024 Search Criteria Customer Short Name v Search String ARE Customer Name Customer ID Clear Advance Recovery From CASA Recovery From GL Transaction Processing CASA Account No GL Account Workflow Transactions GL Transactions Account Transactions Loan Account Transactions TD Account Transactions gt Cash gt Inquiries Other Transactions W TD Tax Refund TD Post Maturity Renew Lien Master Maintenance D Tax Waiver W Backdated Interest Rate C TD Block Unblock Account gt TD Multiple Payout Instruct Tax Acknowledgement Det W TDS Remittance Tax Absorb Account Maint P TD Interest Adjustments W TD Account CBR Codes Mai gt Transfer gt Remittance SDB Account Transactions amp CASA Account Transactions gt Payment Transactions gt walkin Transactions Collection Transactions gt Customer Transactions gt Internal Transactions amp Global Defin
69. 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 M Securities Definitions manually reconcile these GLs M Customer Definitions 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 CASA Definitions 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 TD Definitions ATDMO4 TD Bank Param Penalty applicable due to partial withdrawal can be done in two ways for all TD products at the bank level namely TDMO1 TD Product Mas A TI l l fl in l fi l FATDO60 TD Product Rate 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 Tax Definitions ae Definitions 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 Loan Definitions Penalty Interest Variance or index code as defined in Incremental Penalty Index The standard penalty routine uses the incremental method interest Ra
70. eposit No aj Int Payout Amount Tax Calculated Net Interest Payout Txn Amount User Reference No al Narrative TD Interest Payout By Cash Other Transactions User Defined Fields ok cancel If you click the User Defined Fields tab the system will display the User Defined Fields screen ORACLE Limit Breached validate 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 ORACLE Negotiate Negotiation Exchange Rate 1234 99000 Comments New Exchange Rate Resin a Er 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 arg This field displays the exchange rate after it has been negotiated You can 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 ORACLE Document Receipt This screen is displayed at the end of some transactions For example While using the Future Dated Cash Deposit Fast Path 141
71. equired 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 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 T TAN Number Tax Deduction and Collection Account Number Third Party accounts These are accounts whose records exist outside FLEXCUBE TPD A type of Education Savings account with special features U UDE User Defined Entity V VE Voucher Entry ORACLE VRU Voice Recognition Unit W Wadiah A Syariah banking Product type using depository concept Z ZBA Zero Balance Account ORACLE
72. finitions User Manual Loan maintenance s are explained in the Loan User Manual ORACLE Deposit Accounts e Savings and Current Account CASA definitions are 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 ORACLE Application Security The application security maintenance s and transactions are explained in the Back Office User Manual Order Of Usage The order of usage of the user manuals is as follows ORDER OF USAGE Oracle FLEXCUBE Introduction v Definitions M BROP 4 v 4 CIF CASA TD Loans Collections CM Payments SDB GL RP v M M M M M M STL amp CLG v Back Office Operations Bills User Manual is optional Software Requirements Production Servers Software Oracle Enterprise Linux 6 u4 Intel 64 bit Developer Oracle Database 12c Enterprise Edition Release 12 1 0 2 0 Database Server Oracle Linux 6 u4 Intel 64 bit Developer Oracle Weblogic 11G Application Se
73. g 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 J JAF Joint and First JAO Joint and Other JFAB Joint Finance Asset Buy JOF Joint Or First JOO Joint or Other L LLP Loan Loss Provisioning LO Local Office LOB Line of Business ORACLE LTS Loan Transaction Services Mudharabah A Syariah banking product type using profit sharing concept N 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 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 the total group balance c Interest Calculation on the total group account balance d Reduction of overdraft charges NPL Non Performing Loans O ODC Outward Direct Credit ODD Outward Direct Debit ODFI Originating Depository Financial Institution The financial institution that
74. hes Reconcile Outward MICR File Special Clearing Run Load Central Bank File ORACLE Fast Path 5505 5506 5606 6511 6512 6520 6602 6619 STO77 ST078 ST033 ST034 St035 ST038 Description Batch Consolidated Cheque Data Entry Batch Data Entry Outward Settlement and Clearing Batch Data Entry Outward Clearing Consolidated Cheque Deposit Consolidated Cheque Batch Data Entry Cheque Deposited To GL Postdated Cheque Data Entry Batch Postdated Cheque Cancellation Postdated Cheque Discounting Postdated Cheque Discounting Cancel Inward Clearing Process Scanning Rejected Instrument Scanning of Passed Instrument Bulk Scan Inward Rejects ORACLE Fast Path ST062 ST075 ST076 ST099 6565 6566 6806 5522 8323 BA990 ST067 ST074 STM57 STM71 Description 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 Batch Micr SrinoXref Data Entry Maintained Issued Instruments Clearing Inquiry Collection Purchase Inquiry Remittance Inquiry MICR Number Maintenance Unmatched DHN Blacklist Customer Deletion ORACLE Fast Path Description 7120 Late Clearing Maintenance ST001 Value Date Clearing Process ST002 Value Date Clearing Inquiry STO23 Outward Clearing ST037 Revers
75. ication CTI Customer Search Customer Name and Address Inquiry All Balance Inquiry Old New Customer Inquiry Contract Details Inquiry Offers Inquiry Create Lead Customer Service Maintenance Customer Zoom Inquiry Customer ID Verification History Inquiry ORACLE Fast Path 3000 7102 7103 7104 7105 7111 8053 CHM52 CI501 CIMO9 CIM11 CIM17 CIM23 CIM25 Description Thumb Print Interface Link Customer Image Unlink Cust Image Authorize Customer Image Display Customer Image Modify Customer Image Customer Addition Customer Document Maintenance Assisted Customer Creation Customer Master Maintenance Customer Detail Maintenance Corporate Customer Details Customer Defined Spend Class Reminder ORACLE Fast Path CIM26 CIM29 CIM85 CIM40 CIM59 CIM60 TDS05 Description Customer Instruction Maintenance Conversation Preferences Maintenance Private Banking Customer Maintenance Zengin Short Name Maintenance AML Master Maintenance Customer Contact Details Updation Customer Special Tax Code Maintenance Module Name Current And Savings Account Fast Path BA996 1320 CHO01 CHO11 7002 CH031 Description Product Transfer Maintenance Close Out Balance Inquiry Account Closing Balance Information Account Closure Inquiry Maintenance Balance Inquiry Statement Inquiry ORACLE Fast Path CH051 CH
76. 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 ORACLE Entry Fields Narrative 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 ORACLE Date Fields LN Process Date 20 03 2008 n ES 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 To select a date from a calendar in a date field follow the steps given below To select a date from the Calendar e Click EM with the mouse to activate the calendar e Oracle FLEXCUBE displays a calendar as shown below Calendar February 2008 1 2 3 4 5 6 7 8 9 105 RES ES SMS EDS SIDA MEG Be TON 090 AU 2200 4200 08 ate Zoe KZ ESS ee F9 e Click the relevant date The date gets populated in the
77. ing 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 ORACLE 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 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 ORACLE Bank Code Danamon Bank M Chq Coy IDR p Tan Cey USD M Cheque Cey Rate 4 o0000 Txn Ccy Rate
78. ing the tree menu TOC provided on the left pane and click the topic name link ORACLE 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 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 button You can also enter the text in inverted commas if you want to match the exact search criteria The search string entered 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 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 s is pee aie i 4 button The required text is highlighted and displayed in the right pane Search a p ORACLE en Seach CIM01 Signature Types Maintenance Rank_a 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 CIMO1 Signature pick list in the Customer Addition Fast Path 8053 option Types Mai
79. instrument It can be configured to have the following information Bank code Sector Branch Code ORACLE Field Name Description Bank Branch Sector Drawer Acct No Value Date Display This field displays the bank name to which the cheque belongs corresponding to the bank code extracted from the routing number 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 Display 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 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 En
80. ion Column Name Description CASA Account No Display This column displays the account number of the customer Product Display This column displays the product name and code of the product under which the customer has an account Branch Display This column displays the code and name of the home branch under which the customer has an account Currency Display This column displays the currency assigned to product under which the account is opened In case the customer has accounts in multiple currencies then the accounts have to be ordered as per the currency and the total of the balances to be displayed for each currency ORACLE Column Name Description Available Bal 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 the 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 Book Balance Display This column displays the book balance of the account Unclear Funds Display This column displays the uncle
81. ion the system displays the Account Master Maintenance Fast Path CH021 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 ST066 option 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 ORACLE 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
82. ions 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 entities 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 ORACLE Functional Overview gt Common Facilities 4 oN 1 p Consumer Lending Suite 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 ORACLE Core Modules e Clearing Clearing definitions are explained in the Definitions User Manual Clearing maintenance s are explained in the Settlement and Clearing User Manual e General Ledger GL Definitions are explained in the D
83. isplay 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 in 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 Search ORACLE Customer Details a Photo Signature Funds Projection Account Details Account No Product Currency Branch Available Bal Book Balance Undear Funds Account Status Classification Status 5010000000344810002 Savings Account AINR 240 SANDOZ 0 00 0 00 0 00 ACCOUNT OPEN REGULAR NORMAL INR Total 0 00 4 gt 1 Al 4 Double click 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 a new search Appendix of Fast Path Module Name Definitions Fast Path Description ACMO1 Asset Classification Global Parameters ACM02 Asset Classification Preferences ACMO3 CRR Codes Maintenance ACM04 Product CRR Codes Maintenance ACMO05 ae Asset Classification Plan Maintenance ACMO06 Automatic Write off Bank Parameter Maintenance Credit Risk Rating ORACLE Fast Path
84. isplays the premium currency Display This column displays the option premium Display This column displays the pay date of the premium Display This column displays the type of transaction that is Buy or Sell Display This column displays the tenor for the sale deed Display This column displays the booking date Display This column displays the booking value date for transactions Display This column displays the maturity date Display This column displays the type of transaction done Exchange Traded Derivatives Portfolio Details Portfolio Reference Portfolio Description Fund Id Fund Projection Display This column displays the portfolio reference number Display This column displays the portfolio description Display This column displays the fund Id ORACLE Fast Path Customer Details SELECTED CUSTOMER Photo Signature CASA r Funds Projection Account Number Details Beneficiary Transaction Details Dr Cr Amount Date 1 1 Field Description Column Name Description Fund Projection Details Account Number Beneficiary Transaction Details Dr Cr Display This column displays the account number of the customer This account can either be a provider or beneficiary for an SI The details fetched will be in lines of the screen CH043 Fund s Projection The details can be fetche
85. itions Record Details Input By Authorized By Last Mnt Date Last Mnt Action Authorized 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 transaction which are used on a frequent basis You can drag and drop the transaction from the tree menu in M Click My Transaction to view the screens which you have added You can select the check box adjacent to the option name and click Ill to delete the option from My Transaction ORACLE Customer Id Advance gt Customer Addition PI Safe Box Allotment C Blank Cards Request ORACLE 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 authorization 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 li
86. 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 the screen each of the record inside Oracle FLEXCUBE has some additional fields to be used a by the namely Srno FieldName Name Description Flg mnt status Maintenance Status Can be A for Flag Authorized or Null Cod mnt action Maintenance Action Code Dat last mnt Last Maintenance Date NM Cod last mnt makerid Last Maker ID ORACLE Cod last mnt chkerid Last Checker ID BS For example the standard procedures for the Bank Codes Maintenance option are as follows To add a bank code by copy Select the Add mode Select the Add By Copy check box Type the existing bank code and press the lt Tab gt or lt Enter gt key The system displays the details of the bank code which is already maintained Modify the required fields and click the Ok button Oy Qb NS The system displays the message Record Added Authorisation Pending Click Ok to Continue To add a bank code 1 Select the Add mode Type the bank code and press the lt Tab gt or lt Enter gt key
87. l Services Software Limited All rights reserved arning This software is protected by Indian and International Copyright Laws Unauthorised reproduction or distribution of this software product or any portion of it may result in severe civil amp criminal penalties and will be prosecuted to the maximum extent possible under law e Click the Click here to login link e Oracle FLEXCUBE displays the login screen as shown in the following figure ORACLE TL DEMO BANK 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 e 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 Product Features e 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
88. list 3 The system displays the bank code details 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 Type the account number and press the lt Tab gt or lt Enter gt key 2 Select the Txn Ccy from the drop down list and type the Txn Amount and click the Ok button 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 DO S 9 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 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 Autho
89. loyment 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 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 applicat
90. lphanumeric 30 Type the Customer IC of the customer Optional Alphanumeric 20 Type the short name of the customer Optional Alphanumeric 40 Type the last name of the customer Optional Alphanumeric 34 Type the IBAN All the accounts which belongs to the IBAN entered are displayed Optional Alphanumeric 16 Type the valid ATM card number of the customer 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 is IBAN The currency details are maintained in the Currency Codes Maintenance Fast Path BAM56 option ORACLE Field Name Search Result Customer IC Customer ID Full Name Customer Type Date of Birth Mobile No Home Phone Home Branch Postal Address Description Display This column displays the identification code of the customer A customer IC along with customer type is a
91. ls of CASA ac count whenever ALT I is pressed while accessing any CASA scr een Ares Monthty Balances Se APE AB l OS OG OG ON YTD Value Dipectn Balance Corcactae bats Alert Seose he Deret Accor Maite State Engi Stat Fag Date AMG Dete AMS Date 28 Do ana Daes are Oates ANE Date 8 Deve AVS Cotes AMO Da Last 3H No Last JH Value Decanos Central Bank Reporting ORACLE Hot Screen Descripti Image Ke Name on ys AE Leon LL Oomer Contact couts wasan O OO OOOO O E er screen Contact displays Prem Coneacttie Details the more Office enti ee Updatio contact Mea no 3920875358 enal iD nen con n details for ee si sec Marta Stat peated On the ares i selected customer ID Fast Path CIM60 whenever ALT E is pressed while accessing CIM39 CI141 CIM13 and CIM11 screens Record Details put By Atrorses Br Last Nnt Date Last M At Ceete ceed Arent Artene O 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 Typographical Conventions This Represents Bold Transaction Screen Name Field Names Check Boxes Button Names Prod
92. mber Description Display This column displays the auto liquidate for corporate actions Display This column displays the account number Display This column displays the short position allowed flag Display This column displays the accrue withholding tax for coupons Display This column displays the bankers acceptance flag Display This column displays the contract reference number Display This column displays the type of transaction that is Buy or Sell Display This column displays the In currency Display This column displays the In principal amount Display This column displays the Out currency Display This column displays the Out principal amount Display This column displays the booking date Display This column displays the value date for transactions Display This column displays the maturity date Display This column displays the type of derivatives Display This column displays the contract reference number Display This column displays the transaction currency Display This column displays the contract number ORACLE Column Name Description Contract Amount Strike Price Primary Currency Option Premium Premium Pay Date Buy Sell Tenor Book Date Value Date Maturity Date Type Display This column displays the transaction amount Display This column displays the strike price Display This column d
93. 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 to amend 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 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 authorize the bank code 1 Select the Authorize mode 2 Type the bank code and press the lt Tab gt or lt Enter 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 ORACLE 1 Select the Inquiry mode 2 Type the bank code and press the lt Tab gt or lt Enter gt key or select it from the pick
94. mn displays the maturity date for loan Display This column displays the account status Display This column displays any user defined status Display This column displays the branch code of the contract Display This column displays the product code Display This column displays the account number of the customer Display This column displays the description for the product Display This column displays the account currency ORACLE Column Name Description Amount Financed Display This column displays the amount which is financed Amount Disbursed Display This column displays the actual disbursed amount Outstanding Display Amount Book Date Value Date Maturity Date Account Status User DefinedStatus Leasing Branch Code Product Code Account No Description Currency Amount Financed Amount Disbursed Outstanding Amount Book Date Value Date This column displays the total outstanding amount Display This column displays the booking date or loan commencement date Display This column displays the date on which the first disbursement taken Display This column displays the maturity date for loan Display This column displays the account status Display This column displays any user defined status Display This column displays the branch code of the contract Display This column displays product code Display This column
95. mo Description 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 Display This field displays the customer ID 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 gender of the customer Display This field displays the category of a customer For Example Individual Corporate etc Display This field displays the branch Code and short name of the branch Display This field displays thethe mobile number of the customer Display This column displays the the email address of the customer Display This column displays the Aadhaar number of the customer Display This field displays the date on which Aadhaar Number has been updated Display This field displays the CASA Account linked to Aadhaar
96. n displays the account number of the customer Deposit No Display This column displays the deposit number of the account The active deposits of the account should be displayed in ascending order of deposit number Product Display This column displays the code and name of the product under which the customer has an account Currency Display This column displays the currency assigned to product under which the account is opened In case the customer has accounts in multiple currencies then the accounts have to be ordered as per the currency and the total of the balances is displayed for each currency Branch Display Principal Balance Maturity Date Rate of Interest Uncollected Principal Uncollected Interest Lien Amount Deposit Status Account Rel This column displays the code and name of the home branch under which the customer has an account Display This column displays the principal balance of the deposit Display This column displays the maturity date of the deposit Display This column displays the rate of interest of the deposit In case of floating rate deposit the latest applicable rate is displayed Display This column displays the uncollected principal in case of matured deposits which have no instructions Display This column displays the uncollected interest in case of matured or active deposits which are payout type but there is no instruction maintained for interest payout or
97. nquiry BA460 Loan Employee Account Inquiry BAM49 Reminders History Inquiry LNO50 Loan Billing Transactions Module Name Collections Fast Path Description CLN26 Follow up Main Form CLN28 Authorization by Supervisor CLN29 Exception Case Marking ORACLE Fast Path CLN30 CLN32 CLN33 CLN34 CLN35 CLN37 CLN50 CLN55 CLN62 CLN63 CLN64 CLN70 Description Group Follow Up Reallocation Collectorwise Reallocation Queuewise Reallocation Individual Temporary Re Allocation Re queue Search Query List Follow Up Initiate Repossession Collateral Auctioning Collateral Disposition Customer Sticky Notes Module Name Card Management Fast Path CMO1 Description Card Maintenance ORACLE Fast Path Description CMO2 Blank Cards Request CMO3 Card Status Change CM04 Card Activation CMOS Card Unblocking CMO06 Blank Cards Inventory CMO7 Card Master Setup CMO8 Card Account Product Link Setup CM09 Card Maintenance CM10 Card and Random Number Status Change CMS01 Card Maintenance Module Name Payments Fast Path Description 2030 Outgoing Payment Transaction Initiation 2031 Outgoing Payment Transaction Message 2032 SWIFT Outgoing Payment Message ORACLE Fast Path 2035 2037 2039 2041 2042 PM010 PM023 PM025 PM026 PMO27 PMO30 2055 2056 2057 Description Domestic Outgoing Payment Initiation Credit Card SEPA
98. nt GLMO1 Voucher Entry GLMO2 Chart of accounts GLMO3 MIS Class Maintenance GLM04 GL Transactions and Movements Inquiry GLM13 Period Code Maintenance GLM17 GL Parameter Definition Outward Direct Credit ORACLE Fast Path GLM20 GLM35 GLM36 GLM37 GLM50 Description Enterprise GL Cross Reference Maintenance Implemented GL Cross Ref GL Posting Flag Maintenance GL Cost Centre XRef Maintenance Oracle GL Transactions Inquiry Module Name Relationship Pricing Fast Path CH067 CIM50 CIM51 CIM52 RLOO1 RL002 RLO10 RPO01 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 Rule Debug Maintenance Scheme Definition Maintenance ORACLE Fast Path RP002 RP003 RP004 RP010 RPO11 RP015 Description Eligibility Criteria Maintenance Benefit Plan Maintenance Interest Variance Package Maintenance Eligibility Scheme Linkage Customer Scheme Linkage Eligibility Debug Maintenance Module Name Branch Operations Fast Path 6006 6010 7008 7012 7015 7017 7040 Description Search Electronic Journal View Teller Errors Last Ten Transactions Account Number Check Digit Inquiry Teller Transactions Summary Batch Status Inquiry Teller Totals Position
99. ntenance CIMOJ Customer Note The system automatically authorizes this transaction 2 Information Master N nn 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 CIMO4 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 Field Description 3 Click the Add button 4 Enter the signature code and the type of the signature 5 Click the Ok button 6 The system displays the message Record Authorized Click Ok to Continue Click the Ok button B toc Search E Glossary Use of other tools available on the help header Back Click the button to return to the last help page you viewed ORACLE Forward Click the 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 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 ORACLE Structure of User Manual Doc
100. omer grid and click the Find button or click Advanced Search Customer Details Pa 603900 4 customer Memo Card 1000002 1 Memo for Ram Singh by Court owes RAM SINGH MALE INDIVIDUAL 0 a 240 SANDOZ MUMBAI customer Instructio 9819089266 Photo Signature E Global Definitions Transaction Processing ASA Funds Proiection E Commercial Banking amp Entity Defini Account Details Account No Product Currency Branch Available Bal Book Balance Undear Funds Account Status Classification Status 5010000000184010001 Savings Account LINR 240 SANDOZ 10 58 921 71 10 57 953 71 0 00 ACCOUNT OPEN REGULAR NORMAL 5010000000277710001 Savings Account LIINR 240 SANDOZ 0 00 0 00 0 00 ACCOUNT OPEN REGULAR NORMAL 15010000000278010015 Savings Account NINR 240 SANDOZ 1 99 630 71 1 99 630 71 0 00 ACCOUNT OPEN REGULAR NORMAL 50100000002801 10001 Savings Account LNR 1240 SANDOZ 0 00 0 00 0 00 ACCOUNT OPEN REGULAR NORMAL 5010000002381 1 10015 Savings Account NINR 1240 SANDOZ 2 121 70 2 121 70 0 00 ACCOUNT OPEN REGULAR NORMAL INR Total 12 60 674 12 gt ORACLE Field Description Field Name Customer Id Customer Details Customer Id Customer Name Gender Customer Type Home Branch Mobile Number Email Address Aadhaar Number Aadhar Number Updated On Aadhar Linked Alc Customer Memo Customer Me
101. on to apply the new or modified service charges to the transaction Click the Cancel button to reject the instrument details ORACLE 1 1 5 Cheque Details OBU CASA Funds Transfer Request amp E Cheque Cheque No 988766566 Cheque Date 10041200 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 ORACLE 1 1 6 Inventory Details Inventory Details Stock Code T ll Stock SubType Standard v Instrument Type Coy Code Issuer Code STATE BANK OF IND Total Amount Denomination Details Field Description Field Name Description Stock Code Display This field displays the stock 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
102. onal Whether the field is mandatory optional or based on some other field i e conditional Field Type The type of the field For e g Numeric Alphanumeric Drop Down Pick List etc Field Size The maximum characters that can be entered in the field This is applicable for numeric and alphanumeric fields only General Description It explains the function of the field Field Description Address City State Country Field Name Mandatory Optional Conditional Field Type Riek Se General Description Mandatory Alphanumeric 35 Type the mailing address of the customer The address can be mentioned in three lines Mandatory Pick List Select the name of the city where the customers mails should be sent from the pick list Mandatory Pick List Select the name of the state where the customer s mails should be sent from the pick list Mandatory Drop Down Select the name of the country where the customers mails should be sent from the drop down list ORACLE Understanding the Oracle FLEXCUBE User Interface The Oracle FLEXCUBE is designed for ease of use with a convenient 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 usage The user interface which is displayed at the time of login is configured during the template level settings After
103. osit Box General Ledger Relationship Pricing Branch Operations Settlement and Clearing Back Office System Operations 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 various 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 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 centr
104. plays the total buy amount Display This column displays the actual buying date Display This column displays the currency for selling of transaction Display This column displays the total sell amount Display This column displays the actual selling date Display This column displays the deal commencement date Display This column displays the transaction branch code Display This column displays the contract reference number Display This column displays the transaction currency Display This column displays the transaction amount Display This column displays the tenor for the sale deed Display This column displays the booking date Display This column displays the booking value date Display This column displays the maturity date Display This column displays the type of transaction done Display This column displays the portfolio reference number Display This column displays the portfolio description Display This column displays the transaction currency ORACLE Column Name Auto Liquidate for Corporate Actions Corpus Account Short Position Allowed Accrue Withholding Tax for Coupons Bankers Acceptance Derivatives Contract Reference Buy Sell In Leg Currency In Principal Amount Out Leg Currency Out Principal Amount Book Date Value Date Maturity Date Type OTC Options Contract Reference Currency Contract Nu
105. 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 the 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 ORACLE 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 Authorizaui x Dual control C Local Remote First Previous fi j88 1 2 3 4 5 Next Last TYINS9 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
106. 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 P P amp R Pay and Receivable PAT Pre Authorised Transfers ORACLE 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 Loans It is the phase of the loan account after the maturity date 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 amount 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 R RDFI Receiving Depository Financial Institution The financial institution where the receiver of an ACH entry holds an account
107. put Generator Billing Master Maintenance Pay Receivable Account Maintenance Reason Code Maintenance Third Party Company Details Third Party Collection Remittance Company Master Maintenance MIS Xref Maintenance Reference Directory Bank Code Maintenance FIS Bank Params Maintenance Transaction X ref Maintenance GL Codes Cross Ref Maintenance ECS Company Details Maintenance Account Status Event Xref Maintenance ORACLE Fast Path TCO01 PM002 PM003 PM004 PM005 PMOO7 PM008 PM009 PMO11 PM012 PM019 PM020 PMO21 PMO29 Description Transaction Definition Payments Transaction Definition Network Configuration Bank Branch Directory Zone Circle Maintenance Payments Network Adapter Network Master Payments Package External Payment Product Transaction Code Cross Reference Payment Global Parameters Counterparty Master Maintenance Mandates Network Calendar Float Configuration ORACLE Fast Path PM038 PM039 PMMO1 CHM10 CHM11 BAMO9 BAM23 BAM38 BAM80 762 BA026 SMMO1 SMMO4 SMM05 Description Payment Window Period Modification Payment Transaction Attributes Payment Site Reject Code Xref RD Product Rates Maintenance RD Grace Days Maintenance Issuer Maintenance Lost TC Details Maintenance Demand Draft Details Maintenance Bank Remittance Maintenance Menu Language Cross Reference Customer Account
108. risation 4 Deferred Authorisation 1 1 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 authorizer 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 ORACLE Microsoft Internet Explorer 3 Click the OK button to continue 4 The system displays the Authorization Reason screen Oracle Flexcube Authorization 5 Select the Local option 6 Enter the appropriate user name and password ORACLE Oracle Flexcube Authorizal Premature Redemption of Term Deposit Local Remote Supervisor ID ISSHWETALI Primary Password cssssee Comments court order a L4 7 Click the Grant button and the transaction will be authorised 1 1 2 Remote Authorisation Remote authorisation is used when the person
109. rver Release 10 3 6 JDK 1 7 0 45 Retail Application Server ORACLE Production Servers Software Branch Server Windows 2012 R2 Enterprise Server Oracle Client 11G 11 2 0 1 0 IIS 8 0 MS XML 4 0 SP3 Client Workstations Windows 7 Internet Explorer 11 MS XML 4 0 SP3 Retail Report Server Oracle Linux 6 u4 Intel 64 bit Developer BIP 11G Enterprise Server 11 1 1 7 0 ORACLE 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 Ke Name on ys Alt Balance This FET B Inquiry screen deca Mo Dion displays Aa cy ace sia the Preven Oey foot balance rea Ba bog account tosite ta maton details of Lens Ady paret Undrd Rares Unt vert bak TT Ce mg Pomme the FENG UG be aus savings vx tarer meg Amen and eus ro meen inn checking po ee ee account balances such as the available balance uncleared balance current book balance passbook balance net oo sos balance etc ORACLE Hot Screen Ke Name ys Alt Custom C er Name And Address Inquiry Alt Account A Details Descripti on This screen displays the details such as the name address city country SSN TIN number e
110. ry Audit Trail Inquiry for Non Financial Txns BA Audit Tasks Maintenance Inquire Restricted Account Maintenance Inquiry On Logged In Users Defining User Profile User Profile Maintenance User Prohibited Password Maintenance User Class Cross Reference Maintenance Template Transaction Limits SC Package for Customer SC Package Changes at Account SC History for Account Inquiry ORACLE Fast Path SCM06 BA455 8239 8240 Module Name Bills Fast Path BIMO1 BIMO2 BIMO3 BIMO4 BIMO05 BI001 Description SC Package Linkage to Code Task View File Processing Status Upload Local File To Finware File Upload To Finware Status Inquiry Description Drawee Risk Card Maintenance Court Master Maintenance Branch Court Cross Reference Maintenance Bill Parameters Maintenance Bills Processing Maintenance Bills Data Entry ORACLE Oracle FLEXCUBE July 2015 Version Number India Release 11 6 0 0 0 ORACLE Oracle Financial Services Software Limited i flex Annexe Nirlon Compound Off Western Express Highway Mumbai 400 063 India Worldwide Inquiries Phone 91 022 6718 7000 Fax 91 022 6718 9217 www oracle com us industries financial services Copyright 2014 Oracle and or its affiliates All rights reserved This document is provided for information purposes only and the contents hereof are subject to change without notice The references to the produ
111. s affiliates will not be responsible for any loss costs or damages incurred due to your access to or use of third party content products or services ORACLE kb lb ob kb kb ml ml eh ob ml mb lb mb eh mb ml Table of Contents ly Stenting Orage FLEXCUBE nn detente a siemens tits a anai 4 KE Sjelen Ted ER ERE RE 6 ke OVE REE ER NE 8 w Oder O RR te a a aiaa a 13 6 SES H QUIAM NS aa EE 13 6 Exitng acle FLEXCUBE scission iiir aie eirio aaa aa nnean rendant 20 aTa Typographia Convenio EE EE EE 20 oo Using Online ERE ET a eee es oreo 21 EET EE sje RET EE EN ent 26 10 Understanding the Oracle FLEXCUBE User Interface rrnnrrrrrrnnvrrrrrnnvvrnrrnnvvrrrrnnrererennn 28 11 Standard Maintenance Procedues nintendo 47 12 Standard Transaction Procedures dedans 50 1 Ahonen PROCES ces sec caidas ede gi duet A osent Nate dent ske 50 ON EN PE hea clea pa dye ote rase cede chee nie 65 HRS ee a ee EEE EE EEE ee Re eo 82 Loes de aoir aa E Rene eR RS mt 106 F R Se os RE RE 166 ORACLE 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 managemen
112. se is called the Endpoint 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 F 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 G GEFU Generic External File Upload ORACLE H Hand off It 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 Poolin
113. sted transactions ORACLE Fast Path Customer Id Advance Transactions Pending 2 Authorization Received 0 ORACLE 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 ADDRCHANGE Address Change File Type adrFileDefn General Information Processor Type Format EXTRACT v Close Help rameters Gefu Setup GL Setup Call Timing Output Template Deferred Auth Requred 7 Tab Screen Relative Path XFF File Name Output File Helper Class Output Folder Helper Class ap_ext_resp_acct_opel Record Details Input By Authorized By Last Mnt Date Last Mat Action Authorized TAJAY sasay 16 07 2007 00 00 00 Authorize Record Details Modes Available Screen Name This is the name of the transaction 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 Ta
114. t thus delivering improved performance 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 A 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 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 e Type the Oracle FLEXCUBE URL in the Address bar and click s For example the address may look like http server01 Flexcube e Oracle FLEXCUBE displays the screen as shown in the following figure National Language Support ORACLE ORACLE FLEXCUBE Click here to login ORACLE Oracle Flexcube Copyrights 2006 Oracle Financia
115. t Path code in the text box and click e 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 To navigate to an option menu method Town Cty v Country of Residence v Beth Reg Date 7 Customer Education Maral Status v Employee Id e When you login the system displays the Tree Menu in the left pane as shown in the following figure ORACLE Customer Id ss Advance gt Transaction Processing gt Global Definitions ORACLE 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 TD Account Transaction gt Other Transaction Tax Absorb Account Maintenance as shown in the following figure ORACLE Fast Path Customer Id et Advance Transaction Processing gt Workflow Transactions gt GL Transactions Account Transactions Loan Account Transactions se TD Account Transactions Cash gt Inquiries Other Transactions TD Tax Refund TD Post Maturity Renew Lien Master Maintenance Tax Waiver Backdated Interest Rate C TD Block Unblock Account TD Multiple Payout Instruct D Tax Acknowledgement Det TDS R
116. tcofthe selected customer This screen displays Account Number a Account Branch details of the customer Account Currency such as account number Customer Name account branch account currency customer name etc s Account Details Account Product Account Title Image 000000000075 Head Office 9999 1 IDR 360 ABDIREZATEA ABDIREZATEA ORACLE Hot Screen Descripti Image Ke Name on ys At Amount TE sammes O S based screen Account displays Image the Display images onthe EEE basis of the details maintaine d in the Amount Based Account Image Delay Amount Based Operatin Ament Based Operating Bref rune hen g Instructi on Maintena nce Fast Path 7116 option ORACLE Alt H CBR Details Mainten ance During the course of banking business it always helps to know the profitabilit y aspect of relationsh ip with a customer Using this hot key you can get to know the volume of business associate d with the customer This 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 ORACLE Hot Screen Descripti Ke Name on ys Image F8 This will enable the user to return to the same screen Alt Account This l Details screens Inquiry displays the detai
117. te Guarantee Currency Guarantee Amount Guarantee Amount in LCY Guarantee Outstanding Expiry Date This column displays the beneficiary name in case of LC issued and applicant if LC advised Display This column displays the advising bank name in case of import LC and issuing bank name in case of export LC Display This column displays the branch code of the contract Display This column displays the contract reference number Display This column displays the type of guarantee Display This column displays the issue date of guarantee Display This column displays the guarantee currency Display This column displays the guarantee amount or contract amount Display This column displays the guarantee amount in local currency Display This column displays the outstanding of the guarantee current availability Display This column displays the expiry date ORACLE Column Name Description Claim Expiry Date Display This column displays the claim expiry date Applicant Display Beneficiary Name This column displays the beneficiary name in case of guarantee issued and applicant name if guarantee advised Search Treasury CASA Corporate Loan Trade r Foreign Exchange Details Pr Contract Reference Buy Sell Book Date rs Bought Amount Baug Your Sold Currency Sold Amount Sold Value Date
118. te Rule Definitioi M Limit Management Definition Prerequisite M Collateral Definitions BB insurance Definitions BAMOS Bank Master Maintenance i Basset_Classification_Def ni GLMO2 Chart of Accounts Clearing Definitions Binventory Definitions Modes Available Remittance Definitions M Service Charge Definitions Central Bank Reporting Defi Add Modify Cancel Amend Authorize Inquiry For more information on the procedures of every mode refer to Standard Maintenance Procedures User Defined Fields To add bank parameter pa AEG S i 1 Type the fast path TDMO4 and click Go or navigate through the menus to Global Definitions gt TD gt TD Bank Parameters Maintenance Current and Savings Account rime Deposit 2 The system displays the TD Bank Parameters Maintenance screen Loans M Settlement and Clearing TD Bank Parameters Maintenance M Customer Information File m pr reiationship Pricing E Field Description Back Office 3 Click the Add button Branch Operations B General Ledger 4 Enter the bank code and press the lt Tab gt key BB system Operations Manual 5 Enter the GL details and the interest rate details oracle Flexcube Reports Disclaimer 6 Click the OK button 7 The system displays the message Record Added Authorization Pending Click the OK button 8 The new bank parameter is added once the record is authorised roc Search E Glossary e To locate another topic navigate us
119. 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 ATM card mer r ID Name er Type stration number 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 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 International Bank Account Number It is a unique account number that is used to identify a customer s account in a financial institution internationally ORACLE Customer Details ta Customer id Customer Memo a Home Branch Mobile Number Customer Instruction Email Address Aadhaar Number Photo Signature Aadhaar Number Updated On Aadhaar Linked Account E Global Definitions Transaction Processing Commercial Banking amp Entity Defini 3 Enter the CUST ID in the Selected Cust
120. the customer Product Display This column displays the code and name of the product under which the customer has an account Currency Display This column displays the currency assigned to product under which the account is opened In case the customer has accounts in multiple currencies then the accounts have to be ordered as per the currency and the total of the balances is displayed for each currency Branch Display Outstanding Bal Other Arrears Maturity Date Classification Status Loan Application No Account Rel This column displays the code and name of the home branch under which the customer has an account Display This column displays the outstanding principal for the account Display This column displays the sum total of all other arrears except principal arrears Display This column displays the maturity date of the loan account Display This column displays the classification status of the loan account based on the CRR Display This column displays the application number of the loan that is captured during account opening Display This column displays the relation of the customer with the account Search Corporate Loans Consumer Lending ORACLE CASA Trade Treasurv r Loan Details Branch Code Product Code 960 1SML Maturity Date 31 01 2018 ACTIVE Account Status Account No Description 9601SML170310018 Test Simple User Defined Status NORM
121. tions 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 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 Step Activity By 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
122. uct Name etc ORACLE This Represents lt Xyz gt Name of a keyboard button Constant width Formulae Using Online Help The 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 maintenance s and operational transactions To get Help e Click the Help link on the header or press lt F1 gt or click We button from any transaction or maintenance inside Oracle FLEXCUBE to view the Oracle FLEXCUBE Help e 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 UPE p ORACLE SEE TDM04 TD Bank Parameters Maintenance oracle FLEXCUBE Introduction The two important entities that are defined in TD Bank Parameters Maintenance are Definitions be oti Definitions Suspense General Ledgers General Ledger entries are automatically passed in FLEXCUBE Retail However in certain exceptional cases the system fails to pass the GL M Currency Definitions
123. umentation Set Description Oracle FLEXCUBE Introduction r Data Administrator Customer Information File Customer Service Personnel Current and Savings Account Time Deposit Liabilities Servicing Personnel mf Collections Credit Personnel Liabilities Servicing personnel Retail Credit Personnel Card Management Branch Managers Tellers BackOffice Operations ATM and CARDS team The user manual is divided into the following sub sections namely Understand usage 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 Dep
124. y Maintenance Workflow Master Collector Group Master Collector Master Supervisor Allocation Queue Definition ORACLE Fast Path Description CLNO5 Queue Allocation CLNO6 Action Result Setup CLNO7 Next Action Setup CLNO8 Action Allocation CLNO9 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 BAO91 Currency Rate Maintenance BAM31 Treasury Spread Maintenance BAM34 Special Exchange Rate Inquiry ORACLE Fast Path BAM56 BAM65 BAM90 BAM97 BA438 CIMO1 CIMO2 CIMO4 CIMO3 CIMO5 CIMO6 CIMO7 CIMO8 LNM43 Description Currency Codes Maintenance Currency Pair Definition Currency Float Maintenance Currency Codes Cross Reference Nominee Master Maintenance Signature Types Maintenance Business Type Maintenance Profession Codes Maintenance Customer Prefixes Maintenance Reporting Group Codes Maintenance Income Slabs Maintenance Relation Master Maintenance Customer Types Maintenance Installment Rules ORACLE Fast Path LNM90 LNM98 BAM45 BAM67 BAM77 CHM56 CH099 INMO5 BAM12 BAM13 LNO60 LNM41 LNM42 LNM81 Description Loan Commitment Fee Plan Maintenance Schedule Type Insurance Master Maintenance Collateral Insurance Cross Ref Maintenance Insurance Policy Master Maintenan

Oracle FLEXCUBE Introduction User Manual

Contents

Download Pdf Manuals

Related Search

Related Contents