Home

Securitization of Loans User Manual

1. 8 29 ORACLE Message Message Message Tag Name Tag Type Tag Type Format Description Number _DATE_ Single Underlying Loan s Disbursement Date _LNFLAG_ Single Loan Exists Flag _LNACCN Multiple Underlying UM Loan s Account Number _LNACUS Multiple Underlying ERREF Loan s User Reference LNAMT Multiple Underlying Loan s Amount _LNCCY_ Multiple Underlying Loan s Loan Currency _LNSTATU Multiple Underlying S Loan s Account Status _LNDATE_ Multiple Underlying Loan s Date _LNMDAT Multiple Underlying E Loan s Maturity Date _LNTENO Multiple Underlying R_ Loan s Tenor _LNBNAM Multiple Underlying E Loan s Borrower Name _LNBID_ Multiple Underlying Loan s Borrower ID _SECLNEFL Single Loan Exists Flag AG_ _ACCNUM Multiple Underlying Loan s Account 8 30 ORACLE ORACLE Message Message Message Tag Name Tag Type Tag Type Format Description E Number _AC Multiple Underlying USERREF Loan s User _ Reference LOAMT Multiple Underlying Loan s Amount _LCCY_ Multiple Underlying Loan s Loan Currency _LSTATUS Multiple Underlying _ Loan s Account Status _LDATE_ Multiple Underlying Loan s Date _MDATE_ Multiple Underlying Loan s Maturity Date _LTENOR_ Multiple Underlying Loan s Tenor _LBNAME Multiple Underlying Loan s Borrower
2. Date Time Status Authorization Status Checker Date Time Here you need to capture the following details Contract Currency The system defaults the currency of the contract which is used for the service charge payment It will be always the contract currency Contract Reference Number Specify the securitization contract reference number to which the payment is made Value Date Specify the value date of the payment The system defaults it to application date However you can amend it Total Amount The system calculates and displays the total payment amount which is the sum of the individual component amount paid during the payment Customer Specify the associated SPV customer name Event Sequence Number Specify the event sequence number for the payment Limit Due Specify the limit date for the payment You can do a prepayment through selecting future dated schedule en ORACLE Click Populate Due button the system lists the payment overdue dues till the specified limit due date in the Liquidation details SH ORACLE 6 1 6 2 6 3 6 Online and Batch Process Introduction Oracle FLEXCUBE supports Online and Batch processes based on the options selected for Securitization Mode at Contract Input level The following options are available e Online If selected the system will invoke the securitization process at the time of authorization of securitization contract
3. e Batch If selected the system will save the securitization contract without initiating the securitization process and will change the internal status of the contract as Marked for Securitization Processing Intra day Batch Securitization process is initiated as part of intra day batch SZDSECR The system securitizes the underlying Loan accounts which are marked with Marked for Securitization status Post securitization process the system will update the internal status of the securitization contract as Securitized The below table lists the possible status Securitization mode Internal Status Post securitization status Online NA Securitized Batch Mode Marked for securitization Securitized If any one of the Loan Account s status change event fails then the system stops the securitization process and raises appropriate error message Skipping events is not enabled Once Loan Account is marked for Mark for Securitization as part of the securitization pool the system will not allow any operations to be performed on the underlying asset till the SZ contract s securitization process is complete The system supports securitization of CL MO and LE contracts EOD Batch The below table provides details about the batches run and stage when they are run for Securitization ot ORACLE SI No EOD Stage Sub Stage Module Batch 1 Post EOTI Stage 1 SZDSEC
4. 4 1 6 Specifying Charge Details eet e rtp e ep Ee Ee to 4 10 4 1 7 Capturing MIS Details ee boa eee rtr e eer RE 4 10 4 1 8 Specifying User Defined Fields e a enne entente enne nenne enne 4 11 4 1 9 Accounting Roles and Amount Tags for 5 4 12 5 SECURITIZATION CONTRACT seta suse ta sens senatus esses 5 1 5 1 INTRODUCTION eec ce tiger en rei tet pe re ee ute Pe o ERR UR i ER iess 5 1 5 11 Securitization Contract Life Cycle ct te doe tee ip eb ede 5 1 5 2 MAINTAINING CONTRACT DETAILS 5 9 5 2 1 Sp cifying Main Details ceca et epe Wet 5 10 5 2 2 Sp cifying Advice es cbs EEE PERO 5 12 5 2 3 Specifying Service Charge Details ite eeu P PEERS Re ERES a 5 13 5 2 4 Specifying ProfiNLoss Accrual Details 5 15 9 255 Viewing Securitization Pool Details o cette e tte 5 17 5 2 6 Adding or Deleting Loans from the Pool 5 18 5 2 7 Viewing Contract Charge Detdils siia e te o aee pee uen 5 23 5 2 8 Viewing Contract Event se dE PUR OR pene vedi 5 24 5 2 9 Viewing Securitization Contact History eese eee enne eene ene 5 24 2 2 10 Viewing Fields Details irens SS A tegen ee RpE Ae eee RY 5 26 2 Viewing MIS cn e PRU eR A RY 5 26 5 2 12 Authorizing Securitization
5. Component Details 4 180161 Stop Association Propagation Required Component Default From Class Description Charge Type Debit Credit Third Party Type Add Subtract a Net Consideration SWIFT Qualifier Advice Charge Event Details Event For Association Event For Application Description Description Event For Liquidation Basis Amount Tag Description Description Rule Details Settlement Currency Default Waiver Rule Capitalize Description Collect LC Advising Charges in Bills Other Details Allow Rule Amendment Amend After Application Amend After Association Consider as Discount Allow Amount Amendment Discount Basis Accrual Required H cv For further information on this screen refer chapter the Product Definition under Modularity User Manual 4 1 7 Capturing MIS Details You can retrieve MIS related information for a product by linking it to a Warehouse Code Linking a product to a warehouse code ensures that all contracts processed under the product are automatically tracked under the specified Warehouse Code 4 10 ORACLE Click MIS button to define the MIS details for the product you are creating MIS Details Product Code MIS Group Pool Code Default Frorn MIS Group MIS Classes Cost Code 14 4 10115 MIS Class MIS Code o La For further information on this screen refer chapter the Product Definition under Modularity User Manual 4 1 8 Specifying User Define
6. Date _LNTENO Multiple Underlying R_ Loan s Tenor _LNBNAM Multiple Underlying E Loan s Borrower Name _LNBID_ Multiple Underlying Loan s Borrower ID _SECLNFL Single Loan Exists Flag AG _ACCNUM Multiple Underlying _ Loan s Account Number _AC Multiple Underlying USERREF Loan s User Reference LOAMT Multiple Underlying Loan s Amount _LCCY_ Multiple Underlying Loan s Loan Currency _LSTATUS Multiple Underlying Loan s Account Status _LDATE_ Multiple Underlying Loan s Date _MDATE_ Multiple Underlying Loan s Maturity 8 28 ORACLE Message Message Message Tag Name Tag Type Tag Type Format Description Date _LTENOR_ Multiple Underlying Loan s Tenor _LBNAME Multiple Underlying Loan s Borrower Name _LBID_ Multiple Underlying Loan s Borrower ID Consolidate SZ LDSB SZ LDSB A Single Securitization d Loan ADV DV FMT _SZBRAN Branch Date Account CHDATE Disburseme nt Advice _BRANCH Single Securitization NAME Branch Name _SZSPV Single SPV Customer NAME Name _SZSPV Single SPV Address ADDR Line 1 LN1_ _SZSPV Single SPV Address ADDR Line 2 LN2_ _SZSPV Single SPV Address ADDR Line 3 LN3_ _SZSPV Single SPV Address ADDR Line 4 LN4_ _USERRE Single SZ User F Reference Number _SPVID_ Single Special Purpose Vehicles ID _SPVNAM Single SPV Name E _SREFNO Single SZ Contract Reference
7. Specifying Advice Details Click on the Advice tab to define the contract advice details Contract Details New Ze Enter Query Branch Contract Reference Product Code n User Reference i ees Product Description Operation 00 E sevice Charge Prot Accrual Advice Details M 4 Advice Name Party Type Party Name Medium Priority Pool Details Pool Addition Pool Deletion Settlement Events Event History Fields MIS Maker Date Time Status Authorization Status Checker Date Time Here you need to capture the following details Advice Details Advice Name The system defaults the list of advice reference number which has been generated during the various events of the contract Party Type The system defaults the part type Party ID The system defaults the party ID Party Name The system defaults the party name Medium The system defaults the advice message available medium ix ORACLE 5 2 3 Priority The system defaults the priority of the advice The system displays the latest 25 advices which are generated for the specified contract Specifying Service Charge Details Click on the Service Charge tab to define the service charge details Contract Details New Zen Enter Query Branch Product Code Bn Product Description Main Advices Service Charge ProfitLoss Accrual Service Charge Schedule 10017
8. 1 Fund MIS 2 Fund MIS 3 Fund MIS 4 Fund MIS 5 Fund MIS 6 Fund MIS 7 Fund MIS 8 Fund MIS 9 Fund MIS 10 Link To Group ORACLE Here you can view the MIS details for the securitization contract maintained at the product level 5 2 12 Authorizing Securitization Contract Details You can authorize contracts in the Securitization Authorize Contract screen You can invoke this screen by typing SZDTRAUT in the field at the top right corner of the Application Toolbar and clicking the adjoining arrow button Securitization Authorize Contract Contract Details Event Code Contract Reference Event Date Maker Rekey Fields Value Date Currency Maturity Date Contract Amount Generate Message Customer Contract Overrides 1010 Confirmed Override Remarks Authorized By Authorized Date You need to specify the following details here Contract Reference Specify the contract number which you are authorizing Maker Specify the maker Event Code The system displays a code for this authorizing event Event Date The system displays the current system date T ORACLE Rekey Fields Rekey the following details for authorizing a contract Currency Specify the currency as part of the re key requirements for authorizing a contract Contract Amount Specify the amount as part of the re key requirements for authorizing a contract Customer Specify the customer as part of the re key requirements fo
9. Contract Details 5 27 5 2 13 Amendment of Securitization Contracts ee esee eene nennen eene ene enne 5 28 5 2 14 Handling On line Payment for Service Charges eese eene 5 29 6 ONLINE AND BATCH PROCESS 6 1 6 1 INTRODUCTIONS esca eee te eO OR RE OUR ERE Vat EE ct I P EE trei tn 6 1 6 2 PROCESSING INTRA DAY BATCH 6 1 7 6 3 EE 6 1 REPORTS AA Aaa 7 1 7 1 INTRODUCTIONS ege ee dee 7 1 7 1 1 Viewing Summary of Securitization Pool 7 1 7 1 2 Viewing Summary of Securitization Pool Hietor 7 3 7 1 3 Viewing Summary of Payment Received by ADM 7 4 7 1 4 Viewing Summary of Over Due Payment Received by ADM 7 6 7 1 5 Viewing Summary of Disbursement Details for the Securitization Contract eese 7 7 7 1 6 Viewing Summary of Profit Loss Details for the securitization Contract eee 7 9 74 7 Viewing Summary of Securitization History Details 7 2 ANNEXURE 8 1 8 1 ACCOUNTING ENTRIES FOR SECURITIZATION OF LOAN mei 8 1 B 2 CR 8 1 5 3 AMOUNT DAG erede Oen qe ne Oa A e D re qe eR 8 2 gt ACCOUNTING ROLES eee ee EE Ee EE E 8 4 8 5 EVENT WISE ACCOUNTING ENTRIES nsp eteren eere then nnne nnt KAKA MIAKA IK Pah 8 4 Sp FORMULA ELEMENTS ana es ee bna ANY ee Re ene ES 8 11 8 75 A
10. PDF Printer At Client e Report Output Print Printer You can specify the following preferences for the report E ORACLE Branch Code You can generate a report based on the branch code Select a branch code from the option list provided Securitization ref No You can generate a report based on the securitization reference number Select a reference number from the option list provided Contents of the Report The following information is provided in the report Body of the Report Branch Code This is the branch code for which the report is generated Securitization ref number This is the securitization reference number for which the report is generated Account number desc order This is the account number in descending order for which the report is generated Product code This is the product code for which the report is generated Product category This is the product category for which the report is generated Customer ID This is the customer ID for which the report is generated Amount This is the loan amount for which the report is generated Currency This is the currency for which the loan amount is disbursed Value date This is the value date of the loan for which the report is generated Maturity date This is the maturity date of the loan for which the report is generated i ORACLE 7 1 2 Viewing Summary of Securitization Pool H
11. Processing Fee Components and Sale Activities Role Amount Tag Debit Credit Remarks SPV_SETTLE_ACC CHARGES Dr CHG_INC CHARGES Cr SPV_SETTLE_ACC LOAN_OUTSTANDING Dr SPV SETTL BRIDGE CR LOAN OUTSTANDING CR SPV SETTLE ACC SALE PROFIT DR For immediate realization PLAC INC SALE PROFIT CR SPV SETTLE ACC SALE PROFIT AC DR For periodic realization PLAC RIA SALE PROFIT AC CR PLAC EXP SALE LOSS DR For immediate realization SPV SETTL BRIDGE CR SALE LOSS CR PLAC PIA SALE LOSS AC DR For periodic realization SPV SETTL BRIDGE SALE LOSS AC CR SAMD It is an event for sale of additional loans accounts to SPV Addition of loan accounts to securitization pool During this event the system computes the total profit loss of the transaction Depending on the type of profit loss accrual mode set for product contract the system will either post the entries to RIA PIA GL for periodic accrual of Profit Loss to balance sheet or post it directly to the income expense GL The system triggers the CL status change event and changes the status from NORM to SECR The table below descries the accounting entries for Charges incurred during amendment 8 5 ORACLE Role Amount Tag Debit Credit SPV SETTLE ACC CHARGES Dr CHARGE CHARGES Cr COMPONENT INC The table below describes the accounting entries for S
12. You can manually generate a report that displays the future disbursement for the underlying CL LE MO Accounts for the securitization contract SPV for the specified period in the Summary of disbursement details for the securitization contract screen You can invoke this report screen by typing SZRDSBDT in the field at the top right corner of the Application Toolbar and clicking the adjoining arrow button Gei ORACLE Summary of disbursement details for the securitization contract Branch Code Securitization ref No From Date To Date Report Format PrinterAt Client e Report Output Printer You can specify the following preferences for the report Branch Code You can generate a report based on the branch code Select a branch code from the option list provided Securitization ref no You can generate a report based on the securitization reference number Select a reference number from the option list provided From date Enter the From date The system will generate a report for the securitization pool that have a From Date greater than the date you enter here To date Enter the To date The system will generate a report for the contracts that have a To date less than the date you enter here Body of the Report Branch code This is the branch code for which the report is generated Securitization ref number This is the securitization reference number for which the report is ge
13. _LNSTATU Multiple Underlying S Loan s Account Status 8 21 ORACLE Message Message Message Tag Name Tag Type Tag Type Format Description _LNDATE_ Multiple Underlying Loan s Date _LNMDAT Multiple Underlying E Loan s Maturity Date _LNTENO Multiple Underlying R_ Loan s Tenor _LNBNAM Multiple Underlying E Loan s Borrower Name _LNBID_ Multiple Underlying Loan s Borrower ID _SECLNFL Single Loan Exists Flag AO _ACCNUM Multiple Underlying E Loan s Account Number _AC Multiple Underlying USERREF Loan s User Reference LOAMT Multiple Underlying Loan s Amount _LCCY_ Multiple Underlying Loan s Loan Currency _LSTATUS Multiple Underlying E Loan s Account Status _LDATE_ Multiple Underlying Loan s Date _MDATE_ Multiple Underlying Loan s Maturity Date _LTENOR_ Multiple Underlying Loan s Tenor _LBNAME Multiple Underlying Loan s 8 22 ORACLE Message Message Message Tag Name Tag Type Tag Type Format Description _LBID_ Multiple Underlying Loan s Borrower ID Securitizatio SZ MAM SZ MAMD_ Single Securitization n Contract D ADV ADV FMT _SZBRAN Branch Date Maturity CHDATE_ Date Amendment _BRANCH Single Securitization Advice NAME _ Branch Name _SZSPV Single SPV Customer NAME Name _SZSPV Single SPV Address ADDR L
14. accounting entries It transfers all underlying loan contracts outstanding balance from the bank s ASSET GL LOAN ACCOUNT to SPV SETTL BRIDGE GL The system changes the Accrual GL for the interest and penal interest to BRIDGE GL For all underlying loans Accruals it calculates till sale date and posts to Income GL In case of underlying loan contracts where accrual frequency is not daily then the system performs a force accrual till sale date and post the same to Income GL e Post securitization the system continues the accrual of loan account The table below describes the accounting entries for Status change NORM or Status which are supporting continue accrual to SECR ve ORACLE Simple Loan Amortized Loan Principal Component Amortized Rule 78 Outstanding Principal is moved to SPV SETTL BRIDGE GL Interest Penal Interest Components Accrued interest till the sale date will be transfer to bank s Income GL GL for interest penal interest will be changed to Bridge GL Discounted Loan True Principal Component Discounted Loan Outstanding Principal is transferred to SPV SETTL BRIDGE GL Interest Penal Interest Components A sum equivalent of accrued interest till the sale date is transferred from MAIN INTRIA to bank s Income GL The balance interest amount in the MAIN INTRIA is transferred to Bridge GL account SPV Account 5 1 1 3 Amendment for Addition of Loan Accounts SAMD Additio
15. anendments when you press the Unlock button and trigger the events as per the below table SL Amendment Option Event triggering No 1 Amendment type is SALE addition of new System will trigger the SAMD event loan accounts to Pool while saving the contract 2 Amendment type is BUYBACK removal of System will trigger the BAMD event loan accounts from Pool while saving the contract 3 Amendment type is AMND Contract System will trigger the AMND event Modification other than Pool modification while saving the contract 4 Amendment type is RECOURSE System will trigger the RECR event Replacement of loans in the Pool while saving the contract The system enables the subsystem Pool addition and Pool deletion based on the amendment type 5 2 14 Handling On line Payment for Service Charges Oracle FLEXCUBE provides a facility to handle payment of service charges from SPV Special Purpose Vehicle through Securitization On line Payment Detailed screen You can invoke this screen by typing SZDPYMNT in the field at the top right corner of the Application Toolbar and clicking the adjoining arrow button SS ORACLE Payment Details New Sen Enter Query Contract Currency Customer Contract Reference ESN Value Date Populate Due Total Amount Limit Date Liquidation Details 1010 Component Currency Due Date Amount Due Amount Paid ia
16. branch code Select a branch code from the option list provided ER ORACLE Securitization ref no You can generate a report based on the securitization reference number Select a reference number from the option list provided From date Enter the From date The system will generate a report for the securitization pool that have a From Date greater than the date you enter here To date Enter the To date The system will generate a report for the contracts that have a To date less than the date you enter here Body of the Report Branch code This is the branch code for which the report is generated Securitization ref This is the securitization reference number for which the report is number generated Accrual date This is the accrual date for which the report is generated Event Code This is the event code for which the report is generated Profit Loss Type This is the profit loss type for which the report is generated Operation This is the operation Buy back amendment sale for which the report is generated Accrual amount This is the accrual amount for which the report is generated Accrual currency This is the accrual currency for which the report is generated 7 1 7 Viewing Summary of Securitization History Details You can manually generate a report that displays the summary Securitization history details for the specific CL LE MO account for a specified period in the Summary of
17. e Value Date e Customer ID e Customer Name e Formula e Condition e Rule Expression 5 2 6 Adding or Deleting Loans from the Pool Oracle FLEXCUBE provides a rule based mechanism to add additional loan accounts and remove previously bundled loans from the Pool SE ORACLE 5 2 6 1 Adding Loans to the Pool You can add new loans to the previously configured pool through Securitization Pool Addition screen Click on the Pool Addition button to add new loans to the pool Securitization Pool Addition Formula Name Rule Condition Condition Id Add To Pool Add All To Pool Search Result Account s 10710 E Account Branch Code Product Code Currency o Securitization Pool Account s 10M r7 Account Branch Code Product Code Currency n di Count Remove from Pool Remove All from Pool You need to capture the following details here Formula Name Select the formula for searching the loan contracts from the option list provided Condition ID Select the condition ID for searching the loan contracts from the option list provided Rule Condition Specify the rule condition is ORACLE Click on Search button to search for additional non securitized loan contracts The rule condition would include the standard set of CL attributes The system displays the loan accounts which are matching with contract currency After searching the details click on Add to Pool button t
18. has Credit balance Otherwise it will return 0 p ORACLE LOAN_OUTSTANDING_DR Amount tag returns value only when loan account standing balance has Debit balance Otherwise it will return 0 5 1 1 7 Liquidation of Payments As per the Securitization contract if any periodic charges are configured system liquidates the same either automatically or manually based on the configuration It generates the Debit Advice messages for the liquidation 5 1 1 8 Reversal of Payment The system reverses the payments received from SPV reversed 5 1 1 9 Closure of Contract After maturity of all underlying loan contracts system closes the securitization contract during the EOD cycle The system generates the Contract Closure Advice Message to SPV to indicate the closure of securitization contract If any of the underlying loan contract s maturity has been changed and if the maturity date is beyond the maturity date of securitization contract system will update the maturity date of securitization contract during the EOD cycle and generates the advice message 5 1 1 10 Accrual of Profit Loss and Periodic Service Charge If the securitization contract is configured to realize the Profit Loss over a period during EOD cycle system will trigger the PLAC event based on the frequency set in securitization contract and accrue the Profit and Loss accordingly And during EOD cycle based on the frequency set in securitization contra
19. scheduled date based on the pre defined schedule PLAC Realizing Profit Loss on the scheduled date RECR Replacement of loan transaction is securitized 8 1 ORACLE 8 3 Amount Tag The table below describes the Amount tags in securitization contract which supports accounting entries Amount Tag Description LOAN_OUTSTANDING For a New Contract Sum of Simple and amortized loans Outstanding Principal Interest Accrued till sale date Penalty accrued till sale date Overdue components Sum of Discounted type Loans Outstanding Principal RIA Balance For amendments SAMD Addition of new loans to Pool Sum of newly added Loans Simple and amortized loans Outstanding Principal Interest Accrued till sale date Penalty accrued till sale date Overdue components Sum of Discounted type Loans Outstanding Principal RIA Balance For amendments BAMD removal of loan accounts from Pool Sum of excluded loan Simple and amortized loans Outstanding Principal Interest Accrued till sale date ORACLE Amount Tag Description Penalty accrued till sale date Overdue components Sum of Discounted type Loans Outstanding Principal RIA Balance SALE_AMT For new Contract Sale Amount of the Securitization contract For amendment contracts Increased decreased in Sale Amount of the Securitization contract SALE_PR
20. serviced The servicer is generally obligated to maximize the payments from the borrowers to the issuer and is responsible for handling delinquent loans and foreclosures e Trustee A third party appointed to represent the investors interests in a securitization The trustee ensures that the securitization operates as set forth in the securitization documents which may include determinations about the servicer s compliance with established servicing criteria e Securitization Documents The documents create the securitization and specify how it operates One of the securitization documents is the Pooling and Servicing Agreement PSA which is a contract that defines how loans are combined in a securitization the administration and servicing of the loans representations and warranties and permissible loss mitigation strategies that the servicer can perform in event of loan default e Underwriter Administers the issuance of the securities to investors e Credit Enhancement Provider Securitization transactions may include credit enhancement designed to decrease the credit risk of the structure provided by an independent third party in the form of letters of credit or guarantees TOP eye Not all securitizations are identical For example the lender and the servicer are sometimes the same entity or in other arrangements brokers may not play a role Securitization takes the role of the lender and breaks it into separate
21. yearly e Yearly Start Reference Select the starting date for the Profit Loss accrual If it is Value Date system will take the value date as starting date and compute the schedule Incase if the starting date is Calendar Date system will compute the start date based on Month and Date specified Month Specify the month in which the first accrual has to begin if you set the accrual provisioning frequency as quarterly half yearly or yearly Day Specify the day on which the accrual provisioning has to be done Rekey Requirements If you wish to ensure re keying of values in certain fields of the contract during contract authorization you can indicate it here You can also select the fields for which you wish re keying to be done Specify the following details Rekey Required Indicate whether to avail the re key facility or not during contact authorization for contracts created using this product The options available are e Yes e No Amount Check this box to re key the amount during contract authorization 4 9 ORACLE 4 1 6 Currency Check this box to re key the currency during contract authorization Value Date Check this box to re key the start date during contract authorization Maturity Date Check this box to re key the end date during contract authorization Specifying Charge Details Click on Charges button to specify the charge details Charge Details Product Code Product Description
22. 7 1010 Account Account o F 3i Rernove from Pool Add To Pool Rernove All from Pool Add All To Pool In this screen you can identify the loan accounts from the non securitized loans to add newly into the securitization pool for swapping the loan accounts Also you can identify loan accounts which are part of the securitization pool and remove from the securitization pool SE ORACLE 5 2 7 Viewing Contract Charge Details You can view the charges for the securitization contract through Charge Details screen To invoke this screen click on Charges button Charge Details Contract Reference Charge Association 14 4 105 gt M E Creation ESN Component Description Consider as Discour d lt Charge Application 10710 oO Creation ESN Component Tag Currency Tag Amount Charge Currency Charge Amount lt Charge Liquidation ESN Component Charge Currency Charge Amount Liquidated o m Here you can view the applicable charges for the securitization contract mem ORACLE 5 2 8 Viewing Contract Event Details You can view the contract event details for the securitization contract through Events screen To invoke this screen click on Events button Reference Number Events 10f10 gt Event Number Event Date Event Code Description Authorization Status Accounting Entries Here you can view the triggered events
23. AM Single SPV Name E PMNTFL Single Payment Exists AG Flag 8 34 ORACLE Message Message Type Message Format Tag Name Tag Type Tag Description PAYAMT Single Securitization Contract Payment Amount PAYCCY Securitization Contract Payment Currency Single _PAYDAT Single Securitization E Contract Payment Date The table below describes the generation time and supported tag of the advices and its corresponding event Advice Name Event Generation Time Supported tags Securitization Book Advice BOOK Authorize SZ ADV FMT Securitization Init Advice INIT Authorize SZ ADV FMT Securitization contract AMND Authorize SZ_AMD_ADV Amendment Advice Sale Advice SAMD Authorize SZ_AMD_ADV Buyback Advice BAMD Authorize SZ_AMD_ADV Payment Advice LIQD Authorize SZ_PMNT_ADV Closure Advice Manual CLOS Authorize SZ_CLSR_ADV closure Consolidated Loan LAMD EOD SZ_LAMD_ADV Amendment statement Consolidated Loan LDBR EOD SZ_LDSB_ADV Disbursement Request Consolidated Loan Pre LPMT EOD SZ_PPAY_ADV payments received ORACLE 8 35 9 1 9 Screen Glossary Function ID List The following table lists the function id and the function description of the screens covered as part of this User Manual Function ID Function Des
24. DVICE MESSAGES pens eet Ee qe ente pe ient on 8 12 nnn 9 1 9 1 BEUNGTION E D WC WEEN 9 1 1 1 Introduction 1 About this Manual This manual is designed to help you to quickly get familiar with the Securitization of Loans module of Oracle FLEXCUBE It provides an overview of the module and guides you through the various steps involved in securitization of loans You can further obtain information about to a particular field by placing the cursor on the relevant field and striking the lt F1 gt key on the keyboard 1 2 Audience This manual is intended for the following User User Roles Role Function Back office data entry clerk Input functions for contracts Back office managers officers Authorization functions Product Managers Product definition and authorization End of Day operators Processing during End of Day Beginning of Day Financial Controller Product Managers Generation of reports 1 3 Abbreviations The following are the abbreviations used in this user manual Abbreviation Description SZ Securitization SPV Special Purpose Vehicle VAMI Value dated Amendments EOD End of Day cycle SECR Securitization INC Income P ORACLE Abbreviation Description PIA Paid in Advance RIA Received in Advance 1 4 Organization This manual is organized into the following c
25. GL to Bank s INCOME GL e Accrual is similar like SALE event The table below describes the accounting entries for Status change SECR or Status which are supporting continue accrual to NORM Simple Loan Principal Component Amortized Loan Amortized Rule 78 Outstanding Principal is transferred from SPV SETTL BRIDGE GL to LOAN ACCOUNT Interest Penal Interest Components Accrued interest till the sale date is transferred to SPV account or Bridge GL account GL for interest penal interest is changed to Bank INCOME GL dis ORACLE Discounted Loan True Principal Component Discounted Loan Outstanding Principal is transferred from SPV_SETTL_BRIDGE GL to LOAN ACCOUNT Interest Penal Interest Components Interest amount is calculated till the maturity date and it is posted to MAIN_INTARIA GL account and start accrue the interest and post the interest to Bank s Income GL 5 1 1 5 Amendment for Changing the Contract Details Amendment without Modifying the Securitization Pool The system triggers the AMND event and updates the modified contract details And it generates the Amendment Advice Message 5 1 1 6 Recourse of Loan Accounts During the course of the securitization contract SPV can replace the existing loan contracts in Securitization Contract with new loan accounts which are not part of securitization You can amend the contract through the Securitization Contrac
26. L StartDate End Date Frequency Contract Reference User Reference Operation Code Sale Amount Currency Details 10710 Start Date Due Date Amount Due Amount Settled Currency LCY Amount Pool Details Pool Addition Pool Deletion Settlement Events Event History Maker Checker Date Time Date Time Status Authorization Status Here you need to capture the following details Service Charge Schedule Start Date Specify the start date of the service charge schedule End Date Specify the end date of the service charge schedule 5 13 ORACLE Frequency Specify the frequency of the service charge schedule Amount Specify the amount of the service charge Currency Specify the currency of the service charge Details Start Date Specify the start date of the service charge Due Date Specify the due date of the service charge Amount Due Specify the amount due of the service charge Amount Settled Specify the amount settled of the service charge Currency Specify the currency of the service charge LCY Amount Specify the LCY amount of the service charge The system computes the service charge schedule during authorization of the contract SE ORACLE 5 2 4 Specifying Profit Loss Accrual Details You can define the profit loss realization period for transactions such as Sale Sale Amendments Buyback an
27. LBNAME Multiple Underlying Loan s Borrower Name _LBID_ Multiple Underlying Loan s Borrower ID Consolidate SZ_LAM SZ LAMD Single Securitization d Loan D ADV ADV FMT _SZBRAN Branch Date Account CHDATE Amendment Advice _BRANCH Single Securitization NAME Branch Name _SZSPV Single SPV Customer 8 26 Message Message Message Tag Name Tag Type Tag Type Format Description NAME Name _SZSPV Single SPV Address ADDR Line 1 LN1 _SZSPV Single SPV Address ADDR Line 2 LN2_ _SZSPV Single SPV Address ADDR Line 3 LN3_ _SZSPV Single SPV Address ADDR Line 4 LN4_ USERRE Single SZ User F Reference Number _SPVID_ Single Special Purpose Vehicles ID _SPVNAM Single SPV Name E _SREFNO Single SZ Contract B Reference Number _DATE_ Single Underlying Loan s Amendment Date _LNFLAG_ Single Loan Exists Flag _LNACCN Multiple Underlying UM Loan s Account Number _LNACUS Multiple Underlying ERREF Loan s User Reference LNAMT Multiple Underlying Loan s Amount _LNCCY_ Multiple Underlying Loan s Loan 8 27 ORACLE Message Message Message Tag Name Tag Type Tag Type Format Description Currency _LNSTATU Multiple Underlying S Loan s Account Status LNDATE Multiple Underlying Loan s Date _LNMDAT Multiple Underlying E Loan s Maturity
28. Multiple Underlying _ Loan s Account Status _LDATE_ Multiple Underlying Loan s Date _MDATE_ Multiple Underlying Loan s Maturity Date _LTENOR_ Multiple Underlying Loan s Tenor _LBNAME Multiple Underlying Loan s Borrower Name _LBID_ Multiple Underlying Loan s Borrower ID Securitizatio SZ_BAM SZ BAMD Single Securitization n Contract D ADV ADV FMT _SZBRAN Branch Date Buyback CHDATE Amendment Advice _BRANCH Single Securitization NAME Branch Name _SZSPV Single SPV Customer NAME Name _SZSPV Single SPV Address ADDR Line 1 LN1 _SZSPV Single SPV Address ADDR Line 2 LN2_ _SZSPV Single SPV Address ADDR Line 3 8 20 Message Message Message Tag Name Tag Type Tag Type Format Description LN3_ _SZSPV Single SPV Address ADDR Line 4 LN4_ _USERRE Single SZ User _ Reference Number _SVDATE_ Single SZ Contract Value Date _SBDATE_ Single SZ Contract Book Date _SMDATE Single SZ Contract Maturity Date _SPVID_ Single Special Purpose Vehicles ID _SPVNAM Single SPV Name E _SPOOLA Single Securitized Pool MI Amount SPOOLC Single Securitized Pool CY Currency _LNFLAG_ Single Loan Exists Flag _LNACCN Multiple Underlying UM Loan s Account Number _LNACUS Multiple Underlying ERREF Loan s User Reference LNAMT Multiple Underlying Loan s Amount _LNCCY_ Multiple Underlying Loan s Loan Currency
29. Name _LBID_ Multiple Underlying Loan s Borrower ID Consolidate SZ PPAY SZ PPAY A Single Securitization d Loan ADV DV FMT _SZBRAN Branch Date Account CHDATE pre payment Advice _BRANCH Single Securitization NAME Branch Name _SZSPV Single SPV Customer NAME Name _SZSPV Single SPV Address ADDR Line 1 LN1_ _SZSPV Single SPV Address ADDR Line 2 8 31 Message Message Message Tag Name Tag Type Tag Type Format Description LN2 _SZSPV Single SPV Address ADDR Line 3 LN3_ _SZSPV Single SPV Address ADDR Line 4 LN4_ _USERRE Single SZ User _ Reference Number _SPVID_ Single Special Purpose Vehicles ID _SPVNAM Single SPV Name E _SREFNO Single SZ Contract e Reference Number _DATE_ Single Underlying Loan s Pre Payment Date _LNFLAG_ Single Loan Exists Flag _LNACCN Multiple Underlying UM Loan s Account Number _LNACUS Multiple Underlying ERREF Loan s User Reference LNAMT Multiple Underlying Loan s Amount _LNCCY_ Multiple Underlying Loan s Loan Currency _LNSTATU Multiple Underlying S Loan s Account Status _LNDATE_ Multiple Underlying Loan s Date 8 32 ORACLE Message Message Message Tag Name Tag Type Tag Type Format Description _LNMDAT Multiple Underlying E Loan s Maturity Date _LNTENO Multiple Underlying R_ Loan s Ten
30. OFIT Applicable if the profit loss accrual is not set as required For new Contract Profit of the Securitization Sale contract For amendment AMND SAMD BAMD contracts Increased in Profit of the amendment contract SALE_PROFIT_AC Applicable if the profit loss accrual is set as required For new Contract Profit of the Securitization Sale contract For amendment AMND SAMD BAMD contracts Increased in Profit of the amendment contract SALE_LOSS Applicable if the profit loss accrual is not set as required For new Contract Loss of the Securitization Sale contract For amendment AMND SAMD BAMD contracts Increased in Loss of the amendment contract SALE_LOSS_AC Applicable if the profit loss accrual is set as required For new Contract ORACLE Amount Tag Description Loss of the Securitization Sale contract For amendment AMND SAMD BAMD contracts Increased in Loss of the amendment contract PLAC_PROFT Consolidated profit accrual for the securitization contract PLAC LOSS Consolidated loss accrual for the securitization contract 8 4 Accounting Roles The table below describes the accounting roles in Securitization contract the Securitization contract Accounting Role Description SPV_SETTL_BRIDGE Accounting role head for the Bridge GL SPV_SETTLE_ACC Accounting role head for the SPV Settlement Account PLAC_INC Bank real income GL for realizi
31. Pool Y Sale Currency SALE DA Single Securitized Pool TE Sale Date _SECLNFL Single Loan Exists Flag AG_ _ACCNUM Multiple Underlying E Loan s Account Number _AC Multiple Underlying USERREF Loan s User yA Reference LOAMT Multiple Underlying Loan s Amount _LCCY_ Multiple Underlying Loan s Loan Currency _LSTATUS Multiple Underlying Loan s Account Status _LDATE_ Multiple Underlying Loan s Date 8 15 ORACLE Message Message Message Tag Name Tag Type Tag Type Format Description _MDATE__ Multiple Underlying Loan s Maturity Date _LTENOR_ Multiple Underlying Loan s Tenor _LBNAME Multiple Underlying _ Loan s Borrower Name _LBID_ Multiple Underlying Loan s Borrower ID Securitizatio SZ AMN SZ AMND Single Securitization n Contract D ADV ADV FMT _SZBRAN Branch Date Amendment CHDATE Advice _BRANCH Single Securitization NAME Branch Name _SZSPV Single SPV Customer NAME Name _SZSPV Single SPV Address ADDR Line 1 LN1 _SZSPV Single SPV Address ADDR Line 2 LN2_ _SZSPV Single SPV Address ADDR Line 3 LN3_ _SZSPV Single SPV Address ADDR Line 4 LN4_ USERRE Single SZ User F Reference Number _SVDATE_ Single SZ Contract Value Date _SBDATE_ Single SZ Contract Book Date 8 16 ORACLE Message Message Message Tag Name
32. R 2 Stage 2 CLBATCH MODBATCH LEDBATCH 3 Stage 3 SZEOD 4 Post BOD Stage 1 CLBATCH MODBATCH LEDBATCH 5 Stage 2 SZEOD 6 2 ORACLE 7 1 7 Reports Introduction You may want to retrieve information on any of the several operations that were performed during the day in your bank You can generate this information in the form of reports in Oracle FLEXCUBE For every module you can generate reports which give you data about the various events in the life of a specific contract or across contracts at a specific point in time You can have analysis reports daily reports exception reports reports on events that ought to have taken place on the contract but have not due to various reasons history reports and so on A set of report formats is pre defined for every module However for securitization module special reports can be generated and is explained in the sections below 7 1 1 Viewing Summary of Securitization Pool You can manually generate a report that displays the list of participating CL MO LE accounts for the selected securitization contract securitization pool in the Summary of Securitization Pool Screen You can invoke this report screen by typing SZRPOACC in the field at the top right corner of the Application Toolbar and clicking the adjoining arrow button Summary of CL accounts under securitization pool Branch Code Securitization ref No ReportFormat
33. Securitization History Details screen You can invoke this report screen by typing SZRCLHIS in the field at the top right corner of the Application Toolbar and clicking the adjoining arrow button ns ORACLE Summary of securitization history details for the CL LE MO Accounts Branch Code Account Number From Date To Date ReportFormat PDF PrinterAt Client e Report Output Print Printer You can specify the following preferences for the report Branch Code You can generate a report based on the branch code Select a branch code from the option list provided Securitization Ref No You can generate a report based on the securitization reference number Select a reference number from the option list provided From Date Enter the from date The system will generate a report for the securitization pool that have a From Date greater than the date you enter here To Date Enter the To date The system will generate a report for the contracts that have a To date less than the date you enter here Body of the Report Branch code This is the branch code for which the report is generated Account number This is the account number for which the report is generated Securitization ref This is the securitization reference number for which the report is number generated Securitization date This is the securitization date for which the report is generated Operation This is
34. Securitization of Loan Oracle FLEXCUBE Universal Banking Release 12 0 May 2012 Oracle Part Number E51527 01 ORACLE FINANCIAL SERVICES ORACLE Securitization of Loan Table of Contents 1 ABOUT THIS MANUAL E 1 1 1 1 INTRODUCTION sere Po YO RUE A E T 1 1 1 27 ZAUDIENGE P DURER REED ONE mte URDU xD 1 1 EE RL EE 1 1 L4 ORGANIZATION E 1 2 E RELATED DOCUMENTS Dee Ee ee Ee geen e eech 1 2 1 627 GLOSSARY fives stesso ee e e Doe e a edere eee e 1 2 2 SECURITIZATION OF LOANS AN OVERVIEW u cssscssscsscsscssssssescsssnesscssescesssssesssssnessesnessossossosees 2 1 2 1 INTRODUCTION EE 2 1 K NG ERKENNEN 3 1 3 1 Le IER e 3 1 3 2 MAINTAINING RULE FORMULA DETAILS eeseeeeeeeeeeneeeneenen enne 3 1 3 24 Viewing Securitization Formula Maintenance Summary Details 3 3 4 DEFINING ATTRIBUTES FOR SECURITIZATION PRODUTCTSS eese sees enses testen tese tn tnnt 4 1 4 1 MAINTAINING SECURITIZATION PRODUCT eese nennen nnne nne nni E ERNES 4 1 4 1 1 Mapping Accounting Role to a GL Customer Account 4 2 4 1 2 Maintaining Events chev tec e e e eee e eo a chads ee Oe Sachs ee ERIS EMT 4 3 4 1 3 Maintaining Branch and Currency Restriction eee esee eene enne 4 3 4 1 4 Maintaining Customer Restriction aa oec ee ec Hee i erae d i echado 4 5 4 1 5 Maintdining Preferences ee ot wa e eO e ERR QR Hr ca ee e ie e decir recur Rs 4 5
35. T DR PLAC_INC SALE_PROFIT CR For immediate realization SPV_SETTLE_ACC SALE_PROFIT_AC DR PLAC_RIA SALE_PROFIT_AC CR For periodic realization PLAC_EXP SALE_LOSS DR For immediate realization SPV_SETTL_BRIDGE_CR SALE_LOSS CR PLAC_PIA SALE LOSS AC DR For periodic realization SPV SETTL BRIDGE CR SALE LOSS AC CR AMND It is an event for Amendment of Securitization Contract The system does not allow modifying the Pool details The table below describes the accounting entries for Charges incurred during Amendment Role Amount Tag Debit Credit SPV SETTLE ACC CHARGES Dr CHARGE CHARGES Cr COMPONENT INC The table below describes the accounting entries for Securitization Pool Amendment Role Amount Tag Debit Credit Remarks SPV SETTLE A SALE PROFIT DR For immediate CC realization PLAC INC SALE PROFIT CR SPV SETTLE A SALE PROFIT AC DR For periodic realization 8 7 ORACLE CC PLAC_RIA SALE_PROFIT_AC CR PLAC EXP SALE LOSS DR For immediate realization SPV SETTLE A SALE LOSS CR CC PLAC PIA SALE LOSS AC DR For periodic realization SPV SETTLE A SALE LOSS AC CR CC REVP It is an event for Reversal of Payment The table below describes the accounting entries for Reversal of Payments charge components Role Amount Tag Debit Credit SPV_SETTLE_ACC PRCH_LIQD Dr PRCH_INC PRCH_LIQD Cr LIQD It is an ev
36. Tag Type Tag Type Format Description _SMDATE Single SZ Contract _ Maturity Date _SPVID_ Single Special Purpose Vehicles ID _SPVNAM Single SPV Name E SPOOLA Single Securitized Pool MI Amount SPOOLC Single Securitized Pool CY Currency SECLNFL Single Loan Exists Flag AG _ACCNUM Multiple Underlying Loan s Account Number _AC Multiple Underlying USERREF Loan s User B Reference LOAMT Multiple Underlying Loan s Amount _LCOCY_ Multiple Underlying Loan s Loan Currency _LSTATUS Multiple Underlying gt Loan s Account Status _LDATE_ Multiple Underlying Loan s Date _MDATE_ Multiple Underlying Loan s Maturity Date _LTENOR_ Multiple Underlying Loan s Tenor _LBNAME Multiple Underlying Loan s Borrower Name ORACLE Message Message Message Tag Name Tag Type Tag Type Format Description _LBID_ Multiple Underlying Loan s Borrower ID Securitizatio SZ SAM SZ_SAMD_ Single Securitization n Contract D ADV ADV_FMT _SZBRAN Branch Date Sale CHDATE_ Amendment Advice _BRANCH Single Securitization NAME Branch Name _SZSPV Single SPV Customer NAME Name _SZSPV Single SPV Address ADDR Line 1 LN1_ _SZSPV Single SPV Address ADDR Line 2 LN2_ _SZSPV Single SPV Address ADDR Line 3 LN3_ _SZSPV Single SPV Address ADDR Line 4 LN4_ USERRE Single SZ User F Reference Number _SVDATE_ Single SZ Contrac
37. age Tag Name Tag Type Tag Type Format Description Branch Name _SZSPV Single SPV Customer NAME Name _SZSPV Single SPV Address ADDR Line 1 LN1_ _SZSPV Single SPV Address ADDR Line 2 LN2_ _SZSPV Single SPV Address ADDR Line LN3_ _SZSPV Single SPV Address ADDR Line 4 LN4_ USERRE Single SZ User F Reference Number _SVDATE_ Single SZ Contract Value Date _SBDATE_ Single SZ Contract Book Date _SMDATE Single SZ Contract Maturity Date _SPVID_ Single Special Purpose Vehicles ID _SPVNAM Single SPV Name E SPOOLA Single Securitized Pool MT Amount _SPOOLC Single Securitized Pool CY Currency _SALEAM Single Securitized Pool T Sale Amount _SALECC Single Securitized Pool Y Sale Currency 8 25 ORACLE ORACLE Message Message Message Tag Name Tag Type Tag Type Format Description _SALE_DA Single Securitized Pool TE_ Sale Date SECLNFL Single Loan Exists Flag AG _ACCNUM Multiple Underlying e Loan s Account Number _AC Multiple Underlying USERREF Loan s User _ Reference LOAMT Multiple Underlying Loan s Amount _LCCY_ Multiple Underlying Loan s Loan Currency _LSTATUS Multiple Underlying Loan s Account Status _LDATE_ Multiple Underlying Loan s Date _MDATE_ Multiple Underlying Loan s Maturity Date _LTENOR_ Multiple Underlying Loan s Tenor _
38. ails 1010 Event Code Description Oo lt Accounting Entries For further information on Events Accounting Entries and Advices refer Product Definition User Manual under Modularity User Manual 4 1 3 Maintaining Branch and Currency Restriction Click Branch amp Currency button and invoke the Branch Currency Restriction screen In this screen you have the option of allowing all the branches of your bank to use the product or restricting its use to only some branches 4 3 ORACLE By default when a new product is created no branches will be disallowed BranchiCurrency Restriction Product Code Product Description Class Code Class Description Branch Restrictions Disallowed Allowed Branch Code I4 dont 0 Branch Code Branch Name For further information on this screen refer chapter the Product Definition under Modularity User Manual Default From Class Currency Restrictions Disallowed Allowed Currency I4 4 1070 gt M E Currency Code Currency Name 4 4 ORACLE 4 1 4 Maintaining Customer Restriction Click Customer button to invoke the Customer Restrictions screen In this screen you can specify the categories of customers or the customers themselves with whom you can enter into bills involving the product Customer Restrictions Product Code Product Description Class Details Class Code Class Description Branch res
39. al and it cannot be combined in a single amendment Post securitization the system triggers CL events and posts the accounting entries according to the product configurations If the status of loan account is Marked for securitization then the system restricts performing account specific operations like amendment disbursement or payments on the same day until the securitization process is completed as part of intra day batch and also raises the following error message Islamic asset is under batch securitization 4 12 ORACLE 5 Securitization Contract 5 1 Introduction 5 1 1 5 1 1 1 Securitization Contract is a final entity to represent the securitization deal Each securitization contract is associated with pool of loan contracts securitization Pool and a SPV It allows both Selling Buyback of previously sold pool Securitization Contract Life Cycle The Securitization Contract Life Cycle consists of the following stages they are 1 Contract Booking 2 Contract Initiation Securitization Loan Sale 3 Amendment for addition of loan accounts 4 Amendment for removal of loan accounts 5 Amendment for change the contract details 6 Amendment for exchange of loan account Recourse of loan accounts 7 Liquidation of Payments 8 Reversal of Payment 9 Closure of Contract 10 Accrual of Profit Loss and Periodic Service Charge Contract Booking You can book a new contract based on the Pool information an
40. are available for constructing the formula Pre Defined Elements Description Type PRODUCT CODE Product Code VARCHAR2 BRANCH CODE Branch Code VARCHAR2 COLLATERAL AMOUNT Collateral Amount NUMBER LOAN STATUS Loan Status VARCHAR2 PRINCIPAL OUTSTAND Outstanding Principal NUMBER AMOUNT DISBURSED Disbursed Amount NUMBER AMOUNT NOT DISBURSED Undisbursed NUMBER Principal future scheduled disbursement amount LOAN TYPE Loan Type Discounted NUMBER True Discounted Amortized Amortized 78 TENOR OUTSTAND Outstanding Tenor NUMBER INTEREST RATE Rate of Interest NUMBER INTEREST TYPE Type of Interest NUMBER Floating Fixed PRINCIPAL PAYMENT FREQ Principal Payment NUMBER frequency INTEREST PAYMENT FREQ Interest Payment NUMBER frequency CUSTOMER TYPE Customer Type NUMBER CUSTOMER CITY Customer city location NUMBER COLLATERAL TYPE Collateralized Non NUMBER collateralized CREDIT SCORE Credit Rating NUMBER PAYMENT OUTSTAND Payment outstanding NUMBER LOAN CURRENCY Currency of Loan NUMBER ORACLE Pre Defined Elements Description Type CUSTOMER_CATEGORY Customer Category NUMBER PROD_CATEGORY Product category VARCHAR2 PROFIT_RATE Profit rate NUMBER FUND_ID Fund ID VARCHAR2 ACC_STATUS Account Status VARCHAR2 RP_STATUS Relationship Pricing VARCHAR2 Status 8 7 Advice Messages The table below describes the advice messages for the secu
41. ayment received Branch Code Securitization ref No From Date To Date Report Format PrinterAt Client e Report Output Printer You can specify the following preferences for the report Branch Code You can generate a report based on the branch code Select a branch code from the option list provided Securitization ref no You can generate a report based on the securitization reference number Select a reference number from the option list provided From date Enter the From date The system will generate a report for the securitization pool that have a From Date greater than the date you enter here To date Enter the To date The system will generate a report for the contracts that have a To date less than the date you enter here Body of the Report Branch code This is the branch code for which the report is generated Securitization ref This is the securitization reference number for which the report is number generated Account number This is the account number for which the report is generated Product code This is the product code for which the report is generated Product category This is the product category for which the report is generated m ORACLE Customer id This is the customer ID for which the report is generated Event code This is the event code for which the report is generated Component name This is the component name for wh
42. components Unlike the more traditional relationship between a borrower and a lender securitization involves the sale of the loan by the lender to a new owner the issuer who then sells securities to investors The investors are buying bonds that entitle them to a share of the cash paid by the borrowers on their mortgages Once the lender has sold the mortgage to the issuer the lender no longer has the power to restructure the loan or make other accommodations for its borrower That becomes the responsibility of a servicer who collects the mortgage payments distributes them to the issuer for payment to investors and if the borrower cannot pay action is taken to recover cash for the investors The servicer can only do what the securitization documents allow it to do These contracts may constrain the servicer s flexibility to restructure the loans Example A Financial institution has processed 10 housing loans under the total worth of 5 000 000 USD each loan for 500 000USD The Maximum Tenor for the loan is 20 Years and aggregated Monthly Installment for the housing loan is 50 000USD In order to overcome the financial crisis the financial institution decided to sell the loan assents and raise capital It sold the loan assets to an SPV for 7 000 000 USD and got the profit of 2 000 000 USD Once the contract has been signed after the legal verification the financial institution becomes the service provider for borrowers and SPV It trans
43. corresponding accounting entries and the advice message generated for the securitization contract maintained at the product level 5 2 9 Viewing Securitization Contact History You can view the securitization contact history details through Securitization History Details screen To invoke this screen click on Events History button Securitization History Details Contract Reference Securitization Event History 10f10 Event Code Value Date Pool Amount Pool Currency Contract Amount Contract 0 E Pool Details TS ORACLE Here the system displays the events triggered effective date execution date of the Event Pool Amount Contract Amount and Profit Loss of the transaction Oracle FLEXCUBE provides an option to view the underlying loan contracts when sale amendment and buyback transactions are processed for the amendment event system displays the newly added removed loan accounts from the pool The table below details the list of fields which are supported in the event history screen Securitization Event History Event Value Date Pool Pool Contract Contract Profit Loss Profit Loss Amount Currency Amount Currency Accrued Accrued INIT 5 5 2009 120000 USD 115000 USD 5000 0 0 0 SALE 5 5 2009 120000 USD 115000 USD 5000 0 2500 0 AMD 8 3 2009 123000 USD 121000 USD 2000 0 800 0 AMD 9 12 2009 110000 USD 112000 USD 2000 200 You need to select the event checkbox and press the Pool Details butt
44. cription SZDFRMNT Securitization Formula Maintenance SZDPRMNT Securitization Product Definition SZDPYMNT Securitization Payment Input Detailed SZDTRAUT Securitization Contract Authorization SZDTRONL Securitization Contract Input Detailed SZRCLHIS Summary of Securitization History Details SZRDSBDT Summary of disbursement details for the securitization contract SZRDSBDT Summary of overdue payments for SPV SZRPLACR Summary of profit and loss accrual details for the securitization contract SZRPOACC Summary of Securitization Pool SZRPOHIS Summary of Securitization Pool History Details SZRSPVPY Summary of overdue payments for SPV SZSFRMNT Securitization Formula Maintenance Summary 9 1 ORACLE ORACLE Securitization of Loans May 2012 Version 12 0 Oracle Corporation World Headquarters 500 Oracle Parkway Redwood Shores CA 94065 U S A Worldwide Inquiries Phone 1 650 506 7000 Fax 1 650 506 7200 www oracle com financial_services Copyright 2012 Oracle Financial Services Software Limited All rights reserved No part of this work may be reproduced stored in a retrieval system adopted or transmitted in any form or by any means electronic mechanical photographic graphic optic recording or otherwise translated in any language or computer language without the prior written permission of Oracle Financial Services Software Limited Due care has been taken to make this doc
45. ct for service charges system triggers PRCH event and passes the accounting entries During EOD cycle system updates the maturity date of the securitization contract if the maturity date of any one of the underlying loan contract s maturity date has exceeded the maturity date of securitization contract ORACLE 5 2 Maintaining Contract Details You can capture details of the securitization contract details in the Securitization Contract Details screen To invoke this screen type SZDTRONL in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button Contract Details New Ze Enter Query Branch Contract Reference Product Code n User Reference Sale Product Description Operation e BE oes Senice Charge ProfitLoss Accrual Contract Details Pool Details ProfitiLoss Accrual Book Date Pool Currency B Accrual Required Value Date Pool Amount Accrual Start Date Maturity Date ET Accrual End Date Currency Recourse Details SPV Details Contract Amount Securitization Mode Online Batch Outstanding Credit Customer Id Outstanding Debit Customer Name PaymentTo Bank Securitization Status Pool Details Pool Addition Pool Deletion Event History Fields MIS Maker Date Time Status Authorization Status Checker Date Time Here you can capture the following details Branch Specify the branch code Product Code Sele
46. ct on CL contracts e For all newly added Loan Accounts the system triggers the CL status change event and changes the status from NORM Status which are supporting continue accrual to SECR for all underlying and pass the below accounting entries It transfers all newly added loan accounts outstanding balance from the bank s ASSET GL LOAN ACCOUNT to SPV SETTL BRIDGE GL The system changes the Accrual GL for the interest and penal interest to BRIDGE GL For all newly added Loans Accruals it calculates till sale date and posts to Income GL In case of underlying loan contracts where accrual frequency is not daily then the system performs a force accrual till sale date and post the same to Income GL e For removal of Loan Accounts the system triggers the CL status change event and changes the status from SECR status to NORM and pass the below accounting entries It transfers the removed loan contracts outstanding balance from SPV SETTL BRIDGE GL to bank s ASSET GL LOAN ACCOUNT It changes the removed loan contracts GL for the interest penal interest from BRIDGE INCOME GL to Bank s INCOME GL Accrual is similar like BAMD event e Post securitization the system continues the accrual of loan account The table below provides details about amount tags maintained for recourse of loan accounts Amount Tag Description LOAN_OUTSTANDING_CR Amount tag returns value only when loan account standing balance
47. ct the appropriate product code for which securitization contract is booked Product Description Specify the product description for the selected product Contract Reference Number The system generates a unique number as contract reference number to identify the contract User Reference Number The system generates a unique user reference number to identify the contract Operation Code Select the appropriate operation that you can perform from the drop down list The options available are e Sale ES ORACLE e Buyback e Amend e Recourse The system defaults Sale as the default operation code 5 2 1 Specifying Main Details Here you need to capture the main details of the contract Contract Details Book Date Specify the booking date of the contract Value Date Specify the contract initiation date Maturity Date Specify the maturity date or max maturity date of the underling loan contract Contract Amount Specify the sale buyback amount of the pool Contract Currency Specify the currency of the transaction Securitization Mode Select the securitization mode from the following option e Batch e Online Note the following e f you select online securitization the system invokes the securitization process status change from the current status to SECR at the time of authorization of securitization contract e f you select batch securitization the system saves the securitization contract wi
48. curitization ref number This is the securitization reference number for which the report is generated Operation This is the operation Buy back amendment sale for which the report is generated Account number desc order This is the account number in descending order for which the report is generated Product code This is the product code for which the report is generated Product category This is the product category for which the report is generated Customer ID This is the customer ID for which the report is generated Loan amount This is the loan amount for which the report is generated Currency This is the currency for which the loan amount is disbursed Currency This is the currency for which the loan amount is disbursed Value date This is the value date of the loan for which the report is generated Maturity date This is the maturity date of the loan for which the report is generated 7 1 3 Viewing Summary of Payment Received by SPV You can manually generate a report that displays the summary of payment received details participating CL LE MO Accounts for the securitization contract SPV for the specified period in the Summary of Payment Received by SPV screen You can invoke this report screen by typing SZRSPVPY in the field at the top right corner of the Application Toolbar and clicking the adjoining arrow button ORACLE Summary of p
49. cy _LSTATUS Multiple Underlying Loan s Account Status 8 13 ORACLE Message Message Message Tag Name Tag Type Tag Type Format Description _LDATE_ Multiple Underlying Loan s Date MDATE Multiple Underlying Loan s Maturity Date _LTENOR_ Multiple Underlying Loan s Tenor _LBNAME Multiple Underlying Loan s Borrower Name _LBID_ Multiple Underlying Loan s Borrower ID Securitizatio SZ INIT SZ INIT AD Single Securitization n Contract ADV V FMT _SZBRAN Branch Date Init Advice CHDATE_ _BRANCH Single Securitization NAME Branch Name _SZSPV Single SPV Customer NAME Name _SZSPV Single SPV Address ADDR Line 1 LN1_ _SZSPV Single SPV Address ADDR Line 2 LN2_ _SZSPV Single SPV Address ADDR Line 3 LN3_ _SZSPV Single SPV Address ADDR Line 4 LN4_ USERRE Single SZ User F Reference Number SVDATE Single SZ Contract Value Date 8 14 ORACLE Message Message Message Tag Name Tag Type Tag Type Format Description _SBDATE_ Single SZ Contract Book Date _SMDATE Single SZ Contract _ Maturity Date _SPVID_ Single Special Purpose Vehicles ID _SPVNAM Single SPV Name E _SPOOLA Single Securitized Pool MI Amount _SPOOLC Single Securitized Pool CY Currency _SALEAM Single Securitized Pool T Sale Amount _SALECC Single Securitized
50. d Fields You need to click on Fields button to link the user defined fields to the product that you are defining Product User Defined Fields Product Code Product Description Fields 14 4 toro P M Field Number Field Name For further information on this screen refer chapter the Product Definition under Modularity User Manual 4 11 ORACLE 4 1 9 Accounting Roles and Amount Tags for Securitization The following are the Accounting Roles and Amount Tags for Securitization Accounting Role Description SPV_SETTL_ACC Accounting role for SPV settlement account All credit debit transaction for SPV is handled through the specified settlement account SPV_SETTL_BRIDGE_CR Bank GL account for SPV Credit Settlement bridge SPV_SETTL_BRIDGE_DR Bank GL account for SPV Debit Settlement bridge Note the following A loan account can be part of only one securitization pool Post securitization Interest penal interest accrual continues Post securitization the system does not allow readjustment backdated amendments for loans participating in the securitization pool It is handled operationally The system does not transfer schedule payments paid in advance and realized before securitization to SPV during securitization Securitization of loan contract booking is possible only in head office branch Post sale the system does not allow any amendments resulting in addition and remov
51. d Recourse Based on the schedule definition system computes the detailed schedules for profit loss realization The system triggers the Profit Loss accrual event during the EOD cycle and passes the accounting entries accordingly Click on the Profit Loss Accrual tab to capture the schedule details for the Profit loss realization Contract Details New 9 Enter Query Branch Contract Reference Product Code H User Reference i Product Description Operation Sous E Main Advices Service Charge BEE ProfitiLoss Schedules 10710 Version Reminder Frequency Start Date End Date Total Amount L1 H lt Details 1010 Version Number Start Date Due Date Currency LCY Amount T Pool Details Pool Addition Pool Deletion Settlement Events Event History Maker Status Authorization Status Date Time Checker Date Time Here you need to capture the following details Profit and Loss Schedule Version Specify the version of the profit and loss schedule Frequency Specify the frequency of the profit and loss schedule Start Date Specify the start date of the profit and loss schedule 5 15 ORACLE End Date Specify the end date of the profit and loss schedule Type Specify the type of the profit and loss schedule Total Amount Specify the total amount of the profit and loss schedule Unit Amount Specify the unit amount of t
52. d SPV details Accordingly the system generates the Securitization BOOK Advice messages 5 1 1 2 Contract Initiation Securitization Loan Sale Sale is a process of legally transferring the ownership of the loan asset from the bank to SPV as per the agreement The system carries the following tasks 1 The system initiates the booked securitization contract on the value date of the contract 2 It computes the Profit Loss for the transaction based on the outstanding principal interest payment as mentioned below Profit or Loss of contract e ORACLE SALE_AMOUNT Sum of Simple and Amortized type Loans outstanding Principal Interest Accrued till sale date Penalty accrued till sale date overdue components Sum of Discounted type Loans outstanding Principal RIA Balance 3 If securitization product is set to realize the profit loss immediately then the system posts the calculated profit loss directly to the bank s INCOME EXPENSE GL directly 4 If the securitization product is set to realize the profit loss over a pre defined period then the system computes the profit loss schedule internally and posts the entries accordingly during the EOD cycle 5 The system generates the Sale Advice Message Impact on CL contracts e The system triggers the CL status change event and changes the status from NORM Status which are supporting continue accrual to SECR for all underlying contract and pass the below
53. date The system will generate a report for the securitization pool that have a From Date greater than the date you enter here To date Enter the To date The system will generate a report for the contracts that have a To date less than the date you enter here Body of the Report Branch code This is the branch code for which the report is generated Securitization ref number This is the securitization reference number for which the report is generated Account number This is the account number for which the report is generated Product code This is the product code for which the report is generated Product category This is the product category for which the report is generated Customer id This is the customer ID for which the report is generated Event code This is the event code for which the report is generated Component name This is the component name for which the report is generated Due date This is the due date for which the report is generated Amount due This is the amount due for which the report is generated Payment received This is the payment received for which the report is generated Payment currency This is the payment currency for which the report is generated Payment date This is the payment date for which the report is generated 7 1 5 Viewing Summary of Disbursement Details for the Securitization Contract
54. duct Product Type Specify the type of the product Slogan Specify the slogan of the product 4 1 ORACLE Product Group Specify the product group Start Date Specify the product available start date End Date Specify the product available end date Remarks Specify short note about the product Mapping Accounting Role to a GL Customer Account You are allowed to map Accounting Role to a GL or a customer account The system defaults the GL configured in this screen in the Securitization Contract Online screen Click on Accounting Roles button to capture the details to map the accounting role to a GL or a customer account Accounting Roles Product Code Product Description Class Details Class Code Class Description 1010 Accounting Role Role Description Account Head Default From Class GL Description For further information on this screen refer chapter the Product Definition under Modularity User Manual 4 2 ORACLE 4 1 2 Maintaining Events Details You are allowed to define or specify the pre defined events in securitization product based on the nature of securitization You should click on the Events button to capture the details of the event In the Events screen you can attach the applicable events to the product Events Product Code Product Description Class Details Default From Class Class Code Class Description Event Det
55. ecuritization Pool Amendment Role Amount Tag Debit Credit Remarks SPV_SETTLE_ACC LOAN_OUTSTANDIN DR G SPV SETTL BRIDGE CR LOAN OUTSTANDIN CR G SPV SETTLE ACC SALE PROFIT DR For immediate realization PLAC INC SALE PROFIT CR SPV SETTLE ACC SALE PROFIT AC DR For periodic realization PLAC RIA SALE PROFIT AC CR PLAC EXP SALE LOSS DR For immediate realization SPV SETTL BRIDGE CR SALE LOSS CR PLAC PIA SALE LOSS AC DR For periodic realization SPV SETTL BRIDGE CR SALE LOSS AC CR BAMD It is an event for Buyback of loan accounts from SPV removal of loan accounts from securitization pool During this event the system computes the total profit loss of the transaction Depending on the type of profit loss accrual mode set for product contract the system will either post the entries to contingent GL for periodic accrual of Profit Loss to Balance sheet or post it directly to the income expense GL The system triggers the CL status change activity from SECR to NORM The table below describes the accounting entries for Charge components during Buyback Role Amount Tag Debit Credit SPV SETTLE ACC CHARGES Dr CHG INC CHARGES Cr The table below describes the accounting entries for the Buyback Activity ORACLE 8 6 Role Amount Tag Debit Cr Remarks edit SPV_SETTL_BRIDGE_DR LOAN_OUTSTANDING Dr SPV_SETTLE_ACC LOAN_OUTSTANDING Cr SPV_SETTLE_ACC SALE_PROFI
56. ed till sale date Overdue components Sum of excluded loan Discounted type Loans outstanding Principal RIA Balance e f securitization product is set to realize the profit loss immediately then the system posts the calculated profit loss directly to the bank s Income Expense GL directly e If the securitization product is set to realize the profit loss over a pre defined period then the system computes a schedule for the profit loss and posts the accounting entries accordingly during the EOD cycle e You need to maintain the Profit Loss as a separate slab for each amendment on sale contract and should not merge it with previously calculated profit loss e The system computes separate accrual schedule for profit and loss for that particular amendment based on the schedule defined during the amendment e During EOD the system computes the consolidated profit loss Netting is done on that due date and posts the accounting entries to Banks Income Expense GL e The system generates the Amendment Advice Message Impact on CL Contracts During the amendment the system triggers the change status event from SECR status to NORM for the removed contract from pool and passes the below accounting entries e It transfers the removed loan contracts outstanding balance from SPV SETTL BRIDGE GL to bank s ASSET GL LOAN_ACCOUNT e It changes the removed loan contracts GL for the interest penal interest from BRIDGE INCOME
57. ent for Manual Liquidation to liquidate the charges payments from to SPV The table below describes the accounting entries for collecting periodic service charges from SPV on due date Manual payment Role Amount Tag Debit Credit SPV_SETTLE_ACC PRCH LIQD Dr PRCH INC PRCH LIQD Cr PRCH The system triggers this event during EOD for collecting the service charges from SPV on scheduled date based on the pre defined schedule The table below describes the accounting entries for collecting periodic service charges from SPV on due date Role Amount Tag Debit Credit SPV SETTLE ACC PRCH CHG Dr 8 8 ORACLE PRCH_INC PRCH CHG Cr LPMT The system triggers this event during EOD if any payment has been triggered in underlying loan contract principal interest penalty and overdue components The system posts consolidated accounting entries posted to SPV accordingly for credit payment and debit payments The table below describes the accounting entries for posting the consolidated payments to from SPV on value date Role Amount Tag Debit Credit SPV SETTLE ACC LOAN PMNT DR DR SPV SETTL BRIDGE C LOAN PMNT DR CR R SPV SETTL BRIDGE D LOAN PMNT CR DR R SPV SETTLE ACC LOAN PMNT CR CR PLAC The system triggers the event during EOD for realizing the Profit Loss on the scheduled date The table below describes the accounting en
58. fers the monthly payments interest charges Fees Prepayment penalty charges directly to SPV as per the agreement SS ORACLE 3 Maintenances 3 1 Introduction Before you begin using the Securitization of Islamic Assets module you need to capture Formula Definition which is used to filter or identify the loan contracts that forms part of the securitization pool 3 2 Maintaining Rule Formula Details Oracle FLEXCUBE allows you to capture rule condition which is used to identify the loan contracts to form the securitization pool You can maintain the formula details in the Securitization Formula Maintenance screen You can invoke this screen by typing SZDFRMNT in the field at the top right corner of the Application toolbar and clicking on the adjoining arrow button Formula Maintenance Formula Name Description Rule Expression 1010 L1 Condition Id x Description Condition Rule Condition Maker Date Time Checker Date Time Record Status Authorization Status Here you can capture the following details Formula Name Specify the formula name Description Specify the description for the formula 3 1 ORACLE Condition ID Specify the condition ID Description Specify the description for the condition Rule Condition Specify the rule condition The system provides the following pre defined elements to form the rule expression Outstanding Principal Disbursed Amou
59. hapters Chapter 1 About this Manual gives information on the intended audience It also lists the various chapters covered in this User Manual Chapter 2 Securitization of Loans An Overview offers a snapshot of the features of the entire module Chapter 3 Maintenances details the procedure to set up static information related to the module Chapter 4 Defining Attributes for Securitization Products explains at length how to capture the details of the Securitization of Loans product in Oracle FLEXCUBE Chapter 5 Securitization Contract describes the Securitization Contract Life Cycle and processing of Securitization of Loans Chapter 6 Online Batch Process provides batch details related Islamic Securitization module Chapter 7 Reports describes various reports generated for Islamic Securitization module Chapter 8 Annexure contains a list of suggested events accounting entries amount tags and advices that can be set up for the Securitization module 1 5 Related Documents e Procedures e Settlements e User Defined Fields e MIS 1 6 Glossary of Icons This User Manual may refer to all or some of the following icons Si IA ORACLE is ORACLE 2 1 2 Securitization of Loans An Overview Introduction Securitization is the process of transformation of non tradable assets into tradable securities It is a structured finance process that distributes risk by aggregating debt inst
60. he profit and loss schedule Currency Specify the currency of the profit and loss schedule Total LCY Amount Specify the total LCY amount of the profit and loss schedule Unit LCY Amount Specify the unit LCY amount of the profit and loss schedule Details Version Specify the version of the profit and loss schedule Start Date Specify the start date of the profit and loss schedule Due Date Specify the due date of the profit and loss schedule Amount Specify the amount of the profit and loss schedule Currency Specify the currency of the profit and loss schedule SS ORACLE 5 2 5 Type Specify the type profit and loss schedule LCY Amount Specify the LCY amount of the profit and loss schedule Accrued Amount Specify the accrued amount profit and loss schedule The system computes the Profit Loss accrual schedule during authorization of the contract Viewing Securitization Pool Details Oracle FLEXCUBE provides a facility to view all the underlying loans which have been included as part of the securitization pool Click on the Pool Details button to view the list of loans bundled in securitization pool Securitization Pool Securitization Pool Details n B 1017 Account Branch Code Product Code Currency Here you can view the following details Account Branch Code Product Code Product Type Amount Currency Start Date 5 17 ORACLE e Maturity Date
61. ich the report is generated Due date This is the due date for which the report is generated Amount due This is the amount due for which the report is generated Payment received This is the payment received for which the report is generated Payment currency This is the payment currency for which the report is generated Payment date This is the payment date for which the report is generated 7 1 4 Viewing Summary of Over Due Payment Received by SPV You can manually generate a report that displays the summary of payments which are not received for the underlying CL LE MO Accounts for the securitization contract SPV for the specified period in the Summary of overdue payments for SPV screen You can invoke this report screen by typing SZRODYPT in the field at the top right corner of the Application Toolbar and clicking the adjoining arrow button Summary of overdue payment Branch Code Securitization ref No From Date To Date ReportFormat PDF PrinterAt Client e Report Output Print Printer You can specify the following preferences for the report Branch Code You can generate a report based on the branch code Select a branch code from the option list provided ER ORACLE Securitization ref no You can generate a report based on the securitization reference number Select a reference number from the option list provided From date Enter the From
62. ine 1 LN1_ _SZSPV Single SPV Address ADDR Line 2 LN2_ _SZSPV Single SPV Address ADDR Line 3 LN3_ _SZSPV Single SPV Address ADDR Line 4 LN4_ USERRE Single SZ User F Reference Number _SVDATE_ Single SZ Contract Value Date _SBDATE_ Single SZ Contract Book Date _SMDATE Single SZ Contract m Maturity Date _SPVID_ Single Special Purpose Vehicles ID _SPVNAM Single SPV Name E 8 23 ORACLE ORACLE Message Message Message Tag Name Tag Type Tag Type Format Description _SPOOLA Single Securitized Pool MI Amount _SPOOLC Single Securitized Pool CY Currency _SECLNFL Single Loan Exists Flag AG_ _ACCNUM Multiple Underlying _ Loan s Account Number _AC Multiple Underlying USERREF Loan s User _ Reference LOAMT Multiple Underlying Loan s Amount _LCCY_ Multiple Underlying Loan s Loan Currency _LSTATUS Multiple Underlying Loan s Account Status _LDATE_ Multiple Underlying Loan s Date _MDATE__ Multiple Underlying Loan s Maturity Date _LTENOR_ Multiple Underlying Loan s Tenor _LBNAME Multiple Underlying Loan s Borrower Name _LBID_ Multiple Underlying Loan s Borrower ID Securitizatio SZ_CLSR SZ_CLSR_A Single Securitization n Closure _ADV DV_FMT _SZBRAN Branch Date Advice CHDATE_ _BRANCH Single Securitization 8 24 Message Message Mess
63. istory You can manually generate a report that displays securitization contract history details for the specified intervals history of accounts which are involved in the sale buyback or amendment details for the securitization contract in the Summary of Securitization Pool History Details screen You can invoke this report screen by typing SZRPOHIS in the field at the top right corner of the Application Toolbar and clicking the adjoining arrow button Summary of securitization pool history details Branch Code a Securitization ref No PA From Date E To Date E ReportFormat PDF PrinterAt Client e Report Output Print Printer x You can specify the following preferences for the report Branch Code You can generate a report based on the branch code Select a branch code from the option list provided Securitization ref no You can generate a report based on the securitization reference number Select a reference number from the option list provided From date Enter the From date The system will generate a report for the securitization pool that have a From Date greater than the date you enter here To date Enter the To date The system will generate a report for the contracts that have a To date less than the date you enter here ORACLE Body of the Report Branch Code This is the branch code for which the report is generated Se
64. n of New Loan Account to Securitization Pool During the course of SPV contract SPV can increase the participating loan contracts in Securitization contract e You can amend the contract through Securitization Contract Online screen The system provides you an option to add new loan contracts to the existing Pool e You can compute the Profit Loss for the transaction based on the outstanding principal interest payment as mentioned below Profit or Loss of contract INCREASE IN SALE sum of newly added Loans Simple and Amortized type Loans outstanding Principal Interest Accrued till sale date Penalty accrued till sale date Overdue components Sum of newly added Loans Discounted type Loans i ORACLE outstanding Principal RIA Balance If you set the securitization product to realize the profit loss immediately then the system posts the calculated profit loss directly to the bank s Income Expense GL If you set the securitization product to realize the profit loss over a pre defined period system computes a schedule for the profit loss and posts the accounting entries accordingly during the EOD cycle You need to maintain the Profit Loss as a separate slab for each amendment on sale contract and should not merge it with previously calculated profit loss The system computes separate accrual schedule for profit and loss for that particular amendment based on the schedule defined during
65. nerated Account number This is the account number for which the report is generated Product code This is the product code for which the report is generated Product category This is the product category for which the report is generated ORACLE Branch code This is the branch code for which the report is generated Customer ID This is the customer ID for which the report is generated Component Name This is the component name for which the report is generated Due date This is the disbursement due date for which the report is generated Amount This is the disbursement amount for which the report is generated Currency This is the disbursement currency for which the report is generated 7 1 6 Viewing Summary of Profit Loss Details for the securitization Contract You can manually generate a report that displays the summary of profit loss accrual details for the securitization contract in the Summary of profit and loss accrual details for the securitization contract screen You can invoke this report screen by typing SZRPLACR in the field at the top right corner of the Application Toolbar and clicking the adjoining arrow button Summary of disbursement details for the securitization contract Branch Code Securitization ref No From Date To Date Report Format Printer At Client Report Output Printer You can specify the following preferences for the report Branch Code You can generate a report based on the
66. ng the income arising out PLAC_EXP Bank real expense GL for realizing the loss arising out the Securitization contract PLAC PIA Bank GL to realize the loss from securitization contract periodically PLAC_RIA Bank GL to realize the profit from securitization contract periodically SPV_SETTL_BRIDGE_CR Bank GL account for SPV Credit Settlement bridge SPV_SETTL_BRIDGE_DR Bank GL account for SPV Debit Settlement bridge 8 5 Event wise Accounting Entries In this section we will discuss the suggested events and advices that should be generated for that particular event in the life cycle of Securitization of Loans ORACLE INIT The system executes the INIT event when a contract is initiated on value date If the value date is application date then system triggers the BOOK and INIT event while booking the contract During this event system computes the total profit loss of the transaction Depending on the type of profit loss accrual mode set for product contract the system either posts the entries to RIA PIA GL for periodic accrual of Profit Loss to Balance sheet or posts it directly to the income expense GL The system generates the configured advices and sends as part of the INIT authorized The system triggers the CL status change event and changes the status from NORM to SECR It does not allow backdated future dated contract booking of securitization The table below describes the accounting entries for
67. nt Un Disbursed Principal future scheduled disbursement amount Loan Type Discounted True Discounted Amortized Amortized 78 Outstanding Tenor Rate of Interest Type of Interest Floating Fixed Payment Frequency Customer Type Customer City Location Collateralized Non collateralized Collateral Amount Credit Rating Payment Outstanding Currency of Loan Customer Category Product Category Account Status Relationship Pricing Status Module Code Fund Type Discounted True Discounted Amortized Amortized 78 Simple While creating the securitization pool the system computes the values for the elements dynamically and executes the expression ORACLE 3 2 1 You should use the Rule Name and Condition Name in securitization pool addition deletion screen to execute the specific condition The system allows you to modify the formula This modification will not have any impact on the already selected loan accounts in the securitization pool based on the modified formula Viewing Securitization Formula Maintenance Summary Details You can view the summary details of the Securitization Formula Maintenance in Securitization Formula Maintenance Summary screen You can invoke this screen by typing SZSFRMNT in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button Summary Authorization Status v Record Status Formula az Descri
68. o include the selected loan account for grouping to create the securitization pool If you want to include all the loan accounts to create the securitization pool you need to click on Add All to Pool button To remove the selected loan accounts from the pool click on Remove from Pool button To exclude all the loan accounts from the securitization pool click on Remove all From Pool button The system allows only loans for which Continue accrual flag is set to Y for the current status to participate in the Securitization pool 5 2 6 2 Removal of Loans from Pool You can remove loans from the pool through Securitization Pool Deletion screen Click on the Pool Deletion button to remove the loans from the pool Securitization Pool Deletion Formula Name Rule Condition Condition Id Search Remove from Pool Remove All from Pool Search Result Account s 10f10 Account Branch Code Product Code Amount Currency Count Securitization Pool Account s 10f10 Account Branch Code Product Code Amount Currency L1 n Count Se ORACLE You need to capture the following details here Formula Name Select the formula for searching the loan contracts from the option list provided Condition ID Select the condition ID for searching the loan contracts from the option list provided Rule Condition Specify the rule condition The system allows you to select
69. on to view participating loan accounts Securitization Pool Securitization Pool Details 100 Account Product Code Amount Currency Start Date Value Da n E Here the system displays the participating loan accounts for the securitization contract 3 29 ORACLE 5 2 10 Viewing Fields Details You can view the Fields details through Fields screen To invoke this screen click on Fields button Fields 4 41070 gt Field Name a Here you can view the Fields details for the securitization contract maintained at the product level 5 2 11 Viewing MIS Details You can view the MIS details through MIS screen To invoke this screen click on MIS button Contract Reference MIS Group Input Link To Group Related Reference Related Account Related Account Related Reference MIS Head Rate At Rate Type Interest Method Pool Code Refinance Rate Contract Level Pool Code Transaction MIS Composite MIS MIS Group MIS Group Transaction MIS 1 Composite MIS 1 Transaction MIS 2 Composite MIS 2 Transaction MIS 3 Composite MIS 3 Transaction MIS 4 Composite MIS 4 Transaction MIS 5 Composite MIS 5 Transaction MIS 6 Composite MIS 6 Transaction MIS 7 Composite MIS 7 Transaction MIS 8 Composite MIS 8 Transaction MIS 9 Composite MIS 9 Transaction MIS 10 Composite MIS 10 5 26 Fund MIS Rate Code Spread Cost Code 1 Cost Code 2 Cost Code 3 Cost Code 4 Cost Code 5 Fund MIS
70. or _LNBNAM Multiple Underlying E Loan s Borrower Name _LNBID_ Multiple Underlying Loan s Borrower ID _SECLNFL Single Loan Exists Flag AG_ _ACCNUM Multiple Underlying Loan s Account Number _AC Multiple Underlying USERREF Loan s User Reference LOAMT Multiple Underlying Loan s Amount _LCCY_ Multiple Underlying Loan s Loan Currency _LSTATUS Multiple Underlying Loan s Account Status _LDATE_ Multiple Underlying Loan s Date _MDATE__ Multiple Underlying Loan s Maturity Date _LTENOR_ Multiple Underlying Loan s Tenor _LBNAME Multiple Underlying Loan s Borrower Name 8 33 ORACLE Message Message Message Tag Name Tag Type Tag Type Format Description _LBID_ Multiple Underlying Loan s Borrower ID Securitizatio SZ PMN SZ PMNT Single Securitization n contract T ADV ADV FMT _SZBRAN Branch Date Payment CHDATE_ Advice _BRANCH Single Securitization NAME Branch Name _SZSPV Single SPV Customer NAME Name _SZSPV Single SPV Address ADDR Line 1 LN1_ _SZSPV Single SPV Address ADDR Line 2 LN2_ _SZSPV Single SPV Address ADDR Line 3 LN3_ _SZSPV Single SPV Address ADDR Line 4 LN4_ USERRE Single SZ User F Reference Number _SVDATE_ Single SZ Contract Value Date _SBDATE_ Single SZ Contract Book Date _SMDATE Single SZ Contract _ Maturity Date _SPVID_ Single Special Purpose Vehicle ID _SPVN
71. pe are used in combination to determine the actual rate applicable for currency conversion The default value for Rate Code is STANDARD This means that if you choose Mid Rate the mid rate maintained for the STANDARD code is used for the loans created under the product Rate Indicate the exchange rate applicable for the product you are maintaining The available options are 4 6 ORACLE e Mid Rate e Buy Sell Rate By default the Buy Sell Rate is used Liquidation You can specify the liquidation details here Liquidation Mode Indicate the mode of liquidation The options available are e Auto e Manual Tenor You can set the tenor details here Minimum Tenor Specify the minimum tenor of a product The tenor of the loan account that involves the product should be greater than or equal to the Minimum tenor that you specify Maximum Tenor Specify the maximum tenor for a product The tenor of the loan accounts that involve the product should be less than or equal to the Maximum tenor that you specify Default Tenor The default tenor is the tenor that is associated with a loan account involving this product The value captured here should be greater than the minimum tenor and less than the maximum tenor You can change the default tenor applied on a loan account during loan processing However the new tenor should be within the minimum and maximum tenors maintained for the product Unit Select
72. ption 2i a 0 Advanced Search Records per pagez 15 ze 1 oofa 1 Authorization Status Record Status Formula Name Description Module Code at 0G D D RL EI En ON pE Gm cU aeu wo wu gg eu In this screen you can query based on any combination of the following fields e Authorization Status e Formula Name e Record Status e Description After specifying the parameters for the query click Search button The system displays all the records matching the parameters specified 3 3 ORACLE 4 Defining Attributes for Securitization Products 4 1 Maintaining Securitization Product In this chapter we shall discuss the attributes for a Securitization Product You can maintain the securitization product details in the Securitization Product Definition screen You can invoke this screen by typing SZDPRMNT in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button Securitization Product Maintenance Product Code Product Description Product Type Slogan Product Group Start Date End Date Remarks Maker Date Time Checker Date Time Record Status Authorization Status Here you can capture the following details Product Code Specify the product code of the product Product Description Specify a short description about the pro
73. r authorizing a contract Value Date Specify the value date as part of the re key requirements for authorizing a contract Maturity Date Specify the maturity date as part of the re key requirements for authorizing a contract Generate Message Check this box to generate the messages Contract Overrides Here the system displays the following override details of the contract for all operations e Confirmed e Override Remarks e Authorized By e Authorized Date e Status e Remarks 5 2 13 Amendment of Securitization Contracts Oracle FLEXCUBE supports amendment of securitization contracts after authorization including or excluding of loan contracts to from the securitization pool SPV Special Purpose Vehicle may approach the financial institution to buy addition loans drop bad dept loans from the securitization pool contract as per the sale agreement This may lead to addition removal of loan contract in the securitization pool ae ORACLE The system also facilitates replacement of one or more loan accounts which are not securitized with another loan accounts which are part of the securitized contracts You can amend a securitization contract in the securitization contract screen itself During the amendment system allows you to update the sale amount and pool contracts alone During amendment the system triggers the AMND BAMD SAMD RECR event based on the amendment type selected The system allows you to capture the following type of
74. ritization product Message Message Message Tag Name Tag Type Tag Type Format Description Securitizatio SZ BOO SZ BOOK SZBRANC Single Securitization n Contract K ADV ADV FMT HDATE _ Branch Date Book Advice _BRANCH Single Securitization NAME Branch Name _SZSPV Single SPV Customer NAME Name _SZSPV Single SPV Address ADDR Line 1 LN1_ _SZSPV Single SPV Address ADDR Line 2 LN2_ _SZSPV Single SPV Address ADDR Line 3 LN3_ _SZSPV Single SPV Address ADDR Line 4 LN4_ USERRE Single SZ User F Reference Number _SVDATE_ Single SZ Contract 8 12 ORACLE Message Message Message Tag Name Tag Type Tag Type Format Description Value Date _SBDATE_ Single SZ Contract Book Date _SMDATE Single SZ Contract Maturity Date _SPVID_ Single Special Purpose Vehicles ID _SPVNAM Single SPV Name E SPOOLA Single Securitized Pool MT Amount SPOOLC Single Securitized Pool CY Currency _SALEAM Single Securitized Pool T Sale Amount _SALECC Single Securitized Pool Ke Sale Currency _SALE_DA Single Securitized Pool TE_ Sale Date _SECLNFL Single Loan Exists Flag AG_ _ACCNUM Multiple Underlying m Loan s Account Number _AC Multiple Underlying USERREF Loan s User Reference LOAMT Multiple Underlying Loan s Amount _LOCY_ Multiple Underlying Loan s Loan Curren
75. ruments in a pool and issues new securities backed by the pool When a bank or financial institution is in need of additional capital to finance a new facility to raise the fund instead of selling the assets the financial institution decides to sell the portion of the loan to a Trustee named as Special Purpose Vehicle SPV and collect the fund up front and remove the loan asset from the balance sheet of the institution SPV holds the asset as collateral in balance sheet and issues bonds to the investors It uses the proceeds from those bond sales to pay the originator for the assets The detailed securitization process with typical components has explained with typical components in the diagram below Ka E RE Mortgage Broker e Step 1 Borrower obtains loan from the financial institution bank with the help of Mortgage Broker After the loan issued the borrower and lender will not have much interaction with Mortgage Broker mm Loan Proceeds 1 Financial Instit tion p 999999 9 EES gt Lender ee Borrower Step 2 Lender Financial institution sells the GEN loan assets to Issuer SPV and provide the Servicer onthiy Payments service between the Borrower and Issuer SPV Step 3 The Issuer SPV sells the securities Trustee as a bonds to the Investor Sree ee ee E Underwriter assists the sale Underwritter Rating agency rates
76. t Value Date _SBDATE_ Single SZ Contract Book Date _SMDATE Single SZ Contract _ Maturity Date _SPVID_ Single Special Purpose Vehicles ID _SPVNAM Single SPV Name E SPOOLA Single Securitized Pool MI Amount 8 18 ORACLE Message Message Message Tag Name Tag Type Tag Type Format Description _SPOOLC Single Securitized Pool CY Currency _LNFLAG_ Single Loan Exists Flag _LNACCN Multiple Underlying UM Loan s Account Number _LNACUS Multiple Underlying ERREF Loan s User Reference LNAMT Multiple Underlying Loan s Amount _LNCCY_ Multiple Underlying Loan s Loan Currency _LNSTATU Multiple Underlying S Loan s Account Status LNDATE Multiple Underlying Loan s Date LNMDAT Multiple Underlying E Loan s Maturity Date _LNTENO Multiple Underlying R_ Loan s Tenor _LNBNAM Multiple Underlying E Loan s Borrower Name _LNBID_ Multiple Underlying Loan s Borrower ID _SECLNFL Single Loan Exists Flag AG_ _ACCNUM Multiple Underlying _ Loan s Account Number _AC Multiple Underlying USERREF Loan s User 8 19 ORACLE ORACLE Message Message Message Tag Name Tag Type Tag Type Format Description Reference LOAMT Multiple Underlying Loan s Amount _LCCY_ Multiple Underlying Loan s Loan Currency _LSTATUS
77. t Online screen with the recourse option The below formula explains the calculation related to recourse operation Profit or Loss of contract SALE AMOUNT Sum of newly added Simple and amortized loans Outstanding Principal Interest Accrued till sale date Penalty accrued till sale date Overdue components Sum of newly added Discounted type Loans Outstanding Principal RIA Balance Sum of excluded loan Simple and amortized loans Outstanding Principal Interest Accrued till sale date Penalty accrued till sale date ya ORACLE Overdue components Sum of Discounted type Loans Outstanding Principal RIA Balance Amount tags LOAN_OUTSTANDING_CR and LOAN_OUTSTANDING_DR are available for returning the credit or debit balance of replaced loan accounts The amount tags provide the netted value of newly added loan accounts and removed loan accounts 1 4 If securitization product is set to realize the profit loss immediately then the system posts the calculated profit loss directly to the bank s INCOME EXPENSE GL directly If the securitization product is set to realize the profit loss over a pre defined period then the system computes the profit loss schedule internally and posts the entries accordingly during the EOD cycle Consolidated balance of newly added removed loan accounts will be posted to securitization accounts The system generates the Recourse Advice Message Impa
78. the amendment During EOD the system computes the consolidated profit loss Netting is done on that due date and posts the accounting entries to Banks Income Expense GL The system generates the Amendment Advice Message Impact on CL contracts During the amendment new loan contracts are included in securitization Pool the system triggers the change status event for the newly added loan contract changes the status from NORM Status which are supporting continue accrual status to SECR and passes the below accounting entries The system transfers the new loan contracts outstanding balance from the bank s ASSET GL LOAN_ACCOUNT to SPV_SETTL_BRIDGE GL It changes the new loan account s GL for the interest penal interest from the bank s Income GL to the Bridge Income GL Accrual is similar like SALE event 5 1 1 4 Amendment for Removal of Loan Accounts BAMD Removal of Loan Account from Securitization Pool During the course of the SPV contract SPV can reduce the participating loan contracts in Securitization Contract You can amend the contract through the Securitization Contract Online screen The system computes the Profit Loss for the transaction based on the outstanding principal interest payment as mentioned below Profit or Loss of contract SALE AMOUNT sum of excluded loan Simple and Amortized type Loans outstanding Principal ve ORACLE Interest Accrued till sale date Penalty accru
79. the operation Buy back amendment sale for which the report ES ORACLE is generated From Status This is the from status for which the report is generated To Status This is the to status for which the report is generated E ORACLE 8 Annexure 8 1 Accounting entries for Securitization of Loan This section contains details of the suggested accounting entries that can be set up for the Securitization of Loan module of Oracle FLEXCUBE The details of the suggested accounting entries are given event wise 8 2 Events The following is an exhaustive list of events that can take place during the lifecycle of a Securitization of Loan In the subsequent paragraphs we shall examine the accounting entries and advices for each of the events listed below Event Code Event Description BOOK Booking Of Securitization Contract INIT Contract Initiation SAMD Sale of additional loans accounts to SPV BAMD Buyback of loan accounts from SPV AMND Amendment of Securitization Contract LIQD Manual Liquidation event to liquidate the charges payments from to SPV CLOS Auto Closure of Securitization Contract MAMD Update the Pool Maturity Date with the latest date of all underlying loans REVP Reversal of Payment LAMD Amendment of Loan Contract LDBR Disbursement of Loan Contract LPMT Payment of Loan Contract PRCH Collecting Service Charges from SPV on
80. the rule and condition for searching identifying the loan contracts for excluding from the securitization pool To remove the selected loan accounts from the pool click on Remove from Pool button To exclude all the loan accounts from the securitization pool click Remove all From Pool button To include the removed loan account into the pool click on Add to Pool button To include all the removed loan account into the pool click on Add All to Pool button If any of the underlying loan account has been closed or pre closed the system does not remove those loan accounts from the pool It will remain in the pool for future reference Sg ORACLE 5 2 6 3 Replacement of Loans in the Pool Recourse of Loan accounts Oracle FLEXCUBE allows you to replace one or more loan accounts which are not securitized with another loan accounts which are part of the securitized contract in the Securitization recourse Swaping of accounts screen To invoke this screen click on Recourse button Ei Securitization Recourse Swapping of accounts Formula Condition Id Rule Expression Add To Pool Add All To Pool Formula Condition Id Rule Expression Search Remove from Pool Remove All from Pool Search Result Account s Search Result Account s 10f10 1010 Account Account Branch Prod Account Account Branch 0 la n Li Count Count Securitization Pool Account s Securitization Pool Account s 108
81. the securities Credit enhancement agencies provides the Credit enhancement on securities Asset sales Cash Monthly Payments Issuer SPV Ratting Agency Step 4 Servicer will collect the monthly Credit enhancement payments from borrowers and remits to SPV Provider Cash Securities Monthly Payments Investors The roles and responsibilities of various components involved in the securitization structure are explained below e Borrower An Individual or organization which obtains loan from financial institution bank and pays the monthly payments e Mortgage Broker Acts as a facilitator between a borrower and the lender The mortgage broker receives fee income upon the loan s closing e ORACLE e ssuer A bankruptcy remote Special Purpose Entity SPE formed to facilitate a securitization and to issue securities to investors e Lender An entity that underwrites and funds loans that are eventually sold to the SPE for inclusion in the securitization Lenders are compensated by cash for the purchase of the loan and by fees In some cases the lender might contract with mortgage brokers Lenders can be banks or non banks e Servicer The entity responsible for collecting loan payments from borrowers and for remitting these payments to the issuer for distribution to the investors The servicer is typically compensated with fees based on the volume of loans
82. the tenor details for a product from the drop down list The options available are e Days e Months e Year Others You can set the buy back of pool details here 4 7 ORACLE Buyback of Pool Allowed Check this option to allow the bank to buy back the sold accounts Periodic Charges You can specify the periodic charges here Frequency Select the frequency of the periodic charges to be applied from the drop down list The options available are e Monthly e Quarterly e Half yearly e Yearly Start Reference Select the periodic charge starting day from the drop down list The options available are e Value Date e Colander Date Month Select the starting month of the periodic service charge It is applicable only when start reference is calendar date Day Specify the starting day from which charges should be levied It is applicable only when start reference as calendar date Charge Amount Specify the amount to be charged for the service during the period Currency Specify the service charge currency Profit Loss Accrual You can set the accrual details here 4 8 ORACLE Here Accrual Required Check this box to indicate that the component has to be accrued and provisioning is applicable Frequency If you have opted for accrual and provisioning for the components you have to specify the frequency for the same The frequency can be one of the following e Daily e Monthly e Quarterly e Half
83. thout initiating the securitization process The system will also change the internal status of the securitization contract and Islamic assets as Marked for Securitization pus ORACLE Pool Details Pool Amount Specify the pool amount of the underlying loan contracts which are under the process of Sale or Buyback Pool Currency Specify the currency of the pool Recourse Details You can maintain the following recourse details here Outstanding Credit The system displays the sum of NPV value of loan accounts which are newly included for sale Outstanding Debit The system displays the sum of NPV value of loan assets which are removed from the pool as part of recourse operation Payment To Select net payment direction you need for the recourse operation from the adjoining drop down list This list displays the following values e Bank SPV will pay the contract amount to the Bank as part of the recourse operation e SPV Bank will pay the contract amount to SPV as part of the recourse operation SPV Details Customer Identification Specify the customer ID of the SVP Name Specify the name of the SPV customer Profit Loss Accrual Accrual Required Check this box to indicate whether accrual required or not SE ORACLE 5 2 2 Accrual End Date Specify the end date of the accrual Based on the accrual end date the system populates the schedule to accrue the profit and loss during the EOD cycle
84. triction Categories List Default From Class Disallowed Allowed Customers 1015 Description o Customer Id Customer Name Restrii H Disal For further information on this screen refer chapter the Product Definition under Modularity User Manual 4 1 5 Maintaining Preferences You need to maintain the common attributes which are used to define the Securitization product in the Preference section 4 5 ORACLE Click Preferences button in Securitization Product Definition screen to maintain preferences for the specified securitization product Preferences Preferences Description Product Code Liquidation Tenor Rate Type STANDARD Liquidation Mode Auto Minimum Tenor Middle Rate Manual Default Buy Sell Rate Maximum Tenor Others Unit Buyback of Pool Allowed Periodic Charges Profit Loss Accrual Rekey Requirements Frequency D Accrual Required Rekey Required Yes Start Reference Frequency No Month Start Reference Amount Day Month Currency Charge Amount Day Date Maturity Date Currency Here you need to capture the following details Preferences You can set the preference details here Product Code The system defaults the product code Product Description The system defaults the product description Rate You can set the rate details here Rate Type Select the code that should be used for the product from the option list provided The Rate and Rate Ty
85. tries for realize the profit loss in real GL from the receivables Role Amount Tag Debit Credit PLAC RIA PLAC PROFT Dr PLAC INC PLAC PROFT Cr PLAC PIA PLAC LOSS Dr PLAC EXP PLAC LOSS Cr Note the following e Received in advance e Paid in Advance 8 9 ORACLE RECR The system supports this event in securitizing product and is triggered whenever the replacement of loan transaction is securitized The system compute the profit loss for the securitization contract anendment and pass the accounting entries accordingly Role Amount Tag Debit Credit SPV_SETTLE_ACC LOAN_OUTSTANDING_CR DR SPV_SETTL_BRIDGE_CR LOAN_OUTSTANDING_CR CR SPV_SETTL_BRIDGE_DR LOAN_OUTSTANDING_DR DR SPV_SETTLE_ACC LOAN_OUTSTANDING_DR CR PLAC_EXP SALE_LOSS DR SPV_SETTLE_ACC SALE_LOSS CR PLAC_PIA SALE_LOSS_AC DR SPV_SETTLE_ACC SALE_LOSS_AC CR PLAC_EXP SALE_LOSS_BR DR SPV_SETTL_BRIDGE_CR SALE_LOSS_BR CR PLAC_PIA SALE_LOSS_BR_AC DR SPV_SETTL_BRIDGE_CR SALE_LOSS_BR_AC CR SPV_SETTLE_ACC SALE_PROFIT DR PLAC_INC SALE_PROFIT CR SPV_SETTLE_ACC SALE_PROFIT_AC DR PLAC_RIA SALE_PROFIT_AC CR SPV_SETTL_BRIDGE_DR SALE_PROFIT_BR DR PLAC_INC SALE_PROFIT_BR CR SPV_SETTL_BRIDGE_DR SALE_PROFIT_BR_AC DR PLAC_RIA SALE_PROFIT_BR_AC CR SPV_SETTLE_ACC PRCH_LIQD DR 8 10 ORACLE 8 6 Formula Elements The elements mentioned in the table below
86. ument and accompanying software package as accurate as possible However Oracle Financial Services Software Limited makes no representation or warranties with respect to the contents hereof and shall not be responsible for any loss or damage caused to the user by the direct or indirect use of this document and the accompanying Software System Furthermore Oracle Financial Services Software Limited reserves the right to alter modify or otherwise change in any manner the content hereof without obligation of Oracle Financial Services Software Limited to notify any person of such revision or changes All company and product names are trademarks of the respective companies with which they are associated

Securitization of Loans User Manual

Contents

Download Pdf Manuals

Related Search

Related Contents