Home

Retail Loan Origination User Manual

1. 1 43 1416 6 Requested Ib i bees 1 46 9 asna 1 47 1 16 8 Comes Ibu 1 48 1 169 Capturing Document ith thea 1 49 1 16 10 Capturing Trade Tu Details ttr pr etre ter hee ita ii ere ke EP 1 50 1 16 11 Collateral PER 1 54 1 16 12 Credit 1 57 1 16 13 B rean He 1 58 1 16 14 Ronos OIL 1 64 1 16 15 Voi ERE TM 1 65 1 16 16 Schedule o1 1 66 1 16 17 Charges LAD aqya 1 67 1 16 18 1 68 1 16 19 Investigation E 1 70 1 16 20 Ch cklist 1 71 1 16 21 Comments il qD iyun 1 72 1 17 CREATING OFFLINE LOAN 8 40044000 1 75 1 1 ORACLE 1 18 LOGGING EEKE EER 1 76 1 10 SELECTING THE APPLICATION ee o dec tu va noo con vae eua eon
2. 1 22 1 9 VIEWING CREDIT RATIO SUMMARY uu 1 23 1 10 MAINTAINING OVERRIDE DETAILS ccccccceseeececececececececeeececeeeeececeeeeeeeceeeceesceeecececececeeeeeeeeeeseeeeceeeeeeeeess 1 23 1 11 VIEWING OVERRIDE SUMMARY tette enc ex eet veo eek e Sue EN SEEN ex exu uve Nee un ue p ue EN SEE use 1 26 112 MAINTAINING DOCUMENT CHECKLIST AND 0 0004 0 00 1 26 1 13 VIEWING DOCUMENT CHECKLIST SUMMARY ccccccceseceseceeecececececececeesesceeececececececececececeeeeeeeeeeeeeeeeeeeeeeess 1 29 1 14 MAINTAINING APPLICATION CATEGORY 4000448 1000 1 29 Mam Tabu aee dece e dee eed 1 30 EDAD cB BCNCY VOD sak atau 1 32 1 15 VIEWING APPLICATION CATEGORY SUMMARY ccccccsecesseesscececececeesceesesesesesceeecececseececeeeeeeeeeeseeeeceeseeeeess 1 33 1 16 STAGES IN RETAIL LOAN ORIGINATION 1 34 LAO DU EID RT 1 35 DESIT PROCESS SERERE 1 35 1 16 3 Cuslomer 1 39 TO Details E EE E 1 41
3. 1 77 1 20 CREATING APPLICATIONS es eee oreet vue eve oae aea vue eene uv eue Sue eu ue og eeu voe ue ape oye use Pee au assia 1 77 REPORTS 2 1 2 1 INTRODUCTION zu S see dries te neo 2 1 2 2 PREFUNDING CONTRACT REPORT 2 1 2 2 1 Contents 0f the Report ce ertet t ei oe du WERTE TR ER V BEER e RUNS 2 2 2 3 FUNDED CONTRACTS REPORT tede teste ia en 2 2 2 3 1 Contents of the Report ce ttti tete a eee Hol ue BE ER Sie eus 2 3 2 4 CREDIT APPLICATION BY USER 2 4 2 4 1 Conlents of the Report P SSS 2 5 2 5 UNDERWRITING STATUS BY MONTH AND INTERMEDIARY 2 6 2 5 1 Contentsof the Report u sss SEE 2 6 2 6 UNDERWRITING STATUS BY MONTH AND UNDERWRITER 2 7 2 6 1 Contentsof THER OD OTE E um 2 8 2 1 UNDERWRITING STATUS BY MONTH 2 9 2 7 1 Contents OF the d qp 2 9 SCREEN GLOSSARY d n 3 1 3 1 FUNCTION TD Ag T EE 3 1 1 2 ORACLE 1 1 1 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 approa
4. Outcome 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 1 54 ORACLE Model Specify the vehicle model Body Specify the vehicle body details Usage Specify the mileage used by the vehicle till date You can retrieve vehicle details from an external agency either by specifying the identification number for the vehicle or all of the following fields 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 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 are 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
5. Last 78 Contact Number Emeilid Search Advanced Search Authorization Status Record Status Enquiry ID First Name Last Name Contact Number You can specify any of the following details to search for a record Authorization Status Record Status Enquiry ID Customer Number First Name Last Name Contact Number Email ld ORACLE 1 6 Click Search button to search for record based on the search criteria specified You double click a desired record to view the detailed screen 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 Rule Maintenance Rule Id Type Retail Description Corporate Main Risk Factor Question Details 10f1 Lu Answer Details _ 10f1 riy Date Time Mod No Checker Date Time Record Status Status You can specify the following details in this screen Rule Id Specify a unique identification for the cred
6. 1 000 00 Ok Cancel The system displays the current branch code and loan account number in the fields at the top of the screen Under Liquidate Loans you need to capture the following details Branch This refers to the branch from which the loan being liquidated has been taken Specify the branch code The option list displays all valid branch codes applicable to the customer Choose the appropriate one Account Number Specify the account number of the loan being liquidated The option list displays all valid loan accounts maintained for the customer Choose the appropriate one 1 53 ORACLE Outstanding Amount The system displays the current outstanding amount of the linked loan However you cannot modify this Once you have captured these details click button to save 1 16 13 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 Retail Loan Underwriting Stage Application Category Product Code Lead ld Enquiry ID Priority Customer Collateral Details Collateral ld Collateral Description Collateral Currency Collateral Value Market Value Based Security ld Units Nominal Value Cap Amount Vehicle Details Identification Number Year Make Details
7. Auto Bank Card Retail Loan Finance Sales Finance 6M 12M 24M Total Newest Oldest Trade Lines Creditbureau Report Report Header Bureau First Name MI LastName Birth Dt Summary1 Summary2 TradeLines PublicRecords Collections Fraud Messages Credit Report Id Report Dt Unique Id Onfile Dt Best Match Inquiries Also Known s Consumer Statement Credit Scores Trade Lines 10f1 editors Name Public Records Creditbureau Report Report Header Bureau First Name MI LastName Birth Dt Summary1 Summary2 Tradelines Public Records Credit Report Id Report Dt Unique Id Onfile Dt Best Match Collections Fraud Messages Inquiries Also Known 5 ConsumerStatement Credit Scores Public Records 108 Record Filed Dt Satisfied Dt 1 61 ORACLE Collections Creditbureau Report Report Header Bureau Credit Report Id FirstName Report Dt MI Unique Id LastName Onfile Dt Birth Dt Best Match Summary1 Summary2 TradeLines Public Records Collections FraudMessages Inquiries Also Known s ConsumerStatement Credit Scores Collections 1081 editors Name Balance High Balance Term Type Open Dt Creditbureau Report Report Header Bureau Credit Report Id First Name Report Dt MI Unique Id Last Name Onfile Dt Birth Dt Best Match Summary1 Summary2 TradeLines Public Records Collecti
8. Product Code This indicates the product for the contract Application Number This indicates the application number for the loan Application Date This indicates the date of the application Stage This indicates the stage for the application Contract Date This indicates the contract date Contract Amount This indicates the contract amount Contract Interest This indicates the interest rate for the contract Contract Term This indicates the duration of the contract Branch Total This indicates the total number of records for the branch 2 3 Funded Contracts Report This report lists the applications funded for the loan You can invoke the Funded Contract screen by typing RLRPFNCR in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button 2 2 ORACLE 2 3 1 Funded Contract Funded Contracts Report Branch Code From Date ToDate Specify the following details Branch Specify the branch for which you wish to generate the report You can also select the branch from the adjoining option list The list contains all the valid branches maintained in the system From Date Specify from the adjoining calendar button the date from which you require details To Date Specify from the adjoining calendar button the date till which you require details Click OK button to generate the report Click Exit t
9. 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 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 Application Entry the following details are captured in this stage gt Applicant Information gt Application details gt Requested Loan Details gt Collateral Details gt Checklist gt Documents gt Advice Generation Application Verification gt Information captured during Application Entry stage is verified gt Advice Generation Underwriting gt Collateral Valuation Information gt Applicant Financial Ratios gt Applicant Credit Score gt Applicant Bureau Report gt Loan Offers gt Loan Schedules gt Loan Charges gt Field Investigation gt Document Capture gt Advice Generation Loan Approval gt Information captured during Previous stages are verified gt Advice Generation Document Verification gt Information captured during Previous stages are verified gt All documents obtained are verified against checklist gt Advice Generation Customer Customer Account Contract Collateral Creation 1 34 ORACLE gt Customer Creation gt Customer Account Creation gt Loan Account Creation gt Collateral C
10. 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 Bureau Specify the name of the credit bureau that provides credit rating details for customer securities 1 15 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 the field at the top right corner of the Application tool bar and clicking the adjoining arrow button Category Details Authorization Status Application Category Records 15 Authorization Status Record Status Q Search Advanced Search Record Status Application Category You can specify any of the following details to search for a record e Authorization Status 1 33 ORACLE Record Status 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 1 16 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
11. 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 10f1 a Elements 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 You can select or f 1 18 ORACLE 1 6 3 1 7 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 Sp
12. 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 1 14 1 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 1 30 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 Other 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 Monthly Quarterly e Half Yearly Yearly Frequency 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
13. Select the recommendation of the credit agency for the loan requested from the following options provided in the drop down list Recommended e Not Recommended 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 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 which will be the underwriting stage again The following messag
14. 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 101 Attribute Description Attribute Code Attribute Value Package Incl p 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 For more details on capturing Collateral details refer the chapter titled Maintaining Collateral Details in Enterprise Limits and Collateral Management user manual 1 56 ORACLE 1 16 14 Credit Score 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 Credit engine obtains information from customer and calculates credit score and displays system recommendation Retail Loan Underwriting Stage Workflow Reference Priority Application Category Application Number Branch Code Product Code User Reference Channel Le
15. 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 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 1 22 ORACLE 1 9 Operators Select the mathematical operator to be used to define the credit ratio calculation formula You can select or 7 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 You can invoke this screen by typing ORSRATMT 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 ld Q Search Advanced Search Records per page Authorization Status Record Status Group ld You can specify any of the following details to search for a record e Authorization Status e Record Status e Group 1 Click Search bu
16. option to indicate whether the document is mandatory or not You can select any of the following options from the drop down list provided 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 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 1 28 ORACLE 1 13 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 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 Authorization Status Record Status Process Code Application Category Co Search Advanced Search Records per page Authorization Status Record Status Process Code Application Catd You can specify any of the following details to search for a record Authorization Status Record Status e Process Code e Appli
17. 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 Workflow Reference Priority Application Category Application Number Branch Code Product Code User Reference Channel Lead Id Date Intermediary Code Enquiry ID Purpose Status Priority Offline Application Number Customer Details Financials Requested Collaterals Comments Loan Requested Currency Interest Rate Requested Amount Down Payment Amount Tenor In Months Promotion Id Itemizations 10f1 r gt Prev Remarks Remarks Outcome You can also capture the following itemization details corresponding to the requested loan Itemization Specify the tenor itemization that is required For example you can specify the itemizations like Booking Amount Payment Interiors etc 1 46 ORACLE Requested Amount Specify the amount requested corresponding to the itemization specified Comments Specify comments if any corresponding to the itemization 1 16 7 Collaterals Tab You can capture the details related to the collaterals provided by the customer in this tab Retail Loan Application Entry Workflow Reference Application Category Product Code Lead Id Enquiry ID Priority Priority Application Number User Reference Date Purpose
18. that have been stored for the corresponding loan proposal are displayed here You can modify them if required 1 66 ORACLE Retail Loan Underwriting Stage Workflow Reference Priority Application Category Application Number Branch Code Product Code UserReference Channel Lead Id Date Intermediary Code Enquiry ID Purpose Status Priority Lov Offline Application Number Customer Details Financials Requested Collaterals CreditScore Bureau LMC Eligibility Ratio Loan Schedule Charges Fields Investigation Check List Comments Schedule 10f1 soeaseTe rstoveoae ramen E Details 10f1 Component Name Amount Due EMI amount Amortized Principal m Prev Remarks Remarks The following details related to the schedule are displayed here e Component name e Schedule type e First due date e Number e Frequency e Units 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 1 16 19 Charges Tab In Charges tab the system calculates and displays charges if any applicable 1 67 ORACLE Retail Loan Underwriting Stage Workflow Reference Priority Application Category Application Number Branch Code Product Code User Reference Channel Lead Id Date Intermediary Code Enquiry ID Purpose Status Offline App
19. the address you specify here is the customer s mailing address 1 5 ORACLE Address Line 1 3 Specify the address of the customer in three lines starting from Address Line 1 to Address Line 3 Contact Number Specify the contact telephone number of the customer Zip Specify the zip code associated wit the address specified Country Specify the country associated with the address specified Employment Details Seq No The sequence number is automatically generated by the system 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 Employer Specify the name of the employer of the prospective customer 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 3 Specify the employment address of the customer in three lines starting from Address Line 1 to Address Line 3 Zip Specify the zip code associated with the office address specified Country Specify the country associated with the employment address specified 1 6 ORACLE Phone Specify the official phone number of the prospective customer Extn Specify the telephone extension number if any of the prospective customer Contact Specify the contact number of the pro
20. the applications for which you have access rights will be displayed as shown in the screen below ORACLE DATABASE LITE 10g Mobile Workspace 77 Corporateloan2220 77 Corporate oanDec 23800 gt vateLoan 2 CororateLoanDec23800 CorporateLoans1155 7 Retalloan910 CorporateLoans 1155 RetailLoan 10 7 RetailLoans729 gt RetailLoans 729 In this screen select the retail lending URL The screens in which you require to capture information are displayed 1 20 Creating Applications You can enter the required details in the following screens to create a loan application 1 20 1 1 Customer Tab The Application Number is auto generated You can enter the following details in this tab e Loan Product e Originating Channel e User Reference Number e Purpose e Intermediary e Loan Prospect e Application and Customers Information 437 ORACLE Retail Loan Application Entry Save Application Details Cancel Application Category RETAR 1 User Reference Number 1001 Channel Ofline Product VVV3 Date 24 12 2010 m Intermediary Code 000000010 v Leadid VEH_LD_01 v Purpose TESTING Status NEW APPLICATION v Application Number RetailLending1001 Branch Code 001 Customer Details Financials Requested Collaterals Comments Add Cancel Application Entry Applicant Details Synchronization Type Primary Date Of Birth Office Number Existing
21. 1 Summary2 Trade Lines Credit Scores Credit Report Id Report Dt Unique Id Onfile Dt Best Match Collections Fraud Messages Inquiries Also Known As Consumer Statement Credit Scores Score Model Score 1 16 16 Ratios Tab Score Factor 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 Stage Application Category Application Number Branch Code Product Code User Reference Number Channel Lead Id a3 Date 5 Intermediary Code Enquiry ID 2s Purpose Status ew Aj Priority 1 Offline Application 73 Number Customer Details Financials Requested Collaterals Credit Score Bureau LMC Eligibility Ratio Loan Schedule Charges Fields Investigation Check List Comments Applicant Details I4 4 101 gt M EJE m Existing Customer No Def Salutation First Name Middle Name LastName National Id Dedup tocan Short Name Gender Male Date of Birth Mothers Maiden Name Financial Currency Customer Category Account Number Account Class Trade In Liquidate Loans Prev Remarks Country Nationality Language Mobile Number Landline Number Office Number Fax Remarks Passport Number Passport Issue Date
22. ACLE 2 6 1 User ID Specify the ID of the user for which you wish to generate the report You can also select the ID from the adjoining option list The list contains all the valid users with underwriter role maintained in the system Branch Specify the branch for which you wish to generate the report You can also select the branch from the adjoining option list The list contains all the valid branches maintained in the system From Date Specify from the adjoining calendar button the date from which you require details To Date Specify from the adjoining calendar button the date till which you require details Click OK button to generate the report Click Exit to return to the Reports Browser Contents of the Report The contents of the report are discussed under the following heads Header The Header carries the Report Name Run Date and Time Branch Underwriter Code Month for which report is being generated and the Period for which the report is generated Body of the Report The following details are displayed in the report Field Name Field Description Product This indicates the product for the contract Application No This indicates the loan application number Stage This indicates the stage for the application Application Date This indicates the date of the application Contract Date This indicates the contract date Contract Amount This indicates the contract am
23. CEED Exit 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 or the credit bureau The following reports can be viewed Summary1 Creditbureau Report Report Header Bureau Credit Report Id First Name Report Dt MI Unique Id Last Name Onfile Dt Birth Dt Best Match Summary Summary2 TradeLines Public Records Collections FraudMessages Inquiries Also Known s ConsumerStatement Credit Scores Bankruptcy Life Chapter Chapter11 Chapter13 Total Chapter Chapter11 Chapter13 Total 1 60 Chapter Chapter11 Chapter13 Total ORACLE Summary 2 Creditbureau Report Report Header Bureau First Name MI LastName Birth Dt Credit Report Id Report Dt Unique Id Onfile Dt Best Match Summary1 Summarj2 TradeLines Public Records Collections Fraud Messages Inquiries Also Known 5 ConsumerStatement Credit Scores Inquiries
24. Code Product Code User Reference Channel Lead ld Date Intermediary Code Enquiry ID Purpose Status Priority Offline Application Number Customer Details Financials Requested Collaterals Credit Score Bureau LMC Eligibility Ratio Loan Schedule Charges Fields Investigation Check List Comments Credit Bureau Details 10f1 Status Remarks Report cansAP a External Credit Rating Remarks Status External Agency Score Recommended Prev Remarks Remarks Outcome 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 Customer Id The identification of the loan customer gets displayed here Bureau The credit bureau maintained for the Application Category in Application Category Maintenance gets displayed here Status Select the status for the credit bureau check from the following options in the drop down list e Completed Pending Remarks Specify remarks if any associated with the loan application 1 58 ORACLE 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
25. Customer Details Financials Requested Collaterals Comments Branch Code Channel Intermediary Code Status Offline Application Number Collateral Details Collateral Id Collateral Description Collateral Currency Collateral Value Market Value Based Security Id Units Nominal Value Cap Amount Start Date End Date Collateral Category Collateral Type Guarantor Based Guarantor Id Rating Haircut Revision Date Charge Type Revaluation Date Revalue Collateral Vehicle Details Identification Number Year Covenant Details 10f1 Make Model Body Usage Covenant Name Reversal Date Mandatory Grace Days Notice Days Frequency Start Month Prev Remarks Remarks Outcome 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 Year Specify the year of manufacture for the vehicle ORACLE 1 47 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 These details will be used at the underwriting stage to evaluate the vehicle For more details on capturing Collateral detail
26. Description Specify a suitable description for the loan origination stage 1 24 ORACLE Overrides Here you can capture the details of the conditions to be checked for generating override messages 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 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 lt AND OR 1 25 ORACLE 1 14 1 12 Vie
27. Financ als Requested Credit Score Bureau LMC Eligibility Ratio Loan Schedule Charges Fields Application Number User Reference Date Purpose Start Date End Date Collateral Category Collateral Type Guarantor Based Guarantor Id Rating Model Body Usage RETAIL1 i 6 Branch Code Channel Intermediary Code Status Offline Application Number Haircut Revision Date Charge Type Revaluation Date Valuation Source Valuation Status Investigation a Check List Comments amp Mortgage gt Revalue Collateral Internal Recommended Evaluate Covenant Details Covenant Name Reversal Date Mandatory Grace Days Notice Days Frequency Start Month se Prev Remarks Vehicle Details You can modify the details of the vehicle which is to be evaluated in the fields listed below Identification Number Remarks In this screen capture the following details
28. ID Product Code Branch Customer Details First Name Contact Number Customer No LastName Email Id Requested Rate Down Payment Amount Currency Tenor Down Payment 95 Requested Amount Loan Schedule Schedule 10f1 Schedule Due Date Number Amount n lt Schedule Details r LE Maker Date Time Mod No Checker Date Time Record Status Authorization Status 1 13 ORACLE 1 5 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 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 A Record Status Enquiry ID First
29. Loan Schedule Charges Fields Investigation CheckList Comments Applicant Details 1of1 3188 Short Name Country Gender Male x Nationality Date of Birth Language Mothers Maiden Name Mobile Number E mail Passport Number Passport Issue Date Passport Expiry Date m m m Financial Currency Landline Number Dependents Customer Category Office Number Marital Status Married Account Number Fax Account Class Prev Remarks Remarks Outcome 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 1 74 ORACLE 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 Docu
30. Model Manufacture Year Body Reg Address Line 1 Address Line 2 Address Line 3 Width Length Occupancy Outcome 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 e Rent e Business e Others 1 43 ORACLE 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 Daily e Weekly Monthly e Quarterly Half Yearly e Yearly 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 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 Daily Weekly Monthly e Quarterly Half Yearly Yearly Amount Specify the amount that the customer pays as his liability 1 44 ORACLE Acco
31. Number Retail ending1001 Branch Code Customer Details Financials Requested Collaterals Comments Collateral Details Collateral Code ESCORP Collateral Description ESCORP GBP Collateral Currency Seve Add Cancel 1001 Channel Ofline 24 12 2010 Intermediary 000000010 v TESTING Status NEW APPLICATION v 001 Add Cancel Collateral Value 100000 1 80 ORACLE For details this screen refer the corresponding tab in the Retail Loan Application Entry screen described earlier in this manual 1 20 1 6 Comments Tab In this tab you can capture the following details e User Comments e User who commented and Date the comments were given Retail Loan Application Entry Application Details Application Category RETAR 1 User Reference Number 1001 Channel Ofline Product Code VVV3 Date 24 12 2010 z Intermediary Code 000000010 v Application Entry a 7 Leadid VEH LD 01 Purpose TESTING Status NEW APPLICATION v Synchronization Application Number RetailLending1001 Branch Code 001 Customer Details Financials Requested Collaterals Comments 1 Add Comments Comments Comment By Comment Date FULL CASE 29460 24 12 2010 m For details on this screen refer the corresponding tab in the Retail Loan Application Entry screen described earlier in this manual 1 20 1 7 Transferring Data to Oracle FLEXCUBE Database After you have captur
32. O Mothers Maiden Name Fax Customer No 001001926 Financial Cumency G8 Passport Number Salutation a Customer Cat INDIVIDUAL Passport Issue Date m N Account Number 00100192601 Passport Expiry Date N Middle Mame County GB E mail Last Name Nationality GB Dependents language ENG Marital Status Select v Short Name RON Mobile Number Gender Male Landline Number For details on this screen refer the corresponding tab in the Retail Loan Application Entry screen described earlier in this manual 1 20 1 2 Details Tab You can enter the following details in this tab e Address Details Employment Details Retail Loan Application Entry Save Application Details Cancel Application Category 1 User Reference Number 1001 Channel Product Code VVV3 Date 24 12 2010 intermediary Code 000000010 Lead id VEH_LD_01 v Purpose TESTING Status NEW APPLICATION v Application Number RetailLending1001 Branch Code 001 Customer Details Financials Requested Collaterals Comment Application Entry pe Address Details Synchronization Address PERMANENT V Address Line 1 100 Country Mailing Address Line 2 Zip Address Line 3 Contact Number Cancel Employment Details Employer 21100 Address Line 1 BANGALORE Extn Employment Type FULLTIME Address Line 2 Co
33. 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 1 55 ORACLE The following message gets displayed on successful acquisition of the task Acquire Successful 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 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
34. Passport Expiry Date E mail Dependents Marital Status Outcome iv The stated income and debt of the customer are displayed here You can capture the following additional details here 1 64 ORACLE 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 1 16 17 Loan Tab In the Loans 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 1 65 ORACLE Retail Loan Underwriting Stage Workflow Reference Priority Application Category Application Number Branch Code Product Code User Reference Channel Lead Id Date Interme
35. Purpose Customer Details Financials Requested Collaterals Comments Branch Code Channel Intermediary Code Status Offline Application Number Address Details Address Type Permanent Mailing Employment Details Address Line 1 Address Line 2 Address Line 3 Country Zip Contact Number Employer Employment Type Occupation Designation Employee Id Prev Remarks Address Line 1 Address Line 2 Address Line 3 Country Zip Phone Number Outcome Extension Contact Phone Contact Name Contact Extension Comments Department In this screen you can capture multiple address and employment details if required 1 42 ORACLE 1 16 5 Financials Tab You can capture the financial details corresponding to the customer in this screen Retail Loan Application Entry Workflow Reference Application Category Product Code Lead Id Enquiry ID Priority Customer Details Financials Requested Collaterals Priority Application Number User Reference Date Purpose Comments Branch Code Channel Intermediary Code Status Offline Application Number Income Details 10f1 Salar Liability Details 10 Liability Type Liability Sub Type Frequency Account Balance Start Date End Date Asset Details Vehicle Type hicle Asset Sub Type Description Asset Value Prev Remarks Remarks Income Details Make
36. Requested Amount Specify the loan amount requested by the prospective customer Default Interest rate Specify the preferred interest rate of the prospective customer Tenor Specify the preferred loan tenor in months of the prospective customer Down payment 96 Specify the percentage of amount that the prospective customer can provide as down payment Down payment Amount Specify the preferred amount that the prospective customer can provide as down payment Loan Tab You can maintain the offers for the customer in the loan tab 1 11 ORACLE Retail Loan Simulation Details Retail Loan Simulation Application Category Date Enquiry ID Product Code Branch Customer Details First Name Contact Number Customer No Last Name Email Id Requested Rate Down Payment Amount Currency Tenor Down Payment 96 Requested Amount Loan Schedule Multiple Offers 10 No of installments units Frequency Rate Code Loan Details Rate No of Installments Currency Value Date Units Loan Amount Maturity Date Frequency Down Payment Amount Installment Start Date Account Number Effective Rate Maker Date Time Mod No Checker Date Time Record Status Authorization Status Enter the following details here 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
37. Retail Loan Origination Oracle FLEXCUBE Universal Banking Release 11 3 83 02 0 April 2014 Oracle Part Number 52607 01 ORACLE FINANCIAL SERVICES ORACLE Retail Loan Origination 1 Table of Contents RETAIL LOAN ORIGINATION 1 1 1 1 INTRODUCTION ERR 1 1 1 2 MAINTAINING LOAN PROSPECT 65 8 1 2 1 2 1 1 3 1 2 2 BINDER 1 5 1 2 3 Requested Tb iie Ge e pt Ee er eset diee tede deter 1 6 1 3 VIEWING LOAN PROSPECT SUMMARY 1 8 1 4 SIMULATING RETAIL LOANS 1 9 1 4 1 Loan Taba mm 1 11 1 42 Schedule y nuusan un as SDS 1 13 1 5 VIEWING SIMULATED LOAN 5 1 14 1 6 MAINTAINING CREDIT RATING 1 15 1 6 1 Mam Tab LE 1 16 1 6 2 RISK LGD EE 1 17 1 6 3 Specifying Credit Grades iiti i ete trt ud ete t e e 1 19 1 7 VIEWING CREDIT RULE SUMMARY ccccccccccccesecesesececeseseseessesusesssesssesssesssessseessesssesssesssesssesssesssessseseseseaess 1 19 1 8 MAINTAINING CREDIT RATIOS u La 1 21 1 8 1 Specifying Formula Details uiia iecit
38. Retaillending1461 Application Entry ALLROLES ALLREAD 2010 07 01 18 41 27 IST Pending 0 RetaiLending1464 8 Application Entry ALLROLES ALLREAD 2010 07 01 18 87 11 IST Supervisor 0 OpenSavingsAccounti46S _ Receive And Verify ALLROLES RCSEROLE ALLREAD 2010 07 01 19 06 37 IST OpenCurrentAccounti466 _ RecieveandVerifyCustDetails ALLROLES ALLREAD 2010 07 01 19 07 20 IST RetaiLending1467 Application Entry ALLROLES ALLREAD 2010 07 01 19 07 44 IST Retaillending1469 Application Entry ALLROLES ALLREAD 2010 07 01 19 45 10 IST RetaiLending1471 Application Entry ALLROLES ALLREAD 2010 07 01 19 55 02 IST RetaiLending1364 Document Verification ALLROLES ALLREAD 2010 07 02 11 24 34 IST Low RetailLending1478 Underwriting ALLROLES ALLREAD 2010 07 02 14 14 12 IST Low Task History Action Time PickUp Time User ID User Name Action Code Action Description Branch Remarks Menu Workflow Customer My Dash Board 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 following message gets displayed on successful acquisition of the task Acquire Successful 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 b
39. ad Id Date Intermediary Code Enquiry ID Purpose Status Priority Offline Application Number Customer Details Financials Requested Collaterals CreditScore Bureau LMC Eligibility Ratio Loan Schedule Charges Fields Investigation Check List Comments Internal Credit Rating Rule Id 10f1 Grade raw n ses Risk Factor Details 10f1 Prev Remarks Remarks Outcome 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 for the risk factor associated with the loan 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 1 57 ORACLE 1 16 15 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 Retail Loan Underwriting Stage Workflow Reference Priority Application Category Application Number Branch
40. alculate 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 Group Id Type Retail Description Corporate Ratio Id 10f1 Maker Date Time Mod No Checker Date Time 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 Select the type of the loan from the following options available Retail Corporate Ratio Id Specify a unique identification for the credit ratio being maintained Description Specify a suitable description for the credit ratio 1 21 ORACLE 1 8 1 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 CEZONEEI Elements Functions Braces Operators 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
41. apturing Asset Valuation details refer the section titled Account Asset Valuation in Retail Lending user manual 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 lf any of the mandatory documents are missing the system displays an error message e lf any of the override documents are missing the system displays an override message f 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 1 50 ORACLE The task is completed successfully The Workflow Reference Number is RetailLending lt nnnn gt To acquire the next stage you need to go to the Task menu and select Assigned under Standard option deeem E o T HE o 1 6 gt 2 I Seb Txn Ref No Title Assignee Group Amount Creation Date Priority Acquired 8 C RetaiLending1362 Document Verification ALLROLES ALLREAD 2010 06 29 20 13 10 IST Low bus
42. ber 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 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 information 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 1 38 ORACLE User Reference Number Specify the user reference number for the loan application Date Specify the date on which the application was entered or select the date by clicking the Calendar icon provided Purpose Specify the purpose for which the loan is availed Channel Specify the channel Id of the originating channel Intermediary Code Specify the identification code of the intermediary agency if the customer has been associated with any Offline Application Number Specify the offline application number if the loan application has been created using the offline facility You can also select the application number from the adjoining option list The li
43. by clicking Fields button against a row in the Applicant Details table The Customer UDF screen gets displayed where you can maintain the UDF details Customer UDF UDF Details You can specify the following details in this screen 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 1 16 3 2 Dedupe You can verify if the customer details are duplicated by clicking the Dedupe button Duplicate Customer List screen gets displayed where any duplicate customer details are displayed 1 40 ORACLE Duplicate Customers List Duplicate Customers List 10f1 a First Name Last Name Short Name National Id Customer Category Date of Birth 1 16 3 3 Loans You can view the existing loan for the customer by clicking the Loans button against the Applicant record Loan List Loan List 10f1 Loan Account Number Customer No Currency Amount Value Date Maturity Date Outstand 1 16 4 Details Tab The address and employment related details of the customer corresponding to the Lead Id selected are displayed in this tab You can modify these details if required 1 44 ORACLE Retail Loan Application Entry Workflow Reference Application Category Product Code Lead Id Enquiry ID Priority Priority Application Number User Reference Date
44. cation 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 1 14 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 1 29 ORACLE 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 Application Category Loan Type Category Description Rule Id Ratio Id Main Agency Product Details 108 GM 22222222 2 Offer Details 10f1 Offer Id No of Installments Units Rate Code Effective Rate Default Maker Date Time Mod No Checker Date Time Record Status 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
45. ches 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 Loan applications can also be captured in an offline mode at client sites by authorised users These can be subsequently brought into the main system and processed through the normal loan origination process 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 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 Override details e Document checklist an
46. d advices Application category details The Retail Loan origination process flow is composed of following stages Application Entry Application Verification e Underwriting e Loan Approval Document Verification Customer Customer Account Contract and Collateral Creation These features maintenances and the different stages in the process flow are explained in detail in the following sections 1 1 ORACLE 1 2 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 following details are captured as part of this maintenance e Prospective customer s personal and location details e Prospective customer s employment details e Requested loan details 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 Prospect Details Lead Id Description Reason Date of Enquiry Customer Details Requested 10f1 Im Sequence Number Salutation First Name Middle Name Nationalia L Short Name Country Passport Number Gender Nationality Passport Issue Date Date of Birth Language Passport Expiry Date Mothers Maiden Name Mobile Number Passport Issue P
47. derive the interest rate or select the rate code from the option list provided Spread Specify the spread that is applicable for the loan being offered 1 31 ORACLE Effective Rate The effective rate of interest gets displayed here based on the interest and the spread specified Default Check this box to indicate if the loan offer specified should be maintained as the default offer for the application category 1 14 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 Application Category Loan Type R Category Description Rule Id Ratio Id Main Agency Credit Agency 10f1 m Agency Code Agency Name Bureau Details 104 T Bureau Code Bureau Investigation Agency 104 Agency Code Agency Verification Type Maker Date Time Mod No Checker Date Time Record Status 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 1 32 ORACLE Specify the name of the rating agency that provides credit rating details for customer securities Bureau Details
48. diary Code Enquiry ID Purpose Status Priority Offline Application Number Customer Details Financials Requested Collaterals Credit Score Bureau LMC Eligibility Ratio Loan Schedule Charges Fields Investigation CheckList Comments Multiple Offers 10f1 No orinstanments unt Frequency Rate RateCode Spread chec Apply Loan Details Loan Currency Down Payment Amount No of Installments Loan Amount Value Date Unit Effective Rate Maturity Date Frequency CL Account Number Installment Start Date Prev Remarks Remarks Outcome The details related to the loan offer like the number of installments frequency unit interest rate etc are displayed here Select the required offer by clicking the Check option and click then click the Apply button to apply the selected loan offer The details corresponding to the selected loan offer are displayed in Loan Details section You can modify these details if required and click Apply button to calcualte the schedule details The payment schedules are derived based on the offer selected You can select only loan offer in this screen 1 16 18 Schedule Tab In Schedule tab the system calculates and displays the payment schedules and the schedule details based on the loan offer selected If you have selected an Enquiry ID for the customer then the schedule details
49. dicates the duration of the contract Branch Total This indicates the total number of records for the branch 2 5 ORACLE 2 5 Underwriting Status Month and Intermediary Report 2 5 1 This report lists application status by month and producer for loans You can invoke the Underwriting Status By Month and Intermediary Report screen by typing RLRPUNMI in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button Underwntng Status By Montn and intermediary Report Underwriting Status By Month and Intermediary Report Intermediary Code Branch From Date To Date 8 n Specify the following details Intermediary Code Specify the code of the intermediary for which you wish to generate the report You can also select the ID from the adjoining option list The list contains all the valid intermediaries maintained in the system Branch Specify the branch for which you wish to generate the report You can also select the branch from the adjoining option list The list contains all the valid branches maintained in the system From Date Specify from the adjoining calendar button the date from which you require details To Date Specify from the adjoining calendar button the date till which you require details Click OK button to generate the report Click Exit to return to the Reports Browser Content
50. e and or documentation shall be subject to license terms and license restrictions applicable to the programs No other rights are granted to the U S Government This software or hardware is developed for general use in a variety of information management applications It is not developed or intended for use in any inherently dangerous applications including applications that may create a risk of personal injury If you use this software or hardware in dangerous applications then you shall be responsible to take all appropriate failsafe backup redundancy and other measures to ensure its safe use Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications This 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 Th
51. e 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 REJECT to return the process 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 and click Acquire button at the top of the screen to acquire the next stage of the task The following message gets displayed on successful acquisition of the task Acquire Successful 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 Underwritin
52. e gets displayed on successful acquisition of the task Acquire Successful 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 to open Retail Loan Underwriting Stage screen 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 1 59 ORACLE Retail Loan Loan Stage x Application Category RETAIL_1 Application Number RetailLending1832 Branch Code 001 Product Code VVV1 User Reference 1832 VLO006 Channel Leadid 10 01 Date 2011 09 05 Intermediary Code Enquiry ID Purpose Status Customer Details Financials Requested Collaterals Credit Score LMC Eligibility Ratio Loan Schedule Charges Fields Investigation Check List Comments 1041 Credit Bureau Details Customerid Bureau Status Remarks Report External Credit Rating 4 10f1 gt Remarks External Agency Status Completed Score 500 Report Recommended Recommended mene roe Prev Remarks Remarks Audit Outcome PRO
53. ecifying 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 10f1 a 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 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 1 19 ORACLE Rule Maintenance Authorization Status Record Status gt Rule id Q Search Advanced Search Records per page 15 v Authorization Status Record Status You can specify any of the following details to search for a record e Authorization Status e Record Status e Click button to search for record based the search criteria specified You double click a desired record to view the detailed screen 1 20 ORACLE 1 8 Maintaining Credit Ratios You can maintain the rules to c
54. ed and saved the details for the loan applications you can transfer it into the database of the main system when you are connected to the network To do this you need to change the OffApplicationStatus to SYNCHRONIZE from the existing PENDING status and click the Synchronize button in the following screen 1 81 ORACLE Application Entry Synchronize Synchronization Synchronization 2 r Application Select Application No Product Code Customer No First Name Last Name Account No Offline App No Status RetailLending1001 vwv3 001001926 RON 00100192601 RetailLending1001 PENDING If the synchronization is successful the system will update the status in the OffApplicationStatus as SYNCHRONIZED and all the details will be populated in the database of the system from where you can view it by selecting the application number in the Retail Loan Application Entry screen The process followed thereafter will be the usual one followed for the loan origination If the synchronization is unsuccessful the system will update the status as PENDING 1 82 ORACLE 2 Reports 2 1 Introduction The following are the reports that you can generate in Retail Loan Origination module Prefunding Contract Report Funded Contract Report Credit Application By User Report Underwriting Status By Month and Intermediary Report Underwriting Status By Month and Underwriter Report Underwriting Stat
55. een 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 Step 2 Application Verification The information captured in the previous stage is verified in the Application Verification stage Application verification is carried out by the user role CMROLE 1 51 ORACLE Retail Loan Application Verification Stage EA Application Category Application Number Branch Code Product Code User Reference Number Channel Lead Id Date Intermediary Code Enquiry ID Purpose Status Priority Offline Application Number Customer Details Financials Requested Collaterals Comments Applicant Details 1011 Short Country Passport Number Gender Nationality Passport Issue Date Date of Birth Language Passport Expiry Date Mothers Maiden Name Mobile Number E mail Financial Currency Landline Number Dependents Customer Category Office Number Marital Status Account Number Fax Branch Code Account Class Loans Prev Remarks Remarks Audit Outcome details related to the loan application entry displayed this screen which verified by the verifier The details cannot be modified in this stage but comments can be added appropriately On completion of this stag
56. f 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 1 3 ORACLE 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 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 Mobile Number Specify the mobile phone number of the prospective customer Landline No Specify the land phone number of the prospective customer Office No Specify the office phone number of the prospective customer Fax Specify the fax number of the prospective customer Passport No Specify the passport number of the prospective 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 Passport Iss
57. f the task The following message gets displayed on successful acquisition of the task Acquire Successful 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 Any advices maintained for this stage are generated after the completion of the stage Step 5 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 Users belonging to user role CMROLE are authorized to perform these tasks Retail Loan Document Verification Stage Application Category Application Number Branch Code Product Code User Reference Number Channel Lead Id Date Intermediary Code Enquiry ID Purpose Status Priority Offline Application Number Customer Details Financials Requested Collaterals Credit Score Bureau LMC Eligibility Ratio
58. fy the Id of the user for which you wish to generate the report You can also select the ID from the adjoining option list The list contains all the valid users maintained in the system Branch Specify the branch for which you wish to generate the report You can also select the branch from the adjoining option list The list contains all the valid branches maintained in the system From Date Specify from the adjoining calendar button the date from which you require details To Date Specify from the adjoining calendar button the date till which you require details Click OK button to generate the report Click Exit to return to the Reports Browser Contents of the Report The contents of the report are discussed under the following heads Header The Header carries the Report Name Run Date and Time Branch User ID and the Period for which the report is generated Body of the Report The following details are displayed in the report Field Name Field Description Product This indicates the product for the contract Application No This indicates the loan application number Stage This indicates the stage for the application Application Date This indicates the date of the application Contract Date This indicates the contract date Contract Amount This indicates the contract amount Contract Interest This indicates the interest rate for the contract Contract Term This in
59. g screen 1 52 ORACLE Step 3 Underwriting In this 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 The tasks in underwriting stage are also carried out by the user role CMROLE 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 1 16 12 Capturing Liquidating Loans Details If a customer opts to liquidate his existing loans at the time of disbursal of a new loan to him you can maintain details of the loans to be liquidated in the Liquidate Loan Details screen You can access this screen by clicking the Liquidate Loan button in the Input Details screen Liquidate Loan Details Application Number CORPORATE LENDING Customer No 000000010 Liquidate Loan Details 1of1 l 000 24 000 1 56120610161
60. h the report is generated Body of the Report The following details are displayed in the report 2 9 ORACLE Field Field Description Product This indicates the product for the contract Application No This indicates the loan application number Stage This indicates the stage for the application Application Date This indicates the date of the application Contract Date This indicates the contract date Contract Amount This indicates the contract amount Contract Interest This indicates the interest rate for the contract Contract Term This indicates the duration of the contract Branch Total This indicates the total number of records for the branch 2 10 ORACLE 3 1 3 Function ID List Screen Glossary The following table lists the function id and the function description of the screens covered as part of this User Manual Function ID Function Description ORDCATMT Application Category Maintenance ORDDOOMT Documents and Advice Maintenance ORDLEADM Prospect Details ORDOVDMT Override Maintenance ORDRATMT Credit Ratio Maintenance ORDRLAPP Retail Loan Application Entry ORDRLSIM Retail Loan Simulation Details ORDRULMT Rule Maintenance ORSCATMT Category Details ORSDOOMT Document Details ORSLEADM Loan Prospect Details ORSOVDMT Ove
61. he adjoining arrow button Document amp Advice Maintenance Process Code Application Category Process Stages Stage Stage Document Details 1001 AME 8 Mandatory gt BI Advices 1041 POF en us Maker Date Time Mod No Checker Date Time 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 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 1 27 ORACLE Mandatory Select the
62. ication Category Application Number Branch Code Product Code User Reference Channel Lead ld Date Intermediary Code Enquiry ID Purpose Status Priority Lo Offline Application Number Customer Details Financials Requested Collaterals CreditScore Bureau LMC Eligibility Ratio Loan Schedule Charges Fields Investigation Check List Comments Invest 10f1 r rr na Prev Remarks Remarks Outcome The following details related to the customer can be captured here e Verification Type e Verification agency You can view the investigation report associated with the customer by clicking the Report button 1 70 ORACLE 1 16 22 Checklist Tab In this tab the system lists the checklists that are associated with the application category Retail Loan Underwriting Stage Workflow Reference Priority Application Category Application Number Branch Code Product Code User Reference Channel Lead Id Date Intermediary Code Enquiry ID Purpose Status Priority Lo Offline Application Number Customer Details Financials Requested Collaterals CreditScore Bureau LMC Eligibility Ratio Loan Schedule Charges Fields Investigation Check List Comments Check List 10f1 Prev Remarks Remarks Outcome The following details are displayed in this screen e Checklist Id Description Verified Check this box to indicate that checklist maintained has been verified for the customer Comment
63. is software or hardware and documentation may provide access to or information on content products and services from third parties Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third party content products and services Oracle Corporation and its affiliates will not be responsible for any loss costs or damages incurred due to your access to or use of third party content products or services
64. it rating rule Description Specify a suitable description for the credit rating rule Type Select the type of the loan from the following options available 1 15 ORACLE e Retail Corporate 1 6 1 Main Tab You can maintain the following details in this tab 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 1 16 ORACLE 1 6 2 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 Rule Maintenance Rule Id Type Retail Description Corporate Main Risk Factor Risk Factor 10f1 bef esc Bm Luz NNI Maker Date Time Mod No Checker Date Time 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 147 ORACLE 1 6 2 1 Specifying Formula Details
65. lace Customer Category Landline Number E mail Office Number Dependents Fax Marital Status 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 Reason Specify the reason for the loan enquiry Date of Enquiry Specify the date when the prospective customer has made the enquiry about the loan You can also select the date by clicking the adjoining Calendar icon 1 2 ORACLE 1 2 1 Customer Tab You can capture the following personal and geographical details related to a prospective customer Type Select the type of the customer from the drop down list provided The following options are available e Primary Co Applicant 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 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 National Id Specify the national Id or country code of the customer or select the national Id from the option list provided Short Name Specify the short name of the customer Gender Select the gender o
66. lication Priority Lo Number Customer Details Financials Requested Collaterals CreditScore Bureau LMC Eligibility Ratio Loan Schedule Charges Fields Investigation Check List Comments Details 10f1 Component Event Code Currency Amount Waive Prev Remarks Remarks Outcome The system calculates and displays the charge details associated with the loan The following details are displayed e Component Name Event Code e Associated currency Amount Waive Check this box to waive the charges associated with the loan 1 16 20 Fields Tab In this tab you can capture the user defined fields associated with the loan 1 68 ORACLE Retail Loan Underwriting Stage Workflow Reference Application Category Product Code Lead Id Enquiry ID Priority Customer Details Financials Priority Low Application Number User Reference Date Purpose Requested Collaterals Credit Score Bureau LMC Eligibility Ratio Loan Branch Code Channel Intermediary Code Status Offline Application Schedule Number Charges New Application Fields Investigation Check List Comments Prev Remarks Outcome 1 69 ORACLE 1 16 21 Investigation Tab In this tab the system captures the field investigation details associated with the customer Retail Loan Underwriting Stage Workflow Reference Priority Appl
67. ment verification stage Step 6 Customer Customer Account and Collateral Creation 1 17 In this final stage the loan and collateral are created Customer is also created if the applicant is a new customer Customer account is also created if information is captured for the same The system creates a Loan Customer and Collateral in Oracle FLEXCUBE with details captured from previous stages A user in manager level role handles this stage The creation of customer collateral and loan can be verified in STDCIF GEDCOLLT and CLDACCNT screens respectively Creating Offline Loan Applications Oracle FLEXCUBE facilitates the capturing of information for retail loans at the client site even when the client is not connected to the network This feature is designed using Oracle Lite 10g mobile network To use this facility the client is required to have Olite web application downloaded from an URL when connected over network from the server Snap shot of the required tables would be installed along with OC4J server to run the application standalone in the Laptop To enable authorized people to get access to the latest data for creating loans synchronization of data for banking parameters from the centralized database to the database of the client is done After the offline applications have been created and the mobile application is synchronized with the corporate database the applications are pushed into a queue created for applications origina
68. ntact Phone Occupation Address Line 3 Contact Name Designation Country Contact Extn Employee id Zip Comments Phone Number Department For details on this screen refer the corresponding tab in the Retail Loan Application Entry screen described earlier in this manual 1 78 ORACLE 1 20 1 3 Financials Tab You can capture the following details in this tab Income Details e Liability Details e Asset Details Asset Type e Asset Information for type Home e Asset Information for type Vehicle Application Details Application Category RETAIL 1 User Reference Number 1001 Product Code VVV3 Date 24 12 2010 m intermediary Code 000000010 v Leadid VEH_LD_01 v Purpose TESTING Status NEW APPLICATION Application Number 1001 Branch Code 001 Customer Detads Financials Requested Collaterals Comments Pa Income Details lication Income Type Frequency Entry SALARY MONTHY v Synchronization Liability Details Liability Types Liability Sub Type Frequency Amount Account Balance Start Date OTHERS wv LINEO1 MONTHLY 100000 24 12 2010 Asset Details Vehicle Asset Type Select Make Address Line 1 Asset Sub Type Model Address Line 2 Asset Description Manufacture Year Address Line 3 Asset Value Body Width Registration Number Length Occupancy For details on this screen refer the corresponding tab in the Retail Loan Applica
69. o return to the Reports Browser Contents of the Report The contents of the report are discussed under the following heads Header The Header carries the Report Name Run Date and Time Branch and the Period for which the report is generated 2 3 ORACLE Body of the report The following details are displayed in the report Field Name Field Description Product This indicates the product for the contract Application No This indicates the loan application number Stage This indicates the stage for the application Application Date This indicates the date of the application Contract Date This indicates the contract date Contract Amount This indicates the contract amount Contract Interest This indicates the interest rate for the contract Contract Term This indicates the duration of the contract Branch Total This indicates the total number of records for the branch 2 4 Credit Application By User Report This report lists out the number of credit applications entered by the user You can invoke the Credit Application By User screen by typing RLRPCAUR in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button Credit Application By User Number Of Credit Application By User Report User Id Branch From Date To Date Specify the following details 2 4 ORACLE 2 4 1 User ID Speci
70. ons Fraud Messages Inquiries Also Known s Consumer Statement Credit Scores Fraud Messages 1 62 ORACLE Inquiries Creditbureau Report Report Header Bureau Credit Report Id FirstName Report Dt MI Unique Id Last Name Onfile Dt Birth Dt Best Match Summary1 Summary2 TradeLines PublicRecords Collections FraudMessages Inquiries AlsoKnownAs ConsumerStatement Credit Scores Inquiries 10 Inquirer Inquirer Subscriber Inquirer Industry Code Inquiry Dt Rate Shopping Duplicate Also Known Creditbureau Report Report Header Bureau Credit Report Id First Name Report Dt MI Unique Id Last Name Onfile Dt Birth Dt Best Match Summary2 TradeLines Public Records Collections Fraud Messages Inquiries Also Known s Consumer Statement Credit Scores Also Known 5 10 First LastName 5 First Nai Consumer Statements Creditbureau Report Report Header Bureau 3 First Name i 2009 10 10 M 142234 LastName 2009 10 10 BirthDt 1976 10 02 Best Match Summary2 Trade Lines Public Records Collections Fraud Messages Inquiries Also Known Credit Scores I4 4 101 pl 1 63 ORACLE Credit Score Details Creditbureau Report Report Header Bureau FirstName MI LastName Birth Dt Public Records Summary
71. ount Contract Interest This indicates the interest rate for the contract Contract Term This indicates the duration of the contract Branch Total This indicates the total number of records for the branch 2 8 ORACLE 2 7 Underwriting Status Month Report 2 7 1 This report lists application status by the month for loans You can invoke the Underwriting Status By Month Report screen by typing RLRPUNMN in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button Underwriting Status By Month Report Underwriting Status By Month Report Branch From Date To Date Specify the following details Branch Specify the branch for which you wish to generate the report You can also select the branch from the adjoining option list The list contains all the valid branches maintained in the system From Date Specify from the adjoining calendar button the date from which you require details To Date Specify from the adjoining calendar button the date till which you require details Click OK button to generate the report Click Exit to return to the Reports Browser Contents of the Report The contents of the report are discussed under the following heads Header The Header carries the Report Name Run Date and Time Branch Intermediary Code Month for which report is being generated and the Period for whic
72. reation gt Advice Generation The various tasks carried out in these stages will be explained in detail in the subsequent sections 1 16 1 Process Flow Diagram The process flow diagram given below illustrates the activities carried out during the different stages of the workflow No B Application Entry Underwriting Document Verification Cancel ATN Reject Cancel Gc lt gt T Proceed Proceed fiujuct External Investigation agency Customer Creation Collateral Creation Loan Creation External External Credit gt Agency Valuation Any Pending Verification Any Pending Approvals Yes Application Verification Reject Application gt casia Legend Q Oracle Business Rules Terminate the Process 1 16 2 Process Matrix The process matrix given below lists out the different stages the user role handling each stage the function Ids involved and the exit points for each stage 1 35 ORACLE Stage Stage Title Description Roles Function Exit point 1 Application Entry The following details CEROLE ORDRLAPP PROCEED ac as part of CANCEL Application Details Applicant Details Requested Lending Details Collateral Details Check List User Defined Fields and Comments Document Capture Advice Generation 2 Application The details captu
73. red as CMROLE ORDRLVER PROCEED Verification 7 REJECT CANCEL 3 Underwriting The following details CMROLE ORDRLUND VERIFY E as part of PROCEED Collateral Valuation Information CANCEL Applicant Financial Ratios Applicant Credit Score Applicant Bureau Report Loan Offers Loan Schedules Loan Charges Field Investigation Dacumaent Canture 4 Loan Approval Loan Approval CMROLE ORDRLAPR PROCEED REJECT CANCEL 5 Document Document Verification CMROLE ORDRLDVR PROCEED Final Verification REJECT Customer Creation CANCEL 1 36 ORACLE Stage Stage Title Description Roles Function Exit point Loan Account Creation Advice Generation 6 Customer Loan The system task is N A N A Collateral Account used to create the Creation following Customer Collateral Loan The stages are explained in detail in the sections that follow 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 information requested loan details collateral details etc are captured during this stage Documents obtained from the applican
74. red 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 1 9 ORACLE 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 Retail Loan Simulation Details Retail Loan Simulation Application Category Date 2012 03 01 V 6 Customer Details FirstName Contact Number Customer No LastName Emaild Requested Rate Down Payment Amount Currency _ 5 Tenor Down Payment Requested Amount Multiple Offers Offer ld No of Installments Units Frequency Rate Code Spread v Monthly lt eres Noofinstalments Currency ValueDate Units Monthly LeanAmount Maturity Date Frequency Down Payment Amount Installment StartDate Account Number Effective Rate Date Time Mod Record Status Checker Date Time Authorization Status Cancel If details are available as part of the maintenance for the prospect in the Prospect Details screen
75. rospective customer Intrate Specify the preferred interest rate of the prospective customer Down payment 96 Specify the percentage of amount that the prospective customer can provide as down payment Down payment Amount Specify the preferred amount that the prospective customer can provide as down payment 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 1 8 ORACLE 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 Authorization Status Record Status M Lead Id Date Of Enquiry e Q Search Advanced Search Records per page Authorization Status Record Status Lead Id You can specify any of the following details to search for a record e Authorization Status Record Status e Lead ld e Date of Enquiry 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 1 4 Simulating Retail Loans You can simulate a loan proposal for a customer approaching the bank with enquiries about the loan products offered by the bank The following details would need to be captu
76. rride Maintenance ORSRATMT Credit Ratio Maintenance ORSRLSIM Retail Loan Simulation Summary ORSRULMT Rule Maintenance RLRPCAUR Credit Application By User RLRPFNCR Funded Contract RLRPPFCR Prefunding Contract RLRPUNMI Underwriting Status By Month and Intermediary Report RLRPUNMN Underwriting Status By Month Report RLRPUNMU Underwriting Status By Month and Underwriter Report 3 1 ORACLE ORACLE Retail Loan Origination April 2014 Version 11 3 83 02 0 Oracle Financial Services Software Limited Oracle Park Off Western Express Highway Goregaon East Mumbai Maharashira 400 063 India Worldwide Inquiries Phone 91 22 6718 3000 Fax 91 22 6718 3001 www oracle com financialservices Copyright 2005 2014 Oracle and or its affiliates All rights reserved Oracle and Java are registered trademarks of Oracle and or its affiliates Other names may be trademarks of their respective owners U S GOVERNMENT END USERS Oracle programs including any operating system integrated software any programs installed on the hardware and or documentation delivered to U S Government end users are commercial computer software pursuant to the applicable Federal Acquisition Regulation and agency specific supplemental regulations As such use duplication disclosure modification and adaptation of the programs including any operating system integrated software any programs installed on the hardwar
77. ry to which the document belongs or select the document category from the option list provided Document Reference Number Specify a unique reference number for the document being uploaded Document Type Specify the type of the document or select the document type from the option list provided Click Upload button to upload the documents View button to view the documents 1 49 ORACLE 1 16 10 Liquidating Loans You can liquidate the existing loan accounts of the customer using Liquidate Loans button Click Liquidate Loans button on the Corporate Loan Application Entry screen Loan accounts captured under Liquidate Loans screen are liquidated during disbursement of the current application 1 16 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 Make Model Type Manufacture Year Sub Type Description Body Asset ld Currency Validation Date Wholesale Base Retail Source Payment Amt Supplement Add ons Edition Total Transaction Value You can capture the asset details and the valuation details of the asset in this screen For more details on capturing Asset Valuation details refer the section titled Account Asset Valuation in Retail Lending user manual For more details on C
78. s Specify comments if any associated with the loan application 1 71 ORACLE 1 16 23 Comments Tab In this tab you can capture the comments by the users Retail Loan Underwriting Stage Workflow Reference Priority Application Category Application Number Branch Code Product Code User Reference Channel Lead ld Date Intermediary Code Enquiry ID Purpose Status Priority Offline Application Number Customer Details Financials Requested Collaterals CreditScore Bureau LMC Eligibility Ratio Loan Schedule Charges Fields Investigation Check List Comments Comments 10f1 UENIT commente oomme O Prev Remarks Remarks Outcome 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 REJECT 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 selec
79. s refer the chapter titled Maintaining Collateral Details in Enterprise Limits and Collateral Management user manual 1 16 8 Comments Tab In this tab you can specify comments if any related to the loan application Retail Loan Application Entry Workflow Reference Priority Application Category Application Number Branch Code Product Code User Reference Channel Lead Id Date Intermediary Code Enquiry ID Purpose Status Priority Offline Application Number Customer Details Financials Requested Collaterals Comments Comments 101 pe Prev Remarks Remarks Outcome You can specify the following details here Sequence Number The sequence number is automatically generated by the system 1 48 ORACLE 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 1 16 9 Capturing Document Details You can upload the scanned documents in Documents sub screen To invoke this screen click Documents button in Retail Loan Application Entry screen Main Advices Document Upload 10f1 mil Document Category DocumentReference DocumentType Upload SEE n upioad view You can capture the following details in this screen Document Category Specify the catego
80. s of the Report The contents of the report are discussed under the following heads 2 6 ORACLE Header The Header carries the Report Name Run Date and Time Branch Intermediary Code Month for which report is being generated and the Period for which the report is generated Body of the Report The following details are displayed in the report Field Name Field Description Product This indicates the product for the contract Application No This indicates the loan application number Stage This indicates the stage for the application Application Date This indicates the date of the application Contract Date This indicates the contract date Contract Amount This indicates the contract amount Contract Interest This indicates the interest rate for the contract Contract Term This indicates the duration of the contract 2 6 Underwriting Status By Month and Underwriter Report This report lists application status by month and underwriter for loans You can invoke the Underwriting Status By Month and Underwriter Report screen by typing RLRPUNMU in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button L2 Underwriting Status Month and Underwriter Report Underwriting Status By Month and Underwriter Report usera Branch Jaz From Date Date Specify the following details 2 7 OR
81. spective customer Contact Name Specify the name of a contact person at the customer s office Contact Phone Specify the contact phone number of the customer s contact person Contact Extn Specify the telephone extension number if any associated with contact person Comments Specify comments if any related to the customer s employment Department Specify the department to which the customer belongs Stated Years Specify the number of years the customer has spent with his current employer Stated Months Specify the number of months the customer has spent with his current employer 1 7 ORACLE 1 2 3 Requested 1 3 You can capture the details related to the requested loan in Requested Prospect Details was Lead Id Description Reason Date of Enquiry Customer Details Requested Loan Requested Interest Rate Currency Down Payment 96 Requested Amount Down Payment Amount EMI Amount Tenor In Months Maker Date Time Mod No Checker Date Time Record Status Authorization Status You can capture the following details here 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 EMI Amount Specify the preferred EMI amount of the prospective customer Tenor in months Specify the preferred loan tenor in months of the p
82. st contains all the application numbers for loan applications that have been created offline After specifying the loan number click the Sync button All the details for the selected offline application will be displayed in this screen You can modify the required details Status The status of the application gets displayed here Click Default button to default the details related corresponding to the prospective loan customer 1 16 3 Customer 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 Existing Check this box to indicate if the customer applying for the loan is an existing customer of the bank Customer No For existing customers you need to select the customer number from the option list provided Click Def button to default the details of existing customers 1 39 ORACLE Account Class Specify the account class or select the account class of the customer from the option list provided Account Number The account number gets generated when you click the P button after specifying the account class Financial Currency Specify the financial currency or select the financial currency from the option list provided 1 16 3 1 Fields You can capture the user defined field details for the customer if any
83. t 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 1 72 ORACLE The following message gets displayed on successful acquisition of the task Acquire Successful 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 4 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 Users belonging to user role CMROLE are authorized to perform these tasks Retail Loan Loan Approval Stage Application Category Application Number Product Code User Reference Number Lead Id Date Enquiry ID Purpose Priority Branch Code Channel Intermediary Code Status Offline Application Number Customer Details Financials Requested Collaterals CreditScore Bureau LMC Eligibilit
84. t are uploaded and advices maintained for the stage are generated by the process after completion of the stage Users belonging to user role CEROLE are authorized to perform these tasks 1 37 ORACLE 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 AD Application Category 28 Application Number RetailLending64 Branch Code Product Code E User Reference Number Channel 75 Lead Id 23 Date Intermediary Code 73 Enquiry ID Li Purpose Status Priority Low Offline Application LH Default Number Sync Customer Details Financials Requested Collaterals Comments Applicant Details 101 b hl Short Name Country Passport Number Gender Nationality Passport Issue Date Date of Birth Language Passport Expiry Date Mothers Maiden Name Mobile Number E mail Financial Currency Landline Number Dependents Customer Category Office Number Marital Status Account Number Fax Branch Code Account Class Liquidate Loans Prev Remarks Remarks Audit Outcome x Exit The Application Num
85. 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 Daily e Weekly e Monthly e Quarterly Half Yearly Yearly Frequency Specify the frequency at which the loan disbursement should be carried out Rate Specify the interest rate to be associated with the loan 1 12 ORACLE 1 4 2 Rate Code Specify the rate code used to derive the interest rate or select the rate code from the option list provided Spread Specify the spread that is applicable for the loan being offered Effective Rate The effective rate of interest gets displayed here based on the interest and the spread specified 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 Schedule 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 Schedule and the system will display the details of the payment and amortization schedules based on the loan details Retail Loan Simulation Details Retail Loan Simulation Application Category Date Enquiry
86. then after you specify the Application category Product Code and Customer Number 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 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 can also select it from the adjoining option list Branch Specify the branch code in which the loan will be processed You can also select it from the adjoining option list Customer Details Specify the following customer details 1 10 ORACLE 1 4 1 Customer No Specify a unique customer number for the prospect 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 You can enter the following details requested by the prospect Currency Specify the loan currency preference of the customer or select the currency from the option list provided
87. ting out of the offline application If any additional information is required this can be entered by the users within the Oracle FLEXCUBE system The validations required for the loans are done within the bank network when the network is online The offline application allows the capture 2 records of address employment details for both the primary and co applicants The process of creating the loan application is detailed below 1 75 ORACLE 1 18 Logging In A user can access the offline application by logging in to the mobile client application using the URL provided These users should be defined in Oracle FLEXCUBE and have access to download the application and enter the required details You can have multiple users accessing the application at a given point in time As a user you can specify the login details in the following Screen ORACLE DATABASE LITE 10g Mobile Workspac Logon Help Workspace User Name A29460M01 About Web to Go Password Logon Unauthorized use of this site is prohibited and be subject to and criminal prosecution Copyright 1997 2010 rights reserved 1 Specify the following details User Name Enter the user name provided to you This may or may not be a valid user maintained in Oracle FLEXCUBE Password Enter the password 1 76 ORACLE 1 19 Selecting the Application After you have entered the login details successfully all
88. tion Entry screen described earlier in this manual 1 20 1 4 Requested Tab You can capture the following details in this tab e Requested Loan Amount e Requested Currency for the Loan Requested Tenor Itemizations 1 79 ORACLE Retail Loan Application Entry Application Details Application Category RETAR 1 User Reference Number Product Code Date Leadid LD 01 v Purpose Application Number RetailLending1001 Breach Code Application Entry h Customer Details Financials Requested Collaterals Comments Synchronization Loan Requested Currency Interest Rate Requested Amount 10000 Downpayment Amount Tenor Months 12 Promotion Id Itemizations Itemization Requested Amount No rows yet Save Add Cancel 1001 Channel Ofline 24122010 intermediary Code 000000010 v TESTING Status NEW APPLICATION v 001 m Add Cancel 9 Remarks Add Cancel Comments For details on this screen refer the corresponding tab in the Retail Loan Application Entry screen described earlier in this manual 1 20 1 5 Collaterals Tab In this tab you can capture the following details e Collateral Code and description e Collateral Currency e Collateral Value Retail Loan Application Entry Application Details Application Category 1 User Reference Number Product Code WV3 Date Application Entry Leadid VEH LD 01 v Synchronization Application
89. tton to search for a record based on the search criteria specified You can double click a desired record to view the detailed screen Maintaining Override Details You can maintain the formulae to verify if overrides need to be generated dynamically in Override Maintenance screen 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 1 23 ORACLE Override Maintenance Process Code Retail Application Category Corporate Stage Description 10f1 Sequence Number Condition Error Code Error Parameter CE Elements Functions Braces Operators Logical Operators Maker Date Time Mod No Checker Date Time 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 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
90. ue Place Specify the place where the customer s passport was issued E mail Specify the e mail Id of the prospective customer Dependents Specify the number of dependents for the customer 1 4 ORACLE Marital Status Select the marital status of the prospective customer from the drop down list The following options are available Married e Unmarried Divorcee 1 2 2 Details Tab You can capture the address and employment related details of the prospective customer in Details tab Prospect Details Lead Id Description Reason Date of Enquiry Customer Details Requested Address Details Address Line 1 Contact Number Address Line 2 Zip Address Line 3 Country Sequence Number Address Type Mailing Employment Details Extension Address Line 2 Contact Address Line 3 Contact Name Zip Contact Phone Country Contact Extension Phone Number Address Line 1 Sequence Number Employment Type oyer a Employer Comments Occupation Designation Employee Id Department Stated Years Stated Months Maker Date Time Mod No Checker Date Time Record Status Authorization Status Address Details Seq No The sequence number is automatically generated by the system Address Type Select the address type of the customer from the following options provided in the drop down list e Permanent e Home Work e Temporary e Others Mailing Check this box to indicate that
91. unt 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 Home 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 specify 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 1 45 ORACLE Address Line 1 3 Specify the address of customer s residence in the three Address lines provided 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 1 16 6 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
92. us By Month 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 22 Prefunding Contract Report This report lists out all the applications verified for loans You can invoke the Prefunding Contract screen by typing RLRPPFCR in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button Prefunding Contracts Report Branch From Date ToDate Specify the following details Branch Specify the branch for which you wish to generate the report You can also select the branch from the adjoining option list The list contains all the valid branches maintained in the system From Date Specify from the adjoining calendar button the date from which you require details 24 ORACLE Date Specify from the adjoining calendar button the date till which you require details Click OK button to generate the report Click Exit to return to the Reports Browser 2 2 1 Contents of the Report The contents of the report are discussed under the following heads Header The Header carries the Report Name Run Date and Time Branch and the Period for which the report is generated Body of the report The following details are displayed in the report Field Name Field Description
93. wing Override Summary You can view a summary of the overrides in Override Maintenance screen You can also query for a particular record based on desired search criteria 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 Application Category Q Search Advanced Search Records per page Authorization Status Record Status Code Application Catd You can specify any of the following details to search for a record e Authorization Status Record Status Process Code Application Category Click Search button to search for a record based on the search criteria specified You double click a desired record to view the detailed screen Maintaining Document Checklist and Advices You can maintain the list of documents that are required during the loan origination process in Documents and Advice 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 1 26 ORACLE You can invoke Documents and Advice Maintenance screen typing ORDDOOCMT in the field at the top right corner of the Application tool bar and clicking t
94. y Ratio Loan Schedule Charges Fields Investigation Check List Comments Applicant Details 1of1 Short Name Country Gender e Nationality Date of Birth Language Mothers Maiden Name Mobile Number Financial Currency Landline Number Customer Category Office Number Account Number Fax Account Class Prev Remarks Remarks Outcome Passport Number Passport Issue Date Passport Expiry Date E mail Dependents Marital Status The approver can 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 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 1 73 ORACLE acquire the next stage you need to 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 o

Retail Loan Origination User Manual

Contents

Download Pdf Manuals

Related Search

Related Contents