This manual lists the details of various reports that you can generate for Limits and Collateral Management module of Oracle FLEXCUBE.
During the day, or at the end of the day, 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.
This chapter contains the following sections:
From the Application Browser, select the Reports option. A list of all the modules to which you have access rights are displayed in the screen. When you click on a module, all the reports for which you have access rights under the selected module are displayed. Click on the report you want to generate. You will be given a selection Criteria based on which the report would be generated.
Click ’OK’ button when you have specified your preferences. The ‘Print Options’ screen gets displayed, where you can specify the preferences for printing the report.
This section contains the following topics:
You can invoke the ‘Covenant History Reports’ screen by typing ‘ELRPCONH’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
Covenant Name
Select the covenant name from the adjoining option list.
Liability Number
Select the liability number for which you want to rertive the covenanat data.
The contents of this report are discussed under the following heads:
Header
The Header carries the title of the report, information on the branch and branch date, user id, the date and time, the page number and module of the report.
Body of the Report
This report contains details of:
Field Name |
Field Description |
Covenant Name |
This is the name of the covenant. |
Transaction Type |
This is the facility or collateral type of transaction. |
Mandatory |
This is to specify whether the Covenant is mandatory or not. |
Frequency |
This is to specify the frequency of the Covenant submission. |
Start Date |
This is the start date of the covenant. |
End date |
This is the end date of the covenant. |
Grace days |
This is the grace days of the Covenant. |
Notice days |
This is the notice days of the Covenant. |
Remarks |
This is the additional comments associated with the covenant |
This section contains the following topic:
The report is used to check the overdrawn balances with the respect to the credit lines being used. You can invoke the ‘Over Drawn Lines Report’ screen by typing ‘ELRPOVLN’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button
Line Code
Select the line code as All or Single.
List of Credit Lines
Select the credit line from the adjoining option list, if single line code is selected.
Note
The list of credit lines is disabled, if line code is opted as All. If line code is opted as single, then list of credit lines are mandatory.
The contents of this report are discussed under the following heads:
Header Section
The header contains the following:
Field Name |
Field Description |
Liability Number |
The liability number of the customer is displayed. |
Name |
The name of the liability is displayed. |
Customer Number |
The customer associated with the facility is displayed. |
Customer Name |
The name of the customer associated with the facility is displayed. |
Line |
The credit line number of the facility is displayed. |
Serial |
The serial number of the credit line is displayed. |
Currency |
The currency of the credit line is displayed. |
Main Line |
The main credit line of the facility is displayed |
Effective Line Amount |
The effective credit line amount is displayed. |
Overdrawn Amount |
The amount overdrawn by utilization is displayed. |
Tabular Section
This report contains details of:
Field Name |
Field Description |
Contract Reference Account Number |
The reference number of the contract account which utilizes the line with the primary key as the facility associated with the liability, is displayed. |
Module |
The associated module from which the transaction is generated is displayed. |
Utilization Amount in Contract Currency/A/c Currency |
The utilization amount in the contract currency is displayed. |
Utilization Amount in line currency |
The utilization amount in the line currency is displayed. If full reinstatement is made to the utilization made, then utilization amount in contract currency/ account currency and utilization amount in line currency is 0. This is applicable for revolving lines only. In case of non revolving lines, even if reinstatement is made, utilization amount will remain as is. |
Date of Overdrawn Amount |
The date on which the transaction has overdrawn the line is displayed. |
Reason/Remark |
Reason or Remark of the overdrawn amount is displayed here. |
Note
The subtotal of the overdrawn amount is displayed. The grand total displays the grand total of the overdrawn amount is also displayed. The sub total and the grand total will be displayed in the branch local currency.
This section contains the following topic:
This report is used to track the utilizations on a credit line. You can invoke the ‘Utilizations Report Date Wise’ screen by typing ‘ELRPUTLD’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
Liability
Select All liabilities or Single liability.
From Date
Select the date from which the utilization is to be considered to generate this report.
To Date
Select the date till which the utilization is to be considered to generate this report.
Note
From Date and To Date fields are mandatory fields. The report lists all utilizations that have taken place between the From and To Dates selected. The From and To Dates cannot be a future date. ‘To Date’ cannot be less than ‘From Date’.
List of Liability Names
Select the name of the liability from the adjoining option list, if single liability is selected.
Note
The list of liability names is enabled only if Single Liability is selected. This field is disabled if ‘All Liabilities’ are selected.
The contents of this report are discussed under the following heads:
Header Section
This report contains details of:
Field Name |
Field Description |
Liability Name |
The name of the liability is displayed. |
Line Code |
The line code of the utilization line is displayed. |
Serial Number |
The serial number of the line is displayed. |
Line Currency |
The currency of the line is displayed. |
Contract Reference Number |
The contract reference number that emanates from the Product Processor is displayed. |
Contract Currency |
The contract currency of the contract which utilizes the line is displayed, |
Module |
The module from which the transactions are triggered is displayed. |
Date |
Date wise utilization on the credit line is displayed. |
Utilization Line Currency |
The line currency of the utilization amount is displayed. |
Utilization Contract Currency |
The utilization in contract currency is displayed. |
Note
The utilization remains the same even if a reinstatement is made as the utilizations are made for a line, date wise. The subtotal shows the liability wise total in liability currency and grand total displays the total utilizations in branch currency.
This section contains the following topic:
This report is used to view the collaterals at any point in time. You can invoke the ‘Collateral Report’ screen by typing ‘ELRPCOLT’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button
Liability
Select all liabilities or single liability.
List of Liabilities
Select the liability from the adjoining option list, if single liability is selected.
The contents of this report are discussed under the following heads:
Header Section
This report contains details of:
Field Name |
Field Description |
Liability Number |
The liability number is displayed. |
Liability Name |
The name of the liability is displayed. |
Customer Name |
The name of the customer is displayed. |
Customer Number |
The CIF number of the customer is displayed. |
Collateral Code |
The collateral code is displayed. |
Description |
The collateral description is displayed. |
Currency |
The collateral currency is displayed. |
Collateral Value |
The value of the collateral is displayed. |
Collateral Category |
The category of the collateral is displayed. |
Collateral Type |
The type of collateral which is linked with the category is displayed. |
Shared |
Indication on whether the collateral is shared or not is displayed. |
Note
The subtotal displays the liability wise total collateral value. The grand total displays the liability wise total collateral value. The sub total and grand total will be displayed in the branch local currency.
This section contains the following topic:
This report is used to analyse the following information:
This report gives details of the pool linkage. You can invoke the ‘Pool Linkage Report’ screen by typing ‘ELRPOLNK’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button
Pool Code
Select All Pool Code or Single Pool Code.
Pool List
Select the pool from the adjoining option list, if Single pool code is selected.
Note
Pool Codes should not be selected from the Pool List, if All Pools are selected, else an error message is displayed. The pool code can be selected only if single pool code is selected.
The contents of this report are discussed under the following heads:
Header Section
The header contains the following:
Field Name |
Field Description |
Pool Code |
The collateral pool code is displayed. |
Description |
The description of the pool code is displayed. |
Liability Number |
The liability number is displayed. |
Pool Currency |
The collateral pool currency is displayed. |
Pool Amount |
The total collateral pool amount is displayed. |
Pool Utilized |
The utilized collateral pool amount is displayed. |
Available Amount |
The available amount post the transaction is displayed. This is calculated as Total Available Pool Amount - Transaction Amount of the Pool. |
Link/Contract Linkage |
The utilization line or contract linked to the pool is displayed. |
Tabular Section
This report contains details of:
Field Name |
Field Description |
Collateral Code |
The collateral code is displayed. |
Collateral Currency |
The collateral currency is displayed. |
Collateral Contribution |
The collateral contribution to the pool is displayed. |
Linked Percentage |
The linked percentage of the collateral is displayed. |
Lined Amount |
The linked amount of the collateral is displayed here. |
Linked Amount Pool currency |
The linked amount pool currency of the collateral is displayed here. |
Collateral Type |
The type of collateral is displayed. |
Note
The subtotal displays the pool code wise total pool amount. The grand total displays the pool code wise total pool amount. The sub total and grand total will be displayed in the branch local currency.
This section contains the following topic:
This report is used to analyze the credit movement of the customer exposure across different credit lines of the overall exposure limit given to the customer. Banks require this report to monitor the exposure limit of the customer for the fund based and non fund based credit limits. You can invoke the ‘Credit Movement Report’ screen by typing ‘ELRPCRMO’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button
Liability
Select all liabilities or single liability.
List of Liabilities
Select the liability from the adjoining option list, if single liability is selected.
Note
The liability from the list of liabilities field can be selected only if single liability is selected or else an error message is displayed.
The contents of this report are discussed under the following heads:
Header
The header contains the following:
Field Name |
Field Description |
Liability ID |
The liability ID for the credit movement is displayed. |
Liability Name |
The name of the liability is displayed. |
Line Code |
The line code of the credit facility is displayed. |
Line Serial Number |
The serial number of the facility line code is displayed. |
Line Currency |
The currency of the line is displayed. |
Limit Amount |
The limit amount of the facility is displayed. |
Collateral Contribution |
The collateral contribution in the facility or the credit line is displayed. |
Revolving line |
The revolving line indicator is displayed. |
Available Amount |
The available amount is displayed. The opening balance is updated only after EOD and not after each transaction. After EOD, the closing balance is displayed as the opening balance for the day. The opening balance is not updated for each utilization transaction. |
Amount reinstated today |
The line reinstated amount is displayed. The re-paid amount on the loan which is attached to the credit line is displayed. |
Amount Utilized Today |
The amount utilized for the day in the line is displayed. |
Available Amount |
The available balance of the line is displayed here. |
Tabular Section
This report contains details of:
Field Name |
Field Description |
Contract Reference Number |
The reference of the contract which utilizes the line is displayed. |
Contract Currency |
The currency of the contract which utilized the line is displayed, |
Amount |
The amount of the contract which utilizes the line is displayed. Amount is displayed as 0, if full reinstatement is made to the utilization for a revolving line. In case of part reinstatement, the amount is updated based on the reinstatement. In case of non revolving lines, there is no change in amount after reinstatement. |
This section contains the following topics:
This report is used to view the limit details of the customer at any point in time. You can invoke the ‘Limit Details Report’ screen by typing ‘ELRPLIMT’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button
Line
Select all line codes or single line code.
List of Credit Lines
Select the credit line from the adjoining option list, if Single line code is selected.
Note
The credit lines from the list of credit lines can be selected only if single line code is selected else an error message is displayed.
The contents of this report are discussed under the following heads:
Header
The header contains the following:
Field Name |
Field Description |
Line Code |
The line code of the limit details are displayed. |
Line Serial Number |
The serial number of the line code is displayed. |
Currency |
The currency of the line code is displayed. |
Start Date |
The start date of the line is displayed. |
Expiry Date |
The expiry date of the line is displayed. |
Limit Amount |
The limit amount of the line is displayed. |
Available Amount |
The available amount of the line is displayed. |
Utilized Amount |
The utilized amount of the line is displayed. |
Blocked Amount |
The blocked amount of the line is displayed. |
Tabular Section
This report contains details of:
Field Name |
Field Description |
Contract Reference Number |
The reference number of the contract attached to the line is displayed. |
Module Account Number |
The module or source from which the transaction is generated is displayed. |
Currency |
The contract currency is displayed. |
Amount |
The contract amount is displayed. |
Line Currency Equivalent |
The line currency equivalent of the contract currency is displayed. |
This section contains the following topics:
This report is used to view the liability details and the corresponding line details associated with the customer liability. You can invoke the ‘Line Summary Report’ screen by typing ‘ELRPML’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button
Line
Select all line codes or single line code.
List of Credit Lines
Select the credit line from the adjoining option list, if single line code is selected.
Note
The credit lines from the list of credit lines can be selected only if single line code is selected else an error message is displayed.
The contents of this report are discussed under the following heads:
Header Section
The header contains the following:
Field Name |
Field Description |
Liability Number |
The liability number of the line is displayed. |
Liability Currency |
The liability currency of the line is displayed. |
Liability Limit |
The liability limit of the line is displayed. |
Liability Utilization |
The overall utilization of the liability is displayed. |
Overdrawn Amount |
The overdrawn amount of the liability is displayed. |
Tabular Section
This report contains details of:
Field Name |
Field Description |
Line ID |
The overdrawn line ID is displayed. |
Status |
The status of the line is displayed. |
Currency |
The currency of the overdrawn line is displayed. |
Limit |
The overall limit of the line is displayed. |
Utilization |
The utilization from the contract as on date is displayed. |
Overdrawn Amount |
The overdrawn amount of the line is displayed. |
Contract Reference Number |
The contract which has utilized the line and overdrawn is displayed. |
Module |
The module or source which has utilized the line is displayed. |
This section contains the following topics:
This report is used to identify any exception transaction. This report fetches two types of data:
You can invoke the ‘Exception Report’ screen by typing ‘ELRPEXCE’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
Liability
Select Single or All Liabilities. If ‘All Liabilities’ is selected, then the report is generated with all exceptions that would have occurred in the transaction with different liabilities.
List of Liability Names
Select the liability name from the adjoining option list, if a single liability is selected. You can select multiple liabilities by adding multiple rows by clicking the ‘+’ sign.
From Date
Select the start date. This date should be less than or equal to the system date.
To Date
Select the end date. The date should be less than or equal to the system date.
Note
The From Date and To Date are mandatory fields. The exception transactions performed between the From Date and the To Date are listed.
The contents of this report are discussed under the following heads:
Header
This section contains the following:
Field Name |
Field Description |
Liability Number |
The liability number with which the line has created the exception in the transaction is displayed. |
Tabular Section
This report contains details of:
Field Name |
Field Description |
Transaction Date |
The date on which the exception transaction was made is displayed. |
Source |
The product processor or source from which the transaction with exception was generated, is displayed. |
Line ID |
The facility ID which created the exception transaction, is displayed. |
Customer Number |
The customer number of the customer who has transacted in the line which has created the exception is displayed. For a liability where multiple customers are associated with the facility, the system will fetch the customer number which is attached to the facility. |
Customer Name |
The name of the customer is displayed. |
Currency |
The currency of the facility is displayed. |
Transaction Amount |
The transaction amount which has created this facility is displayed. |
User ID |
The user ID of the user who has made this transaction is displayed. |
Approver ID |
The officer user who has approved the exception transaction is displayed. |
Exception |
The exception reason or the override captured while processing of the transaction during save or authorization is displayed. |