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:

7.1 Summary of Securitization Pool Report

This section contains the following topics:

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 gener­ated.

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 gen­erated.

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:

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 gener­ated.

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 gen­erated.

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:

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 Re­port

This section contains the following topics:

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 Securitiza­tion Contract Report

This section contains the following topics:

7.5.1 Viewing Summary of Disbursement Details for the Securitization Con­tract 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 num­ber

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 gen­erated.

Amount

This is the disbursement amount for which the report is gener­ated.

Currency

This is the disbursement currency for which the report is gen­erated.

7.6 Summary of Profit Loss Details for the Securitization Contract Report

This section contains the following topics:

7.6.1 Generating Summary of Profit Loss Details for the Securitization Con­tract 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:

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