9. Asset Management Reports
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), and history reports and so on.
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.
You can generate the following Asset Management reports in Oracle FLEXCUBE:
- Fund Security Holding Report
- Fund GL Balances Report
- NAV Movements Report
This chapter contains the following sections:
- Section 9.1, "Fund Security Holding Reports"
- Section 9.2, "Fund GL Balances Report"
- Section 9.3, "NAV Movements Report"
9.1 Fund Security Holding Reports
9.1.1 Generating Fund Security Holding Reports
You can invoke the ‘Fund Security Holding Report’ screen by typing ‘AMRFNDHD’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
Select Report Output
Select the report output you need to generate for from the options. The following options are provided for selection:
- All Funds–Select this option if all funds should be considered for report generation.
- Specific Fund–Select this option if only selected or specific fund should be considered for report generation.
Selected Fund
Fund Reference Number
If you have selected the option ‘Specific Fund’ then select the fund to be considered for report generation from the adjoining option list.
Holdings As On
If you want to generate report based on the fund holdings as per a specific date then select the date from the adjoining calendar button based on which the report should be generated.
9.1.2 Contents of the Report
The options that you specified while generating the report are printed at the beginning of the report.
The contents of the Fund Security Holding Report are discussed under the following heads:
Header
The Header carries the title of the Report, information on the branch code, branch date, the date and time of report generation, the user-ID of the user generating the report, module, page and the event date.
Body of the Report
Field |
Description |
Fund Reference |
The reference number of the fund |
Security Id |
The unique id of the security |
Portfolio |
The reference number to identify the portfolio |
Holding From |
The date from which the customer is holding the security |
Closing Security Balance |
The closing balance of the security |
Position Reference |
The position reference number of the security |
9.2 Fund GL Balances Report
This section contains the following topics:
9.2.1 Generating Fund GL Balances Report
The Fund GL Balances report gives the GL balances of the fund.
You can invoke this screen by typing ‘AMRFUNBL’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
Report Period
You can indicate the following preferences for generating the report:
Current Period
Check this box if the report has to be generated for the current period.
Select Period
Select the period to be considered for report generation.
Financial Cycle
Specify the financial cycle for which the report has to be generated.
GL Types
Check the box against the type of GL that has to be considered for report generation. The types of GL available are:
- Asset
- Income
- Liability
- Expense
Fund Reference
Select the fund reference number based on which the report has to be generated, from the adjoining option list.
Fund ID
Specify the id of the fund to be considered for report generation.
9.2.2 Contents of the Report
The options that you specified while generating the report are printed at the beginning of the report. The contents of the Fund GL Balance Report are discussed under the following heads:
Header
The Header carries the title of the Report, information on the branch code, branch date, the date and time of report generation, the user-ID of the user generating the report, module , event date and the page number.
Body of the report
Field |
Description |
Fund ID |
The code used to identify the fund |
GL Code |
The code used to identify the GL |
GL Description |
The description of the GL |
GL Currency |
The currency of the general ledger |
GL Balance in FCY |
The GL balance in foreign currency |
GL Balance in LCY |
The GL balance in local currency of your branch |
Total |
This indicates the total fund balance |
9.3 NAV Movements Report
This section contains the following topics:
9.3.1 Generating NAV Movements Report
The NAV movements report gives details about the Net Asset Value movement of the fund.
You can invoke this screen by typing ‘AMRNAVMV’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
Net Asset Value Movements Report
You can indicate the following preferences for generating the report:
Fund Option
Select the fund for which you need to generate the report from the options. The following options are provided for selection.
- All–Select this option if all funds should be considered for report generation.
- One–Select this option if only a single fund is considered for report generation.
Date Option
Select the date from when you need to generate the report from the options. The following options are provided for selection.
- Current Date–Select if the report has to be generated for NAV movements on the current date.
- Between Dates–Select if the report has to be generated for NAV movements for a period between two dates.
Fund
You can specify the following details here:
Fund
If you have selected the fund option as ‘One’, you need to specify the fund for which the NAV movement report has to be generated.
From Date
If you have selected ‘Between Dates’ options then specify the start date of the time period for which the NAV movement report has to be generated.
To Date
If you have selected ‘Between Dates’ options then specify the end date of the time period for which the NAV movement report has to be generated.
9.3.2 Contents of the Report
The contents of the report are discussed under the following heads:
Header
The Header carries the title of the Report, information on the branch code, branch date, the date and time of report generation, the user-ID of the user generating the report, module, event date and the page number.
Body of the Report
Field |
Description |
Fund ID |
The code used to identify the fund |
Fund Reference Number |
The reference number used to identify the fund |
NAV id |
The unique code to identify the NAV |
NAV |
The net asset value of the fund |
NAV Date |
The date on which the net asset value is quoted |
Base Currency |
The currency in which the NAV is calculated |
Units in Issue |
The total units of fund issued |
NAV Per Unit |
The net asset value per unit of the fund |