Home
        Corporate Loan Origination
         Contents
1.                       Specify the following details    Formula    Ratio Type  Select the ratio type from the adjoining drop down list  This list displays the following values   e Stated Before  e Stated After  e Actual Before  e Actual After    228 ORACLE       Condition    Specify the condition here  You can also maintain the condition in the    Condition Builder  screen which is invoked by clicking the    Condition Builder    button   Sel                Condition  undefined  7a                 Business Rule    Braces        Te    i  as    C i          Specify the following details     Condition  Specify the condition for the rule here     Business Rule       Braces  Select the braces from the adjoining drop down list     Functions  Select the functions from the adjoining drop down list     Elements   Select the elements from the adjoining option list  This list displays all valid elements  maintained in the system    Operators    Select the mathematical operators from the adjoining drop down list  This list displays the  following values     e Equal To   e Greater Than   e Greater Than or Equal To  e Less Than   e Less Than or Equal To   e Like   e NotLike   e Not Equal To    oe ORACLE       Logical Operators  Select the logical operators from the adjoining drop down list  This list displays the following    values    e And  Use    And     e Or  Use    OR     Value    Specify the value of the SDE to define the condition  The value may be numeric or  alphanumeric  as require
2.           gt                   lt  gt       gt        lt          AND    or    OR        Viewing Override Summary       You can view a summary of the overrides in    Override Maintenance    screen  You can also  query for a particular record based on desired search criteria     a ORACLE       2 13       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    Cf advanced Search Reset    Authorization Status Record Status                Process Code z Application Category                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     Maintaining Document Details       You can maintain the list of documents that are required during the loan origination process   in    Documents Verify Maintenance    screen  Document checklists are maintained for an  application category and for the various stages in the origination process  You can also  maintain the details of the Advices that need to be generated on completion of a stage in the  process     aa ORACLE       You can invoke    Documents Verify 
3.         You can specify any of the following details to search for a record   e Authorization Status  e Record Status  e Enquiry ID  e Customer Number    ae ORACLE       2 6    2 6 1    e First Name  e Last Name  e Contact Number    Click    Search    button to search for a record based on the search criteria specified  You can  double click a desired record to view the detailed screen     Maintaining Credit 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  E  New  amp  enter Query  Rule Id    Account Description    Type   Retail     ET  Risk Factor  Question Details  1 Of 1    m Questionid  Category Question       Answer Details  10f1                Sequence Number   Possible Answer                   Rating   Auto Decision    Maker Date Time   Checker  Date Time     Mod No Record Status  Authorization Status       You can specify the following details in this screen     Rule ID  Specify a unique identification for the credit rating rule     Description  Specify a suitable description for the 
4.       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  System displays the name of the commenter     Comment Date  The system displays the date on which the comment was added     Capturing Document Details       You can capture the customer related documents in central content management repository  through the    Documents    screen  Click    Documents    button to invoke this screen     200 ORACLE         Documents                            Document Category   Document Reference   Document Type   Remarks Ratio Upload Upload View                   Here  you need to specify the following details     Document Category  Specify the category of the document to be uploaded     Document Reference  The system generates and displays a unique identifier for the document     Document Type  Specify the type of document that is to be uploaded     Ratio Upload    Check this box to view the calculated financial ratios  which is obtained by uploading the excel  sheet  balance sheet  income statement  statement of cash flows etc       On clicking the    Vertical Analysis    button  system displays the calculated ratios in ratio tab of  underwriting stage    Upload    Click    Upload    button to open the    Document Upload    sub screen  The    Document Upload     sub screen is displayed below       Documents    El Ad
5.     Header    Body of the Report    The contents of the report are discussed under the following heads     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     The following details are displayed in the report        Field Name    Field Description       Branch    This is the branch       Product code    This is the product code       Application Num   ber    This is the loan application number       Stage    This is the stage at which the application lies       Application Date    This is the date on which the application was made       Contract Date    This is the date of the contract       Contract Currency    This is the currency of the contract       Contract Amount    This is the total contract amount       Contract Term    This is the total term of the contract       Contract Rate    This is the rate of interest applicable       Total          This indicates the branch total       ee ORACLE          Cc   CLRPCAUR    oseere 2 4  CLRPCAUR          ee 2 4  CLRPEFCR wicne ein Sete 2 3  CLRPFNCR          ee 2 2  CLRPPFCR iiac 2 1  GLRPPEGR  xeccsiccsceceaieiits 2 1    CLRPUNMU       2  Function ID Glossary    ORACLE       
6.     The applicant will be  verified for the external  KYC check       ORDCLEKC       PROCEED   CANCEL          2 46    ORACLE          Stage   Stage Title    Description    Function ID    Exit point       5 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    ORDCLUND    VERIFY  PROCEED   RETURN   CANCEL       6 Loan  Approval    Facility Approval    ORDCLAPR    PROCEED   RETURN   CANCEL       7 Document  Verification    Document Verification  Final Verification  Customer Creation  Loan Account Creation    Advice Generation    ORDCLDVR    PROCEED   RETURN   CANCEL       8 Manual  Retry             This stage is optional   Task will be moved to  this stage only when the  system is unable to cre   ate Customer  Cus   tomer Account  Liability   Facility  Collateral  pool   Loan  You can make the  necessary changes  amp   retry        ORDCLMCU       PROCEED       The stages are explained in detail in the sections that follow        Step 1 Application Entry    In this stage  the bank receives an application requesting for the creation of a facility from a  prospective borrower customer  The relevant documents and financial statements are also  provided by the customer  If the applicant borrower does not have an account but intends to  open one  the ba
7.     ee eccccceeeeeteee eee eenneeeeeeenaeeeeeeeeaeeeeeeeeneeeeeeenaaes 2 30  2 12 Viewing Override SUMMALY            ccceeeeeeeeeeeeeeeeeeeeeaaeeeeeeeaaeeeeeeeaaeeeeesenteeeeeeeaes 2 31  2 13 Maintaining Document Details    ee eeceeee eee enneeeeeeeeeeeeeeeeeaeeeeeeeeaeeeeeeeaaes 2 32  2 14 Viewing Document Checklist SUMMALY            cece eeceeee eee eeeeeeeeeettaeeeeeetnaeeeeeteaaes 2 34  2 15 Maintaining Application Category Details         0     eeccceceeeeenteeeeeeeeeneeeeeeettaeeeeenenaaes 2 35  2154 Main TaD tice ect soc tented nn EAEN A tate en erate eee E EATE EA R eet 2 36  2 1 9 2  AQCNCY FAD ites eel iit hes dessa dade i eiA ania ARRAT A EAER A sevice EEC liens tae 2 37  2 16 Viewing Application Category Summary            cece eeteeeeeeeetteeeeeeeeneeeeeeetaeeeeeeenaaes 2 38  2 17 Maintaining Pricing Details eec rerea e Ea AEA EEE EAEEREN 2 39  2 18 Viewing Pricing Details Summary         sseseessssseeessrneserernneesrnnnnesenenneentnnnnesentnneeenanane 2 40  2 18 1 Maintaining Pricing Formula          ccccccceceeee cee tnnneeeeetnnneeeeeetnneeeeeetiaeeeeneeaa 2 41    2 18 2 Maintaining Pricing ORe sssri ieia aarin na Aa Aia 2 43    2 19 Stages in Corporate Loan Origination            eceeeeeeeeeeeeeenteeeeeeeenaeeeeeeeeaeeeeeeeaes 2 44    2 19 1 Process Flow DISINI irria e e anr E AAEE VERITE AT AE E 2 45  219 2  Proce SS  MAID aa a aaa a a A aA A aa A a e 2 46  254913  Main Tabs are E OAO AE A ahs 2 49  2 19 4     Details Tab rrii airian nii iE EAE AAEE EAE a
8.     ial    a  Account Class Details  101                       Ea  Account Class Account Description  La       Enim     No of Installments Units Frequency Rate Code Default  Daily    6                Maker Mod No       You can specify the following details in this screen   Application Category   Specify a unique identification for the loan application category   Category Description   Specify a suitable description for the loan application category     Rule ID    Specify the credit rule to be associated with the application category or select the Rule Id from  the option list provided     Ratio ID    Specify the credit ratio to be associated with the application category or select the Ratio Id  from the option list provided     Pricing Group  Specify the pricing group  The pricing group comprises of the multiple pricing IDs containing    formula   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     238 ORACLE       2 15 2    Default    Check this box to indicate if the loan product selected should be maintained as the default  product for the application catego
9.    Cash Flows    You can capture the following details corresponding to the loan applicant   s cash flows     Operations Activities  Specify the cash flow value associated with the operation activities of the corporate customer     Investing Activities  Specify the cash flow value associated with the investing activities of the corporate customer     Loan Activities  Specify the cash flow value associated with the loan activities of the corporate customer     Credit Application       The details associated with how the corporate customer has deployed his assets need to be  captured as part of assessing the risk associated with the loan proposed  You can capture the  following details related to the credit application    Borrower Profile   Specify the details corresponding to the profile of the corporate customer   s customer     Financial Performance   Specify the details corresponding to the financial performance of the corporate customer   s  customer    Borrower Market Position   Specify the details corresponding to the market position of the corporate customer   s  customer    Risk and Mitigants   Specify the details corresponding to the risk and mitigants associated with the corporate  customer   s customer    Risk Department Mitigants   Specify the inputs from risk department related to the risk mitigants associated with the  corporate customer   s customer    Risk Department Assessment   Specify the risk department   s assessment corresponding the corporate customer   
10.    Leadid Application Number   f    Product Code   Enquiry ID La User Reference   _  Description i  Priority Low    Application Branch 000 Status   New Application X  Application Date 2011 01 04    _     Main Details Financials Requested Limits Collateral Credit Score Bureau Ratio Loan Component Charges Investigation Comments   Stated Analysis  Assets Vertical Analysis  Liabilities  Net Worth  Ratios  10f1 E     Ratios   Description Actual  gt   Documents   Tradeln   KYC Review   CustomerDedupe   LoanDedupe   Customer MIS   Customer AccountMIS   Customer AccountFields   a  Previous 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 on the    Calculate    button to calculate the ratio has to be specified  Bureau Tab    You can interface with external credit bureaus and view report obtained from them in    Bureau     tab     ate ORACLE       Corporate Loan Underwriting Stage  les  Save     Hold    Application Category   Leadid Application Number    Product Code   Enquiry ID la   User Referenc
11.    Vehicle Evaluator                                         Vehicle Details  Valuation Source INTERNAL Model  Identification Number Body  Year Usage  Make  Vehicle Valuations  Wholesale Value Attribute Value  Retail Value Total Value  Usage Value  Vehicle Attributes  10710  Attribute Description Attribute Code Attribute Value Package Included o  A o             In this screen  you can view the information available for the vehicle based on the information  provided by you  If the information in this screen matches the details available in the system  database for the same vehicle  the status is updated to    COMPLETED     in the collateral tab  If  it does not match  then the status is updated to    NO DATA        Once the verification is completed  you can select the Outcome as    PROCEED     and move to  the next stage     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     218 ORACLE       2 19 18      Corporate Loan Underwriting Stage  H save Mhod    Application Category    Product Code    Description fal  Application Branch 000  Application Date 2011 01 04    Leadid  Enquiry ID    Application Number    User Reference    Priority Low v    Pa     Status   New Application v    Main Details Financials R
12.    stage will be skipped     e RECOMMEND APPROVAL   Applications need to be approved manually in    Loan  Approval    stage after the    Underwriting Stage        e RECOMMEND REJECT     Applications need to be approved manually in    Loan  Approval    stage after the    Underwriting Stage        e AUTO REJECTED   Applications proceed to the    Application entry    stage from     Application verification    stage again     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    C   advanced Search    Reset    Authorization Status Record Status  Rule Id       Records per page 15 v    Authorization Status Record Status Rule Id Account Description             You can specify any of the following details to search for a record   e Authorization Status  e Record Status  e Rule ID    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     daa ORACLE       2 8    2 8 1    Maintaining Credit Ratios       You can maintain the rules to calculate the credit ratios in    Credit Ratio Maintenance    screen   You can invoke this screen by typing    ORDRATMT    in the field at the
13.   u  az  FEJ                                     Document Category  Select the document category from the adjoining option list     Document Reference  Specify the document reference     Document Type  Select the type of document from the adjoining option list     Remarks  Specify remarks  if any     Ratio Upload  Check this box to enable ratio upload     Upload  Click on    Upload    button to upload the document     View  Click on    View    button to view the uploaded document     The document upload from the external system is allowed only when    e the customer submits the loan request from the external system    a0 ORACLE       2 2 6    e the status in the Prospect Details screen is    Additional Documents Required        e The documents uploaded by the customer through the external system is stored in the    Document Management System with a document reference number     Conversation Details       Click on    Conversation    in the Prospect Detail screen to invoke the    Conversation Input       screen       Conversation Input    ustomer Details    Customer ID   000003171    onversation Details    Conversation ID   0000001075    Conversation Date  Conversation Time  Last Changed On    Department Details    Department    2011 01 04  E   17 11  2011 01 04 17 11 00    Customer Name    Priority  Conversation Status    Target Closure Date    Other Department      Assigned To    Low x  Open X          is   lad        Conversation Category  Venue  Conversation Mode    Senior 
14.  3 Fund MIS 3  Transaction MIS 4 Composite MIS 4 Fund MIS 4  Transaction MIS 5 Composite MIS 5 Fund MIS 5  Transaction MIS 6 Composite MIS 6 r Fund MIS 6  Transaction MIS 7 Composite MIS 7 Fund MIS 7  Transaction MIS 8 Composite MIS 8 Fund MIS 8  Transaction MIS 9 Composite MIS 9   Fund MIS 9          2 19 19 3 Capturing Loan UDF Details       You can capture the Loan UDF details by clicking    Loan Fields    button in    Corporate Loan  Underwriting    screen  System displays the    Loan UDF    screen where you can capture the  details     ant ORACLE       Application Number    Product Code      Character Floids    2    2 g  ie S  ie S  ie    I    ie G  ie S  S S  ie a  fe     ie     2 c  ie      ie S  ie c  ia    fe     c    ie S    Number Fields    Inn non onoo          2 19 20 Investigation Tab       In this tab  the system captures the field investigation details associated with the customer                      Corporate Loan Underwriting Stage     H save  Hoia  Application Category   Leadid Application Number   if   Product Code   Enquiry ID a7  User Reference    Description  S  Priority Low X  Application Branch 000 Status  New Application      Application Date 2011 01 04     Main  Details Financials Requested Limits Collateral Credit Score Bureau Ratio Loan Component Charges Investigation Comments  Invest  10f1    E                                  F  Verification Type Agency   a                Documents   Tradein   KYCReview   CustomerDedupe   LoanDedupe   CustomerM
15.  Financials Tab       You can capture the financial details corresponding to the customer in this screen       Corporate Loan Application Entry    les  Save     Hold    Application Category   z Leadid Application Number   CorporateLending3785  0   Product Code   Enquiry ID User Reference    Description   Priority Low    Application Branch 000 Status   New Application  Application Date 2011 01 04            Main Details Financials Requested Limits Collateral Comments  Assets Capital Reserves    Fixed Assets Issued Capital Subsidy from Government   Intangible Assets Paid up Capital General Reserves  Non Current Assets  Current Assets    Surplus Liabilities Cash Flows    Credit Balance in P Term Liabilities Operations Activities  Current Liabilities Investing Activities  Financing Activities    Credit Application    Borrower Profile Risk and Mitigants Facilities Proposed  Financial Performance Risk Department Approved Facilities  Borrower Market Position Mitigants Recommended    Risk Department Terms and Conditions  Assessment       Documents   Tradein   CustomerDedupe   LoanDedupe   CustomerMIS   CustomerAccountMIS   Customer Account Fields    Previous Remarks Remarks Audit       aoe ORACLE       You can capture the following details here     e Assets Details   e Capital details   e Reserves Details  e Surplus Details   e Liabilities Details  e Cash Flows   e Credit Application    Assets    You can capture the following details corresponding to the loan applicant   s assets    
16.  Fixed Assets  Specify the value associated with the fixed assets of the customer     Intangible Assets  Specify the value associated with the intangible assets of the customer     Non Current Assets  Specify the value associated with the non current assets of the customer     Current Assets  Specify the value associated with the current assets of the customer     Capital    You can capture the following details corresponding to the loan applicants capital     Issued Capital  Specify the value associated with the issued capital of the customer     Paid Up Capital  Specify the value associated with the paid up capital of the customer     Reserves    You can capture the following details corresponding to the loan applicant   s cash reserves     Subsidy from Govt  Specify the value of any subsidies the customer has obtained from the government     General Reserves  Specify the value associated with any general reserves of the customer     Surplus    You can capture the following details corresponding to the loan applicant   s surplus income     Credit Balance in PL  Specify the surplus credit balance  if any  associated with the customer     Liabilities    You can capture the following details corresponding to the loan applicant s liabilities     Ze ORACLE       Term Liabilities  Specify the value associated with the long term liabilities associated with the customer     Current Liabilities  Specify the value associated with the current liabilities associated with the customer  
17.  ID User Reference    Description Priority  Application Branch 000 Status   New Application  Application Date 2011 01 04    UEY Details Financials Requested Limits Collateral Comments    Channel KYC Required External Credit Check  Required  Intermediary Group Auto Decision Required s  Applicant Details  Branch Short Name   Telephone ISD Code    Customer No   Customer Name Telephone  Existing Customer National ID Fax ISD Code    y   Category Fax  Group Code RMID Language    RM Name Country    Nationality    Account Details Incorporation Business Description  Account Branch Date  Account Class Currency    Account Capital  Net Worth    Country       Documents   Tradein   CustomerDedupe   LoanDedupe   CustomerMIS   CustomerAccountMIS   Customer Account Fields    Previous Remarks Remarks Audit       The details related to the loan application entry are displayed in this screen  which can be  verified by the verifier  The details cannot be modified in this stage  but comments can be  added appropriately  On completion of this stage  the advices that are maintained for the   stage are generated     The verifier can either send the application back to the previous stage if the information  provided is not adequate or can cancel it if the information captured is not satisfactory     If the application details are verified successfully  the verifier can proceed with the processing  of the application by selecting    PROCEED    as the Outcome  The verifier can select    REJECT     to re
18.  adjoining option list displays all valid rate codes  You  can select the appropriate one   Code Usage  Select the code usage from the adjoining drop down list  The options available are   e Periodic  e Automatic    Resolved Value    When you click Apply Button in the Financial Section  the system calculates the resolved  value     Intermediary    Intermediary Code   Specify the intermediary code  The adjoining option list displays all valid intermediary codes   You can select the appropriate one    Intermediary Ratio   System displays the intermediary ratio     The details related to the loan offer like the number of installments  frequency  unit  interest    rate etc  are displayed here  Select the reuired offer by clicking the    Check    option and click  then click the    Apply    button to apply the selected loan offer  The details corresponding to the    oe ORACLE       2 19 22    selected loan offer are displayed in    Loan Details    section  You can modify these details  if  required  and click    Apply    button to calcualte the schedule details     The payment schedules are derived based on the offer selected        Note    You can select only one loan offer in this screen        Component Tab       In    Component tab  the system calculates and displays the component 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 displaye
19.  click on the    Default    button    Priority    Select the priority for the creating export LC from the adjoining drop down list  This list  displays the following options     e Low   e Medium   e High  Status    The status of the application gets displayed here     Click    Default    button to default the details related corresponding to the prospective loan  customer     Main Tab    In    Main    tab  you can capture the details associated with the loan applicant  The customer  details corresponding to the Application Category specified are displayed here  You can  modify these details  if required    Channel   Specify the channel ID of the originating channel     Intermediary Group   Specify the identification code of the intermediary group if the customer has been associated  with any    KYC Required   Check this box to indicate that the customer verification is required for this applicant     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    a
20.  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     Default  Check this box to set this as the default price ID for the price group that you maintain     Viewing Pricing Details Summary       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     a0 ORACLE       2 18 1      Pricing Details    Authorization Status Record Status    Price Group ID  at Description  Price Type    Records per page 15 v 1011    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     Application Status  Price Group ID  Price Type  Record Status  Description    Based on the details provided  system displays the following details     Authorization Status  Record Status  Price Group ID  Description   Price Type    Maintaining Pricing Formula       Click    Formula    button to define the pricing rule for each price ID  You can define the formula  using originatio
21.  e Not Equal To    Logical Operators    Select the logical operators from the adjoining drop down list  This list displays the following  values     e And  Use    And      e Or  Use    OR     Value  Specify the value of the SDE to define the condition  The value may be numeric or  alphanumeric  as required for the condition     After building the condition  click the    Insert    button to insert the same  To remove a condition   click the    Clear    button in the screen     Defining Template for Calculating Ratios       You can define templates for calculating financial ratios taken from the balance sheet  income  statement  statement of cash flows or statement of retained earnings within the product  You  can capture the template related details through the    Ratio Template Definition    screen     oe ORACLE       You can invoke this screen by typing    ORDTEMDF     in the field at the top right corner of the  Application tool bar and clicking the adjoining arrow button                Ratio Template Definition    Eb new    enter query                Industry   Sheet Name   Sheet Description    Worksheet  10F1        E  Worksheet Name    Worksheet description Work sheet Required    SDE Details    1 Of 1 G     EE    T  SDE Name    SDE Description Data Type    Category   Sub Category   SDE Type  gt                 Date Time        Maker  Checker    Mod No  Record Status  Authorization Status       Date Time     Specify the following details     Industry  Specify the industry
22.  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     e Married  e Unmarried  e Divorcee  Dependents  Specify the number of dependents for the customer     SSN  Specify applicants SSN   Passport Number    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     Existing Relationship Details       Relationship Type  Specify the relationship type of the customer     Credit Card Number  Specify the credit card number of the customer    as ORACLE       2 2 2    Customer ID Account Number  Specify the customer identification or account number of the customer     Details Tab    You can capture the address and employment related details of the prospective customer in     Details    tab                 Prospect Details   A  H save M  Hoia  Leadid   187111 Branch  000  3  Application Type Retail    Description example fal Date of Request   2011 01 06 Current Sta
23.  interfacing with external agencies                 Corporate Loan Underwriting Stage  X  H save    Hod  Application Category   Leadid Application Number   E   Product Code   Enquiry ID User Reference    Description E  Default Priority Low v  Application Branch 000 Status   New Application  Application Date 2011 01 04  Main Details Financials Requested Limits Collateral Credit Score Bureau Ratio Loan Component Charges Investigation Comments  Collateral Details  wo GE  Start Date E Haircut   fl  Cassi frac   End Date jp Revaluation Date B  ateral Bran E      saa   Collateral Category   Revision Date B  i iaa Collateral Type Normal Ed Charge Type X  Collateral Description g   Default Linked rea Utilization Order i  Collateral Currency   E  tkd ARR Commitment Product sa  Collateral Value   7  Revalue Collateral  Market Value Based Vehicle Details Haircut Schedule  securtyd eaten 101 ESE  E     Vehicle 1D   E  Effective Date    Haircut    Units Nominal Value P     C Vehicle Number a  M  m  Cap Amount  Year  Guarantor Based Make o  Guarantor Id E Model te   Ie  Body o  Rating o Usage fe   Valuation Source None v  Valuation Status Not Required v      i    Documents   Tradeln   KYC Review   CustomerDedupe   Loan Dedupe   CustomerMIS   Customer AccountMIS   Customer AccountFields   a          Previous Remarks Remarks Audit       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 list
24.  name here     Sheet Name  Specify the worksheet name here     Short Description  Specify a brief description about the template   Worksheet    Worksheet Name  Specify the name of the worksheet     Worksheet Description  Specify a brief description about the worksheet     Work sheet Required  Check this box to include the work sheet in the generated excel   SDE Details    SDE Name  Specify the SDE name here     SDE Description  Specify a brief description of the SDE     Data Type  Select the data type from the adjoining drop down list  This list displays the following values     aS ORACLE       e VARCHAR2    e Number  e Date  Category    Select the SDE category from the adjoining drop down list  This list displays the following  values     e Asset   e Liability   e Income   e Expense  Sub Category    Select the sub category of the SDE from the adjoining option list  This list displays all valid  sub categories maintained in the system  Sub  Category has to be maintained as part of SDE  maintenance only if the subcategory is used as part of Ratio formula    For example     If SDE s defined are SDE1  SDE2  SDE3 and all of them belong to a SUB CATEGORY1  then  you can use SDE1  SDE2 and SDE3 directly in the Ratio formula     You can also define SUBCATGORY1 in the SDE maintenance and use the same in ratio  formula  The system will then internally derive the formula     SUB CATEGORY1  SDE1 SDE2 SDE3       Note    The sub category should be defined as an SDE in the    SDE Maintenan
25.  number of records for the branch             Underwriting Status By Month and Intermediary Re   port    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    CLRPUNMI 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 Intermediary Report             Underwriting Status By Month and Intermediary Report  Branch  Intermediary Code  From Date  To Date  Report Format   PDF Printer At   Client  Report Output   Print Printer    za ORACLE          2 5 1    Specify the following details     Intermediary Code    Specify the code of the intermediary for which you wish to generate the report  You can also  select the ID from the adjoining option list  The list contains all the valid intermediaries  maintained in the system     Branch    Specify the branch for which you wish to generate the report  You can also select the branch  from the adjoining option list  The list contains all the valid branches maintained in the system     From Date  Specify  from the adjoining calendar button  the date from which you require details     To Date  Specify  from the adjoining calendar button  the date till which you require details     Click    OK    button to generate the report  Click    Exit    to return to the Reports Browser     Contents of the Report       The contents of the repor
26.  top right corner of the  Application tool bar and clicking the adjoining arrow button       LMC Eligibility Ratio  New  amp  Enter Query                 Group Id   7  New Route  Description Type   Retail M  Ratio Id  10f1            Ratio Id   Description Formula    aE                                     Maker Date Time    Checker  Date Time    Mod No Record Status  Authorization Status    You can specify the following details in this screen    Group ID   Specify a unique identification code for the ratio group    Description   Specify a suitable description for the ratio group    Type   Select the type of the loan from the following options available   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     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     2 24 ORACLE       2 9      Formula Wizard    Formula  1 0f1       Ratio Type   Condition Condition Builder     Stated Before               You can specify the following details here     Ratio Type    Select the type of the ratio being maintained  from the drop down list provided  The following  options are available     e Stated Before  e Stated After  e Actu
27.  use in any inherently dangerous applications  including applications that may create a risk of personal injury  If you use  this software or hardware in dangerous applications  then you shall be responsible to take all appropriate failsafe  backup   redundancy  and other measures to ensure its safe use  Oracle Corporation and its affiliates disclaim any liability for any damages  caused by use of this software or hardware in dangerous applications     This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and  are protected by intellectual property laws  Except as expressly permitted in your license agreement or allowed by law  you may  not use  copy  reproduce  translate  broadcast  modify  license  transmit  distribute  exhibit  perform  publish or display any part  in  any form  or by any means  Reverse engineering  disassembly  or decompilation of this software  unless required by law for  interoperability  is prohibited    The information contained herein is subject to change without notice and is not warranted to be error free  If you find any errors   please report them to us in writing     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  Orac
28. 2 2    2  Corporate 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     Corporate 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 Corporate Loan   e Credit rating rules  e Credit ratios  e Override details  e Document checklist and advices  e App
29. 24  COMMEOMS Tab et cise sied aint oats ied eins cea T 2 85  Maint  n  ntes o 2 ccc  fcctc css ce aera aea dh ett enden cteh ach en aineena sa claeteetatecennys 2 1  Sly MOJCI kG etadece terete a aeaeaei e aea aa i 2 1  3 2 Maintaining System Data Elements          eeseeeeeeeseeeeeseeerrestttrrrsttrrrssserrststrenrsstrrenns 2 1  3 3 Defining Template for Calculating Ratios            seeeeeeeeeeeeeeeeeerreeeerrreserrresererrrssreenns 2 3  PROP OMS 125  scnccsdesssugececcecedecaiesajecuestincisacniesaansadeategedaassngadecsgutcedecacacsdonnsacsanaces 2 1  AU    IMtrOduCtion sss fascisteteten tect cdacece sat cates atok tence cdece et a T hatte th aelede nt teed eae 2 1  4 2  Prefunding Contract Repon  oriceret i a E AE T E aE a as 2 1  4 2 1 Contents of the Report              ccccccceeeeceecnececeeeeeeesececeneeaaneeseeteeteesteeseeenenanees 2 2  4 3 Funded Contracts Report                    ccccecceceeeeeeeeeeeceeenaecaeececeeeeeeeeeseeeeenuesaeeeeeeeeeeeeess 2 2  4 3 1 Contents of the Report              ccccccceeeeseeceececeeeeeeeseseeeaaaeeeeeeeeeeeeeteeteeenenanens 2 3  4 4 Credit Application By User Report              ccccccececceeeeeeeeeeeeceeeeeeeeeeeeeeeseesecseesaeeeeeeeeess 2 4  4 4 1 Contents of the Report               2 cccceccecececcceceeeeeeeseseeenaaeaeeeeteeeeesteeseeeneaneas 2 4  4 5 Underwriting Status By Month and Intermediary Report                ccccceeeeeeeeteeeeeentaes 2 5  4 5 1 Contents of the Report          2   cccccceeeeeseeceeceeeeeeeeeteceee
30. AEE E OEO R 2 11  2 3 Viewing Loan Prospect Summary        esssseessssrressssrrnesrnnnestennaasstennneeetnnnesentnnennnnenne 2 13  2 4 Simulating Corporate Loans   aerieni eni EAE EEEE AEAT AE EERIE 2 13  244  LOAN TaD cla nina AE aE R R 2 15  2 4 2  Component Tab  Arere ai iieii a e iaa a aia eai ideaa a 2 17  2 5 Viewing Simulated Loan Details             ecceceeeeceeeeeeeeecneeeeeeeeceeeeeeenieeeeeeeteeeeene 2 18  2 6 Maintaining Credit Rating Rules         esesessssseeessreeessennenesnnnnesnnnnnennttennasnnnnneennnanneenenn 2 19  20 Main Taba faites a See ieee na ier deci aa Ea 2 19  26 2 cRISK FaclOl TaD jj ccs divested Eia Ean S AAEREN EEA ARAS CERA ARa ea addi tee 2 20  2 6 3 Specifying Credit Grad  S             eeesssrrrrerrrrnrerrrrrrrerrnrnnrrrrrnnarerinnnennnnnn eenaa 2 22  2 6 4 Specifying Auto Decision            esseessrirrnreriinnrnnrrnnnrernnnnrrrnnnnnrenannnnneranneeenne 2 22  2 amp 7  Viewing Credit Rule Summary  ee eaeoe iire reire rnea AFERE AERA EAEE EREEREER EERTE 2 23  2 8 Maintaining Credit Ratios   00 0 0     cccccccceceeeecccceeeeeecceeeeeeeeceaeeeeeceaeneeeesenaeeeeeeeeeeeeeneeees 2 24  2 8 1 Specifying Formula Details           seeessrrrenssrrrrrenerrrnnrrrnnnrenerrannrrnnnnneeerrnnrnnnn 2 24  2 9 Viewing Credit Ratio SUMMALY             eee ceceeeeeeeneeeeeeeeceeeeeeeaaeeeeeeeeaeeeeeeenateeeeeenaaes 2 25  2 10 Maintaining Ratio Details    ceceeeeeenee rece eeteeeeeeeiaeeeseetiaeeeeeetieeeeesenaaes 2 26  2 11 Maintaining Override Details         0
31. AND    or    OR        221 ORACLE       2 6 3    2 6 4    Specifying Credit Grades       You can maintain different credit grades based on the credit scores obtained  Click    Rating     button in Rule Details screens to invoke the    Rating    screen  where you can maintain these  details     10f1       Sequence Number                        You can specify the following details here     Sequence Number  The sequence number is automatically generated by the system     Score  Specify the score associated with a credit risk     Grade  Specify the credit grade based on the score obtained     Specifying Auto Decision       You can maintain decisions based on the credit scores obtained to decide applicants eligibility  for loan  Click    Auto Decision    button in Rule Details screens to invoke the    Auto Decision     screen  where you can maintain these details       Auto Decision    10f1    Serial Number   Score Credit Decision  Vv RECOMMEND REJECT X       Serial Number    System generates the unique serial number for each auto decision status     Score  Specify the maximum credit score for the applicant based on the auto decision     eee ORACLE       2 7    Credit Decision  Specify the credit decision for the applicant based on the auto decision  You can select any  of the following options from the drop down list provided   e AUTO APPROVED   Applications proceed to    Document Verification    stage from     Underwriting    stage  If this option is selected     Loan Approval 
32. Account Branch bel Date E  Account Class bel Currency   GBP az   Account azl Capital  Net Worth  Country Fa                   Documents   TradeIn   CustomerDedupe   LoanDedupe   CustomerMIS   CustomerAccountMIS   Customer Account Fields    Previous Remarks Remarks Audit    Outcome MEE       The Application Number is automatically generated by the system  You can capture the  following details in the main screen    Application Category   Specify the loan application category to be used or select the application category from the  option list    Product Code   Select the product from the adjacent option list  The list displays only the corporate CL  products created in Oracle FLEXCUBE    Description   System displays the description of the selected product code     Application Branch  System displays the current branch code     246 ORACLE       2 19 3    Application Date  System displays the application date     Lead ID  Specify a unique identification for the prospective loan customer     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    System displays the application number     User Reference   Specify the user reference number for the loan application  If you do not specify the reference  number  system generates it when you
33. Date  Report Format   PDF Printer At   Client  Report Output   Print Printer       Specify the following details     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 displayed in the report        Field Name Field Description       Branch This is the branch                et ORACLE       2 7       Product code    This is the product code       Application Num   ber    This is the loan application number       Stage    This is the stage at which the application lies       Applicati
34. Defined Fields       Application Number   je   Customer Customer Account  Account Branch Account Number  Character Fields Number Fields Date Fields  1 Of 1 1 Of 1 1 Of 1  E  FieldName    Value A    Field Name   Value  o E FieldName   Value                            You can specify the following user defined field details for the customer account  in Customer  Account Tab     Name  Specify the name of the UDF being created for the customer account   Value    Specify the value associated with the UDF being created for the customer account     a ORACLE       2 19 15 Viewing Vehicle Evaluator       You can view the evaluated vehicle details captured as part of collateral details by clicking the     Vehicle Evaluator button against the Applicant record       Vehicle Evaluator    Application Number   CorporateLending5705 Vehicle ic   Collateral Code      Vehicle Detalls  Valuation Source N  Identification Number  Year  Make  Vehicle Valuations  Wholesale Value Attribute Value  Retail Value Total Value  Usage Value  Vehicle Attributes  1011   J Attribute Description AftributeCode Attribute Value Packageincluded Selected       To acquire the next stage  you need to go to the    Task    menu and select    Assigned    under     Standard    option     DOCUMEN   00    000   Oracle FLEXCUBE UBS1 1 2   ENG   2012 11 07   Transaction Input   Windows internet Explorer    Home Interactions Customer Werlow Tasks Preferences oe ae E as  Tasks      a eae Page 3001 monpa E   Acquired         vie
35. E A ARENE 2 51  219 5 Financials  Tab  sedgi nea kisses dei ega ae ae E a dara eLA ETE EA a a ee 2 52  2 196 Limits Tabria eari sees aieiaiei AAE EENE AAEE E AA e EA AA AEA ian E 2 55  ZAG    Collaterals  TI r EE T E E AE ian Lathes 2 57  219 0  Red  e Sted TAD aa a aos aa ee gee a Saaai 2 59  219 9  Comments Tabrani eene E A AE AEA A 2 60  2 19 10 Capturing Document DetailS            1111ssrinnnseernrrernrnnnnennrnnnrnnrrnneenrrnnnnnnnnna 2 60  2 19 11 Capturing Trade In Detallls         ccccccccccteeeeeeenteeeeeetetneeeeeetnneeeeeetnaaeeeeneeae 2 62  2 19 12 Capturing Customer MIS woo  ccccccccecettteee iteris tirari i an ERNEA ARS LEA RATES RI R   2 63  2 19 13 Capturing Customer Account MIS          ssssssesssissseeiiseseeenenneerrnneeerrnnneeeenne 2 63  2 19 14 Specifying Customer Account FiClOS          cccccccceeeeeceeennteeeeeeenteeteeeeaaes 2 64  2 19 15 Viewing Vehicle Evaly  t  r uisi siedain isiad ienerienrreariria iaaii erian dia 2 65  2 19 16    Collateral Tab sisimoriniereiiiraii iiai i E E A AE EAR EEE a 2 71  2 19 17  Credit Score  Tab   reann uh eoin ie e ea s rae aa eee eee 2 73  219  18  RAUO Tab rr e aT EE al pe ea ee ee 2 74  2 19 19 Bur Qu TAD a aa a aaa a a aaa a aeetdeeehaeeteand 2 75  2 19 20 INVESTIGATION Tabori O R 2 78  2 19 21  LOAN  Taber ee deel ad ees nt een a 2 79  2 19 22  COMPONENT AD vi rererere anicar kadi pa ae abn aetna 2 82  2 19 23 Charg  s Tab aseran esos ded iveedaev ceveetinen cevebanedevsebbdeeuevsieiaeuevsetbadedenes 2 84  2 49 
36. Facility  Collateral  pool  Loan  You can make  the necessary changes  amp  retry  You can select the outcome as    PROCEED        a ORACLE          2 1    2 2    2  Maintenances    Introduction       As part of general maintenance required for the successful functioning of Corporate Loan  Origination  you should maintain the following in the system     e SDE Maintenance  e Template Definition Maintenance  e Ratio Maintenance    Maintaining System Data Elements       In order to calculate financial ratios  you can maintain System Data Elements  SDEs  using  the    SDE Maintenance    screen  You can invoke this screen by typing    ORDSDEMT    in the field  at the top right corner of the Application tool bar and clicking the adjoining arrow button     SDE Maintenance  H Save  Group   Worksheet Name    _   _      A Group   Worksheet C     A  Element Type     Corporate     Description                         1 Of 1 5 ft          SDE Name    SDE Description Data Type SDEType Derivation Required    C PO Pme a                                               Maker Date Time   Checker Date Time   Mod No Record Status  Authorization Status       Specify the following details     Group Worksheet Name  Specify the group worksheet name here     Element Type    Select the element type from the adjoining drop down list  This list displays the following  values     e Corporate  e Retail  e Both    Group Worksheet Description  Specify a brief description of the group worksheet you are maintaini
37. IS   Customer AccountMIS   Customer AccountFields      Previous 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     Ap ORACLE       2 19 21 Loan Tab    In the    Loans    tab  the system displays the list of the multiple loan offers that are attached to  the application category specified  If you have selected an    Enquiry ID    for the customer  then  the loan details that have been stored for the corresponding loan proposal are displayed here   You can modify these details  if required       Corporate Loan Underwriting Stage  X  al Save i  Hold  Application Category   Leadid Application Number   i     Product Code   Enquiry ID e  User Reference    Description E Priority Low X    Application Branch 000  Application Date 2011 01 04    Status  New Application    Main Details Financials Requested Limits Collateral Credit Score Bureau Ratio Loan Component Charges Investigation Comments  Pricing  Pricing ID iF    Multiple Offers  10f1    m        E  Offerid  Noofinstallments Frequency Unit Rate RateCode Check Apply          Loan Details    Loan Account Number Value Date No ofinstallments 12    S        Loan Branch laz Maturity Date Frequency 1  Loan Currency Installment Start Date Unit Monthly X  Loan Amount Status Change Mode Auto  v    Down Payment E Close Collateral as   lt  m 
38. J  gt                    Documents   Tradeln   KYC Review   CustomerDedupe   LoanDedupe   CustomerMIS   CustomerAccountMIS   Customer AccountFields      Previous Remarks Remarks Audit       Specify the following details     Pricing  Pricing ID    You can select  amp  apply any one of the Pricing rule available under a pricing group linked to  Application category  Each pricing rule will auto select the best matched Loan Proposal for  the requested loan application among the available offers for the application category  You  can either proceed with the system selected offer or can select any other offer for the loan  based on the requirement     If the pricing is not maintained for the application category  then on clicking the Apply    button   the pricing and the offer will not apply for the loan     Multiple Offers    Offer ID  Specify the offer ID        Number of Instalments  Specify the number of instalments for the loan     Frequency   Specify the frequency of the instalment    Unit   Select the unit of the instalment from the adjoining drop down list   e Daily  e Weekly    ara ORACLE       e Monthly  e Quarterly    e Half Yearly  e Yearly  Rate    Specify the rate for the loan     Rate Code    Specify the rate code  The adjoining option list displays all the valid rate code  Select the  appropriate one     Check    System displays this option as checked if this option is selected at application category level   If this check box is not checked  you can check this box 
39. 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                                 New E3 Enter Query  Process Code    Application Category    Process Stages  10f1  Stage    Stage  Document Details  10f1  Document Category   Document Type   Mandatory  m  Mandatory    BI Advices  10f1  m  Report Name   Description Template Type Format Locale Outcome  m  Query   Por     enus    Checklist Details  10f1  E  Sequence Number      Checklist Item   Mandatory   a   Maker Date Time  Mod No  Checker Record Status   Exit    Date Time  Authorization Status       You can specify the following details in this screen     Process Code   Specify the process code of the process for which you wish to maintain override conditions or  select the process code from the option list provided    Application Category   Specify the category to which the loan application belongs or select the application category  from the option list provided    Stage   Select the stage of the loan origination process from the option list provided  The various  stages can be Application Entry  Application Verification  Underwriting  Loan Approval etc   Stage Title   Specify a suitable description for the loan origination stage     Document Details       Document Category   Specify the category to which the document belongs or select the document category from  the option list provided    Do
40. Management       Involved    Call Report 5  Branch z   NIA v            User Role  Role 5         Other Offices Involved             hannel Details  Direct Access Channel No     External System User ID Channel UserID    Message Details       Orginal Request          Subject          Detail                Documents Presented    Reply to Customer  No        Closure Remarks                         Customer Conversation       Documents    Maker Date Time   Checker Date Time    Mod No  Record Status  Authorization Status    The system displays the following details if the conversation ID is selected in the prospect  Detail screen     Customer Details       Customer ID  The system displays the customer ID     Customer Name  The system displays the name of the customer     Conversation Details       Conversation ID  The system displays the conversation ID     Conversation Date  The system displays the conversation date     2 11    ORACLE       Conversation Time  The system displays the conversation time     Last Changed On  The system displays the date and time when the conversation was last changed     Priority  The system displays the conversation priority     Conversation Status  The system displays the conversation status     Conversation Category  The conversation category is defaulted here     Venue  The system defaults the venue     Conversation Mode  The system displays the conversation mode     Department Details       The system displays the following department details   
41. Mode   Auto  Effective Date User Defined Element Values  1 Of 1 1 Of 1   E  Effective Date    ca   E  User Defined Elementid  User Defined Element Value Rate Code Code usage    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     Application Category    Specify the application category for the loan enquiry  You can also select it from the adjoining  option list     Product Code    Specify the product code for loan product selected by the customer  You can also select it  from the adjoining option list     Branch Code    Specify the branch code in which the loan will be processed  You can also select it from the  adjoining option list     Customer Details       Specify the following details for the customer     aN ORACLE       2 4 1    Customer No    Specify a unique customer number for the prospect who has initiated a loan account for the  same product and application category combination     First Name  Specify the first name of the customer     Last Name  Specify the last name of the customer     Contact Number  Specify the number at which the c
42. 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     Details Tab    The address and employment related details of the customer corresponding to the Application  Category selected are displayed in this tab  You can modify these details if required       Corporate Loan Application Entry     al Save q  Hold    Application Category   a    Leadid  zl Application Number   CorporateLending3785 fel  Product Code   Ba Enquiry 1D User Reference    Description    Priority Low      Application Branch 000  Application Date 2011 01 04       Status   New Application    Main Details Financials Requested Limits Collateral Comments    Address Details       101  HE Address 1  iS Zip  Address 2 r   Country    Address Type   Address 3 o Contact Number  Correspondence Address v ai iniinis   E Mailing  Director Details Permanent Address Mailing Address  101  HE Address 1 Address 1  Address 2 Address 2  Director Name    Address 3 Address 2  Taxld san  Email E Country Ga Address 4  i    E  Permanent US Resident Country bal  Nationality ba Status  Share Percentage  Telephone ISD Code   la  i  Telephone  Mobile ISD Code   e     Mobile Number       Documents   Tradeln   CustomerDedupe   LoanDedupe   CustomerMIS   Customer AccountMIS   Customer Account Fields    Previous Remarks Remarks Audit       In this screen  you can capture multiple address and employment details  if required        Note    For more 
43. ORACLE       Corporate Loan Origination User Guide  Oracle FLEXCUBE Universal Banking  Release 12 0 2 0 0    Part No  E49740 01    September 2013    Corporate Loan Origination User Guide  September 2013    Oracle Financial Services Software Limited  Oracle Park    Off Western Express Highway  Goregaon  East    Mumbai  Maharashtra 400 063  India   Worldwide Inquiries    Phone   91 22 6718 3000  Fax  91 22 6718 3001  www oracle com financialservices     Copyright    2007  2013  Oracle and or its affiliates  All rights reserved     Oracle and Java are registered trademarks of Oracle and or its affiliates  Other names may be trademarks of their respective  owners     U S  GOVERNMENT END USERS  Oracle programs  including any operating system  integrated software  any programs installed  on the hardware  and or documentation  delivered to U S  Government end users are  commercial computer software  pursuant to  the applicable Federal Acquisition Regulation and agency specific supplemental regulations  As such  use  duplication  disclosure   modification  and adaptation of the programs  including any operating system  integrated software  any programs installed on the  hardware  and or documentation  shall be subject to license terms and license restrictions applicable to the programs  No other  rights are granted to the U S  Government     This software or hardware is developed for general use in a variety of information management applications  It is not developed or  intended for
44. S    Transaction MIS 1  Transaction MIS 2  Transaction MIS 3  Transaction MIS 4  Transaction MIS 5  Transaction MIS 6  Transaction MIS 7       5              0                         fis  he  i  is  a  i  Ba    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    2 63    Fixed    X                                                                     Poo     Aca  Pool Code  F  Link  MIS Group  Cost MIS  Cost MIS 1  Cost MIS 2  Cost MIS 3  Cost MIS 4  Cost MIS 5    ORACLE       2 19 14 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   System displays the    User Defined Field    screen where you can maintain the UDF details      User Defined Fields                   Application Number      0     Eeay Customer Account    Customer Branch Customer No  Character Fields Number Fields Date Fields  10f1 Go 10f1 8 1 0f1    FieldName   Value    E Field Name   Value M  FieldName   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 
45. W Details Financials Requested Limits Collateral Credit Score Bureau Ratio Loan Component Charges Investigation Comments    Channel  Intermediary Group    KYC Required Exte    Rec  Auto Decision Required    Applicant Details    Branch Short Name   Telephone ISD Code    Customer No   Customer Name Telephone  Existing Customer National ID Fax ISD Code    yk  Category Fax P  Group Code RM ID Language  RM Name Country    Nationality    Account Details Incorporation Business Description  Account Branch Date  Account Class Currency    Account Capital       anji Net Worth    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  facility etc  are created in the system  on completion of the Document verification stage     Manual Retry    This stage is optional  Task will be moved to this stage only when the system is unable to  create Customer  Customer Account  Liability  
46. a  Main Agency  Credit Agency   101 mE   W  Agency Code   Agency Name  7       Bureau Details  im ios  v  Bureau Code   Bureau Call Priority c  w e   I                Date Time  Mod No    Date Time        You can specify the following details in this screen     Credit Agency    You can capture the details related to the credit rating agencies here     Agency Code   Specify the identification code of the rating agency that provides credit rating details for  customer securities    Agency Name    Specify the name of the rating agency that 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 rating details for customer  securities     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     2 38 ORACLE       2 17    Category Details  C  Advanced Search Reset    Authorization Status  Application Category    Records per page 15 v 10f1    Authorization Status Record Status       Record Sta
47. al          This indicates the total number of records for the branch          Funded Contracts Report       This report lists the applications funded for the loan  You can invoke the    Funded Contract     screen by typing    CLRPFNCR in the field at the top right corner of the Application tool bar and    clicking on the adjoining arrow button     2 2    ORACLE         Report Details    X  Funded Contracts Reports    Branch Code    From Date   To Date  ReportFormat  PDF   Printer At   Client    Report Output   Print Printer       Specify the following details     Branch Code    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     2 3 1 Contents of the Report       The contents of the report are discussed under the following heads     Header   The Header carries the Report Name  Run Date and Time  Branch and the Period for which  the report is generated    Body of the Report   The following details are displayed in the report        Field Name Field Description       Branch This is the branch code       Application Number   This is the applica
48. al 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    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     228 ORACLE       Credit Ratio Maintenance     od Advanced Search 5 Reset    Authorization Status Record Status       Group Id             Records per page 145 x    Authorization Status Record Status Group Id Description             You can specify any of the following details to search for a record     e Authorization Status  e Record Status  e Group ID    Click    Search    button to search for a record based on the search criteria specif
49. alues   101    E  10f1   4  Ea     Effective Date    User Defined Elementid   User Defined Element Value Rate Code Codeusage Resolvedvalue                                       Maker Date Time  Mod No  Checker Record Status  Date Time Authorization Status       Enter the following details here     Offer ID  Specify a unique identification for the loan offer being made to the customer     No of Instalments  Specify the number of instalments associated with the loan     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    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     Spread  Specify the spread that is applicable for the loan being offered     alg ORACLE       2 4 2    Effective Rate    The effective rate of interest gets displayed here  based on the interest and the spread  specified     Check  Select the required offer by clicking the    Check    option     Click the    Apply    button  The system will default all the details in the    Loan Details    section   When you click the    Apply    button available in the lower section in    Loan Details     the system  will populate 
50. ation 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 mathematical operator to be used to define the conditions for generating override    messages  You can select                           or f     Logical Operators    Select the logical operator to be used to define the conditions for generating override  messages  You can select     lt
51. ce     ORDSDEMT   screen        SDE Type    System displays the SDE type here  The SDE type could either be General SDE or Derived  SDE based on the SDE maintenance     29 ORACLE          2 1    2 2    2  Reports    Introduction       This chapter deals with the various BIP reports that are available for the corporate loan  origination process  The reports that are available are     e Prefunding Contract Report   e Funded Contracts 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  Corporate Lending under it  A list of all the reports in Corporate Lending module will be  displayed  You can choose to view or print the report     The selection options that you specified while generating the report a printed at the beginning  of every report     Prefunding Contract Report       This report lists out all the applications verified for loans  You can invoke the    Prefunding  Contract    screen by typing    CLRPPFCR    in the field at the top right corner of the Application  tool bar and clicking on the adjoining arrow button       Prefunding Contract               Prefunding Contracts Report    Branch  From Date  To Date    ReportFormat   PDF Printer At   Client       Report Output   Print Printer       Specify the following details     Branch    Specif
52. ce Number   Type Existing Local Branch Customer No Default Short Name   Customer Name m    i Pimay fe  m E   a      m J r  City l First Name    SSN  Country  az  Middle Name E  Passport Number E   Nationality    Last Name     Passport Issue Date E   Language  az  Salutation x Passport Expiry Date  Ez   Customer Category   kzl Gender E Existing Relationship Details  Financial Currency faz  Date of Birth el    Relationship Type  Mobile Number j A  Mothers Maiden Name a EEA E  Landline Number Marital Status  Jo  l  k Customer ID Account l  Email 2   Dependents Number  Fax  Preferred Date of Contact  E   Preferred Time of Contact  Any Time X  Documents   Conversation  Maker Date Time  Mod No  Checker Date Time  Record Status    Authorization Status       You can specify the following details in this screen     Lead Id  Specify a unique identification for the prospective loan customer     Description  Specify a suitable description for the prospective loan customer     f       v Offers    to view the multiple offers        Request ID    The system displays the request identification of the loan request     Channel   The system by default displays    FLEXCUBE    as the channel  However  you can modify if  needed  The adjoining option list displays a list of valid channels  Select the appropriate one   Promotion Code   Indicate the promotion code     Branch  Select the branch code from the adjoining option list     Date of Request    Specify the date when the prospective customer ha
53. cessfully done     The system will display a message stating that the task is successfully completed on saving  the record     To acquire the next stage  you need to go to the    Task    menu and select    Assigned    under     Standard    option  All tasks that have been successfully completed are listed in the right side  of the screen  Select the checkbox against your    Workflow Ref No    and click    Acquire    button  at the top of the screen to acquire the next stage of the task     The system displays the system message as    Acquire Successful    on successful acquisition  of the task     Click    Ok    to proceed to the next stage which will again be the underwriting stage  To select  the acquired task for the next stage  select    Acquired    under    Standard    option in the    Task       ale ORACLE       2 19 17    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     Corporate 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    
54. credit rating rule     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     a ORACLE       2 6 2       Question Details       Question ID  The question ID is automatically generated by the system     Category  Select the category to which the question belongs from the option list provided     Question  Specify the question to be asked to the prospective customer to derive the credit rating score     Answer Details       Sequence Number  The sequence number is automatically generated by the system     Possible Answer  Specify a set of possible answers to be associated with a question     Score  Specify the score associated with an answer     Risk Factor Tab       You can specify the risk details associated with the loan and also indicate the formula for  calculating the credit score in this tab     Rule Maintenance    E  New E3 Enter Query    Rule Id    F  New Route  Account Description Type   Retail Tj v  Risk Factor    Risk Factor  1 Of 1             Risk Id   Account Description Formula    Farrea                   Rating   Auto Decision      Maker Date Time  Checker    Date Time    Mod No Record Status  Authorization Status  You can specify the following details here     Risk ID  Specify a unique identifier for the credit risk being maintained     Description  Specify a suitable description for the credit risk     a0 ORACLE       2 6 2 1    Specifying Formula De
55. cument 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     2 98 ORACLE       2 14    e Mandatory  e Overridden  e Others    BI Advices    Report Name  Specify the name of the advice report to be generated on completion of the process stage     Template  Specify the template to be used to generate the advice report     Format    Select the format in which the advice report needs to be generated from the drop down list  provided  The following options are available     e PDF  e RTF  Locale    Select the locale information to be used for generating the advices from the drop down list   The following options are available     e en US    Out come  Specify the outcome for which the report needs to be generated     Checklist Details       Sequence Number  The system displays the sequence number     Checklist Item  Specify the checklist to be maintained     Mandatory  Check this box to indicate whether the checklist is mandatory or optional     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     ae ORACLE       2 15    You can invoke this screen by typing    ORSDOCMT in the field at the top right corner of t
56. d  Default  Documents   Tradein   CustomerDedupe   LoanDedupe   CustomerMIS   CustomerAccountMIS   Customer Account Fields  Previous Remarks Remarks Audit       In this screen  specify the following details     Liability Details       Liability Number    Select the liability number  The adjoining option list displays all valid liability numbers  maintained in the system  Select the appropriate one     Liability Name    Select the liability name  The adjoining option list displays all valid liability names maintained  in the system  Select the appropriate one     Main Liability No    Select the parent liability number  The adjoining option list displays all valid main liability  numbers maintained in the system  Select the appropriate one     Liability Branch    Select the liability branch  The adjoining option list displays all valid liability branch maintained  in the system  Select the appropriate one     Liability Currency    Select the liability currency  The adjoining option list displays all valid liability currency  maintained in the system  Select the appropriate one     Overall Limit  Specify the overall limit     20   ORACLE       Line Details    Line Code    Select the line code  The adjoining option list displays all valid liability numbers maintained in  the system  Select the appropriate one     Line Serial  Specify the line serial number     Main Line Code    Select the main line code  The adjoining option list displays all valid main line codes  maintained in 
57. d for the condition     After building the condition  click the    Insert    button to insert the same  To remove a condition   click the    Clear button in the screen     2 11 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  E New    amp  Enter Query    Process Code   J  New Route  Application Category   Type  Retail X  Stage  10f1  Stage    Description  Overrides  1 Of 1     Sequence Number   Condition Error Code Error Parameter i                                  Elements  Index  Functions         Braces v       Operators     Logical Operators       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 category to which the loan application belongs or select the application category  from the option list provided     230 ORACLE       2 12    Type   Select the type of the loan from the following options available   e Retail  e Corporate    Stage   Select the stage of the loan origin
58. d here  You can  modify them  if required       Corporate Loan Underwriting Stage       Save di  Hold  Application Category   Leadid Application Number   fal  Product Code   Enquiry ID fal User Reference    Description fa Default Priority Low      Application Branch 000  Application Date 2011 01 04    Status   New Application    Main Details Financials Requested Limits Collateral CreditScore Bureau Ratio Loan Component Charges Investigation Comments    Component Name   Main Component 10f1  Component Currency Capitalized  Liquidation Mode   Auto  Waive  Verify Funds Schedule Details  Details  10F1 Eime         E  Schedule Type    FirstDue Date No Units DueDateOn Schedule Start Date    End Date   Amount EMIAmount Capitalized Waive Compoun            Documents   Tradeln   KYCReview   CustomerDedupe   LoanDedupe   Customer MIS   Customer Account MIS   Customer AccountFields         Previous Remarks Remarks Audit    Outcome  e       The following details related to the schedule are displayed here   e Component name  e Schedule type  e First due date  e Number  e Frequency  e Unit  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     You can specify the following schedule related details     Compound Days  Specify the number of compound days     arte ORACLE       Compound Months  Specify the number of compound months     Compound Years  Specify the number of com
59. details on capturing address details  refer the chapter titled    Maintaining Custom   er Information Files    in Core Entities user manual        You can capture the following additional details related to the Director in this tab     Director Name    Specify the name of the director of the corporate customer     Tax ID  Specify the tax identification of the director     E mail  Specify the e mail ID of the director     Nationality  Specify the nationality of the director     a ORACLE       2 19 5    Share Percentage  Specify the percentage of share for the key person     Telephone ISD Code      Specify the international dialling code for the telephone number of the director    The adjoining  option list displays valid ISD codes maintained in the system  Select the appropriate one     Telephone  Specify the telephone number of the director     Mobile ISD Code      Specify the international dialling code for the mobile number of the director  The adjoining  option list displays valid ISD codes maintained in the system  Select the appropriate one     Mobile Number    Specify the mobile number of the director     Permanent Address       Address  Specify the permanent address of the director     Country  Specify the country associated with the address specified     Permanent US Resident Status  Check this box to indicate that the corresponding director is a permanent US resident     Mailing  Line 1 4    Specify the mailing address of the customer in Line 1 to Line 4 provided    
60. e    Description Priority Low X  Application Branch 000 Status  New Application  Application Date 2011 01 04    oO     Main Details Financials Requested Limits Collateral CreditScore Bureau Ratio Loan Component Charges Investigation Comments    External Credit Rating       10f1 m m Recommended NotRecommended v                Request ID 1 Status NotRequired v    External Agency   Remarks fa  Score          Documents   Tradeln   KYC Review   CustomerDedupe   LoanDedupe   CustomerMIS   CustomerAccountMIS   Customer AccountFields      Previous 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     External Credit Rating       Request ID  System displays the request ID     External Agency    The external credit agencies maintained for the Application Category in    Application Category  Maintenance    are displayed here     Score  Specify the score associated with the rating     Recommended    Select the recommendation of the credit agency for the loan requested from the following  options provided in the drop down list     e Recommended  e Not Recommended    Remarks  Specify remarks  if any  associated with the loan application     2 19 19 1 Viewing Credit Bureau Report       You can view the credit bureau report by the external agency by clic
61. e   Customer MIS   Customer AccountMIS   Customer Account Fields    Previous Remarks Remarks Audit       In this screen  specify the following details to facilitate vehicle evaluation     Collateral Details       Collateral Branch       Specify the collateral branch     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     A ORACLE       Market Value Based       Security ID    Select the security ID  The adjoining option list displays all valid security IDs maintained in the  system  Select the appropriate one     Number of Units Nominal Value  Specify the number of units     Cap Amount  Specify the cap amount     Guarantor Based       Guarantor ID    Select the Guarantor ID  The adjoining option list displays all valid guarantor IDs maintained  in the system  Select the appropriate one     Rating  The system displays the rating     Haircut Schedules       Specify the following Haircut Revision Schedule details for any collateral linked to the Loan     Effective Date  Specify the effective date from the adjoining calendar     Haircut    Specify the haircut percentage     Vehicle Details       You can capture the details of the vehicle which is to be evaluated in the following fields   Vehicle Number    Specify the registration number of the vehicle     Year   Specify the year of manufacture for the vehicle   Make   Specify the 
62. e Department  e User Role  e Other Department  e Assigned To  e Senior Management Involved  e Other Offices Involved    Channel Details  The system displays the following channel details     e Direct Access Channel  e External System User ID  e Channel User ID    Message Details       The system displays the following message details  e Original Request  e Subject  e Detail  e Documents Presented  e Reply to Customer  e Closure Remarks    ate ORACLE       2 3    2 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     amp  Search CE Advanced Search    Reset r9 Clear All   Case Sensitive    Authorization Status x Record Status x      Request ID Leadlid  Application Type x   Customer Id  Loan Type x   Channel    Branch az     A       Records per page 10f1    Authorization Status Record Status Request ID Date of Request Lead Id Application Type Customer Id Loan T              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  do
63. ed 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     ari ORACLE       Model   Specify the vehicle model    Body   Specify the vehicle body details    Usage   Specify the mileage used by the vehicle till date     You can retrieve vehicle details from an external agency either by specifying the identification  number for the vehicle or all of the following fields     e Year   e Make  e Model  e Body  e Usage    Valuation Source   Select the valuation source from the adjoining drop down list  The options are   e INTERNAL  e NONE    Select    INTERNAL    if you wish the evaluation to be done by interfacing with an external  agency   Status  Select the status from the adjoining drop down list  The options are   e RECOMMENDED  e NOT RECOMMENDED  e COMPLETE  e NODATA    The evaluation will be done only if the valuation source is selected as    INTERNAL    and the  status is    RECOMMENDED     For any other combination of values for the two fields  the  system will display an error message and will not proceed with the evaluation till the values  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 suc
64. en  You can invoke this    screen by clicking    Schedule Details    button     Schedule Details    Application Number MAIN_INT Component Name MAIN_INT    Details  10f1   o Due Date Amount Settled AmountDue EMlamount Amortized Principal   7  2012 12 07  E    2013 01 07        F  2013 02 07   F  2013 03 07   F  2013 04 08                   nosan or o gt           2 19 23 Charges Tab       In    Charges    tab  the system calculates and displays charges  if any applicable                  Corporate Loan Underwriting Stage   x  H save  lt  Hoid  Application Category   Leadid Application Number   eI  Product Code   Enquiry ID  asl User Reference    Description   Default Priority Low    Application Branch 000 Status   New Application     Application Date 2011 01 04           Main   Details Financials  Requested  Limits   Collateral Credit Score Bureau  Ratio  Loan  Component  Charges  Investigation Comments  10f 1  Waive  Component Name   Due Date  Component Currency Amount Due  Effective Date Amount Waived  Documents   Tradeln   KYC Review   CustomerDedupe   LoanDedupe   CustomerMIS   Customer Account MIS   Customer AccountFields   a  Previous Remarks Remarks Audit          The system calculates and displays the charge details associated with the loan     a ORACLE       2 19 24    The following details are displayed   e Component Name  e Component Currency  e Effective Date    Waive  Check this box to waive the charges associated with the loan     Comments Tab       In this tab  
65. enerate 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     2 4 1 Contents of the Report       The contents of the report are discussed under the following heads     os ORACLE       2 5    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 indicates the branch code   Product This indicates the product code under which the application is made  Application Num  This indicates the credit application number   ber   Stage This indicates the stage at which the application lies   Application Date This indicates the date on which the application was made   Contract Date This indicates the contract date       Contract Currency   This is the currency of the contract                Contract Amount This is the amount of the contract   Contract Term This is the total term of the contract   Contract Interest This is the interest applicable to the contract   Total This indicates the total
66. equested Limits Collateral Credit Score Bureau Ratio Loan Component Charges Investigation Comments  Internal Credit Rating      Rule Id    10f1 E    Ei Grade  Score    Calculate    E Category   Question   Answer    m       Risk Factor Details   10f1 PEE  ol Risk Factor   Score  a                 m                        Documents   Tradeln   KYCReview   CustomerDedupe   LoanDedupe   CustomerMIS   Customer AccountMIS   Customer AccountFields        Previous Remarks   Bat      Remarks Audit    Outcome  e    The set of questions used to assess the credit rating of a prospective loan customer   associated Rule Id are displayed in this screen  You can specify the following details here     Answer   Specify the answer to be associated with the question used for calculating the credit score   Risk Factor   Specify the risk factor associated with the loan  if any    Description   Specify a suitable description for the risk factor associated with the loan     Click    Calculate    button to calculate the credit score and the grade  based on the formula    maintained for calculating the credit score  The    Grade    and the    Score    are displayed based  on this calculation     Ratio Tab    In the    Ratio    tab  the system calculates the stated and actual income debt ratios and also  calculates the ratio based on    What if payment amount     2 ORACLE       2 19 19      Corporate Loan Underwriting Stage mre                                        H save i  Hold  Application Category
67. h  Col    Advanced Search    Records per page 15   10t1  Name Date of Birth          Once reviewed the verifier provides the review status and remarks     206 ORACLE       You can perform a check on the customer record based on the KYC Review and SDN Review  screens and choose the internal KYC status and SDN status respectively based on the  review     Step 4 External KYC Review    If the check box    KYC Required    is checked  then the external agency performs the KYC  check for the applicant       KYC Review  Application Number   001005754 Customer No   001005754    YC Review Details    Local Branch Ral KYC Extenal Status No Match    KYC Extenal Remarks No Match  SON Status No Match       SON Remarks No Match    Date of Birth        First Name  Middle Name  Last Name    Country  Nationality IN       You can review the KYC details displayed on the screen     System displays the following information   e KYC Internal Status  e KYC Internal Remarks  e SDN Status  e SDN Remarks    Based on the KYC and SDN statuses and remarks the reviewer decides whether to move the  task to the next stage     aba ORACLE       Click    Review    button to view all customer information and perform KYC and SDN checks  The  KYC Review Screen  STSKYCMN  and SDN Review Screens  ORSSDNMN  are displayed       KYC Maintenance Summary    Authorization Status Record Status    KYC Reference lag Full Name of Customer  KYC Customer Type   Risk Level    Advanced Search  Records per page 45   10f1  Authoriza
68. he  Application tool bar and clicking the adjoining arrow button         ee Advanced Search 5 Reset                   Authorization Status   Record Status m  Process Code as Application Category ba  Records per page 15 v 10f1 p gt   Authorization Status Record Status Process Code Application Category          aip m EEG       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     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 corner of the Application tool bar and clicking the adjoining arrow button     205 ORACLE       2 15 1      Application Category Maintenanc   H save  lt i  Hod    Application Category    Category Description     Main Agency  Product Details     m    a  Product Code   Product Description External Credit Check Required External Credit Check Required for Amount Basi       wm fea  i  Ea  All Applicants  
69. icle Type Four Wheeler   Purchase Type New X    Requested CASA Details    Type of Account   Current Account    Purpose of Account    Overdraft Limit Required    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 Type  Select the loan type from the adjoining drop down list     Loan Purpose  Specify the Purpose of the loan     Vehicle Details       Vehicle Type  Select the type of vehicle for which the loan is requested from the adjoining drop down list     Purchase Type  Select he purchase type from the adjoining drop down list     ae ORACLE       2 2 5       Requested CASA Details       Type of Account  The system displays the type of account     Purpose of Account  The system displays the purpose of the account     Overdraft Limit Required  Check this box if overdraft limit is required     Document Details       Click on    Documents    link to invoke the Documents screen You can upload the required  documents from the external system       Documents  ME  Advices Checklist    Document Upload o  10f1         E    Document Category   Document Reference   Document Type   Remarks Ratio Uploz      w
70. ied  You can  double click a desired record to view the detailed screen     2 10 Maintaining Ratio Details       You can define templates for calculating financial ratios taken from the balance sheet  income  statement  statement of cash flows or statement of retained earnings within the product  You  can capture the template related details through the    Ratio Template Definition    screen     226 ORACLE       You can invoke this screen by typing    ORDTEMDF     in the field at the top right corner of the  Application tool bar and clicking the adjoining arrow button       Credit Ratio Maintenance  E  New E3 Enter Query    Group Id    Description    Ratio Id  1 0f1 Go  Ratiold  Description Formula                Maker Date Time  Checker Date Time  Mod No Record Status  Authorization Status       Specify the following details     Group Id  Specify the group id here     Description  Specify a brief description of the group id you are maintaining     Type  Select the credit ratio type from the adjoining drop down list  This list displays the following  values     e Retail   e Corporate  e Ijarah   e   stisna   e Mudarabah  e Murabaha  e Mushraka  e Tawarooq    Ratio Id  Specify the ratio id here     Description  Specify a brief description for the ratio id you are maintaining     eet ORACLE       Click the    Formula    button to build the ratio formula     Formula Wizard    Formula  10f1    W  Ratio Type   Condition Condition Builder       Stated Beton 2                       
71. ignation     Pool Currency    Select the pool currency code  The adjoining option list displays all valid pool currency codes  maintained in the system  Select the appropriate one     Pool Amount  System displays the pool amount     Pool Utilized  System displays the pool amount utilized     Collaterals Tab       You can capture the details related to the collaterals provided by the customer in this tab       Corporate Loan Application Entry wA  H save  lt i  Hoid  Application Category   ba Leadid Ga Application Number   CorporateLending3785  C   Product Code    e Enquiry ID il User Reference    Description fal Default Priority Low      Application Branch 000  Application Date 2011 01 04    Status   New Application    Main Details Financials  Requested Limits Collateral Comments    Collateral Details    m       100 HE Start Date Haircut    Collateral Branch   End Date Revaluation Date  apie Collateral Category   Revision Date  korsesi Collateral Type   Ni   Charge Type  jormal M  Collateral Description  ra Linked Percentage Utilization Order  Number  Collateral Currency   cvs Commitment Product  Collateral Value   Revalue Collateral  Market Value Based Vehicle Details Haircut Schedule J  Security Id 10F4 gt      104 HEE  Units Nominal Value I i  Vehicle ID   E  Effective Date   Haircut    Cap Amount  Vehicle Number  Guarantor Based Year  Guarantor Id Make  Rating Model  Body  Usage  Valuation Source   None v  4 m               Documents   Tradein   Customer Dedupe   LoanDedup
72. ils are included     On successful completion a message  stating that the task is successfully completed  gets  displayed     aS ORACLE       To acquire the next stage  you need to go to the    Task    menu and select    Assigned    under     Standard    option  All tasks that have been successfully completed are listed in the right side  of the screen  Select the checkbox against your    Workflow Ref No    and click    Acquire    button  at the top of the screen to acquire the next stage of the task     The system displays the system message as    Acquire Successful       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    Corporate Loan Approval    screen     Step 7 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       Corporate Loan Approval Stage   X       Save M  Hold    Application Category   Leadid Application Number    Product Code   Enquiry ID User Reference    Description Priority   Low  Application Branch 000  Application Date 2011 01 04    S
73. ing5705  C  Product Code    Asset  Model  Type    Manufacture Year  Sub Type  Body  Description  Assetid  p  Value  Source Wholesale  Supplement Base Retail  Edition Payment Amt       Validation Date eS Additions       Currency   a Total Transaction Value       You can capture the asset details and the valuation details of the asset in this screen        Note    For more details on Capturing Asset Valuation details  refer the section titled    Account As   set Valuation    in Retail Lending user manual        abe ORACLE       2 19 12 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  System displays the    Customer MIS    screen where you can    maintain the MIS details          Customer MIS    Application Number   CorporateLending4120       MIS Group    Default From MIS Group    iets Cuciaiiiy Composite MIS    Customer MIS Classes  10f1             MISClass MIS Code       PE          Customer No    Local Branch   000     Link to Group                   d ChangeLog   TransferLog    2 19 13 Capturing Customer Account MIS          You can capture the MIS details for the Customer Accounts in Customer Account MIS Screen   System displays the    Customer Account MIS    screen where you can maintain the MIS details       Customer Account MIS    Application Number   CorporateLending4120  Customer    Branch Code    Account    Account Class    Currency   GBP    Transaction MI
74. king    Bureau Report     button in    Corporate Loan Underwriting    screen     System displays the    Credit Bureau Report    screen where you can view the details     ate ORACLE         Credit Bureau Report                Application Number   RetailLending3852 Customer No   000006150  Requested Id   644 Bureau Code   EQFX  Report Header  Bureau EQFX Credit Report id 644  First Name ReportDate 2013 08 21  MiddleName Unique ld 644  Last Name On File Date 2013 08 21  Birth Date 1981 05 18  F  Best Match       Summary 2 Trade Lines PublicRecords Collections Fraud Messages Inquiries AlsoKnownAs Consumer Statement Credit Score     Life Recent Open  Chapter7 0 Chapter7 0 Chapter7  Chapter11 0 Chapter11 0 Chapter11  Chapter13 0 Chapter13 0 Chapter13  Total 0 Total 0 Total    4    2 19 19 2 Capturing Loan MIS Details       You can capture the Loan MIS details by clicking    Loan MIS    button in    Corporate Loan  Underwriting    screen  System displays the    Loan MIS    screen where you can capture the  details     Application Number   Product   Pi Unk To Group  Loan Account Number   Loan Branch      Financing Currency   f Deta      Input     Reixed Roterence Reizes Account  Retated Account Related Reference  MWS Head    Rate At    Rate Type interest Method    Reference Rate  Pool Code    Transaction MIS Composite MIS Fund MIS  MIS Group MIS Group MS Group  Transaction MIS 1 Composite MIS 1 Fund MIS 1  Transaction MIS 2 T Composte MIS 2 Fund MIS 2  Transaction MIS 3 Composite MIS
75. ks that have been successfully completed are listed in the right side  of the screen  Select the checkbox against your    Workflow Ref No    and click    Acquire    button  at the top of the screen to acquire the next stage of the task     The system displays the system message as    Acquire Successful   on successful acquisition  of the task     ae ORACLE       Step 8     Step 9     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    Corporate Loan Document  Verification    screen     Any advices maintained for this stage are generated after the completion of the stage     Document Verification    In the Document Verification stage  the documents captured in the previous stages are  verified  It is ensured that all documents in the checklist maintained are obtained from the  customer  In this stage  the application and applicant information captured as part of the  previous stages undergoes a final verification       Corporate Loan Document Verification Stage  len  Save ty  Hold    Application Category   Lead Id Application Number    Product Code   Enquiry ID User Reference    Description Priority   Low    Application Branch 000  Application Date 2011 01 04    Status  NewA  E
76. l                                               OTC Over the Counter   IRO Interest Rate Options   CO Currency Options   EOD End of Day   BOD Beginning of Day   FV Face Value   TV Time Value   IV Intrinsic Value   System the system Oracle FLEXCUBE system  unless otherwise specified    Organization    This manual is organized as follows        About this Manual gives information on the intended audience  It also lists    Chapter the various chapters covered in this User Manual       Corporate Loan Origination explains the workflow of a loan generation pro   Chapter 2   cess and procedure to define and maintain the prospective customer  details                 1 1 ORACLE       1 6    1 7       Maintenances describes about the general maintenance options available             Chapter to ensure successful functioning of a corporate loan origination process   Chapter 4 Reports lists the possible reports that can be generated for the module   Chapter 5 Function ID Glossary has alphabetical listing of Function Screen ID s used       in the module with page references for quick navigation           Related Documents       e The Procedures User Manual    e The Messaging System User Manual    e The Central Liability User Manual  e The Products User Manual    Glossary of Icons       This User Manual may refer to all or some of the following icons                               Icons Function     J Exit     J Add row     Delete row  Fasl Option List          1 2    ORACLE          2 1    
77. le 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        Contents    Preface iiine iiaea bP baat aaa teeta eect aaa te teeta na  1 1  We    UMMOMUGHON app ceciaded shies becdtesuetedeniendittatistdn eehensiddat Meduiece E EN AREE 1 1  V2  Auden CO int ncct eestor haa A edn cci eh ania T eased eteandhe Ar EE 1 1  1 3 Documentation Accessibility 0 00    eceeecreeeetceeeeeeeecneeeeeeeneeeeeeeaeeeeseetaeeeeseeaes 1 1  1 4 Acronyms and Abbreviations             ccceceeeeeeeeeneeeeeeeeneeeeeeeaaeeeeeeeaaeeeeeeeiaeeeeeeeaas 1 1  WD      QFOANIZAtlON  cee cedes pasha des testers secu added eviaachad aadecaeecsacaeedcnaytivengand toned ae teases uate 1 1  1 6     Related  Documents reren her tie tii Ab ad Meee aint 1 2  Wf     Glossary  OICONS ra r E eat AE EAE E ER 1 2  Corporate Loan Origination             ccccccceeeeeseeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeees 2 1  2O production eena a r a TA 2 1  2 2 Maintaining Loan Prospect Details        0       eccececceeeeeeeeeeeeeeeeeeeseeeeeeeeeeeaaeeeeseeaaeees 2 1  221 MAUR TaD e a hole cass a a a bad a Aa 2 3  2k DEOS TAIETE EA AE AE O 2 6  223 Financial Ffab orenian ienien AEL ERE LEES A AAEE S d ARE ia 2 8  22 4     R      est  d TaD a aa aa rad ae eae eaa a aE ae eoria eaan EAA 2 9  2 2 5  Document Detalls s siniserriiri iiit enii i ar ARENE AEREE ra TELA AE AT 2 10  2 2 6 Conversation Details osere renni EA O 
78. lication category details    The Corporate 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    The features  maintenances and the different stages in the process flow are explained in  detail in the following sections     Maintaining Loan Prospect Details       You can maintain the details of a prospective borrower or a loan applicant  when the borrower  initially approaches the bank enquiring about the various loan products that are being offered     The following details are captured as part of this maintenance     e Prospective customer s personal and location details  e Prospective customer s employment details    a ORACLE       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    ORDLEADWM    in the field at the top right corner of the  Application tool bar and clicking the adjoining arrow button                                                          Prospect Details   X  H sae 4  Hold  Leadid  Branch  000  az  Application Type  Retail i  Description 6l Date of Request   2011 01 04 Current Status NEW  New Account Number New Status  az   Request ID Conversation ID  az   Channel FLEXCUBE  az   Promotion Code  DEIJ Details Financial Requested  Applicant Details  10f14  st    I  ES       Sequen
79. make of the vehicle    Model   Specify the vehicle model    Body   Specify the vehicle body details     Usage  Specify the mileage used by the vehicle till date     These details will be used at the underwriting stage to evaluate the vehicle     208 ORACLE       2 19 8    Requested Tab       The details related to the requested loan can be captured in this tab  If you have selected an     Enquiry ID    for the customer  then the requested details that have been stored for the  corresponding loan proposal are displayed here          Corporate Loan Application Entry  o  H save Hold  Application Category   FE  Leadid  FE  Application Number   CorporateLending3785     Product Code    as  Enquiry 1D  asl User Reference    Description fal Default Priority Low      Application Branch 000    Status   New Application  Application Date 2011 01 04    Main Details Financials Requested Limits Collateral Comments  Financing Requested    Currency   FE  No of Installments Loan Purpose    Requested Amount   Unit Monthy    Rate   Frequency   Tenor In Months    12  Itemizations   tort Eee   ia itemization Comments  m  E   m E                 Documents   Tradeln   Customer Dedupe   LoanDedupe   CustomerMIS   Customer AccountMIS   Customer Account Fields    Previous Remarks Remarks Audit       You can capture the following details here     Currency    Specify the loan currency preference of the customer or select the currency from the option  list     Requested Amount  Specify the loan amount req
80. n system elements in Oracle FLEXCUBE     a ORACLE         Formula Maintenance    10f1  v Sequence Number      wi    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 corresponding score gets added  If the details do not satisfy the condition then zero will  be considered as default score    Functions   Select the mathematical function to be used to define the formula from the drop down list  provided    Braces   Select the opening or the closing brace from the drop down list provided  to define the credit  score calculation formula    Operators   Select the mathematical operator to be used to define the credit score calculation formula     3 6 6 oD    You can select                   or f     AA ORACLE       2 18 2    Logical Operators    Select the logical operator to be used to define the credit score calculation formula  You can  select  lt    gt   A  lt  gt   S  lt P        AND    or    OR        Based on the formula and the l
81. ne ORACLE       2 19 3 1    system decides whether to approve  reject  recommend approval or recommend rejection of  the application     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  The credit  check initiation happens before underwriting stage     Applicant Details       Existing Customer    Check this box to indicate if the customer applying for the loan is an existing customer of the  bank     Local Branch  Specify the applicant   s home branch     Account branch  Specify the applicant   s account branch     Customer No  For existing customers you need to select the customer number from the option list provided     Group Code  Select the group code from the adjoining option list     National ID  Specify the national ID     Click    Default    button to default the details of existing customers        Note    For more details on capturing Customer details  refer the chapter titled    Maintaining Cus   tomer Information Files    in Core Entities user manual        Fields    You can capture the user defined field details for the customer  if any by clicking    Fields     button  The    Customer UDF    screen gets displayed where you can maintain the UDF details     Customer UDF    UDF Details  100    m  Name          200 ORACLE       2 19 4    You can specify the following details in this screen     
82. neaaaeceeeeeeseeeeteeeneenenaneas 2 6  4 6 Underwriting Status By Month and Underwriter Report        seessseeeeseesrreseererrsseeee 2 7  4 6 1 Contents of the Report   0     1  1cccccccccceeeceeenseneceeeeeeeeeeeeseetecseeaaecaeceseeeeeteteteees 2 7  4 7 Underwriting Status By Month Report          cc ceecceeee tennessee eenneeeeeeeneeeeseseeeeeres 2 8  4 7 1 Contents of the REDOSE 2000    1    cccccccccceceneenecseceeeeeeeeeeeetetsesneeaaenaeeeteeteentenseess 2 9    Function  ID Glossary icc  cnet eto  2 1       1 1    1 2    1 3    1 4    1 5    1  Preface    Introduction       This manual is designed to help you maintain and process Over the Counter dealings in  Interest Rate and Currency Options in Oracle FLEXCUBE  It also assists you in handling all  the necessary activities in the life cycle of an OCT instrument once it is booked  This includes  the generation of messages and reports  the accrual and liquidation of interest components   the application of charges and taxes and so on     Audience       This manual is intended for the Customer Service Representatives  CSRs  and staff in charge  of setting up new products in your bank     Documentation Accessibility       For information about Oracle s commitment to accessibility  visit the Oracle Accessibility  Program website at http  Awww oracle com pls topic lookup  ctx acc amp id docacc        Acronyms and Abbreviations       The following are some of the acronyms and abbreviations you are likely to find in the manua
83. ng     a ORACLE       SDE Name  Specify a unique name for the SDE you are maintaining     SDE Description  Specify a description for the SDE you are maintaining     Data Type    Select the data type of the SDE from the adjoining drop down list  This list displays the  following values     e VARCHAR2  e Number  e Date   SDE Type    Select the SDE type from the adjoining drop down list  This list displays the following values     e Template  e Static    Derivation Required  Check this box indicate that derivation formula is required for the SDE     Derivation Formula    Specify the derivation formula here  You can also maintain the derivation formula in the     Condition Builder    screen which is invoked by clicking the    Formula    button       Condition Builder       Condition undefined          Business Rule    Braces        Te     i   dd  L       Specify the following details     Condition  Specify the condition for the rule here     d ORACLE       2 3    Business Rule       Braces  Select the braces from the adjoining drop down list     Functions  Select the functions from the adjoining drop down list     Elements  Select the elements from the adjoining option list  This list displays all valid elements  maintained in the system   Operators  Select the mathematical operators from the adjoining drop down list  This list displays the  following values    e Equal To   e Greater Than   e Greater Than or Equal To   e Less Than   e Less Than or Equal To   e Like   e Not Like  
84. nk also obtains the account opening form and related documents as part of  this activity     The following details are captured in this stage     af ORACLE       e Applicant information   e Applicant contact information  e Director s information   e Corporate information   e Facility   e Loan details   e Collateral details    Documents obtained from the applicant are also uploaded during this stage     You can key in the loan application details required in    Corporate Loan Application Entry     screen  You can also invoke this screen by typing    ORDCLAPP    in the field at the top right    corner of the Application tool bar and clicking the adjoining arrow button     Corporate Loan Application Entry    save ii  Hold                         Application Category   azl Leadid FA Application Number   CorporateLending3645  2   Product Code   fae  Enquiry ID Pa  User Reference    Description 2  Default Priority  Low _   Application Branch 000 Status  New Application     Application Date 2011 01 04   Eig  Details Financials Requested Limits Collateral Comments   Channel FA  EKYC Required ElExternal Credit Check  Intermediary Group azl auto Decision Required Required  pplicant Details  Branch 000 Pe Short Name   Telephone ISD Code   lad   Customer No   bel Customer Name Telephone   Existing Customer National ID Fax ISD Code   az  Category   azl Fax  Group Code faz  RMID PAJ Language   az   RM Name Country   PAJ  Nationality   PA  ccount Details Incorporation Business Description  
85. nto    Assignee Customer   Creston Date   gt Assimedis aj Warsow Reference Users tame Amount Fromtoje Priority   gt  Completed       Penang  Superson     Transsctoa  Reference  IstammicharamAccouret 362 Appicaben Entr ALROLES    Tie Assignad Group    Istammucharamaccoue ss 7  Applicaton Enty  ALURAES  IslarrucharamAccouet  75 Appacapce Ent  ALROLES    impor  CProcessFiow 1587 Receive and Venty   ALLROLES CCSERCLE  LC impot       All tasks that have been successfully completed are listed in the right side of the screen   Select the checkbox against your    Workflow Ref No    and click    Acquire    button at the top of the  screen to acquire the next stage of the task     The system displays the message as    Acquire Successful    on successful acquisition of the  task     Click    Ok    to proceed to the next stage  To select the acquired task for the next stage  select     Acquired    under    Standard    option in the    Task    menu  All the tasks that have been    20 gt  ORACLE       successfully acquired are displayed in the right side of the screen  Search for your workflow  reference number and click the    Workflow Ref No    to open    Corporate Loan Application  Verification    screen     Step 2 Application Verification    The information captured in the previous stage is verified in the Application Verification stage       Corporate Loan Application Verification Stage   X  4 Save iy  Hold    Application Category   Lead ld Application Number    Product Code   Enquiry
86. oan 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     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  7  Sequence Number   Score From   Score UpTo  Rate  No of Installments   Frequency   Units      7 i Monthly       You can specify the following details here   Sequence Number    System generates the sequence number     Score From  Specify the start credit score to pick the offer for the loan     Score Up To  Specify the end credit score to pick the offer for the loan     Rate   Specify the rate to be picked up for the score   No of Instalments   Specify the number of instalments for the offer   Frequency    Specify the frequency of the offer     Units    Select the frequency unit from the adjoining drop down list  You can select one of the  following     e Daily    aan ORACLE       2 19    e Weekly    e Monthly   e Quarterly   e Half Yearly  e Yearly   e Bullet    Stages in Corporate Loan Origination       The different stages in corporate lending process flow are designed using Oracle BPEL  framework  The process 
87. 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      Information captured in this stage include      Applicant Information      Corporate Information      Directors Information      Application details      Requested Loan Details      Facility Information      Collateral Details      Checklist      Documents  e Application Verification  e   Internal KYC  e External KYC  e Underwriting      Collateral Valuation Information      Applicant Financial Ratios      Applicant Credit Score      Applicant Bureau Report      Loan Offers      Loan Schedules      Loan Charges      Field Investigation      Document Capture      Advice Generation  e Loan Approval  e Document Verification      Information captured during Previous stages are verified    aA ORACLE       2 19 1        All documents obtained are verified against checklist  e Manual Retry    Process Flow Diagram       The process flow diagram given below illustrates the activities carried out during the different  stages of the workflow     ow bad  te   howe  o mse  a  t    
88. on Date    This is the date on which the application was made       Contract Date This is the date of the contract       Contract Currency   This is the currency of the contract       Contract Amount This is the total contract amount       Contract Term This is the total term of the contract       Contract Rate This is the rate of interest applicable       Branch Total This indicates the branch total                Underwriting Status By Month Report       This report lists application status by the month for loans  You can invoke the    Underwriting  Status By Month Report    screen by typing    CLRPUNMN    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  Report Format   PDF Printer At   Client  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     26 ORACLE       2 7 1    Contents of the Report   
89. onality    SON Remarks No Match       You can review the following KYC details     Applicant Number  System displays the Application number     Customer Number  System displays the customer number     KYC Review Details       Local Branch  System displays the local branch code     First Name  Specify the first name of the applicant     Middle Name  Specify the middle name of the applicant     Last Name  Specify the last name of the applicant     Date of Birth  Specify date of birth of the applicant     Country  System displays the country code of the applicant     Nationality  Specify the nationality of the applicant     System displays the following information   e KYC Internal Status  e KYC Internal Remarks  e SDN Status  e SDN Remarks    abr ORACLE       Based on the KYC and SDN statuses and remarks the reviewer decides whether to move the  task to the next stage     Click    Review    button to view all customer information and perform KYC and SDN checks  The  KYC Review Screen  STSKYCMN  and SDN Review Screens  ORSSDNMN  are displayed       KYC Maintenance Summary    Authorization Status Record Status    KYC Reference   Full Name of Customer  KYC Customer Type Risk Level    Advanced Search  Records per page 15 v 1 Of 1  Authorization Status Record Status KYC Reference Full Name of Customer KYC Customer Type Risk Lew               You can modify the KYC status and review based on the manual review done through KYC  Review screen     Alias Names Summary     ad Date of Birt
90. owing options     e 360  e 365    alt ORACLE       2 5    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    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     Corporate 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    Corporate Loan Underwriting Stage    screen     Viewing Simulated Loan Details       You can view a summary of the loans that have been simulated for prospects in    Corporate  Loan Simulation Summary    screen  You can also query for a particular record based on  desired search criteria     You can invoke this screen by typing    ORSCLSIM    in the field at the top right corner of the  Application tool bar and clicking the adjoining arrow button       Corporate Loan Simulation Summary    Authorization Status Record Status  Enquiry ID P  Application Category   Product Code  a3 Customer No   First Name Last Name   Status User Reference    Records per page 15 v 1 Of 1  Authorization Status Record Status Enquiry ID Application Category Product Code Customer No FirstName       
91. pect Details  save  lt i  Hold    Lead id    Description    View Offers  Request ID  Channel FLEXCUBE  Promotion Code       Main Details  AUEUGEI Requested  Income Details  10f1    F  Income Type   Frequency Currency      Business     Monthly E zl                             lt S        Branch  000  az   6  Date of Request   2011 01 04  New Account Number       Amount      Application Type  Current Status  New Status  Conversation ID       Retail x    NEW    MA             Ez                    Documents   Conversation    Maker  Checker    Income Details       Income Type    Date Time  Date Time     Mod No    Record Status    Authorization Status    Select the income type from the adjoining option list     Frequency    Select the frequency of the income of the applicant     Currency    Select the currency of the income from the adjoining option list     Amount    Specify the income amount     2 8       ORACLE       2 2 4 Requested Tab       You can capture the details related to the requested loan in    Requested    tab       Prospect Details    a  Save c  Hold       Lead Id  IST111 Branch   000  a3  Application Type Retai  Description example E  Date of Request   2011 01 06 Current Status NEW  New Account Number New Status  Request ID   Conversation ID  Channel FLEXCUBE  ae     Promotion Code  Main Details Financial Requested    Requested Loan Details    Requested Currency k Rate Loan Type Vehicle    Requested Amount Tenor In Months  12 Loan Purpose    Vehicle Details    Veh
92. ployment Details       Employer    Employment Type    Select the customer   s employment type from the drop down provided  The following options  are available     e Part Time   e Full Time   e Contract Based  Employer  Specify the name of the employer of the prospective customer   Occupation  Specify the occupation of the prospective customer   Designation  Specify the designation of the prospective customer   Employee Id  Specify the employee Id of the prospective customer   Address Line 1     4    Specify the employment address of the customer in four lines starting from Address Line 1 to  Address Line 4     Pincode  Specify the zip code associated with the office address specified     Country  Specify the country associated with the employment address specified     Phone Number  Specify the official phone number of the prospective customer     Extension  Specify the telephone extension number  if any  of the prospective customer     Contact Phone  Specify the contact phone number of the customer   s contact person     Contact Name  Specify the name of a contact person at the customer s office     Contact Extension  Specify the telephone extension number  if any  associated with contact person     a ORACLE       2 2 3    Comments    Specify comments  if any  related to the customer s employment     Department    Specify the department to which the customer belongs     Financial Tab       You can capture the details related to the finance in the    Financial    tab     Pros
93. pound years     Years    Select the actual number of days for the year from the adjoining drop down list  You can select  one of the following options     e 360  e 365  e Actual    Days in Month    Select the number of days that would constitute a month for calculation from the adjoining  drop down list  You can select one of the following options     e 30  euro   e 30 US   e Actual    2 19 22 1 Disbursal Details       You can capture the Loan Disbursal schedules details in    Disbursals    screen  You can invoke  this screen by clicking    Disbursement Details    button     Disbursais  Application Number CorporateLending4806 ComponentName MAIN_INT    Disbursals  10f1      i  Schedule Date Total Disbursement Amount Amount To Disburse Already Disbursed Amount    Split Details  10        Split Sequence No Split Percent     SplitAmount PaymentMode SettlementBranch Settlement Account Numbe                  The following details related to the Loan Disbursal schedules can be captured here     e Schedule Date   e Total Disburse Amount   e Amount to Disburse   e Already Disbursed Amount    The following Disbursal Schedule   s Split Details can be captured here     e Split Sequence No    aag ORACLE       e Split Percentage   e   Split Amount   e Payment Mode   e Settlement Branch   e Settlement Account Number   e Account Description   e Customer  amp  Settlement Currency    2 19 22 2 Viewing Schedule Details       You can view the modified schedule details    Schedule details    scre
94. ry     Other Details    You can capture the additional details related to the loan product here     Offer ID   Specify a unique identification for the loan offer being made to the customer   No of Installments   Specify the number of installments 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  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     Spread  Specify the spread that is applicable for the loan being offered     Effective Rate    The effective rate of interest gets displayed here  based on the interest and the spread  specified     Default    Check this box to indicate if the loan offer specified should be maintained as the default offer  for the application category     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     al ORACLE       2 16       Application Category Maintenance Detail    H save  lt i  Hold    Application Category   Application Type Retail  Category Description Rule id Fe   Ratio Id E   Pricing Group b
95. s customer     Facilities Proposed   Specify the details corresponding to the facilities that have been proposed by the corporate  customer    Approved Facilities   Specify the details corresponding to the facilities that have been approved by the corporate  customer    Recommended    Specify the details corresponding to the facilities that have been recommended by the  corporate customer     aot ORACLE       2 19 6    Terms and Conditions  Specify the terms and conditions associated with the credit application     Limits Tab    You can capture the Facility Information in    Limits    tab     Corporate Loan Application Entry    les  Save     Hold    Application Category   a    Leadid Application Number   CorporateLending4113  0   Product Code   FEI Enquiry 1D User Reference    Description fa Priority Low    Application Branch 000  Application Date 2011 01 04    Status   New Application    Main Details Financials Requested Limits Collateral Comments             Liability Details Line Details Availability  Liability Number ba Line Code FE  Start Date  m  Liability Name o Line Serial Expiry Date E   Main Liability No w  Main Line Code Last Available Date B  Liability Branch 000    Line Branch FE  Remarks fal  Liability Currency GBP  a   Line Currency La  Revolving Line  Overall Limit Limit Amount  Collateral Amount  Effective Line Amount Limit   Collateral      Basis  Effective Line Amount  Pool Details  Pool Code GJ  Pool Description  Pool Currency ba  Pool Amount  Pool Utilize
96. s made the enquiry about the loan  You  can also select the date by clicking the adjoining    Calendar    icon     ee ORACLE       2 2 1    New Account Number    Application Type    e Retail  e Corporate    e CASA  e Ijarah  e Istisna    e Mudarabah  e Murabaha  e Musharaka  e Tawarooq    Current Status    New Status    Select the new status from the adjoining option list  It is mandatory to select the new status if  the current status is    Closed        Rejected    or    Additional Document Required        Conversation ID    Main Tab   You can capture the following personal and geographical details related to a prospective  customer    Sequence Number   The system displays the sequence number    Type   Select the type of the customer from the adjoining drop down list    Existing   Check this box if you are an existing customer     Local Branch   Select the local branch of an existing customer from the adjoining option list   Customer No   Select the customer number from the adjoining option list    Default    Click on default button to default the details on existing customer     Short Name  Specify the short name of the customer     oe ORACLE       Customer Name  Specify the 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 primar
97. t       apee im m  a a  re      er  kd           i    r tep  ad were aieea roe a  Poer  oi    o r             r  oe eee  oe lore  ny    p ten Cee  ae ee        om t   Me iw  i     Ld t   oa    hd  ar w  sner i  d    e tew bore  ton Cea      beo    gt             sre x  owe  wae  ass a  apor          D        ad  gt     oe  be GL  EN  e Lg  Ses   wry  wre      gt   2    ove     tos armo  begbe 4        2 u baw ain  herd rra were  re  ba  ci Ai  K a  ere   n     co          ober    i a                    mau FF    The various tasks carried out in these stages will be explained in detail in the subsequent  sections        ORACLE       2 19 2    Process Matrix       The process matrix given below lists out the different stages  the user role handling each  stage  the function Ids involved and the exit points for each stage        Stage    Stage Title    Description    Function ID    Exit point       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    ORDCLAPP    PROCEED   CANCEL       Application  Verification    The details captured as  part of    Application  Entry    stage is verified    ORDCLVER    PROCEED   RETURN   CANCEL       Internal KYC    The applicant will be  verified for the internal  KYC check    ORDCLIKC    PROCEED   CANCEL             External  KYC   
98. t 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    Body of the Report   The following details are displayed in the report        Field Name    Field Description       Branch    This is the branch       Product code    This is the product code       Application Num   ber    This is the loan application number       Stage    This is the stage at which the application lies       Application Date    This is the date on which the application was made       Contract Date    This is the date of the contract       Contract Currency    This is the currency of the contract       Contract Amount    This is the total contract amount       Contract Term    This is the total term of the contract       Contract Interest    This is the rate of interest applicable       Branch Total          This indicates the branch total       ee ORACLE          2 6    2 6 1    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    CLRPUNMU in the  field at the top right corner of the Application tool bar and clicking on the adjoining arrow  button     Uluecl Write epo       Underwriting Status By Month and Underwriter Report    Branch  User    From Date  To 
99. tails       You can specify the formula to calculate the credit score by clicking the    Formula    button  corresponding to a credit risk entry in Risk Factor tab  The    Formula    screen is displayed  where you can specify the condition for calculating the credit score associated with a risk  condition               1 Of 1       E Sequence Number   Condition Result    fa    Elements   Index   Functions   Braces   Operators   Logical Operators       You can specify the following details here     Sequence Number  The sequence number is automatically generated by the system     Condition  The condition specified using the Elements  Functions  Operators etc  gets displayed here     Result  Specify the result to be associated with the condition specified     Elements   Specify the data elements to be used to define the formula for credit score calculation or select  the element from the option list provided    Functions   Select the mathematical function to be used to define the formula from the drop down list  provided    Braces   Select the opening or the closing brace from the drop down list provided  to define the credit  score calculation formula    Operators   Select the mathematical operator to be used to define the credit score calculation formula     3 6 6 OD    You can select                   or f     Logical Operators    Select the logical operator to be used to define the credit score calculation formula  You can  select L   gt      lt  gt    gt           lt       
100. tatus   New Application    Els Details Financials Requested Limits Collateral Credit Score Bureau Ratio Loan Component Charges Investigation Comments       Channel KYC Required External Credit Check  Required  Intermediary Group Auto Decision Required  Applicant Details  Branch Short Name   Telephone ISD Code    Customer No   Customer Name Telephone  Existing Customer National ID Fax ISD Code       Category Fax  Group Code RM ID Language    RM Name Country    Nationality    Account Details Incorporation Business Description  Account Branch Date  Account Class Currency    Account Capital  Net Worth  Country  Documents   Tradeln   KYC Review   CustomerDedupe   LoanDedupe   CustomerMIS   CustomerAccountMIS   Customer AccountFields   a  Previous 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     If the application details are verified successfully  the approver can proceed with the  processing of the application by selecting    PROCEED    as the Outcome  The approver can  select    RETURN    to return the process to previous stage for data correction or    CANCEL    to  terminate the process     On successful completion  a message stating that the task is successfully completed gets  displayed     To acquire the next stage  you need to go to the    Task    menu and select    Assigned    under     Standard    option  All tas
101. the schedule details for the offer you have selected     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       Corporate Lending Simulation Details ao  E  New  amp  Enter Query    Enquiry ID   Application Category   Status  Active    Branch   Product Code   User Reference      Enquiry Date Description  Customer Details  Customer No   First Name Contact Number  Last Name Email  Requested Loan Details  Requested Currency   Rate   Loan Purpose  Requested Amount   Tenor in Months  12  Loan Component  Component Name   Main Component 40f1  Component Curren z  p  urrency Capitalized   Exlode Schedule _   Liquidation Mode  Auto  Waive  Verity Funds Schedule Details    Schedules  10f1     E Schedule Type Schedule Flag Formula FirstDueDate NoofSchedules Units Frequency DueDateOn Schedule StartDatex EndDate Am            a T               Maker Date Time  Mod No  Checker    Date Time        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 foll
102. the system  Select the appropriate one     Line Branch    Select the line branch code  The adjoining option list displays all valid branch codes  maintained in the system  Select the appropriate one     Line Currency    Select the line currency code  The adjoining option list displays all valid line currency codes  maintained in the system  Select the appropriate one     Line Amount  Specify the line amount   Limit Amount    Specify the limit amount     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     Availability   Start Date   Specify the start date of the line from the adjoining calendar   Expiry Date   Specify the expiry date of the line from the adjoining calendar     Last Available Date  Specify the last availability date for the line from the adjoining calendar     Remarks  Specify the remarks for the line     Revolving Line  Check this box to indicate that the revolving line is required     206 ORACLE       2 19 7    Pool Details    Pool Code    Select the pool code  The adjoining option list displays all valid pool codes maintained in the  system  Select the appropriate one     Pool Designation  Specify the pool des
103. tion Status Record Status KYC Reference Full Name of Customer KYC Customer Type Risk Lew           Alias Names Summary    Date of Birth    Advanced Search  Records per page 15   101  Name Date of Birth          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     210 ORACLE       Step 6 Underwriting    2 19 16    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     After ascertaining the eligibility of the customer  the bank provides a facility offer to the  borrower and generates payment schedule and schedule details  The advices that are  maintained for the stage are generated on completion of the stage     In this stage  the bank also conducts vehicle evaluation based on the details that have been    captured at the    Application Entry    stage  This evaluation can be done with details from an  external agency in the collateral tab     Collateral Tab       You can carry out the evaluation of vehicles in the collateral tab  Here  the details provided as  part of the    Application Entry    stage are defaulted  which you can modify  The evaluation can  be done by
104. tion number                   Stage This is the stage at which the application lies  Application Date This is the date of application   Currency This s the currency of the contract   Product This indicates the product for the contract  Value Date This indicates the value date of the contract                oe ORACLE                         Field Name Field Description   Loan Amount This indicates the loan amount   Interest This indicates the interest rate for the loan   Term This indicates the duration of the contract   Branch Total This indicates the total number of records for the  branch   Maker This indicates the user ID of the maker of the  application                   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    CLRPCAUR    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  Branch  From Date  To Date    Report Format   PDF Printer At   Client       Report Output   Print Printer       Specify the following details     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 maintained in the system     Branch    Specify the branch for which you wish to g
105. to apply for the new offer     Click    Apply    button to apply the specified information     Loan Details  Loan Account Number  Specify the loan account number   Loan Branch  Specify the loan branch   Loan Currency  Specify the loan currency   Loan Amount  Specify the loan account   Down Payment  Specify the downpayment done for the loan   Value Date  Specify the value date for the loan   Maturity Date  Specify the maturity date of the loan   Instalment Start Date  Specify the instalment start date of the loan from the adjoining calendar   Status Change Mode  Select the status change mode from the adjoining drop down list   e Auto  e Manual  Close Collateral    Check this box to close collateral     No of Instalments  Specify the number of instalments for the loan     280 ORACLE       Frequency  Specify the frequency of the instalment     Unit  Select the unit of the instalment from the adjoining drop down list   e Daily  e Weekly  e Monthly  e Quarterly  e Half Yearly  e Yearly    Click    Apply    button to apply the specified information     Effective Date    Effective Date  Specify the effective date of the loan from the adjoining colander        User Defined Element Values       User Defined Element ID   Specify the user defined element ID  The adjoining option list displays all valid user defined  element IDs  You can select the appropriate one    User Defined Element Value   Specify the User Defined element value     Rate Code  Specify the rate code for the loan  The
106. turn 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 system displays the system message as    Acquire Successful    on successful acquisition  of the task     Click    Ok    to proceed to the next stage  To select the acquired task for the next stage  select     Acquired    under    Standard    option in the    Task    menu  All the tasks that have been  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    Corporate Loan Underwriting     screen     206 ORACLE       Step 3 Internal KYC Review    If the check box    KYC Required    is checked  then the bank performs the KYC check for the  applicant       KYC Review    Application Number   001005754 Customer No   001005754    YC Review Details   Local Branch KYC Internal Status No Match     First Name KYC Internal Remarks No Match  Middle Name SON Status  No Makhi      Yast Name  Date of Birth  Country  Nati
107. tus  Application Type    Application Category Category Description    Application Type L             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     Maintaining Pricing Details       Oracle FLEXCUBE allows you to maintain pricing groups and apply a suitable pricing rule to  an application category during corporate 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 Details    screen  To invoke the screen  type    ORDPRCMT in the field at the top right  corner of the application toolbar and click the adjoining arrow button     2 39    ORACLE       2 18               Pricing Maintenance  E New    Enter Query    Price Group ID   Price Type  Retail bd  Description    Pricing Details  10f1                  Price ID   Price Description Default Formula Offer    E Ofer                               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
108. tus NEW  New Account Number New Status a7   Request ID   Conversation ID a7   Channel FLEXCUBE na    Promotion Code  Applicant Details   Type   Primary Customer Name it  Main Details Financial Requested     Address Details          1020 BE Address 1   Pin Code  Aulikess Typo Address 2 Contact Number  SS Address 3 Country  Address 4  E Current  Employment Details  10 gt  GI Address 1 Extension  Empl Address 2 Contact Phone  m er Address 3 Contact Name  mployment Type   Full Time permanent   Address 4 Contact Extension  Occupation f   Country Department  Designation te Pin Code Comments  Employee Id io Phone Number  Business Details  Type of Business Currency  Name of Business Annual Turnover  Type of Ownership  Others  Documents   Conversation  Maker Date Time  Mod No  Checker Record Status  Date Time        Authorization Status       Address Details       Address Type    Select the address type of the customer from the following options provided in the drop down  list     e Correspondence Address  e Registration  Mailing    Check this box to indicate that the address you specify here is the customer   s mailing  address     Address Line 1     4    Specify the address of the customer in four lines starting from Address Line 1 to Address Line  4    Contact Number  Specify the contact telephone number of the customer     Pincode  Specify the zip code associated wit the address specified     26 ORACLE       Country  Specify the country associated with the address specified     Em
109. uble click a desired record to view the detailed screen     Simulating Corporate 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  e Loan offers selected by the Prospect    Based on the product  offers selected and requested details  the system will generate loan  and schedule details     ats ORACLE       You can enter the required details for the prospective customer in    Corporate Loan Simulation  Details    screen  You can invoke this screen by typing    ORDCLSIM    in the field at the top right  corner of the Application tool bar and clicking the adjoining arrow button      Corporate Lending Simulation Details       E  New  amp  Enter Query    Enquiry ID   Application Category   Status   Active  Branch   Product Code   User Reference    Enquiry Date Description   Detal  Customer Details  Customer No   FirstName Contact Number  Last Name Email    Requested Loan Details  Requested Currency   Rate   Loan Purpose  Requested Amount   Tenor In Months  12  EEY Component    Multiple Offers  10f1    E  Offerid   No ofinstallments Frequency Unit Rate RateCode Check Apply          Loan Details  Loan Branch   Value Date No ofInstallments 12  Loan Account Number   Maturity Date Frequency 1  Financing Currency Installment Start Date Unit   Monthly  Financing Amount   Status Change 
110. uested by the prospective customer     Interest Rate  Specify the preferred interest rate of the prospective customer     Tenor  in months   Specify the preferred loan tenor  in months  of the prospective customer     No 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 Purpose  Specify the Purpose of the loan     Itemization    Specify the tenor itemization that is required  For example  you can specify the itemizations  like    Booking Amount        Payment        Interiors    etc     208 ORACLE       2 19 9    2 19 10    Comments  Specify comments  if any  corresponding to the itemization     Comments Tab       In this tab  you can specify comments  if any  related to the loan application          Corporate Loan Application Entry    A   al Save F  Hold  Application Category   a   Leadid al Application Number   CorporateLending4113     Product Code      Enquiry ID Ga User Reference    Description fel Default Priority Low    Application Branch 000 Status  New Application       Application Date 2011 01 04           Main Details Financials Requested Limits Collateral Comments    Comments  10f1   I      E  Serial No   Comments   CommentBy Comment Date                        Documents   Tradeln   CustomerDedupe   LoanDedupe   CustomerMIS   CustomerAccountMIS   Customer Account Fields    Previous Remarks Remarks Audit 
111. ustomer can be contacted     E mail ID  Specify the e mail ID of the prospective customer     Requested Loan Details       You can enter the details requested by the prospect 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     Default Interest rate  Specify the preferred interest rate of the prospective customer     Tenor  In Months   Specify the preferred loan tenor  in months  of the prospective customer     Loan Purpose  Specify the purpose of the loan     Loan Tab    You can maintain the offers for the customer in the loan tab     anlo ORACLE         Corporate Lending Simulation Details  Eer New E3 Enter Query  Enquiry ID   Application Category   Status  Active    Branch   Product Code   User Reference    Enquiry Date Description  Customer Details  Customer No   First Name Contact Number  Last Name Email  Requested Loan Details  Requested Currency   Rate   Loan Purpose  Requested Amount   Tenor in Months   EUI Component  Multiple Offers  10f1                       e Offerid  No ofinstallments Frequency Unit Rate RateCode Check Apply                Loan Details  Loan Branch   Value Date No ofinstallments 12  Loan Account Number   Maturity Date Frequency 1  Financing Currency Installment Start Date B Unit   Monthly xj   Financing Amount   Status Change Mode  Auto X  Effective Date User Defined Element V
112. vices Checklist    Document Upload                         TE         Document Upload Remarks Ratio Upload Upload View    A i                   Document Path                         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     261 ORACLE       View  Click    View    to view the document uploaded     In    Corporate Loan Origination    process     Document Upload    feature is not available in all the  stages  Its availability in this process is given below                            View Avail   Stage Title Function Id Doe Catoni AproantAvaitanlg able Not  Exists  Not Available     Available    Application ORDCLAPP   Available Available Available  Entry  Application Veri    ORDCLVER   Available Available Available  fication  Underwriting ORDCLUND   Available Available Available  Facility Approval   ORDCLAPR   Available Available Available  Document Veri    ORDCLDVR   Available Available Available  fication  Customer    Account   Facil   ity   Loan   Col   lateral Creation                         2 19 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 Corporate Loan Application Entry screen                 Trade in Details    Application Number   CorporateLend
113. y applicant     City   The system defaults the city of the customer    Country   Specify the country of domicile of the customer or select the country code from the option list  provided    Nationality   Specify the country of which the customer is a national or select the country code from the  option list provided    Language   Specify the primary language of the customer or select the language from the option list  provided    Customer Category   Specify the category to which the customer belongs or select the customer category from the  option list that displays all valid customer categories    Financial Currency   Select the financial currency from the adjoining option list     Mobile Number  Specify the mobile phone number of the prospective customer     Landline No   Specify the land phone number of the prospective customer   E mail   Specify the e mail Id of the prospective customer     Fax  Specify the fax number of the prospective customer     Preferred Date of Contact  Specify the preferred date of contact     Preferred Time of Contact  Specify the preferred time of contact     First Name  Specify the first name of the customer     os ORACLE       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  canselect any of the following options     e Mr   e Mrs   e Miss  DrGender    Select the gender of the customer
114. y 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     a ORACLE       2 2 1    2 3    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       Application Number    This is the application number       Stage    This is the stage at which the application lies       Application Date    This is the date of application             Currency This s the currency of the contract  Product This indicates the product for the contract  Value Date This indicates the value date of the contract       Loan Amount    This indicates the loan amount       Contract Date    This indicates the contract date       Contract Interest    This indicates the rate of interest       Contract Term    This indicates the duration of the contract       Branch Tot
115. you can capture the comments by the users      Corporate Loan Underwriting Stage  X  H save ci  Hold    Application Category   Leadld Application Number     Product Code   Enquiry ID fas  User Reference    Description    Priority Low X  Application Branch 000    Application Date 2011 01 04    3     Status   New Application    Main Details Financials Requested Limits Collateral  Credit Score Bureau Ratio Loan Component Charges Investigation Comments     Comments  10f1          25   ea Serial No   Comments   Comment By Comment Date z  wi  S  Doc1                   Documents   Tradeln   KYCReview   CustomerDedupe   LoanDedupe   CustomerMIS   CustomerAccountMIS   Customer AccountFields      Previous Remarks Remarks Audit       You can capture the following details     Serial No  Specify the serial number of the comment     Comments  Specify comments  if any  to be associated with the loan application     Comments By  The system displays the commenter   s ID     Comment Date    Specify the date on which the comment was given or select the date by clicking the    Calendar     icon     If the underwriting stage is successfully completed  the underwriter can proceed with the  processing of the application by selecting    PROCEED    as the Outcome  The underwriter can  select    REJECT    to return the process to previous stage for data correction or    CANCEL    to  terminate the process  The underwriter can choose the outcome as VERIFY if the credit  bureau or vehicle evaluator deta
    
Download Pdf Manuals
 
 
    
Related Search
    
Related Contents
XL-BD601PH Operation-Manual DE  p3 u&i hard drive Manual  Gebrauchsanweisung  Tender Document - Shri Mata Vaishno Devi University  clicca qui - prodotti per piscine  DIÁRIO DO·CONG ESSa NACIONAL  Manual de instalación y funcionamiento Adsorbedor de carbón  CG Series Guitar Amplifiers  取扱説明書をダウンロード(PDFファイル)    Copyright © All rights reserved. 
   Failed to retrieve file