Reports allow you to retrieve information on the several operations that were performed during the day.This chapter discusses the various reports which can be generated using the Oracle Global Liquidity Management application.
You can generate the various reports using the reports screen. To invoke the report screen, click on Reports tab on the application..
Specify the following general details:
Report Name
Select the name of the report to be generated from the drop down list. The list displays the following options:
● Interest Accrual Report
● Sweep Reject Report
● Sweep Structure Report
● Sweep Summary Report
Template
The system displays the template of the report based on the report to be generated.
Format
Select the format in which the report is to be generated from the drop down list. The list displays the following options:
● Interactive
● HTML
● RTF
● EXCEL
● PowerPoint
Click Generate button to generate the report in the selected format.
This section contains the following topics:
● Section 12.2.1, "Sweep Structure Report"
● Section 12.2.2, "Sweep Reject Report"
● Section 12.2.3, "Sweep Summary Report"
● Section 12.2.4, "Interest Accrual Report"
This report provides details on all the Sweep structures maintained with details of the sweep agreements between the participant accounts. You can view it as Daily report and Range report. Invoke the Report screen and select the report name as Sweep Structure Report.
Specify the following additional details:
Customer ID
Specify the customer ID for which the report is to be generated. You can select the customer ID from the option list. The list displays all the customer IDs maintained in the system.
Structure ID
Specify the structure ID for which the report is to be generated. You can select the structure ID from the option list. The list displays all the structure IDs maintained in the system.
Version No.
Specify the version number for which the report is to be generated.
Click Generate. The report will be generated as below:
The table below describes the various columns in the report:
Column |
Description |
Structure ID |
Displays the Structure ID of the sweep structure |
Structure Description |
Displays the description for the structure ID |
Customer ID |
Displays the customer ID |
Customer Description |
Displays the description of the customer |
Header Account ID |
Displays the ID of the header account |
Header Account Description |
Displays the description for the header account |
Structure Valid From Date |
Displays the date from which the structure is valid |
Structure Valid To Date |
Displays the date till which the structure is valid |
Structure Version No |
Displays the version number of the structure |
Cross Border |
Displays if the cross border sweep is allowed for the structure |
MBCC |
Displays if the Multi Bank Cash Concentration is allowed for the structure |
Cross Currency |
Displays if cross currency sweep is allowed for the structure |
Child Account Details |
|
|
|
Account Number |
Displays the child account number |
Account Description |
Displays the description for child account |
Branch Code |
Displays the branch code of the child account |
Branch Name |
Displays the branch name of the child account |
Account Currency |
Displays the currency set for the account |
Sweep Concentration Method |
Displays the sweep concentration method assigned to the pair |
Parent Account Details |
|
Account Number |
Displays the parent account number |
Account Description |
Displays the description for parent account |
Branch Code |
Displays the branch code of the parent account |
Branch Name |
Displays the branch name of the parent account |
Account Currency |
Displays the currency set for the parent account |
Other Parameters |
|
Sweep Frequency |
Displays the sweep frequency set for the account pair |
Two Way |
Displays if two way sweep is set for the pair |
Reverse Sweep |
Displays if reverse sweep is set for the pair |
Reverse Sweep Frequency |
Displays the reverse sweep frequency set for the account pair |
This report provides details of Sweeps rejected along with reason for rejection as a Daily report. Invoke the Report screen and select the report name as Sweep Reject Report.
Specify the following additional details:
Customer ID
Specify the customer ID for which the report is to be generated. You can select the customer ID from the option list. The list displays all the customer IDs maintained in the system.
Structure ID
Specify the structure ID for which the report is to be generated. You can select the structure ID from the option list. The list displays all the structure IDs maintained in the system.
From Date
Specify the start date from which to generate the report.
To Date
Specify the end date till which to generate the report.
Click Generate. The report will be generated as below:
The table below describes the various columns in the report:
Column |
Description |
Sweep Log ID |
Displays the sweep log ID of the rejected sweep |
Structure ID |
Displays the structure ID to which the rejected sweep belong to |
Structure Description |
Displays the description of the structure |
Sweep Origin Account |
|
Account Number |
Displays the account number from which the sweep was to occur |
Account Description |
Displays the description for account |
Branch Code |
Displays the branch code of the sweep origin account |
Branch Name |
Displays the branch name of the sweep origin account |
Account Currency |
Displays the currency set for the sweep origin |
Sweep Concentration Method |
Displays the sweep concentration method assigned to the pair |
Sweep Destination Account |
|
Account Number |
Displays the account number to which the sweep was occur |
Account Description |
Displays the description for sweep destination account |
Branch Code |
Displays the branch code of the sweep destination account |
Branch Name |
Displays the branch name of the sweep destination account |
Account Currency |
Displays the currency set for the sweep destination account |
Other Parameters |
|
Sweep Reject Reason |
Displays the reason for the sweep reject |
Date and Time of Reject |
Displays if the date and time at which the sweep reject occurred |
This report provides the summary of sweeps done on a specified date\ specific period for a customer or a structure. It states the sweep reference number, sweep amount, the accounts involved, reference number and the value date. Invoke the Report screen and select the report name as Sweep Summary Report.
Specify the following additional details:
Customer ID
Specify the customer ID for which the report is to be generated. You can select the customer ID from the option list. The list displays all the customer IDs maintained in the system.
Structure ID
Specify the structure ID for which the report is to be generated. You can select the structure ID from the option list. The list displays all the structure IDs maintained in the system.
Log Time From
Specify the start time from which to generate the report.
Log Time To
Specify the end time till which to generate the report.
Click Generate. The report will be generated as below:
The table below describes the various columns in the report:
Column |
Description |
Sweep Log ID |
Displays the sweep log ID |
Structure ID |
Displays the structure ID |
Structure Description |
Displays the description of the structure |
Sweep Origin Account |
|
Account Number |
Displays the account number from which the sweep should happen |
Account Description |
Displays the description for account |
Branch Code |
Displays the branch code of the sweep origin account |
Branch Name |
Displays the branch name of the sweep origin account |
Account Currency |
Displays the currency set for the sweep origin |
Sweep Concentration Method |
Displays the sweep concentration method assigned to the pair |
Sweep Destination Account |
|
Account Number |
Displays the account number to which the sweep should happen |
Account Description |
Displays the description for sweep destination account |
Branch Code |
Displays the branch code of the sweep destination account |
Branch Name |
Displays the branch name of the sweep destination account |
Account Currency |
Displays the currency set for the sweep destination account |
Other Parameters |
|
Value Date of Sweep |
Displays the date of the sweep |
Date and Time of Sweep |
Displays if the date and time at which the sweep occurred |
Two Way |
Displays if two way sweep is set for the pair |
Reverse Sweep |
Displays if reverse sweep is set for the pair |
Reverse Sweep Frequency |
Displays the reverse sweep frequency set for the account pair |
12.2.4 Interest Accrual Report
This report provides the interest accrued on the account till date. You can view the Daily/Range report. Invoke the Report screen and select the report name as Interest Accrual Report.
Specify the following additional details:
Date From
Specify the start date from which to generate the report.
Date To
Specify the end date till which to generate the report.
Click Generate. The report will be generated as below:
The table below describes the various columns in the report:
Column |
Description |
Account |
Displays the account number |
Description |
Displays the description for account |
Product |
Displays the product code |
Formula Number |
Displays the formula number |
CCY |
Displays the currency of the transaction |
Current Accrual |
Displays the current accrual |
Accrual To Date |
Displays the net accrual till date |
Accrual Account |
Displays the accrual account number |
P& L Account |
Displays the P & L account number |
Current Accrual in LCY |
Displays the current accrual in local currency |