Home

Retail Loan Origination User Manual

Contents

1. 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 5 ORACLE 2 5 Underwriting Status By 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 Retail loan underwriting status by intermediary report Intermediary Code Branch From Date To Date ReportFormat PDF v PrinterAt Client Report Output Print v Printer 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 calen
2. or P 1 23 ORACLE 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 1 6 3 Specifying Credit Grades You can maintain different credit grades based on the credit scores obtained Click Rating button in Rule Details screens to invoke the Rating screen where you can maintain these details Rating Rating 10 Sequence Number Score Grade 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 1 24 ORACLE 1 6 4 Specifying Auto Decision Details While creating a loan you need to decide whether the applicant is eligible to receive a loan from the bank Auto Decision feature in Oracle FLEXCUBE decides whether to approve or reject an application It also gives the stipulations or reasons for the decision To use this feature you need to maintain the Auto Decision details in Auto Decision screen Auto Decision 10f1 E Serial Number Score Credit Decision Specify the following details Serial Number The system displays the serial number Score Specify the maximum credit score of the loan applicant for the system to ma
3. Application Entry The following details are captured as part of this stage Application Details Applicant Details Requested Lending Details Collateral Details Check List User Defined Fields and Comments Document Capture Advice Generation ORDRLAPP PROCEED CANCEL Application Verification The details captured as part of Application Entry stage is verified Document Capture Stage Comments ORDRLVER PROCEED RETURN CANCEL Internal KYC The Customer will be verified for Internal KYC check and reviewed The following details are captured as part of this stage Document Capture Stage Comments ORDRLIKC PROCEED CANCEL External KYC The Customer will be verified for External KYC check and reviewed The following details are captured as part of this stage Document Capture Stage Comments ORDRLEKC PROCEED CANCEL 1 48 ORACLE Underwriting The following details are captured as part of this stage Collateral Valuation Information Applicant Financial Ratios Applicant Credit Score Applicant Bureau Report Loan Offers Loan Schedules Loan Charges Field Investigation Document Capture Advice Generation ORDRLUND RETURN PROCEED VERIFY CANCEL Loan Approval Loan Approval ORDRLAPR PROCEED CANCEL Document Verification The details captured as part of Underwriting stage is verified The following
4. Home Interactions Customer Workflow Tasks Preferences Tasks El Search ALL E Standard gt Acquired 0 gt Assigned 5 Completed 0 Pending 0 Supervisor 0 o alaoo a Workflow Reference IslamicijarahAccount1362 IslamicljarahAccount1574 IslamicljarahAccount1575 ImportLCProcessFlow1587 ImportLCProcessFlow1687 Transaction Reference Page 1 Of 1 Title Application Entry Application Entry Application Entry Receive and Verify LC Import Receive and Verify LC Import Change Branch Options Window Help Sign Off gt Jump to page Assignee Group ALLROLES ALLROLES ALLROLES ALLROLES CCSEROLE ALLROLES CCSEROLE Assignee Customer A Creation Date Users Name mou romo Maco 2012 04 30 11 14 27 IST 2012 05 10 15 16 46 IST 2012 05 10 15 40 50 IST 2012 05 11 12 11 04 IST 2012 05 16 19 55 53 IST 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 been successfully acquired are displayed in the right side
5. ORACLE 3 1 Function ID List 3 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 CSCDOCUP Documents ORDCATMT Application Category Maintenance ORDDOCMT Documents Verify Maintenance ORDLEADM Prospect Details ORDOVDMT Override Maintenance ORDPRCMT Pricing Details ORDRATMT Credit Ratio Maintenance ORDRLAPP Retail Loan Application Entry ORDRLDVR Retail Loan Document Verification ORDRLMCU Retail Loan Manual Retry Task ORDRLSIM Retail Loan Simulation Details ORDRLUND Retail Loan Underwriting ORDRULMT Rule Maintenance ORSCATMT Category Details ORSDOCMT Document Details ORSLEADM Loan Prospect Details ORSOVDMT Override Maintenance ORSPRCMT Pricing Summary ORSRATMT Credit Ratio Maintenance ORSRLSIM Retail Loan Simulation Summary 3 1 ORACLE Function ID Function Description 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 ORACLE ORACLE Retail Loan Origination December 2012 Version 12
6. 10H Ratios Stated Before Stated After Actual Before Actual After KYC Review Customer Dedupe Loan Dedupe Customer MIS Customer Account MIS Customer Account Fields Vehicle Evaluator Bureau Report Loan MIS Loan Fields Prev Remarks Remarks Audit The stated income and debt of the customer are displayed here You can capture the following additional details here 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 1 97 ORACLE 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 18 23 Loan Tab In the Loan tab the system displays the list of the multiple loan offers that are attached to the application category specified If you have selected an Enquiry ID for the customer then the loan details that have been stored for the corresponding loan proposal are displayed here You can modify these details
7. Application Branch 000 Application Status Underwriting Application Date 2012 03 05 Main Details Financial Requested Limit Collateral Credit Score Bureau Ratio Loan Component Charge Investigation Comments Comments jion D PEE E Serial No Comments Comment By Comment Date a 32474A01 E 2012 05 15 KYC Review Customer Dedupe Loan Dedupe Customer MIS Customer Account MIS Customer Account Fields Vehicle Evaluator Loan MIS Loan Fields Prev Remarks Remarks Audit You can capture the following details Comments Specify comments if any to be associated with the loan application Comment Type Specify the type of the comment given Comment Date Specify the date on which the comment was given or select the date by clicking the Calendar icon If the underwriting stage is successfully completed the underwriter can proceed with the processing of the application by selecting PROCEED as the Outcome The underwriter can select RETURN to return the process to previous stage for data correction or CANCEL to terminate the process On successful completion a message stating that the task is successfully completed gets displayed 1 107 ORACLE Step 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 ch
8. In Charges tab the system calculates and displays charges if any applicable gt Retell Loss Underwriting Seve Ll Hd Aggbcation Category ORG_RET_123 Appbcaton Number RetatLonging4375 Product Code BERT User Reference GLUSEAT 20550004 Desciston NomstBesrg91 Ss App canos Proy Low gt Application Branch 008 Dorast Acpicaton Stas ninio Apebcaton Dots 2012 03 05 Main Detads Firanoal Requested Limt Cotateral Credt Score Bureau Ratio Loan Comporent MN restos Comnart Mwave Dye De 2020005 A Arcourt Deo Amat Naved Conponert Karme HANDLING CHG 2 Componerl Cetrency GBP Etectwo Divo 20120345 Dacurenms Trade la KYC Rewew Customer Deduze Loan Dedupe Customer MIS Customer Account MS CuctorreriAcceunt Pelis Venice Evaluator Baross Report Lean MIS Loan hades Prev Ranas Aust The system calculates and displays the charge details associated with the loan The following details are displayed e Component Name e Event Code e Associated currency e Amount Component Name Specify the name of the component Component Currency Specify the component currency Effective Date Specify the effective date 1 104 ORACLE Waive Check this box to waive the charges associated with the loan 1 105 ORACLE 1 18 26 Investigation Tab In this tab the system captures the field investigation details associated with the customer Retail Loan Underwriting Transaction Branch Cod
9. in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button Documents BEB Advices Checkiist Document Upload a PSE Document Category Document Reference Document Type Remarks Upload y La el Las 2 ME Here you need to specify the following details Document Category Specify the category of the document to be uploaded Document Reference The system generates and displays a unique identifier for the document Document Type Specify the type of document that is to be uploaded 1 70 ORACLE Upload Click Upload button to open the Document Upload sub screen The Document Upload sub screen is displayed below Documents Main Advices Checklist N Document Upload E El Document Category Document Reference Document Type Remarks Upload 7 ID PROOF1 a3 E VoterlD A Document Upload Document Path Browse In the Document Upload sub screen specify the corresponding document path and click the Submit button Once the document is uploaded through the upload button the system displays the document reference number View Click View to view the document uploaded In Retail Loan Origination process Document Upload feature is not available in all the stages lts availability in this process is given
10. 1 74 ORACLE 1 18 16 Specifying Customer Account Fields You can capture the user defined field details for the customer and customer account if any by clicking Customer Account Fields button against a row in the Applicant Details table The User Defined Field screen gets displayed where you can maintain the UDF details User Defined Fields Application Number RetailLending5149 Customer Customer Account Customer Branch 007 Customer No 001 UDF Details J 10 DIN _ Field Name Value You can specify the following user defined field details for the customer in Customer Tab Name Specify the name of the UDF being created for the customer Value Specify the value associated with the UDF being created for the customer User Defined Fields Application Number RetailLending5149 Account Branch Account Number UDF Details 10f1 0 Field Name Value You can specify the following user defined field details for the customer account in Customer Account Tab 1 75 ORACLE Name Specify the name of the UDF being created for the customer account Value Specify the value associated with the UDF being created for the customer account 1 18 17 Viewing Vehicle Evaluator You can view the evaluated vehicle details captured as part of collateral details by clicking the Vehicle Evaluator button against the Applicant record
11. Assigned under Standard option All tasks that have been successfully completed are listed in the right side of the screen Select the checkbox against your Workflow Ref No and click Acquire button at the top of the screen to acquire the next stage of the task The 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 If you have checked the option Auto Decision Required during Application Entry stage the based on the applicant credit score auto decision mapping maintained in Auto Decision screen the system decides whether to approve the loan or not The system makes one of the following decisions in that case e Approved e Recommend Approval e Recommend Reject e Rejected If the auto decision made by the system is Recommend Approval or Recommend Reject you need to manually verify and confirm the decision at this stage If any price group is associated with the application category then the system will apply auto pricing after proceeding the Application Entr
12. Audit In this screen you can capture multiple address and employment details if required 1 56 ORACLE 1 18 5 Financials Tab You can capture the financial details corresponding to the customer in this screen Retail Loan Application Entry Transaction Branch Code Application Category Lead Id Application Number Product Code Enquiry ID User Reference Description Application Priority Low Application Branch Application Status Application Entry Application Date E Main Details MARBB Requested Limit Collateral Comments Income Details 10 Income Type Frequency Currency Amount Liability Details 10H E Liability Type Liability Sub Type Frequency Currency Amount Account Balance Start Date End Date Asset Details Vehicle Make Address Line 1 a Model Address Line 2 ETT al m1 Trade In Customer Dedupe Loan Dedupe Customer MIS Customer Account MIS Customer Account Fields Prev Remarks Remarks Audit Income Details You can capture the following details corresponding to the loan applicant s income Income Type Select the type of income associated with the customer from the drop down list provided The following options are available e Salary e Rent e Business e Others Currency Specify the currency in which the customer draws his income or select the currency from the option list provi
13. RLRPUNMU in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button Underwriting Status By Month and Underwriter Report Underwriting Status By Month and Underwriter Report User Branch From Date To Date ReportFormat PDF wv PrinterAt Client v Report Output Print v Printer Specify the following details 2 7 ORACLE 2 6 1 User 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 d
14. Specify a unique identifier for the credit risk being maintained Description Specify a suitable description for the credit risk 1 6 2 1 Specifying Formula Details You can specify the formula to calculate the credit score by clicking the Formula button corresponding to a credit risk entry in Risk Factor tab 1 22 ORACLE The Formula screen is displayed where you can specify the condition for calculating the credit score associated with a risk condition 4 Formula 1010 Sequence Number Condition Result 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
15. Transaction Branch Code 001 Application Category Lead Id Application Number Product Code Enquiry ID User Reference Description Application Priority Low X Application Branch Application Status Application Enty gt Application Date Main Details Financial Requested Limit EEBB Comments Collateral Details Start Date C Revaluate Collateral End Date Revaluation Date Collateral Category Revision Date Collateral Type Normal y Charge Type Linked Percent Utilization Order Linked Amount Commitment Product Haircut Collateral Branch Collateral Id Collateral Description Collateral Currency Collateral Value Market Value Based Haircut Schedule Vehicle Details Number Of Units Nominal Effective Date Haircut Vehicle ID Value eae Cap Amount Vehicle Number Year Make Guarantor Id Model Rating Body Usage Valuation Source None Guarantor Based Valuation Status Not Required Covenant Details 10H Covenant Name Description Reversal Date Mandatory Grace Days Due Date On Frequency Start Date Start Month Remarks m Documents Trade In Customer Dedupe Loan Dedupe Customer MIS Customer Account MIS Customer Account Fields Prev Remarks Remarks Audit 1 65 ORACLE Collateral Details Collateral Branch Specify the collateral Branch The adjoining option list displays all valid collateral branch codes maintained in the system
16. Chapter11 Chapter11 Chapter11 Chapter13 Chapter13 Chapter13 Total Total Total 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 Credit Bureau Report Application Number RetailLending4856 Customer No 000000103 Requested Id 1353 External Agency A1 Report Header Bureau Credit Report Id First Name Report Date MiddleName Unique Id Last Name On File Date Birth Date C Best Match Summary 1 Summary 2 Trade Lines Public Records Collections Fraud Messages Inquiries Also Known As Consumer Statement Credit Scores Life Recent Open Chapter Chapter Chapter Chapter11 Chapter11 Chapter11 Chapter13 Chapter13 Chapter13 Total Total Total 1 91 ORACLE Summary 2 Credit Bureau Report Application Number RetailLending4856 Requested Id Report Header Bureau First Name MiddleNam
17. First Name Specify the first name of the customer Middle Name Specify the middle name of the customer Last Name Specify the last name of the customer Salutation Select the salutation preference of the customer from the drop down list provided You can select any of the following options e Mr e Mrs e Miss e Dr Gender Select the gender of the customer from the drop down list Date of Birth Specify the date of birth of the customer or select the date by clicking the Calendar icon provided Mother s Maiden Name Specify the customer s mother s maiden name Marital Status Select the marital status of the prospective customer from the drop down list The following options are available 1 54 ORACLE e Married e Unmarried e Divorcee e Separated e Spouse Expired Dependents Specify the number of dependents for the customer SSN Specify the SSN of the customer Passport Number Specify the passport number of the customer Passport Issue Date Specify the date on which the customer s passport was issued or select the date from by clicking the adjoining Calendar icon Passport Expiry Date Specify the date on which the customer s passport expires or select the date from by clicking the adjoining Calendar icon Account Branch Specify the branch at which the loan applicant holds an account Select the appropriate branch code from the option list Account
18. Functions 7 Braces aa 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 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 28 ORACLE 1 9 Operators Select the mathematical operator to be used to define the credit ratio calculation formula You can select or f Viewing Credit Ratio Summary You can view a summary of the credit ratios in Credit Ratio Maintenance screen You can also query for a particular record based on desired search criteria You can invoke this screen by typing ORSRATMT in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button Credit Ratio Maintenance Authorization Status Group Id ai Advanced Search Records per page 15 w 1 Of 1 Aut
19. Select the actual number of days for the year from the adjoining drop down list You can select one of the following options e 360 e 365 e Actual Days in Month Select the number of days that would constitute a month for calculation from the adjoining drop down list You can select one of the following options e 30 euro e 30 US e Actual Verify Funds Check this box to indicate that verify of funds to be checked for the component Click on the Explode Schedule button to explode the component schedules Click on Disburse Details button to display disbursal schedule info for the selected component The following details related to the schedule are displayed here 1 101 ORACLE e Schedule Type e Schedule Flag e Formula e First due Date e Number of Schedules e Frequency e Units e Schedule Start Date e End Date e Amount For each component of the components listed the system calculates and displays the details like the Due Date Amount Due EMI Amount and Amortized Principal Using Explode schedules the schedule details can be recalculated 1 18 24 1 Maintaining Disbursal Details You can capture the Loan Disbursal schedules details in Disbursal screen You can invoke this screen by clicking Disbursement Details button Disbursals Application Number RetailLending3248 qa Component Name
20. Two ff Address Line 2 Contact Number Address Type EE Address Line 3 Country Current ployment Details Address Line 1 Extension Address Line 2 Contact Phone Employer Employment Type FUIT Address Line 3 Contact Name oy a Country Contact Extension Occupation Zip Department Designation Phone Number Comments Employee ld Maker TEST3 Checker TESTI Date Time 2012 03 05 17 12 15 Date Time 2012 03 05 17 12 15 Authorization Address Details Address Type Select the address type of the customer from the following options provided in the drop down list e Permanent e Home e Correspondence Address 1 5 ORACLE Mailing Check this box to indicate that the address you specify here is the customer s mailing address Address Line 1 3 Specify the address of the customer in three lines starting from Address Line 1 to Address Line 3 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 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 t
21. Vehicle Evaluator Application Number RetailLending3248 Vehicle Id BMVW12 Collateral Code O17ASTKVR14 fehicle Details Valuation Source Model Identification Number 12535 Body Year Usage Make fehicle Valuations Wholesale Value Attribute Value Retail Value Total Value Usage Value Vehicle Attributes 10f1 I Attribute Description Attribute Code Attribute Value Package Included Selected L ii After specifying the mandatory details in Application Entry screen select the Outcome that you wish in the lower portion of the screen To move to the next stage select PROCEED as the outcome and click the Save icon You can select CANCEL to terminate the process if required The following validations are carried out in this stage e f any of the mandatory documents are missing the system displays an error message e f any of the override documents are missing the system displays an override message e 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 The task is completed successfully The Workflow Reference Number is RetailLending lt nnnn gt 1 76 ORACLE To acquire the next stage you need to go to the Task menu and select Assigned under Standard option
22. if required fal Sava Ah Applicaton Category ORG_RET_123 Leachd Applicaton Numer RetatLensings243 2 4 Product Coda CLP Enquiry D User Retarenco DJOCLP 112095007 Description CL_PDC_TENOR_PAC KS Apebcat sn Priory Low ol pplicadon Branch 000 Apabcatico Stalis Underwriting Application Dak 2012 03 05 Defaut Nan Details Financial Requested Limi Cotateral Credit Score Euras Rato BY Compenect Cuarzo Investigator Comments Prin Preng a Muriple Otters were H58 Y Ofarid No ofinztaliments Frequency unt Rate Rate Code ek Apo yi teri S42 U von Te sz gt Loan Dorado Loan Branch 001 7 VaueDoe 2072 02 05 5 Noctinsisiments 12 Loan Arcourt Number ODICLP112312003 Mty Ose 2013 5 Frequency 1 Loan Cureny Gap 28 netamen Sat Dae 2 5 Unt mony y Loan Amount 70 000 00 Status Change Mode Em EGose Cobresal Effective Date User Dufined Esoreosr Valses htermadary 10n 5 108 rio i 108 e ll HM Efectivo Data WY aer Danos Esamest ld User OctsosSiomer CT intormosiary Cada intenmosiary Rato 5 y 20120305 ee 19 INTEREST_ZRATE DE eh YC Redew Cost Specify the following details Pricing ID System displays the default price in the pricing field You can select amp apply any one of the price available under a linked pricing group for the requested loan application among the available offers for the application category You can either proceed with the system selected offer or can select any
23. 6 MAINTAINING CREDIT RATING RULES cccccccccecececececesececesececececececececececececececesesaseessecesesessseuseesseenauseaes 1 20 1 6 1 MGI Tab ta a Sue eis ees a aan aa E eS 1 21 1 6 2 RISK FOCO TADA sd 1 22 1 6 3 Specifying Credit Grades omic sii acia sh atada alien depuis a enga desd sabe 1 24 1 6 4 Specifying Auto Decision Details init iaa ini e dep Hendon dai 1 25 1 7 VIEWING CREDITRULESUMMAR dies 1 26 1 8 MAINTAINING CREDIT RATOS iii 1 27 1 8 1 Specifying Formula Detalla id shee do eve aioe aes 1 28 1 9 VIEWING CREDIT RATIO SUMMARY cies 1 29 1 10 MAINTAINING OVERRIDE DETAIUS dais 1 30 1 11 VIEWING OVERRIDE SUMMARY dies 1 32 1 12 MAINTAINING DOCUMENT DETAILS cccccccccecececececsceseceeseseseseecsesesesesesesesceeseecececececececeeseececsesceeeeececess 1 32 1 13 VIEWING DOCUMENT CHECKLIST SUMMARY ccccssseseeecsceeeescecscseeesesescsesesesescececececsesceceeseseeeeeseseseeeeceeess 1 35 1 14 MAINTAINING APPLICATION CATEGORY DETAILS ccccccccecececececscecsescecscscececececscseseseseeeeeeeseseseeeeeeeeeess 1 36 DIAK MGI TAD cad etek Se sess ties oes nada ec Des seg Es CBS STS as i ete gee SES A eS Sahn 1 37 ISTE SA GCRCYELADY cock Bich eee dodo 1 38 1 15 VIEWING APPLICATION CATEGORY SUMMARY ccccccsssesecesececscecececeescsesesesceceseeseseseseseeeseseseseseseseeeececeeess 1 40 1 16 MAINTAINING PRICING DETAILS cccccccccecesececsescsesescsesesesesesesesesceceescseeeececececscecececece
24. 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 For the existing customer account you can select the account number from the adjoining option list 1 55 ORACLE 1 18 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 Retail Loan Application Entry Transaction Branch Code 001 Application Category Lead Id Application Number Product Code Enquiry ID User Reference Description Application Priority Low gt Application Branch Application Status Application Entry Application Date o o Main ABN Financial Requested Limit Collateral Comments Address Details Address Line 1 Country Address Line 2 Zip Address Type Permanent gt ress Type Permanent Address Line 3 Contact Number C Current Employment Details Address Line 1 Extension Empl m Address Line 2 Contact Phone mployer Address Line 3 Contact Name Employment Type Full Time X Country Contact Extension Zip Comments Designation Phone Number Department Employee Id Occupation Documents Trade In Customer Dedupe Loan Dedupe Customer MIS Customer Account MIS Customer Account Fields Prev Remarks Remarks
25. Customer No 000000103 External Agency A1 Credit Report Id Report Date Unique Id On File Date C Best Match Summary 1 Summary 2 Trade Lines Public Records Collections Fraud Messages inguiries Also Known As Consumer Statement Credit Scores Inquiries 4 1011 Inquirer Name vi Inquirer Subscriber Inquirer Industry Code Inquiry Date Rate Shopping Duplicate 1 93 ORACLE Also Known As Credit Bureau Report Application Number RetailLending4856 Customer No 000000103 Requested Id External Agency A1 Report Header Bureau Credit Report Id First Name Report Date MiddleName Unique Id Last Name On File Date Birth Date C Best Match Summary 1 Summary 2 Trade Lines Public Records Collections Fraud Messages Inquiries AASIMGMMIAE Consumer Statement Credit Scores Also Known As id d 10n DD First Name MI LastName Suffix Spouse First Name Consumer Statements Credit Bureau Report Application Number RetailLending4856 Customer No 000000103 Requested Id 1353 External Agency A1 Report Header Bureau Credit Report Id First Name Report Date MiddleName Unique Id Last Name On File Date Birth Date Best Match Summary 1 Summary 2 Trade Lines Public Records Collections Fraud Messages Inquiries SMIRNBMMIAE Consumer Statement Credit Scores Also Known As fd Y 107 gt hi First Name MI LastName
26. Details in Enterprise Limits and Collateral Management user manual 1 18 20 Credit Score Tab The credit score tab is used to calculate the credit score details of the customer You can also interface with external Credit engines and display recommendations and report Internal Credit engine obtains information from customer and calculates credit score and displays system recommendation Retail Loan Underwriting Transaction Branch Code 000 Application Category RETAIL_N Lead Id Application Number RetailLending4828 Product Code CLO2 Enquiry ID User Reference 000CLO212065000F Description NormalBearing Application Priority Low oe a Application Status Underwriting Application Date 2012 03 05 Applicant Details Type Primary y Local Branch 000 Customer No 000000103 Customer Name PAVIT address Main Details Financial Requested Limit Collateral OIEA Bureau Ratio Loan Component Charge Investigation Comments Internal Credit Rating Rule Id RRULE1 10 1 i EJ Grade E Category Question Answer Score Risk Factor Details 10f1 E Risk Factor Description Score m a KYC Review Customer Dedupe Loan Dedupe Customer MIS Customer Account MIS Customer Account Fields Vehicle Evaluator Loan MIS Loan Fields Prev Remarks Remarks Audit The set of questions used to assess the credit rating of a prospective loan customer associated Rule Id are displayed in this sc
27. PRINCIPAL Disbursals 10f1 OC E Schedule Date Total Disbursement Amount AmountToDisburse Already Disbursed Amount 2012 03 05 100000 100000 0 Split Details 10f1 Go He h SettlementAccountNumber Account Description Customer Settlement Currency Split Amount 0000000000009 a3 000005575 GBP ai 50 000 00 0010000001031 az 000000103 GBP ai 50 000 00 lt ill IS zj The following details related to the Loan Disbursal schedules can be captured here e Schedule Date e Total Disburse Amount e Amount to Disburse 1 102 ORACLE Already Disbursed Amount The following Disbursal Schedule s Split Details can be captured here 1 18 24 2 Split Sequence No Split Percentage Split Amount Payment Mode Settlement Branch Settlement Account Number Account Description Customer amp Settlement Currency Viewing Schedule Details You can view the modified schedule details Schedule details screen You can invoke this screen by clicking Schedule Details button Schedule Details Application Number RetailLending3248 QP Component Name PRINCIPAL Schedule Details 10f1 O Due Date Amount Settled Amount Due EMI amount Amortized Principal 4 2012 07 03 0 8333 33 E 2012 08 03 0 8333 33 E 2012 09 03 0 8333 33 E 2012 10 03 0 8333 33 0 2012 11 05 0 8333 33 Fj 2012 12 05 0 8333 33 Da all anna an 1 103 ORACLE 1 18 25 Charges Tab
28. Reportan ii pita 2 9 SCREEN GLOSSARY AAA O 3 1 3 1 FUNG TION TD DAS Ti A RG ii 3 1 1 1 1 2 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 approaches a prospective customer taking lead from its database In case of a bank initiated request the process moves forward only if the prospective customer is interested The entire process is carried out in multiple stages and on successful completion of each stage it moves automatically to the next stage When the customer approaches the bank for its products and offers before initiating the loan origination process the bank can create a mock proposal which would have the personal details of the customer the loan offers the customer is interested in as well as the schedules associated with the loan offer This can be stored as reference in the system to be retrieved when the actual loan process flow is initiated Retail lending process flow uses Oracle BPEL framework with multiple human tasks for workflow stages The capture and enrichment of information in multiple steps can be dynamically assigned to different user roles so that multiple users can take part in the transaction Oracle Business rules are used for dynamic creation of multiple approval stages The following details need to be maintained for originating a Retail Loan e Loan p
29. RetailLending5149 MIS Group zi Default From MIS Group Customer MIS Composite MIS Customer MIS Classes 10 gt DI MIS Class MIS Code Change Log Transfer Log Customer No 001 Local Branch Link to Group 1 18 15 Capturing Customer Account MIS You can capture the MIS details for the Customer Accounts in Customer Account MIS Screen by clicking Customer Account MIS button The Customer Account MIS screen gets displayed where you can maintain the MIS details Customer Account MIS Application Number RetailLending5149 Customer 001 Branch Code Account Account Class Currency GBP Transaction MIS Transaction MIS 1 Transaction MIS 2 basis MIS 3 Transaction MIS 4 Transaction MIS 5 Transaction MIS 6 Transaction MIS 7 Transaction MIS 8 m E jna ate ana ARRIA P Calc Method Rate Code Rate Type Reference Rate Spread Composite MIS Composite MIS 1 Composite MIS 2 Composite MIS 3 Composite MIS 4 Composite MIS 5 Composite MIS 6 Composite MIS 7 Composite MIS 8 Pool Code Account Level Pool Code E Link to Group Default MIS Group MIS Group Cost MIS Cost MIS 1 Cost MIS 2 Cost MIS 3 Cost MIS 4 Cost MIS 5 III aj Change Log Transfer Log
30. The system displays the following details SDN Status The system displays the SDN status Based on the records in Oracle FLEXCUBE the KYC SDN status can be one of the following e Passed e Failed e No Match SDN Remarks The system displays the SDN remark The SDN remark can be one of the following e Possible Match e No Match Click Ok to proceed to the next stage Click on the Review button to view the following screen KYC Review Application Number RetailLending3275 Customer No 001005697 KYC Review Details Local Branch KYC Extenal Status No Match First Name KYC Extenal Remarks No Match Middle Name SDN Status No Match Last Name o Date ofBith 1982 11 07 SDN Remarks No Match Country GB Nationality GB Based on the KYC and SDN statuses and remarks the reviewer decides whether to move the task to the next stage Click Review button to view all customer information and perform KYC and SDN checks The KYC Review Screen STSKYCMN and SDN Review Screens ORSSDNMN are displayed 1 83 ORACLE KYC Maintenance Summary Authorization Status Record Status KYC Reference Full Name of Customer KYC Customer Type Risk Level Records per page 15 10f1 m Authorization Status Record Status KYC Reference Full Name of Customer KYC Customer Type Risk Level 5 Alias
31. 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 32 ORACLE You can invoke Documents Verify Maintenance screen by typing ORDDOCMT in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button Document verify Maintenance Save M Hold Process Code Application Category Process Stages Stage Stage Document Details 10f1 Document Category Document Type Mandatory 73 a Mandatory Report Name Template Format Locale PDF Y en US v Checklist Details 10f1 Sequence Number Checklist Item Mandatory 1 la E Maker Date Time Mod No Checker Record Status Date Time Authorization Status You can specify the following details in this screen Process Code Specify the process code of the process for which you wish to maintain override conditions or select the process code from the option list provided Application Category Specify the category to which the loan application belongs or select the application category from the option list provided Stage Select the stage of the loan origination pr
32. below Stage Title Function Id Doc Callform Upload Available View Available Exists Not Available Not Available Application Entry ORDRLAPP Available Available Available Application Verification ORDRLVER Available Available Available Underwriting ORDRLUND Available Available Available Loan Approval ORDRLAPR Available Available Available Document Verification ORDRLDVR Available Available Available Customer Loan Collateral Account Creation 1 71 ORACLE 1 18 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 Trade in Details Application Number RetailLending5149 el Product Code Make Model Manufacture Year Body Type Sub Type Description Asset ld Source Wholesale Supplement Base Retail Edition Payment Amt Validation Date Additions Currency H Total Transaction Value You can capture the asset details and the valuation details of the asset in this screen Application Number Specify the application number Product Code Specify the loan product Currency Specify the trade asset currency For more details on capturing Asset Valuation details refer the section titled Account Asset Valuation in Retail Lending user manual For
33. can be done with details from an external agency in the collateral tab 1 18 19 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 Transaction Branch Code 000 Application Number RetailLending4828 User Reference 000CLO212065000F Application Priority Low Application Category RETAIL_N Lead Id Product Code CLO2 Enquiry ID Description NormalBearing Application Branch 000 Application Date 2012 03 05 Application Status Underwriting Applicant Details Type Primary y Local Branch 000 Customer No 000000103 Customer Name PAVIT address Main Details Financial Requested Limit EET Credit Score Bureau Ratio Loan Component Charge Investigation Comments Collateral Details Start Date Revaluate Collateral Collateral Branch Collateral Id Collateral Description Collateral Currency Collateral Value Market Value Based Security Id Number Of Units Nominal alue Cap Amount Guarantor Based Guarantor ld Rating Covenant Details End Date Revaluation Date Collateral Category Revision Date Collateral Type Normal X Charge Type Linked Percent Utilization Order Linked Amount Commitment Product Haircut Haircut Schedule Vehicle Details Effective Date Hai
34. can modify it in underwriting stage User Defined Element Values The system supports multiple User Defined Elements here based on the effective dates maintained UDE ld Select the User Defined Element Id from the adjoining option list Value Specify the UDE value Rate Code Select the rate code for UDE from the adjoining option list Code Usage Select the code usage from the adjoining drop down list Resolved Value The system defaults the system revised UDE value 1 99 ORACLE Intermediary System displays the intermediary details including the compensation percentage for each Intermediary based on the Inetrmediary code mainatined in Application Entry stage However you can modify it The payment schedules are derived based on the offer selected You can select only one loan offer in this screen 1 18 24 Component Tab In Component tab the system calculates and displays component name schedule type first due date number frequency units and amount details based on the loan offer selected If you have selected an Enquiry ID for the customer then the schedule details that have been stored for the corresponding loan proposal are displayed here You can modify them if required Retail Loan Underwriting Transaction Branch Code 000 Application Category RETAIL_N Lead Id Application Number RetailLending4828 Product Code CLO2 Enquiry ID User Reference 000CLO212065000F Description N
35. 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 Vehicle Evaluator Application Number RetailLending3248 Vehicle ld BMVWW12 Collateral Code 017ASTKVR14 ehicle Details Valuation Source Identification Number Year Make ehicle Valuations Wholesale Value Attribute Value Retail Value Total Value Usage Value Vehicle Attributes 10f1 C Attribute Description Attribute Code Attribute Value Package Included Selected L 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 1 87 ORACLE 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
36. clicking Loan MIS button in Retail Loan Underwriting screen The Loan MIS screen gets displayed where you can capture the details Loan mis Application Number RetailLending4856 al Product CLO2 Link To Group Loan Account Number Loan Branch 000 MIS Group Financing Currency GBP Input Link To Group Related Reference Related Account ag Rate Code Related Account Related Reference Spread MIS Head Rate At Interest Method Cost Code 1 Pool Code Reference Rate Cost Code 2 Contract Level Pool Code H Cost Code 3 o Cost Code 4 Cost Code 5 Transaction MIS Composite MIS Fund MIS MIS Group MIS Group MIS Group Transaction MIS 1 El Composite MIS 1 3 Fund MIS 1 Transaction MIS 2 Composite MIS 2 Fund MIS 2 Transaction MIS 3 Composite MIS 3 Fund MIS 3 Transaction MIS 4 La3 Composite MIS 4 Fund MIS 4 Transaction MIS 5 a3 Composite MIS 5 73 Fund MIS 5 Transaction MIS 6 Las Composite MIS 6 El Fund MIS 6 Transaction MIS 7 pi Composite MIS 7 3 Fund MIS 7 Transaction MIS 8 Composite MIS 8 23 Fund MIS 8 Transaction MIS 9 a3 Composite MIS 9 a Fund MIS 9 1 18 21 3 Capturing Loan UDF Details You can capture the Loan UDF details by clicking Loan Fields button in Retail Loan Underwriting screen You can also invoke this screen by typing ORCLNUDF in the field at the top right c
37. groups applicable Choose the appropriate one 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 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 Offer Details You can capture the additional details related to the loan product here Offer Id Specify a unique identification for the loan offer being made to the customer No of Installments Specify the number of instalments associated with the loan Units Select the units based on which the loan disbursement should be carried out The following options are available in the option list e Daily e Weekly e Monthly e Quarterly e Half Yearly e Yearly 1 37 ORACLE 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 derive the interest rate or select the rate code from the option list provided Default Check this box to ind
38. gt Documents gt Advice Generation e Application Verification 1 45 ORACLE gt Information captured during Application Entry stage is verified gt Advice Generation e Internal KYC e External KYC e Underwriting gt Collateral Vehicle 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 e Loan Approval gt Information captured during Previous stages are verified gt Advice Generation e Document Verification gt Information captured during Previous stages are verified gt All documents obtained are verified against checklist gt Advice Generation e Manual Retry The various tasks carried out in these stages will be explained in detail in the subsequent sections 1 46 ORACLE 1 18 1 Process Flow Diagram The process flow diagram given below illustrates the activities carried out during the different stages of the workflow ir 2 gt agame im an rary ute AR eso e y E Kre tersa hm e cio ai Serene mom Prot igoma were aha 1 47 ORACLE 1 18 2 Process Matrix The process matrix given below lists out the different stages the function Ids involved and the exit points for each stage Stage Stage Title Description Function Id Stage Outcome
39. month for calculation from the adjoining drop down list You can select one of the following options e 30 euro e 30 US e Actual After the loan application has been created in the system if you select the Enquiry ID specified here the system will default the requested details for the offer selected here in the Retail Loan Application Entry screen in the Requested tab You can only view the details in the screen At the Underwriting stage the system will default the loan details which you can modify in the Loan tab of the Retail Loan Underwriting Stage screen Viewing Disbursal Details You can view the disburse details on Disbursal screen To invoke this screen click Disburse Details button in the Components tab of the Retail Loan Simulation Details screen Disbursals x Application Number RetailLending3248 QP Component Name PRINCIPAL a Disbursals 10f1 E M Schedule Date Total Disbursement Amount Amount To Disburse Already Disbursed Amount 7 2012 03 05 100000 100000 0 Split Details 1011 el Oo Split Sequence No Split Percent Payment Mode Settlement Branch Settlement Account Number O 1 50 ACC 000 a 0000000000009 a M 2 50 ACC 001 a3 0010000001031 23 lt gt ok cancel This screen displays the disbursal details 1 17 ORACLE 1 4 4 Viewing Sched
40. of the screen Search for your workflow reference number and click the Workflow Ref No to open Retail Loan Application Verification screen 1 77 ORACLE Step 2 Application Verification The information captured in the previous stage is verified in the Application Verification stage Retail Loan Application Verification El Save A Hola Applicat RETAIL_1 Leadid CLO2 Enquiry ID NormalBearing Applic 001 Application Date 2012 11 07 er RetailLending5140 001CL0212312003 Maio Details Financial Requested Limit Collateral Comments Channel KYC External Credit Check Required Intermediary Group 1 Applicant Details 10 Y Type Existing Local Branch CustomerNo Default Short Name Customer Name National ld Responsibility y Prima 001 001005698 EE 091 Logu ndia Marital Status Ma nts The details related to the loan application entry are displayed in this screen which can be verified by the verifier The details cannot be modified in this stage but comments can be added appropriately On completion of this stage the advices that are maintained for the stage are generated The verifier can either send the application back to the previous stage if the information provided is not adequate or can cancel it if the information captured is not satisfactory If the application details are verified successfully the verifier can proceed with the processing of the applica
41. 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 Outcome till the verification has been successfully done The system will display a message stating that the task is successfully completed on saving the record To acquire the next stage you need to go to the Task menu and select Assigned under Standard option All tasks that have been successfully completed are listed in the right side of the screen Select the checkbox against your Workflow Ref No and click Acquire button at the top of the screen to acquire the next stage of the task The 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
42. the customer No of Instalments Specify the number of instalments associated with the loan Frequency Specify the frequency at which the loan disbursement should be carried out Units Select the units based on which the loan disbursement should be carried out The following options are available in the option list e Daily e Weekly e Monthly 1 13 ORACLE e Quarterly e Half Yearly e Yearly Rate Specify the interest rate to be associated with the loan Rate Code Specify the rate code used to derive the interest rate or select the rate code from the option list provided Check Select the required offer by clicking the Check option and click the Apply button The system will default all the details in the Loan Details pane When you click the Apply button available in the lower pane in Loan Details the system will populate the schedule details for the offer you have selected Financing Details After applying the requested offer or on applying the loan without selecting the offer you need to specify the following financing details Loan Branch The system displays the branch code of the branch at which the loan enquiry was made Loan Account Number The system displays the loan account number Financing Currency The system displays the requested loan currency Financing Amount The system displays the requested loan amount Value Date Specify the date on which the lo
43. 0 1 0 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 O 2007 2012 Oracle and or its affiliates All rights reserved Oracle and Java are registered trademarks of Oracle and or its affiliates Other names may be trademarks of their respective owners U S GOVERNMENT END USERS Oracle programs including any operating system integrated software any programs installed on the hardware and or documentation delivered to U S Government end users are commercial computer software pursuant to the applicable Federal Acquisition Regulation and agency specific supplemental regulations As such use duplication disclosure modification and adaptation of the programs including any operating system integrated software any programs installed on the hardware and or documentation shall be subject to license terms and license restrictions applicable to the programs No other rights are granted to the U S Government This software or hardware is developed for general use in a variety of information management applications It is not developed or intended for use in any inherently dangerous applications including applications that may create a risk of personal injury If you use this software or hardware in dangerous applications then you sh
44. D E Description Price Type Advanced Search Records per page 45 X 1 Of 1 a Authorization Status Record Status Price Group ID Description Price Type In this screen you can base your queries by providing any or all of the following criteria e Application Status e Price Group ID e Price Type e Record Status e Description Based on the details provided system displays the following details e Authorization Status e Record Status e Price Group ID e Description e Price Type 1 42 ORACLE 1 17 1 Maintaining Pricing Formula Click Formula button to define the pricing rule for each price ID You can define the formula using origination system elements in Oracle FLEXCUBE Formula Maintenance 10f1 7 Sequence Number Condition Y 1 Elements Index Functions Braces Operators Logical Operators Sequence Number Specify the sequence number Condition Specify the possible data or the data limits here The supported operators are Operator Description Equals To gt Greater Than gt Greater Than or Equals To lt Less Than lt Less Than or Equals To Score Specify the score for each condition Elements Select the element from the adjoining option list If the loan requested details satisfies the condition specified in the pricing maintenance then the correspon
45. Names Summary Name Date of Birth amp Country Records per page 15 I4 Name Date of Birth Country Once reviewed the verifier provides the review status and remarks You can perform a check on the customer record based on the KYC Review and SDN Review screens and choose the external KYC status and SDN status respectively based on the review 1 84 ORACLE Step 5 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 You can also invoke Retail Loan Underwriting screen by typing ORDRLUND in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button 1 18 18 Main Tab System defaults the customer details provided in the Application Entry stage here However you can modify it After ascertaining the eligibility of the customer the bank provides multiple loan offers for the borrower and uses one offer chosen by the customer to generate payment schedule and schedule details The advices that are maintained for the stage are generated on completion of the stage In this stage the bank also conducts vehicle evaluation based on the details that have been captured at the Application Entry stage This evaluation
46. Retail Loan Origination Oracle FLEXCUBE Universal Banking Release 12 0 1 0 0 December 2012 Oracle Part Number E51465 01 ORACLE FINANCIAL SERVICES ORACLE Retail Loan Origination 1 Table of Contents RETAIL LOAN ORIGINATION ecssssssscosisssescesscsvscosssivescssctacooscctecssbentecssdssioossescsesessessosssvecsssesstvivsesscoscessonss 1 1 1 1 INTRODUCTION oe cec2d dessa eee ER ee I EEE EE ER A 1 1 1 2 MAINTAINING LOAN PROSPECT DETAILS ccoccccncncncnonononononononononononononononononononononononononononononnnnnonononononininininens 1 1 1 2 1 Customer FAD iii ri A Ma Penh EE A eth A ost Ate ek oe ad sesh dos ds 1 2 1 2 2 DEG TaD asicd Bs aR trate sed eae A ses ed Seth Ae Bose A coe A ness A et ees y 1 5 1 2 3 Requested Tab ini AD A dd ds tE 1 8 1 3 VIEWING LOAN PROSPECT SUMMARY oocococcccncncnoncnononononononononononononononononononnnnnnnononononononononnnnnnnnnononononininininens 1 9 1 4 SIMULATING RETA IG L OANS i seh secelccten eee DS 1 9 1 4 1 BOON LGD Sr SI Sates A aac NN AS esi ate te oth Asstt A ties dia 1 13 1 4 2 Component TAD DA A A dt A 1 16 1 4 3 Viewing Disbursal Details ooooncnncnininoninononanonanonononnnnnn nono cono cono aE EE ENE E euE aai 1 17 1 4 4 Viewing Schedule Details isc 2 isss sesichestcacagintdeccessnestgousnscdiosh ii doi 1 18 1 5 VIEWING SIMULATED LOAN DETAILS ccccccccnnnnnnnnnnonononononononononononononononnnnnnnononononononononononononononononenonenenenesos 1 19 1
47. Select the appropriate one Utilization Order Specify the collateral utilization order if any collaterals are linked to the Loan Commitment Product Specify the commitment product if any collaterals are linked to the Loan If you click on the Default button system defaults the existing collateral details based on the collateral code provided Linked Percentage Specify the linked percentage of the collateral amount to be linked to the pool in pool details and collateral contribution in facility details Linked Amount Specify the Linked amount based on the linked percentage Haircut Specify the collateral haircut percentage for evaluating the collateral amount Utilization Order Specify the collateral utilization order Commitment Product Specify the commitment product associated with the collateral For more details on capturing Collateral details refer the chapter titled Maintaining Collateral Details in Enterprise Limits and Collateral Management user manual Market Value Based Security ID Select the security id from the option list Number of units Nominal value Specify the number of units Cap Amount Specify the cap amount 1 66 ORACLE Guarantor Based Guarantor ID Select the Guarantor Id from the option list Rating The system displays the rating Haircut Schedules Specify the following Haircut Revision Schedule details for any collateral linked to the Loan E
48. Short Name Customer Name Nationalld Responsibility Liability RM ID Country First Name SSN Nationality Middle Name Passport Number Language Last Name Passport Issue Date Customer Category Salutation Mr Passport Expiry Date Financial Currency Gender Male Group Code Date of Birth Mobile Number Landline Number Account Details Account Branch Mothers Maiden Name Marital Status Married Account Number Dependents Defauit Account Class Email Fax KYC Review Customer Dedupe Loan Dedupe Customer MIS Customer Account MIS Customer Account Fields Vehicle Evaluator Bureau Report Loan MIS Loan Fields Prev Remarks Remarks Audit The verifier can choose to send the application back to the previous stage if the information provided is not adequate or choose to cancel it if the information captured is not satisfactory If the applicant application and document details are verified successfully the verifier can proceed with the processing of the application by selecting PROCEED as the Outcome The verifier can select RETURN to return the process to underwriting stage for data correction or CANCEL to terminate the process On successful completion a message stating that the task is successfully completed gets displayed The customer customer account collateral etc are created in the system on completion of the Document verification stage Step 8 Manual Retry Manual Ret
49. Suffix Spouse First Name Credit Score Details Credit Bureau Report Application Number RetailLending4856 Customer No 000000103 Requested Id 1353 External Agency A1 Report Header Bureau Credit Report Id First Name Report Date MiddleName Unique Id Last Name On File Date Birth Date Best Match Summary 1 Summary 2 Trade Lines Public Records Collections Fraud Messages Inquiries Also Known As Consumer Statement Credit Scores Credit Scores Score Model Score Factor Score 1 94 ORACLE 1 18 21 1 Viewing Credit Bureau Report You can view the credit bureau report by the external agency by clicking Bureau Report button in Retail Loan Underwriting screen The Credit Bureau Report screen gets displayed where you can view the details Credit Bureau Report Application Number RetailLending3248 Customer No 000000330 Requested Id 403 External Agency 123 Report Header Bureau Credit Report ld First Name Report Date MiddleName Unique Id Last Name On File Date Birth Date Best Match EUA Summary 2 Trade Lines Public Records Collections Fraud Messages Inquiries Also Known As Consumer Statement Credit Scores Life Recent Open Chapter Chapter Chapter Chapter11 Chapter11 Chapter11 Chapter13 Chapter13 Chapter13 Total Total Total 1 18 21 2 Capturing Loan MIS Details You can capture the Loan MIS details by
50. YC Review Details Local Branch 001 KYC Internal Status No Match First Name dl KYC intemal Remarks No Match Middle Name ld SON Status No Mat Last Name le Date of Birth 1982 03 01 SON Remarks No Match Country GB Review Nationality GB The system displays the following details e Local branch code e First name of the customer e Middle name of the customer e Last name of the customer e Date of birth of the customer e Country of the customer e Nationality of the customer KYC Internal Status The system displays the internal KYC status Based on the records in Oracle FLEXCUBE the KYC internal status can be one of the following e Passed e Failed e No Match KYC Internal Remarks The system displays the internal KYC remark The internal remark can be one of the following e Possible Match e No Match Click Review button to check the customer details against the blacklisted customers list The system displays the following details 1 79 ORACLE SDN Status The system displays the SDN status Based on the records in Oracle FLEXCUBE the KYC SDN status can be one of the following e Passed e Failed e No Match SDN Remarks The system displays the SDN remark The SDN remark can be one of the following e Possible Match e No Match Click Ok to proceed to the next stage Click on the Review button to view the following screen KYC Review Application Number RetailLending3275 Cus
51. ads 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 Branch This is the branch code Product This indicates the product for the contract Application Number 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 Currency This is the currency of the contract 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 ReportFormat PDF wv PrinterAt Client v Report Output Print v Printer Specify the
52. aintenance 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 Credit Ratio Maintenance Group Id Description Type Retail Ratio Id dion di Ratio Id Formula Maker Date Time 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 Specify the type of the loan You can choose one of the following loan types e Retail e Corporate Ratio Id Specify a unique identification for the credit ratio being maintained Description Specify a suitable description for the credit ratio 1 27 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 101 E El Ratio Type Condition S Stated Before x ST_MON_DEBT ST Stated After x ST_MON_DEBT gt P Actual Before y ACT_MON_DEBT VG C EJ Actual Afer x ACT_MON_DEBT C Elements EE Index
53. all be responsible to take all appropriate failsafe backup redundancy and other measures to ensure its safe use Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws Except as expressly permitted in your license agreement or allowed by law you may not use copy reproduce translate broadcast modify license transmit distribute exhibit perform publish or display any part in any form or by any means Reverse engineering disassembly or decompilation of this software unless required by law for interoperability is prohibited The information contained herein is subject to change without notice and is not warranted to be error free If you find any errors please report them to us in writing This software or hardware and documentation may provide access to or information on content products and services from third parties Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third party content products and services Oracle Corporation and 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
54. an was initiated Maturity Date Specify the maturity date of the loan Instalment Start Date Specify the date on which the first instalment falls due Status Change Mode Specify the status change mode of the loan The status change mode can be one of the following e Auto 1 14 ORACLE e Manual No of Installments Specify the total number of instalments Frequency Specify the frequency of the loan Unit Specify the unit of the frequency The unit can be one of the following e Daily e Weekly e Monthly e Quarterly e Half Yearly e Yearly e Bullet Effective Date Specify the following details Effective Date Specify the effective date of the loan User Defined Element Values Specify the following details User Defined Element ID Specify the user defined element ID User Defined Element Value Specify the value of the user defined element ID Rate Code Specify the rate code to be used for the user defined element Code Usage Select the code usage from the drop down list ORACLE 1 4 2 Resolved Component Tab After the loan details have been displayed by the system or modified as per your requirements click Apply The system will process these details Click Component and the system will display the details of the payment and amortization schedules based on the loan details gt Retail Loan Simulation Details New Of Copy X Delete fal Unlock y Print amp Au
55. athematical 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 gt lt AND or OR 1 31 ORACLE 1 11 Viewing 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 E Application Category Advanced Search Records per page 15 Mm TO Authorization Status Record Status Process Code Application Category You can specify any of the following details to search for a record e Authorization Status e Record Status e Process Code e Application Category Click Search button to search for a record based on the search criteria specified You can double click a desired record to view the detailed screen 1 12 Maintaining Document Details You can maintain the list of documents that are required during the loan origination process in Documents Verify Maintenance screen Document checklists
56. ber Type Short Name Customer Name National ld Responsibility Liability Y 4 Primary Uday Borrower 50 2 CoApplicant jeevit Co Borrower X 50 Country IN First Name SSN Nationality IN Middle Name Passport Number Language ENG Last Name Passport issue Date Customer Category INDIVIDUAL Salutation Mr Passpon Expiry Date Financial Currency GBP Gender Male Mobile Number Date of Birth 1985 03 01 Landline Number Mothers Maiden Name Emaa Mamal Status Married Fa Dependents Maker TEST3 215 Mod No 1 Checker TEST3 Date Time 2012 03 05 17 1215 Date Time 2012 03 05 17 Record Status Open Authorization Status Aul 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 Customer Tab You can capture the following personal and geographical details related to a prospective customer 1 2 ORACLE Type Select the type of the customer from the drop down list provided The following options are available e Primary e Co Applicant Salutation Select the salutation preference of the customer from the drop down list provi
57. box to indicate whether the checklist is mandatory or optional 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 ai Application Category Search Advanced Search Records per page 15 v Authorization Status Record Status Process Code Application Category You can specify any of the following details to search for a record e Authorization Status e Record Status e Process Code e Application Category Click Search button to search for a record based on the search criteria specified You can double click a desired record to view the detailed screen 1 35 ORACLE 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 You can invoke Application Category Maintenance screen by typing ORDCATMT in the field at the top right corn
58. cify the following details in this screen Rule Id Specify a unique identification for the credit rating rule Account Description Specify a suitable description for the credit rating rule 1 20 ORACLE 1 6 1 Type Select the type of the loan from the following options available e Retail e Corporate 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 21 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 Details al Save lt i Hold Rule Id Account Description Main ME Risk Factor id 4 10 D hi Risk Id Account Description Formula Type Retail Maker Checker Mod No Date Time Date Time Record Status Authorization Status You can specify the following details here Risk Id
59. cseeeececseseecseeeecececs 1 40 1 17 NIEWING PRICING DETATUS 5 ss secscaeesosddgaeveuscavessisaueveuacuyesvei teas venscavens Giese ecg a ieee eaten eee 1 42 LAP A Maintaining Pricing FOrm l A a iii 1 43 LAZ2 Maintaining Preng Oller pin aga teas at vtec eee hace Ween TAT EG 1 44 1 18 STAGES IN RETAIL LOAN ORIGINATION ccccccccececeeeeeeecececscsescscsescscseseseseseeceeseecseseseseseseseseeeeeseseeeeeecess 1 45 LISD Process FLOW Diagramaren ia os 1 47 TAB 2 1 AA 121A A 2 EARE AENEA EE AE ia riadas 1 48 STEP 1 APPLICA TON ENTRAR e it faa dt a vat 1 50 BE o PO EE 17 191 5 105 We PERAE A RS RRO ANA T AEE 1 51 LEER DEUSTO AAEE A AA E AE A 1 56 LLSD Emancidl Tia Disses sited hese th E A EE EEA A E E A EA 1 57 I 18 6 Requested Tab AAA ceases aoeeoe es raea ig E OE EEEn EEEE EEE EE RE EERE TE EE EES Nea 1 61 GAS Ee STARE Bd LTS 0 AA EA A AES E A AE Re ASE E AAEN 1 63 1 18 8 CEollaterals Tab A E E A EE ENE E AE E EA 1 65 1 18 9 Comments Tab As EEEE E ANEA AE S EEA de od E EN 1 69 1 18 10 Capturing Document Details vn sccceicsssveccascsssdissetvnoss seteessasesbiesaseases iaaedtossasuaaessbeesbbecasecsebeasnebeesss 1 70 1 18 11 Capiuring Trade In Details sive cssccsegsascsvecsasssaatiactsnesssetseg indian tareas seise TE eiat oba EEES iaa 1 72 1 18 12 Verifying Customer Dedupe ovcscssccsezcisssiectascsssaivaetinocs sadeegsasedbigsaceases tanes essasuasesabeesbbecasecsebeascsbeerss 1 72 1 18 13 Verifying Loan Dedup
60. d be associated with the applicant salary account Purpose Specify the Purpose of the loan Loan Itemization Details Serial Number Specify the serial number ltemization Specify the tenor itemization that is required For example you can specify the itemizations like Booking Amount Payment Interiors etc Requested Amount Specify the amount requested corresponding to the itemization specified Comments Specify comments if any corresponding to the itemization 1 62 ORACLE 1 18 7 Limit Tab You can capture the liability details pool details and line details in this tab Retail Loan Application Entry Transaction Branch Code 001 Application Category Lead Id Application Number Product Code Enquiry ID User Reference Description Application Priority Low Y Application Branch Application Status Application Entry gt Application Date Main Details Financial Requested B cottaterai Comments Liability Details Line Details Pool Details Liability No Line Code Pool Code Liability Name Line Serial Pool Description Main Liability No Main Line Code Pool Currency Liability Branch Line Branch Pool Amount Liability Currency Line Currency Pool Utilized Overall Limit Limit Amount Collateral Amount Effective Line Amount Basis Limit Collateral y Effective Line Amount Documents Trade In Customer Dedupe Loan Dedupe Customer MIS Customer Account MIS Customer Account Fields Pr
61. dar 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 which the report is generated 2 6 ORACLE Body of the Report The following details are displayed in the report Field Name Field Description Branch This is the branch code Product This indicates the product for the contract Application Number 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 Currency This is the currency of the contract 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 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
62. ded Amount Specify the amount that the customer draws as his income 1 57 ORACLE Frequency Select the frequency at which the customer earns income The following options are available in the drop down list e Daily e Weekly e Monthly e Quarterly e Half Yearly e Yearly Currency Specify the applicant s asset currency You can select the currency from the option list provided Amount Specify the amount that the customer draws as his income Liability Details You can capture the following details corresponding to the loan applicant s liabilities Liability Type Select the type of the liability from the following options provided in the drop down list e Loan e Lease e Rent e Others Liability Sub Type Specify the sub type corresponding to the liability Frequency Select the frequency at which the customer pays his liability amount The following options are available in the drop down list e Daily e Weekly e Monthly e Quarterly e Half Yearly e Yearly Currency Specify the currency in which the customer pays his liability amount You can select the appropriate currency from the option list provided 1 58 ORACLE Amount Specify the amount that the customer pays as his liability Account Balance Specify the balance associated with the liability account Start Date Specify a start date for the liability or select the start date by clicking the Calendar icon End Date Sp
63. ded 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 Responsibility Select the responsibility from the adjoining drop down list Liability Specify the liability for all parties other than primary applicant Short Name Specify the short name of the customer Gender Select the gender of the customer from the drop down list Date of Birth Specify the date of birth of the customer or select the date by clicking the Calendar icon provided 1 3 ORACLE Mother s Maiden Name Specify the customer s mother s maiden name 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 prospec
64. details are captured as part of this stage Document Capture Stage Comments After this stage the following core activities are carried out in the following sequential order Applicant Creation Applicant Account Creation Applicants Limits Liability Facility Collateral Pool creation Loan Creation ORDRLDVR PROCEED RETURN CANCEL Manual Retry This stage is optional Task is moved to this stage only when the system is unable to create Customer Customer Account Liability Facility Collateral pool Loan You have to do the necessary changes and retry the same ORDRLMCU PROCEED The stages are explained in detail in the sections that follow 1 49 ORACLE Step 1 Application Entry In this stage the bank receives an application for a loan along with the relevant documents and financial statements from a prospective customer If the applicant does not have an account but intends to open one the bank also obtains the account opening form and related documents as part of this activity The details related to the applicant contact information employment information requested loan details collateral details etc are captured during this stage Documents obtained from the applicant are uploaded and advices maintained for the stage are generated by the process after completion of the stage You can key in the loan application details required in Retail Loan Application Entry sc
65. ding score gets added If the details do not satisfy the condition then zero will be considered as default score 1 43 ORACLE 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 Logical Operators Select the logical operator to be used to define the credit score calculation formula You can select e gt lt gt gt lt AND or OR Based on the formula and the loan application category the system automatically applies a price ID to the application You can apply a different price ID that matches the application only at the Underwriting Stage If you change a price ID selected by the system and reapply a different price ID the system changes the score of the pricing rule The score determines the price ID to be automatically applied 1 17 2 Maintaining Pricing Offer Click Pricing button to define the pricing rule for each price ID for the user to pick up the offer for the loan Offer Details 10f1 4 Sequence Number Score From Score Up To Rate No of Installments Frequency Units Monthly X Yo
66. e 000 Save J Hold Application Category TESTRET Lead Id Application Number RetailLending4856 Product Code CLO2 Enquiry ID User Reference 000CLO212065000H Description NormalBearing lel Application Priority Low Application Branch 000 Application Status Underwriting Application Date 2012 03 05 Applicant Details Type Primary Local Branch 000 Customer No 000000103 Customer Name PAVIT address Main Details Financial Requested Limit Collateral Credit Score Bureau Ratio Loan Component Charge IESNBAIER Comments 101 il Verification Type Agency Status Internal 3 al Not Required KYC Review Customer Dedupe Loan Dedupe Customer MIS Customer Account MIS Customer Account Fields Vehicle Evaluator Bureau Report Loan MIS Loan Fields Prev Remarks Remarks Audit 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 106 ORACLE 1 18 27 Comments Tab In this tab you can capture the comments by the users Retail Loan Underwriting Transaction Branch Code 000 Save oi Hold Application Category TESTRET Lead Id Application Number RetailLending4856 Product Code CLO2 Enquiry ID User Reference 000CLO212065000H Description NormalBearing e Application Priority Low
67. e Last Name Birth Date Summary ic ons Fri lessages Inquiries Also tement res Sur 1 Trade Lines Public Records Collecti Fraud Mi Inquiries Also Known As Consumer Stat Credit Score Inquiries Auto Bank Card Retail Financing Salas Finance Customer No 000000103 External Agency A1 Credit Report ld Report Date Unique Id On File Date E Best Match 6M 24M Trade Lines Credit Bureau Report Application Number RetailLending4856 Requested Id 1353 Report Header Bureau First Name MiddleName Last Name Birth Date Summary 1 Summary 2 MUA Pei Records Collections Fraud Messages Inquiries Also Known As Consumer Statement Credit Scores Trade Lines l dion D WD Creditors Name Status Type Type Code Past Due Amt Balance Balance Date Customer No 000000103 External Agency A1 Credit Report Id Report Date Unique Id On File Date C Best Match Open Date 60 90 Creditor Subs Public Records Credit Bureau Report Application Number RetailLending4856 Requested Id Report Header Bureau First Name MiddleName Last Name Birth Date Summary 1 Summary 2 Trade Lines Public Records Collections Fraud Messages Inquiries Also Known As Consumer Statement Credit Scores Public Records ii dion gt DD Record Type Status Amount Filed Date Customer No 000000103 External Agency A1 Credit Repor
68. e iseseisva soke aeea aE RE Sei aee TE EAE Toba ESES iaa 1 73 1 18 14 Capturing Customer MIS sic ciescssecsezcisssiestascassdtasetinoes sadeegsesedbtg a isei tea aee TE oa Et oake s aE Sa reiia 1 74 1 18 15 Capturing Customer Account MIS oooccnccccunacconnnonocononononn nono nonn nena nnnn cnn canon nn cre cnn econ cenar nn nr nn craneo 1 74 p 1 18 16 Specifying Customer Account Fields ccccccccesccescesscesecesecusecuseceeeaeeesseeseesaeeseeeseceseseaesaeenaeenas 1 75 1 18 17 Viewing Vehicle EVGluUdtor icons traen batea cadesrveva asaini tiekie a eai 1 76 STEP 2 APPLICATION VERIFICATION cococoncncncnonononononononononononononononononononononononononononononnnonononnnnnononnnnnoncnoninininnns 1 78 STEP 3 INTERNAL KY C CHECK et 1 79 STEP 4 EXTERNAL KYC CHECK eenaa apre irea E repe EITE EEEE OSTSID EEE E ESISTE E E aIia 1 82 STEP 5 UNDERWRITING 443 A E a TT TEE E 1 85 1 18 18 MIQUE KOIPEA EEE AEAEE AE ENESE E O et AE e Re a 1 85 1 18 19 E ollateral Tab NE EE E AE AE E E E E E E AE ETE rd 1 85 1 18 20 CVEGIE SCO TADA A iaa 1 88 1 18 21 Bureau Tab cias a as 1 89 1 18 22 Ratios Taba a na ida 1 97 1 18 23 VEA Ee PEN EE tia 1 98 1 18 24 Component Tabo ciao aii aA E sas dot eu dev aR A E OE EER ERGa 1 100 1 18 25 Charges Labio a a E legos E EE aE Ea A O E NETES RSE 1 104 1 18 26 Investigation Tab norisei te EEEE EE as tias 1 106 1 18 27 Comments TAD AEE ENEE AEA E EE E A E E E E E E R 1 107 STEP 6 LOAN APPROVAL i cece ser
69. e screen type ORDPRCMT in the field at the top right corner of the application toolbar and click the adjoining arrow button Pricing Details Price Group ID Price Type Retail Description el Pricing Details ld 4 107 D DI Price ID Price Description Default Formula Offer l MEA Offer o PE EA Maker Date Time Checker Date Time Mod No Record Status Authorization Status Specify the following details Pricing Group ID Specify a unique name to identify the price group Description Specify a brief description of the price group Price Type Specify the price type associated with the price group You can choose one of the following price types e Corporate e Retail Pricing Details Specify the following details Price ID Specify a unique price ID This price ID can be applied to a loan at underwriting stage Price Description Specify a brief description of the price ID 1 41 ORACLE Default Check this box to set this as the default price ID for the price group that you maintain 1 17 Viewing Pricing Details You can view the pricing details maintained in the Pricing Details screen To invoke the screen type ORSPRCMT in the field at the top right corner of the application toolbar and click the adjoining arrow button Pricing Details Authorization Status r Record Status Price Group I
70. ecify an end date for the liability or select the end date by clicking the Calendar icon Asset Details Type Select the type of the asset from the following options available in the drop down list e Vehicle e Home e Others Asset Sub Type Specify the sub type associated with the asset Description Specify a suitable description for the asset type Asset Value Specify the value associated with the asset Vehicle You can 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 1 59 ORACLE Reg Specify the registration number of the vehicle Home Address Line 1 3 Specify the address of customer s residence in the three Address lines provided 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 You can enter only the details of the selected asset type otherwise the system displays an error message 1 60 ORACLE 1 18 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 required If you have selected an Enquiry ID for the cus
71. eckbox 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 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 6 Loan Approval In the Loan Approval stage the approver verifies the loan application analyzes the applicant s financial status credit rating and field investigation reports and based on the credit worthiness of the customer approves the loan offered to the customer You can invoke this screen by typing ORDRLAPR in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button Retail Loan Approval Save iil Hold Application Category Lead Id Application Number Product Code Enquiry ID User Reference Description Application Priority Low Application Branch 007 Application Status Application Enty Application Date 2012 05 15 a Main Details Financial Requested Limit Collateral Credit Score Bureau Ratio Loan Component Charge Investigation Comments Channel KYC Requir
72. ection of the application If you do not check this box the system will not make an auto decision with regard to approval of the application You can set the status of this check box only during Application Entry stage External Credit Check Required Check this box to enable external credit bureau service for credit evaluation of the loan applicant If you check this box the system will automatically initiate external credit check If you do not check this box the system will not initiate external credit bureau check The credit check initiation happens before underwriting stage Group Code Specify customer s group code along with the applicant s details SSN Specify applicant s SSN Applicant Details Type Select the type of the customer from the drop down list provided The following options are available e Primary e Co Applicant Existing Check this box to indicate if the customer applying for the loan is an existing customer of the bank 1 52 ORACLE Local Branch Specify the local branch home branch of the loan applicant Select the appropriate one from the option list Customer No The system displays the customer number However you can modify it For existing customers you need to select the customer number from the option list provided Click Default button to default the details of existing customers In case of new customers the checkbox Existing will be unchecked When you clic
73. ed External Credit Check Intermediary Group Auto Decision Required Required Applicant Details 10 E Type Existing Local Branch Customer No Default Short Name Customer Name Nationalld Responsibility Liability RM ID Country First Name SSN Nationality Middle Name Passport Number Language Last Name Passport Issue Date Customer Category Salutation Mr Passport Expiry Date Financial Currency Gender Male Account Details os Date of Birth Mobile Number Landline Number Account Branch Mothers Maiden Name Account Class ale Marital Status Married Account Number Dependents Default KYC Review Customer Dedupe Loan Dedupe Customer MIS Customer Account MIS Customer Account Fields Vehicle Evaluator Loan MIS Loan Fields Prev Remarks Remarks Audit 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 1 108 ORACLE If the application details are verified successfully the approver can proceed with the processing of the application by selecting PROCEED as the Outcome The approver can select RETURN to return the process to previous stage for data correction or CANCEL to terminate the process On successful completion a message stating that the task is successfully completed gets displayed To acquire the next stage you need to go to the Task menu and select
74. er Language Last Name Passport Issue Date Customer Category Salutation Me Passport Expiry Date Financial Currency Gender l Male Account Details Group Code Date of Birth Mobile Number Mothers Maiden Name Landline Number Marital Status Married EN Dependents Account Branch Account Class Account Number Fax Documents Trade In KYC Review Customer Dedupe Loan Dedupe Customer MIS Customer Account MIS Customer Account Fields Vehicle Evaluator Bureau Report Loan MIS Loan Prev Remarks Remarks Audit 1 111 ORACLE 2 Reports 2 1 Introduction The following are the reports that you can generate in Retail Loan Origination module e Prefunding Contract Report e Funded Contract Report e Credit Application By User Report e Underwriting Status By Month and Intermediary Report e Underwriting Status By Month and Underwriter Report e Underwriting Status 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 The selection options that you specified while generating a report are printed at the beginning of every report 2 2 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 corn
75. er of the Application tool bar and clicking on the adjoining arrow button Prefunding Contract Prefunding Contracts Report Account Branch From Date To Date ReportFormat PDF wv PrinterAt Client v Report Output Print v Printer Specify the following details Account 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 2 1 ORACLE 2 2 1 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 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 Branch This is the branch code Product 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 indicat
76. er of the Application tool bar and clicking the adjoining arrow button Application Category Maintenance Detail _ M New E Copy E Close E Unlock E Print 25 Enter Query Application Category RETAIL_P Application Type Retail Category Description Retail Rule ld RRULE1 Ratio ld RATIO1 Pricing Group NRP2 Agency Product Details 101 Product Code Product Description Default Ey CLO2 NormalBearing F CLP1 CL_PDC_TENOR_PRODUCT Offer Details 101 ia Offer id No of Installments Units Frequency Rate Rate Code Default F OFF1 12 Monthly 1 8 F OFF2 12 Monthly 1 15 F OFF3 12 Monthly 1 10 Monthly 1 Maker M35713 Date Time 2012 11 07 14 37 51 Mod No 1 Checker M35713 Date Time 2012 11 07 14 37 52 Record Status Open Authorization Status Authorized You can specify the following details in this screen Application Category Specify a unique identification for the loan application category Category Description Specify a suitable description for the loan application category Rule Id Specify the credit rule to be associated with the application category or select the Rule Id from the option list provided 1 36 ORACLE Ratio Id Specify the credit ratio to be associated with the application category or select the Ratio Id from the option list provided Pricing Group Specify the pricing group to be linked to the retail loan category The option list displays all valid pricing
77. es the contract date Contract Currency This is the currency of the contract 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 2 ORACLE 2 3 Funded Contracts Report 2 3 1 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 Funded Contract Funded Contracts Reports Branch From Date To Date ReportFormat PDF wv PrinterAt Client v Report Output Print Printer 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 he
78. ev Remarks Remarks Audit In this screen specify the following details Liability Details Liability No Select the applicant s liability number The adjoining option list displays all the valid liability numbers maintained in the system Select the appropriate one Liability Name Select the liability name Main Liability No Select the parent liability number The adjoining option list displays all the valid liability number maintained in the system Select the appropriate one Liability Branch Select the liability branch The adjoining option list displays all the valid liability branches maintained in the system Select the appropriate one 1 63 ORACLE Liability Currency Select the liability currency The adjoining option list displays all the valid liability currencies maintained in the system Select the appropriate one Overall Limit Specify the overall liability limit Line Details Line Code Select the applicant s facility The adjoining option list displays all the valid line codes maintained in the system Select the appropriate one Line Serial Specify the line serial number Main Line Code Select the parent facility if the specified applicants facility is associated with any parent facility from the adjoining option list Line Branch Select the facility branch code The adjoining option list displays all the valid line branches maintained in the system Select the appropriate one Line C
79. ffective Date Specify the Collateral Value evaluation date Haircut Specify the haircut for evaluating the Collateral Value in the provided effective date In this screen specify the following details to facilitate vehicle evaluation Vehicle Details You can capture the details of the vehicle which is to be evaluated in the following fields Identification Number Enter the unique identification number associated with the vehicle Vehicle Number Specify the vehicle number Year Specify the year of manufacture for the vehicle Make Specify the make of the vehicle Model Specify the vehicle model Body Specify the vehicle body details Usage Specify the mileage used by the vehicle till date 1 67 ORACLE Valuation Source Select the collateral Vehicle Valuation Source from the adjoining drop down list You can select one of the following e None e Internal Valuation Status Select collateral vehicle valuation status from the adjoining drop down list You can select one of the following e Recommended e Not Recommended Vehicle ID Specify the vehicle identification number These details will be used at the underwriting stage to evaluate the vehicle Covenant Details Covenant Name Specify the collateral s covenant name Due Date On Specify collateral s covenant due date on Frequency Start Date Specify the collateral covenant start date Start Month Specif
80. following details 2 4 ORACLE 2 4 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 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 Branch This is the branch code Product This indicates the product for the contract Application Number 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 Currency This is the currency of the contract
81. he 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 No 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 prospective 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 1 7 ORACLE 1 2 3 Requested Tab You can capture the details related to the requested loan in Requested tab Prospect Details Py New Oy Copy ES Close E Unlock Ed Print 2 Enter Query Lead hd LEADO1 Branch Code 000 Financing Type Retail Description Lead Desc Date of Enquiry 2012 03 05 Reason Loan equested Loan Details Requested Currency GBP Rate Loan Purpose IOAN Requested Amount Teno
82. horization Status Record Status You can specify any of the following details to search for a record e Authorization Status e Record Status e Group Id Record Status Group Id Description 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 29 ORACLE 1 10 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 Override Maintenance Save ff Hold Process Code a a Application Category Type Retail X Stage Description Overrides 10f1 Sequence Number Condition Error Code Error Parameter 1 7 E Elements a Index Functions X Braces X Operators X Lanical Onaratare Ba Maker Date Time Checker Date Time Mod No Record Status Authorization Status You can specify the following details in this screen Process Code Specify the process code of the process for which you wish to maintain override conditions or select the process code from the option list provided Application Category Specify the catego
83. icate 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 M New Ct Copy ES Close E Unlock Gy Print 15 Enter Query Application Category RETAIL_P Application Type Retail Category Description Retail Ruleld RRULE1 Ratio ld RATIO1 Pricing Group NRP2 Agency Code Agency Name Bureau Details 1011 Bureau Code Bureau Maker M35713 Date Time 2012 11 07 14 37 51 Mod No i Checker M35713 Date Time 2012 11 07 14 37 52 Record Status Open Authorization Status Authorized You can specify the following details in this screen Credit Agency You can capture the details related to the credit rating agencies here 1 38 ORACLE Agency Code Specify the identification code of the rating agency that provides credit rating details for customer securities Agency Name Specify the name of the rating agency that provides credit rating details for customer securities Bureau Details You can capture the details related to the credit bureau here Bureau Code Specify the identification code of the credit bureau that provides credit ratings for customer securities Bureau Specify the name of the credit bureau that provides credit rati
84. ie cao obe chases ooo 1 108 STEP 7 DOCUMENT VERIFICATION cada 1 109 STEP 8 MANUAL RETRY caxo 1 110 REPORTS ERE NO 2 1 2 1 INTRODUCTION a 2 1 2 2 PREFUNDING CONTRACT REPORT ccccccccccccsecececececececesececesssesesesesecssesssssesesssesseeseseessesesessssssessseeseeesseseaeess 2 1 22 4 Contents Of the REPO A seas saseshnsnateadpscaeusenecasecenscasecheosdsqabnesacesouesaseas 2 2 2 3 FUNDED CONTRACTS REPORT cccccccesecscececesecscececesecececececececesscecesecasesecssssscssecssecacasesaseessssessessesesseesseseauses 2 3 23 1 Conitents Of the R DOrt iscsi RN 2 3 2 4 CREDIT APPLICATION BY USER REPORT ccccccccccccecccesecececesececesececesesesesesesscesssesecesesesecesssesssesesesesseseseaeess 2 4 2 4 1 CONtENTS OF the Report ai speserei ieoa see enir E o AEAEE SRE SEEE ETEA ASEE ETENE ios 2 5 2 5 UNDERWRITING STATUS BY MONTH AND INTERMEDIARY REPORT cccccccceceseceseseseceseceseseseseseseeeeeeeeses 2 6 2 5 1 Contents 0f the Reporta ta saasededaviseevageasns sodeates Spoachevadelsessasaasbedaeutenecdsecebscasecheosaseabngsasesouecuseas 2 6 2 6 UNDERWRITING STATUS BY MONTH AND UNDERWRITER REPORT occccccccncncnononononononononononononononononininininons 2 7 2 6 1 CONTENTS OF the Reportar sedative da seusbbvaseshessataasbscastenecd veces EEE EE AEEA ASES TETEE Ra 2 8 237 UNDERWRITING STATUS BY MONTH REPORT ococcccccncncnonononononononononononononononononononononononononononononononononininininons 2 9 2 7 1 Contentsof MRE
85. isplayed in the report Field Name Field Description Branch This is the branch code Product This indicates the product for the contract Application Number 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 Currency This is the currency of the contract 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 8 ORACLE Field Name Field Description Branch Total This indicates the total number of records for the branch 2 7 Underwriting Status By 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 ReportFormat PDF v PrinterAt Client v Report Output Print v Printer 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 op
86. k Default button the system defaults the local branch and automatically generates the customer number Responsibility Specify the Co Applicant s Responsibility for all parties other than primary Applicant Liability Specify the Co Applicant s Liability Percentage for all parties other than primary Applicant Sum of liability for all applicants should not exceed 100 RM ID Specify the Relationship Manager ID of the Loan Applicants RM Name Specify the Relationship Manager name of the Loan Applicants You have to specify the following details Country Specify the country of domicile of the customer or select the country code from the option list provided Nationality Specify the country of which the customer is a national or select the country code from the option list provided Language Specify the primary language of the customer or select the language from the option list provided Customer category Specify the category to which the customer belongs or select the customer category from the option list that displays all valid customer categories Financial Currency Select the currency used in the transaction 1 53 ORACLE Group Code Specify the appropriate group code Mobile Number Specify the mobile number of the customer Landline Number Specify the landline number of the customer Email Specify the e mail address of the customer Fax Specify the fax number of the customer
87. ke the corresponding auto decision Auto Decision Specify the auto decision to be made for each credit score You can maintain the maximum credit scores for each of the following decisions e Auto Approved e Recommend Approval e Recommend Reject e Auto Rejected While creating a loan based on the applicant s credit score and auto decision mapping maintained in here the system decides whether to approve reject recommend approval or recommend rejection of the application 1 25 ORACLE 1 7 Viewing Credit Rule Summary You can view a summary of the credit rules in Rule Maintenance screen You can also query for a particular record based on desired search criteria You can invoke this screen by typing ORSRULMT in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button Rule Maintenance Authorization Status y Record Status v Rule Id a Advanced Search Records per page 15 w 1 Of 1 Authorization Status Record Status Rule Id Account Description You can specify any of the following details to search for a record e Authorization Status e Record Status e Rule ld 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 26 ORACLE 1 8 Maintaining Credit Ratios You can maintain the rules to calculate the credit ratios in Credit Ratio M
88. led screen 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 captured as part of the simulation e Personal Details of the Prospect 1 9 ORACLE e Loan offers selected by the Prospect Based on the product offers selected and requested details the system will generate loan and schedule details You can enter the required details for the prospective customer in Retail Loan Simulation Details screen You can invoke this screen by typing ORDRLSIM in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button Retail Loan Simulation Details New Of Copy X Delete E Unlock Ey Print iz Authorize 5 Enter Query Enquiry ID FCGGHFG Application Category RETAIL1 Status Active 7 na Branch Code 000 Product Code CLP1 User Reference 000CLP112065004 Enquiry Date 2012 03 05 Description CL_PDC_TENOR_PRC ustomer Details Customer No 000000103 First Name Contact Number Last Name Email Requested Loan Details Requested Currency GBP Interest Rate 14 Loan Purpose Requested Amount 20 000 00 Tenor In Months 12 Coan Component Multiple Offers 10f1 v Offer Id No of Installments Frequency Unit Rate Rate Code Check Apply y ofter12 12 1 Monthly 12 inanci
89. mer No First Name Last Nam A Unauthorized Open FCGGHFG RETAIL1 CLP1 000000103 v You can specify any of the following details to search for a record e Authorization Status e Record Status e Enquiry ID e Application Category e Product Code e Customer Number e First Name e Last Name e Status e User Reference Click Search button to search for a record based on the search criteria specified You can double click a desired record to view the detailed screen 1 19 ORACLE 1 6 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 Details Save vil Hold BM Risk Factor Question Details 10f1 Question Id 1 Rule Id Account Description Question Type Retail Answer Details 10f1 Sequence Number Possible Answer Maker Checker Mod No Date Time Date Time Record Status Authorization Status You can spe
90. more details on Capturing Asset Valuation details refer the section titled Account Asset Valuation in Retail Lending user manual 1 18 12 Verifying Customer Dedupe You can verify if the customer details are duplicated by clicking the Customer Dedupe button Customer Dedupilcation Check screen gets displayed where any duplicate customer details are displayed 1 72 ORACLE Customer Dedupe Application Number RetailLending5149 el Customer No 001 Customer Dedupe Details Id dion D DI Go Customer No First Name LastName Short Name National ld Customer Category Date of Bith Email Passport h 1 18 13 Verifying Loan Dedupe You can verify if the loan details are duplicated by clicking the Loan Dedupe button Loan Dedupilcation Check screen gets displayed where any duplicate loan details are displayed Loan Dedupe Application Number RetailLending5149 Customer No 001 Loan Dedupe Details ld dion gt Mi Go Loan Account Number Loan Currency Loan Amount Value Date Maturity Date Outstanding Amount Rate 1 73 ORACLE 1 18 14 Capturing Customer MIS You can capture the MIS details for the customer if any by clicking MIS button against a row in the Applicant Details table The Customer MIS screen gets displayed where you can maintain the MIS details Customer MIS Application Number
91. ncial Requested Limit Collateral Credit Score B Ratio Loan Component Charge Investigation Comments External Credit Rating Recommended Not Recommended Request ID Status Not Required External Agency Remarks Score KYC Review Customer Dedupe Loan Dedupe Customer MIS Customer Account MIS Customer Account Fields Vehicle Evaluator Bureau Report Loan MIS Loan Fields Prev Remarks Remarks Audit The credit agencies and the bureaus maintained for the Application Category are displayed in this screen You can capture the remarks and recommendations from these agencies in this tab You can also view the credit report obtained from the agencies and bureaus Credit Bureau Details 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 1 89 ORACLE Status Select the status for the credit bureau check from the following options in the drop down list e Completed e Pending Remarks Specify remarks if any associated with the loan application External Credit Rating External Agency Specify the external agency that you want to use for the evaluation If you do not specify a value here the system will display an error message Recommended Select the recommendation of the credit agency for the loan requested from the following options provided in the drop down lis
92. ng Details Loan Branch 000 Value Date 2012 03 05 No of Installments 12 Loan Account Number 000CLP112065014 Maturity Date 2013 06 05 Frequency 4 Financing Currency GBP Installment Start Date 2012 04 05 Unit Monthly Financing Amount 20 000 00 Status Change Mode Auto gt Effective Date User Defined Element Values 1011 10f1 V Effective Date v User Defined Elementid User Defined Element Value Rate Code Code usage Resol y 2012 03 05 Y INTEREST_RATE 12 4 m Maker SUBHA1 Date Time 2012 03 05 18 13 11 Mod No 1 Checker Date Time Record Status Open Authorization Status Unauthorized If details are available as part of the maintenance for the prospect in the Prospect Details screen then after you specify the Application category Product Code and Customer Number 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 ORACLE Enquiry ID On clicking the Default button the system generates and displays a unique enquiry ID Branch Code The system displays the enquiry branch code This cannot be modified Enquiry Date The system displays the date of enquiry Enquiry date cannot be modified Application Category Specify the application category for the loan enqui
93. ng details for customer securities 1 39 ORACLE 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 in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button Category Details Authorization Status v Record Status v Application Category a Financing Type x Advanced Search Reset Records per page 15 vj 1 Of 1 Authorization Status Record Status Application Category Category Description Financing Type You can specify any of the following details to search for a record e Authorization Status e Record Status e Application Category Click Search button to search for a record based on the search criteria specified You can double click a desired record to view the detailed screen 1 16 Maintaining Pricing Details Oracle FLEXCUBE allows you to maintain pricing groups and apply a suitable pricing rule to an application category during retail loan origination The pricing rule automatically selects the best matched loan offer for the loan application from the available offers for the application category You need to maintain pricing groups and define the price IDs and formulae for the group using Pricing Maintenance screen 1 40 ORACLE To invoke th
94. ocess 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 1 33 ORACLE Document Details Document Category Specify the category to which the document belongs or select the document category from the option list provided Document Type Specify the type of the document or select the document type from the option list provided Mandatory Select the option to indicate whether the document is mandatory or not You can select any of the following options from the drop down list provided e Mandatory e Overridden e Others BI Advices Report Name Specify the name of the advice report to be generated on completion of the process stage Template Specify the template to be used to generate the advice report Format Select the format in which the advice report needs to be generated from the drop down list provided The following options are available e PDF e RTF Locale Select the locale information to be used for generating the advices from the drop down list The following options are available e en US Out come Specify the outcome for which the report needs to be generated Checklist Details Sequence Number The system displays the sequence number Checklist Item Specify the checklist to be maintained 1 34 ORACLE Mandatory Check this
95. on the review Step 4 External KYC Check You can verify the customer information against the external blacklist of customers at External KYC Check stage This step is enabled only if you have checked the box KYC Required during Application Entry You can invoke this screen by typing ORDRLIKC in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button KYC Review Application Number RetailLending1179 el Customer No 001004388 KYC Review Details Local Branch KYC Extenal Status First Name Middle Name lo Mate N Stat Last Name ON aes Date of Birth 1982 03 01 SON Remarks No Matc Country GB Review Nationality GB j KYC Extenal Remarks No lj P h itch j h The system displays the following details e Local branch code e First name of the customer e Middle name of the customer e Last name of the customer e Date of birth of the customer e Country of the customer e Nationality of the customer KYC External Status The system displays the external KYC status Based on the records in Oracle FLEXCUBE the KYC external status can be one of the following e Passed e Failed e No Match KYC External Remarks The system displays the external KYC remark The external remark can be one of the following e Possible Match 1 82 ORACLE e No Match Click Review button to check the customer details against the blacklisted customers list
96. ormalBearing Application Priority Low Application Branch 000 Default Application Status Underwriting Application Date 2012 03 05 Main Details Financial Requested Limit Collateral Credit Score Bureau Ratio Loan ERR charse Investigation Comments Component Name Main Component Component Currency Capitalized Liquidation Mode Auto Sa Waive Verify Funds Schedules 10 E Schedule Type Schedule Flag Formula First Due Date No of Schedules Frequency Units Schedule Start Date End Date Amount EMI Amount Car z KYC Review Customer Dedupe Loan Dedupe Customer MIS Customer Account MIS Customer Account Fields Vehicle Evaluator Loan MIS Loan Fields Prev Remarks Remarks You have to specify the following details Component Name Select the name of the loan component Component Currency Select the loan component currency code 1 100 ORACLE Liquidation Mode Select the mode of liquidation from The adjoining drop down list displays the following optiins e Auto e Manual Main Component Check this box to indicate if the provided component is main component Capitalized Check this box to indicate that the component needs to be capitalized Waive Check this box to indicate that component needs to be waived Compound Days Specify the number of compound days Compound Months Specify the number of compound months Compound Years Specify the number of compound years Years
97. orner of the Application tool bar and clicking the adjoining arrow button 1 95 ORACLE The Loan UDF screen gets displayed where you can capture the details Loan Fields Application Number RetailLending4856 Loan Account Product Code CLO2 Loan Account Branch 000 Character Fields ol a E la o Ie e Ia E iz a 2 o i o ie E a le o la 0000000000000 lalo lola Number Fields lo0 0 0 0 0 0 l0l o 1 96 ORACLE 1 18 22 Ratios Tab In the Ratios tab the system calculates the stated and actual income debt ratios and also calculates the ratio based on What if payment amount Retail Loan Underwriting Transaction Branch Code 000 Application Category RETAIL_N Lead Id Application Number RetailLending4828 Product Code CLO2 Enquiry ID User Reference 000CLO212065000F Description NormalBearing Application Priority Low y Application Branch 000 Default Application Status Underwriting Application Date 2012 03 05 Applicant Details Type Primary X Local Branch 000 Customer No 000000103 Customer Name PAVIT address Main Details Financial Requested Limit Collateral Credit Score Bureau n Component Charge Investigation Comments Stated Actual Anois Monthly Income Monthly Income Liabilities Monthly Debt Monthly Debt Net Worth What if Payment Amt Ratios
98. other offer for the loan based on the need 1 98 ORACLE If you change a price ID selected by the system and reapply a different price ID the system changes the score of the pricing rule The score determines the price ID to be automatically applied Click Apply button to apply the selected price ID to the loan On clicking Apply button the system compares each offer under Multiple Offers with the pricing and other details requested The values in the fields No of Installments Frequency and Unit are compared with the values given by the applicant in the Requested tab during Application Entry stage The rate under Multiple Offers is compared with the rate maintained in the Pricing ID On comparison if the system finds a matching offer it applies the details of the offer to the application In case the details do not match the system creates a new row with the values available in the offers maintained for the pricing ID and applies it Status Change Mode Select the status change mode of the loan The adjoining option list displays the following option e Auto To change the status automatically e Manual To change the status manually Close Collateral Check this box to give a provision to close the collaterals associated with the Loan It can be selected only if the liquidation mode is Auto Effective Date The system captures the effective date of User defined elements However you
99. r in months of the prospective customer Loan Purpose Specify the customer s purpose for obtaining the loan 1 12 ORACLE 1 4 1 Loan Tab You can maintain the offers for the customer in the loan tab Retail Loan Simulation Details New Of Copy X Delete 9 Unlock Ey Print Authorize 53 Enter Query Enquiry ID FCGGHFG Application Category RETAIL1 Status Active Branch Code 000 Product Code CLP1 User Reference 000CLP112065004 Enquiry Date 2012 03 05 Description CL_PDC_TENOR_PRC Customer Details Customer No 000000103 First Name Contact Number Last Name Email Requested Loan Details Requested Currency GBP Interest Rate 14 Loan Purpose Requested Amount 20 000 00 Tenor In Months 12 BE coroner Multiple Offers 10f1 v Offer ld No of installments Frequency Unit Rate Rate Code Check Apply 7 offer12 12 1 Monthly 12 Apply inancing Details Loan Branch 000 Value Date 2012 03 05 No of Installments 12 Loan Account Number 000CLP112065014 Maturity Date 2013 06 05 Frequency 1 Financing Currency GBP Installment Start Date 2012 04 05 Unit Monthly Financing Amount 20 000 00 Status Change Mode Auto Effective Date User Defined Element Values 1011 1011 Y Effective Date v User Defined Element ld User Defined Element Value Rate Code Code usage Resolv Y 2012 03 05 Y INTEREST_RATE 12 Enter the following details here Offer ID Specify a unique identification for the loan offer being made to
100. r in Months Maker TESTI Checker TEST3 You can capture the following details here Requested Currency Specify the loan currency preference of the customer or select the currency from the option list provided Requested Amount Specify the loan amount requested by the prospective customer Tenor in months Specify the preferred loan tenor in months of the prospective customer Rate Specify the preferred interest rate of the prospective customer Loan Purpose Specify the Purpose of the loan 1 8 ORACLE 1 3 1 4 Viewing Loan Prospect Summary You can view a summary of the prospective loan customers or the borrowers in Loan Prospect Details screen You can also query for a particular record based on desired search criteria You can invoke this screen by typing ORSLEADM in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button Loan Prospect details Authorization Status Record Status v Lead Id 7 Date of Enquiry Advanced Search Records perpage 15 w 1 Of 1 Authorization Status Record Status Lead Id Date of Enquiry You can specify any of the following details to search for a record e Authorization Status e Record Status e Lead Id 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 detai
101. rcut s Vehicle ID Vehicle Number Year Make Model Body Usage Valuation Source None Valuation Status Not Required m JE KYC Review Customer Dedupe Loan Dedupe Customer MIS Customer Account MIS Customer Account Fields Vehicle Evaluator Loan MIS Loan Fields Prev Remarks Remarks Audit 1 85 ORACLE In this screen capture the following details Vehicle Details You can modify the details of the vehicle which is to be evaluated in the fields listed below Identification Number Enter the unique identification number associated with the vehicle Year Specify the year of manufacture for the vehicle Make Specify the make of the vehicle Model Specify the vehicle model Body Specify the vehicle body details Usage Specify the mileage used by the vehicle till date You can retrieve vehicle details from an external agency either by specifying the identification number for the vehicle or all of the following fields e Year e Make e Model e Body e Usage Valuation Source Select the valuation source from the adjoining drop down list The options are e INTERNAL e NONE Select INTERNAL if you wish the evaluation to be done by interfacing with an external agency Status Select the status from the adjoining drop down list The options are e RECOMMENDED e NOT RECOMMENDED e COMPLETE e NODATA 1 86 ORACLE The evaluation will be done
102. re 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 1 50 ORACLE Description The system displays the brief description on the selected retail lending product You cannot modify it Application Branch The system defaults the application branch You cannot modify it Application Date The system defaults the branch date as the application date You cannot modify it Lead ID Specify the lead Id of the loan applicant or select the lead Id from the option list provided Enquiry ID Specify an enquiry Id if you wish to retrieve 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 Application Number The system displays the application number You cannot modify it User Reference System defaults the user reference number However you can modify it Application Priority Select the priority of application Application Status The status of the application gets displayed here Click Default button to default the details related to the prospective loan customer It also default
103. reen 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 Save lt i Hold Application Category Product Code Description Application Branch 007 Application Date 2012 05 15 Lead Id Application Number RetailLending5050 la User Reference Application Priority Low Enquiry ID Application Status Application Entry MM deis Financial Requested Limit Collateral Comments Channel aij E KYC Required E Auto Decision Required E External Credit Check Intermediary Group ai Required Applicant Details 10H Short Name Customer Name National Id E Type Existing Local Branch Customer No Default Country Nationality Language Customer Category Financial Currency Group Code Mobile Number Landline Number Email Fax Responsibility First Name Middle Name Last Name Salutation Mr Gender Male Date of Birth Mothers Maiden Name Marital Status Married Dependents Customer Dedupe Loan Dedupe Customer MIS Customer Account MIS Customer Account Fields Prev Remarks Remarks Audit Liability RMID RM Name SSN Passport Number Passport Issue Date Passport Expiry Date Account Details Account Branch Account Class Account Number Det The Application Number is automatically generated by the system You can captu
104. reen 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 1 88 ORACLE System defaults the Category and Question as maintained in the Rule Click Calculate button to display the calculated grade and score based on the selected answer Click Calculate button to calculate the credit score and the grade based on the formula maintained for calculating the credit score The Grade and the Score are displayed based on this calculation 1 18 21 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 Transaction Branch Code 000 Application Category RETAIL_N Lead Id Application Number RetailLending4828 Product Code CLO2 Enquiry ID User Reference 000CLO212065000F Description NormalBearing Application Priority Low Application Branch 000 Defau Application Status Underwriting Application Date 2012 03 05 Applicant Details Type Primary y Local Branch 000 Customer No 000000103 Customer Name PAVIT address Main Details Fina
105. rospect retails e Credit rating rules e Credit ratios e Override details e Document checklist and advices e Application category details The Retail Loan origination process flow is composed of following stages e Application Entry e Application Verification e Internal KYC e External KYC e Underwriting e Loan Approval e Document Verification e Manual Retry These features maintenances and the different stages in the process flow are explained in detail in the following sections Maintaining Loan Prospect Details You can maintain the details of a prospective borrower or a loan applicant when the borrower initially approaches the bank enquiring about the various loan products that are being offered 1 1 ORACLE 1 2 1 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 Y new O Copy Ej Close Ej Uniock amp Print 1 Enter Query Load ld LEADO1 Branch Code 000 Financing Type Retail Description Lead Desc Date of Enquiry 2012 03 05 Reason Loan Details Requested nt Details 1011 Sequence Num
106. ry 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 Description The system displays the description of the selected product code Status The system displays the status of the loan simulation User Reference On clicking Default button the system generates and displays a unique user reference numbe You can use this number to track the simulation later Customer Details Specify the following customer details Customer No Specify the customer number for the simulation customer who has initiated a loan account for the same product and application category combination First Name Specify the first name of the customer Last Name Specify the last name of the customer Contact Number Specify the number at which the customer can be contacted E mail ID Specify the e mail ID of the prospective customer 1 11 ORACLE Requested Loan Details You can enter the following details requested by the prospect Requested Currency Specify the loan currency preference of the customer You can select the appropriate currency code from the option list Requested Amount Specify the loan amount requested by the prospective customer Interest Rate Specify the preferred interest rate of the prospective customer Tenor In Months Specify the preferred loan teno
107. ry Stage is an optional stage If the system faces any issues while creating Customers or Customer s Accounts or Customer s Limits the loan application is moved to Manual Retry stage You can do any corrections in the requested Loan Application and retry the task In this stage the verifier can provide the corrected information based on the issues thrown by the system while processing the Loan This stage will be retried until the Loan gets booked in the system 1 110 ORACLE You can invoke this screen by typing ORDRLMCU in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button Retail Loan Manual Retry Task Save lt i Hold Application Category Lead Id Application Number Product Code Enquiry ID User Reference Description Application Priority Low w Application Branch 007 Application Status Application Entry Application Date 2012 05 15 EBM Details Financial Requested Limit Collateral Credit Score Bureau Ratio Loan Component Charge Investigation Comments Channel C KYC Required C External Credit Check Intermediary Group Auto Decision Required Required Applicant Details Id dion gt hi Go Type Existing Local Branch Customer No Default Short Name Customer Name Nationalld Responsibility Liability RMID RM Name Country First Name SSN Nationality Middle Name Passport Numb
108. ry 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 1 30 ORACLE e Retail e Corporate Stage Select the stage of the loan origination process from the option list provided The various stages can be Application Entry Application Verification Underwriting Loan Approval etc Description Specify a suitable description for the loan origination stage Overrides Here you can capture 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 m
109. s the Application Category related details like documents mapped to that particular stage In the Category Maintenance screen if you have marked it as Default the system automatically displays the Product and Product Description 1 18 3 Main Tab The details corresponding to the lead Id selected gets displayed in the Customer tab once you click the Default button You can modify these details if needed For existing customers of the bank you need to specify the following details Channel Specify the channel Id of the originating channel 1 51 ORACLE Intermediary Group Specify the identification code of the intermediary group if the customer has been associated with any KYC Required Check this box to indicate the KYC check is required for the customer If you check this box the system will evaluate a business rule Based on that rule the system initiates internal KYC or External KYC or both during application entry and verification stage If you do not check this box the system then system skips the Internal KYC and External KYC stages after completing the application entry and verification stages Auto Decision Required Check this box to enable auto decision on loan application If you check this box based on the applicant credit score auto decision mapping maintained in Auto Decision screen the system decides whether to approve reject recommend approval or recommend rej
110. t e 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 1 90 ORACLE The system will invoke the external valuation agency for credit evaluation You can view the details in the bureau tab This includes the score assigned by the agency for the customer Credit Bureau Report Application Number RetailLending4856 Customer No 000000103 Requested Id 1357 External Agency A1 Report Header Bureau Credit Report Id First Name Report Date MiddleName Unique Id Last Name On File Date Birth Date Best Match Summary 1 Summary 2 Trade Lines Public Records Collections Fraud Messages Inquiries Also Known As Consumer Statement Credit Scores Life Recent Open Chapter Chapter Chapter
111. t Id Report Date Unique Id On File Date C Best Match 1 92 ORACLE Collections Credit Bureau Report Application Number RetailLending4856 Requested Id Report Header Bureau First Name MiddleName Last Name Birth Date Customer No 000000103 External Agency A1 Credit Report Id Report Date Unique Id On File Date C Best Match Summary 1 Summary 2 Trade Lines Public Records Collections Fraud Messages Inquiries Also Known As Consumer Statement Credit Scores Collections l dion gt di Creditors Name Account Acct Balance High Balance Term Type Balance Date Open Date Last Activity Date History Date Special Exclusior Fraud Messages Credit Bureau Report Application Number RetailLending4856 Requested Id Report Header Bureau First Name MiddleName Last Name Birth Date Customer No 000000103 External Agency A1 Credit Report Id Report Date Unique Id On File Date C Best Match Summary 1 Summary 2 Trade Lines Public Records Collections Fraud Messages Inquiries Also Known As Consumer Statement Credit Scores Fraud Messages is Y 10n gt PY Product Message Inquiries Credit Bureau Report Application Number RetailLending4856 Requested Id 1353 Report Header Bureau First Name MiddleName Last Name Birth Date
112. thorize 4 Enter Query Enquiry ID FCGGHFG Branch Code 000 Enquiry Date 2012 03 05 Customer Details Customer No 000000103 Requested Loan Details Requested Currency GBP Requested Amount Component Name MAIN_INT Component Currency GBP Liquidation Mode Auto Schedules 10f1 F Schedule Type Schedule Flag Y Payment Normal X E Payment Normal 20 000 00 Formula MAIN_INT_FRM_1 MAIN_INT_FRM_1 Application Category RETAIL1 Product Code CLP1 Description CL_PDC_TENOR_PRC First Name Last Name Interest Rate 14 Tenor in Months 12 Main Component Capitalized Waive Verify Funds First Due Date Units 2012 07 03 11 2013 06 05 1 No of Schedules Monthly Bullet v Frequency Schedule Start Date 1 1 User Reference 000CLP112065004 Contact Loan Purpose Disburse Details Schedule Details 2012 03 05 2013 05 06 Status Active Number Email End Date All 2013 05 06 2013 06 05 You can specify the following schedule related details Compound Days Specify the number of compound days Compound Months Specify the number of compound months Compound Years Specify the number of compound years Years Select the actual number of days for the year from the adjoining drop down list You can select one of the following options e 360 e 365 e Actual ORACLE 1 4 3 Days in Month Select the number of days that would constitute a
113. tion by selecting PROCEED as the Outcome The verifier can select RETURN 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 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 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 screen 1 78 ORACLE Step 3 Internal KYC Check You can verify the customer information against the internal blacklist of customers at Internal KYC Check stage This step is enabled only if you have checked the box KYC Required during Application Entry Application Number RetaiiLending1179 i Customer No 001004383 K
114. tion 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 which the report is generated 2 9 ORACLE Body of the Report The following details are displayed in the report Field Name Field Description Branch This is the branch code Product This indicates the product for the contract Application Number 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 Currency This is the currency of the contract 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
115. tive 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 Issue Place Specify the place where the customer s passport was issued E mail Specify the e mail Id of the prospective customer 1 4 ORACLE Dependents Specify the number of dependents for the customer Marital Status Select the marital status of the prospective customer from the drop down list The following options are available e Married e Unmarried e Divorcee 1 2 2 Details Tab You can capture the address and employment related details of the prospective customer in Details tab gt Prospect Details Y New Dz Copy Ej Close E Unlock Gy Print YS Enter Query Lead ld LEADO1 Branch Code 000 Financing Type Retail Description Lead Desc Date of Enquiry 2012 03 05 Reason Loan pplicant Details Type Primary Customer Name ddress Details Address Line 1 PERAMBUR Zip
116. tomer then the requested details that have been stored for the corresponding loan proposal are displayed here Retail Loan Application Entry Transaction Branch Code 001 Application Category Lead Id Application Number Product Code Enquiry ID User Reference Description Application Priority Low Application Branch Application Status Application Entry Application Date Main Details Financial MMERREMY Limit Collateral Comments Requested Loan Details Requested Currency No of Installments 12 Loan Against Salary Requested Amount Frequency 1 Loan Purpose Interest Rate Unit Monthly Tenor In Months Loan Itemization Details 101 E Serial No Itemization Amount Comments Customer Dedupe Loan Dedupe Customer MIS Customer Account MIS Customer Account Fields Prev Remarks Remarks Audit Specify the following details Requested Loan Details Requested Currency Specify the requested currency for the loan Requested Amount Specify the amount requested for the loan Interest Rate Specify the requested loan rate for the loan Tenor In Months Specify the requested tenor for the loan 1 61 ORACLE Number of Installments Specify the requested Number of Loan Instalments Schedules Frequency Specify the requested Loan Schedule Frequency Unit Specify the requested Loan Schedule Frequency Unit Basis Loan against Salary Check this box to indicate that the loan shoul
117. tomer No 001005697 KYC Review Details Local Branch KYC Internal Status No Match First Name KYC Internal Remarks No Match Ps SDN Status No Match gt Last Name no Date of Birth 1982 11 07 emarks No Match gt Country GB Nationality GB Based on the KYC and SDN statuses and remarks the reviewer decides whether to move the task to the next stage Click Review button to view all customer information and perform KYC and SDN checks The KYC Review Screen STSKYCMN and SDN Review Screens ORSSDNMN are displayed 1 80 ORACLE KYC Maintenance Summary gt le Advanced Search 1 or 11 bi Authorization Status KYC Reference KYC Customer Type Records per page 15 14 T Authorization Status Record Status Record Status Full Name of Customer Risk Level KYC Reference Full Name of Customer KYC Customer Type Risk Level Alias Names Summary Name Country Records per page 12 M Name Date of Birth Date of Birth Country 1 81 Once reviewed the verifier provides the review status and remarks You can perform a check on the customer record based on the KYC Review and SDN Review screens and choose the internal KYC status and SDN status respectively based
118. u can specify the following details here Sequence Number System generates the sequence number 1 44 ORACLE Score From Specify the start credit score to pick the offer for the loan Score Up To Specify the end credit score to pick the offer for the loan Rate Specify the rate to be picked up for the score No of Instalments Specify the number of instalments for the offer Frequency Specify the frequency of the offer Units Select the frequency unit from the adjoining drop down list You can select one of the following e Daily e Weekly e Monthly e Quarterly e Half Yearly e Yearly e Bullet 1 18 Stages in Retail Loan Origination The different stages in Retail lending process flow are designed using Oracle BPEL framework The process of loan origination consists of several manual as well as system tasks carried out in a sequential manner Many users can be involved in the completion of a transaction and at each stage of the process a user or a group of users assigned with a task acquire and work on the relevant transaction Oracle Business rules that are embedded help the dynamic creation of multiple approval stages The different stages and sub stages in the process flow can be summarized as follows e Application Entry the following details are captured in this stage gt Applicant Information gt Application details gt Requested Loan Details gt Collateral Details gt Checklist
119. ule Details You can view the schedule details on Schedule Details screen To invoke this screen click Schedule Details button in the Components tab of the Retail Loan Simulation Details screen Schedule Details Application Number RetailLending3248 P Component Name PRINCIPAL a Schedule Details 10f1 Go Oo Due Date Amount Settled Amount Due EMI amount Amortized Principal Accrued 2012 07 03 D 8333 33 E 2012 08 03 0 8333 33 O 2012 09 03 0 8333 33 O 2012 10 03 0 8333 33 J O 2012 11 05 0 8333 33 O 2012 12 05 D 8333 33 manina na nt all naan an v ES ll gt This screen displays the schedule details 1 18 ORACLE 1 5 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 X Authorization Status gt Record Status Enquiry ID Application Category RETAIL1 Product Code Customer No First Name Last Name Status User Reference Records per page 15 M4 4 4 or 1 Authorization Status Record Status Enquiry ID Application Category Product Code Custo
120. urrency Select the facility currency code The adjoining option list displays all the valid line currencies maintained in the system Select the appropriate one Line Amount Specify the line amount for the facility Collateral Amount If the collateral is maintained system displays the collateral amount when you click on Default button Otherwise system displays the value as zero Effective Line Amount basis Select the basis on which the effective line amount is calculated Effective Line Amount System displays the effective line amount based on the specified effective line amount basis Pool Details Pool Code Select the collateral pool code The adjoining option list displays all the valid pool codes maintained in the system Select the appropriate one 1 64 ORACLE Pool Description Specify the collateral pool description Pool Currency Select the collateral pool currency The adjoining option list displays all the valid pool currencies maintained in the system Select the appropriate one Pool Amount Specify the collateral pool amount Pool Utilized Specify the collateral pool amount utilized amount If you click on the Default button system displays the collaterals in the Collateral Tab associated with the pool code and liability 1 18 8 Collaterals Tab You can capture the details related to the collaterals provided by the customer in this tab Retail Loan Application Entry
121. y stage by considering the default Price ID linked to the pricing group Further based on the selected loan offer the loan is applied and schedules are defaulted However at underwriting stage the underwriter may proceed or re apply the loan by selecting a different loan offer Any advices maintained for this stage are generated after the completion of the stage Step 7 Document Verification In the Document Verification stage the documents captured in the previous stages are verified It is ensured that all documents in the checklist maintained are obtained from the customer In this stage the application and applicant information captured as part of the previous stages undergoes a final verification You can invoke this screen by typing ORDRLDVR in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button 1 109 ORACLE Retail Loan Document Verification Save Hold Application Category Lead ld Application Number Product Code Enquiry ID User Reference Description Application Priority Low Application Branch 007 Application Status Application Entry Application Date 2012 05 15 MN ois Financial Requested Limit Collateral Credit Score Bureau Ratio Loan Component Charge Investigation Comments Channel KYC Required Extemal Credit Check Intermediary Group Ati Decisi n Ragas Required Applicant Details 10n E El Type Existing Local Branch Customer No Default
122. y the collateral covenant start month Remarks Specify the covenant remarks 1 68 ORACLE 1 18 9 Comments Tab In this tab you can specify comments if any related to the loan application Retail Loan Application Entry Transaction Branch Code 001 Application Category Lead Id Application Number Product Code Enquiry ID User Reference Description Application Priority Low Application Branch Application Status Application Entry Application Date Main Details Financial Requested Limit Collateral AAA Comments 10 ol Serial No Comments Comment By Comment Date 7 a 32474A01 2012 05 15 Customer Dedupe Loan Dedupe Customer MIS Customer Account MIS Customer Account Fields Prev Remarks Remarks You can specify the following details here Sequence Number The sequence number is automatically generated by the system Comments Specify comments if any to be associated with the loan application Comment By Specify the name of the commenter Comment Date Specify the date on which the comment was given or select the date by clicking the Calendar icon 1 69 ORACLE 1 18 10 Capturing Document Details You can capture the customer related documents in central content management repository through the Documents screen Click button to invoke this screen You can also invoke this screen by typing CSCDOCUP

Download Pdf Manuals

Related Search

Related Contents

Versão    GE JCK 915 User's Manual  Samsung GT-P1000/DM16 Felhasználói kézikönyv  the sterling range of scooters from sunrise medical  

Copyright © All rights reserved. Failed to retrieve file