Home

Oracle FLEXCUBE Core Banking

1. 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 1 2 Click the Advance option in the Selected Customer grid You can enter the single search string or combination of search string as explained in the introduction The system displays the Advance Search screen 103 ORACLE Search Advance Search Customer Search r Search Criteria 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 _Reset cos Search Results 38 record s found Customer IC Customer ID Full Name Customer Type Date of Birth Mobile No Home Phone L CIF01 603910 MANMEET CIFO1 INDIVIDUAL 31 12 1990 1111111111 CIFO3 603911 MANMEET CIFO3 INDIVIDUAL 16 02 1990 CIF04 603912 MANMEET CIF04 INDIVIDUAL 25 02 1993 66665487
2. For example in Bank Codes Maintenance the table layout is as follows Bank Code Bank Code Integer Name of Bank KEY pe BODY OF RECORD Bank code is a key identifier in the Bank Codes table Each bank code uniquely identifies a bank in the table The attributes of that bank code would be defined in the body of the record All action on the table namely add modify delete amend authorize and view are done using key field s For doing any operations on the maintenance or table the key fields for the respective transaction screen have to be entered In addition to the entities on the screen each of the record inside Oracle FLEXCUBE has some additional fields to be used internally by the system namely 1 Flg mnt status Maintenance Status Can be A for Flag Authorized or Null 2 Cod mnt action Maintenance Action Code Dat last mnt Last Maintenance Date s Cod last mnt makerid Last Maker ID ee Cod last mnt chkerid Last Checker ID Lo For example the standard procedures for the Bank Codes Maintenance option are as follows To add a bank code by copy 1 Select the Add mode Select the Add By Copy check box Type the existing bank code and press the lt Tab gt 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 Par oN The system displays the message Record Added Authorisation Pending Click Ok to
3. 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 dependent 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 66 ORACLE Common Screens Bank Code Danamon Bank v Chq Cey IDR B Txn Cey uso ov Cheque Ccy Rate 4 00000 Txn Ccy Rate 47 50000 Cheque Amount 500 00 Charges Ley 10 00 Total Amount 10 74 BC Date 29 04 2008 Serial No Micr No 257889 Routing No Bebeficiary Name John Passport JIC No asses Beneficiary Addr 7B Altamount Road User Reference No 5525 Narrative BC Sale Against Cash d Cha
4. 2008 Oracle Fin Services Software Limited All rights reserved Warning This software is protected by ernational Copyright Laws nay result c Co 4 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 7 ORACLE Starting Oracle FLEXCUBE ORACLE FLEXCUBE User Name Password e Enter your identification code in the User Name field and the password assigned to you in the Password field and click Hes e f 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 8 ORACLE 2 2 Product Features Product Features Flexibility through Standardization Oracle FLEXCUBE s unique Product Definition facility is a manifestation of its flexible design This feature allows a bank to define the various services and elements that the bank would offer under a product to all customers ther
5. ATDMO1 TD Product Mas ATDOGO TD Product Rate Tax Definitions GRD Definitions M Loan Definitions interest Rate Rule Definition M Limit Management M Collateral Definitions insurance Definitions Asset_Classification_Defini Clearing Definitions M inventory Definitions H Remittance Definitions M Service Charge Definitions Central Bank Reporting Defi M User Defined Fields M Other Definitions M Current and Savings Account WTime Deposit Loans M Settlement and Clearing customer Information File Relationship Pricing Back_Ofice W Branch Operations General Ledger M system Operations Manual Oracle Flexcube Reports ADisclaimer lt gt G toc P Search E Glossary TDM04 TD Bank Parameters Maintenance The two important entities that are defined in TD Bank Parameters Maintenance are Suspense General Ledgers General Ledger entries are automatically passed in FLEXCUBE Retail However in certain exceptional cases the system fails to pass the GL entries automatically In such cases GL posting is done automatically by the system into the suspense GLs defined at the bank parameter level The bank would have to manually reconcile these GLs Penalty Interest Parameters The penalty interest rate values will be derived from the Bank Parameters Maintenance if the penalty interest rate to be charged has been defined as Bank Level while defining the product You can specify an interest index and a variance that has
6. 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 143 ORACLE Appendix of Fast Path Fast Path BAM50 BAM57 INO10 INO17 LN444 BAM52 SY001 BA460 BAM49 LNO50 Description Common Billing Transactions Interest Adjustment Transaction Insurance Premium Remittance Insurance Coverage Maintanence Miscellaneous Charges Waiver Third Party Account Address Maintenance Guarantee Inquiry Loan Employee Account Inquiry Reminders History Inquiry Loan Billing Transactions Module Name Collections Fast Path CLN26 CLN28 CLN29 Description Follow up Main Form Authorization by Supervisor Exception Case Marking 144 ORACLE Appendix of Fast Path Fast Path Description CLN30 Group Follow Up CLN32 Reallocation Collectorwise CLN33 Reallocation Queuewise CLN34 Reallocation Individual CLN35 Temporary Re Allocation CLN37 Re queue CLN50 Search Query CLN55 List Follow Up CLN62 Initiate Repossession CLN63 Collateral Auctioning CLN64 Collateral Disposition CLN70
7. 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 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 maturity 89 ORACLE Customer Search Column Name Description Lien Amount Display This column displays the sum total of all active principal liens on the deposit Deposit Status Display This column displays the status of the deposit Status of the deposit can be ACCOUNT OPEN REGULAR ACCOUNT MATURED etc Account Rel Display This column displays the relationship of th
8. This field displays the total amount for which the inventory is being purchased This is defaulted from the transaction screen 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 Mandatory Numeric 10 Type the series number of the inventory which is to be purchased Mandatory Numeric 10 Type the start number of the inventory belonging to the respective series number which is to be purchased Display This field displays the end number that is calculated by the system depending upon the start number and 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 77 ORACLE Common Screens 2 16 5 Cost Rate Details As part of the Branch Profitability requirements cost rates needs to be captured transaction and account currency wise for FX transactions Outgoing Payment Transaction Message ENTE Account Ccy INR Acct Cey Rate 1 0 Acct Ccy Cost Rate Txn Cecy INR Txn Cey Rate 10 Txn Ccy Cost Rate Field Description Field Name Description Account Display Cey This field displays the currency assigned to the product at the product level under which the loan account
9. 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 75 ORACLE Common Screens 2 16 4 Inventory Details Inventory Details Stock Code T yy Stock SubType Standard v Instrument Type Ccy 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 the transaction screen 76 ORACLE Field Name Issuer Code Total Amount Denomination Details Denm Series Number Start Number End Number Quantity Common Screens Description Display This field displays the issuer code of the inventory This is defaulted from the transaction screen Display
10. e Re enter Transaction Amount This parameter will require the authorizer to input the transaction amount before authorizing a transaction done through specific options Authorisation can be broadly classified into following four types 1 Local Authorisation 2 Remote Authorisation 3 Centralised Authorisation 4 Deferred Authorisation 2 15 1 Local Authorisation Local authorisation is used when the authoriser authorises the transaction on the same location PC as that of the person posting the transaction without the person logging off from his session The transaction can be authorized by a user of same level or a higher level belonging to the same class based on the Parallel Authorization parameter value A user can be initiator of a transaction as well as an authoriser for same transaction type but will not have the right to authorize the transaction initiated by him Only posting transaction screens have option for Local authorization Re entry of amount is not possible for local authorization 1 Enter the relevant information in the transaction screen and click the Ok button 1 The system displays the Authorization required message box Microsoft Internet Explorer 2 Authorization Required Do you want to continue 3 Click the OK button to continue 4 The system displays the Authorization Reason screen 50 ORACLE Authorisation Procedures Oracle Flexcube Authorization 5 Select the Local option 6
11. r Commitment Details Branch Code Product Code Account No Description Currency AmountFinanced Amount Disbursed Outstanding Amount Book Date Value Date L r 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 This column displays the total outstanding amount Book Date Display This column displays the booking date or loan commencement date Value Date Display This column displays the date on which the first disbursement taken Maturity Date Displa
12. 1001 CANARA1 4 Value Date o1 105 2008 Sector 201 Java Late Clearing N Chg Commission Yes xi Instr Sub type 00 Crossed Cheque hi 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 71 ORACLE Field Name Cheque No Cheque Literal Cheque Date Routing No Bank Common Screens Description Mandatory Numeric 12 Type the cheque number which is present on the MICR line of the instrument When the cheque is deposited into any payee s account the cheque number is used to ensure that the duplicate entries are not made in the system that the same cheque is not deposited multiple times in the system On deposit of every cheque cheque number routing number and drawer account number all the three are present on the MICR line are used to check for the presence of duplicate instrument If duplicate instruments are found cheque deposit will be rejected unless the earlier cheques are all marked as
13. BAM77 CHM56 CHO099 INMO5 BAM12 BAM13 LNO60 LNM41 LNM42 Description Installment Rules Loan Commitment Fee Plan Maintenance Schedule Type Insurance Master Maintenance Collateral Insurance Cross Ref Maintenance Insurance Policy Master Maintenance 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 114 ORACLE Appendix of Fast Path Fast Path Description LNM81 Rate Change LNM88 Loan Product Repricing Revision Maintenance IVMO1 Stock Codes IVM02 Supplier Codes IVMO3 Inventory Control Branch Cross Reference IVM04 Maintaining Stock branch Cross Reference SBM01 Safe Box Product Inventory Cross Reference BAM55 Channel Limit Maintenance BAM73 Bank Customer Limit Maintenance LMBO1 Bank Limit Setup LMCO1 Customer Limit Setup LMCO05 Multi limit Plan Setup LMR0O1 Credit Concentration And Exposure Limits Maintenance LMS01 Limit Inquiry 115 ORACLE Appendix of Fast Path Fast Path LMS02 LMS03 LMS04 LMS05 LMS07 LMS08 LMS09 BA655 BAM44 LNM11 LNM18 LNM22 ORS25 ORS35 Description Bank Network Maintenance Limit Manual Transfer Limit Transfer Rule Multi limit Plan Setup Casa Loan Account Exemptions Customer Regulatory Information Loan Con
14. Corporation and its affiliates will not be responsible for any loss costs or damages incurred due to your access to or use of third party content products or services ORACLE Oracle FLEXCUBE Introduction User Manual Table of Contents 1 Pr InG6 nanna ene eae a 4 2 Introduction te Oracle FLEX CUBE nsc 6 eI RY ae FLEA CUB E kasie tah aa slau ah i a a aa a aa a dese ESSN 7 ER roe Tada a E asst A EAE A NEE T ENEE E AE TA EA A 9 2 3 Functional QVENWVIEWeiocccccisinicscscikcscacnsssacdasunbesaunusedeesuincedaauascnedunas araa Daar aaa iai aaia NANE 10 BN Core MOES ainsat a a a anaa aaa Eaa EN 10 23 2 Common FACIES sssrinin aa aa aa aaraa ka anaa baaa a bannuudiwaddxnanteawunny 11 RERS yE Eee Ee A E AE Teer E Cer ANT 11 Pe Wi Wa erties a On oa ae ery eee eC Te Te en ee Cee et eee tr een eee herent rene ry eet 11 es SPO IU eat NIN a aaa hase cgi dsb sateen Gl do A A E A shea ade wana 11 EEr aE e E A E E E cua nasa bola E T deena ota ones ad tials 12 EE AOMA re RoE a aaaea aAa ainda akaa aT S aA aE 13 Ba dN OS LAE E IT EE A A A ui A AE A Maumee aides E A 14 Lr 40 18 Res eo FLEX CUBE seiis 20 Pato Mm velete ecie 1 etc EO ati hc 1311 6 G pepe e nr pee reerrrtr cre terre rer crea tien eer rrerer eer er rt rarer ee eect a 21 ear UE Tot Online Ma amp eeeee eence arene re sorters ye cre erere rere re minen eer ree erm ner rt rere teen rf crrrr erat marr 22 2 10 Structure of User Manual Documentation Set cccccsesssesssessse
15. Define SMS entities and operations perform GL operations collateral definitions and linkage manage inventory SC linkage maintenance Download service maintenance and operations Asset classification amp operations file upload operations Define bills and their operations courts and their linkage to various branches Branch Server operations and Data centre operations ORACLE User Manual Structure 2 11 User Manual Structure The user manual covers all the aspects of Oracle FLEXCUBE The structure of the user manual is as follows CIMA Corporate Customer Details Option Name Field Descripton Field Name e amar aemp enaa ena n aaee roh mandatory Searc Criteria Entities to be The defined description of the fields Definition Prerequisites e 8053 Customer Addition Modes available for maintenance Modes Available Add Modtty Delete Inquiry For more nfomaton on the procedures of every mode eter to standard Maintenance Procedures Toadd the te customer details tN CIMI7 and cick Goor navigate through the menus 10 Transaction tomer Transactions gt Corporate Customer Details lays the Corporate Customer Details screen The procedure Corporate Customer Details EE Transaction Screen Full Name 4 Select tne search crtena tomine drop down ist 5 Type the search stnng a
16. Enter the appropriate user name and password 51 ORACLE Authorisation Procedures Oracle Flexcube Authorizal Premature Redemption of Term Deposit Local Remote Supervisor ID ISSHWETALI Primary Password eecccee Comments court order z 7 Click the Grant button and the transaction will be authorised 2 15 2 Remote Authorisation Remote authorisation is used when the person posting the transaction has sent the transaction for authorisation to a remote location within his branch The authoriser list includes user name along with the user ID and login status The transaction will be allowed to be authorized by a user of similar level or a higher level based on the Parallel Authorization parameter value The list will not have 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 authoriser 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 52 ORACLE Authorisation Procedures Teller Activities 1 Enter the relevant information in the transaction screen and click the Ok button 2 The system displays the Authorization required message box Mic
17. O Modify Modify a record The user can modify the record after sti 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 ts authorization The record is deleted from the system and cannot be accessed O Cancel Cancel a record The user can cancel the record before he 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 O Amend Amend a record The user who has added or modified the record i can amend it before authorization These amendments shall be taken into consideration when the supervisor authorizes the record FEN O Authorize l Authorize a record The user who has specific access rights can authorize the record 40 ORACLE Understanding the Oracle FLEXCUBE User Interface Click To Pyare O Inquiry View the authorized records PARI 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 u this to view the help related to a particular screen Close Click x to close the current screen Type of fields Information is entered in fields Generally t
18. ORACLE Appendix of Fast Path Fast Path PM033 PM034 PM035 PM036 PM037 PM043 PM044 PM045 PM046 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 148 ORACLE Appendix of Fast Path Fast Path SB002 SB003 SB004 Description Customer Waitlist Safe Box Usage And Payment Inquiry 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 Account GLMO1 Voucher Entry GLM02 Chart of accounts GLMO3 MIS Class Maintenance GLM04 GL Transactions and Movements Inquiry GLM13 Period Code Maintenance GLM17 GL Parameter Definition GLM20 Enterprise GL Cross Reference Maintenance 149 ORACLE Appendix of Fast Path Fast Path Description GLM35 Implemented GL Cross Ref GLM36 GL Posting Flag Maintenan
19. 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 42 ORACLE Understanding the Oracle FLEXCUBE User Interface Pick List A field that has the J button adjacent to it is a pick list e You can enter the value in the field by selecting it from the pick list 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 LJ adjacent to the Country field as shown in the following figure Country fad e Oracle FLEXCUBE displays the pop up screen as shown in the following figure First Previous fy 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 aa 43 ORACLE Understanding the Oracle FLEXCUBE User Interface 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
20. 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 107 ORACLE 2 19 Appendix of Fast Path Module Name Definitions Appendix of Fast Path Fast Path Description ACM01 Asset Classification Global Parameters ACM02 Asset Classification Preferences ACM03 CRR Codes Maintenance ACM04 Product CRR Codes Maintenance ACM05 Asset Classification Plan Maintenance ACMO6 l Automatic Write off Bank Parameter Maintenance ACM11 Product Provision Codes Maintenance ACM12 Universal NPA Crr Code Maintenance ACM22 Provision Plan Maintenance BS001 Rating Agency Maintenance BS004 Rating Group Maintenance BS007 Basel II Pick list Maintenance BS010 Basel II Securitization Details Maintenance BS013 Basel II Customer Details Maintenance BS019 Basel II Collateral Data Maintenance BS020 BASEL II Data Capture Screen 108 ORACLE Appendix of Fast Path Fast Path BS016 BAO11 BA012 BA013 BA014 CH099 CHMO1 CHM02 CHM04 CHM70 CHM84 BA078
21. 000 00 Value Date 15 0 03 6 User Reference No Narrative Cash Deposit Fetch DS Rates Pin Validation Service Charge Signature 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 64 ORACLE Authorisation Procedures 2 15 4 Deferred Authorisation Deferred authorisation is used for maintenance transactions The transaction will be allowed to be authorized by a user of same level or a higher level belonging to the same class based on the Parallel Authorization parameter value A User can be initiator of a transaction as well as an authoriser 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 authorising 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 65 ORACLE Common Screens 2 16 Common Screens This topic includes the details of the following screens available in Oracle FLEXCUBE
22. BA080 BAM27 Description Basel II Account Details Maintenance Spend Class Maintenance Spend Analysis Preferences Maintenance Spend Rule Maintenance Spend Rule Configuration CASA Multi Currency Product Package Definition 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 109 ORACLE Appendix of Fast Path Fast Path BAM28 BAM29 BAM33 BAM41 ECM03 ST080 STM50 STM54 STM55 STM56 STM58 STM60 STM64 STM70 Description Endpoint Float Maintenance End Point Master Maintenance Composite Calendar Generation Sector Master ECS Central Bank Reject Code Xref PDC Discounting Parameters Maintenance Clearing Branch Cross Reference Routing Branch Maintenance Clearing Minimum Maintenance Site Reject Code Xref Instrument Type Xref ACH Branch Cross Reference Maintenance Clearing Type Maintenance Routing Number Details 110 ORACLE Appendix of Fast Path Fast Path Description STM74 Restricted Clearing Types Maintenance STM82 Drawer Name and Issuing Bank Update STM83 Bulk Authorization Drawer Update STM97 Correspondence Bank Master Maintenance STM98 IC OC Clearing Type Cross Reference BAM37 Collateral Codes Details
23. 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 Typo Format EXTRACT Close Help rameters Gefu Setup Gt Setup Call Timing Output Template Deferred Auth Required a Tab Screen Relative Path XFF File Name Output File Helper Class Output Folder Helper Class ap_ext_resp_acct_opei Record Details Input By Authorized By Last Mnt Date Last Mint Action Authorized Authorize Record Details TAJAY sasay 16 07 2007 00 00 00 Modes Available Validation Button 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 Tab Screen Certain transactions are made up of a number of sub sections The tab screens are these separate sub sections D
24. Continue 46 ORACLE Standard Maintenance Procedures 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 Enter the bank code integer and bank name and click the Ok button PO RN 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 P oO N 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
25. Customer Search Column Name Description Tenor Display This column displays the tenor for the sale deed Book Date Display This column displays the booking date Value Date Display This column displays the booking value date for transactions Maturity Date Display This column displays the maturity date Display Type This column displays the type of transaction done Exchange Traded Derivatives Portfolio Details Portfolio Reference Portfolio Description Fund Id Fund Projection Fast Path Customer Details Display This column displays the portfolio reference number Display This column displays the portfolio description Display This column displays the fund Id SELECTED CUSTOMER Customer Id 603900 Account Number 50100000023811 casa Funds Projection Details Account Number Beneficiary Transaction Details Dr cr Amount Date 1 jl 101 ORACLE Customer Search Field Description Column Name Description Fund Projection Details Account Number 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 fetched only for the accounts where the customer holds a primary relationship Beneficiary Display This column display
26. 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 SC Package Linkage to Code Task View File Processing Status 165 ORACLE Appendix of Fast Path Fast Path 8239 8240 Description Upload Local File To Finware File Upload To Finware Status Inquiry Module Name Bills Fast Path Description BIMO1 Drawee Risk Card Maintenance BIM02 Court Master Maintenance BIM03 Branch Court Cross Reference Maintenance BIM04 Bill Parameters Maintenance BIMO5 Bills Processing Maintenance BI001 Bills Data Entry 166 ORACLE
27. 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 133 ORACLE Appendix of Fast Path Fast Path CHM48 CHM57 TDS13 7010 7013 7030 CH032 CHM34 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 134 ORACLE Appendix of Fast Path Fast Path 1093 1431 1801 1804 CHM50 ORS42 BAM66 BAM93 BAM82 BAM24 CH039 7115 7116 ECM02 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
28. customer has an account Display This column displays the code and name of the home branch under which the customer has an account Display This column displays the currency assigned to product under which the account is opened 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 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 Display This column displays the book balance of the account Display This column displays the unclear balance of the account 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 Display This column displays the classification status of t
29. details of the transaction Document Reciept r Documents 137 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 83 ORACLE Customer Search 2 17 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 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 the DOB date incorporated as 01 01 1965 DD MM YYYY and it is entered along with
30. 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 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 temp
31. figure displays a section with Marital Status as its title e It has two fields viz Status and No of Spouses Radio Button Male C Female A radio button is a group of two or more choices that are mutually exclusive that is you can select only one For example if there are two radio buttons only one of them can be active e To select a radio button click the radio button Check box Global O Keep In Office 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 44 ORACLE Understanding the Oracle FLEXCUBE User Interface User Defined Fields This section is used for updating additional details Based on the requirement and the nature of the field you can specify default values and validations for the field Oracle FLEXCUBE validates all entries made to the field against the validations defined for a field For more information refer to User Defined Fields
32. in any inherently dangerous applications including applications that may create a risk of personal injury If you use this software or hardware in dangerous applications then you shall be responsible to take all appropriate failsafe backup redundancy and other measures to ensure its safe use Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws Except as expressly permitted in your license agreement or allowed by law you may not use copy reproduce translate broadcast modify license transmit distribute exhibit perform publish or display any part in any form or by any means Reverse engineering disassembly or decompilation of this software unless required by law for interoperability is prohibited The information contained herein is subject to change without notice and is not warranted to be error free If you find any errors please report them to us in writing This software or hardware and documentation may provide access to or information on content products and services from third parties Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third party content products and services Oracle
33. in drop down hot spots e Collapse All Click the button to close all the data added in drop down hot spots e Glossary In the Help window click the Glossary button This will display the list of glossary available in the help 24 ORACLE Structure of User Manual Documentation Set 2 10 Structure of User Manual Documentation Set The user manual is divided into the following sub sections namely Oracle FLEXCUBE Understand usage of Oracle Introduction FLEXCUBE and its manuals online help screen menu layouts transaction maintenance procedures authorization procedures common screens acronyms used Definitions Static Data Administrator Define various static data entities required for basic Oracle FLEXCUBE operations across all modules Customer Information File Customer Service Personnel Create new customers and maintain various customer level entities Current and Savings Liabilities Servicing personnel Create new accounts and link Account Retail Credit Personnel customers to it define funds management such as Standing Instruction Sweep Out Sweep In Overdrafts Account Operations Statement Attributes and Interest Attributes Time Deposit Liabilities Servicing Personnel Create new accounts and link customers to it create account operations lien maintenance and certificate printing Loans Credit Personnel Link loan operations collateral define interest attributes Collections Credit Personnel I
34. in the Common Screens option in Oracle FLEXCUBE Introduction user manual The user defined fields are available in two layouts The UDF in classic format Other Transactions User Defined Fields An alternative UDF format me Click on the appropriate UDF to enter the additional details Session Auto Expiry The system displays session expiry alert if you are inactive for a particular duration Interval 2 which is set by the bank Click anywhere in the dashboard you can reset inactivity duration and auto logout mechanism will not proceed with the logout of current session 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 Font show this dialog again in current session 45 ORACLE Standard Maintenance Procedures 2 13 Standard Maintenance Procedures The standard procedure for the maintenance s in Oracle FLEXCUBE is explained below A record inside the table on which the maintenance operates has two parts namely A Key This can consist of one or more fields and these together identify a unique record in the table B Parts of the record Other attributes of the record
35. 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 78 ORACLE Field Name Acct Ccy Rate Acct Ccy Cosi Rate Txn Ccy Txn Ccy Rate Txn Ccy Cost Rate Common Screens Description 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 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 curren
36. 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 AUN 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 47 ORACLE Standard Maintenance Procedures 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 S
37. risk management 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 6 ORACLE Starting Oracle FLEXCUBE 2 1 Starting Oracle FLEXCUBE You require the necessary rights and privileges to start the Oracle FLEXCUBE software To start Oracle FLEXCUBE e Click Start point to Programs and click Internet Explorer e Type the Oracle FLEXCUBE URL in the Address bar and click eed For example the address may look like http server01 Flexcube e Oracle FLEXCUBE displays the screen as shown in the following figure ORACLE FLEXCUBE Click here to login ORACLE Oracle Flexcube Copyrights
38. the Central Workspace section in the Understanding the Oracle FLEXCUBE User Interface option Tab Screen In case the maintenance screen has more than one tab each of the tabs is defined separately The tab screens are the different sections of a transaction screen The tab screens are explained in the Understanding the Oracle FLEXCUBE User Interface option Field Description The explanation of the fields in the transaction and tab screens The explanation gives the following points e Mandatory Optional Conditional Whether the field is mandatory optional or based on some other field i e conditional e Field Type The type of the field For e g Numeric Alphanumeric Drop Down Pick List etc e Field Size The maximum characters that can be entered in the field This is applicable for numeric and alphanumeric fields only e General Description It explains the function of the field Mandatory Optional i a Conditional Field Type Reds General Description Field Description Field Name Address Mandatory Alphanumeric 35 Type the mailing address of the customer The address can be mentioned in three lines City Mandatory Pick List Select the name of the city where the customer s mails should be sent from the pick list State Mandatory Pick List Select the name of the state where the customer s mails should be sent from the pick list Country Mandatory Drop Down Select the name of the country w
39. 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 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 5 The system downloads the product to the respective branch Oracle FLEXCUBE is a comprehensive solution that provides a unified back office processing environment for Corporate Retail and Investment Banking operations with a highly adaptable and scalable modular architecture Oracle FLEXCUBE is designed to offer flexibility to financial institutions for easy adaptability to market needs and also enables banks to improve their overall operational efficiency Oracle FLEXCUBE offers effective control and risk management thus delivering improved 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
40. 007 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 138 ORACLE Appendix of Fast Path Fast Path TDS10 TDS11 TDS12 TDS14 TDS15 8054 TD020 TD021 TD022 TD028 TD043 TDMO05 TDM24 TDM25 Description TDS Remittance TDS Inquiry Tax Recovery TD Tax Refund Inquiry on Projected Tax Time Deposit Account Opening TD Account Master Deposit Master TD Nominee Maintenance TD Block Unblock Account Status TD Certificate Printing TD Account CBR Codes Maintenance Lien Master TD Duplicate Receipt Issue 139 ORACLE Appendix of Fast Path Fast Path Description TDM48 Backdated Interest Rate Change TD044 TD Transactions Inquiry 6503 Quick Payin By BC 6504 Quick Payin by DD 6505 Quick Payin By Cheque 1311 TD Redemption Inquiry By BC 1828 TD Redemption Inquiry 2828 TD Redemption Inquiry 1332 Quick Redemption By DD 1336 Quick Redemption By Reinvesting To New Account 1824 Quick Payin By CASA FW FCR 2824 Quick Payin By CASA UBS BAIB7 Customer Prod Cross Reference TD689 Customer Deposit Inqu
41. 41 CIF05 603913 MANMEET CIFOS INDIVIDUAL 22 02 1990 7777777777 CIFO6 603915 MANMEET CIFO6 INDIVIDUAL 18 02 1991 964584751 CCFCDB 603926 MANMEET FCDB INDIVIDUAL 07 02 1989 9865745896 CUS2 603950 MANVA PATIL INDIVIDUAL 12 12 1989 CUST12 603995 MANOJ INDIVIDUAL 31 10 1988 9985451224 54152546 MEMOTEST 604059 MANMEET MEMO INDIVIDUAL 16 02 1988 7895461231 TESTMANN 604065 MANMEET TEST INDIVIDUAL 12 02 1988 9856320145 m 4 1 Maa Field Description Field Name Description User can enter any of the following search criteria mentioned below Customer Id Account No Customer IC Short Name NLS Name IBAN 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 Alphanumeric 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 belong to the
42. BAM39 Collateral Codes Maintenance BAM63 Product Collateral Linkage BAM74 Collateral Header Maintenance BAM84 Financial Security Maintenance CLNOO Workflow Master CLNO1 Collector Group Master CLNO2 Collector Master CLNO3 Supervisor Allocation 111 ORACLE Appendix of Fast Path Fast Path Description CLNO04 Queue Definition 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 BA091 Currency Rate Maintenance BAM31 Treasury Spread Maintenance 112 ORACLE Appendix of Fast Path Fast Path BAM34 BAM56 BAM65 BAM90 BAM97 BA438 CIMO1 CIM02 CIM04 CIMO3 CIM05 CIM06 CIMO07 CIM08 Description Special Exchange Rate Inquiry 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 113 ORACLE Appendix of Fast Path Fast Path LNM43 LNM90 LNM98 BAM45 BAM67
43. Customer Sticky Notes Module Name Card Management Fast Path CMO1 Description Card Maintenance 145 ORACLE Appendix of Fast Path Fast Path CM02 CMO03 CM04 CM05 CMO06 CMO07 CMO08 CM09 CM10 CMS01 Description Blank Cards Request Card Status Change Card Activation Card Unblocking Blank Cards Inventory Card Master Setup Card Account Product Link Setup Card Maintenance Card and Random Number Status Change Card Maintenance Module Name Payments Fast Path 2030 2031 2032 Description Outgoing Payment Transaction Initiation Outgoing Payment Transaction Message SWIFT Outgoing Payment Message 146 ORACLE Appendix of Fast Path Fast Path 2035 2037 2039 2041 2042 PM010 PM023 PM025 PM026 PM027 PM030 2055 2056 2057 Description Domestic Outgoing Payment Initiation Credit Card SEPA 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 147
44. Hot Keys Hot Screen Descripti Image Ke Name on ys F8 This will enable the user to return to the same screen Alt Account This 1 Details screen Inquiry displays the details of CASA acc ount whenever ALT lis B pressed re rane zao while San ast Uocane Dene cree accessing Anaraga Qutaly Octenes re any D oroma CASA scr De AA AME OME E HE Charges gan me Hani mpe ee ANS AQE Ard Coarged Cepected Asna woe Cxpected Balance YON YTD Vaive Last 3M No Last JH Valve Decwon Cash Cash Dep Mene urn Cheque Leaves auto Loot Teo meses oan 18 ORACLE Hot Ke ys Alt E Screen Name Custome r Contact Details Updation Descripti on This screen displays the contact details for the selected customer ID Fast Path CIM60 whenever ALT E is pressed while accessing CIM39 Cl141 CIM13 and CIM11 screens Image Hot Keys 1000002nm Goine Nere 3820975359 EMaiD phretani com 1af 10y 1980 Sex 19 ORACLE Exiting Oracle FLEXCUBE 2 7 Exiting Oracle FLEXCUBE The user needs to follow the correct procedure to exit Oracle FLEXCUBE The user has to log out from the application and then close the browser window To exit Oracle FLEXCUBE 1 Each screen in Oracle FLEXCUBE has the Logout link on the header 2 Click the Logout link 3 The system displays the Logon screen 20 ORACLE Typographical Conventions 2 8 Typog
45. IBAN entered are displayed 104 ORACLE Customer Search Field Name Description ATM Card Optional Alphanumeric 16 Number Type the valid ATM card number of the customer Refined Search Mobile No Home Phone Date of Birth Date Incorporated Currency Search Result Customer IC Customer ID Full Name 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 additional search criteria with IBAN from the drop down list This field is enabled if the search criteria are IBAN The currency details are maintained in the Currency Codes Maintenance Fast Path BAM56 option Display This column displays the identification code of the customer A customer IC along with customer type is a unique method of customer 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 soci
46. In Inquire Amount Based Operating Instruction Maintenance Amount Based Account Image Display ECS Mandate Maintenance 135 ORACLE Appendix of Fast Path Fast Path TD024 CH033 STM72 BA988 BA007 C1500 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 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 136 ORACLE Appendix of Fast Path Fast Path 5056 Cl142 CH043 Description Statement Request Customer Account Relationship Maintenance Fund s Projection Module Name Term Deposit Fast Path 1337 TD029 TD039 7020 TD023 TD030 TD031 TD037 TD040 TD041 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 137 ORACLE Appendix of Fast Path Fast Path TD042 TDO50 TDO70 TDMO07 1
47. Inventory Detalls s Lok cancel Mark Grant Deny view Back 6 Click the Grant button to authorize the transaction 7 Click the Deny button to deny authorization of the transaction 8 The system displays the Authorization Reasons screen 61 ORACLE Authorisation Procedures Account No f i M Al Account Ccy fine Txn Coy fine Acct Ccy Rate Txn Cecy Rate 1 Amount S0000 Account Amt Narrative j 3 Fexcube Web Page Dialog Authorization Reasons Reason SANCTION OBTAINED Comments Overdraft for the account z atnventory Detais i 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 expected to submit the transaction for posting from the Electronic Journal screen or Incomplete Transactions screen after the authorizer has authorized the transaction 1 Type the fast path 6006 and click Go or navigate through the menus to Transaction Processing 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 62 ORACLE Authorisation Procedures Te
48. ORACLE Oracle FLEXCUBE Core Banking Oracle FLEXCUBE Introduction User Manual Release 11 5 0 0 0 Part No E52876 01 July 2014 Oracle FLEXCUBE Introduction User Manual July 2014 Oracle Financial Services Software Limited Oracle Park Off Western Express Highway Goregaon East Mumbai Maharashtra 400 063 India Worldwide Inquiries Phone 91 22 6718 3000 Fax 91 22 6718 3001 www oracle com financialservices Copyright 2014 Oracle and or its affiliates All rights reserved Oracle and Java are registered trademarks of Oracle and or its affiliates Other names may be trademarks of their respective owners U S GOVERNMENT END USERS Oracle programs including any operating system integrated software any programs installed on the hardware and or documentation delivered to U S Government end users are commercial computer software pursuant to the applicable Federal Acquisition Regulation and agency specific supplemental regulations As such use duplication disclosure modification and adaptation of the programs including any operating system integrated software any programs installed on the hardware and or documentation shall be subject to license terms and license restrictions applicable to the programs No other rights are granted to the U S Government This software or hardware is developed for general use in a variety of information management applications It is not developed or intended for use
49. Path Fast Path Description BA452 File Upload GEFU BAM53 SCHEDULAR SETUP BAM54 External File Setup BAM94 External File Processing Upload File Status Inquiry BAM96 File Upload Inquiry GEFU CHM43 Cheque Book Issue Upload ST043 Load Inward Remittance File ST044 Outward Remittance Hand off 1005 Miscellaneous GL Transfer 1060 GL Miscellaneous Debit Against Cash 1460 GL Miscellaneous Credit Against Cash 1905 Cross Cost Center Miscellaneous GL Transfer Dr Cr 9019 Transfer Stocks IV001 Stock Transaction 163 ORACLE Appendix of Fast Path Fast Path IV002 IV011 7011 752 753 755 756 757 758 766 767 768 769 AT002 Description Stock Adjustment Stock Inquiries Event Log Inquiry Reset Primary Password Enable Disable Users Modify Login Status User Prohibited Password Inquiry for Logged in Users Inquiry for Password Secondary Password Expiry Date Reset Secondary Password Change Primary Password Change Secondary Password Audit Trail Inquiry 164 ORACLE Appendix of Fast Path Fast Path BA777 BAM04 BAM10 SM11A SMM02 SMM03 SMMO09 SMM12 SMM13 SCM02 SCM03 SCM05 SCM06 BA455 Description 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
50. Reference Currency Amount Tenor Book Date Value Date Maturity Date Type Security Portfolio Portfolio Reference Portfolio Description Currency Auto Liquidate for Corporate Actions Corpus Account Short Position Allowed Accrue Withholding Tax for Coupons 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 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 99 ORACLE Column Name Bankers Acceptance Derivatives Contract Reference Buy Sell In Leg Currency In Principal Amount Out Leg Currency O
51. Returned Mandatory Drop Down Select the cheque literal from the drop down list Mandatory dd mm yyyy Type the cheque date This date has to be less than or equal to current posting date This date is used in checking validity of the instrument Instruments become stale if the cheque date is prior to the current posting date by the stale period defined in the Settlement Bank Parameters Fast Path STM59 option Mandatory Numeric Nine Type the routing number of the cheque The routing number is a combination of the bank code the branch code and the sector code from where the instrument was drawn The combination can be obtained from the Routing Branch Maintenance Fast Path STM54 option Routing Number Sector Code Bank Code Branch Code For a deposited cheque this routing 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 Display This field displays the bank name to which the cheque belongs corresponding to the bank code extracted from the routing number 72 ORACLE Common Screens Field Name Description Branch Display This field displays the branch name from where the cheque is drawn corresponding to the branch code
52. ace e The system displays the transaction screen in the Central Workspace as shown in the following figure Fast Path Search Criteria Customer Short Name Search String adi Customer Name Customer ID z Recovery from CASA Recovery from GL s Transaction Processing CASA Account No GL Account Workflow Transactions GL Transactions w Account Transactions Loan Account Transactions TD Account Transactions gt Cash Inquiries wOther Transactions TD Tax Refund TD Post Maturity Renew Lien Master Maintenance Tax Waiver W Backdated Interest Rate C TD Block Unblock Account gt TD Multiple Payout Instruct Tax Acknowledgement Det TDS Remittance W Tax Absorb Account Maint P TD Interest Adjustments W TD Account CBR Codes Mai gt Transfer Remittance gt SDB Account Transactions gt CASA Account Transactions gt Payment Transactions walkin Transactions Collection Transactions gt Customer Transactions gt Internal Transactions Global Definitions 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 is used on a frequent basis You can drag and drop t
53. al 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 105 ORACLE Customer Search Field Name Description Customer Display Type 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 Date of Birth Display This column displays the date of birth of the customer Mobile No Display This column displays the mobile number of the customer Home Phone Display This column displays the home phone number of the c
54. and bank code extracted from the routing number Sector Display Drawer Acct No Value Date This field displays the clearing sector name to which the cheque branch belongs corresponding to the sector code extracted from the routing number Sector Codes are defined using Sector Codes Maintenance Fast Path BAM41 option Mandatory Numeric 16 Type the account number on which the cheque is drawn The drawer account number is the account number of the person who has issued the cheque The drawer account number which is generally printed on the cheque leaf is the account from where the funds will come into the beneficiary account If the cheque is drawn on a different bank the drawer account number will not be validated by the system If the cheque is drawn on your own bank the system will validate the drawer account number for its correctness Display This field displays the value date of the cheque When a cheque is deposited on an account the system uses the routing number to check the float days from the Endpoint Float Maintenance Fast Path BAM28 option and the working days from the Endpoint Clearing Branch Composite Calendar Fast Path BAM33 option to generate the value date of the cheque The value date is the date on which the cheque is expected to be cleared On the value date the system updates the customer s available balance and credits the account with the cheque amount and reduces the un cleared fund
55. appy 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 Term Deposit Loans RD Funds Projection Account Details Account No Product Currency Branch Available Bal Book Balance Undear Funds Account Status Classification Status 5010000000816010005 Savings Account LINR 60 FORT MUN 1 97 337 52 97 689 52 0 00 ACCOUNT OPEN REGULAR NORMAL 837410005 Savings Account LINR 60 FORT MUN 0 00 0 00 0 00 ACCOUNT OPEN REGULAR NORMAL Account Rel sow JAF INR Total 1 97 337 52 87 ORACLE Field Description Column Name CASA Account No Product Branch Currency Available Bal Book Balance Unclear Funds Account Status Classification Status Account Rel Customer Search Description Display This column displays the account number of the customer Display This column displays the product name and code of the product under which the
56. arantee Outstanding Expiry Date Claim Expiry Date Applicant Beneficiary Name Customer Search Description 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 Display This column displays the claim expiry date Display This column displays the beneficiary name in case of guarantee issued and applicant name if guarantee advised 97 ORACLE Customer Search Search Treasury casa Corporate Loan Trade Foreign Exchange Details a ContractReference Buy Sell Book Date rede Bought Amount Bought Vale Sold currency Sold Amount Sold Value Date Deal Rate 960FSB1170310075 B 31 01 2017 USD 50 00 31 01 2017 JINR 3085 0031 01 2017 31 01 2017 1 m r Money Market Details BranchCode Co
57. ature type for individual customers using the Signature Types Maintenance option Authorized records from this maintenance will populate the CIMO1 Signature pick list in the Customer Addition Fast Path 8053 option Types Maintenance CIMOJ Customer Note The system automatically authorizes this transaction 2 Information Master N A a 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 toc P Search amp Glossary 23 ORACLE Using Online Help Use of other tools available on the help header e Back Click the button to return to the last help page you viewed e Forward Click the button to view the help option which you were initially working on e Refresh Click the Ga button to refresh the current page which you are using e Expand All Click the s button to expand all the data added
58. c 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 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 102 ORACLE Customer Search Bills If the user clicks on this option the system displays the Bills Processing Maintenance Fast Path BIMO05 option Hold Funds If the user clicks on this option the system displays the Hold Funds Maintenance Fast Path CHM33 option Balance Enquiry If the user clicks on this option the system displays the Balance Inquiry Fast Path 7002 option If the user double clicks on the TD account number the system displays the following pop up Statement If the user clicks on this option the system displays the TD Account Ledger Inquiry Fast Path TD037 option Account Profile If the user clicks on this option the system displays the TD Account Master Fast Path TD020 option TD Enquiry If the user clicks on this option the system displays the TD Balance Inquiry Fast Path 7020 option If the user double clicks on the Loan account number the system displays the following pop up Statement If the user clicks on this option the system displays the Account Transactions Inquiry Fast Path LNM10 option
59. ccount can be ACCOUNT OPEN REGULAR ACCOUNT OPEN NO CREDIT ACCOUNT OPEN NO DEBIT etc 90 ORACLE Column Name Account Rel Search Loans Customer Search Description Display This column displays the relationship of the customer with the account casa Term Deposit Funds Projection 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 3370000 Loan Product 1 INR 240 SANDOZ 0 0 00 01 01 1950 NORMAL LNMAT1235631 SOW 5000000 1411 70000 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 0002 09 2017 NORMAL 14160 SOW 500000 3417 70000 Loan Product 1 INR 240 SANDOZ 175860 66 0 00 02 09 2017 NORMAL In1563212322 SOW 50000 381270000 Loan Product 1 INR 240 SANDOZ 658742 65 0 00 30 08 2017 NORMAL LNMAT563 SOW 5000000032145270000 Loan Product 1 INR 240 SANDOZ 0 0 00 01 01 1950 NORMAL LN30815 sow 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
60. ce GLM37 GL Cost Centre XRef Maintenance GLM50 Oracle GL Transactions Inquiry Module Name Relationship Pricing Fast Path Description CH067 CASA Interest Inquiry CIM50 Relationship Value Tag Definition CIM51 Customer Group Definition Maintenance CIM52 Customer Group Inquiry Applicable Customer Groups RLOO1 UDE Master Maintenance RLOO2 Rule Definition Master Maintenance RLO10 Rule Debug Maintenance RPOO1 Scheme Definition Maintenance RP002 Eligibility Criteria Maintenance 150 ORACLE Appendix of Fast Path Fast Path RP003 RP004 RP010 RP011 RP015 Description 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 7041 Description Search Electronic Journal View Teller Errors Last Ten Transactions Account Number Check Digit Inquiry Teller Transactions Summary Batch Status Inquiry Teller Totals Position Branch Totals Position 151 ORACLE Appendix of Fast Path Fast Path Description 7050 Old to New Account Inquiry 7122 Cross Rate Inquiry BAM95 Branch Batch Status Inquiry 6001 Batch Open 6002 Branch Batch Close 6005 Branch Batch Confirm 6009 Force Close Branch Batch 9888 Setting Initial Cash 6201 Cash Balancing 6203 TC Balancing 7551 Book Shor
61. column displays the account status User Defined Status Display Search Trade This column displays any user defined status casa Corporate Loan Treasury Bill Details al 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 Beneficiary Issuing Advising Bank Branch Code Contract Reference Issue Date LC Currency PE EA LC Tolerance LCY Availability Expiry Date fine Name 960 960NELC170310005 31 01 2017 _ INR 20 500 00 20 500 00 20500 01 05 2017 _ FGDT ENT LKJ ENT 1 n Guarantee Details Guarantee Guarantee Guarantee Guarantee Claim Expiry Application Bene Branch Code Contract Reference Guarantee Type Issue Date eee paaur Amountin CY Outstanding Expiry Date Date faa 0 p 5 E E Field Description Column Name Description Bill Details 95 ORACLE Customer Search Column Name Description 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 LC Reference Number Outstanding Amount Purchase Amount LC Details Branch Code Contract Reference Issue Date LC Currency LC Contract Amount LC Tolerance LC Amount
62. 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 86 ORACLE Customer Search Field Name Description Gender Display This field displays the gender of the customer Display Customer Type Home Branch Mobile Number Email Address Aadhaar Number Aadhar Number Updated On Aadhar Linked Alc Customer Memo Customer Memo Customer Instructions Message Number of unresolved conversations Search CASA 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 the mobile number of the customer Display This column displays 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 Display This field displays all the customer memos one below the other Display This field displays the customer Instructions which are maintained as part of Customer Instruction Maintenance Display This field displays the message of h
63. cy 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 79 ORACLE Common Screens 2 16 6 User Defined Fields While working with Oracle FLEXCUBE there are additional fields which are required to be used either for convenience or to suit the requirements of the bank The User Defined Fields option allows the user to add fields based on the 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 Cecy INR Txn Coy INR v Acct Cey Rate Txn Cey Rate Deposit No Int Payout Amount Tax Calculated Net Interest Payout og Txn Amount User Reference No a Narrative TD Interest Payout By Cash J Other Transactions User Def
64. dentify the delinquent advances accounts and initiate necessary follow up actions Card Management Branch Managers Tellers Create new card types and BackOffice Operations ATM link accounts to it Modify the and CARDS team card status and other card operations 25 ORACLE Description Payments Safe Deposit Box General Ledger Relationship Pricing Branch Operations Settlement and Clearing Back Office System Operations Structure of User Manual Documentation Set Tellers Supervisors Branch Manager Back Office Operations Safe Deposit Box Users Customer Support Officers Send and receive fund and related messages to from any external entity outside the bank Safe deposit box allotment rent recovery and maintenance GL Personnel Branch and Head Define 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 26 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
65. document is intended for the following audience e Customers Partners 1 2 Documentation Accessibility For information about Oracle s commitment to accessibility visit the Oracle Accessibility Program website at http www oracle com pls topic lookup ctx acc amp id docacc 1 3 Access to OFSS Support https support us oracle com 1 4 Structure This manual is organized into the following categories Preface gives information on the intended audience It also describes the overall structure of the User Manual Introduction provides brief information on the overall functionality covered in the User Manual Chapters are dedicated to individual transactions and its details covered in the User Manual 4 ORACLE Preface 1 5 Related Information Sources For more information on Oracle FLEXCUBE Core Banking Release11 5 0 0 0 refer to the following documents e Oracle FLEXCUBE Core Banking Licensing Guide 5 ORACLE Introduction to Oracle FLEXCUBE 2 Introduction to Oracle FLEXCUBE Oracle FLEXCUBE is a comprehensive solution that provides a unified back office processing environment for Corporate Retail and Investment Banking operations with a highly adaptable and scalable modular architecture Oracle FLEXCUBE is designed to offer flexibility to financial institutions for easy adaptability to market needs and also enables banks to improve their overall operational efficiency Oracle FLEXCUBE offers effective control and
66. e No ff To Sequence No Pss From Txn Time oo 00 00 To Txn Time From Amount 0 00 To Amount Mnemonic C zij f Incomplete Transactions 7 Remote Authorized Transactions j B e 10 000 00 TDEVLOANZ za 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 hn rd Change Pin heq R Service Ch Card Cheque Cost Rate Denomination ventory in Validation ge Signature ravellers Cheque 6 Double click the sequence number in the Seq No column 7 The system displays the relevant screen 54 ORACLE Authorisation Procedures h Deposit Eon z Account No 60000001756440 Feray Account Ccy LTL Txn Cey LTL Account Ccy Rate 1 00000 Txn Cecy Rate 1 00000 Customer Type Self Customer Category Individual Customer Status Resident Bank Notes l 100000 Litas Coins 0 Centas Coins a Total Amount 100 000 00 Account Amount Txn Amount Value Date 15 01 2008 C User Reference No Narrative Cash Deposit Pin Validation Service Charge Sign Travellers Cheque 8 Click the Grant button to authorize the transaction The system displays the dialog box for confirming amount 9 Enter the amount If the amount entered matches with the transaction amount entered by t
67. e customer with the account Search RD CASA Term Deposit in sid Funds Projection Account Details Installment Account No Product Currency Branch Available Bal Maturity Date Account Status Account Rel Amount 0004411 12001 RD FLOATING PENINR 240 SANDOZ 2 500 00 2 500 00 02 09 2017 ACCOUNT OPEN REGULAR SOW 0442112001 RD FLOATING PENINR 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 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 a
68. e 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 9 ORACLE Functional Overview 2 3 Functional Overview Common Facilities 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 2 3 1 Core Modules e Clearing Clearing definitions are explained in the Definitions User Manual Clearing maintenance s is explained in the Settlement and Clearing User Manual e General Ledger GL Definitions are explained in the Definition User Manual e Customer Information System Custome
69. eby ensuring that all customers are offered the same uniform services 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 employment financial corporate etc about a
70. ed Cheque Deposit 6512 Consolidated Cheque Batch Data Entry 6520 Cheque Deposited To GL 6602 Postdated Cheque Data Entry Batch 6619 Postdated Cheque Cancellation ST077 Postdated Cheque Discounting ST078 Postdated Cheque Discounting Cancel ST033 Inward Clearing Process ST034 Scanning Rejected Instrument St035 Scanning of Passed Instrument ST038 Bulk Scan Inward Rejects ST062 Clearing Account X Reference Inquiry 155 ORACLE Appendix of Fast Path Fast Path Description ST075 Unchecked Instruments Inquiry ST076 Check Inward Clearing Instruments ST099 Payment Value Date Clearing 6565 ICC Data Entry 6566 OCC Batch Data Entry 6806 Cheque Collection Processing 5522 Batch Micr SrlnoXref Data Entry 8323 Maintained Issued Instruments BA990 Clearing Inquiry ST067 Collection Purchase Inquiry ST074 Remittance Inquiry STM57 MICR Number Maintenance STM71 Unmatched DHN Blacklist Customer Deletion 7120 Late Clearing Maintenance 156 ORACLE Appendix of Fast Path Fast Path ST001 ST002 ST023 ST037 ST060 ST061 ST066 ST072 STM62 STM63 1009 1025 1026 1409 Description Value Date Clearing Process Value Date Clearing Inquiry Outward Clearing Reverse Authorized Batches Immediate Credit Float Extension Cheque Status Inquiry Global Float Extension Late Clearing Inquiry Late Clearing Marking Maintenance TC Sale Against Account Bill Payment Ad
71. ed to step D 57 ORACLE Authorisation Procedures Step Activity By Activity Description 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 button 2 The system displays the Authorization Required message box Microsoft Internet Explorer ug Authorization Required Do you want to continue Cancel 3 Click the OK button 4 The system displays the Authorization Reason screen 58 ORACLE Authorisation Procedures Flexcube Authorization Dual control Hold Funds Present Refer to Drawer Account would Overdraw Account Number 000000007260 Available Balance After Transaction 400 40 Local 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 se
72. elect the Amend 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 P oO N The system displays the message Record Amended Authorisation Pending Click Ok to Continue Amend action is used by the teller who wants to do further changes to the record which has been modified by him earlier but before authorization by the supervisor System will allow 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 statu
73. epending 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 39 ORACLE Understanding the Oracle FLEXCUBE User Interface 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 D Add By Copy Add a new record with the features of an existing record O add Add a new record
74. f auto authorization is disabled 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 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 D Supervisor Supervisor access the central authorization transaction and authorizes the transaction waiting for authorization E Teller Teller resubmits the approved transaction from the Electronic Journal and completes the transaction lf auto authorization is enabled 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 proce
75. he 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 This field displays the total service charge to be applied in local currency Column Name Description Rule Details Rule ID Display Original Value Rule Returned Rule Returned Value 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 69 ORACLE Common Screens Column Name Description Final Value 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 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 70 ORACLE Common Screens 2 16 2 Instrument Details Instrument Details UE z Clearing Type Local3day float w Cheque No 1 Cheque Literal Local Cheque Depost Chi Date ios eque Date 20 03 2008 E Routing No 100 1001 Bank 100 Canara Drawer Acct No 000000002220 Branch
76. he account For asset type of products the classification status of the account which is derived based on the CRR code should be displayed Display This column displays the relation of the customer with the account 88 ORACLE Search Term Deposit Customer Search casa Account Details Account No Deposit No Product Currency Branch Principal Balance Maturity Date Rate of Interest aa aoa Lien Amount 5030000 11 1 1005 Payout at maturity INR 240 SANDOZ 50000 31 08 2017 22 0 00 0 00 0 00 ACCO 5030000 112 1005 Payout at maturity INR 240 SANDOZ 1500 30 08 2017 22 0 00 0 00 0 00 ACCO 503000000042141 1012 FD Bimonthly IntereINR 240 SANDOZ 100000 30 08 2017 22 0 00 0 00 1 00 000 00 ACCO 503000000042142 1012 FD Bimonthly Intere INR 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 Ld Field Description Column Name Description Account No Display This column 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
77. he fields can be Display Fields Entry Fields Date Fields and pick list Display Fields Reserve Calculation Frequency Information in these fields is retrieved calculated by Oracle FLEXCUBE Display fields are shown on screen in grey colour indicating that they cannot be changed Entry Fields 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 41 ORACLE Understanding the Oracle FLEXCUBE User Interface Date Fields LN Process Date 20 03 2008 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 Prey ir J e Click ES with the mouse to activate the calendar e Oracle FLEXCUBE displays a calendar as shown below E Calendar February 2008 3 4 5 6 7 105 BIS ES c a Le CIBU L194 20 eek Pa A E E e Click the relevant date The date gets populated in the date field
78. he teller the authorizer can commit the transaction The authoriser can reject the transaction if required foracte Flexcube Authorization nD i X Amount 100 000 00 10 Click Ok button The system displays the authorization screen 55 ORACLE Authorisation Procedures Oracle Flexcube Authorization 11 Enter the relevant information 12 Click Grant button for record authorisation 56 ORACLE Authorisation Procedures 2 15 3 Centralised Authorisation Centralised authorisation is a security enhancing setup which can be enabled in Oracle FLEXCUBE for providing additional authorizations when predefined reasons are encountered in online transactions by a group of supervisors preferably from those located centrally This level of authorization is subsequent to and 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 I
79. he transaction from the tree menu in Y Click My Transaction to view the screens which you have added You can select the check box adjacent to the option name and click W to delete the option from My Transaction 35 ORACLE Understanding the Oracle FLEXCUBE User Interface Fast Path 8053 Customer Id Advance gt Customer Addition I Safe Box Allotment hI Blank Cards Request 36 ORACLE Understanding the Oracle FLEXCUBE User Interface 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 listed transactions 37 ORACLE Understanding the Oracle FLEXCUBE User Interface Fast Path Customer Id Advance Transactions Pending 2 Authorization Received 0 38 ORACLE Understanding the Oracle FLEXCUBE User Interface
80. here the customer s mails should be sent from the drop down list 28 ORACLE Understanding the Oracle FLEXCUBE User Interface 2 12 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 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 Header Fast Path Customer Search Tree Menu Central Workspace Frequently Used 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 29 ORACLE Understanding the Oracle FLEXCUBE User Interface 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
81. in LCY LC Current Availability Expiry Date Applicant Beneficiary Name 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 Display This column displays the contract reference number Display This column displays LC issue date Display This column displays the LC currency Display This column displays the LC contract amount Display This column displays the tolerance amount Display This column displays the LC amount in local currency Display This column displays the LC current availability Display This column displays the expiry date Display This column displays the beneficiary name in case of LC issued and applicant if LC advised 96 ORACLE Column Name Issuing Advising Bank Name Guarantee Details Branch Code Contract Reference Guarantee Type Issue Date Guarantee Currency Guarantee Amount Guarantee Amount in LCY Gu
82. ined Fields ox cancer If you click the User Defined Fields tab the system will display the User Defined Fields screen 80 ORACLE Common Screens Limit Breached N 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 81 ORACLE Common Screens 2 16 7 Negotiate Negotiation Exchange Rate 234 99000 Comments New Exchange Rate Reo Sa ana Field Description Field Name Description Exchange Rate Display This field displays the current exchange rate Comments Optional Alphanumeric 256 Type the comments if any New Exchange Display Rate This field displays the exchange rate after it has been negotiated You 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 82 ORACLE Common Screens 2 16 8 Document Receipt This screen is displayed at the end of some transactions For example While using the Future Dated Cash Deposit Fast Path 1411 option at the end of the transaction the system will display the Document Receipt screen It is used to print the
83. iry 140 ORACLE Appendix of Fast Path Module Name Loans Fast Path Description 1413 Loans Disbursement Inquiry LNO45 Loan Disbursement Reversal LN521 Account Schedule LNM44 Disbursement Schedule LNO46 Post Dated Cheques Maintenance LN057 Loan Direct Account Opening LNO65 Loan Product Promotional Interest Rates LNO89 Loan Account Repricing Revision LNO90 Loan Account Commitment Schedule Details Maintenance LN101 Loans Account Status Change LN323 Account Documents Maintenance LNM31 Account Payment Instructions LNM32 Additional Document Maintenance LNM33 Loan Account Address Maintenance 141 ORACLE Appendix of Fast Path Fast Path 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 142 ORACLE Appendix of Fast Path Fast Path 7026 INO20 LNO22 LNO23 LN500 LN501 LN502 LN522 LNM10 LNM49 1065 1066 1068 1430
84. late 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 30 ORACLE Understanding the Oracle FLEXCUBE User Interface To access an option fast path method e Fast Path is an alphanumeric keyword used to uniquely identify a transaction It is also called a transaction mnemonic e The Fast Path is to be entered in the Fast Path text box provided in the top left corner of the Oracle FLEXCUBE screen as shown in the following figure Fast Path BAMOS so e To access the option type the Fast Path code in the text box and click 9 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 Language Customer ID Full Name Fest Name Made Name Last Name Staon x Shot Name _ Address Town Cty Sate a Country yr Nationality J Country of Residence 2p Beth f Reg Date Resi Phone No Customer Education v Mobile No Emai ID Gender x Maral Status v Ra Employee Id Business To navigate to an option menu method e When you login the system displays the Tree Menu in the left pane as shown in the following figure 31 ORACLE Understanding the Oracle FLEXCUBE User Interface Fast Path Customer Id Advance T
85. ll 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 applications of the bank can use for online interfac
86. ller ID Electronic Journal Remote Authorization Branch Posting Date 30704 2008 a Account No From Sequence No 1 To Sequence No 9999 From Txn Time 00 00 00 To Txn Time 23 59 59 From Amount 0 00 To Amount 9 999 999 999 999 99 Mnemonic m Incomplete Transactions Remote Authorized Transactions Host Process Date 2070472008 a 6 1401 18 47 01 06049420000012 INR Incomplete 1 000 00 TSRINIVASA Click to print 5 1401 17 52 46 06049420000012 INR Sent 1 000 00 TSRINIVASA Click to print 4 1401 17 51 10 06049410000019 Cancelled 0 00 TSRINIVASA Click to print 3 8051 18 39 45 06056900000019 Sent 0 00 TSRINIVASA Click to print 2 8053 12 24 50 Sent 0 00 TSRINIVASA Click to print 1 9001 17 53 26 Success 0 00 TSRINIVASA Click to print am Card Change Pin Cost Rate Denomination Instrument Inventory Pin V 5 Double click the sequence number in the Seq No column whose state is Auth Granted 6 The system displays the relevant screen 63 ORACLE Authorisation Procedures Account No 60000001756440 Feray Account Cey LTL Txn Cey Account Ccy Rate 1 00000 Txn Cecy Rate Customer Type Self Customer Category Individual Customer Status Resident Bank Notes Litas Coins Centas Coins Total Amount Account Amount Txn Amount 100
87. n The system displays the message Record Added Authorization Pending Click the OK button The new bank parameter is added once the record is authorised e To locate another topic navigate using the tree menu TOC provided on the left pane and click the topic name link OR e 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 22 ORACLE Using Online Help To perform a search e Inthe Help window click the Search button e Enter the text you want to search in the text box located in the left pane and click the Search oe 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 kal 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 sf a i button The required text is highlighted and displayed in the right pane Search a p ORACLE ene Seach CIMO1 Signature Types Maintenance Rank a Title The user can maintain the sign
88. nance 130 ORACLE Appendix of Fast Path Fast Path Description 1401 Cash Deposit 1822 Cash Deposit FW FCR 2822 Cash Deposit UBS 1408 Miscellaneous Customer Credit 1411 Future Dated Cash Deposit 1421 RD Installment Payment by Cash 1429 Flexible RD Deposit by Cash 1803 OBU CASA Account Credit 1908 Cross Cost Center Miscellaneous Customer Credit 6501 Cheque Deposited on Savings Account 6601 Postdated Cheque Deposit BAM21 Immediate Credit for Advance Cash Deposits ST070 Cheque Purchase 1001 Cash Withdrawal 131 ORACLE Appendix of Fast Path 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 132 ORACLE Appendix of Fast Path Fast Path 1010 1825 2825 1014 1827 2827 1080 1432 1650 8318 BA030 CH077 CHM09 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
89. nd 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 transaction For more information refer to the Modes Available section in the Understanding the Oracle FLEXCUBE User Interface option Procedures The process used to operate the transaction is mentioned Depending upon the nature of the maintenance only the important sub 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 27 ORACLE User Manual Structure e The tree menu access path Transaction Screen The transaction or maintenance screen which is displayed in the procedure The transaction screen is explained in
90. nge Pin heq Rate Denomin Instrument Invent Pin Validation Service Charge g Travellers Cheque vo ox cise 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 67 ORACLE Common Screens 2 16 1 Service Charge Details A maximum of five default service charges can be linked to each transaction TOTAL 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 68 ORACLE Common Screens Field Name Description CCY Display This field displays the service charge currency 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 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 t
91. nrat Currency Amount Tenor BookDate ValueDate Maturity Date Type 960 960MBI11703 INR 1050 190 31 01 2017 31 01 2017 01 05 2017 BORROW 1 7 r Security Portfolio firth Portfolio Description Currency pees sepa ayaa anata hoes o p r Derivatives contact Buy sell InLeg Currency Principal A OutPrindpal SookDate Value Date Maturity Date Type o p r OTC Options ieee Currency Contract Number Contract Amount Strike Price een Option Premium rors Buy Sell Tenor Book Date 0 p r ETD Protfolio Details tfoli tfolio Reference Despen FAID 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 Bought Currency Bought Amount Bought Value Date This column displays the date on which the transaction is booked Display This column displays the currency for buying of transaction Display This column displays the total buy amount Display This column displays the actual buying date 98 ORACLE Customer Search Column Name Description Sold Currency Display This column displays the currency for selling of transaction Sold Amount Display This column displays the total sell amount Sold Value Date Display This column displays the actual selling date Deal Date Display Money Market Details Branch Code Contract
92. plained in the Loan User Manual 2 3 4 Deposit Accounts 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 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 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 2 3 5 Application Security The application security maintenance s and transactions are explained in the Back Office User Manual 11 ORACLE Order Of Usage 2 4 Order Of Usage The order of usage of the user manuals is as follows ORDER OF USAGE Oracle FLEXCUBE Introduction v Definitions v BROP v 4 4 4 4 X 4 x 4 4 CIF CASA TD Loans Collections CM Payments SDB GL RP M M M M M M M STL amp CLG Back Office Operations Bills User Manual is optional 12 ORACLE Software Requirements 2 5 Software Requirements Production Servers Software Database Server AIX 5 3 Oracle 10g Enterprise Edition 10 1 0 4 SQL Plus Retail Application Server AIX 5 3 OR Windows 2003 Enterprise Server Oracle Client 10G 10 1 0 Oracle 10G Application Se
93. quence 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 refers to Local Authorization and Remote Authorization earlier in this chapter 59 ORACLE Authorisation Procedures At Central Location 1 Navigate to the Centralised Authorization screen using the fast path 4501 2 Transactions to be authorized can be filtered by entering one or more of the following a From Branch and To Branch b Mnemonic c Customer ID d Account No e Teller ID Centralised Authorisation From Branch TEA BAN x To Branch paa t f Mnemonic fi f thdra Customer Id Account No 999101000001080 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 er aaora INR 6 000 00 Incomplete conce The system displays all the transactions sent for authorization 4 Click the transaction to view the transaction details The system displays the transaction details screen The supervisor cannot modify any details on the screen 60 ORACLE Authorisation Procedures Cash Withdrawal Account No Account Ccy nr E Txn Coy fm oJ AcctCcyRate dau Txn Cey Rate T00 Amount Si0000 Accountamt 60m0 Narrative i ash Withdrawa g
94. r Information File Fast Path Description 7101 IC No Short Name Change 123 ORACLE Appendix of Fast Path Fast Path Description 7117 Bulk Authorization Cancellation of Images 7118 Delete Customer Image 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 124 ORACLE Appendix of Fast Path 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 125 ORACLE Appendix of Fast Path Fast Path Description CIM79 Eligibili
95. r 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 10 ORACLE Functional Overview 2 3 2 Common Facilities Inventory Management Inventory definitions are explained in the Definitions User Manual Inventory maintenance s are explained in the Back Office User Manual Fund Transfer Fund Transfer transactions are explained in the Current and Savings Account User Manual Service Charges Service Charges definitions are explained in the Definitions User Manual Service Charges maintenance s are explained in the Back Office User Manual NPA Management Asset Classification definitions are explained in the Definitions User Manual Asset Classification maintenance s are explained in the Back Office User Manual Collateral Management Collateral definitions are explained in the Definitions User Manual Collateral maintenance s are explained in the Back Office User Manual 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 2 3 3 Consumer Lending Suite Retail Loan Accounts Loan definitions are explained in the Definitions User Manual Loan maintenance s are ex
96. ranch 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 93 ORACLE Customer Search Column Name Description Outstanding Display Amount This column displays the total outstanding amount Book Date Display This column displays the booking date or loan commencement date Value Date Display This column displays the date on which the first disbursement taken Maturity Date Display This column displays the maturity date for loan Account Status Display This column displays the account status User Defined Status Display Leasing Branch Code Product Code Account No Description Currency Amount Financed Amount Disbursed Outstanding Amount Book Date Value Date Maturity Date Account Status User Defined Status 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 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 di
97. ransaction Processing Global Definitions 32 ORACLE Understanding the Oracle FLEXCUBE User Interface 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 gt Tax Absorb Account Maintenance as shown in the following figure 33 ORACLE Understanding the Oracle FLEXCUBE User Interface Fast Path Customer Id et Advance Transaction Processing gt Workflow Transactions gt GL Transactions Account Transactions Loan Account Transactions TD Account Transactions Cash Inquiries t 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 Tax Acknowledgement Det TDS Remittance 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 Internal Transactions gt Global Definitions 34 ORACLE Understanding the Oracle FLEXCUBE User Interf
98. raphical Conventions This Represents Bold Transaction Screen Name Field Names Check Boxes Button Names Product Name etc lt Xyz gt Name of a keyboard button Constant width Formulae 21 ORACLE Using Online Help 2 9 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 Wihe 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 Qbear p ORACLE WjOracle FLEXCUBE Aversion Number oracle FLEXCUBE Introduction Definitions W master Definitions E Currency Definitions M Securities Definitions E Customer Definitions CASA Definitions QATO Definitions ATDM04 TD Bank Param
99. rosoft Internet Explorer 2 J Authorization Required Do you want to continue Cancel 3 Click the OK button 4 The system displays the Authorization Reason screen Oracle Flexcube Authorizata Dual control C Local Remote First Previous fi js8 1 2 3 4 5 Next Last TVINS9 4564 N i SANAND ANAND SUP ID N TANAND ANAND VIEW ID N TVINAYSO BROP 50 N Cancel 5 Select the Remote option 6 Select the authoriser ID to whom the transaction is to be sent for authorisation from the User Id column drop down list 7 The system displays the message Transaction sent for Authorization Click the Ok button 53 ORACLE Authorisation Procedures 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 2 The system displays the Search Electronic Journal screen 3 Select the Teller ID from the pick list 4 Click the Remote Authorisation option 5 Click the Fetch button The system displays all the transactions sent by the teller for authorization Teller ID fu ttst lt SsS B Electronic Journal Remote Authorization Branch Posting Date 55 04 2008 Host Process Date 30 04 2008 Account No C From Sequenc
100. rver Release 3 OR WebSphere Application Server 5 1 IBM MQ Server 6 Branch Server Windows 2003 Enterprise Server Crystal Reports Professional Version 10 Oracle Client 10G 10 1 0 IIS 6 0 Microsoft SOAP Toolkit 2 0 MS XML 4 0 IBM MQ Client 6 Client Workstations Windows XP Professional SP1 Internet Explorer 6 0 Microsoft SOAP Toolkit 2 0 MS XML 4 0 Retail Report Server Windows 2003 Enterprise Server Crystal Enterprise Version 11 Crystal Reports Developer Edition 11 13 ORACLE Hot Keys 2 6 Hot Keys Hot Keys are the shortcut keys which can be invoked by the user to navigate through various screens Some of the examples are Cash Deposit Fast Path 1501 option allows the user to navigate through Balance Inquiry Alt B Customer Name and Address Inquiry Alt C Account Details Alt A etc Hot Screen Descripti Image Ke Name on ys Alt Balance This ee B Inquiry screen erase Mo ouaa displays RAN ETET T the ARE R aii account sitata iioa details of GeeS Ady aganet unci hares Lint the scale te savings tet tatars REETA and 5 checking oes icone account balances such as the available balance uncleared balance current book balance passbook balance net a balance etc 14 ORACLE Hot Ke ys Alt C Alt A Screen Name Custome r Name And Address Inquiry Account Details Descripti on This screen displays the details such as
101. s Maintenance Issuer Maintenance Lost TC Details Maintenance Demand Draft Details Maintenance Bank Remittance Maintenance Menu Language Cross Reference Customer Account Access Code Template Profile Maintenance Class Profile Maintenance Menu Language Cross Ref Maintenance 121 ORACLE Appendix of Fast Path Fast Path SMM06 SMM08 SMM14 SMM16 SMM17 SMM18 SMM19 SMM22 BAM14 BAM18 BAM19 BAM22 SCM01 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 122 ORACLE Appendix of Fast Path Fast Path Description SCMO09 SC Product XRef Maintenance BAM30 Tax Codes Maintenance BAM51 Additional Tax Maintenance BAM76 Product Customer Tax Codes Maintenance TDS04 Tax Waiver Criteria Maintenance TDS06 Tax Parameters Maintenance TDS07 Tax Acknowledgement Details Maintenance TDO60 TD Product Rate Maintenance TDMO1 TD Product Master TDM04 TD Bank Parameters Maintenance UDF01 User Defined Fields UDF02 UDF Task Code Linkage Module Name Custome
102. s Pa Customer Search E i Photo Signature COS curds proiection Account Details Account No Product Currency Branch Available Bal Book Balance Undear Funds Account Status Classification Status 4010001 Savings Account LINR 240 SANDOZ 10 58 921 71 10 57 953 71 0 00 ACCOUNT OPEN REGULAR NORMAL 0001 Savings Account LINR 240 SANDOZ 0 00 0 00 0 00 ACCOUNT OPEN REGULAR NORMAL 0015 Savings Account NINR 240 SANDOZ 1 99 630 71 1 99 630 71 0 00 ACCOUNT OPEN REGULAR NORMAL 0001 Savings Account LINR 240 SANDOZ 0 00 0 00 0 00 ACCOUNT OPEN REGULAR NORMAL 11 10015 Savings Account NINR 240 SANDOZ 2 121 70 2 121 70 0 00 ACCOUNT OPEN REGULAR NORMAL INR Total 12 60 674 12 nE Field Description Field Name Customer Id Customer Details Customer Id Customer Name 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
103. s of the Unauthorized record to Authorized To view the bank code 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 list 3 The system displays the bank code details 48 ORACLE Standard Transaction Procedures 2 14 Standard Transaction Procedures The procedure for the transactions in Oracle FLEXCUBE is explained below The key fields for the respective transaction screen have to be entered For example the standard procedure for the Cash Deposit is as follows To deposit cash in CASA account 1 2 Oo OV Ge Type the account number and press the lt Tab gt or lt Enter gt key 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 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 49 ORACLE Authorisation Procedures 2 15 Authorisation Procedures You can define the following bank level parameters for authorisation e Parallel Authorization This parameter will allow transaction to be authorised by a same level or higher level user belonging to the same class
104. s on the account For more information on maintaining value date refer to the Clearing Definitions option in the Definitions User s Guide 73 ORACLE Field Name Late Clearing Chg Commission Instr Sub type Common Screens Description 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 Display This field is currently not used in any processing Mandatory Drop Down Select the instrument sub type from the drop down list The values in the drop down are defaulted from the Site Instrument Type field maintained in the Instrument Type Xref Fast Path STM58 option Click the Ok button to apply the new or modified service charges to the transaction Click the Cancel button to reject the instrument details 74 ORACLE Common Screens 2 16 3 Cheque Details OBU CASA Funds Transfer Request amp a E Cheque Cheque No 988766566 Cheque Date 100472008 Field Description Field Name Description Cheque No Mandatory Numeric 12
105. s the beneficiary account for the SI or Loans Drawdown instructions Transaction Details Display Dr Cr This column displays the transaction details The transaction details are 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 Amount Display Date 4 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 Display 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 option the system displays the Account Master Maintenance Fast Path CH021 option Commissions Et
106. splays 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 Display This column displays the maturity date for loan Display This column displays the account status Display This column displays any user defined status Syndicated Loan Details Branch Code Product Code Display This column displays the branch code of the contract Display This column displays the product code 94 ORACLE Customer Search Column Name Description 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 This column displays the total outstanding amount Book Date Display This column displays the booking date or loan commencement date Value Date Display This column displays the date on which the first disbursement taken Maturity Date Display This column displays the maturity date for loan Account Status Display This
107. sssesssscssesesessssesrsrererees 25 211 User Manual SUCINE orriaren tae eeidaices Lapis meudaduee cutest 27 2 12 Understanding the Oracle FLEXCUBE User Interface cceeseeeeeceeeeeeeeeeeeeeeeeeeeeeeees 29 2 13 Standard Maintenance Procedures sccciiccc ccsicccassitacecasdivaneactacsetassveerwaseigdnnsayiesnwntancuesaevians 46 2 14 Standard Transaction Procemune soi csiiicuct avjeseestisecceaeinanensdadubaspioaieutaigdennsplagnoaiaducsaaviecs 49 2 15 Auihorsaton Procedures rinnce asd teducheylasnoubiaauetac teas 50 nhs Na aN PESTS SEU cas 25 Sacco ssatetiacet cto ecneke aagaeis noe maiatadute eu loaceoiiaue eviesceetaduenecaions 50 2 15 2 SMO SFU TWO SA HIOIN oe sacacs coi tagtetacent ai vlaconht E TSE 52 2 15 3 Centralised Authoris atio sci eo iaiccaivaduedcebleccesksuasurczoagdeattadsvbenaioonoatdzaueces pied seitadactseaiens 57 2 14 Deleired AUTOS O erraia enean Eai EE NS Eta 65 2 Io COMINO oa PIS a aaa an aaa n eaa 66 216 1 SPUN Chade Dealg eissii raaa iaaa a e 68 210 2 WPS UATE IE DERN eiaa aa aaa a oea aE eai 71 2103 Cheie D GUNG oaa aaa a 75 2 104 WONTON DONS nissin a a aa aie i 76 210o GOS Pae DoE ae aa eaa 78 2100 User Deined PIAS siririna n ra aAa e eaa 80 NGF NODON na aaa aa aa aN a 82 2 16 9 Document ACCC IN iraisser a NS aaa 83 BN COM Eo a a anA 84 2 16s Downi e PO O U a eae eR a eR eR 107 A ADONIS OIRBSE Fas iz E A tenia sia aie eae RS I eS 108 ORACLE Preface 1 Preface 1 1 Intended Audience This
108. t Fast Path BA996 1320 CHO01 CHO011 7002 CH031 Description Product Transfer Maintenance Close Out Balance Inquiry Account Closing Balance Information Account Closure Inquiry Maintenance Balance Inquiry Statement Inquiry 128 ORACLE Appendix of Fast Path Fast Path Description CH051 Account Capitalization History Inquiry CH068 Amortization Inquiry 7106 Account Image Display 8051 CASA Account Opening AC014 Account CRR Details Maintenance AC040 Asset Agreement Inquiry BA437 Account Memo Maintenance BAM69 Islamic Account Attributes CH021 Account Master Maintenance CHO070 Accident Reason Code Maintenance CHM08 CBR Codes Maintenance CHM21 Account Status Maintenance CHM24 Group Accounts Maintenance CHM38 Inward Direct Debit Maintenance 129 ORACLE Appendix of Fast Path Fast Path BAMO06 CHM45 CHM51 CHM55 Cl142 CIM28 SCM08 5004 CH078 CHM35 CHM37 CH066 CHMO06 CHMO07 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 Mainte
109. tage 7552 Book Cash Overage 9001 Open Teller Batch 9005 Close Teller Batch 152 ORACLE Appendix of Fast Path Fast Path 9007 9008 9003 9006 9009 9010 5514 5515 9800 BA995 BA999 7775 7778 7779 Description 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 Report Print All Tellers 153 ORACLE Appendix of Fast Path Fast Path 7780 7781 BAM16 Description Advice Report Cancel Request Report Cancel All Tellers Report Control Maintenance Module Name Settlement and Clearing Fast Path 6560 1511 5521 CHM41 ST031 ST032 ST036 ST039 ST042 5505 Description Online Cheque Return Inquiry MICR Header Entry Batch Inward Clearing Cheque Data Entry Inward Cheque Status Inquiry Load Inward MICR File Authorise Inward Clearing Batches Reconcile Outward MICR File Special Clearing Run Load Central Bank File Batch Consolidated Cheque Data Entry 154 ORACLE Appendix of Fast Path Fast Path Description 5506 Batch Data Entry Outward Settlement and Clearing 5606 Batch Data Entry Outward Clearing 6511 Consolidat
110. th BA453 BAM05 BAM07 BAM40 BAM78 BAM79 BAM81 BAM83 BAM89 BAM91 BAM98 BAM99 ECMO01 LNM27 Description Parameterized Output 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 119 ORACLE Appendix of Fast Path Fast Path Description TCO001 Transaction Definition PMO002 Payments Transaction Definition PM003 Network Configuration PM004 Bank Branch Directory PM005 Zone Circle Maintenance PM007 Payments Network Adapter PM008 Network Master PMO009 Payments Package PMO11 External Payment Product Transaction Code Cross Reference PM012 Payment Global Parameters PM019 Counterparty Master Maintenance PM020 Mandates PM021 Network Calendar PM029 Float Configuration 120 ORACLE Appendix of Fast Path Fast Path PM038 PM039 PMM01 CHM10 CHM11 BAMO09 BAM23 BAM38 BAM80 762 BA026 SMMO01 SMM04 SMMO05 Description Payment Window Period Modification Payment Transaction Attributes Payment Site Reject Code Xref RD Product Rates Maintenance RD Grace Day
111. th Description AC001 Account Classification Preferences AC002 Account Classification Inquiry AC003 Account Provision AC004 Account WriteOff ACM07 Provisioning Parameters at Bank level for Loans and Overdrafts AC008 Provision Inquiry and Modification for Loans and Overdraft 160 ORACLE Appendix of Fast Path Fast Path Description BA433 Collateral To Accounts Inquiry BA434 Account To Collateral Inquiry BAM46 Collateral Propagation BAM47 Application Collateral Delink ATMO1 ATM Bank Params Maintenance ATM02 ATM Acquirer POS ID Maintenance BA092 Auto Relock Time Maintenance BAIB2 IB Bill Company Details Maintenance BAIB3 IB Customer Application Billing Information Maintenance BAIB4 IB Bank Params Maintenance BAIB5 IB Block Transfer Across Products BAIB6 IB Transaction Customer Relationship Cross Reference POSO1 POS Acquirer POS ID Maintenance POS02 POS Bank Params Maintenance 161 ORACLE Appendix of Fast Path Fast Path Description POS04 POS BIN Xref Maintenance TBSO1 TBS Bank Params Maintenance TBS02 TBS Acquirer POS ID Maintenance TBSO3 IVR TIN Request 5504 Download Upload Status Inquiry 5531 Download Upload File 8889 Download Scheduler Maintenance 8890 Cluster Maintenance 8891 Download Log 8892 Download Service 7239 Upload Local File 7240 File Upload Status Inquiry 8893 Upload Account Balance File BA450 Generic External File Upload GEFU 162 ORACLE Appendix of Fast
112. 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 91 ORACLE Customer Search Search Corporate Loans Consumer Lending casa Trade Treasury r Loan Details a Branch Code Product Code Account No Description Currency AmountFinanced Amount Disbursed Outstanding Amount Book Date Value Date N 960 1SML 9601SML170310018 Test Simple INR 25000 25000 25000 31 01 2017 31 01 2017 _ 3 Maturity Date Account Status User Defined Status 31 01 2018 ACTIVE NORM 4 b
113. the advance search criteria of first name as George then Oracle FLEXCUBE will fetch all the records where the registration date or the date of birth of a customer is 01 01 1965 and the first name is George The search result will be as follows Custo Custome First Custom DOB Regi ATMcard Postal mer r ID Name er Type stration number Address IC date 8159 600918 George Individu 01 01 196 44793705 28 Billstreet N al 5 21504778 ew York 1253 315789 George Corpora 01 01 196 61763528 25 Billstreet te 5 45789887 New York 4789 678215 George Corpora 01 01 196 50791248 18 Hamilton te 5 32594578 street New York 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 International Bank Account Number It is a unique account number that is used to identify a customer s account in a financial institution internationally 84 ORACLE Customer Search Oracle FLEXCUBE Customer id Home Branch Mobile Number Customer Instruction Email Address Aadhaar Number Photo Signature Aadhaar Number Updated On Aadhaar Linked Account Customer Memo 3 Enter the CUST ID in the Selected Customer grid and click the Find button or click Advanced Search 85 ORACLE Search Fast Path SEARCH Customer Id Advance Customer Detail
114. the name address city country SSN TIN number etc of the selected customer This screen displays the account details of the customer such as account number account branch account currency customer name etc Image s Account Details Account Number Account Branch Account Product Account Currency Account Title Customer Name 15 Hot Keys 000000000075 Head Office 9999 1 IDR 360 ABDIREZATEA ABDIREZATEA ORACLE Hot Keys Hot Screen Descripti Image Ke Name on ys A Amount ile tee et eit S based screen Account displays Image the Display images on hebasis ec eee cel of the details maintaine din the Amount Amount Aned Account Image Deeley Based Operating Instruction Maintenan ce Fast Path 7116 option Amount Rated Operating Instruction 16 ORACLE Hot Keys Hot Screen Descripti Image Ke Name on ys A CBR Duringthe as H Details course of sans veme Hea wns Maintena banking n S m nce business it always helps to know the profitabilit y aspect of relationshi p with a customer Using this hot key you can get to know the volume of business associate d with the customer This ee screen gets populated whenever the Alt H are pressed at the Customer ID field This screen displays the details for the selected customer ID based on the CBR Details Maintenan ce Fast Path CIM18 option 17 ORACLE
115. to be levied as penalty at the account level Penalty applicable due to partial withdrawal can be done in two ways for all TD products at the bank level namely Absolute Method The absolute penalty can be defined as a fixed rate or floating rate Fixed interest rate is defined in Net Penalty Interest Rate field Floating interest rate is defined by selecting the corresponding interest index code in Net Penalty Index field Incremental Method Penalty can be defined as reduction in applicable TD interest rate This reduction can be either in the form of variance as defined in Incrernental Penalty Interest Variance or index code as defined in Incremental Penalty Index The standard penalty routine uses the incremental method Definition Prerequisite BAMOS Bank Master Maintenance GLMO2 Chart of Accounts Modes Available Add Modify Cancel Amend Authorize Inquiry For more information on the procedures of every mode refer to Standard Maintenance Procedures To add bank parameter 1 2 Type the fast path TDMO4 and click Go or navigate through the menus to Global Definitions gt TD gt TD Bank Parameters Maintenance The system displays the TD Bank Parameters Maintenance screen TD Bank Parameters Maintenance E Field Description 3 Orn one Click the Add button Enter the bank code and press the lt Tab gt key Enter the GL details and the interest rate details Click the OK butto
116. ty Criteria Maintenance for Customer Type Updation CIM78 Customer Information Maintenance ETM01 Customer Alerts Registration STM81 Customer Blacklist Details Modification 2000 CTI Customer Search 7004 Customer Name and Address Inquiry 7100 All Balance Inquiry BA008 Old New Customer Inquiry C1001 Contract Details Inquiry C1502 Offers Inquiry C1503 Create Lead C1504 Customer Service Maintenance C1999 Customer Zoom Inquiry CIM55 Customer ID Verification History Inquiry 126 ORACLE Appendix of Fast Path Fast Path 3000 7102 7103 7104 7105 7111 8053 CHM52 C1501 CIMO09 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 127 ORACLE Appendix of Fast Path 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 Accoun
117. ustomer Home Branch Display This column displays the home branch of the customer The branch in which the customer accounts in opened Postal Display Address This column displays the mailing address of the customer 3 Double click the record to view the account details for the selected customer Search 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 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 106 ORACLE Downloading Procedure 2 18 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
118. ut Principal Amount Book Date Value Date Maturity Date Type OTC Options Contract Reference Currency Contract Number Contract Amount Strike Price Primary Currency Option Premium Premium Pay Date Buy Sell Customer Search Description Display This column displays the banker s 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 Display This column displays the transaction amount Display This column displays the strike price Display This column displays 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 100 ORACLE
119. vance Payment against Credit Card TC Purchase Against Account 157 ORACLE Appendix of Fast Path Fast Path 5511 6575 7782 7783 8003 8004 8203 8204 8205 8301 8302 8305 8306 8307 Description 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 BC Liquidation Inquiry 158 ORACLE Appendix of Fast Path Fast Path 8309 1833 2833 8310 1838 2838 8314 8315 8316 8317 8319 8322 8324 8325 Description BC Liquidation BC Liquidation BC Liquidation Against A c UBS DD Liquidation DD Liquidation DD Liquidation BC Status Inquiry DD Status Inquiry TT Issue Walkin TT Issue GL TT Liquidation TT Lost Status Inquiry BC Revalidate DD Revalidate 159 ORACLE Appendix of Fast Path Fast Path Description 5525 Remittance Printing EC004 Scanning of ECS Passed Rejected Records 8326 Unclaimed BC DD Status Inquiry CH071 NSF Reject Log Inquiry STM73 Return Cutoff Maintenance STM75 Scan Reject Pass Disable Maintenance EC005 ECS Cutoff Marking Maintenance Module Name BackOffice Fast Pa
120. vertability 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 116 ORACLE Appendix of Fast Path Fast Path Description ORS41 Document Code Maintenance BA316 Village Master BA317 Centre Master BA318 Group Code Master BA431 LOB Master BA435 Branch Product Cross Reference BA436 Line of Business LOB Branch Cross Reference BA456 BAO Inquiry screen BA524 Product Code Product Type Cross Reference BAM02 Local Office Master Maintenance BAM17 Branch Type Maintenance BAM20 Bank Codes Maintenance BAM59 Branch Restricted for Online Registration for Net Banking BAM60 Product Category Maintenance 117 ORACLE Appendix of Fast Path 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 118 ORACLE Appendix of Fast Path Fast Pa
121. y This column displays the maturity date for loan Account Status Display This column displays the account status 92 ORACLE Column Name User Defined Status 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 Defined Status Mortgages Branch Code Product Code Account No Description Currency Amount Financed Amount Disbursed Customer Search 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 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 b

Oracle FLEXCUBE Core Banking

Contents

Download Pdf Manuals

Related Search

Related Contents