2. Loan Origination - Oracle Documentation
Contents
1. Nationality Select the nationality of the customer from the option list provided Language Select the language in which the customer wants the statements and advices to be generated from the option list Customer Category Select the category under which the particular customer is to be categorized from the option list provided Click Ok to save the details specified and return to Input Details screen The customer Id of the newly created customer gets displayed in Input Details screen 2 2 3 3 Query Existing Customer Account Input New Customer Account Details In case of an existing customer you can query and choose the customer account to be used for loan settlements in the Select Customer Account screen To invoke this screen click Qry button adjacent to Customer Account in Input Details screen You can also invoke this screen by typing STSCLOAC in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button GG Select Customer Account Web Page Dialog Branch SHC Customer Number 00002 Search Advanced Search Reset 100254 00002 PF00014 00002 PFOO04 00002 PFOOOS 00002 mmcO01 00002 USD INR GBP INR USD a a Account Number Records per page 15 m LUN of 1 r vr Go to Page Branch Account Number Description Customer Number Account Currency Account Class No Debits Mo Credits Stop Payments Dormant SAVING VFTS2. Due care has been taken to make this document and accompanying software package as accurate as possible However Oracle Financial Services Software Limited makes no representation or warranties with respect to the contents hereof and shall not be responsible for any loss or damage caused to the user by the direct or indirect use of this document and the accompanying Software System Furthermore Oracle Financial Services Software Limited reserves the right to alter modify or otherwise change in any manner the content hereof without obligation of Oracle Financial Services Software Limited to notify any person of such revision or changes All company and product names are trademarks of the respective companies with which they are associated 2 1 ORACLE
3. oanOriginationProcess310015 oanOriginationProcess350021 oanDriginationProcess 35001 1 oanOriginationProcess31 0016 oanOriginationProcess31 0003 oanOriginationProcess31 0049 oanOriginationProcess31 0042 oanOriginationProcess31 0005 oanOriginationProcess310013 oanOriginationProcess380096 TXN REF NO TITLE Credit Scoring Stage Credit Scoring Stage Customer Agreement Customer Agreement Customer Agreement Enrichment Of Details Enrichment Of Details Enrichment Of Details Enrichment Of Details Enrichment Of Details CL SCORE CL SCORE CUS AGREE CUS AGREE CUS AGREE CL ENRICH CL ENRICH CL ENRICH CL ENRICH CL ENRICH Mon Oct 20 13 18 51 IST 2008 Thu Oct 23 15 35 27 IST 2008 Thu Oct 23 14 42 41 IST 2008 Mon Oct 20 13 34 44 IST 2008 Mon Oct 20 12 50 06 IST 2008 Tue Oct 21 14 08 48 IST 2008 Mon Oct 20 18 51 30 IST 2008 Mon Oct 20 12 05 07 IST 2008 Mon Oct 20 12 57 21 IST 2008 Wed Oct 29 14 13 22 IST 2008 RI m Next z Action Time Workflow Customer Pickup Time User Id User Name Action Code Branch undefined ASSIGNEEGROUPS ASSIGNEEUSERS CUST ID CUST NAME CREATEDDATE oe ee dd S Remarks Click Acquire button adjoining the desired task to acquire it The following screen will be displayed E Information Web Pag
4. 00 Monthy v Remarks Priority Hi You can also capture the details related to other sources of income if exists Click Ok to save the details and return to Input Details screen There are two sub stages involved for the Input stage where you can perform a review of the details specified i e the NEW sub stage and the REVIEW sub stage The details input during the sub stage New can be reviewed in the sub stage Review In the Input Details screen you can perform the review by selecting an action in the textbox adjoining Audit button If you select AUTOMOVENEXT option in sub stage NEW the next sub stage for REVIEW is acquired automatically If you select MOVENEXT option in sub stage NEW you need to acquire the next stage for REVIEW manually 2 21 ORACLE 3 Input Dotails Web Page Dialsp z Princ C Liver Desine 533 ahis User Peteremeks wer GHOLF Ore tub xw PEN Neen Acecgg Deni Delml C Acii ets Customer ld LUPFTFTE Y 55 555 IK 5E AEE an Priory PPS HEEN Mg ze PROCEED Exit PROCEED MEIVEFHEV In the REVIEW sub stage you can select any of the following actions If you select MOVEPREV option in sub stage REVIEW the work flow moves to the previous stage Input Detail screen with sub stage NEW and has to be manually acquired If you select PROCEED option in sub stage REVIEW the next stage for Enrichment D
5. Amount Disbursed o Booking Date 3 July 2004 Loan Product T PROS 2 NN Bde NN ProductCategory MONIS Customer kd 0000001 Amount Financed EEEE Walue Date 3 July 2000 Maturity Date 3 August 2000 Interest Rate 7 Tenor 31 THE FOLLOWING COMPONENTS WOULD BE ASSOCIATED WITH THE LOAN _ Component CHargen MAIN INT Penal Interest Penal Principal Prepayment PRINCIPAL DEBIT MODE DETAILS FOR ctarges Branch CHO Product Card Humber CLG Bank CLG Bank CLG Branch CLG Branch CASA CASA CASA CASA CASA CARA CASA CASA CASA CASA CASA Debit Settlement Mode CASA _ External AIC External AIC Name Product Category Instrument No CLG product _ Sector Code End Point 2 34 ORACLE On successful completion the task moves to the Pending task list for the next stage Customer Acceptance of the process 2 2 10 Customer Acceptance At this stage the customer accepts the loan application Only users belonging to the CUS ACCEPT role can perform this task You need to acquire the required task from the pending task list if you have the required rights for the same Click Acquire button adjoining the desired task to acquire it Once you acquire a task it moves from the Pending list to the Assigned list Click the Assigned task list and search for the task you need to perform Double click the required task to open Customer Acceptance
6. Bill Schedule Basis Product Contract Notice Day Basis Product zl Prepayment of Amort Loan Recomputation Basis Recaic installment Amt v z Single Installment Prepay Effective From Prepay EMI Type Minimum EMI Amount Minimum EMI Ccy Role To Head Account Status Events Branch Ccy Rest Liquidation Liquidation Mode auto zl Allow Partial Liquidation Retry Count Rev Auto Liq Retries Auto Liq Readjustment Entry Pref Debit Ze Adjust Settlement Adjust Settlement Disbursement Mode Auto Manual Auth Rekey Days m Ze Product Contract Rollover Rollover C Auto Manual Rollover Type Custom Special Allow Rollover Yes C No Product Category Product End Date E Product Type Loan Commitment Cust Cat Rest UDF Holiday Treatment for All Schedules Ignore Holidays Move Across Month Cascade Schedules Adhoc Treatment Reqd Schedule Movement Move forward C Move Backward Include Branch Holiday use Facility Currency Use Contract Currency Use Local Currency Holiday Check Local Holiday CCY a Tenor Minimum Tenor Default Maximum Tenor Unit Months zl Recomputation of Amort Loan Yami Action Change Installment D V AMI Installment Single Installment DN Calculation Type A c Opening Installment AIC Opening Inst Calc Single Installment Type Accrual Preference
7. IST Agreement 2008 EE Action Time Pickup Time User Id User Name Action Code Action Desc Branch Remarks Click Acquire button adjoining the desired task to acquire it Once you acquire a task it moves from the Pending list to the Assigned list Click the Assigned task list and search for the task you need to perform Double click the required task to open Credit Score screen Click Credit Score tab to specify the details for calculating the credit score BT DL to oer Miah Fiy shinny Brah a BEA ij Dus d AP c b qe aoe Ux ande L g be afre ten Sik Loma am d hp Aripa lapi Ve dicari Dems D e ER Comme Changer Lr egr ee bigi Ge Soe bera uni su P awe PET Ages mi Lae Fal Gore Ete Orel cons Sy fore ore wj raises PR OCEEE sl LE You need to specify the following details here Rule Name The rule associated with the loan product gets defaulted here You can modify this if required 2 31 ORACLE 2 2 8 User Input Score Specify the credit score associated with the customer Automated Score The credit score calculated by the system based on the rules maintained at the product level gets displayed here Agency Code Select the code of the external agency to be approached for calculating the score External Credit Score The score as calculated by the external agency is displayed here Click Score to auto generate the credit score for the customer After calculating the credit sc
8. Liquidate All Comp For amp Date Liquidate Each Comp Across Dates Daily x Complete Accruals ParibiscountiPremium D Frequency Handling of Foreclosure Acquisition Type Credit Score Credit Scoring Holiday Period Rollover Comp E Component Input By Authorized By Date Time Date Time Modification Number For more details on Retail Lending product categories refer chapter Defining Product Categories and Products in this User manual The Credit Score screen is invoked when you click the Credit Scoring button ORACLE 2 3 Z Credit Score Web Page Dialog eF 2 Rule Mame RULEZ E Default Rule Credit Score Rule Expression ue Condition Condition Result C 1 DELINQUENCY _Days o Condition um You can maintain the following details in this screen Rule Name Specify a suitable name for the credit scoring rule Default Rule Check this box if you want to select this rule as the default rule which gets defaulted to the account o You can maintain only one rule as the default rule Line Specify a sequence number to keep track of the number of expressions maintained for that rule name Condition You need to specify the condition to be satisfied for the rule by clicking the Condition button You can specify the condition in the Condition Builder screen which gets invoked 2 4 ORACLE Z Condition Bu
9. record On successful completion the task moves to the Pending task list for the next stage Credit Scoring of the process 2 2 Credit Scoring Credit score of the customer is calculated based on the evaluation of the rule defined for the loan product Only users belonging to the CL SCORE role can perform this task You need to acquire the required task from the pending task list if you have the required rights for the same 2 30 ORACLE E DOCOR1 CHO CHO FLEXCUBE UBS 10 1 0 0 0 0 0 7 3 2000 ENG Transaction Input Microsoft Internet Explorer Actions Operations Options Windows Help Branch Is Online Oracle FLEXCUBE fi Home sign ott SP Ext Help s lle STDCLO06 zl E Search l Workflow Refno TXN REF NO TITLE PARENTID ASSIGNEEGROUPS ASSIGNEEUSERS CUST ID CUST NAME CREATEDDATE o Task Search Credit Mon Oct 20 LoanOriginationProcess310015 Scoring CL SCORE 13 18 51 IST E Standard View Stage 2008 E Pendina 5 Credit Thu Oct 23 E New 3 LoanOriginationProcess350021 Scoring CL SCORE 15 35 27 IST E Assigned o Stage ae B conan Credit Wed Oct 29 ompleted 0 LoanOriginationPracess380096 Scoring CL SCORE 18 59 09 IST E Expired O Stage 2008 E Suspended 0 Betrag Mon Oct 20 LoanOriginationProcess31 0003 CLIS AGREE 12 50 06 IST Agreement 2008 C siomal Mon Oct 20 LoanOriginationProcess310016 CUS AGREE 13 34 44 IST Agreement 2008 Customer Thu Oct 23 LoanOriginationProcess350011 CUS AGREE 14 42 41
10. INPLIT 16 01 30 IST 2008 Input LoanOriginationProcess390018 Details Action Time Pickup Time User Id User Name Action Code Action Desc Branch Remarks Click Acquire button adjoining the desired task to acquire it Once you acquire a task it moves from the Pending list to the Assigned list Click the Assigned task list and search for the task you need to perform Double click the required task to open Verification of customer identity screen 2 27 ORACLE LLLI tol tae r aN E E Bef baste bok ny ey P E p LEE Largue ot exu Li azp m ibr c md e Here you can view all details captured during customer information input If all details are accurate select the action CLEARED from the drop down list adjoining the Audit button Click Save icon in the tool bar to save the record 2 2 6 2 KYC Decision by User The task moves to the Pending task list for the next stage KYC Decision by User of the process Only users belonging to the KYCEROLE role can perform this task If you have the required rights go to the Pending task list and acquire it from the list by clicking Acquire button adjoining the desired task The task moves from Pending list to the Assigned list once you acquire it Search the Assigned task list for the task you need to perform and double click to open KYC Decision by User screen 2 28 ORACLE JD porcos Cee CIAF INR AY K
11. KEE Er ED E de Dt OENLLULU UE ped et as epee Armen COpeaDora Cfo Fie PEE Mur Rape Corpore Cums Cen Ep Abb mum re ut eager e tte ones bee N aa r egen Beagei 00 ris nme Cantica Te Gm AEF Mewing betintiens Linked indies Test a p Lares Geeni ME SEM Segen RE we EC ECH co Check for the accuracy of the details specified in the input stage Select the action PASSED from the drop down list adjoining the Audit button if all details are correct Click Save icon in the tool bar to save the record 2 2 6 3 KYC Decision The task moves to the Pending task list for the next stage KYC Decision of the process Only users belonging to the KYCMROLE role can perform this task If you have the required rights go to the Pending task list and acquire it from the list by clicking Acquire adjoining the desired task The task moves from Pending list to the Assigned list once you acquire it Search the Assigned task list for the task you need to perform and double click to open KYC Decision screen 2 29 ORACLE ee Wing Besse 05 Eet get EI mam Gann Tremere s Gaim At this stage a managerial level check and approval of the customer details is sought If all details are acceptable for the customer select the action PASSED from the drop down list adjoining the Audit button Click Save icon in the tool bar to save the
12. Loan Origination Version 11 0 9ONT1316 ORACLE FC UBS V UM 11 0 0 0 0 0 0 January 2010 Oracle Part Number E51573 01 ORACLE FINANCIAL SERVICES ORACLE Document Control Author Documentation Team Group UBPG NN Created on October 01 2008 Revision No Final EBEN Updated by Documentation Team Reviewed by Approved by Software Quality Development Testing teams Assurance Team Updated on January 07 2010 Reviewed on January 07 Approved on January 07 2010 2010 ORACLE Loan Origination Table of Contents L XBOLDI THIS MANDA WE 1 1 1 1 MOD e TON e 1 1 1 1 1 D 177 777 T T PPR 1 1 1 1 2 OLE NT M N 1 1 1 1 3 Po IOC ICTS siti caries eee MD LM M MEE D ee anes 1 1 1 1 4 COSS ICONE duced ou Hoa ch cg M HI M LE LM me 1 2 2 LOANORIGINA TION ner c DR 2 1 2 PINTO COIN 2 1 2 2 STAGES INVOLVEDIN EE gi 2 1 2 NETO CY CA BLUT RNC 2 2 Ze Mappine Function Jd wilh EEN 2 5 22 3 Input Details for Loan Account EE 2 6 2 2 4 Enrichment of Loan Account Opening Details sesenta 2 22 2 2 9 Verification of Loan Account Opening Details 2 26 2 2 6 OT E LU T 2 27 dud EE 2 30 2 2 8 PCT TmS 2 32 2 2 9 Customer A TOMON censeo is aetna e 2 33 2240 TE 2 35 E GG EE 2 36 1 1 1 About this Manual Int
13. V VFTSV VFTSV NOSTRO You can search for an existing account by specifying any of following as search criteria e Branch e Account Number 2 10 ORACLE e Customer Number If a new account needs to be opened for this loan you need to capture the customer account information using the Input Customer Account screen To invoke this screen click New button adjacent to Customer Account in Input Details screen You can also invoke this screen by typing STDCLAO1 in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button E Input Customer Account Web Page Dialog Branch CHO Customer Number CHOO01702 Account Class Account Number Account Currency USD a Main Auxiliary Hominess Account Facilities First Nominees C Cheque Second Nominees IT Tam _ Passbook Description C CAS Account Dormancy Parameters Type Credit Single Debit Joint Manual Account Open Date E Any Alternate Account Onti Nuhr Dptions C Track Receivable Referral Required C IBAN Required Account Address Instructions Account Status Restriction Currency Limits Statement Limits Joint Holders Interest Charge Standing Instructions Linked Entities MIS Fields Account Signatory Refer the chapter Maintaining Customer Accounts in the Core Entities User Manual for details about this screen You need to specify the f
14. about this screen The following details are defaulted in this screen Branch The unique identification code of the branch gets displayed here Workflow Number Workflow number is automatically generated by the system User Defined Status User Defined Status is displayed as NORM by default You need to specify the following details here Product Category Select the category of the product you wish to use from the option list provided Product Code Select the identification code of the product you wish to use from the option list provided Click Def button adjacent to Product Code Maturity Date gets defaulted You can modify this if required Currency Select the transaction currency from the option list provided 2 2 3 2 Query Existing Customer Input New Customer Details You can query and check if the customer is an existing customer of the bank in the Customer Information screen To invoke this screen click Qry button adjacent to Customer Id in Input Details screen You can also invoke this screen by typing STSCLCIF in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button 2 7 ORACLE Z Customer Information Web Page Dialog Authorization Status uthorized Record Status Customer Mo Customer Type Name Short Name Liability Number Customer Category CORPORATE Country Nationality 3 Language Exposure EH Location Z SSN Sear
15. al System Task Hot required Customer acc creatian System Task Collateral Creation System Task Loan Creation System Task i End of application Entry Approwvexl You need to maintain the following details before you start with the loan origination process e Maintaining Credit Rule e Mapping Function Id with Policy Code 2 2 1 Maintaining Credit Rule You need to maintain the rules for calculating the credit score of a customer You can do this in the Credit Score screen which can be invoked by clicking Credit Scoring in the Preferences tab of Retail Lending Product Maintenance screen 2 2 ORACLE 2 Product Maintenance Web Page Dialog Product Code Product Description Main Preferences Components Notice amp Statements Rate Normal variance Max Variance Rate Type a Rate Middle Rate Buy Sell Rate Holiday Treatment for Maturity Value Dates Include Branch Holiday IT Ignore Holidays Move Across Month Use Facility Currency Use Contract Currency Use Local Currency Local Schedule Movement Move Forward Move Backward Holiday Check Holiday CCY Account Preferences Pass Book Facility Atm Facility Track Receivable aliq Amend Past Paid Schedule Check Book Liquidate Back valued schedules Interest Statement Back Period Entry Allowed IT Special Interest amp ccrual CL Against
16. ch Advanced Search Reset Records per page 15 Tia Of 1 v vr 30 to Page Authorization Status Record Status Customer No Customer Type Name Short Mame Liability Number Customer Category Country Nationalit e Authorization Status Record Status amp Authorized C Closed You can search for an existing customer by specifying any of following as search criteria e Authorization Status e Record Status e Customer Number e Customer Type e Name e Short Name e Liability Number e Customer Category e Country e Nationality e Language e Exposure e Location e SSN If the loan applicant is a new customer you need to capture the customer details using the Input Details Customer Information To invoke this screen click New button adjacent to Customer Id in Input Details screen You can also invoke this screen by typing STDCLCO 1 in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button 2 8 ORACLE a Input Details Customer Information Web Page Dialog Customer No CHOO01 701 Liability Number Customer Type Short Name NODDY Full Name Branch Code CHO Individual Corporate Bank Main Auxiliary Corporate Custom Credit Report Address For Correspondence Geographic Status Name Country Address Swift Code Fax Group Code Charge Group Clearing Group Tax Group Nationality Language Ex
17. d in the sub stage Review In the Enrichment Details screen you can perform the review by selecting an action in the textbox adjoining Audit button If you select AUTOMOVENEXT option in sub stage NEW the next sub stage for REVIEW is acquired automatically If you select MOVENE ST option in sub stage NEW you need to acquire the next stage for REVIEW manually nce usher ao PSA oe ee tub Eae KEYEN ken Account Denis DefauB Ceci Lit VUE Compo Changes Linked ficou heise Dirbama ki Cnculale Gres Principal Prioris IE j WT Ten a n E PROCEED In the REVIEW sub stage you can select any of the following actions If you select MOVEPREV option in sub stage REVIEW the work flow moves to the previous stage Enrichment Detail screen with sub stage NEW and has to be manually acquired If you select PROCEED option in sub stage REVIEW the next stage for Verification Details can be acquired You need to save the details in the Enrichment Detail screen by selecting PROCEED action and then clicking Save icon in the tool bar On successful completion the following screen gets displayed 2 25 ORACLE E Information Web Page Dialog MESSAGE REFERENCE di The taskis completed successfully LCIP O04 The task moves to the Pending task list for the next stage Verification of the process 2 2 5 Verification of Loan Account Opening Details All details speci
18. d with the vehicle Id Number Specify the unique identification number associated with the vehicle Reg Number Specify the registration number of the vehicle 2 17 ORACLE E Assets Web Page Dialog Valuations Vehicle Home Others Class Status Address Type SubType Occupancy Remarks Priority PE rumes Cancel You can specify the following additional details for home type of asset Occupancy Specify the number of people occupying the house Width Specify the width associated with the selected asset Length Specify the length associated with the selected asset PO Specify the post office number of the location of the property GEO Specify the property GEO code Geospatial Entity Object Code for the asset BNA Specify the census tract BNA code Block Numbering Area for the asset MSA Specify the metropolitan statistical area MSA code for the asset Click Ok to save the details and return to Input Details screen 2 2 3 Financials Tab You can capture the income or liability details of the customer in the Financials screen To invoke this screen click Financials in Input Details screen 2 18 ORACLE 15 Financials Web Page Dialog Financials Liability Other Income Source Currency Amount AUD a 1 000 000 00 You can specify the following details related to the customer s income here Type Select the type of the income from the opt
19. e Dialog MESSAGE D Once you acquire a task it moves from the Pending list to the Assigned list Click the Assigned a The Task was successfully Acquired REFERENCE COO task list and search for the task you need to perform 2 23 ORACLE Ji VEE CHO CHO FLEXCUBE UBS 10 2 0 0 0 0 0 03 07 2000 ENG Transaction Input Microsoft Internet Explorer E m EA rani Crate LEX CLUE LIP KSAM SEA IEN RI MO THLE PABENIL Aal GROUP ASSN US CUusSIE LUESPHAM CREA TUD DATE TIA LLU LECT ARUP FH OF RES Liani ainra 4 L 1 Oa AA CH Delnds DT DS n 2008 DI Corpais O Geet Cl Suspect Heras F 3 Enrichment Details Web Page Dialog Partt E Account buber ro j Ai Aer We A pp amp cabon amii Venns X 120007 User Deere tah Produci Category Lou iiit tidi E User Reference Mumber CHOISAFOTTEADOSX Sub Stage MN eco ek aia Giria kt Customer Hee CHOTIS Currency ines Beek nada Customer occu Cust Ace Branch CHO Co Ace L Cakculate Crops Principal Col ev ni NA Ler France Diarani Hel Price W s Deia EK Hahay De ZOCCO 2 24 ORACLE Click Modify in Account details tab to modify the customer account or collateral details The Enrichment Details stage also has two sub stages where you can perform a review of modified details i e the NEW sub stage and the REVIEW sub stage The details input during the sub stage New can be reviewe
20. e the required task from the pending task list if you have the required rights for the same E DOCOR1 CHO CHO FLEXCUBE UBS 10 1 0 0 0 0 0 7 3 2000 ENG Transaction Input Microsoft Internet Explorer Actions Operations Options Windows Help 8 branch Is Online Oracle FLEXCUB ff Home Sign Off E Exit 9 Help s lle cLDORO05 l d EM BV Workflow Refno TXN REF NO TITLE PARENTID ASSIGNEEGROUPS ASSIGNEEUSERS CUST ID CUST NAME CREATEDDATE LH Search Thu Oct 30 Ed tardan Viti LoanOriginationProcess400019 vere CUS AGREE 17 54 40 IST E Pending 117 pap Input Agreement E Assigned 8 LoanOriginationProcess380092 Details CL INPUT 12 32 48 IST E Completedc129 2008 Wed Oct 29 Expired 0 0 prea LoanOriginationProcess390016 Input CL INPLIT 15 58 04 IST E Suspended 0 Details Hes Wed Oct 29 CL INPUT 16 00 03 IST 2008 Wed Oct 29 CL INPUT 16 01 30 IST 2008 Wed Oct 29 CL INPUT 18 02 07 IST 2008 Thu Oct 30 CL INPUT 16 48 05 IST 2008 Thu Oct 30 Dosis CL INPUT 16 56 28 IST 2008 Hm nm 2008 Input LoanOriginationProcess39001 7 Details Input LoanOriginationProcess390018 Details Input LoanOriginationProcess390026 Details Input LoanOriginationProcess4000165 Details LoanOriginationProcess40001 7 LIITLLLT1 Action Time Pickup Time User Id User Name Action Code Action Desc Branch Remarks Click Acq
21. e valuation 2 15 ORACLE Wholesale opecify the wholesale rate associated with the asset selected Retail opecify the retail rate associated with the asset selected Usage Specify usage level at the time of the valuation Usage Value Specify the initial usage value Total Specify the total usage of the asset E Assets Web Page Dialog Valuations Vehicle Home Others Class z Status z Address Type SubType You can specify the following common details associated with asset of type vehicle or home Class Select the class associated with the asset selected from the option list The following options are provided e New e Used Status Select the status of the asset selected from the option list The following options are provided e Active e Inactive 2 16 ORACLE e Inventory e Undefined Type Specify the type of the selected asset here Sub Type Specify the subtype associated with the asset if any Year Specify the year of association with the selected asset Make Specify the make of the selected asset For vehicle you can specify the manufacturing company name and for home you can specify the name of the builder or developer Model Specify the model of the selected asset Address Specify the address associated with the asset You need to specify the following details additional related to vehicle type of asset Body Specify the body number associate
22. ecify the validation policy from the option list provided Policy Code Select the validation policy to be attached to the function selected For more details on Retail Lending product categories refer chapter Defining Product Categories and Products in this User manual 2 2 3 Input Details for Loan Account Opening The following activities constitute this task e Keying in loan account details e Uploading relevant documents e Capturing Asset Details e Capturing Financial Details e Querying existing customer details or specifying details for a new customer e Querying existing customer account details or specifying details for a new customer account e Querying existing collateral details or specifying details for a new collateral Users belonging to user role CL INPUT are authorized to perform these tasks 2 2 3 1 Key in loan account details You need to key in all details required for loan account opening as part of this activity You can specify the details for loan account opening in Input Details screen You can invoke this screen by typing CLDOROO01 in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button T input Dotais Web Page Dialog n ren Te we ene Ty eWinmwNK 1 Le Darei Satis kan Acocnunt Deier fete Check Lich UDF Componente Changes L Acco net ada 2 6 ORACLE Refer the chapter Account Creation in this user manual for details
23. ential 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 The loan origination process involves the following steps e Input Details for Loan Account Opening e Enrichment of Loan Account Opening Details e Verification of Loan Account Opening Details e KYC Check e Credit Rating e Check whether Approval is required for Credit Rating e Approval of Credit Rating e Contract Generation e Customer Approval e Funding gt Creation of Customer gt Creation of Customer Account gt Creation of Collateral gt Creation of Loan Only users who have procured the relevant access rights can perform activities under a stage The following diagram illustrates the series of events involved in the process of loan origination 2 1 ORACLE Start App Entry Human Task Input of Loan CIF details and upload of documents Enrichment of Loan CIF CASA and Collateral i Verification Stage Verification Result Approved NYC Sub Process KYC Result Appapaext Input of Loan CIF details and upload of documents Credit Sco ring Result Approwed Rejectex Business rule Evaluation for approval i Approval required Credit score approval Customer agreement Customer acceptance Acceptance result Customer creation Approv
24. etails can be acquired You need to save the details in the Input Details screen by selecting PROCEED action and then clicking Save icon in the tool bar On successful completion the following screen gets displayed E Information Web Page Dialog g MESSAGE REFERENCE a The task is completed successfully LCIP O04 The task moves to the Pending task list in the Tasks menu for the next stage Enrichment of the process 2 2 4 Enrichment of Loan Account Opening Details At this stage you can perform an enrichment of the details specified in the previous step You can modify or update any of the following details if required e Loan Details e Customer Details e Customer Account Details 2 22 ORACLE e Collateral Details Only users belonging to the CL ENRICH role can perform this task You need to acquire the Enrichment task from the pending task list if you have the required rights for the same 3 DOCOR1 CHO CHO FLEXCUBE UBS 10 1 0 0 0 0 0 7 3 2000 ENG Transaction Input Microsoft Internet Explorer Actions Operations Options Search E Task Search E Standard View E Pending 115 E New 2 E Assigned 1 E Completed 0 E Expired 0 E Suspended 0 Windows Help 9 Branch Is Online aA 411 Home A Sign Oft Eat Exit Help s a eESESESEE eEeEEEEEEEE Workflow Refno
25. existing collateral by specifying any of the following e Authorization Status e Record Status e Liability Identification e Collateral Code If you need to create a new collateral for the loan you can capture the collateral details in the Input Collateral Details screen To invoke this screen click New button adjacent to Collateral in Input Details screen You can also invoke this screen by typing CLDCO001 in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button 2 12 ORACLE E Input Collateral Details Web Page Dialog Liability Identification ASSOO1TET a C Market Value Based Collateral Code N WCOLL AT Collateral Currency USD A Market Value Based Collateral Details Offset Margin Security Code Lendable Margini Number af Units Nominal alue Limit Contribution Cap Amount Type Price Code Collateral Value Last Reval Price Start Date gawaran PS Expiry Date Revision Date Description Si lgsuer And Exposure Details F Issuer Code Issuer Exposure Line Exposuref Exposure Amount Fields Refer the chapter Maintaining Collateral Details in Central Liabilities User Manual for details about this screen Specify the following mandatory details for collateral creation Liability Identification Select the credit line to which you want to link the collateral The credit facilities granted to a custo
26. fied during loan account opening are verified during this activity A verifier checks for any errors input during the previous stages The process moves to the next stage once the verifier approves the details The process moves back to the Enrichment stage on rejection of the details by the verifier Only users belonging to the CL AUTH role can perform this task You need to acquire the Verification task from the pending task list if you have the required rights for the same Click Acquire button adjoining the desired task to acquire it Once you acquire a task it moves from the Pending list to the Assigned list Click the Assigned task list and search for the task you need to perform Double click the required task to open Verify Details screen ELLE Logs SEP Murs Aun Des Deal check Lb LIES Cie Oe L amp esger OB Wa r raul Ge miu Here you can view all details captured during the input stage If all details are accurate select the action APPROVE from the drop down list adjoining the Audit button Click Save icon in the tool bar to save the record 2 26 ORACLE On successful completion the task moves to the Pending task list for the next stage KYC Review of the process 2 2 06 KYC Review After verification of the loan account opening details KYC Know Your Customer check is initiated for a new customer In case of an existing customer this check is carried out
27. ilder Web Page Dialog Field DELINGQUENCY DAYS LC Operator Equal To m Condition DELINQUENCY DAYS Value 0 Element Y Logical Op e Mathematical Op v To specify the condition you need to select the field name operator and the value and click Accept Result Specify the expected result of the condition to be satisfied 2 2 2 Mapping Function Id with Policy Code You need to maintain a mapping of the various stages of the workflow with the policies to be used for validating the details in each stage At each stage validation of the details specified is carried out by executing the policy associated with that stage You can maintain the mapping in Product Category screen You can invoke this screen by typing CLDPRCMT in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button A Product Category Web Page Dialog Product Category LOANS1 Scoring Resolve Rule SCH a DESC Cycle Code Product Category Policy O Policy Code Event Code TC pm 7Z ACCR aZ Product Stage Policy Function Policy Code TT cLDOROO1 a PL2 Product Rule UDF Input By DOCOR1 Date Time Modification Number E Open Authorized By Date Time El Authorized 2 5 ORACLE You need to specify the following details to perform the mapping between the function and the policy code Function Select the loan origination function for which you want to sp
28. ion list provided Source Specify the source of the income Currency Select the currency associated with the income from the option list provided Amount Specify the amount associated with the income Comment Specify any remarks or comments for the income 2 2 3 8 Liability Tab You can capture the liability details here 2 19 ORACLE 25 Financials Web Page Dialog Financials Liability Other Income Account Type Currency Amount Frequency Balance RB 5 000 00 Monthly Here you can specify the following details related to the customer s liability Type Select the type of the liability from the option list provided Account Type opecify the account type associated with the liability Currency Select the currency associated with the liability from the option list provided Amount opecify the amount associated with the liability Frequency Select the frequency at which payments are made towards the liability The following options are possible e Daily e Weekly e Monthly e Quarterly e Half Yearly 2 20 ORACLE e Yearly Balance opecify the current amount outstanding Comment opecify any remarks or comments to be associated with the liability 2 2 3 9 Other Income Tab You can capture other income details here J Financials Web Page Dialog Financials Liability Other Income Other Incomes E Seq No Currency Amount Frequency P SALARY ajau 5 10 000
29. mer will be tracked against this liability code Collateral Code Specify the code of the collateral for which you are maintaining details Collateral Currency Select the currency of the collateral from the option list provided Type Select the type of security that you accept as collateral from the option list Offset and Lendable margins are defaulted based on the collateral type selection 2 13 ORACLE Collateral Value opecify the contribution that the collateral should make to the credit limit of the customer This is applicable can only for non marketable collaterals Click Ok to save the details specified and return to Input Details screen The collateral Id gets defaulted in Input Details screen Specify the other mandatory details in the Input Details screen and click Default to auto generate the following details e Account Number e Alternate Account Number e User Reference Number 2 2 3 9 Upload Relevant Documents You can upload the relevant documents for loan account opening using Upload Documents required for each stage screen To invoke this screen click Documents button in Input Details screen E Upload the documents required for each stage Web Page Dialog Document Upload Document Code Document Description Document Path Upload View boc a DOC WE Browse Upload View Here you need to specify the following details Document Code S
30. ollowing details here Account Currency Select the currency associated with the customer account from the option list provided Account Class Select the class of the customer account from the option list provided Click P button to generate the account number automatically Specify the mandatory details for account creation and click Ok The details specified are saved and the control returns to Input Details screen The customer account and account currency get defaulted in Input Details screen 241 ORACLE 2 2 3 4 Query Existing Collateral Input New Collateral Details You can query and choose existing collateral for the loan in the Collaterals Summary screen To invoke this screen click Qry button adjacent to Collateral in Input Details screen You can also invoke this screen by typing CLSCOLLT in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button e Collaterals Summary Web Page Dialog Authorization Status uthorized Record Status Liability Identification CHOO02544 Ko Collateral Code Search Advanced Search Reset Records per page 15 z Kika Of 1 TT Authorization Status Record Status Liability Identification Collateral value Offset Margin Limit Contribution Start Date Expiry Date Collatere E E Authorization Status Record Status A Authorized C Closed U Unauthorized O Open You can search for
31. only if the customer details have been modified during the enrichment stage This task consists of three sub task performed at the Regulatory Supervisory and Managerial levels 2 2 6 1 Verifying Customer Identity The first stage in KYC check is the verification of customer identity This task needs to be performed for new customers and also for existing customers if the customer details are modified in the enrichment stage Only users belonging to the CMROLE role can perform this task You need to acquire the required task from the pending task list if you have the required rights for the same E DOCOR1 CHO CHO FLEXCUBE UBS 10 1 0 0 0 0 0 7 3 2000 ENG Transaction Input Microsoft Internet Explorer Actions Operations Options Windows Help 8 branch Is Online Arac m Pd e am PUE Ame 411 Home A Sign Off a Exit 9 Help EH mp STDCLOO2 a JES EA Workflow Refno TXN REF NO TITLE PARENTID ASSIGNEEGROUPS ASSIGNEEUSERS CUST ID CUST NAME CREATEDDATE H Search Inform Wed Oct 29 i KY CReview 390021 Regulatory String CMROLE 17 20 35 IST ee ew Authority 2008 E Pendina 117 Wed Oct 29 E New amp LoanOriginationProcess 380092 Input CL INPUT 12 32 48 IST Details E Assigned 5 2008 Wed Oct 29 Completed O D e SR LoanOriginationProcess390016 SE CL INPUT 15 58 04 IST IBI Expired 0 alls 2008 E Suspended o Ed Wed Oct 29 LoanOriginationProcess39001 7 E A CL INPLIT 15 00 03 IST Details 2008 Wed Oct 28 CL
32. ore select PROCEED from the drop down list adjoining the Audit button Click Save icon in the tool bar to save the record On successful completion the task moves to the Pending task list for the next stage Credit Evaluation of the process Credit Evaluation At this stage evaluation of the calculated credit score is carried out Only users belonging to the CL SCRVERIFY role can perform this task You need to acquire the required task from the pending task list if you have the required rights for the same Click Acquire button adjoining the desired task to acquire it Once you acquire a task it moves from the Pending list to the Assigned list Click the Assigned task list and search for the task you need to perform Double click the required task to open Credit Evaluation screen PI de DIMRSSULM IET Wurm Bed Deep Dem Cents TEX ree o f Armed Gof ege 2 32 ORACLE Check if the credit score calculated in the previous stage needs approval If the credit score can be approved select APPROVE from the drop down list adjoining the Audit button Click Save icon in the tool bar to save the record On successful completion the task moves to the Pending task list for the next stage Customer Agreement of the process 2 2 9 Customer Agreement The loan contract agreement is generated at this stage Only users belonging to the CUS AGREE role can perform this task You need to acquir
33. pecify a unique code to identify the document to be uploaded Document Description Give a brief description for the document Document Path Specify the directory location from where the document has to be uploaded Upload After specifying the document path click this button to upload documents 2 14 ORACLE Click Upload button to upload the documents Once the documents are uploaded click Ok to save the details and return to Input Details screen 2 2 3 6 Capture Asset Details You can capture the details corresponding to the collateral being provided for the current loan in the Assets screen To invoke this screen click Assets in Input Details screen E Assets Web Page Dialog Valuations Vehicle Home Others Valuations E Assets ValuationDt Source Supplement Edition Wholesale Usage E Remarks Priority EN Cancel Here you can specify the following details related to your assets like vehicle home etc Assets Select the type of asset from the drop down list The following values are provided for selection e Vehicle e Home e Others Valuation Dt Specify the valuation date for the selected asset or select the date by clicking Calendar button Source Specify the source associated with the asset selected Supplement Specify the supplement of the valuation source used for the valuation Edition Specify edition of the valuation source used for th
34. posure Location Unique Identifier Name Value xref Customer Category Customer Classification Exposure Category CHOO01 701 IT CRM Customer Mailers Required CLS Participant C Issuer Customer Treasury Customer FX nett Customer mis Standing Instructions Linked Entities Text Image Group Limits CLS Restrictions UDF son Issuer Refer the chapter Maintaining Customer Information in the Core Entities User Manual for details about this screen Here you need to specify the following mandatory details for creating a customer Liability Number The credit facility granted to any customer is tracked against the liability number of the customer The default liability number of a customer is the same as his customer code You can also select an existing liability number from the option list provided Short Name Specify the customer s abbreviated name The name that you capture here is unique for a customer Full Name opecify the full name of the customer here Name Specify the name of the customer to be used for all correspondence sent from the bank These characters should conform to SWIFT standards Address Specify the mailing address of the customer in the four rows that are provided All characters should conform to SWIFT standards Country Select the country as given in the address of correspondence of the customer from the option list provided 2 9 ORACLE
35. roduction This manual is designed to help acquaint you with the Loan Origination module of Oracle FLEXCUBE It provides an overview of the module and guides you through the various steps involved in granting loans to the customers of your bank In addition to this User Manual you can find answers to specific features and procedures in the Online Help It can be invoked by choosing Help Contents from the Help Menu of the software You can further obtain information about to a particular field by placing the cursor on the relevant field and striking the F1 key on the keyboard Audience This manual is intended for the following User User Roles Back office data entry clerk Input functions for contracts Back office managers officers Authorization functions Product Managers Product definition and authorization End of Day operators Processing during End of Day Beginning of Day Financial Controller Product Managers Generation of reports Organization This manual is organized into the following chapters Chapter 1 About this Manual gives information on the intended audience It also lists the various chapters covered in this User Manual Chapter 2 Loan Origination Loan Origination describes the different stages involved in capturing a loan application along with mandatory documents and prerequisites Related Documents You may need to refer to any or all of the User Manuals while working on the Loan Origination mod
36. screen 3 Customer Acceptance Web Pape Dialog Mein cecum Dishes eimi Creche UDF Components Changes Linkages Advices Dei Mag test Credi Score Account Details Cuito mes kj Calle Groit Prineigod Codd ev ni rere Firowgc ei If all the details specified are acceptable to the customer select ACCEPT from the drop down list adjoining the Audit button Click Save icon in the tool bar to save the record On successful completion the task moves to the Funding stage which is an automated stage 2 35 ORACLE 2 2 11 Funding This is an automated stage where accounts are created automatically on successful completion of the previous stages The following are created automatically e Customer e Customer Account e Collateral 2 36 ORACLE ORACLE Loan Origination January 2010 Version 11 0 Oracle Corporation World Headquarters 500 Oracle Parkway Redwood Shores CA 94065 U S A Worldwide Inquiries Phone 1 650 506 7000 Fax 1 650 506 7200 www oracle com financial services Copyright 2010 Oracle Financial Services Software Limited All rights reserved No part of this work may be reproduced stored in a retrieval system adopted or transmitted in any form or by any means electronic mechanical photographic graphic optic recording or otherwise translated in any language or computer language without the prior written permission of Oracle Financial Services Software Limited
37. uire button adjoining the desired task to acquire it Once you acquire a task it moves from the Pending list to the Assigned list Click the Assigned task list and search for the task you need to perform Double click the required task to open Customer Agreement screen 2 33 ORACLE PITT Agreement D ve Appiah aera Product Ces Main Account Detalu Accecirng Dalaba Cutbome kj UG unrecuy Cutters Lif Cue amp Ces Cola er ni irapa ant Free Mai Princi volum ala Lishurib Dais Web Pape Dialog Account Humber Aarts ff iS Piht Coe Liner Reference prier BE SCC Ben Lise Diete 503 iss CHEF Z IT EO Sun Siege nil Cueto Mame CHOOLEIB fetes Exch ato Ort Are Eresch HG Cniculale Gross Erres Check if all the details specified are acceptable If all details are correct select PROCEED from the drop down list adjoining the Audit button Click Save icon in the tool bar to save the record A Customer Loan Agreement report can be generated by clicking the Agreement button Customer Loan Agreement Branch CH User Id VEE BAHE OF INDIA Unit 1 Bleck A California USA USA daa l2 church street Date o3 JUL 2000 Application Ho 03 JUL 2000 12 NOV 08 18 19 33 Branch Date Date amp Time PLEASE WOTE THAT A LOAN WITH THE FOLLOWING DETAILS HAS BEEN SIMULATED Account Ho CHOPROZO01850018 Currency UED
38. ule e Core e Procedures e Settlements e Interest e User Defined 1 1 ORACLE 1 1 4 Glossary of Icons This User Manual may refer to all or some of the following icons tone Function NN a pore Liquidate Sign off Refer the Procedures User Manual for further details about the icons 1 2 ORACLE 2 1 2 2 2 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 For opening a loan account the bank needs to receive the relevant set of documents for verification The details of the loan account customer and collateral are captured The details are verified and a Know Your Customer KYC check is carried out A credit rating is performed for the customer who clears the KYC check Approval of the credit score is sought in case required On approval of the credit score customer customer account collateral and loan are created in the system Stages Involved in Loan Origination The process of loan origination consists of several manual as well as system tasks carried out in a sequ
Download Pdf Manuals
Related Search