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 Viewing Summary of Securitization Pool

You can manually generate a report that displays the list of participating CI accounts for the selected securitization contract / securitization pool in the ‘Summary of CI accounts under Islamic Securitization Pool’ screen. You can invoke this report screen by typing ‘IZRPOACC’ 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.

Contents of the Report

The following information is provided in the report.

Header

The following details are displayed in the header section:

Field Name

Field Description

Report Name

Indicates Report Name

Branch Code / Branch Name

Indicates Current Branch code and Branch Name

User ID

Indicates the Identification of the User

Module

Indicates the Module of the Report

Report Run Date

Indicates Current Branch Date

Report Run Time

Indicates Current Branch Time

Body of the Report

Field Name

Field Description

Branch Code

This is the branch code for which the report is generated.

Securitization Ref No

This is the securitization reference number for which the report is generated.

Asset Ref No(Desc order)

This is the assest reference 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.

Finance Amount

This is the finance amount for which the report is generated.

Currency

This is the currency for which the finance amount is disbursed..

Value date

This is the value date of the finance for which the report is gen­erated.

Maturity date

This is the maturity date of the finance for which the report is generated.

 

7.2 Viewing Summary of Islamic Securitization Pool His­tory

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 Islamic Securitization Pool History Details’ screen.

You can invoke this report screen by typing ‘IZRPOHIS’ 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.

Header

The following details are displayed in the header section:

Field Name

Field Description

Report Name

Indicates Report Name

Branch Code / Branch Name

Indicates Current Branch code and Branch Name

User ID

Indicates the Identification of the User

Module

Indicates the Module of the Report

Report Run Date

Indicates Current Branch Date

Report Run Time

Indicates Current Branch Time

Body of the Report

Field Name

Field Description

Branch Code

This is the branch code for which the report is generated.

Securitization ref No

This is the securitization reference number for which the report is generated.

Event Code

This is the event code for which the report is generated.

Operation

This is the operation (Buy back, amendment, sale) for which the report is generated.

Asset Ref No

This is the asset reference number for which the report is gener­ated.

Product Code

This is the product code for which the report is generated.

Product Cate­gory

This is the product category for which the report is generated.

Customer ID

This is the customer ID for which the report is generated.

Finance Amount

This is the finance amount for which the report is generated.

Currency

This is the currency for which the finance amount is disbursed..

Value Date

This is the value date of the finance for which the report is gener­ated.

Maturity Date

This is the maturity date of the finance for which the report is gener­ated.

Fund ID

This is the fund id of the finance for which the report is generated.

7.3 Viewing Summary of Payment Received by SPV

You can manually generate a report that displays the summary of payment received details (participating CI Accounts) for the securitization contract / SPV for the specified period in the ‘Summary of Payment Received’ screen. You can invoke this report screen by typing ‘IZRSPVPY’ 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.

Header

The following details are displayed in the header section:

Field Name

Field Description

Report Name

Indicates Report Name

Branch Code / Branch Name

Indicates Current Branch code and Branch Name

User ID

Indicates the Identification of the User

Module

Indicates the Module of the Report

Report Run Date

Indicates Current Branch Date

Report Run Time

Indicates Current Branch Time

Body of the Report

Field Name

Field Description

Branch Code

This is the branch code for which the report is generated.

Securitization ref No

This is the securitization reference number for which the report is gener­ated.

Asset Ref No

This is the asset reference 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 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 CI Accounts for the securitization contract / SPV for the specified period in the ‘Summary of overdue payments’ screen.

You can invoke this report screen by typing ‘IZRODYPT’ 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.

Header

The following details are displayed in the header section:

Field Name

Field Description

Report Name

Indicates Report Name

Branch Code / Branch Name

Indicates Current Branch code and Branch Name

User ID

Indicates the Identification of the User

Module

Indicates the Module of the Report

Report Run Date

Indicates Current Branch Date

Report Run Time

Indicates Current Branch Time

Body of the Report

Field Name

Field Description

Branch Code

This is the branch code for which the report is generated.

Securitization ref No

This is the securitization reference number for which the report is gener­ated.

Asset Ref No

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 Viewing Summary of Disbursement Details for the Is­lamic Securitization Contract

You can manually generate a report that displays the future disbursement for the underlying CI Accounts for the securitization contract / SPV for the specified period in the ‘Summary of disbursement details for the Islamic securitization contract’ screen. You can invoke this report screen by typing ‘IZRDSBDT’ 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.

Header

The following details are displayed in the header section:

Field Name

Field Description

Report Name

Indicates Report Name

Branch Code / Branch Name

Indicates Current Branch code and Branch Name

User ID

Indicates the Identification of the User

Module

Indicates the Module of the Report

Report Run Date

Indicates Current Branch Date

Report Run Time

Indicates Current Branch Time

Body of the Report

Field Name

Field Description

Branch Code

This is the branch code for which the report is generated.

Securitization Ref No

This is the securitization reference number for which the report is gener­ated.

Asset Ref No

This is the asset ref 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.

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

This is the amount for which the report is generated.

Currency

This is the currency for which the report is generated.

 

7.6 Viewing Summary of Profit and Loss Accrual Details for the Islamic 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 Islamic securitization contract’ screen. You can invoke this report screen by typing ‘IZRPLACR’ 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.

Header

The following details are displayed in the header section:

Field Name

Field Description

Report Name

Indicates Report Name

Branch Code / Branch Name

Indicates Current Branch code and Branch Name

User ID

Indicates the Identification of the User

Module

Indicates the Module of the Report

Report Run Date

Indicates Current Branch Date

Report Run Time

Indicates Current Branch Time

Body of the Report

Field Name

Field Description

Branch Code

This is the branch code for which the report is generated.

Securitization Ref No

This is the securitization reference number for which the report is gener­ated.

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 Viewing Summary of Islamic Securitization History de­tails for the Islamic Finances

You can manually generate a report that displays the summary Securitization history details for the specific CI account for a specified period in the ‘Summary of Islamic Securitization History Details for CI Accounts’ screen. You can invoke this report screen by typing ‘IZRCLHIS’ 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 Number

You can generate a report based on the account number.

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.

Header

The following details are displayed in the header section:

Field Name

Field Description

Report Name

Indicates Report Name

Branch Code / Branch Name

Indicates Current Branch code and Branch Name

User ID

Indicates the Identification of the User

Module

Indicates the Module of the Report

Report Run Date

Indicates Current Branch Date

Report Run Time

Indicates Current Branch Time

Body of the Report

Field Name

Field Description

Branch code

This is the branch code for which the report is generated.

Asset Ref No

This is the asset reference number

Securitization Ref No

This is the securitization reference number for which the report is gener­ated.

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 previous status of the account

To Status

This is the new status of the account

 

7.8 Viewing Summary of Islamic assets under securitiza­tion for the specific fund

You can manually generate a report that displays the underlying Islamic assets which are funded by the specified Islamic fund in the ‘Summary of Islamic Assets under securitization for the specific fund’ screen. You can invoke this report screen by typing ‘IZRSECFD’ 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.

Fund Id

Specify the fund id. The adjoining option list displays all the fund ids maintained in the system. You can choose the appropriate one.

Header

The following details are displayed in the header section:

Field Name

Field Description

Report Name

Indicates Report Name

Branch Code / Branch Name

Indicates Current Branch code and Branch Name

User ID

Indicates the Identification of the User

Module

Indicates the Module of the Report

Report Run Date

Indicates Current Branch Date

Report Run Time

Indicates Current Branch Time

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.

Asset ref no

This is the asset reference 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 gener­ated.

Customer ID

This is the customer ID for which the report is generated.

Finance amount

This is the finance amount for which the report is generated.

Currency

This is the currency for which the finance amount is dis­bursed..

Lcy amount

This is the local currency for which the finance amount is dis­bursed..

Value date

This is the value date of the finance for which the report is generated.

Maturity date

This is the maturity date of the finance for which the report is generated.

 

7.9 Viewing Summary of Payments / Disbursement of Is­lamic assets under securitization for the Specific Fund

You can manually generate a report that displays payments / disbursement details for all underlying Islamic assets which are funded by the specified Islamic fund in the ‘Summary of payments / disbursement of Islamic assets under securitization for the specific fund’ screen. You can invoke this report screen by typing ‘IZRPMTFD’ 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.

Fund Id

Specify the fund id. The adjoining option list displays all the fund ids maintained in the system. You can choose the appropriate one.

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.

Header

The following details are displayed in the header section:

Field Name

Field Description

Report Name

Indicates Report Name

Branch Code / Branch Name

Indicates Current Branch code and Branch Name

User ID

Indicates the Identification of the User

Module

Indicates the Module of the Report

Report Run Date

Indicates Current Branch Date

Report Run Time

Indicates Current Branch Time

Body of the Report

Field Name

Field Description

BRANCH CODE

This is the branch code for which the report is generated.

SECURIZATION REF NO

This is the securitization reference number for which the report is generated.

ASSET REF NO

This is the asset reference 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 gener­ated.

COMPONENT NAME

This is the component for which the report is generated.

CUSTOMER ID

This is the customer ID for which the report is generated.

AMOUNT

This is the amount for which the report is generated.

CURRENCY

This is the currency for which the finance amount is dis­bursed.

VALUE DATE

This is the value date of the finance for which the report is generated.

MATURITY DATE

This is the maturity date of the finance for which the report is generated.

 

7.10 Viewing Summary of Islamic Securitization History Details for the CI Finances

You can invoke this report screen by typing ‘IZRCLHIS’ 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 Number

Specify the account number from the adjoining option list.

From Date

Specify a valid date from when you wish to generate the report from the adjoining calendar.

To Date

Specify a valid date till when you wish to generate the report from the adjoining calendar.

Header

The following details are displayed in the header section:

Field Name

Field Description

Report Name

Indicates Report Name

Branch Code / Branch Name

Indicates Current Branch code and Branch Name

User ID

Indicates the Identification of the User

Module

Indicates the Module of the Report

Report Run Date

Indicates Current Branch Date

Report Run Time

Indicates Current Branch Time

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

Asset ref no

This is the asset reference number for which the report is generated.

Securitization Date

Indicates the securitization date

Operation

Indicates the Operation

From Status

Indicates the from status

To Status

Indicates the to status

 

7.11 Viewing Summary of Payments/Disbursement of Is­lamic Assets under Securitization for the dpecific Fund

You can invoke this report screen by typing ‘IZRPMTFD’ 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.

Fund ID

Specify the fund id from the adjoining option list.

From Date

Specify a valid date from when you wish to generate the report from the adjoining calendar.

To Date

Specify a valid date till when you wish to generate the report from the adjoining calendar.

Header

The following details are displayed in the header section:

Field Name

Field Description

Report Name

Indicates Report Name

Branch Code / Branch Name

Indicates Current Branch code and Branch Name

User ID

Indicates the Identification of the User

Module

Indicates the Module of the Report

Report Run Date

Indicates Current Branch Date

Report Run Time

Indicates Current Branch Time

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

Asset ref no

This is the asset reference number for which the report is generated.

Product Code

This is the code of the product for which the report is generated.

Product Category

This is the category of the product for which the report is generated

Component Name

This is the name of the component for which the report is generated

Customer ID

This is the customer Identification number

Amount

Indicates the amount

Currency

This is the currency of the account

Value Date

Indicates the value date

Maturity Date

Indicates the maturity date

 

7.12 Viewing Summary of Islamic Assets under Securitiza­tion for the Specific Fund

You can invoke this report screen by typing ‘IZRSECFD’ 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.

Fund ID

Specify the fund id from the adjoining option list.

Header

The following details are displayed in the header section:

Field Name

Field Description

Report Name

Indicates Report Name

Branch Code / Branch Name

Indicates Current Branch code and Branch Name

User ID

Indicates the Identification of the User

Module

Indicates the Module of the Report

Report Run Date

Indicates Current Branch Date

Report Run Time

Indicates Current Branch Time

Body of the Report

Field Name

Field Description

Branch code

This is the branch code for which the report is generated.

Securitization Ref No

This is the securitization reference number for which the report is gener­ated.

Asset Ref No

This is the asset reference number for which the report is generated.

Product Code

This is the code of the product for which the report is generated.

Product Category

This is the category of the product for which the report is generated

Customer ID

This is the customer Identification number

Finance Amount

Indicates the finance amount

Currency

This is the currency of the account

Value Date

Indicates the value date

Maturity Date

Indicates the maturity date