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

• Section 9.1.1, "Generating Fund Security Holding Reports"
• Section 9.1.2, "Contents of the Report"

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:

• Section 9.2.1, "Generating Fund GL Balances Report"
• Section 9.2.2, "Contents of the Report"

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:

• Section 9.3.1, "Generating NAV Movements Report"
• Section 9.3.2, "Contents of the Report"

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