Home

Retail Loan Origination User Manual

1. Prospect Details X H save i Hold Leadid Branch 000 lez Application Type Retail Description Ki Date of Request 2011 01 04 CurrentStatus NEW New Account Number New Status lez Request ID E Conversation ID lez Channel FLEXCUBE LE Promotion Code Remarks EE Details Financial Requested Applicant Details 10f1 ERI EIE v Sequence Number Type Existing Local Branch Customer No Default Short Name Customer Name z z 1 Pimay e EE zH i lt m D City KJ First Name Kl SSN Country az Middle Name B Passport Number el Nationality az LastName i Passport Issue Date E Language lat Salutation L Passport Expiry Date E Es Customer Category LH Gender Existing Relationship Details Financial Currency az Date of Birth E Mobile Number i I Fe sonatin Te so th ei Credit Card Number Kl Landline Number MartalStaus sw ie Sl L Customer ID Account Email l D Dependents Number Fax Preferred Date of Contact E2 Preferred Time of Contact Any Time Documents Conversation Maker Date Time Mod No Checker Date Time Record Status Authorization Status You can specify the following details in this screen Lead Id Specify a unique identification for the prospective loan customer Description Specify a suitable description for the prospective loan customer Click on View Offers to view the multiple offers in the sub screen similar to
2. n m 5 Documents Tradeln KYCReview CustomerDedupe LoanDedupe CustomerMIS CustomerAccountMIS Customer AccountFields Seller Details us Remarks Remarks 27180 ORACLE 3 1 3 2 3 Maintenances Introduction As part of general maintenance required for the successful functioning of Corporate Loan Origination you should maintain the following in the system e SDE Maintenance e Template Definition Maintenance e Ratio Maintenance Maintaining System Data Elements In order to calculate financial ratios you can maintain System Data Elements SDEs using the SDE Maintenance screen You can invoke this screen by typing ORDSDEMT in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button SDE Maintenance B Save Group Worksheet Name Group Worksheet ElementType Corporate v Description 1 Of 1 SDE Name SDE Description Data Type SDE Type Derivation Required Number Static X Maker Date Time Checker Date Time Mod No Record Status Authorization Status Specify the following details Group Worksheet Name Specify the group worksheet name here Element Type Select the element type from the adjoining drop down list This list displays the followi
3. sssn men 2 65 2 23 1 Process Flow Diagram isis iine entitas daas 2 66 2 23 2 Process Malrix iii pauio 2 67 2 23 3 Main Tab aera tete idee ag dams un nde redeo 2 71 2 29 4 Details Tab iid edt doi gd ded ded dade edades 2 77 2 23 9 Financials Tab seda a oen lec a di aae ure AAT EER 2 80 223 6 Requested Tab oleae lee tens 2 83 2 23 Limit Tab iiie a a RR di ERR ea d e ET E RES 2 84 2 23 8 Collaterals TAO orraa T aen 2 86 2239 COMMONS Tab rasure ae pd it PR f RR EE aes 2 89 2 23 10 Capturing Document Details seen 2 90 2 23 11 Capturing Trade In Details 2 92 2 23 12 Verifying Customer Dedupe ssssss eene 2 93 2 23 13 Verifying Loan Dedupe onserer E OaE EA E seen 2 93 2 23 14 Capturing Customer MIS sse 2 93 2 23 15 Capturing Customer Account MIS 2 94 2 23 16 Specifying Customer Account Fields see 2 94 2 23 17 Specifying Collateral Seller Details sene 2 95 2 23 18 Viewing Vehicle Evaluator sssssss eene 2 97 2 23 19 Main Tab iiis is ba ER ER DA RURAL OE 2 105 2 23 20 Collateral Tab eiie it n teni ia nacen 2 105 2 23 21 Credit Score Tab ead ead dad eer ded s teats 2 108 2 23 22 Bureau Tab ass a ee esce EE EE eau een Posi Ven ue e Ea 2 109 2 23 23 Viewing Credit Bureau Report sse 2 115 2 23 24 Salios TD aia ARR ERR RA HERE ERR ea Rides 2 117 2 23 2
4. Reject Analysis Report Process Branch Rejected User Id From Date To Date Report Format Report Output Printer Specify the following details Process Select the process from the adjoining option list This list displays all valid processes maintained in the system If you do not select a process then system displays the report for all processes Branch Select the branch code from the adjoining option list This list displays all valid branch codes maintained in the system Tm ORACLE 4 6 1 Rejected User Id Select the user id from the adjoining option list This list displays all valid user ids maintained in the system If you select a process but not a user id then system displays the report for all user ids in a the selected branch If you select a user id but not a process then system displays the report for all processes for the selected user id From Date Specify the date from which the report should be generated Alternatively you can select the date from the adjoining calendar button To Date Specify the date till which the report should be generated Alternatively you can select the date from the adjoining calendar button Report Format Select the format in which you want to report to be generated from the options provided in the drop down list This list displays the following values e PDF e HTML e Excel e RTF Report Output Select the output for the report from t
5. AND or OR oat ORACLE 2 7 3 2 7 4 Specifying Credit Grades You can maintain different credit grades based on the credit scores obtained Click Rating button in Rule Details screens to invoke the Rating screen where you can maintain these details Rating 1 Of 1 Sequence Number You can specify the following details here Sequence Number The sequence number is automatically generated by the system Score Specify the score associated with a credit risk Grade Specify the credit grade based on the score obtained Specifying Auto Decision Details While creating a loan you need to decide whether the applicant is eligible to receive a loan from the bank Auto Decision feature in Oracle FLEXCUBE decides whether to approve or reject an application It also gives the stipulations or reasons for the decision To use this feature you need to maintain the Auto Decision details in Auto Decision screen E Auto Decision 10f1 E Serial Number Score Credit Decision Specify the following details 2 ORACLE 2 8 Serial Number The system displays the serial number Score Specify the maximum credit score of the loan applicant for the system to make the corresponding auto decision Auto Decision Specify the auto decision to be made for each credit score You can maintain the maximum credit scores for each of the following decisions
6. Elements Specify the data elements to be used to define the formula for credit ratio calculation or select the element from the option list provided Functions Select the mathematical function to be used to define the formula from the drop down list provided Braces Select the opening or the closing brace from the drop down list provided to define the credit ratio calculation formula Operators Select the mathematical operator to be used to define the credit ratio calculation formula You can select or f Viewing Credit Ratio Summary You can view a summary of the credit ratios in Credit Ratio Maintenance screen You can also query for a particular record based on desired search criteria ids ORACLE You can invoke this screen by typing ORSRATMT in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button Credit Ratio Maintenance Authorization Status Record Status Group Id aa Advanced Search Records per page 15 vj 1 0f 1 Authorization Status Record Status Group Id Description You can specify any of the following details to search for a record e Authorization Status e Record Status e Group Id Click Search button to search for a record based on the search criteria specified You can double click a desired record to view the detailed screen 2 11 Maintaining Override Details You can maintain the formulae to verify if ov
7. You can capture the details of the seller of the collateral using Collateral Seller Details screen This information helps you understand whether the application has been made for loan against used collateral However it is not mandatory to specify the collateral seller details for entering a retail loan application You can add the collateral seller details only after capturing the details of the collaterals in Collateral tab zu ORACLE To invoke Collateral Seller Details screen click Seller Details button on the Retail Loan Application Entry screen E Collateral Seller Details Application Number RetailLending4984 Collateral ld NEVWCOLLTEST ollateral Seller Details 101 HE Address 1 Address 2 Seller Id 1 Address 3 Seller Name Address 4 Seller Type Individual v Country Code zz Passport Number Nationality PA Passport Issue Date E gt Passport Expiry Date Ly Specify the following details Application Number The system displays the retail loan application number Seller ID The system displays the seller ID This is generated sequentially one 1 being the ID of the first seller Seller Type Select the type of seller from the drop down list The drop down list displays the following options e ndividual e Corporate Seller Name Specify the name of the collateral seller Nationality Specify the nationality of the collateral sel
8. Address 1 No of years known Number REFNO1 E Address 2 Relation eference Number laz AUdesS 3 TNT L Address 4 Country Code a Middle Name a zi Nationality IP pe Mobile Qe 79 Telephone Gender Male Y Documents Tradeln CustomerDedupe LoanDedupe CustomerMIS Customer AccountMIS Customer AccountFields Seller Details Previous Remarks Remarks Audit In this screen you can capture multiple address and employment and reference details Address Details Address Type Select the address type of the customer from the following options provided in the drop down list e Permanent e Home e Correspondence Address Mailing Check this box to indicate that the address you specify here is the customer s mailing address Address Line 1 3 Specify the address of the customer in three lines starting from Address Line 1 to Address Line 3 Country Specify the country associated with the address specified e ORACLE Zip Specify the zip code associated wit the address specified Contact Number Specify the contact telephone number of the customer Employment Details Employer Specify the name of the employer of the prospective customer Employment Type Select the customer s employment type from the drop down provided The following options are available e Part Time e Full Time e Contract Based Occupation Specify the occupation of the prospective customer Designatio
9. Branch a Investigation Agency 1 Of 1 EZ v Agency Code x Agency Name Contact Number Verification Type All m Maker Date Time Checker Date Time Mod No Record Status Authorization Status Specify the following details Branch Code Specify the branch code Agency Tab Under Agency tab you can capture the details of the investigation agency and the corresponding verification type Agency Code Specify a unique agency code The system will use this code to identify the agency whose details you are maintaining 29s ORACLE 2 19 2 Agency Name Specify the name of the investigation agency whose details you are maintaining Contact Number Specify the contact number of the agency Verification Type Select the verification type that you need to associate with the agency The drop down list displays the following verification types e Address Select Address to indicate that the agency deals in address verification only e Employment Select Employment to indicate that the agency deals in employment verification only e Collateral Select Collateral to indicate that the agency deals in collateral verification only e All Select All to indicate that the agency deals in all kind of verifications i e address employment and collateral verifications Select the appropriate one Others Tab Click Others tab on the Field Investigation
10. Horizontal Report ustomer Details Customer Branch Customer Name Customer Number az Industry Report Type Quarter To Quarter Report Generation Type Data Type x Year To Year Quarter To Quarter From Year H Year To Year n uarter1 juarter2 uarter3 uarter4 Report Format Printer At Clien Report Output Printer jaz Specify the following details Customer Details Customer Number Select the customer number from the adjoining option list This list displays all valid customer numbers maintained in the system If you do not select a customer number then system displays the report for all the customers Report Type Select the report type from the adjoining drop down list This list displays the following values e Quarter to Quarter If you select this option then system displays the report based on the values maintained in the Quarter to Quarter section e Year to Year If you select this option then system displays the report based on the values maintained in the Year to Year section Report Generation Type Select the report generation type from the adjoining drop down list This list displays the following values e Date Type If you select this option then the report displayed is a data type report e Graph Type If you select this option then the report displayed is a graphical report Year to Year From Year Specify the year from which you want to
11. J New Route Description Type Retail X Ratio Id 10tf1 Ratio Id Description Formula Farmila Maker Date Time Checker Date Time Mod No Record Status Authorization Status You can specify the following details in this screen Group Id Specify a unique identification code for the ratio group Description Specify a suitable description for the ratio group Type Specify the type of the loan You can choose one of the following loan types e Retail e Corporate Ratio Id Specify a unique identification for the credit ratio being maintained Description Specify a suitable description for the credit ratio id ORACLE 2 9 1 2 10 Specifying Formula Details You can specify the formula to calculate the credit ratio by clicking the Formula button corresponding to a ratio Id The Formula screen is displayed where you can specify the condition for calculating the credit ratio associated with a ratio Id Formula Wizard Formula 10f1 Ratio Type Condition Condition Builder F Stated Before You can specify the following details here Ratio Type Select the type of the ratio being maintained from the drop down list provided The following options are available e Stated Before e Stated After e Actual Before e Actual After Condition The condition specified using the Elements Functions Operators etc gets displayed here
12. Last Name Date of Bith 1982 03 01 SON Remarks No Mat Country GB Review Nationality GB The system displays the following details e Local branch code e First name of the customer e Middle name of the customer e Last name of the customer e Date of birth of the customer e Country of the customer e Nationality of the customer KYC Internal Status The system displays the internal KYC status Based on the records in Oracle FLEXCUBE the KYC internal status can be one of the following e Passed e Failed e No Match KYC Internal Remarks The system displays the internal KYC remark The internal remark can be one of the following e Possible Match e No Match Click Review button to check the customer details against the blacklisted customers list The system displays the following details SDN Status The system displays the SDN status Based on the records in Oracle FLEXCUBE the KYC SDN status can be one of the following e Passed 2 100 ORACLE e Failed e No Match SDN Remarks The system displays the SDN remark The SDN remark can be one of the following e Possible Match e No Match Click Ok to proceed to the next stage Click on the Review button to view the following screen Application Number RetaiLending1179 ie Customer No 001004388 KYC Review Details Local Branch 001 KYC intemal Status No Match First Name e KYC intemal Remarks io Match Middle Name SDN Status N
13. MIS Class MIS Code Application Number RetailLending4086 RIO Customer No 00006673 Local Branch 000 r7 Link to Group ChangeLog TransferLog 2 23 15 Capturing Customer Account MIS You can capture the MIS details for the Customer Accounts in Customer Account MIS Screen by clicking Customer Account MIS button The Customer Account MIS screen gets displayed where you can maintain the MIS details Customer Account MIS Application Number RetailLending4086 Customer 00006673 Branch Code 000 Account Account Class Currency GBP Transaction MIS Transaction MIS 1 Transaction MIS 2 Transaction MIS 3 Transaction MIS 4 Transaction MIS 5 Transaction MIS 6 Transaction MIS 7 Transaction MIS 8 d B Bis 1 fa a o Calc Method Rate Code Rate Type Reference Rate Spread Composite MIS Composite MIS 1 Composite MIS 2 Composite MIS 3 Composite MIS 4 Composite MIS 5 Composite MIS 6 Composite MIS 7 Composite MIS 8 Pool Code MIS Group Cost MIS Cost MIS 1 CostMIS 2 Cost MIS 3 Cost MIS 4 Cost MIS 5 O8 B 5 1 AAAA Pool Code Account Level Link to Group Default MIS Group Lg ChangeLog TransferLog 2 23 16 Specifying Customer Account Fields You can capture the user defined field details for the customer and customer accoun
14. Tradeln KYC Review CustomerDedupe LoanDedupe Customer MIS MIS Customer AccountFields LBL SELLER DTLS Vehicle Evaluator BureauReport LoanMIS LoanFields Prev Remarks Remarks Audit The credit agencies and the bureaus maintained for the Application Category are displayed in this screen You can capture the remarks and recommendations from these agencies in this tab You can also view the credit report obtained from the agencies and bureaus Credit Bureau Details Request Id The identification of the loan customer gets displayed here Bureau Code The credit bureau code maintained for the Application Category in Application Category Maintenance gets displayed here If you enable external credit checking for a particular applicant then you need to manually select the bureau from the option list Bureau Name The system displays the name of the credit bureau Recommended This indicates whether external credit check is required for the customer or not The following options are available in the option list e Recommended This indicates that external credit check is required for the applicant e Not Recommended This indicates that external credit check is not required for the applicant By default the system displays the appropriate option that is recommended or not recommended based on the external credit check settings for the application category Zoe ORACLE Status Select the status f
15. Application Branch 000 Application Date 2011 01 04 Promotion Code Application Number User Reference Application Priority Low Application Status Application Entry Conversation ID EU Details Financial Requested Limit Collateral Credit Score Bureau Ratio Loan Component Charge Investigation Comments Channel Intermediary Group KYC Required Auto Decision Required Applicant Details no E Type Existing LocalBranch CustomerNo Default ShortName CustomerName Nationalid Responsibility Liability RMID RMName City Country Nationality Language Customer Category Financial Currency Group Code Mobile ISD Code Mobile Number Home Phone ISD Home Phone Work Phone ISD Work Phone Email First Name Middle Name Last Name Salutation Mr Gender Male Birth Place Birth Country Date of Birth Mothers Maiden Name Marital Status Married Dependents SSN Account Details Power of Attorney Holder Name Address Country Nationality Telephone ISD Code Telephone Number US Resident Status Power of Attorney Permanent US Resident Status Visited US in last 3 years Fax ISD Code Account Branch lt m D Documents Tradeln KYC Review CustomerDedupe LoanDedupe CustomerMIS CustomerAccountMIS Customer AccountFields Seller Details Previous Remarks Remarks Audit The approver can send the application back to the previous stag
16. Apply button e You can explode the schedules in the component tab to view modified prequalification offer letter However the modifications done against a particular lead Id in the standalone simulation screen will not be displayed or saved in the lead screen for that lead Id Note The system generates the offer based on the promotion code and pricing code specified in the Prospect Details screen If a promotion ID is attached to the lead ID then on clicking View Offers the system displays only those application categories with which the product associated with specific promotion code is linked f promotion code is not specified then you can select any product code mapped to selected application category If pricing ID is attached to the application category then the offer specified in the Pricing Details screen is used for generating the offer letters You will not be able to change details as in standalone simulation screen or man ually select pricing id as in underwriting screen while simulating in the screen launched from the lead screen a8 ORACLE 2 5 1 Loan Tab You can maintain the offers for the customer in the loan tab Retail Loan Simulation Details E New amp Enter Query Enquiry ID Branch Status Active Enquiry Date Application Category User Reference Request ID Product Code Lead Id Request Date Description Customer Details Customer No
17. Default button the system defaults the local branch and automatically generates the customer number Responsibility Specify the Co Applicant s Responsibility for all parties other than primary Applicant Liability Specify the Co Applicant s Liability Percentage for all parties other than primary Applicant Sum of liability for all applicants should not exceed 100 uis ORACLE RM ID Specify the Relationship Manager ID of the Loan Applicants RM Name Specify the Relationship Manager name of the Loan Applicants You have to specify the following details City Specify the city of the customer Country Specify the country of domicile of the customer or select the country code from the option list provided Nationality Specify the country of which the customer is a national or select the country code from the option list provided Language Specify the primary language of the customer or select the language from the option list provided Customer category Specify the category to which the customer belongs or select the customer category from the option list that displays all valid customer categories Financial Currency Select the currency used in the transaction Group Code Specify the appropriate group code Mobile Number Specify the mobile number of the customer Landline Number Specify the landline number of the customer Email Specify the e mail address of the customer Fax Specify the fax number of
18. Main Details Financial Requested Limit Collateral Comments Requested Loan Details Requested Currency FE No ofinstallments 12 F Loan Against Salary Requested Amount Frequency 1 Rate Unit Monthly ad Tenor In Months Loan Type VehidleLoan Loan Purpose Loan Itemization Details 10tf1 majme SeriaiNo itemization Amount Comments Vehicle Details Vehicle Type Four Wheeler Purchase Type New Documents Tradein Customer Dedupe LoanDedupe CustomerMIS Customer Account MIS Customer AccountFields Seller Details Previous Remarks Remarks Audit Outcome o Specify the following details Requested Loan Details Requested Currency Specify the requested currency for the loan Requested Amount Specify the amount requested for the loan Interest Rate Specify the requested loan rate for the loan coa ORACLE Tenor In Months Specify the requested tenor for the loan Number of Instalments Specify the requested Number of Loan Instalments Schedules Frequency Specify the requested Loan Schedule Frequency Unit Specify the requested Loan Schedule Frequency Unit Basis Loan against Salary Check this box to indicate that the loan should be associated with the applicant salary account Purpose Specify the Purpose of the loan Loan Itemization Details Serial Number Specify the serial number Itemization Specify the tenor itemization that is required For examp
19. Marital Status Select the marital status of the prospective customer from the drop down list The following options are available e Married e Divorced e Remarried e Separated e Spouse Expired Dependents Specify the number of dependants for the customer SSN Specify applicant s SSN Passport Number Specify the passport number of the prospective customer EX ORACLE Passport Issue Date Specify the date on which the customer s passport was issued or select the date from by clicking the adjoining Calendar icon Passport Expiry Date Specify the date on which the customer s passport expires or select the date from by clicking the adjoining Calendar icon Existing Relationship Details You can maintain the following relationship details Relationship Type Specify the relationship type of the customer Credit Card Number Specify the credit card number of the customer Customer ID Account Number Specify the customer identification or account number of the customer Note The system defaults the above details for both the prospect and the existing customer if the application is submitted from external system 2o ORACLE 2 2 2 Details Tab You can capture the address and employment related details of the prospective customer in Details tab Prospect Details EA save 4 Hod Leadid Branch 000 a Application Type Retail Description Il Date of Request 201
20. income statement statement of cash flows or statement of retained earnings within the product You can capture the template related details through the Ratio Template Definition screen 39 ORACLE You can invoke this screen by typing ORDTEMDFEF in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button LMC Eligibility Ratio E New amp Enter Query Group Id 7 New Route Description Type Retail Y Ratio Id 10tf1 Ratio Id Description Formula Formula Maker Date Time Checker Date Time Mod No Record Status Authorization Status Specify the following details Group Id Specify the group id here Description Specify a brief description of the group id you are maintaining Type Select the credit ratio type from the adjoining drop down list This list displays the following values e Retail e Corporate e Ijarah e istisna e Mudarabah e Murabaha e Mushraka e Tawarooq Ratio Id Specify the ratio id here Description Specify a brief description for the ratio id you are maintaining a ORACLE Click the Formula button to build the ratio formula Formula Wizard Formula 1 0f 1 Ratio Type Condition Condition Builder Stated Before Specify the following details Formula Ratio Type Select the ratio type from the adjoining drop down list This list displays the following values e Stated Be
21. Birth Country Date of Birth Mothers Maiden Name Marital Status Dependents SSN Married Account Details Account Branch Account Class Power of Attorney Holder Name Address Country Nationality Telephone ISD Code Telephone Number US Resident Status Power of Attorney Permanent US Resident Status Visited US in last 3 years I n Documents Tradeln CustomerDedupe LoanDedupe CustomerMIS Customer Account MIS Customer AccountFields Seller Details Previous Remarks Remarks Audit The Application Number is automatically generated by the system You can capture the following details in the main screen Application Category Specify the loan application category to be used or select the application category from the option list provided Product Code Specify the retail lending product to be used for initiating the loan or select the product code from the option list provided Description The system displays the brief description on the selected retail lending product You cannot modify it 20 ORACLE 2 23 3 Application Branch The system defaults the application branch You cannot modify it Application Date The system defaults the branch date as the application date You cannot modify it Lead ID Specify the lead Id of the loan applicant or select the lead Id from the option list provided Enquiry ID Specify an enquiry Id if you wish to retrieve informati
22. Code Attribute Value Packageincluded Selected After specifying the mandatory details in Application Entry screen select the Outcome that you wish in the lower portion of the screen To move to the next stage select PROCEED as the outcome and click the Save icon You can select CANCEL to terminate the process if required The following validations are carried out in this stage e f any ofthe mandatory documents are missing the system displays an error message e If any ofthe override documents are missing the system displays an override message e If any mandatory customer information is missing the system displays error messages You will not be able to proceed to the next stage without correcting the errors if any On successful completion a message stating that the task is successfully completed gets displayed The system displays the system message as The task is completed successfully The workflow reference number is Retaillending lt nnnn gt oat ORACLE To acquire the next stage you need to go to the Task menu and select Assigned under Standard option All tasks that have been successfully completed are listed in the right side of the screen Select the checkbox against your Workflow Ref No and click Acquire button at the top of the screen to acquire the next stage of the task The system displays the system message as Acquire Successful on the successful acquis
23. Maintenance screen Field investigation Maintenance H save Agency Others Status 1 Of 1 Code Description Enabled ELCs Date Time Checker Date Time Mod No Record Status Authorization Status Under Others tab you can configure the statuses and results that should be enabled for the field investigation Status You can configure the statuses here The statuses that you enable here will be available at the following places for selection e Status field on the Investigation tab of Field Investigation Update ORDFIUPD screen e Status field on the Investigation tab at Retail Loan Underwriting Stage 28e ORACLE 2 19 3 You can add a new status or delete an existing status using the add row button or delete row button respectively Code Specify a unique code that identifies the status that you are maintaining Description Specify a brief description of the status Enabled Check this box to enable the status If you enable the status the system will allow you to use the corresponding status in the following places e Status field on the Investigation tab of Field Investigation Update ORDFIUPD Screen e Status field on the Investigation tab at Retail Loan Underwriting Stage If you do not check the box for a particular status you will not get that status for selec
24. Quarterly e Half Yearly e Yearly Rate Specify the interest rate to be associated with the loan Rate Code Specify the rate code used to derive the interest rate or select the rate code from the option list provided Check Select the required offer by clicking the Check option and click the Apply button The system will default all the details in the Loan Details pane When you click the Apply button available in the lower pane in Loan Details the system will populate the schedule details for the offer you have selected Click on View to view the generated offer letter on loans You can also check on each offer and go to components tab to view the offer details Format Select the format in which the offer letter should be generated Accepted Check this box to show that an offer is locked to be used in origination Note You cannot modify the details or re simulate the offers if the Retail Loan Origination screen is invoked from the Prospect Details screen Loan Details After applying the requested offer or on applying the loan without selecting the offer you need to specify the following financing details Loan Branch The system displays the branch code of the branch at which the loan enquiry was made Loan Account Number The system displays the loan account number Financing Currency The system displays the requested loan currency Financing Amount The system displays the requested loan amo
25. Required Check this box to enable external credit check If this box is checked it indicates that credit bureau pull is required for applications under this application category External Credit Check Required for Select the applicants for whom external credit check is required The drop down list displays the following options e All Applicants Select this to enable credit bureau pull for all the applicants e Only Primary Applicant Select this to enable credit bureau pull only for the primary applicant Select the appropriate one Amount Basis Check this box to set the requested loan amount as the basis for deciding whether external credit check required or not If you check this you need to specify the requested loan amount range to apply this rule If the requested loan amount falls within the range thus specified the system will initiate credit bureau pull If you have enabled credit bureau check and this box is not checked then the applications under this application category will be considered for external credit check irrespective of the requested loan amount Amount From If you have opted the requested loan amount as the basis for deciding requirement for external credit check then you need to specify the amount range Specify the minimum amount of the amount range Amount To If you have opted the requested loan amount as the basis for deciding requirement for external credit check then you need to specify the
26. T yon hun O Swe bere hon 2 23 2 Process Matrix The process matrix given below lists out the different stages the function Ids involved and the exit points for each stage ony ORACLE The following details are captured as part of this stage Document Capture Stage Comments rer Function Stage Stage Stage Title Description ld O tcom e 1 Application The following details are captured ORDR PROCEED Entry as part of this stage LAPP CANCEL Application Details Applicant Details Requested Lending Details Collateral Details Check List User Defined Fields and Com ments Document Capture Advice Generation 2 Application The details captured as part of ORDR PROCEED Verification Application Entry stage is verified LVER RETURN Document Capture CANCEL Stage Comments 3 Internal The Customer will be verified for ORDR PROCEED KYC Internal KYC check and reviewed LIKC CANCEL The following details are captured as part of this stage Document Capture Stage Comments 4 External The Customer will be verified for ORDR PROCEED KYC External KYC check and reviewed LEKC CANCEL 2 68 ORACLE Stage Stage Title Description Function Id Stage Outcome Underwrit ing The following details are captured as part of this stage Collateral Valuation Information Applicant Financial Ratios Applicant Credit Score Applicant Bureau Report Loan Offers Loan Schedul
27. Trade Lines Public Records Collections Fraud Messages Inquiries Also Known As Consumer Statement Credit Scores Inquiries M 4 1011 gt Hl VICHIDU2 1234 EQFX 2013 03 19 o n 644 Inquirer Name Inquirer Subscriber amp t Inquirer Industry Code Inquiry Date Rate Shopping Duplicate i aes ORACLE Also Known As Credit Bureau Report Application Number RetailLending3852 Customer No 000006150 Requested Id 644 Bureau Code EQFX Report Header Bureau EQFX Credit Report Id 644 First Name ReportDate 2013 08 21 MiddleName Uniqueld 644 Last Name OnFileDate 2013 08 21 E Birth Date 1981 05 18 7 Best Match Summary 1 Summary 2 Trade Lines Public Records Collections Fraud Messages Inquiries Also Known As Consumer Statement Credit Scores Also Known As 10f1 F vi First Name M LastName Suffix Spouse First Name Consumer Statements Application Number RetailLending3852 Customer No 000006150 Requested Id 644 Bureau Code EQFX Report Header Bureau EQFX Credit Report Id 644 First Name ReportDate 2013 08 21 MiddleName Uniqueld 644 LastName OnFile Date 2013 08 21 E Birth Date 1981 05 18 7 Best Match I Summary 1 Summary 2 Trade Lines Public Records Collections Fraud Messages Inquiries Also Known As Consumer Statement Credit Scores Consumer St
28. Type Customer Id You can specify any of the following details to search for a record e Authorization Status e Record Status e Request ID e Lead Id e Application Type e Customer ID e Loan Type e Channel e Branch Click Search button to search for a record based on the search criteria specified You can double click a desired record to view the detailed screen Zw ORACLE 2 4 Maintaining Status Reason You can maintain the status reason codes and reason description against a specific status through the Status Reason Maintenance screen To invoke this screen type ORDSTRMT in the field at the top right corner of the Application tool bar and click the adjoining arrow button Status Reason Maintenance lex Save Branch Application Type Retail Process Stages Process Code laz Description Status Definition 10f1 v Status Enable lag E Reason Code x Description FE Maker Date Time Mod No Checker Date Time Record Status Authorization Status You can capture the following in this screen Branch Select the branch from the adjoining option list Application Type Select the application type from the adjoining drop down list The available options are e Retail e Corporate e CASA Process Stages Process Code Select the process code against which the particular status is used from the adjoining option list Descript
29. Unean g Application Date 2011 01 04 Conversation ID Promotion Code Main Details Financial Requested Limit Collateral Credit Score Bureau Ratio Loan Component Charge Investigation Comments Component Name Main Component 10f 1 Component Currency Cai E pitaiized Liquidation Mode Auto X Exolode Schedule Waive Verify Funds Schedules AOA s E Schedule Type Schedule Flag Formula FirstDueDate No ofSchedules Frequency DueDateOn Schedule Start Date End Date Units Am Documents Tradeln KYCReview CustomerDedupe LoanDedupe CustomerMIS Customer AccountMIS Customer AccountFields Seller Details Vehicle Evaluator Bureau Report LoanMIS LoanFields Previous Remarks Remarks Audit You have to specify the following details Component Name Select the name of the loan component Component Currency Select the loan component currency code 2 120 ORACLE Liquidation Mode Select the mode of liquidation from The adjoining drop down list displays the following optiins e Auto e Manual Main Component Check this box to indicate if the provided component is main component Capitalized Check this box to indicate that the component needs to be capitalized Waive Check this box to indicate that component needs to be waived Compound Days Specify the number of compound days Compound Months Specify the number of compound months Compound Years Specify the num
30. a month for calculation from the adjoining drop down list You can select one of the following options e 30 euro e 30 US e Actual iod ORACLE 2 5 3 2 5 4 After the loan application has been created in the system if you select the Enquiry ID specified here the system will default the requested details for the offer selected here in the Retail Loan Application Entry screen in the Requested tab You can only view the details in the screen At the Underwriting stage the system will default the loan details which you can modify in the Loan tab of the Retail Loan Underwriting Stage screen Viewing Disbursal Details You can view the disburse details on Disbursals screen To invoke this screen click Disburse Details button in the Components tab of the Retail Loan Simulation Details screen Disbursals Application Number RetailLending3248 i Component Name PRINCIPAL Disbursals 10f1 V Schedule Date Total DisbursementAmount Amount To Disburse Already Disbursed Amount v 2012 03 05 100000 100000 0 Split Details 10fi HHE O Split Sequence No Split Percent Payment Mode Settlement Branch Settlement Account Number o 50 ACC 000 a 0000000000009 28 ica 50 ACC o01 az 0010000001031 az This screen displays the disbursal details Viewing Schedule Details You can view the schedule details on Schedule Details screen To invoke t
31. amount range Specify the maximum amount of the amount range If you have enabled amount as the basis and specified the range then while processing the application the system will decide whether to enable external credit check based on the requested loan amount Account Class Details Note This section is applicable only for CASA accounts nd ORACLE You can link the required account classes to the application category here Account Class Specify a valid account class you need to link with the application category The adjoining option list displays a list of available account classes Select the appropriate one You can link an account class to only one application category However you can link multiple account classes to an application category Account Description The system defaults the description associated with the specified account class here Default Check this box if you need to maintain the account class as the default option Offer Details You can capture the additional details related to the loan product here Offer Id Specify a unique identification for the loan offer being made to the customer No of Installments Specify the number of instalments associated with the loan Units Select the units based on which the loan disbursement should be carried out The following options are available in the option list e Daily e Weekly e Monthly e Quarterly e Half Yearly e Yearly F
32. application number for which you need to generate the report Account Number Specify the account number for which you need to generate the report Once you have specified the details click OK button The system generates the report 4 2 1 Contents of the Report The contents of the report are discussed under the following heads Header The header carries the report title run date and time branch code and branch name Body of the Report The following details are displayed in the report Field Name Description Seller ID The seller ID generated by the system Seller Type The type of seller whether individual or corporate Seller Name Name of the seller Nationality Nationality of the seller Passport Number Passport number of the seller Passport Issue Date Date of issue of the seller s passport ORACLE 4 3 4 3 1 Field Name Description Passport Expiry date Date of expiry of the seller s passport Address Line 1 Address of the seller Address Line 2 Address of the seller Address Line 3 Address of the seller Address Line 4 Address of the seller Country Country of the seller Reference Details Report You can generate a report with the details of the reference for a retail loan application or account using Reference Details Report screen To invoke this screen type RLRPREFR in the field at the top right corner of the application tool
33. completed the task will be in underwriting stage itself Note If you are enabling external credit check for more than one applicants primary co appli cant then after checking the option External Credit Check Required for each applicant in the Main tab you need to initiate at least one credit bureau pull for each applicant se lected If external credit check is enabled for an applicant at underwriting stage you will not be allowed to disable it External Credit Rating External Agency Specify the external agency that you want to use for the evaluation If you do not specify a value here the system will display an error message Recommended Select the recommendation of the credit agency for the loan requested from the following options provided in the drop down list e Recommended e Not Recommended zm ORACLE Remarks Specify remarks if any associated with the loan application Status The following statuses are available e Initiated e Completed The evaluation will be done only if the external agency has been specified and the Recommended field has the value Recommended status is RECOMMENDED For any other combination of values for the two fields the system will display an error message and will not proceed with the evaluation till the values are set as specified above After entering the required details select VERIFY as the Outcome and click Save If you have indicated
34. customer are displayed here You can capture the following additional details here zen ORACLE 2 23 25 Actual Monthly Income Specify the actual monthly income of the customer based on documentary proof provided Monthly Debt Specify the actual monthly debt of the customer based on documentary proof provided Click Calculate Ratios button to calculate the asset liability ratios for the customer What if Pmt Amt Specify the EMI amount that the customer is ready to pay Click Update Ratio button to update the asset liability ratios for the customer taking into account the EMI payments also The ratios for Installment Loan To Value and Disposable Income are calculated for the following conditions e Stated Before e Stated After e Actual Before e Actual After Loan Tab In the Loan tab the system displays the list of the multiple loan offers that are attached to the application category specified If you have selected an Enquiry ID for the customer then the loan details that have been stored for the corresponding loan proposal are displayed here You can modify these details if required Retail Loan Underwriting B Save 4m Hold Application Category RCAT1 Leadid Application Number RetailLending3899 Product Code LRT4 Enquiry ID User Reference 000LRT411004001 Description Demand loans with Co Application Priority Low X Application Branch 000 Application Status Underwritin g Applicati
35. enabled in Others tab of the Field Investigation Maintenance screen for the selected agency Call Date If the agency has conducted the investigation over the phone specify the date on which the phone call was made Number of Attempts Specify the number of attempts made to investigate This includes the number of visits phone calls and other attempts that were made during investigation Spoke To Specify the name of the person to whom the investigation agency has spoken in order to get the information verified Result Specify the result of the investigation The drop down list displays all valid results that are enabled in Others tab of the Field Investigation Maintenance screen for the selected agency Remarks Specify the remarks with regard to the investigation if any Note If the investigation is done for an application number maintained in the Investigation Up date screen ORDFIUPD the details will be defaulted in the Field Investigation tab at the underwriting stage of the that application The system will allow you to modify the investi gation details at the underwriting stage Such modifications are automatically updated in Field Investigation Update screen for that application number You can view the investigation report associated with the customer by clicking the Report button 2 23 29 Comments Tab In this tab you can capture the comments by the users alan ORACLE Reta
36. for the risk factor associated with the loan System defaults the Category and Question as maintained in the Rule Click Calculate button to display the calculated grade and score based on the selected answer Click Calculate button to calculate the credit score and the grade based on the formula maintained for calculating the credit score The Grade and the Score are displayed based on this calculation 2 23 22 Bureau Tab You can interface with external credit bureaus and view report obtained from them in Bureau tab Based on the reports that are obtained from the external bureaus the underwriter determines whether to approve the loan to the customer or not 2 109 ORACLE Retail Loan Origination E New E Enter Query Workflow Reference Priority Low MI Application Category Lead Id Application Number Product Code Enquiry ID User Reference Description Offline Application Application Priority Low Y Application Branch Number Application Date Promotion Code Application Status Application Entry Conversation ID Applicant Details Type Primary Y Local Branch Customer No Customer Name Main Details Financial Requested Limit Collateral Credit Score EMEEN Ratio Loan Component Charge Investigation Comments External Credit Rating 1 Of 1 Request ID External Agency Bureau Name Recommended Status Remarks NotRecommended Not Required m Documents
37. generate the report Alternatively you can select the year from the adjoining option list To Year Specify the year till which you want to generate the report Alternatively you can select the year from the adjoining option list ixi ORACLE 4 5 1 Quarter to Quarter Year Specify the year in which you want to generate the quarter to quarter report Alternatively you can select the year from the adjoining option list Quarter1 Check this box to generate the report for the first quarter of the selected year Quarter2 Check this box to generate the report for the second quarter of the selected year Quarter3 Check this box to generate the report for the third quarter of the selected year Quarter4 Check this box to generate the report for the forth quarter of the selected year Report Format Select the format in which you want to report to be generated from the options provided in the drop down list This list displays the following values e PDF e HTML e Excel e RTF Report Output Select the output for the report from the adjoining drop down list This list displays the following values e Print Select this option if you wish to print the report e View Select this option if you wish to view the contents of the report e Spool Select this option if you wish to spool the report for further use Printer At Select the location where you want the report to be generated from the options provided in the
38. is a permanent US resident Visited US in last 3 years Check this box to indicate that the beneficial owner has visited US in the last three years 218 ORACLE 2 23 4 Details Tab The address and employment related details of the customer corresponding to the Lead ld selected are displayed in this tab You can modify these details if required Retail Loan Application Entry Fl save lt i Hold Application Category Leadid sz Application Number RetailLending3796 C5 Product Code Enquiry ID PE User Reference Description Education Loans c Application Priority Low Application Branch 000 Application Status 4 nt pplication Entry Application Date 2011 01 04 Default Conversation ID PL Promotion Code Applicant Details Type Primary Local Branch 000 CustomerNo 000003171 Customer Name c Main Details Financial Requested Limit Collateral Comments Address Details 4or1 gt HE Address Line 1 e Country PEAREN T Address Line 2 f Zip Fi UP Address Line 3 e Contact Number Correspondence Address v 7 Current Employment Details 10f1 Address Line 1 Extension Employer Address Line 2 Contact Phone Emplo wein e eam 1 Address Line 3 Contact Name Se Country Contact Extension Zip Comments Designation Phone Number Department Employee Id Customer Reference Details 10f 1 3
39. of the Application tool bar and clicking the adjoining arrow button KYC Review Application Number RetailLending1179 Customer No 001004388 KYC Review Details Local Branch KYC Extenal Status No Match First Name Middle Name Last Name Date of Birth 1982 03 01 Country GB Rewew KYC Extenal Remarks No Match SON Status No Match SON Remarks No Match Nationaity GB The system displays the following details e Local branch code e First name of the customer 25108 ORACLE e Middle name of the customer e Last name of the customer e Date of birth of the customer e Country of the customer e Nationality of the customer KYC External Status The system displays the external KYC status Based on the records in Oracle FLEXCUBE the KYC external status can be one of the following e Passed e Failed e No Match KYC External Remarks The system displays the external KYC remark The external remark can be one of the following e Possible Match e No Match Click Review button to check the customer details against the blacklisted customers list The system displays the following details SDN Status The system displays the SDN status Based on the records in Oracle FLEXCUBE the KYC SDN status can be one of the following e Passed e Failed e No Match SDN Remarks The system displays the SDN remark The SDN remark can be one of the following e Possible Match e No Match Click Ok to proc
40. operators are Operator Description Equals To gt Greater Than gt Greater Than or Equals To lt Less Than lt Less Than or Equals To Score Specify the score for each condition Elements Select the element from the adjoining option list If the loan requested details satisfies the condition specified in the pricing maintenance then the corresponding score gets added If the details do not satisfy the condition then zero will be considered as default score Functions Select the mathematical function to be used to define the formula from the drop down list provided Braces Select the opening or the closing brace from the drop down list provided to define the credit score calculation formula one ORACLE 2 18 2 Operators Select the mathematical operator to be used to define the credit score calculation formula 64 GP You can select or f Logical Operators Select the logical operator to be used to define the credit score calculation formula You can select lt gt lt gt gt lt AND or OR Based on the formula and the loan application category the system automatically applies a price ID to the application You can apply a different price ID that matches the application only at the Underwriting Stage If you change a price ID selected by the system and reapply a different price ID the system
41. the customer First Name Specify the first name of the customer Middle Name Specify the middle name of the customer Last Name Specify the last name of the customer Salutation Select the salutation preference of the customer from the drop down list provided You can select any of the following options en ORACLE e Mr e Mrs e Miss e Dr Gender Select the gender of the customer from the drop down list Birth Place Specify the birth place of the customer Birth Country Specify the birth country of the customer Date of Birth Specify the date of birth of the customer or select the date by clicking the Calendar icon provided Mother s Maiden Name Specify the customer s mother s maiden name Marital Status Select the marital status of the prospective customer from the drop down list The following options are available e Married e Unmarried e Divorcee e Separated e Spouse Expired Dependents Specify the number of dependents for the customer SSN Specify the SSN of the customer Passport Number Specify the passport number of the customer Passport Issue Date Specify the date on which the customer s passport was issued or select the date from by clicking the adjoining Calendar icon Passport Expiry Date Specify the date on which the customer s passport expires or select the date from by clicking the adjoining Calendar icon Account Branch Specify the branch at which the
42. using add row button Once you have specified all the details save the maintenance 2e ORACLE The following credit bureaus are already available in the system Bureau Name Bureau Code Equifax EQFX TransUnion TRUN Credco CRDC Experian EXPN CIBIL CIBL You can add the details of other credit bureaus as per requirement 2 21 4 Viewing Credit Bureau Summary You can view a summary of credit bureau details maintained in the system using Credit Bureau Details screen To invoke the screen type ORSCBRMT in the field at the top right corner of the application toolbar and click the adjoining arrow button Credit Bureau Details E Search Ct Advanced Search Reset KY Clear All Case Sensitive Authorization Status Bureau Code Records per page 15 x L i 10f1 Authorization Status i Record Status Record Status Bureau Code You can search for the records based on one or more of the following parameters e Authorization status e Record status e Bureau code Once you have specified the search parameters click search button The system displays the following details of each result e Authorization status e Record status 2 62 ORACLE 2 22 e Bureau code Maintaining ZIP Code Details for Bureau Call Order You need to maintain the ZIP codes and the order of credit bureau pull using Zip Code Maintenance screen This maintenance enabl
43. vehicle Loan Requested Amount Tenor In Months Loan Purpose ehicle Details Vehicle Type Four Wheeler x Purchase Type New Requested CASA Details Type of Account Current Account Purpose of Account JOverdraft Limit Required Documents Conversation Maker Date Time Mod No Checker Date Time Record Status Authorization Status You can capture the following details here Requested Loan Details Requested Currency Specify the loan currency preference of the customer or select the currency from the option list provided Requested Amount Specify the loan amount requested by the prospective customer Tenor in months Specify the preferred loan tenor in months of the prospective customer Rate Specify the preferred interest rate of the prospective customer Loan Type Select the loan type from the adjoining drop down list Loan Purpose Specify the Purpose of the loan Vehicle Details Vehicle Type Select the type of vehicle for which the loan is requested from the adjoining drop down list Purchase Type Select he purchase type from the adjoining drop down list in ORACLE Requested CASA Details Note This section is applicable only for CASA Lead origination Type of Account The system displays the type of account Purpose of Account The system displays the purpose of the account Overdraft Limit Required Check this box if overdraft limit is required 2 2 5 Documen
44. will check for the data within the FLEXCUBE database If there are none for the corresponding vehicle it will try to obtain the details from the external agency and display them in the Vehicle Evaluator screen 25197 ORACLE 2 23 21 Vehicle Evaluator Vehicle Details Valuation Source INTERNAL Model Identification Number Body Year Usage Make Vehicle Valuations Wholesale Value Attribute Value Retail Value Total Value Usage Value Vehicle Attributes 1010 E Attribute Description Attribute Code Attribute Value Package Included Oo 33 m D o In this screen you can view the information available for the vehicle based on the information provided by you If the information in this screen matches the details available in the system database for the same vehicle the status is updated to COMPLETED in the collateral tab If it does not match then the status is updated to NO DATA Once the verification is completed you can select the Outcome as PROCEED and move to the next stage Note For more details on capturing Collateral details refer the chapter titled Maintaining Collat eral Details in Enterprise Limits and Collateral Management user manual Credit Score Tab The credit score tab is used to calculate the credit score details of the customer You can also interface with external Credit engines and display recommendations and report Internal Cre
45. 013 08 21 MiddleName Uniqueld 644 LastName OnFile Date 2013 08 21 E Birth Date 1981 05 18 7j Best Match Summary 1 Summary 2 Trade Lines Public Records Collections Fraud Messages Inquiries Also Known As Consumer Statement Credit Scores Collections 10f1 gt Go E W Creditors Name Account Acct Balance High Balance Term Type Balance Date OpenDate LastActivi g CHIDU2 35000 1000000 Monthly 2012 0203 20130402 2013 03 Fraud Messages Credit Bureau Report Application Number RetailLending3852 Customer No 000006150 Requested Id 644 Bureau Code EQFX Report Header Bureau EQFX Credit Report Id 644 First Name ReportDate 2013 08 21 MiddleName Uniqueld 644 LastName OnFileDate 2013 08 21 Birth Date 1981 05 18 7 Best Match Summary 1 Summary 2 Trade Lines Public Records Collections Fraud Messages Inquiries Also Known As Consumer Statement Credit Scores Fraud Messages 10t1 Gs E Fi Product Message Fraud Message No Fraud Message Inquiries Credit Bureau Report Application Number RetailLending3852 Customer No 000006150 F Requested Id 644 Bureau Code EQFX Report Header Bureau EQFX Credit Report Id 644 First Name ReportDate 2013 08 21 MiddleName Uniqueld 644 LastName OnFile Date 2013 08 21 E Birth Date 1981 05 18 Best Match Summary 1 Summary 2
46. 1 01 04 Current Status NEW New Account Number New Status ae Request ID M Conversation ID PI Channel FLEXCUBE laz Promotion Code Remarks Applicant Details Type Primary EJ Customer Name TOM E Main Financial Requested Address Details 410r31 LIE Address 1 Ki Pin Code A N Sa ddress 2 2 Contact Number pace jal Address 3 iei Country a Hcurrent gel Employment Details Address 1 Extension eL E Address 2 ei Contact Phone pa Address 3 E Contact Name B Employment Type Full Time permanent E o i ES _ Address 4 e Contact Extension te ie eme fe Country nz Department eS as a Pin Code Comments e d 2 x x Be Phone Number Business Details Type of Business Currency Name of Business Annual Turnover Type of Ownership Others Documents Conversation Maker Date Time Mod No Checker Date Time Record Status Authorization Status Address Details Address Type Select the address type of the customer from the following options provided in the drop down list e Permanent e Home e Correspondence Address Mailing Check this box to indicate that the address you specify here is the customer s mailing address Address Line 1 4 Specify the address of the customer in four lines starting from Address Line 1 to Address Line 3 Pincode Specify the zip code associated wit the address specified Contact Number Specify the contact telephone number of the customer Coun
47. 2 2 10 Interaction Integration of the External System ssssssss 2 18 2 3 Viewing Loan Prospect Summary ssssesssseeee enne nene nnns 2 19 24 Maintaining Status REASON aair aa a eene ener 2 20 2 441 Creating Customer Number sss 2 21 2 5 Simulating Retail LOANS n r enalia rE AAAA LE Ea AAEE RE AAA iaaa Ta 2 22 2 5 1 Loan Lab irera rin A R AEE Heine a ut ede Ema dna EEL A 2 26 2 b 2 Gomponent 8D iino te p d ere ipae agde tots 2 28 2 5 3 Viewing Disbursal Details sss 2 30 2 5 4 Viewing Schedule Details sse 2 30 2 6 Viewing Simulated Loan Details sssse ee 2 31 2 Maintaining Credit Rating Rules ssssssene eene nenne 2 32 241 Main Tab sod i ee d ne d uas 2 32 2 2 Risk Factor Lab eise teen ete cte a dee cnn AN Er AEE Ei 2 33 2 743 Specifying Credit Grades sse 2 35 2 4 Specifying Auto Decision Details seen 2 35 2 8 Viewing Credit Rule Summary sssssssee eene nnne nene 2 36 2 9 Maintaining Credit Ratios sssssseenne nm nemen 2 37 2 9 1 Specifying Formula Details sssssssssseeeeen eene 2 38 2 10 Viewing Credit Ratio Summary sssssee eene eee eene enne 2 38 2 11 Maintaining Override Details ssssee mene 2 39 2 12 Viewing Override Summary yo eroaan re EEEE E nennen nnns 2 41 2 13 Maintaining D
48. 5 LOAN Tab sebum inp uS NEWER 2 118 2 23 26 Component Tab ibo REDE 2 120 2 23 27 Charges lab aie etu E Le Ra nome AEREE due 2 123 2 23 28 Investigation Tab saene rrean rinia e aaa e Rei AEE Aia nn 2 124 2 23 29 COMMONS TaD rriti v TEAR 2 125 Be MA INTCMANCES mem unn iin 3 1 3 1 Introduction 2 EEE e A A EE AA 3 1 3 2 Maintaining System Data Elements sss emen 3 1 3 3 Defining Template for Calculating Ratios ss 3 3 3 4 Maintaining Ratio Details cecinere nnne ttes 3 5 iuo ga e C eeeccndctate sec ece be rcaaslenworcebecet A A 4 1 4A Jntroduction eee Raden evel an el at tee e ees eae a eves 4 1 4 2 Collateral Seller Details Report c ccccccceceeceeeseeeeeceneeeceeeeeeeeeeeseesecseecaeeaeeeeeees 4 1 4 2 1 Contents of the Report ssssssssssssssssesei sentent nnne 4 2 4 3 Reference Details Report ssssssssssssssssssseeeererrere eren enne 4 3 4 3 1 Contents of the Report sssssssssssssssssssei senes nnn 4 3 4 4 Business Analysis Report ssssssssssseeeeeeeneen mener nennen nen 4 4 4 4 1 Contents of the Report sssssssssssssss essent nhe nnne 4 6 4 5 Ratio Analysis Report ouibus Lid Hee a code ea Lon dd ec de Lie 4 6 4 5 1 Contents of the Reports d t itt rette aset ses queis 4 8 4 6 Reject Analysis Report areren a aeaea EE anA AEEA AEAEE TAA E 4 9 4 6 1 Contents of th
49. Branch 000 Character Flelds HANNON NNO HNN HANAN AA e c c e e e iS c c c e c e e c g c Number Fields 0 00 0022902070 2 23 24 Ratios Tab In the Ratios tab the system calculates the stated and actual income debt ratios and also calculates the ratio based on What if payment amount Retail Loan Underwriting PA E Save dh Hold Application Category RCAT1 Lead Id Application Number RetailLending3899 Product Code LRT4 Enquiry ID User Reference 000LRT411004001 Description Demand loans with Co Application Priority Low Application Branch 000 lication Status Underwritin Application Date 2011 01 04 spi ITI Conversation ID Promotion Code Applicant Details Type Primary gt Local Branch 000 CustomerNo 000006150 CustomerName CHIDU2 Main Details Financial Requested Limit Collateral Credit Score Bureau Ratio Loan Component Charge Investigation Comments Stated Actual Assets Monthly Income Monthly Income Liabilities Monthly Debt Monthly Debt Net Worth What if Payment Amt Ratios 10f1 gt 7 Ratios StatedBefore Stated After Actual Before Actual After A Documents Tradeln KYC Review CustomerDedupe LoanDedupe CustomerMIS Customer Account MIS Customer AccountFields Seller Details Vehicle Evaluator Bureau Report LoanMIS Loan Fields Previous Remarks Remarks Audit Outcome Exit The stated income and debt of the
50. Client Report Output Print e Printer zz User Select the User from the adjoining option list Branch Select the branch from the adjoining option list Status Select the status from the adjoining option list 4 8 1 Contents of the Report The parameters specified while generating the report are printed at the beginning of the report Other content displayed in the Report is as follows s ORACLE 4 9 4 9 1 Header The Header carries the title of the Report information on the branch code branch date the date and time of report generation the user ID of the user generating the report module page and the event date Body of the Report The following details are displayed as body of the generated report Field Name Field Description Lead ID Indicates the lead ID created by the user ID User ID Indicates the user ID Branch Indicates the branch Status Indicates the status of the loan request Converted Leads Report You can invoke the Converted Leads screen by typing the RLRPCOVR in the field at the top right corner of the Application tool bar and click on the adjoining arrow button Converted leads UserID Branch az Status Report Format PDF Printer At Client Report Output Print Printer az User Select the User from the adjoining option list Branch Select the branch from the adjoining option list Status Select the st
51. Customer AccountFields Seller Details l Previous Remarks Remarks Audit s ANNG ES The verifier can choose to send the application back to the previous stage if the information provided is not adequate or choose to cancel it if the information captured is not satisfactory If the applicant application and document details are verified successfully the verifier can proceed with the processing of the application by selecting PROCEED as the Outcome The verifier can select RETURN to return the process to underwriting stage for data correction or CANCEL to terminate the process On successful completion a message stating that the task is successfully completed gets displayed The customer customer account collateral etc are created in the system on completion of the Document verification stage Step 2 Manual Retry Manual Retry Stage is an optional stage If the system faces any issues while creating Customers or Customer s Accounts or Customer s Limits the loan application is moved to Manual Retry stage You can do any corrections in the requested Loan Application and retry the task In this stage the verifier can provide the corrected information based on the issues thrown by the system while processing the Loan This stage will be retried until the Loan gets booked in the system You can invoke this screen by typing ORDRLMCU in the field at the top right corner of the Application tool bar and clicking th
52. FCUBS for this status Request ID Lead ID Review Status as Review Request ID Lead ID Offer Generated Status as Offer gener DMS reference number ated unique offer Reference numbers Request ID Lead ID Converted Status as Converted Status Lead ID Request ID Closed Status as Closed Reason selected against this status Request ID Lead ID Rejected Status as Rejected Reason selected against this status Request ID Lead ID 2 16 ORACLE 2 2 9 Conversation Details Click on Conversation in the Prospect Detail screen to invoke the Conversation Input screen Conversation Input ustomer Details Customer ID 000003171 Customer Name onversation Details amp Conversation ID 0000001075 Priority Low Conversation Category CallRepot Conversation Date 2011 01 04 E Conversation Status Open z Venue Branch Conversation Time 17 11 Target Closure Date El Conversation Mode N A LastChangedOn 2011 01 04 17 11 00 Department Details Department Other Department Senior Management User Role Role Assigned To az Involved Rove la Other Offices Involved hannel Details Direct Access Channel No External System User ID Channel User ID Message Details Orginal Request Subject Detail Documents Presented Replyto Customer No Closure Remarks Customer Conversation Do
53. First Name Contact Number Last Name Email Requested Loan Details Requested Currency Rate Loan Purpose Requested Amount Tenor In Months Genarate Offers t Loan Component Multiple Offers 10f1 Offer Reference Number Offerid Nooflinstallments Frequency Unit Rate RateCode View Format Accepted Loan Details Loan Branch Value Date Frequency Loan Account Number Maturity Date Unit Monthly Financing Currency Installment Start Date Liquidation Mode Auto E Financing Amount Status Change Mode Auto gt Annly No ofinstallments 12 Effective Date User Defined Element Values 10f 1 H ES 10f1 H E Effective Date User Defined Elementid User Defined Element Value Rate Code Codeusage Resolvedvalue Maker Date Time Mod No Checker Record Status Date Time Authorization Status Enter the following details here Offer Reference Number The system displays a unique reference number for each offer Offer ID Specify a unique identification for the loan offer being made to the customer No of Instalments Specify the number of instalments associated with the loan Frequency Specify the frequency at which the loan disbursement should be carried out Units Select the units based on which the loan disbursement should be carried out The following options are available in the option list e Daily e Weekly id ORACLE e Monthly e
54. Haircut Revision Schedule details for any collateral linked to the Loan Effective Date Specify the Collateral Value evaluation date Haircut Specify the haircut for evaluating the Collateral Value in the provided effective date In this screen specify the following details to facilitate vehicle evaluation Vehicle Details You can capture the details of the vehicle which is to be evaluated in the following fields Identification Number Enter the unique identification number associated with the vehicle Vehicle Number Specify the vehicle number Year Specify the year of manufacture for the vehicle Make Specify the make of the vehicle Model Specify the vehicle model Body Specify the vehicle body details ans ORACLE 2 23 9 Usage Specify the mileage used by the vehicle till date Valuation Source Select the collateral Vehicle Valuation Source from the adjoining drop down list You can select one of the following e None e Internal Valuation Status Select collateral vehicle valuation status from the adjoining drop down list You can select one of the following e Recommended e Not Recommended Vehicle ID Specify the vehicle identification number These details will be used at the underwriting stage to evaluate the vehicle Covenant Details Covenant Name Specify the collateral s covenant name Due Date On Specify collateral s covenant due date on Frequency Specify the c
55. Header The Header carries the title of the Report information on the branch code branch date the date and time of report generation the user ID of the user generating the report module page and the event date Body of the Report The following details are displayed as body of the generated report Field Name Field Description Lead ID Indicates the lead ID created by the user ID User ID Indicates the user ID Branch Indicates the branch Status Indicates the status of the loan request ORACLE 5 Function ID Glossary C ORDRLDVR 2 128 CLRPADVC ea 11 12 ORDRLMOU 2 129 CMROLE Luce circ ea 2 99 ORDRLSIM uu sees 2 22 CSCOOCUP sceneries 2 90 ORDRLUND 2 105 ORSCATMT ee 2 50 o ORSDOOMT 2 45 ORDCATMT 2 46 ORSLEADM 2 19 ORDDOCMT ossiani 2 43 ORSOVDMT 2 42 ORDLEADM 2 2 ORSPROMT e 2 52 ORDOVDMT 2 40 ORSRATMT 2 39 ORDPROMT 2 51 ORSRLSIM 2 31 ORDRATMT 2 37 ORSRULMT nooo 2 36 ORDRLAPP oon 2 70 ORACLE
56. Low Application Category Lead d Application Number Product Code Enquiry ID User Reference Description Offline Application Application Priority Low Application Branch Number Application Status Application Entry Application Date Daran Conversation ID Promotion Code Applicant Details Type Primary Local Branch Customer No Customer Name Main Details Financial Requested Limit KJEE Comments Collateral Details 101 Start Date Revaluate Collateral End Date Collateral Branch Revaluation Date Ceca Collateral Category Revision Date collateral Id Collateral Type Normal pe M Collateral Description yp oma Charge Type Mortage Linked Percent 96 Utilization Order Collateral Currency Linked Amount Commitment Product Collateral Value Hara Market Value Based Haircut Schedule Vehicle Details Security Id OR 1011 Number Of Units E Effective Date Haircut Nominal Value Vehicle ID Cap Amount n Vehicle Number Year Guarantor Based Guarantor Id Model Rating Body Usage Valuation Source None Valuation Status Not Required Covenant Details 10f1 Covenant Name Description Reversal Date Mandatory Grace Days Notice Days Due Date On Frequency a Monthly Documents Tradeln CustomerDedupe LoanDedupe CustomerMIS MIS Customer AccountFields LBL SELLER DTLS Prev Remarks Remarks Audit Collateral Details Collateral Branch Specify the collateral Branch The adjoining opt
57. Manual Glossary of Icons This User Manual may refer to all or some of the following icons Icons Function Ed Exit Add row Delete row EE Option List Ve ORACLE 2 1 2 2 2 Retail Loan Origination Introduction The process of loan origination gets initiated when a prospective customer approaches the bank with a loan account opening request or when the bank approaches a prospective customer taking lead from its database In case of a bank initiated request the process moves forward only if the prospective customer is interested The entire process is carried out in multiple stages and on successful completion of each stage it moves automatically to the next stage When the customer approaches the bank for its products and offers before initiating the loan origination process the bank can create a mock proposal which would have the personal details of the customer the loan offers the customer is interested in as well as the schedules associated with the loan offer This can be stored as reference in the system to be retrieved when the actual loan process flow is initiated Retail lending process flow uses Oracle BPEL framework with multiple human tasks for workflow stages The capture and enrichment of information in multiple steps can be dynamically assigned to different user roles so that multiple users can take part in the transaction Oracle Business rules are used for dynamic
58. ORACLE Retail Loan Origination User Guide Oracle FLEXCUBE Universal Banking Release 12 0 2 0 0 Part No E49740 01 September 2013 Retail Loan Origination User Guide September 2013 Oracle Financial Services Software Limited Oracle Park Off Western Express Highway Goregaon East Mumbai Maharashtra 400 063 India Worldwide Inquiries Phone 91 22 6718 3000 Fax 91 22 6718 3001 www oracle com financialservices Copyright 2007 2013 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 i
59. S screen gets displayed where you can capture the details Loan mis Application Number RetailLending4856 Product CLO2 F Link To Group Loan Account Number Loan Branch 000 MIS Group Financing Currency GBP Input Related Reference Related Account Related Account Related Reference MIS Head Rate At Interest Method Cost Code 1 Pool Code Reference Rate Cost Code 2 Contract Level Pool Code Cost Code 3 Cost Code 4 Cost Code 5 Transaction MIS Composite MIS Fund MIS MIS Group MIS Group MIS Group Transaction MIS 1 Composite MIS 1 Fund MIS 1 Transaction MIS 2 Composite MIS 2 Fund MIS 2 Transaction MIS 3 Composite MIS 3 Fund MIS 3 Transaction MIS 4 Composite MIS 4 Fund MIS 4 Transaction MIS 5 Composite MIS 5 Fund MIS 5 Transaction MIS 6 Composite MIS 6 Fund MIS 6 Transaction MIS 7 i Composite MIS 7 E Fund MIS 7 Transaction MIS 8 L Composite MIS 8 Fund MIS 8 Transaction MIS 9 r Composite MIS 9 a Fund MIS 9 2 23 23 2 Capturing Loan UDF Details You can capture the Loan UDF details by clicking Loan Fields button in Retail Loan Underwriting screen You can also invoke this screen by typing ORCLNUDF in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button 2516 ORACLE The Loan UDF screen gets displayed where you can capture the details Loan Fields Application Number RetailLendingt8S6 Loan Account Product Code CLO2 Loan Account
60. Type Collateral Details Collateral Branch Collateral Id Primary Workflow Reference Priority Low X Application Category Lead Id Application Number Product Code Enquiry ID User Reference NN Description Offline Application Application Priority Low Application Branch Number Application Status Application Enty m E Local Branch Main Details Financial Requested Limit EIGE Credit Score Bureau Ratio Loan Component Charge Investigation Comments Start Date End Date Collateral Category Conversation ID Customer No Customer Name C Revaluate Collateral Revaluation Date Revision Date Collateral Type N I Collateral Description we es Charge Type Mortage j Linked Percent Utilization Order Collateral Currency Linked Amount Commitment Product Collateral Value rans Market Value Based Haircut Schedule Vehicle Details Security Id ROM 101 Number Of Units Effective Date Haircut x Nominal Value Vehicle ID Cap Amount Vehicle Number Year Guarantor Based Make Guarantor Id Model Rating Body Usage Valuation Source None Valuation Status NotRequired Covenant Details 1 Of 1 E Covenant Name Description Reversal Date Mandatory Grace Days Notice Days Due Date On Frequency El Monthly m r Documents Tradeln KYC Review CustomerDedupe LoanDedupe CustomerMIS Vehicle Evaluator Bur
61. adjoining drop down list This list displays the following values e Client e Server Printer Specify the name of the printer or select it from the option list provided The adjoining option list displays all the configured printers This is applicable only if you have specified the output as Print Contents of the Report The contents of the report are discussed under the following heads Header The header carries the report title run date and time branch code branch name branch date user id module code and page number ORACLE 4 6 Body of the Report The following details are displayed in the report Field Name Description Customer Number Customer Number for which the report is generated Year The financial year Ratio Group Ratio group of the ratios Ratio Ratio name Quarter1 Value of the ratio in quarter1 Quarter2 Value of the ratio in quarter2 Quarter3 Value of the ratio in quarter3 Quarter4 Value of the ratio in quarter4 Reject Analysis Report You can generate the reject analysis report to analyse applications which are rejected or terminated and to get information of the rejected stage and reason within the specified period You can generate this report using the Reject Analysis Report screen You can invoke this screen by typing ORRRJAPP in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button
62. age 15 v 1 0f 1 Authorization Status Record Status Process Code Application Category You can specify any of the following details to search for a record e Authorization Status e Record Status e Process Code e Application Category Click Search button to search for a record based on the search criteria specified You can double click a desired record to view the detailed screen 2 15 Maintaining Application Category Details You can maintain various application categories linked to multiple loan products that cater to the requirements of different customers in Application Category Maintenance screen The entire process of loan origination depends mainly on the category to which the application belongs ae ORACLE 2 15 1 You can invoke Application Category Maintenance screen by typing ORDCATMT in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button Application Category Maintenance Detail H save Hola Application Category Application Type Category Description Rule Id Ratio Id Pricing Group Main Agency Product Details 10f41 l ssl Product Code Product Description Default External Credit Check Required External Credit Check Requiredfor AmountBasis AmountFrom Amou tet Account Class Details 10tf 1 AccountClass Account Description Offer Details 1 0f 1 E Offerid No of Ins
63. an also select it from the adjoining option list Description The system displays the description of the selected product code Status The system displays the status of the loan simulation User Reference On clicking Default button the system generates and displays a unique user reference number You can use this number to track the simulation later Lead ID Specify the lead ID Click on Default button to populate the details associated with application category and lead ID Note If the simulation screen is invoked from the lead screen ORDLEADM the lead id will be propagated from the lead screen You will have to click on the default button to capture the requested details associated with the lead Id In the standalone simulation screen you have to input the lead Id and then click on the default button if you want to capture the details related to a particular lead Id Customer Details Specify the following customer details ios ORACLE Customer No Specify the customer number for the simulation customer who has initiated a loan account for the same product and application category combination First Name Specify the first name of the customer Last Name Specify the last name of the customer Contact Number Specify the number at which the customer can be contacted E mail ID Specify the e mail ID of the prospective customer Requested Loan Details You can enter the following details req
64. ane ORACLE 2 14 e Mandatory e Overridden e Others BI Advices Report Name Specify the name of the advice report to be generated on completion of the process stage Template Specify the template to be used to generate the advice report Format Select the format in which the advice report needs to be generated from the drop down list provided The following options are available e PDF e RTF Locale Select the locale information to be used for generating the advices from the drop down list The following options are available e en US Out come Specify the outcome for which the report needs to be generated Checklist Details Sequence Number The system displays the sequence number Checklist Item Specify the checklist to be maintained Mandatory Check this box to indicate whether the checklist is mandatory or optional Here you can also maintain the documents for the Lead with the stage as Default Viewing Document Checklist Summary You can view a summary of the document checklists and advices in Document Details screen You can also query for a particular record based on desired search criteria di ORACLE You can invoke this screen by typing ORSDOCMT in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button Documents Details m o Authorization Status X Record Status X Process Code 28 Application Category 28 Reset Records perp
65. atement 10f1 v Reported Date Text 7 2013 03 19 COMPLETED 1234 lt m JF Credit Score Details Credit Bureau Report Application Number RetailLending3852 Customer No 000006150 Requested Id 644 Bureau Code EQFX Report Header Bureau EQFX Credit Report Id First Name ReportDate 2013 08 21 MiddleName Uniqueld 644 LastName OnFile Date 2013 08 21 Birth Date 1981 05 18 7j Best Match Summary 1 Summary 2 Trade Lines Public Records Collections Fraud Messages Inquiries Also Known As Consumer Statement Credit Scores Score Model Score 2 23 23 Viewing Credit Bureau Report You can view the credit bureau report by the external agency by clicking Bureau Report button in Retail Loan Underwriting screen The Credit Bureau Report screen gets displayed 255 ORACLE where you can view the details Credit Bureau Report Application Number RetailLending3852 Customer No 000006150 Requested Id 644 Bureau Code EQFX Report Header Bureau EQFX Credit Report Id 644 First Name ReportDate 2013 08 21 MiddleName Uniqueld 644 Last Name On File Date 2013 08 21 Birth Date 1981 05 18 7 Best Match Life Recent Open Chapter 0 Chapter 0 Chapter Chapter11 0 Chapter11 0 Chapter11 Chapter13 0 Chapter13 0 Chapter13 2 23 23 1 Capturing Loan MIS Details You can capture the Loan MIS details by clicking Loan MIS button in Retail Loan Underwriting screen The Loan MI
66. ating that the task is successfully completed gets displayed To acquire the next stage you need to go to the Task menu and select Assigned under Standard option All tasks that have been successfully completed are listed in the right side of the screen Select the checkbox against your Workflow Ref No and click Acquire button at the top of the screen to acquire the next stage of the task The system displays the system message as Acquire Successful on successful acquisition of the task 2 128 ORACLE Click Ok to proceed to the next stage To select the acquired task for the next stage select Acquired under Standard option in the Task menu All the tasks that have been successfully acquired are displayed in the right side of the screen Search for your workflow reference number and click the Workflow Ref No to open Retail Loan Approval screen Step 1 Loan Approval In the Loan Approval stage the approver verifies the loan application analyzes the applicant s financial status credit rating and field investigation reports and based on the credit worthiness of the customer approves the loan offered to the customer You can invoke this screen by typing ORDRLAPR in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button Retail Loan Approval x E Save 4A Hold Application Category Lead d Product Code Enquiry ID Description
67. ation Entry stage the based on the applicant credit score auto decision mapping maintained in Auto Decision screen the system decides whether to approve the loan or not The system makes one of the following decisions in that case e Approved e Recommend Approval e Recommend Reject e Rejected If the auto decision made by the system is Recommend Approval or Recommend Reject you need to manually verify and confirm the decision at this stage If any price group is associated with the application category then the system will apply auto pricing after proceeding the Application Entry stage by considering the default Price ID linked to the pricing group Further based on the selected loan offer the loan is applied and schedules are defaulted However at underwriting stage the underwriter may proceed or re apply the loan by selecting a different loan offer Any advices maintained for this stage are generated after the completion of the stage Document Verification In the Document Verification stage the documents captured in the previous stages are verified It is ensured that all documents in the checklist maintained are obtained from the customer In this stage the application and applicant information captured as part of the previous stages undergoes a final verification You can invoke this screen by typing ORDRLDVR in the field at the top right corner of the Application tool bar and clicking the adjoi
68. atus from the adjoining option list Contents of the Report The parameters specified while generating the report are printed at the beginning of the report Other content displayed in the Report is as follows is ORACLE Header The Header carries the title of the Report information on the branch code branch date the date and time of report generation the user ID of the user generating the report module page and the event date Body of the Report The following details are displayed as body of the generated report Field Name Field Description Lead ID Indicates the lead ID created by the user ID User ID Indicates the user ID Branch Indicates the branch Status Indicates the status of the loan request Application Number Indicates the application number 4 10 Rejected and Closed Leads Report You can invoke the Rejected and Closed Leads screen by typing the RLRPRCLR in the field at the top right corner of the Application tool bar and click on the adjoining arrow button Rejected and closed leads User ID Branch Status Report Format PDF Printer At Client Report Output Print T Printer zz User Select the User from the adjoining option list Branch Select the branch from the adjoining option list Status Select the status from the adjoining option list 4 10 1 Contents of the Report The parameters specified while generating the report are prin
69. atus is selected as Offer Generated Closed it will be mandatory for the user to select the rea son code in the sub screen which will be populated at the save operation Review When the prospect customer Follow Up uploads corrected or additional Closed documents Rejected Offer Generated Offer Generated When the FCUBS user simu Closed lates and system generates Converted 2 4 ORACLE 2 2 1 Lead Status Description Possible Next Staus Closed When the FCUBS rejects or Status cannot be changed closed the lead id When the status is selected as Closed it will be mandatory for the user to select the rea son code in the sub screen which will be populated at the save operation Converted When the customer accepts Closed one of the generated offers Application Under When a converted loan lead is You will not be able to change process saved in the application entry the status manually after this stage of the origination the status system will automatically change the status of the lead in ORD LEADM to application under process Main Tab You can capture the following personal and geographical details related to a prospective customer Sequence Number The system displays the sequence number Type Select the type of the customer from the drop down list provided The following options are available e Primary e Co Applicant Existing Check this box if the lead appl
70. bar and click the adjoining arrow button Reference Details X Application Number Account Number sz ReportFormat PDF wv PrinterAt Client v Report Output Print Printer ka Specify the following details Application Number Specify the loan application number for which you need to generate the report Account Number Specify the account number for which you need to generate the report Once you have specified the details click OK button The system generates the report Contents of the Report The contents of the report are discussed under the following heads Header The header carries the report title run date and time branch code and branch name D ORACLE 4 4 Body of the Report The following details are displayed in the report Field Name Description Reference Num ber Reference number of the person whose reference is provided by the applicant First Name First name of the person who referred the applicant Middle Name Middle name of the person who referred the applicant Last Name Last name of the person who referred the applicant Salutation Salutation of the person who referred the applicant Gender Gender of the person who referred the applicant No of Years Number of years the reference has known the applicant Known Relation Relation of the reference with the applicant Line 1 First line of the address of the reference Line 2 Second l
71. ber of compound years Years Select the actual number of days for the year from the adjoining drop down list You can select one of the following options e 360 e 365 e Actual Days in Month Select the number of days that would constitute a month for calculation from the adjoining drop down list You can select one of the following options e 30 euro e 30 US e Actual Verify Funds Check this box to indicate that verify of funds to be checked for the component Click on the Explode Schedule button to explode the component schedules Click on Disburse Details button to display disbursal schedule info for the selected component The following details related to the schedule are displayed here e Schedule Type e Schedule Flag e Formula e First due Date e Number of Schedules zu ORACLE e Frequency e Units e Schedule Start Date e End Date e Amount For each component of the components listed the system calculates and displays the details like the Due Date Amount Due EMI Amount and Amortized Principal Using Explode schedules the schedule details can be recalculated 2 23 26 1 Maintaining Disbursal Details You can capture the Loan Disbursal schedules details in Disbursal screen You can invoke this screen by clicking Disbursement Details button Disbursats Application Number RetailLending3248 CD Component Name PRINCIPAL Disbursals 10f1 V Schedule Date Total Disbu
72. bureau and so on If you have not maintained any Zip code credit bureau call order the system will request the credit report based on the call order defined in Application Category Maintenance screen EDR ORACLE 2 22 1 2 23 Viewing Zip Code Summary You can view a summary of Zip code details maintained in the system using Zip Code Details screen To invoke the screen type ORSZIPMT in the field at the top right corner of the application toolbar and click the adjoining arrow button Zip code Details Xx E search C Advanced Search Reset K Clear All Case Sensitive Authorization Status E Record Status Branch az Records per page 15 z 10f1 Authorization Status Record Status Branch You can search for the records based on one or more of the following parameters e Authorization status e Record status e Branch Once you have specified the search parameters click search button The system displays the following details of each result e Authorization status e Record status e Branch Stages in Retail Loan Origination The different stages in Retail lending process flow are designed using Oracle BPEL framework The process of loan origination consists of several manual as well as system tasks carried out in a sequential manner Many users can be involved in the completion of a transaction and at each stage of the process a user or a group of users assigned with a task acquire and
73. changes the score of the pricing rule The score determines the price ID to be automatically applied Maintaining Pricing Offer Click Pricing button to define the pricing rule for each price ID for the user to pick up the offer for the loan E Offer Details 10 Vi Sequence Number Score From Score Up To Rate No of Installments Frequency Units y 1 Monthly You can specify the following details here Sequence Number System generates the sequence number Score From Specify the start credit score to pick the offer for the loan Score Up To Specify the end credit score to pick the offer for the loan Rate Specify the rate to be picked up for the score No of Instalments Specify the number of instalments for the offer Frequency Specify the frequency of the offer em ORACLE 2 19 2 19 1 Units Select the frequency unit from the adjoining drop down list You can select one of the following e Daily e Weekly e Monthly e Quarterly e Half Yearly e Yearly e Bullet Maintaining Field Investigation Details You can maintain field investigation details including the agency details and the corresponding verification types using Field Investigation Maintenance screen To invoke this screen type ORDFIAMT at the top right corner of the application toolbar and click the adjoining arrow button Field investigation Maintenance
74. cks 2n ORACLE To invoke the Credit Bureau Maintenance screen type ORDCBRMT in the field at the top right corner of the application toolbar and click the adjoining arrow button Bureau Maintenance Details Bureau Details Bureau Code Bureau Name Bureau Details ECT Branch Validity Period for Bureau Report ball e Maker Date Time Checker Date Time Mod No Record Status Authorization Status Specify the following details Bureau Code Specify a unique code that identifies the credit bureau that you are maintaining Bureau Specify the name of the bureau Branch Code Specify the branch code for which the bureau details are maintained Use add row button to add more rows to the list of branches Validity Period for Bureau Report Select the number of days during which the credit report from this bureau is considered as valid The drop down list displays the following values e 30days e 60days e 90 days e 120 days e Blank Space If the credit check is initiated for the same bureau either automatically or manually by underwriter a new bureau report will be fetched and displayed irrespective of any bureau report existing for same applicant from the same bureau Select the appropriate one The system will store the credit bureau report of the applicant for the validity period from the date of report request You can add more rows to the list of branches
75. creation of multiple approval stages The following details need to be maintained for originating a Retail Loan e Loan prospect retails e Credit rating rules e Credit ratios e Override details e Document checklist and advices e Application category details The Retail Loan origination process flow is composed of following stages e Application Entry e Application Verification e Internal KYC e External KYC e Underwriting e Loan Approval e Document Verification e Manual Retry These features maintenances and the different stages in the process flow are explained in detail in the following sections Maintaining Loan Prospect Details You can maintain the details of a prospective borrower or a loan applicant when the borrower initially approaches the bank enquiring about the various loan products that are being offered The system facilitates capturing of lead details through external channels as well The following details are captured as part of this maintenance 24 ORACLE e Prospective customer s personal and location details e Prospective customer s employment details e Requested loan details e Lead life cycle management You can maintain the details related to the prospective customer in Prospect Details screen You can invoke this screen by typing ORDLEADM in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button
76. cription Specify a brief description of the price ID Default Check this box to set this as the default price ID for the price group that you maintain d ORACLE 2 18 Viewing Pricing Details You can view the pricing details maintained in the Pricing Details screen To invoke the screen type ORSPRCMT in the field at the top right corner of the application toolbar and click the adjoining arrow button Pricing Details Authorization Status Record Status Price Group ID az Description Price Type Advanced Search Records perpage 15 v 1 Of 1 Authorization Status Record Status Price Group ID Description Price Type gt In this screen you can base your queries by providing any or all of the following criteria e Application Status e Price Group ID e Price Type e Record Status e Description Based on the details provided system displays the following details e Authorization Status e Record Status e Price Group ID e Description e Price Type ane ORACLE 2 18 1 Maintaining Pricing Formula Click Formula button to define the pricing rule for each price ID You can define the formula using origination system elements in Oracle FLEXCUBE Formula Maintenance 10f1 Sequence Number mi Elements Index Functions Braces Operators Logical Operators Sequence Number Specify the sequence number Condition Specify the possible data or the data limits here The supported
77. cted Rejected Reason Rejected reason specified by the user for rejecting the application 4 7 Lead Report You can invoke the Lead Report screen by typing the code RLRPLEDR in the field at the top right corner of the Application tool bar and click on the adjoining arrow button Lead Report User Branch Code From Date To Date Report Format PrinterAt Client v Report Output Printer User Select the User from the adjoining option list Branch Select the branch from the adjoining option list 4 7 1 Contents of the Report The parameters specified while generating the report are printed at the beginning of the report Other content displayed in the Report is as follows aen ORACLE 4 7 2 Header The Header carries the title of the Report information on the branch code branch date the date and time of report generation the user ID of the user generating the report module page and the event date Body of the Report The following details are displayed as body of the generated report Pending Action Leads Field Name Field Description Lead ID Indicates the lead ID created by the user ID User ID Indicates the user ID Branch Indicates the branch Days of Inactivity Indicates the days lapsed from New to Follow Up Report You can invoke the Pending Action Leads screen by typing the RLRPPALR in the field at the top right corner of the Application too
78. cuments Maker Date Time Mod No Checker Date Time Record Status rization Status The system displays the following details if the conversation ID is selected in the prospect Detail screen Customer Details Customer ID The system displays the customer ID Customer Name The system displays the name of the customer Conversation Details Conversation ID The system displays the conversation ID Conversation Date The system displays the conversation date Conversation Time The system displays the conversation time aN ORACLE Last Changed On The system displays the date and time when the conversation was last changed Priority The system displays the conversation priority Conversation Status The system displays the conversation status Conversation Category The conversation category is defaulted here Venue The system defaults the venue Conversation Mode The system displays the conversation mode Department Details The system displays the following department details e Department e User Role e Other Department e Assigned To e Senior Management Involved e Other Offices Involved Channel Details The system displays the following channel details e Direct Access Channel e External System User ID e Channel User ID Message Details The system displays the following message details e Original Request e Subject e Detail e Documents Presented e Reply to Customer e Closure Re
79. d ORACLE 2 20 You can search for the records based on the of parameters available on the screen The system will display the records based on the search criteria specified You can double click a record to open the detailed screen Updating Field Investigation Details You can update the field investigation results and other details for a selected application type using Field Investigation Update screen To invoke the screen type ORDFIUPD in the field at the top right corner of the application toolbar and click the adjoining arrow button Field Investigation Update X H save Application Number P P Application Branch Main Detail Investigation 10f1 Il f V Verification Type Agency Status Call Date Number Of Attempts Spoke To Result gi Al FE z3 es Date Time Mod No Record Status Date Time Authorization Status You can specify the following details Application Number Specify the retail loan application number for which the field investigation details need to be updated The option list displays all valid retail loan application numbers that are in any stage from application entry to underwriting Choose the appropriate one Application Branch Based on the application number the system displays the application branch code You can update the investigation details of the agencies only if they are maintained under this branch Applicant Details Ba
80. dit engine obtains information from customer and calculates credit score and displays system recommendation 2 108 ORACLE Retail Loan Origination l New 3 Enter Query Workflow Reference Priority Low Application Category Leadid Application Number Product Code Enquiry ID User Reference Description Offline Application Application Priority Low Application Branch Number zu Application Status Application Entry ET Application Date Conversation ID Promotion Code Applicant Details Type Primary M Local Branch Customer No Customer Name Main Details Financial Requested Limit Collateral e Bureau Ratio Loan Component Charge Investigation Comments Internal Credit Rating Rule Id 10f 1 Grade o Category Question Answer a Score o Risk Factor Details 10f1 m Risk Factor Description Score a Documents Tradeln KYCReview CustomerDedupe LoanDedupe CustomerMIS MIS Customer AccountFields LBL SELLER DTLS Vehicle Evaluator BureauReport LoanMIS LoanFields Prev Remarks Remarks Andit The set of questions used to assess the credit rating of a prospective loan customer associated Rule Id are displayed in this screen You can specify the following details here Answer Specify the answer to be associated with the question used for calculating the credit score Risk Factor Specify the risk factor associated with the loan if any Description Specify a suitable description
81. e Auto Approved e Recommend Approval e Recommend Reject e Auto Rejected While creating a loan based on the applicant s credit score and auto decision mapping maintained in here the system decides whether to approve reject recommend approval or recommend rejection of the application Viewing Credit Rule Summary You can view a summary of the credit rules in Rule Maintenance screen You can also query for a particular record based on desired search criteria You can invoke this screen by typing ORSRULMT in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button Rule Maintenance Authorization Status Record Status Rule Id 28 Advanced Search Records per page 15 v 1 Of 1 Authorization Status Record Status Rule Id Account Description You can specify any of the following details to search for a record e Authorization Status e Record Status e Rule Id ids ORACLE 2 9 Click Search button to search for a record based on the search criteria specified You can double click a desired record to view the detailed screen Maintaining Credit Ratios You can maintain the rules to calculate the credit ratios in Credit Ratio Maintenance screen You can invoke this screen by typing ORDRATMT in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button LMC Eligibility Ratio E New amp Enter Query Group Id
82. e Report sssssssssssssssssssssi enean 4 10 ASE Lead Reports aet reos ertt et ee t dees de eae ERA RENE 4 11 4 7 1 Contents of the Report sssssssssssssessss sesenta 4 11 4 7 2 Contents of the Report ssssssssssssssssssss sss 4 12 4 8 Offer Generated for Leads Report sssssssssssssseeeeeees 4 13 48 1 Contents ofthe Report sien ee e bL beo EN IRE Rs 4 13 4 9 Converted Leads Report ssssssssssssssssseeeee eren eren 4 14 4 9 1 Contents of the Report sssssssssssssssses sentina 4 14 4 10 Rejected and Closed Leads Report ssessssssssssee emm 4 15 4 10 1 Contents of the Report sssssssssssssssesss eene nnne 4 15 4 11 Non Originated Leads Report sess eme 4 16 4 11 1 Contents of the Report sssssssssssssssssssss eene 4 17 Function ID Glossary teet eU n ME EE 5 1 1 1 1 2 1 3 1 4 1 5 1 Preface Introduction This manual is designed to explain the Retail Loan Origination module of Oracle FLEXCUBE It provides an overview of the workflow and information on maintaining the prospect details and other supported features Audience This manual is intended for the following User User Roles Role Function Corporate Customer Service Collection of applications Executive Trade Finance Executive Updation of details of contracts Trade Finance Manager Verification and authorization o
83. e adjoining arrow button 2 129 ORACLE Retail Loan Manual Retry Task X E save si Hola Application Category Leadid Application Number o Product Code Enquiry ID User Reference Description E Application Priority Low Application Branch 000 EN Application Status Application Enty Application Date 2011 01 04 It i 4 Conversation ID a7 Promotion Code EEG cetails Financial Reauested Limit Collateral Credit Score Bureau Ratio Loan Component Charge Investigation Comments Chail KYC Required Intermediary Group 7 Auto Decision Required Applicant Details M 4 1011 gt HH Go Type Existing Local Branch CustomerNo Default ShortName CustomerName Nationalld Responsibility Liability RMID RMName E Ji J F City FirstName Power of Attorney Country Middle Name Power of Attorney Nationality LastName Holder Name Language Salutation Mr IS Customer Category Gender Male Financial Currency Birth Place Country oe Birth Country Nationality MID Date of Birth Telephone ISD Code i ers Mothers Maiden Name Telephone Number lome ione Ad Ir Marital Status Married i tione Plone BIS US Resident Status Work Phone ISD Permanent US Resident Work Phone HM Status Email Account Details Visited US in last 3 years FaxISD Code Account Branch u
84. e credit rating rule Type Select the type of the loan from the following options available e Retail e Corporate 2 7 1 Main Tab You can maintain the following details in this tab ius ORACLE 2 7 2 Question Details Question Id The question Id is automatically generated by the system Category Select the category to which the question belongs from the option list provided Question Specify the question to be asked to the prospective customer to derive the credit rating score Answer Details Sequence Number The sequence number is automatically generated by the system Possible Answer Specify a set of possible answers to be associated with a question Score Specify the score associated with an answer Risk Factor Tab You can specify the risk details associated with the loan and also indicate the formula for calculating the credit score in this tab E Rule Maintenance FX New amp Enter Query Rule Id F New Route Account Description Type Retail M Risk Factor 1 Of 1 Risk Id Account Description Formula Formula Rating Auto Decision Maker Date Time Checker Date Time Mod No Record Status Authorization Status You can specify the following details here Risk Id Specify a unique identifier for the credit risk being maintained Description Specify a suitable description for the credit risk ids ORACLE 2 7 2 1 Specifyi
85. e if the information provided is not adequate or choose to cancel it if the information captured is not satisfactory If the application details are verified successfully the approver can proceed with the processing of the application by selecting PROCEED as the Outcome The approver can select RETURN to return the process to previous stage for data correction or CANCEL to terminate the process On successful completion a message stating that the task is successfully completed gets displayed To acquire the next stage you need to go to the Task menu and select Assigned under Standard option All tasks that have been successfully completed are listed in the right side of the screen Select the checkbox against your Workflow Ref No and click Acquire button at the top of the screen to acquire the next stage of the task The system displays the system message as Acquire Successful on successful acquisition of the task aie ORACLE Step 1 Click Ok to proceed to the next stage To select the acquired task for the next stage select Acquired under Standard option in the Task menu All the tasks that have been successfully acquired are displayed in the right side of the screen Search for your workflow reference number and click the Workflow Ref No to open Retail Loan Document Verification Screen If you have checked the option Auto Decision Required during Applic
86. e set as specified above After entering the required details select VERIFY as the Outcome and click Save If you have indicated that evaluation should be done you will not be allowed to select PROCEED or CANCEL as the Outcome till the verification has been successfully done The system will display a message stating that the task is successfully completed on saving the record To acquire the next stage you need to go to the Task menu and select Assigned under Standard option All tasks that have been successfully completed are listed in the right side of the screen Select the checkbox against your Workflow Ref No and click Acquire button at the top of the screen to acquire the next stage of the task The system displays the system message as Acquire Successful on successful acquisition of the task Click Ok to proceed to the next stage which will again be the underwriting stage To select the acquired task for the next stage select Acquired under Standard option in the Task menu All the tasks that have been successfully acquired are displayed in the right side of the screen Search for your workflow reference number and click the Workflow Ref No to open Retail Loan Underwriting Stage screen The system will invoke the external valuation agency for vehicle evaluation You can view the details in the collateral tab In the collateral tab click the Evaluate button The system
87. eauReport LoanMIS LoanFields Prev Remarks Remarks In this screen capture the following details Vehicle Details MIS Customer AccountFields LBL SELLER DTLS Andit You can modify the details of the vehicle which is to be evaluated in the fields listed below Identification Number Enter the unique identification number associated with the vehicle Year Specify the year of manufacture for the vehicle Make Specify the make of the vehicle Model Specify the vehicle model Body Specify the vehicle body details Usage Specify the mileage used by the vehicle till date 2 106 ORACLE You can retrieve vehicle details from an external agency either by specifying the identification number for the vehicle or all of the following fields e Year e Make e Model e Body e Usage Valuation Source Select the valuation source from the adjoining drop down list The options are e INTERNAL e NONE Select INTERNAL if you wish the evaluation to be done by interfacing with an external agency Status Select the status from the adjoining drop down list The options are e RECOMMENDED e NOT RECOMMENDED e COMPLETE e NODATA The evaluation will be done only if the valuation source is selected as INTERNAL and the status is RECOMMENDED For any other combination of values for the two fields the system will display an error message and will not proceed with the evaluation till the values ar
88. ecify the following details for the asset type Vehicle Make Specify the make of the vehicle Model Specify the model of the vehicle Manufacturing Year Specify the year of manufacture of the vehicle Body Specify the body details of the vehicle Reg Specify the registration number of the vehicle Home Address Line 1 3 Specify the address of customer s residence in the three Address lines provided das ORACLE 2 23 6 Width Specify the width of the customer s residence Length Specify the length of the customer s residence Occupancy Specify the number of people who occupy of the customer s residence Note You can enter only the details of the selected asset type otherwise the system displays an error message Requested Tab The details related to the requested loan corresponding to the Lead Id selected are displayed in this tab You can modify these details if required If you have selected an Enquiry ID for the customer then the requested details that have been stored for the corresponding loan proposal are displayed here Retail Loan Application Entry EA save iy Hoid Application Category iz Lead d az Application Number RetailLending3796 Product Code E Enquiry ID UserReference Description Education Loans Application Priority Low Application Branch 000 Application Date 2011 01 04 Promotion Code Application Status Application Entry Conversation ID
89. eed to the next stage Click on the Review button to view the following screen Application Number RetailLending1179 a Customer No 001004388 KYC Review Details Local Branch 001 First Name KYC Extenal Status NoM KYC Extenal Remarks Middle Name SON Status Last Name Date of Bith 1982 03 01 SUN Remarks ountry GB Revew Nationality GB 2 105 ORACLE Based on the KYC and SDN statuses and remarks the reviewer decides whether to move the task to the next stage Click Review button to view all customer information and perform KYC and SDN checks The KYC Review Screen STSKYCMN and SDN Review Screens ORSSDNMN are displayed KYC Maintenance Summary X Authorization Status Iz Record Status Iz KYC Reference E Full Name of Customer 28 i KYC Customer Type Iz Risk Level Iz Reset Records per page Ds 1 Of 1 Authorization Status Record Status KYC Reference Ful Name of Customer KYC Customer Type Risk Level m Exit Alias Names Summary X Name gt Date of Birth e Country L Records per page IMiI4 1 of 1 Name Date of Birth Country lt gt Once reviewed the verifier provides the review status and remarks You can perform a check on the customer record based on the KYC Review and SDN Review screens and choose the external KYC status and SDN status respectively based on the review 2 104 ORACLE Step 1 Underwriting 2 23 19 2 23 20 In thi
90. errides need to be generated dynamically in Override Maintenance screen dd ORACLE You can invoke this screen by typing ORDOVDMT in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button Override Maintenance FEX New amp Enter Query Process Code 7 New Route Application Category Type Retail Y Stage Stage Description Overrides 10f 1 E Sequence Number Condition Error Code Error Parameter Elements Index Functions Braces Operators Logical Operators ELCs Date Time Checker Date Time Mod No Record Status Authorization Status You can specify the following details in this screen Process Code Specify the process code of the process for which you wish to maintain override conditions or select the process code from the option list provided Application Category Specify the category to which the loan application belongs or select the application category from the option list provided Type Select the type of the loan from the following options available e Retail e Corporate Stage Select the stage of the loan origination process from the option list provided The various stages can be Application Entry Application Verification Underwriting Loan Approval etc Description Specify a suitable description for the loan origination stage Overrides Here you can capture
91. erwriting EA save sh Hold Application Category RCAT1 Leadid Application Number RetailLending3899 Product Code LRT4 Enquiry ID User Reference OO0LRT411004001 Description Demand loans with Co Application Priority Low Application Branch 000 App cation Status Tenana Application Date 2011 01 04 aM ER Promotion Code Conversation ID Main Details Financial Requested Limit Collateral Credit Score Bureau Ratio Loan Component Charge Investigation Comments 10f 1 C Waive Component Name Due Date Component Currency Amount Due Effective Date Amount Waived Documents Tradein KYC Review CustomerDedupe LoanDedupe CustomerMIS CustomerAccountMIS Customer AccountFields SellerDetails I Vehicle Evaluator Bureau Report LoanMIS Loan Fields Previous Remarks Remarks Audit The system calculates and displays the charge details associated with the loan The following details are displayed e Component Name e Event Code e Associated currency elas ORACLE 2 23 28 e Amount Component Name Specify the name of the component Component Currency Specify the component currency Effective Date Specify the effective date Waive Check this box to waive the charges associated with the loan Investigation Tab In this tab the system captures the field investigation details associated with the customer Retail Loan Origination FAX New yee Workflow Reference Prior
92. es Loan Charges Field Investigation Document Capture Advice Generation ORDR LUND RETURN PROCEED VERIFY CANCEL Loan Approval Loan Approval ORDRL APR PROCEED CANCEL Document Verification The details captured as part of Underwriting stage is verified The following details are captured as part of this stage Document Capture Stage Comments After this stage the following core activities are carried out in the fol lowing sequential order Applicant Creation Applicant Account Creation Applicants Limits Liability Facility Collateral Pool creation Loan Creation ORDRLDV R PROCEED RETURN CANCEL Manual Retry This stage is optional Task is moved to this stage only when the system is unable to create Cus tomer Customer Account Liabil ity Facility Collateral pool Loan You have to do the necessary changes and retry the same ORDR LMCU PROCEED The stages are explained in detail in the sections that follow 2 69 ORACLE Step 1 Application Entry In this stage the bank receives an application for a loan along with the relevant documents and financial statements from a prospective customer If the applicant does not have an account but intends to open one the bank also obtains the account opening form and related documents as part of this activity The details related to the applicant contact information employment inf
93. es the bank to automatically decide the credit bureaus from which the credit report of a specific applicant to be taken The decision is based on the zip code of the applicant s address To invoke Zip Code Maintenance screen type ORDZIPMT in the field at the top right corner of the application toolbar and click the adjoining arrow button ZipCode Maintenance Details B Save Branch zz Zip Code Maintenance 1 0f 1 35 v From ZIP x To Zip x b Bureau Call Order and Validity 1 Of 1 Bureau Code Bureau Name Bureau Call Order Validity Period for Bureau Report 15 a 7 b s Date Time Date Time Record Status Authorization Status Maker Checker Mod No Specify the following details Branch Code Specify the branch code for which the zip code and bureau call order are being maintained Zip Code Maintenance You need to specify the zip code details in this section You can add more rows to the list of zip codes using the add row button From Zip Code Specify the first Zip code of the Zip code range For the range of Zip codes from the first to the last the system will decide the order of calling credit bureaus for credit check 2s ORACLE To Zip Code Specify the last Zip code of the Zip code range For the range of Zip codes from the first to the last the system wi
94. f contracts Compliance Executive Performance of compliance details of all parties in a contract Compliance Manager Verification of compliance check carried out by Compliance Executive Documentation Accessibility For information about Oracle s commitment to accessibility visit the Oracle Accessibility Program website at http Awww oracle com pls topic lookup ctx acc amp id docacc Abbreviations The following abbreviations are used in this User Manual Abbreviation Description BPEL Business Process Execution Lan guage SDEs System Data Elements WF Workflow Organization This manual is organized into the following chapters About this Manual gives information on the intended audience It also lists Chapter 1 the various chapters covered in this User Manual 1 1 ORACLE 1 6 1 7 Retail Loan Origination explains the process of creating and maintaining Chapter 2 the prospective applicant details Maintenances explains the process of handling SDE Template Definition Chapter 3 i and Ratio Maintenance Reports provides a list of reports that can be generated in this module Chapter 4 and also explains their contents Chapter 5 Function ID Glossary has alphabetical listing of Function Screen ID s used in the module with page references for quick navigation Related Documents e Procedures User Manual e Core Entities User
95. for only primary applicant Incase external credit check is enabled for all applicant in the application category and if you enable it for primary applicant alone the system will display an error message External credit check required for all applicants f bureau report is available for the customer and the customer applies for another loan then the system displays the alert Bureau report already exists for the customer when you save the record at application entry stage based on the validity period settings for the chosen bureau If the existing bureau report is within the validity period only then this message will be displayed Ifan external bureau report in validity period is already available for the applicant then the system will not initiate the credit bureau pull The details of the report in validity period will be used External Credit Check Required for Select the applicants for whom external credit check is required The drop down list displays the following options e All Applicants Select this to enable credit bureau pull for all the applicants e Only Primary Applicant Select this to enable credit bureau pull only for the primary applicant Select the appropriate one Group Code Specify customer s group code along with the applicant s details Mobile ISD Code Specify the international dialling code for the mobile number of the customer The adjoining option list displays valid ISD codes mai
96. fore e Stated After e Actual Before e Actual After ai ORACLE Condition Specify the condition here You can also maintain the condition in the Condition Builder screen which is invoked by clicking the Condition Builder button Condition Builder Condition TOTAL ACCOUNTS RECEIVABLEst TOTAL CASH ASSETS OTHER CURRENT ASSETS amp sTOTAL ACCOUNT PAYABLEst TOTAL_ST_BORROWINGS 0THER CURRENT LIABILITIES amp Condition Elements Braces Functions Elements Operators Logical Operators Index Specify the following details Condition Specify the condition for the rule here Business Rule Braces Select the braces from the adjoining drop down list Functions Select the functions from the adjoining drop down list Elements Select the elements from the adjoining option list This list displays all valid elements maintained in the system Operators Select the mathematical operators from the adjoining drop down list This list displays the following values e Equal To e Greater Than e Greater Than or Equal To e Less Than e Less Than or Equal To e Like e NotLike e Not Equal To 3 8 ORACLE Logical Operators Select the logical operators from the adjoining drop down list This list displays the following values e And Use And e Or Use OR Value Specify the value of the SDE to define the condition The value may be numeric or alphanumeric as required for the co
97. from the adjoining option list It is mandatory to specify the reason if the current status is Closed Rejected or Additional Document Required After authorization the new status becomes the current status of the lead Conversation ID Specify the conversation ID if conversation is originated before the lead record submission The adjoining option list displays all valid conversation IDs Select the appropriate one a ORACLE The table shows the status available for lead management of loans the offer based on requested details Lead Status Description Possible Next Staus New All the leads generated from Follow Up the channel will have the sta fj i Closed tus as New FCUBS user can see the Rejected entire list of leads in the lead summary screen Rejected When the FCUBS user rejects Status cannot be changed the lead When the status is selected as rejected it will be mandatory for the user to select the rea son code in the sub screen which will be populated at the save operation Follow Up The FCUBS contacts the pros Additional Documents pect for further processing Required The FCUBS user can edit the Closed details provided by the pros pect customer based on their Rejected interaction Offer Generated Additional Docu After speaking to the prospect Follow Up ments Required customer FCUBS user i Closed informs correct or additional documents required Rejected When the st
98. ges Stage Stage Document Details 10f1 7 Document Category Document Type Mandatory 1 Mandatory BI Advices 10tf1 E Report Name Description Template Type Format Locale au Query PbF en us Checklist Details 10f 1 Sequence Number Checklist Item Mandatory Maker Date Time Mod No Checker Record Status Date Time Authorization Status You can specify the following details in this screen Process Code Specify the process code of the process for which you wish to maintain override conditions or select the process code from the option list provided Application Category Specify the category to which the loan application belongs or select the application category from the option list provided Stage Select the stage of the loan origination process from the option list provided The various stages can be Application Entry Application Verification Underwriting Loan Approval etc Stage Title Specify a suitable description for the loan origination stage Document Details Document Category Specify the category to which the document belongs or select the document category from the option list provided Document Type Specify the type of the document or select the document type from the option list provided Mandatory Select the option to indicate whether the document is mandatory or not You can select any of the following options from the drop down list provided
99. h the customer is a national or select the country code from the option list provided Language Specify the primary language of the customer or select the language from the option list provided Customer Category Specify the category to which the customer belongs or select the customer category from the option list that displays all valid customer categories Financial Currency Select the financial currency from the adjoining option list Mobile Number Specify the mobile phone number of the prospective customer Landline Number Specify the land phone number of the prospective customer E mail Specify the e mail Id of the prospective customer 29 ORACLE Fax Specify the fax number of the prospective customer Preferred Date of Contact Specify the preferred date of contact Preferred Time of Contact Specify the preferred time of contact First Name Specify the first name of the customer Middle Name Specify the middle name of the customer Last Name Specify the last name of the customer Salutation Select the salutation preference of the customer from the drop down list provided You can select any of the following options e Mr e Mrs e Miss e Dr Gender Select the gender of the customer from the drop down list Date of Birth Specify the date of birth of the customer or select the date by clicking the Calendar icon provided Mother s Maiden Name Specify the customer s mother s maiden name
100. he adjoining drop down list This list displays the following values e Print Select this option if you wish to print the report e View Select this option if you wish to view the contents of the report e Spool Select this option if you wish to spool the report for further use Printer At Select the location where you want the report to be generated from the options provided in the adjoining drop down list This list displays the following values e Client e Server Printer Specify the name of the printer or select it from the option list provided The adjoining option list displays all the configured printers This is applicable only if you have specified the output as Print Contents of the Report The contents of the report are discussed under the following heads Header The header carries the report title run date and time branch code branch name branch date user id module code and page number 10 ORACLE Body of the Report The following details are displayed in the report Field Name Description Application Number Application Number that was rejected Branch Branch of the rejected application Customer Number Customer number of the rejected application Customer Name Customer name for the customer number Rejected Stage The stage where the application was rejected Rejected By The user who rejected the application Rejected Date The date on which the application was reje
101. he mathematical operators from the adjoining drop down list This list displays the following values e Equal To e Greater Than e Greater Than or Equal To e Less Than e Less Than or Equal To e Like e NotLike e Not Equal To Logical Operators Select the logical operators from the adjoining drop down list This list displays the following values e And Use And e Or Use OR Value Specify the value of the SDE to define the condition The value may be numeric or alphanumeric as required for the condition After building the condition click the Insert button to insert the same To remove a condition click the Clear button in the screen Defining Template for Calculating Ratios You can define templates for calculating financial ratios taken from the balance sheet income statement statement of cash flows or statement of retained earnings within the product You can capture the template related details through the Ratio Template Definition screen ORACLE You can invoke this screen by typing ORDTEMDFEF in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button Ratio Template Definition X E New amp Enter Query Industry Sheet Name Sheet Description Generate Worksheet 10f1 E Worksheet Name Worksheet description Work sheet Required y SDE Details 1 0f1 E SDEName SDE Description Data Type Categor
102. he trade asset currency Note For more details on Capturing Asset Valuation details refer the section titled Account As set Valuation in Retail Lending user manual uds ORACLE 2 23 12 Verifying Customer Dedupe You can verify if the customer details are duplicated by clicking the Customer Dedupe button Customer Dedupilcation Check screen gets displayed where any duplicate customer details are displayed Customer Dedupe Application Number RetailLending5149 cl Customer No 001 Customer Dedupe Details 10f1 he E Customer No FirstName LastName Short Name Nationalld Customer Category Date of Bith Email Passport 2 23 13 Verifying Loan Dedupe You can verify if the loan details are duplicated by clicking the Loan Dedupe button Loan Dedupilcation Check screen gets displayed where any duplicate loan details are displayed Loan Dedupe Application Number RetailLending5149 Ie Customer No 001 Loan Dedupe Details 10f1 Li Loan Account Number Loan Currency Loan Amount Value Date Maturity Date Outstanding Amount Rate 2 23 14 Capturing Customer MIS You can capture the MIS details for the customer if any by clicking MIS button against a row in the Applicant Details table The Customer MIS screen gets displayed where you can maintain the MIS details one ORACLE E Customer MIS MIS Group Default From MIS Group Customer MIS Classes 1 Of 1
103. his screen click Schedule Details button in the Components tab of the Retail Loan Simulation Details screen Schedule Details Application Number RetailLending3248 0 Component Name PRINCIPAL Schedule Details 10fi E C Due Date Amount Settled Amount Due EMI amount Amortized Principal Accrued v 2012 07 03 0 8333 33 CJ 2012 08 03 0 8333 33 DJ 2012 09 03 0 8333 33 3 2012 10 03 0 8333 33 0 2012 11 05 0 8333 33 0 2012 12 05 0 8333 33 w lt zuo ORACLE 2 6 This screen displays the schedule details Viewing Simulated Loan Details You can view a summary of the loans that have been simulated for prospects in Retail Loan Simulation Summary screen You can also query for a particular record based on desired Search criteria You can invoke this screen by typing ORSRLSIM in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button Retail Loan Simulation Summary Authorization Status x Record Status Enquiry ID Application Category R Product Code Customer No First Name Last Name Status User Reference EX Records per page 15 M 4 1 ot 1 Authorization Status Record Status Enquiry ID Application Category Product Code Customer No First Name Last Nam Unauthorized Open FCGGHFG RETAIL1 CLP1 000000103 You can specify any of the following details to search for a record Authorization Stat
104. icant is an existing customer Local Branch Select the local branch of an existing customer from the adjoining option list Customer No Specify the customer if the Customer is existing The adjoining option list displays all valid customer numbers Select the appropriate one If the Customer is prospect then the system generates the new customer ID by default Default Click on default button to default the details on existing customer Short Name The system defaults the Short name when default button is pressed if the applicant is an existing customer However you can specify the short name if the applicant is prospect n ORACLE Customer Name The system defaults the Customer name when default button is pressed if the applicant is an existing customer However you can specify the customer name if the applicant is prospect National ID Specify the national Id or country code of the customer or select the national Id from the option list provided Responsibility Select the responsibility from the adjoining drop down list Liability Specify the liability for all parties other than primary applicant City Specify the city of the customer If the lead is received from the channel FCDB then the city value is passed by the FCDB to FCUBS and is defaulted here Country Specify the country of domicile of the customer or select the country code from the option list provided Nationality Specify the country of whic
105. idates and restricts the application category based on the promotion code In case of invalid promotion code input received from the channel or specified by you the system launches the option list screen for Promotion Id and you have to select a correct promotion code and proceed for simulation The promotion code field in the main lead screen will also get updated with the selected correct promotion code Whenever a promotion code is specified the offer associated with promotion code will take precedence is ORACLE 2 2 8 Acceptance of the Offer by the Customer If the customer accepts one of the offers from the external system then the Oracle FLEXCUBE changes the lead status to Converted and the offer reference number is locked for that particular lead ID and request ID If the offer is accepted within the Oracle FLEXCUBE then the lead status is automatically changed to Converted The system intimates the offer reference number request ID and the status change to the external system Notifying the External SystemOracle FLEXCUBE communicates each status or stage movements to the external system Oracle FLEXCUBE Status Notification to External System Additional Communication to External System New Status as New Request ID Lead ID Follow Up Status as Follow Up RequesT ID Lead ID Additional Documents Required Status as Additional Doc uments required Reason selected at
106. iew Click View to view the document uploaded In Retail Loan Origination process Document Upload feature is not available in all the stages Its availability in this process is given below zd ORACLE View Availa Stage Title Function id 209 Calltorm Upload Available T ieinot Exists Not Available Available Application Entry ORDRLAPP Available Available Available Application Verifi ORDRLVER Available Available Available cation Underwriting ORDRLUND Available Available Available Loan Approval ORDRLAPR Available Available Available Document Verifi ORDRLDVR Available Available Available cation Customer Loan Collateral Account Creation 2 23 11 Capturing Trade In Details You can capture the trade in details related to the loan application in Trade In sub screen To invoke this screen click Trade In button in Retail Loan Application Entry screen Retail Loan Application Entry Asset 4 10001 gt Make Model Manufacture Year Body Type Sub Type Description Asset Id Value Wholesale Validation Date Source Base Retail Supplement Payment Amt Edition Additions Currency Total Transaction Value You can capture the asset details and the valuation details of the asset in this screen Application Number Specify the application number Product Code Specify the loan product Currency Specify t
107. il Loan Underwriting E save Hold Application Category RCAT1 Lead Id Application Number RetailLending3899 Product Code LRT4 Enquiry ID User Reference 000LRT411004001 Description Demand loans with Co Application Priority Low Application Branch 000 ppi aion Sinks ae Application Date 2011 01 04 2 Conversation ID Promotion Code Main Details Financial Requested Limit Collateral Credit Score Bureau Ratio Loan Component Charge Investigation Comments Comments 10f1 4 ss 7 Serial No Comments CommentBy Comment Date Documents Tradeln KYC Review CustomerDedupe LoanDedupe CustomerMIS CustomerAccountMIS Customer AccountFields Seller Details l Vehicle Evaluator Bureau Report Loan MIS Loan Fields Previous Remarks Remarks Audit c VENT EZ You can capture the following details Comments Specify comments if any to be associated with the loan application Comment Type Specify the type of the comment given Comment Date Specify the date on which the comment was given or select the date by clicking the Calendar icon If the underwriting stage is successfully completed the underwriter can proceed with the processing of the application by selecting PROCEED as the Outcome The underwriter can select RETURN to return the process to previous stage for data correction or CANCEL to terminate the process On successful completion a message st
108. in Others tab of the Field Investigation Maintenance screen for the selected agency Remarks Specify the remarks with regard to the investigation if any Once you have updated the details save the record es ORACLE 2 20 2 2 21 Viewing Field Investigation Update Summary You can view a summary of field investigation updates using Field Investigation Update Summary screen To invoke the screen type ORSFIUPD in the field at the top right corner of the application toolbar and click the adjoining arrow button Orsfiupd_Desc T Advanced Search 5 Reset Authorization Status Record Status Application Branch zi Application Number Records per page 15 v Authorization Status Record Status Application Branch Application Number You can search the for the records based on one or more of the following parameters e Authorization status e Record status e Application branch e Application number Once you have specified the search parameters click search button The system displays the following details of the records maintained e Authorization status e Record status e Application branch e Application number Maintaining Credit Bureau Details You can maintain the details of external credit bureaus using Credit Bureau Maintenance screen You can use the credit bureau information while retrieving the credit information of retail loan applicants through external credit che
109. ine of the address of the reference Line 3 Third line of the address of the reference Line 4 Fourth line of the address of the reference Country Country of the person who referred the applicant Nationality Nationality of the person who referred the applicant Mobile Number Mobile Number of the person who referred the applicant Landline Number Landline number of the reference Business Analysis Report You can generate the business analysis report to analyse the business by giving data on the volume of transactions across products in a branch You can also get information of the transaction status within a specific period v ORACLE You can generate this report using the Business Analysis Report screen You can invoke this screen by typing ORRLNAMT in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button Business Analysis Report H save Status Completed ORejected OwWIP Branch Fy Product Code zz From Date Ea To Date E2 ReportFormat PDF z PrinterAt Clien Report Output Print x Printer a Specify the following details Status Indicate the transaction status You can select one of the following options e Completed e Rejected e WIP By default Completed option is selected Branch Specify the branch code from the adjoining option list This list displays all valid branch codes ma
110. intained in the system If no branch is selected then system displays the report for all branches Product Code Select the product code from the adjoining option list This list displays all valid product codes maintained in the system If you select a branch but not a product code then system displays the report for all product codes of the selected branch If you select only the product code and not the branch then system displays the report for all branches for the selected product code From Date Specify the date from which the report should be generated By default system displays the current Application date To Date Specify the date till which the report be generated By default system displays the current Application date Report Format Select the format in which you want to report to be generated from the options provided in the drop down list This list displays the following values e PDF a ORACLE 4 4 1 4 5 e HTML e Excel e RTF Report Output Select the output for the report from the adjoining drop down list This list displays the following values e Print Select this option if you wish to print the report e View Select this option if you wish to view the contents of the report e Spool Select this option if you wish to spool the report for further use Printer At Select the location where you want the report to be generated from the options provided in the adjoining drop down list This list d
111. ion Give a brief description on the process code Status Definition Status Select the status from the adjoining option list 220 ORACLE 2 4 1 2 4 1 1 2 4 1 2 Enable Check this box to enable the status defined here in the Prospect Detail screen Reason Codes Reason Code Select the reason code from the adjoining option list All the reason codes maintained in the Error Messages Maintenance CSDERMSG screen will be available for selection in the option list Description Give a brief description on the reason Enable Check this box to enable reason for the status in the Prospect Details screen An ALL ALL record is factory shipped You can copy this record and maintain the status and corresponding reasons for the particular branch Only those error codes with the function id as COMMON is displayed in the Reason Code Maintenance screen Note It is mandatory to select a reason when you select the status as Closed Rejected or Ad ditional Document Required If the reason is not specified then the system displays an er ror message as Reason for the chosen status mandatory Creating Customer Number You can create customer number for the leads in the following scenarios CIF Functionality in the Lead Screen If the customer is new then a new CIF Id will be allocated to the lead This CIF Id is displayed in the Customer Number of the Applicant Details section The CIF Id i
112. ion list displays all valid collateral branch codes maintained in the system Select the appropriate one Utilization Order Specify the collateral utilization order if any collaterals are linked to the Loan Commitment Product Specify the commitment product if any collaterals are linked to the Loan If you click on the Default button system defaults the existing collateral details based on the collateral code provided Linked Percentage Specify the linked percentage of the collateral amount to be linked to the pool in pool details and collateral contribution in facility details Linked Amount Specify the Linked amount based on the linked percentage Haircut 96 Specify the collateral haircut percentage for evaluating the collateral amount Utilization Order Specify the collateral utilization order Commitment Product Specify the commitment product associated with the collateral d ORACLE Note For more details on capturing Collateral details refer the chapter titled Maintaining Collat eral Details in Enterprise Limits and Collateral Management user manual Market Value Based Security ID Select the security id from the option list Number of units Nominal value Specify the number of units Cap Amount Specify the cap amount Guarantor Based Guarantor ID Select the Guarantor Id from the option list Rating The system displays the rating Haircut Schedules Specify the following
113. isplays the following values e Client e Server Printer Specify the name of the printer or select it from the option list provided The adjoining option list displays all the configured printers This is applicable only if you have specified the output as Print Once you have specified the details click the OK button The system generates the report Contents of the Report The contents of the report are discussed under the following heads Header The header carries the report title run date and time branch code branch name branch date user id module code and page number Body of the Report The following details are displayed in the report Field Name Description Branch Code Branch code of the transaction Product Code Produce code of the transaction Product Description Description of the product code Volume Count of the applications Currency Currency type of the product Amount Total amount against the product Ratio Analysis Report You can generate the ratio analysis report to analyse and compare the ratios by giving yearly and quarterly data of the customer You can also get information on the ratio group You can generate the ratio analysis report using the Ratio Analysis Report screen You can invoke TP ORACLE this screen by typing ORRRATRP in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button Ratio Analysis
114. ition of the task Click Ok to proceed to the next stage To select the acquired task for the next stage select Acquired under Standard option in the Task menu All the tasks that have been successfully acquired are displayed in the right side of the screen Search for your workflow reference number and click the Workflow Ref No to open Retail Loan Application Verification screen 299 ORACLE Step 1 Application Verification The information captured in the previous stage is verified in the Application Verification stage CMROLE Retail Loan Application Verification H save gM Hold Application Category CATO2 Product Code LRT3 Description Education Loans Application Branch 000 Application Date 2011 01 04 Promotion Code Leadid Enquiry ID Application Number RetailLending3900 User Reference 000LRT311004006 WEI Details Financial Requested Limit Collateral Comments Channel Intermediary Group Applicant Details 10f1 m Type Ig Primary 000 IF Co Applicant 000 Local Branch Customer No x Default KYC Required Application Priority Application Status Conversation ID Auto Decision Required Short Name 00006592 INE NISHA 00006597 ei SSS Customer Name National Id Low Verity Application Respons Borrower Co Borrower City Country GB Nationality GB Language ENG Customer Category INDIVIDUAL Financial Currency GBP Gr
115. ity Low X Application Category Lead Id Application Number Product Code Enquiry ID User Reference Description Offline Application Application Priority Low v Application Branch Number Application Status Application Entry Application Date naraun Conversation ID Promotion Code Applicant Details Type Primary X Local Branch Customer No Customer Name Main Details Financial Requested Limit Collateral Credit Score Bureau Ratio Loan Component Charge ig Invest 41 0f1 _ Verification Type Agency Status Call Date LBL NO OF ATMPTS LBL SPOKETO Result E EA lt m g Documents Tradeln KYC Review CustomerDedupe LoanDedupe Customer MIS MIS Customer AccountFields LBL SELLER DTLS A Vehicle Evaluator Bureau Report LoanMIS Loan Fields Prev Remarks Remarks Andit The following details related to the customer can be captured here Verification Type Select the type of verification The drop down list displays the following verification types e Address e Employment e Collateral e All Select the appropriate one Agency Specify the agency code of the agency who will investigate the information The option list displays all valid agency codes maintained under the branch code that you have specified above Select the appropriate one 2 124 ORACLE Status Specify the status of investigation The drop down list displays all statuses that are
116. l bar and click on the adjoining arrow button Pending Action leads User ID Branch Status Report Format PDF Printer At Client Report Output Print x Printer User Select the User from the adjoining option list Branch Select the branch from the adjoining option list Status Select the status from the adjoining option list Contents of the Report The parameters specified while generating the report are printed at the beginning of the report Other content displayed in the Report is as follows e ORACLE Header The Header carries the title of the Report information on the branch code branch date the date and time of report generation the user ID of the user generating the report module page and the event date Body of the Report The following details are displayed as body of the generated report Field Name Field Description Lead ID Indicates the lead ID created by the user ID User ID Indicates the user ID Branch Indicates the branch Status Indicates the status of the loan request Days of Inactivity Indicates the days lapsed from New to Follow Up 4 8 Offer Generated for Leads Report You can invoke the Offer Generated for Leads screen by typing the RLRPOFGR in the field at the top right corner of the Application tool bar and click on the adjoining arrow button Offer Generated for leads User ID Branch Status Report Format PDF Printer At
117. lar record based on desired search criteria e ORACLE You can invoke this screen by typing ORSOVDMT in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button Override Maintenance Authorization Status Record Status Process Code 28 Application Category j Advanced Search Records per page 15 v 1 Of 1 Authorization Status Record Status Process Code Application Category You can specify any of the following details to search for a record e Authorization Status e Record Status e Process Code e Application Category Click Search button to search for a record based on the search criteria specified You can double click a desired record to view the detailed screen 2 13 Maintaining Document Details You can maintain the list of documents that are required during the loan origination process in Documents Verify Maintenance screen Document checklists are maintained for an application category and for the various stages in the origination process You can also maintain the details of the Advices that need to be generated on completion of a stage in the process s ORACLE You can invoke Documents Verify Maintenance screen by typing ORDDOCMT in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button Document verify Maintenance FX New E3 Enter Query Process Code Application Category Process Sta
118. le you can specify the itemizations like Booking Amount Payment Interiors etc Requested Amount Specify the amount requested corresponding to the itemization specified Comments Specify comments if any corresponding to the itemization 2 23 7 Limit Tab You can capture the liability details pool details and line details in this tab oe ORACLE Retail Loan Origination X New E Enter Query Workflow Reference Priority Low M Application Category Leadld Application Number Product Code Enquiry ID User Reference Description Offline Application Application Priority Low Application Branch Number Application Status Application Entry Application Date p Conversation ID Promotion Code Applicant Details Type Primary Local Branch Customer No Customer Name Main Details Financial Requested Eul Collateral Comments Liability Details Line Details Pool Details Liability No Line Code Pool Code Liability Name Line Serial Pool Description Main Liability No Main Line Code Pool Currency Liability Branch Line Branch Pool Amount Liability Currency Line Currency Pool Utilized Overall Limit Limit Amount Collateral Amount Effective Line Amount Limit Collateral Basis Effective Line Amount Documents Tradeln CustomerDedupe LoanDedupe CustomerMIS MIS Customer AccountFields LBL SELLER DTLS Prev Remarks Remarks Audit Outcome In this
119. lect the customer number and click Default button the system displays the other details of the customer If the applicant provides the reference of a person who is not an existing customer of the bank then you can leave this field blank The system will display a default reference number You can capture the other details of the reference by clicking add row button Once you specify the customer number click Default button The system will display the remaining details as available in the customer record First Name Specify the first name of the person who referred the applicant Middle Name Specify the middle name of the person who referred the applicant Last Name Specify the last name of the person who referred the applicant Salutation Select a suitable salutation for the person from the drop down list It is mandatory to specify the salutation if you have entered the name of the reference Gender Select the gender of the person from the drop down list It is mandatory to specify the gender if you have entered the name of the reference Address Line 1 4 Specify the address of the person who referred the applicant You can use all the fields provided in order to capture the complete address Country Specify the country of the person who referred the applicant Nationality Specify the nationality of the person who referred the applicant Mobile Number Specify the mobile phone number of the reference If you have s
120. ler Passport Number Specify the passport number of the collateral seller Passport Issue Date Specify the issue date of the passport of the collateral seller Passport Expiry Date Specify the expiry date of the passport of the collateral seller Address Specify the address of the collateral seller Country Specify the country to which the collateral seller belongs The option list displays all valid country codes that are applicable Choose the appropriate one ane ORACLE Note If you specify any information regarding the collateral seller on this screen it becomes mandatory to specify the remaining details also This means that you cannot save the ap plication with data in only some fields of this screen The collateral seller information can not be left incomplete However you can completely ignore the collateral seller information if such details are not required If you do not enter any information on this screen then the system allows you to save the application 2 23 18 Viewing Vehicle Evaluator You can view the evaluated vehicle details captured as part of collateral details by clicking the Vehicle Evaluator button against the Applicant record Vehicle Evaluator Application Number RetallLending3248 Vehicle Id BMW12 Collateral Code 01 7ASTKVR14 ehicle Details Valuatio ure dentification Number 12535 Make ehicle Valuations Vehicle Attributes 10fl C attribute Description Attribute
121. ll decide the order of calling credit bureaus for credit check Bureau Call Order and Validity In this section you need to maintain the call order of the bureau for the Zip code ranges specified above Bureau Code Specify the bureau code You can select the appropriate bureau code from the option list Bureau Name Based on the bureau code selected the system displays the name of the bureau Bureau Call Order When there are multiple bureaus you can set the order in which the bureau will be called Select the order of this bureau from the option list The order 1 indicates that the bureau will be called first and the order 5 indicates that the bureau will be called at fifth turn Validity Period for Bureau Report The system displays the number of days during which the credit report from this bureau is considered as valid This can be one of the following values based on the details maintained in Bureau Maintenance Details screen e 30 days e 60 days e 90 days e 120 days Select the appropriate one Once you have specified the details save the maintenance During a retail loan application process the system will check the Zip code of the address of the applicant Based on the Zip code credit bureau call order maintenance the system will decide the credit bureau and request the credit report If the system is not able to get the credit report from the first credit bureau it will request a report from the second
122. loan applicant holds an account Select the appropriate branch code from the option list Account Class Specify the account class or select the account class of the customer from the option list provided ane ORACLE Account Number The account number gets generated when you click the P button after specifying the account class For the existing customer account you can select the account number from the adjoining option list Power of Attorney Note Ifthe FATCA is enabled atthe bank and the check box Power of Attorney is checked here then it is mandatory to specify the Power of Attorney information Power of Attorney Check this box to indicate that the customer account is to be operated by the power of attorney holder Holder Name The person who has been given the power of attorney Address Line 1 4 Specify the address of the power of attorney holder Country Specify the country of the power of attorney holder Nationality Specify the nationality of the power of attorney holder Telephone ISD Code Specify the international dialling code for the telephone number of the power of attorney holder The adjoining option list displays valid ISD codes maintained in the system Select the appropriate one Telephone Number Specify the telephone number of the power of attorney holder US Resident Status Permanent US Resident Status Check this box to indicate that the corresponding director
123. marks 2 2 10 Interaction Integration of the External System The customer initiates an interaction from the external system before lead generation The external system passes the conversation ID while submitting the lead request is ORACLE 2 3 If there is an existing interaction ID then it is intimated to Oracle FLEXCUBE at the time of lead creation along with the service request number The conversation ID passed by the external system is displayed in the Prospect Detail screen If you initiate an interaction through Oracle FLEXCUBE then you can capture the details in the Conversation Input screen The details in the conversation input screen are displayed if the conversation ID is maintained in the Prospect Detail screen Viewing Loan Prospect Summary You can view a summary of the prospective loan customers or the borrowers in Loan Prospect Details screen You can also query for a particular record based on desired search criteria You can invoke this screen by typing ORSLEADM in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button Loan Prospect details E gt Search Advanced Search 4C Reset 4 Clear All Case Sensitive Authorization Status Record Status Request ID Lead id Application Type Customer Id Loan Type Channel Branch Lae Records perpage 15 10f1 Authorization Status Record Status Request ID Date of Request Leadid Application
124. me MiddleName LastName Birth Date 1981 05 18 Summary 1 Summary 2 Trade Lines Public Trade Lines 10f1 gt M ss Creditors Name Status y CHIDU2 Initiated CHIDU2 Completed Customer No 000006150 644 Bureau Code EOFX Credit Report Id ReportDate 2013 08 21 Uniqueld 644 OnFile Date 2013 08 21 7 Best Match Records Collections Fraud Messages Inquiries Also Known As Consumer Statement Credit Scores Type Code PastDue Amt Balance Balance Date Public Records Credit Bureau Report Requested Id Report Header Bureau EQFX First Name MiddleName LastName Birth Date 1981 05 18 Public Records 1011 hk bl Record Type ANNUAL Status N Application Number RetailLending3852 Customer No 000006150 644 Bureau Code EQFX Credit Report Id Report Date Unique Id OnFile Date 2013 08 21 644 2013 08 21 7 Best Match Summary 1 Summary 2 Trade Lines Public Records Collections Fraud Messages Inquiries Also Known As Consumer Statement Credit Scores Amount FiledDate Satisfied Date iii 2 113 ORACLE Collections Credit Bureau Report Application Number RetailLending3852 Customer No 000006150 Requested Id 644 Bureau Code EQFX Report Header Bureau EQFX Credit Report Id 644 First Name ReportDate 2
125. n Specify the designation of the prospective customer Employee Id Specify the employee Id of the prospective customer Address Line 1 3 Specify the employment address of the customer in three lines starting from Address Line 1 to Address Line 3 Country Specify the country associated with the employment address specified Zip Specify the zip code associated with the office address specified Phone Number Specify the official phone number of the prospective customer Extension Specify the telephone extension number if any of the prospective customer Contact Phone Specify the contact number of the prospective customer Contact Name Specify the name of a contact person at the customer s office Contact Extension Specify the telephone extension number if any associated with contact person Comments Specify comments if any related to the customer s employment nis ORACLE Department Specify the department to which the customer belongs Reference Details If the applicant has provided any reference then you can capture the reference details here This information can be edited only at underwriting stage You can also add new references at Underwriting stage Reference No The applicant can provide the reference of a customer of the bank or even a person who is not a customer of the bank If the applicant provides the reference of a customer of the bank then specify the customer number Once you se
126. n 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 Cor
127. n this stage e The external system sends the document to the Document Management System and generates a DMS reference number Scenario 2 Uploading document during Additional Documents Required sta tus and replacing document against the same document category e The external system enables the document upload link and displays the document checklist to the customer e The customer can then upload a document against the document category in the checklist e The external system then sends the document to the DMS and generates a DMS reference number in Oracle FLEXCUBE e The external system sends the status as Review to Oracle FLEXCUBE to intimate about the document upload Generating Offers The offer is generated based on two conditions e Promotion code attached to the lead e Pricing code attached to the lead Offer letter when promotion code is not attached to the lead The offer letters are generated according to the offers mapped to the product code at application category maintenance screen ORDCATMT It is possible to map only five offers against each of the products mapped to the application category If a pricing Id is attached to the application category the offer defined in the pricing details screen ORDPRCMT will be used for generating offer letters Hence pricing will take precedence in offer generation For example M ORACLE When promotion code is not specified an application ca
128. ndition After building the condition click the Insert button to insert the same To remove a condition click the Clear button in the screen vM ORACLE 4 1 4 2 4 Reports Introduction The following are the reports that you can generate in Retail Loan Origination module Collateral Seller Details Report Reference Details Report Business Analysis Report Ratio Analysis Report Reject Analysis Report Lead Report Offer Generated for Leads Report Converted Leads Report Rejected and Closed Leads Report Non Originated Leads Report To generate any of these reports choose Reports in the Application Browser Choose Retail Lending under it A list of all the reports in Retail Lending module will be displayed You can choose to view or print the report The selection options that you specified while generating a report are printed at the beginning of every report Collateral Seller Details Report You can generate a report with the details collateral sellers for a retail loan application or account using Collateral Seller Details Report screen To invoke this screen type a ORACLE RLRPCLSR in the field at the top right corner of the application toolbar and click the adjoining arrow button Collateral Seller Details Application Number Account Number Report Format PrinterAt Client v Report Output Printer Specify the following details Application Number Specify the loan
129. ng values e Corporate e Retail e Both Group Worksheet Description Specify a brief description of the group worksheet you are maintaining s ORACLE SDE Name Specify a unique name for the SDE you are maintaining SDE Description Specify a description for the SDE you are maintaining Data Type Select the data type of the SDE from the adjoining drop down list This list displays the following values e VARCHAR2 e Number e Date SDE Type Select the SDE type from the adjoining drop down list This list displays the following values e Template e Static Derivation Required Check this box indicate that derivation formula is required for the SDE Derivation Formula Specify the derivation formula here You can also maintain the derivation formula in the Condition Builder screen which is invoked by clicking the Formula button Condition Builder Condition RSALES amp CSFS amp ondition Elements Braces Functions Elements Operators Logical Operators Index Specify the following details Condition Specify the condition for the rule here s ORACLE 3 3 Business Rule Braces Select the braces from the adjoining drop down list Functions Select the functions from the adjoining drop down list Elements Select the elements from the adjoining option list This list displays all valid elements maintained in the system Operators Select t
130. ng Formula Details You can specify the formula to calculate the credit score by clicking the Formula button corresponding to a credit risk entry in Risk Factor tab The Formula screen is displayed where you can specify the condition for calculating the credit score associated with a risk condition 1 Of 1 E Sequence Number Condition A Elements Index Functions Braces Operators Logical Operators You can specify the following details here Sequence Number The sequence number is automatically generated by the system Condition The condition specified using the Elements Functions Operators etc gets displayed here Result Specify the result to be associated with the condition specified Elements Specify the data elements to be used to define the formula for credit score calculation or select the element from the option list provided Functions Select the mathematical function to be used to define the formula from the drop down list provided Braces Select the opening or the closing brace from the drop down list provided to define the credit score calculation formula Operators Select the mathematical operator to be used to define the credit score calculation formula 3 64 GP You can select or f Logical Operators Select the logical operator to be used to define the credit score calculation formula You can select e gt lt gt gt lt gt F
131. ning arrow button 2 128 ORACLE Retail Loan Document Verification HB Save 4fy Hold Application Category Lead Id Application Number Product Code Enquiry ID User Reference Description Application Priority Low Application Branch 000 Application Status Application Entry Application Date 2011 01 04 Conversation ID Promotion Code ET Details Financial Requested Limit Collateral Credit Score Bureau Ratio Loan Component Charge Investigation Comments Channel KYC Required Intermediary Group Auto Decision Required Applicant Details 10tf 1 7 Type Existing Local Branch CustomerNo Default ShortName CustomerName Nationalld Responsibility Liability RMID RMName m J City First Name Power of Attorney Country Middle Name Power of Attorney Nationality Last Name Holder N older Name Language Salutation Mr iin ress Customer Category Gender Male x Financial Currency Birth Place Country Group Code Birth Country Nationality Mobile ISD Code Date of Birth Telephone ISD Code j d TE Mothers Maiden Name Telephone Number jome one poate Marital Status Married Tii Work Phone ISD Sees Permanent US Resident Work Phone SEN Sisin Email Account Details Visited US in last 3 years FaxISD Code Account Branch gi n J Documents Tradeln KYC Review CustomerDedupe LoanDedupe CustomerMIS CustomerAccountMIS
132. ntained in the system Select the appropriate one Mobile Number Specify the mobile number of the customer us ORACLE Telephone ISD Code Specify a valid international dialling code for the telephone number of the customer The adjoining option list displays valid ISD codes maintained in the system Select the appropriate one Landline Number Specify the landline number of the customer E mail Specify the E mail address of this customer Fax ISD Code Specify the international dialling code for the fax number of the customer The adjoining option list displays valid ISD codes maintained in the system Select the appropriate one Fax Specify the fax number of the customer SSN Specify applicant s SSN Applicant Details Type Select the type of the customer from the drop down list provided The following options are available e Primary e Co Applicant Existing Check this box to indicate if the customer applying for the loan is an existing customer of the bank Local Branch Specify the local branch home branch of the loan applicant Select the appropriate one from the option list Customer No The system displays the customer number However you can modify it For existing customers you need to select the customer number from the option list provided Click Default button to default the details of existing customers In case of new customers the checkbox Existing will be unchecked When you click
133. o Match Last Name el Date of Birth 1962 03 01 SON Remarks NoMa Country GB Reve Nationality GB Based on the KYC and SDN statuses and remarks the reviewer decides whether to move the task to the next stage Click Review button to view all customer information and perform KYC and SDN checks The KYC Review Screen STSKYCMN and SDN Review Screens ORSSDNMN are displayed KYC Maintenance Summary o X Authorization Status Il Record Status Iz KYC Reference aE Full Name of Customer i KYC Customer Type il Risk Level iT Reset Records per page 15 7 1 0f 1 Authorization Status Record Status KYC Reference Full Name of Customer KYC Customer Type Risk Level 2 101 ORACLE Alias Names Summary aa aS Name n Date of Birth e3 Country EL Reset Records per page 14 4 1 of 1 Name Date of Birth Country lt gt Once reviewed the verifier provides the review status and remarks You can perform a check on the customer record based on the KYC Review and SDN Review screens and choose the internal KYC status and SDN status respectively based on the review Step 1 External KYC Check You can verify the customer information against the external blacklist of customers at External KYC Check stage This step is enabled only if you have checked the box KYC Required during Application Entry You can invoke this screen by typing ORDRLIKC in the field at the top right corner
134. ocument Details mme menn 2 42 2 14 Viewing Document Checklist Summary essen enne 2 44 2 15 Maintaining Application Category Details ssen nne 2 45 2 15 1 Main Tabiri naa un RURSDUR ER nani 2 46 2 15 2 Agency Tabs i b EROR EG ORDRE URBE RH RE RN ERRAT ARA 2 49 2 16 Viewing Application Category Summary ssssssseeem eene 2 50 2 17 Maintaining Pricing Details ssssenn meme 2 50 2 18 Viewing Pricing Details aicest irrien enne nnne 2 52 2 18 1 Maintaining Pricing Formula sse 2 53 2 18 2 Maintaining Pricing Offer sse 2 54 2 19 Maintaining Field Investigation Details seem 2 55 2 19 1 Agency FAD i ides E Wad ARD RR eile adhe CREER ORAE RR 2 55 2 19 2 Others Tab serie ndi ai EH RH cO PUn 2 56 2 19 3 Viewing Field Investigation Summary sss 2 57 2 20 Updating Field Investigation Details 2 58 2 20 1 Investigation Tab eeessi ies enitn neta ttn adn deni aant nnn 2 59 2 20 2 Viewing Field Investigation Update Summary sss 2 60 2 21 Maintaining Credit Bureau Details seee m 2 60 2 21 1 Viewing Credit Bureau Summary sse 2 62 2 22 Maintaining ZIP Code Details for Bureau Call Order sees 2 63 2 22 1 Viewing Zip Code Summary sse 2 65 2 23 Stages in Retail Loan Origination
135. ollateral frequency Start Date Specify the collateral covenant start date Start Month Specify the collateral covenant start month Remarks Specify the covenant remarks Comments Tab In this tab you can specify comments if any related to the loan application zB ORACLE 2 23 10 Retail Loan Application Entry H Save 4m Hold Application Category CATO1 Lead Id ixl Application Number RetailLending4086 coi Product Code LRT3 a3 Enquiry ID ba User Reference 000LRT311004008 Description Education Loans el Application Priority Low Application Branch 000 Application Status A 3 Application Entry T Application Date 2011 01 04 Default M ir Conversation ID Promotion Code Main Details Financial Requested Limit Collateral Comments Comments 10f1 Es E Serial No Comments CommentBy Comment Date Documents Tradeln CustomerDedupe LoanDedupe CustomerMIS CustomerAccountMIS Customer AccountFields Seller Details Previous Remarks Remarks You can specify the following details here Sequence Number Audit The sequence number is automatically generated by the system Comments Specify comments if any to be associated with the loan application Comment By Specify the name of the commenter Comment Date Specify the date on which the comment was given or select the date by clicking the Calendar icon Capturing Document Details You can ca
136. omments Income Details 10f1 7 Income Type Frequency Currency Amount s E Salary Monthly Liability Details 10tf 1 7 Liability Type Liability Sub Type Frequency Currency Amount Account Balance Start Date End Date A F Loan Monthly Asset Details Vehicle Home 10f 1 Make Address Line 1 Type Tuan Model Address Line 2 e BERGE Manufacture Year Address Line 3 Asset Sub Type Body Width Description Reg Length Currency Occupancy Asset Value Documents Tradeln CustomerDedupe LoanDedupe CustomerMIS MIS Customer AccountFields LBL SELLER DTLS Prev Remarks Remarks Andit Income Details You can capture the following details corresponding to the loan applicant s income Income Type Select the type of income associated with the customer from the drop down list provided The following options are available e Salary 280 ORACLE e Rent e Business e Others Currency Specify the currency in which the customer draws his income or select the currency from the option list provided Amount Specify the amount that the customer draws as his income Frequency Select the frequency at which the customer earns income The following options are available in the drop down list e Daily e Weekly e Monthly e Quarterly e Half Yearly e Yearly Currency Specify the applicant s asset currency You can select the currency from the option list provided Amount Specify the amount
137. on Date 2011 01 04 Promotion Code Conversation ID Main Details Financial Requested Limit Collateral Credit Score Bureau Ratio Loan Component Charge Investigation Comments Pricing PricingiD P1 No ofinstallments Frequency Unit Rate Code Check Apply Monthy Monthly Loan Details Loan Branch 000 Value Date 2011 01 04 No ofinstallments 12 Loan Account Number Maturity Date Frequency 1 Financing Currency GBP Installment Start Date Unit Monthly Financing Amount 25 000 00 Status Change Mode Auto Close Collateral Effective Date User Defined Element Values Intermediary 10f1 Le 1 0f4 4 s 10f1 7 Effective Date E User Defined Elementid UserDefinedElemer Intermediary Code Intermediary Ratio lt i m Documents Tradeln KYC Review CustomerDedupe LoanDedupe CustomerMIS Customer Account MIS Customer AccountFields Seller Details bd Vehicle Evaluator Bureau Report LoanMIS Loan Fields Previous Remarks Remarks Audit Specify the following details 28 ORACLE Pricing ID System displays the default price in the pricing field You can select amp apply any one of the price available under a linked pricing group for the requested loan application among the available offers for the application category You can either proceed with the system selected offer or can select any other offer for the loan based on the need If
138. on on the loan offer selected by the customer You can also select the ID from the adjoining option list The list contains all the Enquiry IDs created for the customer as part of the loan simulation process Application Number The system displays the application number You cannot modify it User Reference System defaults the user reference number However you can modify it Application Priority Select the priority of application Application Status The status of the application gets displayed here Click Default button to default the details related to the prospective loan customer It also defaults the Application Category related details like documents mapped to that particular stage In the Category Maintenance screen if you have marked it as Default the system automatically displays the Product and Product Description Main Tab The details corresponding to the lead Id selected gets displayed in the Customer tab once you click the Default button You can modify these details if needed For existing customers of the bank you need to specify the following details Channel Specify the channel Id of the originating channel Intermediary Group Specify the identification code of the intermediary group if the customer has been associated with any KYC Required Check this box to indicate the KYC check is required for the customer If you check this box the system will evaluate a busines
139. or the credit bureau The following reports can be viewed E ORACLE Summary1 redit Bureau Report x Application Number RetailLending3852 Requested Id Report Header Bureau EQFX First Name MiddleName LastName Birth Date 1981 05 18 Customer No 000006150 644 Bureau Code EQFX Credit Report Id Report Date Unique Id On File Date 2013 08 21 644 2013 08 21 J Best Match Summary 1 Summar 2 Trade Lines Public Records Collections Fraud messages Inquiries Also Known As Consumer Statement Credit Scores Life Chapter Chapter11 Chapter13 Total 1 Recent Open 0 Chapter 0 Chapter7 0 Chapter11 0 Chapter11 0 Chapter13 0 Chapter13 0 Total 0 Total oooco Summary 2 Credit Bureau Report Application Number RetailLending3852 Customer No 000006150 Requested Id 644 Bureau Code EQFX Report Header Bureau EQFX Credit Report Id 644 First Name ReportDate 2013 08 21 MiddleName Uniqueld 644 LastName OnFileDate 2013 08 21 Birth Date 1981 05 18 7 Best Match Summary 4 Summary 2 Trade Lines Public Records Collections Fraud Messages Inquiries Also Known As Consumer Statement Credit Scores Inquiries Auto 0 6M 0 Bank 12M 0 Card 0 24M 0 Retail 0 Total 0 Financing 0 Newest 0 S35lac Finance n n Trade Lines Credit Bureau Report Application Number RetailLending3852 Requested Id Report Header Bureau EQFX First Na
140. or the credit bureau check from the following options in the drop down list e Completed This indicates that the credit checking is completed for the applicant e Required This indicates that credit checking is required for the applicant You need to select this when you manually enable external credit checking for an applicant e Pending Remarks Specify remarks if any associated with the loan application Score If the credit checking is completed the score is displayed here Enabling External Credit Check at Underwriting Stage You can enable external credit check during underwriting stage If external credit check is not enabled for an applicant primary applicant or co applicant or all you may enable it by following the steps given below e Inthe Main tab check the option External Credit Check Required for each applicant for whom you need to enable external credit check e Inthis tab specify the credit bureau by selecting the appropriate bureau code form the option list e In this tab in the field Recommended select Recommended from the drop down list e In this tab in the field Status select Required from the drop down list e Change Outcome to Verify e Save the record After enabling External Credit Check Required in the Main tab if you do not specify the bureau and other details the system will display an error message Until the external credit check is
141. ormation requested loan details collateral details etc are captured during this stage Documents obtained from the applicant are uploaded and advices maintained for the stage are generated by the process after completion of the stage You can key in the loan application details required in Retail Loan Application Entry screen You can also invoke this screen by typing ORDRLAPP in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button Retail Loan Application Entry H save dy Hola Application Category Product Code zz Description Application Branch 000 Application Date 2011 01 04 Promotion Code Lead d Enquiry ID Application Number RetailLending3796 User Reference Application Priority Low Application Status Application Entry Conversation ID QET Details Financial Requested Limit Collateral Comments Channel zzi Intermediary Group sz KYC Required 7 Auto Decision Required Applicant Details 10t4 c ESE E Type Existing Local Branch x Customer No Default ShortName Customer Name Nationalld Responsibility Liability RMID RMName City Country Nationality Language Customer Category Financial Currency Group Code Mobile ISD Code Mobile Number Home Phone ISD Home Phone Work Phone ISD Work Phone Email Fax ISD Code Fax First Name Middle Name Last Name Salutation Mr Gender Male Birth Place
142. ou can double click a desired record to view the detailed screen Maintaining Pricing Details Oracle FLEXCUBE allows you to maintain pricing groups and apply a suitable pricing rule to an application category during retail loan origination The pricing rule automatically selects the best matched loan offer for the loan application from the available offers for the application category aan ORACLE You need to maintain pricing groups and define the price IDs and formulae for the group using Pricing Maintenance screen To invoke the screen type ORDPRCMT in the field at the top right corner of the application toolbar and click the adjoining arrow button Pricing Maintenance E New E3 Enter Query Price Group ID Price Type Retail Description Pricing Details 1 Of 1 Price ID Price Description Default Formula Offer o E E CIE Date Time Checker Date Time Mod No Record Status Authorization Status Specify the following details Pricing Group ID Specify a unique name to identify the price group Description Specify a brief description of the price group Price Type Specify the price type associated with the price group You can choose one of the following price types e Corporate e Retail Pricing Details Specify the following details Price ID Specify a unique price ID This price ID can be applied to a loan at underwriting stage Price Des
143. oup Code Mobile ISD Code Mobile Number Home Phone ISD Home Phone Work Phone ISD Work Phone Email Fax ISD Code First Name Middle Name Last Name Salutation Mr Gender Male Birth Place Birth Country GB Date of Birth 1987 01 18 Mothers Maiden Name Marital Status Married Dependents SSN Account Details AccountBranch 000 Power of Attorney Holder Name Address Country Nationality Telephone ISD Code Telephone Number US Resident Status Power of Attorney Permanent US Resident Status Visited US in last 3 years and Account Class SAVST 4 m Documents Tradeln CustomerDedupe LoanDedupe CustomerMIS Customer Account MIS Customer AccountFields Seller Details Previous Remarks Remarks Audit The details related to the loan application entry are displayed in this screen which can be verified by the verifier The details cannot be modified in this stage but comments can be added appropriately On completion of this stage the advices that are maintained for the stage are generated The verifier can either send the application back to the previous stage if the information provided is not adequate or can cancel it if the information captured is not satisfactory If the application details are verified successfully the verifier can proceed with the processing of the application by selecting PROCEED as the Outcome The verifier can select RETURN to return the proces
144. pecified the name of the reference then it is mandatory to specify either the mobile phone number or the landline number ui ORACLE 2 23 5 Landline Number Specify the landline phone number of the reference If you have specified the name of the reference then it is mandatory to specify either the mobile phone number or the landline number Relation Specify the relation of the applicant with the person who referred him her If you are entering the reference details then it is mandatory to enter the relationship No of Years Known Specify the number of years for which the person provided in the reference knows the applicant For example if the reference knows the customer for five years enter 5 in this field If you are entering the reference details then it is mandatory to enter the number of years Financials Tab You can capture the financial details corresponding to the customer in this screen Retail Loan Origination a E New amp Enter Query Workflow Reference Priority Low Application Category Lead Id Application Number Product Code Enquiry ID User Reference Description Offline Application Application Priority Low Application Branch Number Application Status Application Entry M Application Date EM lt Conversation ID Promotion Code Applicant Details Type Primary X Local Branch Customer No Customer Name Main Details Requested Limit Collateral C
145. poration and its affiliates will not be responsible for any loss costs or damages incurred due to your access to or use of third party content products or services Contents Prefate ons nasterio iom ente eite eoe DLP bua tetrules t Denier 1 1 Wes dnttoduction cd ie PERO ER Aba M e eb Pe Fo e Leite 1 1 12 AUdIence e cbe rH ier cui gebeten DER t les 1 1 1 38 Documentation Accessibility esssseeeennn enne 1 1 1 4 Abbreviations v2 04 cer etie ectetuer a Ere tania aa 1 1 1 5 Organization desitedee et etr e RU REPRE SE dete nd andl ie eee aries 1 1 1 0 Related Documents rrenaren niee E EEEE nhan ed n ERR a aede and ena ua 1 2 137 Glossary ot I 0L8 5 oec n d eate eet e de diae aiite dete 1 2 Retail Loan Origination cci cee eter eee 2 1 24b nttoductiOmz atate ete ed Ut HO ERE Ot RS 2 1 2 2 Maintaining Loan Prospect Details sssse mme 2 1 22 1 Mall Tab rt RB etel deris 2 5 2 22 Detalls Tabaco a RR ORE ER UR ER EROR 2 9 2 3 Financial Tab te ad ek ta duc LEEA EAEE ad AERE a 2 11 2 2 4 Requested Tab oon sio c ede e tret dr 2 12 2 25 Document Details secessus n eene n ea anra hn anna aun 2 13 2 2 6 Process Flow in Uploading Document from an External System 2 14 2 2 7 Generating Offers o ic dae alae nie aA ae 2 14 2 2 8 Acceptance of the Offer by the Customer ssssssese 2 16 2 29 Conversation Details sssrini a aa esent 2 17
146. pture the customer related documents in central content management repository through the Documents screen Click button to invoke this screen You can also invoke this screen by typing CSCDOCUP in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button 2 90 ORACLE EU Advices Checklist Document Upload 1 Of 1 Go mm m gt gui E Document Category Document Reference DocumentType Remarks Ratio Upload Upload View Here you need to specify the following details Document Category Specify the category of the document to be uploaded Document Reference The system generates and displays a unique identifier for the document Document Type Specify the type of document that is to be uploaded Upload Click Upload button to open the Document Upload sub screen The Document Upload sub screen is displayed below Documents WEI Advices Checklist Document Upload Document Upload 10f 1 gums m gt ii Document Reference Ratio Upload Upload View az abc B i Document Path V Browse In the Document Upload sub screen specify the corresponding document path and click the Submit button Once the document is uploaded through the upload button the system displays the document reference number V
147. pture the details related to the finance in the Financial tab Prospect Details H save df Hold Leadld Branch 000 sz Application Type Retail v Description Date of Request 2011 01 04 Current Status NEW View Offers New Account Number New Status Request ID Conversation ID Channel FLEXCUBE Promotion Code Remarks Applicant Details Type Primary Customer Name TOM Main Details XDETISET Income Details 10f1 gt J Income Type Frequency Currency Business Monthly x a Documents Conversation Maker Date Time Mod No Checker Date Time Record Status Authorization Status Income Details Income Type Select the income type from the adjoining option list Frequency Select the frequency of the income of the applicant Currency Select the currency of the income from the adjoining option list Amount Specify the income amount zn ORACLE 2 2 4 Requested Tab You can capture the details related to the requested loan in Requested tab Prospect Details H save J Hold Leadid Branch 000 az Application Type Retail Description Date of Request 2011 01 04 Current Status NEW New Account Number New Status Request ID Conversation ID Channel FLEXCUBE Promotion Code Main Details Financial asi EEICIS Requested Loan Details Requested Currency 2E Rate LoanType
148. requency Specify the frequency at which the loan disbursement should be carried out Rate Specify the interest rate to be associated with the loan Rate Code Specify the rate code used to derive the interest rate or select the rate code from the option list provided Default Check this box to indicate if the loan offer specified should be maintained as the default offer for the application category 246 ORACLE 2 15 2 Agency Tab In Agency tab you can capture the details of the credit rating agencies and credit bureaus that provide credit rating details for customer securities Application Category Maintenance Detail x H save 4 Hola Application Category Application Type Real Category Description Rule Id Ratio Id Pricing Group Ba Bal Ba Main Agency Credit Agency aor E 7 Agency Code Agency Name q V Bureau Details 10f1 x Tm di 7 Bureau Code Bureau Call Priority v IE rg Maker Date Time Mod No Checker Record Status Date Time Authorization Status You can specify the following details in this screen Credit Agency You can capture the details related to the credit rating agencies here Agency Code Specify the identification code of the rating agency that provides credit rating details for customer securities Agency Name Specify the name of the rating agency that pro
149. roaching the bank with enquiries about the loan products offered by the bank The following details would need to be captured as part of the simulation e Personal Details of the Prospect e Loan offers selected by the Prospect Based on the product offers selected and requested details the system will generate loan and schedule details You can enter the required details for the prospective customer in Retail Loan Simulation Details screen You can invoke this screen by typing ORDRLSIM in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button You can also invoke this screen by clicking on View Offers button in the Prospect Detail screen Retail Loan Simulation Details E New E5 Enter Query Enquiry ID Branch Status Active Enquiry Date Application Category User Reference Request ID Product Code Lead d Request Date Description Customer Details Customer No First Name Contact Number Last Name Email Requested Loan Details Requested Currency Rate Loan Purpose Requested Amount Tenor In Months Generate Olfers Loan Component Multiple Offers 10f 1 Offer Reference Number Offerid Noofinstallments Frequency Unit Rate RateCode View Format Loan Details Loan Branch Value Date Frequency Loan Account Number Maturity Date Unit Monthly Financing Currency Installment Stat Date Liquidation Mode Auto Financing Amoun
150. rsementAmount AmountToDisburse Already Disbursed Amount fc 2012 03 05 100000 100000 0 Split Details 10f1 1 88 LH Split Sequence No Split Percent 96 Payment Mode Settlement Branch Settlement Account Number o 50 ACC 000 3 0000000000009 28 tz 50 ACC 001 ak 0010000001031 P The following details related to the Loan Disbursal schedules can be captured here e Schedule Date e Total Disburse Amount e Amount to Disburse e Already Disbursed Amount The following Disbursal Schedule s Split Details can be captured here e Split Sequence No e Split Percentage e Split Amount e Payment Mode e Settlement Branch e Settlement Account Number 2 128 ORACLE e Account Description e Customer amp Settlement Currency 2 23 26 2 Viewing Schedule Details You can view the modified schedule details Schedule details screen You can invoke this screen by clicking Schedule Details button Schedule Details Application Number RetailLending3248 CO Component Name PRINCIPAL 2 Schedule Details 10f1 E O Due Date Amount Settled Amount Due EMI amount Amortized Principal Accrued v 2012 07 03 0 8333 33 0 2012 08 03 0 4 8333 33 2012 09 03 0 8333 33 C 2012 10 03 0 8333 33 2012 11 05 0 8333 33 C 2012 12 05 0 8333 33 a CUT z ROAR TT r v 2 23 27 Charges Tab In Charges tab the system calculates and displays charges if any applicable Retail Loan Und
151. s later released when the status of the lead is Rejected or Closed For the existing customer you can unlock and amend the CIF Id with the correct CIF Id in the Customer Number of Applicant Details section For the existing customer without the external system log in but with existing relationship details provided from the external system but not validated by the external system e The existing check box will be auto checked by the system and walk in customer Id will be defaulted by the system in Customer Number of Applicant Details section in lead screen when the request is received from the channels However when the lead record is modified and saved by the branch user the system will display an error message as Invalid CIF Cannot amend a lead as existing customer and walk in Customer ID You can then amend and input a correct customer number For the existing customer with the external system log in the customer number will be validated and sent from the external system CIF release condition to be added for Loan All the blocked CIF IDs are released by the system for loan leads with status as either Rejected or Closed en ORACLE 2 5 For leads with the status as Converted which are not specified in the origination workflow the bank can decide to change the status to Closed so that the blocked CIF number can be released Simulating Retail Loans You can simulate a loan proposal for a customer app
152. s rule Based on that rule the system initiates internal KYC or External KYC or both during application entry and verification stage If you do not check this box the system then system skips the Internal KYC and External KYC stages after completing the application entry and verification stages en ORACLE Auto Decision Required Check this box to enable auto decision on loan application If you check this box based on the applicant credit score auto decision mapping maintained in Auto Decision screen the system decides whether to approve reject recommend approval or recommend rejection of the application If you do not check this box the system will not make an auto decision with regard to approval of the application You can set the status of this check box only during Application Entry stage External Credit Check Required This is defaulted from Application Category Maintenance screen The credit check initiation happens before underwriting stage Note Note the following n case external credit check is not enabled for the application category and if you enable it at the application entry stage the system will display an error message External credit check not required for primary applicant Incase external credit check is enabled only for primary applicant in the application category and if you enable it for other applicants the system will display an error message External credit check required
153. s stage the bank assesses the eligibility of the borrower for the requested loan offer based on the analysis of the borrower s financial ratios and credit scores The bank also obtains credit details from external agencies and field investigation agencies You can also invoke Retail Loan Underwriting screen by typing ORDRLUND in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button Main Tab System defaults the customer details provided in the Application Entry stage here However you can modify it After ascertaining the eligibility of the customer the bank provides multiple loan offers for the borrower and uses one offer chosen by the customer to generate payment schedule and schedule details The advices that are maintained for the stage are generated on completion of the stage In this stage the bank also conducts vehicle evaluation based on the details that have been captured at the Application Entry stage This evaluation can be done with details from an external agency in the collateral tab Collateral Tab You can carry out the evaluation of vehicles in the collateral tab Here the details provided as part of the Application Entry stage are defaulted which you can modify The evaluation can be done by interfacing with external agencies 2 199 ORACLE E Retail Loan Origination E New E3 Enter Query Application Date Promotion Code Applicant Details
154. s to previous stage for data correction or CANCEL to terminate the process On successful verification a message stating that the task is successfully completed gets displayed To acquire the next stage you need to go to the Task menu and select Assigned under Standard option All tasks that have been successfully completed are listed in the right side of the screen Select the checkbox against your Workflow Ref No and click Acquire button at the top of the screen to acquire the next stage of the task The system displays the system message as Acquire Successful on successful acquisition of the task Click Ok to proceed to the next stage To select the acquired task for the next stage select Acquired under Standard option in the Task menu All the tasks that have been ids ORACLE successfully acquired are displayed in the right side of the screen Search for your workflow reference number and click the Workflow Ref No to open Retail Loan Underwriting screen Step 2 Internal KYC Check You can verify the customer information against the internal blacklist of customers at Internal KYC Check stage This step is enabled only if you have checked the box KYC Required during Application Entry Application Number RetaiLending1179 ie Customer No 001004388 KYC Review Details Local Branch 001 KYC intemal Status No Ma First Name Middle Name wan
155. screen specify the following details Liability Details Liability No Select the applicant s liability number The adjoining option list displays all the valid liability numbers maintained in the system Select the appropriate one Liability Name Select the liability name Main Liability No Select the parent liability number The adjoining option list displays all the valid liability number maintained in the system Select the appropriate one Liability Branch Select the liability branch The adjoining option list displays all the valid liability branches maintained in the system Select the appropriate one Liability Currency Select the liability currency The adjoining option list displays all the valid liability currencies maintained in the system Select the appropriate one Overall Limit Specify the overall liability limit Line Details Line Code Select the applicant s facility The adjoining option list displays all the valid line codes maintained in the system Select the appropriate one Zu ORACLE 2 23 8 Line Serial Specify the line serial number Main Line Code Select the parent facility if the specified applicants facility is associated with any parent facility from the adjoining option list Line Branch Select the facility branch code The adjoining option list displays all the valid line branches maintained in the system Select the appropriate one Line Currency Select the facility currenc
156. sed on the application number selected the system displays the following details of the applicant e Type of applicant e Local branch code of the applicant e Customer number e Name of the applicant one ORACLE 2 20 1 Investigation Tab Under this tab you can update the specify investigation details Verification Type Select the type of verification The drop down list displays the following verification types e Address e Employment e Collateral Select the appropriate one Agency Specify the agency code of the agency who will investigate the information The option list displays all valid agency codes maintained under the branch code that you have specified above Select the appropriate one Status Specify the status of investigation The drop down list displays all statuses that are enabled in Others tab of the Field Investigation Maintenance screen for the selected agency Call Date If the agency has conducted the investigation over the phone specify the date on which the phone call was made Number of Attempts Specify the number of attempts made to investigate This includes the number of visits phone calls and other attempts that were made during investigation Spoke To Specify the name of the person to whom the investigation agency has spoken in order to get the information verified Result Specify the result of the investigation The drop down list displays all valid results that are enabled
157. t Status Change Mode Auto Ir No ofInstallments 12 Effective Date User Defined Element Values 10f1 10f1 E l Effective Date User Defined Elementid User Defined Element Value Rate Code Codeusage Resolvedvalue Maker Date Time Mod No Checker Record Status Date Time Authorization Status If details are available as part of the maintenance for the prospect in the Prospect Details screen then after you specify the Application category Product Code and Customer Number ae ORACLE in this screen if you click the Default button the system will populate all loan and schedule details available for the prospect When you create a new proposal the system will generate the Enquiry ID and the Date for the proposal You are required to capture the following details Enquiry ID On clicking the Default button the system generates and displays a unique enquiry ID Branch Code The system displays the enquiry branch code This cannot be modified Enquiry Date The system displays the date of enquiry Enquiry date cannot be modified Request ID The system displays the request ID Request Date The system displays the date when the request for loan was received Application Category Specify the application category for the loan enquiry You can also select it from the adjoining option list Product Code Specify the product code for loan product selected by the customer You c
158. t if any by clicking Customer Account Fields button against a row in the Applicant Details table The User Defined Field screen gets displayed where you can maintain the UDF details 2 94 ORACLE 2 23 17 4 User Defined Fields X Application Number RetailLending4093 CD i CustomerBranch 000 CustomerNo 00006875 Character Fields Number Fields Date Fields 10f1 Go 1 Of 1 1 Of 1 Field Name Value Field Name Value fw Field Name Value PRIORITY cl CUSTDATE fal Ej TELLERTELLERTELLE C ELOVTEST O SAMPLE You can specify the following user defined field details for the customer in Customer Tab Name Specify the name of the UDF being created for the customer Value Specify the value associated with the UDF being created for the customer User Defined Fields Application Number RetailLending4093 Customer Customer Account Account Branch 000 Account Number Character Fields Number Fields Date Fields 10f1 10f1 10f1 E Field Name Value E FieldName Value Field Name Value You can specify the following user defined field details for the customer account in Customer Account Tab Name Specify the name of the UDF being created for the customer account Value Specify the value associated with the UDF being created for the customer account Specifying Collateral Seller Details
159. t Details Click on Documents link to invoke the Documents screen You can upload the required documents from the external system Documents EWE Advices Checklist Document Upload 10f1 Document Category Document Reference Document Type Remarks Ratio Uploz P e zzi ke El Document Category Select the document category from the adjoining option list Document Reference Specify the document reference Document Type Select the type of document from the adjoining option list Remarks Specify remarks if any Ratio Upload Check this box to enable ratio upload Upload Click on Upload button to upload the document zm ORACLE 2 2 6 2 2 7 View Click on View button to view the uploaded document The document upload from the external system is allowed only when e the customer submits the loan request from the external system e the status in the Prospect Details screen is Additional Documents Required Note The documents uploaded by the customer through the external system is stored in the Document Management System with a document reference number Process Flow in Uploading Document from an External System You can upload the required documents for the loan request from an external system Scenario 1 Uploading document during loan request submission e The customer can upload any kind of document along with the document type i
160. tallments Units Frequency Rate RateCode Default Maker Date Time Mod No Checker Record Status Date Time Authorization Status You can specify the following details in this screen Application Category Specify a unique identification for the loan application category Category Description Specify a suitable description for the loan application category Rule Id Specify the credit rule to be associated with the application category or select the Rule Id from the option list provided Ratio Id Specify the credit ratio to be associated with the application category or select the Ratio Id from the option list provided Pricing Group Specify the pricing group to be linked to the retail loan category The option list displays all valid pricing groups applicable Choose the appropriate one Main Tab You can capture the following details in the Main tab Product Details You can specify the following details related to the loan product here 246 ORACLE Product Code Specify the identification code of the loan product to be linked to the application category being maintained You can also select the product code from the option list provided Product Description The description associated with the selected loan product gets displayed here Default Check this box to indicate if the loan product selected should be maintained as the default product for the application category External Credit Check
161. ted at the beginning of the report Other content displayed in the Report is as follows ale ORACLE Header The Header carries the title of the Report information on the branch code branch date the date and time of report generation the user ID of the user generating the report module page and the event date Body of the Report The following details are displayed as body of the generated report Field Name Field Description Lead ID Indicates the lead ID created by the user ID User ID Indicates the user ID Branch Indicates the branch Status Indicates the status of the loan request Reason Indicates the reason for the status change to Rejected and Closed 4 11 Non Originated Leads Report You can invoke the Non Originated Leads screen by typing the RLRPNORR in the field at the top right corner of the Application tool bar and click on the adjoining arrow button Non originated Leads User ID Branch Status ReportFormat PDF v Printer At Client v Report Output Print Printer az User Select the User from the adjoining option list Branch Select the branch from the adjoining option list Status Select the status from the adjoining option list T9 ORACLE 4 11 1 Contents of the Report The parameters specified while generating the report are printed at the beginning of the report Other content displayed in the Report is as follows
162. tegory without any pricing group attached is selected Application Category Retail P Pricing group attached No Products Mapped Product A B with five offers each In the simulation screen launched from the prospect details screen ORDLEADM when the application category Retail P and the product code as A is selected then the offers matching the requested loan details are displayed When promotion code is not specified an application category with attached pricing group is selected In ORDCATMT screen application category maintenance detail screen Application Category Retail P Pricing group attached PRC1 Products Mapped Product A B with five offers each In ORDPRCMT screen Pricing detail screen Pricing group PRC1 Price Id 1 Price Id 2 Price Id 3 Default pricing System will check the calculated score based on the requested loan details as entered in the lead screen and displays the offer maintained for Default pricing id price id 3 Offer generation when promotion code is attached to the lead If a valid promotion ID is attached to a lead ID the offer is mapped against the promotion code in promotion details screen CLDPROMT for offer generation On clicking View Offers the simulation screen is invoked and the option list against the application category displays only those application categories with which the product associated with the specific promotion code has been linked Hence the system val
163. tem supports multiple User Defined Elements here based on the effective dates maintained UDE Id Select the User Defined Element Id from the adjoining option list Value Specify the UDE value Rate Code Select the rate code for UDE from the adjoining option list Code Usage Select the code usage from the adjoining drop down list 259 ORACLE 2 23 26 Resolved Value The system defaults the system revised UDE value Intermediary System displays the intermediary details including the compensation percentage for each Intermediary based on the Inetrmediary code mainatined in Application Entry stage However you can modify it The payment schedules are derived based on the offer selected Note You can select only one loan offer in this screen Component Tab In Component tab the system calculates and displays component name schedule type first due date number frequency units and amount details based on the loan offer selected If you have selected an Enquiry ID for the customer then the schedule details that have been stored for the corresponding loan proposal are displayed here You can modify them if required Retail Loan Underwriting yes es Save Hold Application Category RCAT1 Lead Id Application Number RetailLending3899 Product Code LRT4 Enquiry ID User Reference 000LRT411004001 Description Demand loans with Co Application Priority Low Application Branch 000 Application Status
164. that evaluation should be done you will not be allowed to select PROCEED or CANCEL as the Outcome till the verification has been successfully done The system will invoke the external valuation agency for credit evaluation You can view the details in the bureau tab This includes the score assigned by the agency for the customer Credit Bureau Report Application Number RetailLending3852 Customer No 000006150 Requested Id 644 Bureau Code EQFX Report Header Bureau EQFX Credit Report Id 644 First Name ReportDate 2013 08 21 MiddleName Uniqueld 644 Last Name OnFile Date 2013 08 21 Birth Date 1981 05 18 Best Match ERREUR Summary 2 Trade Lines Public Records Collections Fraud Messages Inquiries Also Known As Consumer Statement Credit Scores Life Recent Open Chapter 0 Chapter 0 Chapter7 Chapter11 0 Chapter11 0 Chapter11 Ae iain Alla Fu E In this screen you can view the information available for the customer by clicking the Report button under the field Status in the External Credit Rating section If the information is available the status is updated to COMPLETED in the collateral tab If it does not match then the status is updated to NO DATA Once the verification is completed you can select the Outcome as PROCEED and move to the next stage You can click Report button adjacent to credit rating record or credit bureau record to view the report obtained from the credit rating agency
165. that the customer draws as his income Liability Details You can capture the following details corresponding to the loan applicant s liabilities Liability Type Select the type of the liability from the following options provided in the drop down list e Loan e Lease e Rent e Others Liability Sub Type Specify the sub type corresponding to the liability Frequency Select the frequency at which the customer pays his liability amount The following options are available in the drop down list e Daily e Weekly e Monthly e Quarterly e Half Yearly e Yearly d ORACLE Currency Specify the currency in which the customer pays his liability amount You can select the appropriate currency from the option list provided Amount Specify the amount that the customer pays as his liability Account Balance Specify the balance associated with the liability account Start Date Specify a start date for the liability or select the start date by clicking the Calendar icon End Date Specify an end date for the liability or select the end date by clicking the Calendar icon Asset Details Type Select the type of the asset from the following options available in the drop down list e Vehicle e Home e Others Asset Sub Type Specify the sub type associated with the asset Description Specify a suitable description for the asset type Asset Value Specify the value associated with the asset Vehicle You can sp
166. the Retail Loan simulation screen However you are not allowed to modify and re simulate in this screen Request ID The system displays the request identification of the loan request Channel The system by default displays FLEXCUBE as the channel However you can modify if needed The adjoining option list displays a list of valid channels Select the appropriate one Promotion Code Indicate the promotion code 2 2 ORACLE Remarks Specify the reason for the loan enquiry Branch code The system displays the branch code However you can modify it Date of Request Specify the date when the prospective customer enquired about the loan You can also select the date from the adjoining Calendar icon New Account Number The system updates the new account number automatically when you create a customer account in BPEL flow by changing the lead status to Converted Note You can update the Customer Account in the New Account number field by changing the status of the Lead record to Converted This is applicable only for CASA lead origination This is not relevant for Loan leads Application Type Select the application type from the adjoining drop down list The available options are e Retail e Corporate e CASA e Ijarah e stisna e Mudarabah e Murabaha e Musharaka e Tawarooq Current Status The system displays the current status of the lead New Status Select the new status
167. the details of the conditions to be checked for generating override messages a0 ORACLE 2 12 Sequence Number The sequence number is automatically generated by the system Condition The condition specified using the Elements Functions Operators etc gets displayed here Error Code Specify the error code to be used to generate the override message or select the error code from the option list provided Error Parameter Specify the error parameter to be substituted in the override messages Elements Specify the data elements to be used to define the conditions for generating override messages or select the element from the option list provided Functions Select the mathematical function to be used to define the condition from the drop down list provided Braces Select the opening or the closing brace from the drop down list provided to define the conditions for generating override messages Operators Select the mathematical operator to be used to define the conditions for generating override 6 38 messages You can select or f Logical Operators Select the logical operator to be used to define the conditions for generating override messages You can select lt gt lt gt gt lt AND or OR Viewing Override Summary You can view a summary of the overrides in Override Maintenance screen You can also query for a particu
168. tion Details X H save Enquiry ID ENQ262 cl Branch 000 Status Active EnquiryDate 2011 01 04 Application Category CATO2 asl User Reference 000LRT311004008 Request ID Product Code LRT3 a Leadid Request Date Description Education Loans je Customer Details Customer No 000003171 FirstName Abel Contact Number Last Name Email Requested Loan Details Requested Currency GBP a Rate Loan Purpose cal Requested Amount Tenor In Months 12 Loan Component Component Name ol m Main Component 10f 1 Component Currency Hat 7 Capitalized _ Explode Schedule ci Liquidation Mode Auto Explode Schedule Waive Schedules 10tf1 a I 5 Schedule Type Schedule Flag Formula FirstDue Date NoofSchedules Units Frequency Schedule Start Date x End Date Amount EMIAmo lt m al D Maker Date Time Mod No Checker Record Status m Date Time Authorization Status You can specify the following schedule related details Compound Days Specify the number of compound days Compound Months Specify the number of compound months Compound Years Specify the number of compound years Years Select the actual number of days for the year from the adjoining drop down list You can select one of the following options e 360 e 365 e Actual Days in Month Select the number of days that would constitute
169. tion in the above screens Result You can configure the results here The results that you enable here will be available at the following places for selection e Result field on the Investigation tab of Field Investigation Update ORDFIUPD screen e Result field on the Investigation tab at Retail Loan Underwriting Stage You can add a new result or delete an existing result using the add row button or delete row button respectively Code Specify a unique code that identifies the result that you are maintaining Description Specify a brief description of the result Enabled Check this box to enable the result If you enable the result the system will allow you to use the corresponding result in the following places e Result field on the Investigation tab of Field Investigation Update ORDFIUPD screen e Result field on the Investigation tab at Retail Loan Underwriting Stage If you do not check the box for a particular result you will not get that result for selection in the above screens Once you have captured the details save the maintenance Viewing Field Investigation Summary You can view a summary of the field investigations maintained in the system using Field Investigation Summary screen To invoke the screen type ORSFIAMT in the field at the top right corner of the application toolbar and click the adjoining arrow button
170. try Specify the country associated with the address specified 9 ORACLE Employment Details Employer Specify the name of the employer of the prospective customer Employment Type Select the customer s employment type from the drop down provided The following options are available e Part Time e Full Time e Contract Based Occupation Specify the occupation of the prospective customer Designation Specify the designation of the prospective customer Employee Id Specify the employee Id of the prospective customer Address Line 1 4 Specify the employment address of the customer in four lines starting from Address Line 1 to Address Line 4 Country Specify the country associated with the employment address specified Pincode Specify the zip code associated with the office address specified Phone Number Specify the official phone number of the prospective customer Extension Specify the telephone extension number if any of the prospective customer Contact Phone Specify the contact phone number of the customer s contact person Contact Name Specify the name of a contact person at the customer s office Contact Extension Specify the telephone extension number if any associated with contact person Department Specify the department to which the customer belongs Comments Specify comments if any related to the customer s employment 2519 ORACLE 2 2 3 Financial Tab You can ca
171. uested by the prospect The request loan details are propagated from the lead screen if the simulation screen is invoked from the lead screen ORDLEADM Requested Currency Specify the loan currency preference of the customer You can select the appropriate currency code from the option list Requested Amount Specify the loan amount requested by the prospective customer Interest Rate Specify the preferred interest rate of the prospective customer Tenor In Months Specify the preferred loan tenor in months of the prospective customer Promotion ID Select the promotion ID from the adjoining option list Loan Purpose Specify the customer s purpose for obtaining the loan Click on Generate Offers to generate multiple offers and auto calculate schedules for each offer You can view the schedules by e Clicking on view against each offer in the selected format or e Check each offer and go to component tab to view the details You cannot modify details and re simulate the offers if the simulation is done from the lead screen ORDLEADM However in the standalone simulation screen you can modify and simulate again To simulate the modified details in standalone simulation screen e Check one of the offers of the multiple offers generated e The details against the particular checked offer will be displayed in the loan details tab ici ORACLE e You can modify the details in the loan details tab and then click on
172. unt Value Date Specify the date on which the loan was initiated Maturity Date Specify the maturity date of the loan ied ORACLE 2 5 2 Instalment Start Date Specify the date on which the first instalment falls due Status Change Mode Specify the status change mode of the loan The status change mode can be one of the following e Auto e Manual No of Installments Specify the total number of instalments Frequency Specify the frequency of the loan Unit Specify the unit of the frequency The unit can be one of the following e Daily e Weekly e Monthly e Quarterly e Half Yearly e Yearly e Bullet Effective Date Specify the following details Effective Date Specify the effective date of the loan User Defined Element Values Specify the following details User Defined Element ID Specify the user defined element ID User Defined Element Value Specify the value of the user defined element ID Rate Code Specify the rate code to be used for the user defined element Code Usage Select the code usage from the drop down list Resolved Component Tab After the loan details have been displayed by the system or modified as per your requirements click Apply The system will process these details Click Component and the a8 ORACLE system will display the details of the payment and amortization schedules based on the loan details Retail Loan Simula
173. us Record Status Enquiry ID Application Category Product Code Customer Number First Name Last Name Status User Reference Click Search button to search for a record based on the search criteria specified You can double click a desired record to view the detailed screen 2n ORACLE 2 7 Maintaining Credit Rating Rules You can maintain a set of questions along with a possible set of answers with associated scores to assess the credit rating of a prospective loan customer You can also calculate the risk factor associated with the loan and arrive at a credit grade based on the scores obtained You can maintain these details in Rule Details screen You can invoke this screen by typing ORDRULMT in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button E Rule Maintenance EX New E3 Enter Query Rule Id 7 New Route Account Description Type Retail WET Risk Factor Question Details 1 011 Question Id Category Question T Answer Details 10f1 Sequence Number Possible Answer Score A Rating Auto Decision Maker Date Time Checker Date Time Mod No Record Status Authorization Status You can specify the following details in this screen Rule Id Specify a unique identification for the credit rating rule Account Description Specify a suitable description for th
174. vides credit rating details for customer securities Bureau Details You can capture the details related to the credit bureau here Bureau Code Specify the identification code of the credit bureau that provides credit ratings for customer securities ane ORACLE 2 16 2 17 Bureau Based on the bureau code the system displays the name of the bureau that provides credit rating details for customer securities Call Priority Specify the priority of this bureau in the order of preference by which the bureaus will be called When there are multiple bureaus this bureau will be called based on the priority set here Viewing Application Category Summary You can view a summary of the application categories in Category Details screen You can also query for a particular record based on desired search criteria You can invoke this screen by typing ORSCATMT in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button Category Details Authorization Status Record Status Application Category IE Financing Type Advanced Search Records per page 15 v 1 0t 1 Authorization Status Record Status Application Category Category Description Financing Type You can specify any of the following details to search for a record e Authorization Status e Record Status e Application Category Click Search button to search for a record based on the search criteria specified Y
175. work on the relevant transaction Oracle Business rules that are embedded help the dynamic creation of multiple approval stages The different stages and sub stages in the process flow can be summarized as follows e Application Entry the following details are captured in this stage 299 ORACLE 2 23 1 Applicant Information Application details Requested Loan Details Collateral Details Checklist Documents Advice Generation Application Verification Information captured during Application Entry stage is verified Advice Generation Internal KYC External KYC Underwriting Collateral Vehicle Valuation Information Applicant Financial Ratios Applicant Credit Score Applicant Bureau Report Loan Offers Loan Schedules Loan Charges Field Investigation Document Capture Advice Generation Loan Approval Information captured during Previous stages are verified Advice Generation Document Verification Information captured during Previous stages are verified All documents obtained are verified against checklist Advice Generation Manual Retry The various tasks carried out in these stages will be explained in detail in the subsequent sections Process Flow Diagram The process flow diagram given below illustrates the activities carried out during the different stages of the workflow 206 ORACLE pz
176. y Sub Category SDE Type Maker Date Time Mod No Checker Record Status Date Time Authorization Status Specify the following details Industry Specify the industry name here Sheet Name Specify the worksheet name here Short Description Specify a brief description about the template Worksheet Worksheet Name Specify the worksheet name here Worksheet Description Specify a brief description about the worksheet Work sheet Required Check this box to indicate that work sheet should be generated in excel format SDE Details SDE Name Specify the SDE name here SDE Description Specify a brief description of the SDE Data Type Select the data type from the adjoining drop down list This list displays the following values ORACLE 3 4 e VARCHAR2 e Number e Date Category Select the SDE category from the adjoining drop down list This list displays the following values e Asset e Liability e Income e Expense Sub Category Select the sub category of the SDE from the adjoining option list This list displays all valid sub categories maintained in the system Note The sub category should be defined as an SDE in the SDE Maintenance ORDSDEMT screen SDE Type System displays the SDE type here The SDE type could either be General SDE or Derived SDE Maintaining Ratio Details You can define templates for calculating financial ratios taken from the balance sheet
177. y code The adjoining option list displays all the valid line currencies maintained in the system Select the appropriate one Line Amount Specify the line amount for the facility Collateral Amount If the collateral is maintained system displays the collateral amount when you click on Default button Otherwise system displays the value as zero Effective Line Amount basis Select the basis on which the effective line amount is calculated Effective Line Amount System displays the effective line amount based on the specified effective line amount basis Pool Details Pool Code Select the collateral pool code The adjoining option list displays all the valid pool codes maintained in the system Select the appropriate one Pool Description Specify the collateral pool description Pool Currency Select the collateral pool currency The adjoining option list displays all the valid pool currencies maintained in the system Select the appropriate one Pool Amount Specify the collateral pool amount Pool Utilized Specify the collateral pool amount utilized amount If you click on the Default button system displays the collaterals in the Collateral Tab associated with the pool code and liability Collaterals Tab You can capture the details related to the collaterals provided by the customer in this tab ae ORACLE Retail Loan Origination E New E3 Enter Query Workflow Reference Priority
178. you change a price ID selected by the system and reapply a different price ID the system changes the score of the pricing rule The score determines the price ID to be automatically applied Click Apply button to apply the selected price ID to the loan On clicking Apply button the system compares each offer under Multiple Offers with the pricing and other details requested The values in the fields No of Installments Frequency and Unit are compared with the values given by the applicant in the Requested tab during Application Entry stage The rate under Multiple Offers is compared with the rate maintained in the Pricing ID On comparison if the system finds a matching offer it applies the details of the offer to the application In case the details do not match the system creates a new row with the values available in the offers maintained for the pricing ID and applies it Status Change Mode Select the status change mode of the loan The adjoining option list displays the following option e Auto To change the status automatically e Manual To change the status manually Close Collateral Check this box to give a provision to close the collaterals associated with the Loan It can be selected only if the liquidation mode is Auto Effective Date The system captures the effective date of User defined elements However you can modify it in underwriting stage User Defined Element Values The sys

Retail Loan Origination User Manual

Contents

Download Pdf Manuals

Related Search

Related Contents