10. 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), history reports and so on. A set of report formats is pre-defined for every module.

This chapter contains the following sections:

10.1 Reports Generation

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.

Report Options

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.

In this screen, you can indicate the following preferences for printing the report.

Format

Select the format in which you want the report to be generated from the options provided in the drop-down list. The following options are available:

Output

Select the output for the report from the options provided. The following options are available:

Printer

Specify the name of the printer or select it from the option list provided. All the configured printers are displayed in the list.

This is applicable only if you have specified the output as ‘Print’.

Contents of the report

The contents of the report are discussed under the following heads:

Header

The Header section of the report carries the title of the Report, information on the User who generated the report, the branch code, the date and time and the page number of the report.

Body of the report

The actual contents of the report are displayed in this section. It is detailed for each report, in the subsequent sections of this document.

10.2 Processed Salary Report

This section contains the following topics:

10.2.1 Generating Processed Salary Report

You can invoke this screen by typing ‘CORPRSAL’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.

Branch Code

You can generate this report for all the branches or a single branch alone. You can indicate the branch for which the report is being generated using the following options:

Report Date

Specify the date of report from the adjoining calendar.

10.2.2 Contents of the Report

The parameters specified while generating the report are printed at the beginning of the report. Other content displayed in the report is as follows:

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

Branch Date

Indicates the date of Branch in which report is taken.

Page No

Displays Page No out of total No of pages in report.

Body of the Report

The following details are displayed as body of the generated report:

Field Name

Field Description

Branch

Indicates the current branch code

Processed Date

Indicates the processed date

Transaction Reference Number

Indicates the transaction reference number

Salary Date

Indicates the salary date

Employer

Indicates the name of the employer

Employee

Indicates the employee name

Employee Account

Indicates the employee account

Salary Amount

Indicates the salary account

CCY

Indicates the currency of the transaction

10.3 Unprocessed Salary Report

This section contains the following topics:

10.3.1 Generating Unprocessed Salary Report

You can invoke this screen by typing ‘CORUNPSL’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.

Branch Code

You can generate this report for all the branches or a single branch alone. You can indicate the branch for which the report is being generated using the following options:

Report Date

Specify the date of report from the adjoining calendar.

10.3.2 Contents of the Report

The parameters specified while generating the report are printed at the beginning of the report. Other content displayed in the report is as follows:

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

Branch Date

Indicates the date of Branch in which report is taken.

Page No

Displays Page No out of total No of pages in report.

Body of the Report

The following details are displayed as body of the generated report:

Field Name

Field Description

Branch

Indicates the current branch code

Employer

Indicates the name of the employer

Employee

Indicates the employee name

Employee Account

Indicates the employee account

Salary Date

Indicates the date of the salary

Salary Amount

Indicates the salary account

Transaction Reference Number

Indicates the transaction reference number

Bank Code

Indicates the bank code

Error Description

Indicates the error description