7. Reports
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.
This chapter contains the following sections:
- Section 7.1, "Summary of Securitization Pool Report"
- Section 7.2, "Summary of Securitization Pool History Report"
- Section 7.3, "Summary of Payment Received by SPV Report"
- Section 7.4, "Summary of Over Due Payment Received by SPV Report"
- Section 7.5, "Summary of Disbursement Details for the Securitization Contract Report"
- Section 7.6, "Summary of Profit Loss Details for the Securitization Contract Report"
- Section 7.7, "Summary of Securitization History Details Report"
7.1 Summary of Securitization Pool Report
This section contains the following topics:
- Section 7.1.1, "Generating Summary of Securitization Pool Report"
- Section 7.1.2, "Contents of the Report"
7.1.1 Generating Summary of Securitization Pool Report
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.
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.
7.1.2 Contents of the Report
The following information is provided in the report.
Body of the Report
| Field Name | Field Description | ||
|---|---|---|---|
| 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. | ||
| Customer Name | This is the customer name 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. |
7.2 Summary of Securitization Pool History Report
This section contains the following topics:
- Section 7.2.1, "Generating Summary of Securitization Pool History"
- Section 7.2.2, "Contents of the Report"
7.2.1 Generating Summary of Securitization Pool History
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.
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.
7.2.2 Contents of the Report
Body of the Report
| Field Name | Field Description | ||
|---|---|---|---|
| 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. | ||
| 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. | ||
| Customer Name | This is the customer name 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.. | ||
| 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.3 Summary of Payment Received by SPV Report
This section contains the following topics:
- Section 7.3.1, "Generating Summary of Payment Received by SPV Report"
- Section 7.3.2, "Contents of the Report"
7.3.1 Generating Summary of Payment Received by SPV Report
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.
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.
7.3.2 Contents of the Report
Body of the Report
| Field Name | Field Description | ||
|---|---|---|---|
| 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.4 Summary of Over Due Payment Received by SPV Report
This section contains the following topics:
- Section 7.4.1, "Generating Summary of Over Due Payment Received by SPV Report"
- Section 7.4.2, "Contents of the Report"
7.4.1 Generating Summary of Over Due Payment Received by SPV Report
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.
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.
7.4.2 Contents of the Report
Body of the Report
| Field Name | Field Description | ||
|---|---|---|---|
| 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.5 Summary of Disbursement Details for the Securitization Contract Report
This section contains the following topics:
- Section 7.5.1, "Viewing Summary of Disbursement Details for the Securitization Contract Report"
- Section 7.5.2, "Contents of the Report"
7.5.1 Viewing Summary of Disbursement Details for the Securitization Contract Report
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.
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.
7.5.2 Contents of the Report
Body of the Report
| Field Name | Field Description | ||
|---|---|---|---|
| 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. | ||
| Customer Name | Indicates the customer name. | ||
| 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.6 Summary of Profit Loss Details for the Securitization Contract Report
This section contains the following topics:
- Section 7.6.1, "Generating Summary of Profit Loss Details for the Securitization Contract Report"
- Section 7.6.2, "Contents of the Report"
7.6.1 Generating Summary of Profit Loss Details for the Securitization Contract Report
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.
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.
7.6.2 Contents of the Report
Body of the Report
| Field Name | Field Description | ||
|---|---|---|---|
| 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. | ||
| 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 | ||
| 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.7 Summary of Securitization History Details Report
This section contains the following topics:
- Section 7.7.1, "Generating Summary of Securitization History Details Report"
- Section 7.7.2, "Contents of the Report"
7.7.1 Generating Summary of Securitization History Details Report
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 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.
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.
Account NumberYou can generate a report based on the account number. Select an account 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.
7.7.2 Contents of the Report
Body of the Report
| Field Name | Field Description | ||
|---|---|---|---|
| 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 number | This is the securitization reference number for which the report is generated. | ||
| Securitization date | This is the securitization date for which the report is generated. | ||
| Operation | This is the operation (Buy back, amendment, sale) for which the report 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 |