Skip Headers

Oracle Financial Services Reporting Administration Guide
Release 12.1
Part Number E13529-03
Go to Table of Contents
Contents
Go to previous page
Previous
Go to next page
Next

Data Management Reports

This chapter describes the reports you use to analyze the quality of your data.

This chapter covers the following topics:

Overview of Data Management Reports

Use the data management reports to evaluate the quality of your data. There are two sets of data management reports.

The data management reports leverage data defined in the EPF business area, which refers to objects in the FEM schema. This business area resides in a standard Oracle Applications end user layer (EUL_US) and is populated through facts, joins, and lookup tables. See: Core EPF Business Area and its Components.

Related Topics

Overview of the Reports

GL Instrument Reports

This table lists the GL instrument reports and their Discoverer file names.

Data Management: GL Instrument Reports
Report Name Discoverer Workbook Title Discoverer Worksheet Title
STD – DATA Instrument to GL Reconciliation STD - DATA Instrument to GL Reconciliation
  1. Instrument to GL Reconciliation

    Ending Balances

  2. Instrument to GL Reconciliation

STD – GL Instrument Upload GL Instrument Upload Report
  1. STD - Data GL Instrument Upload

  2. Internal worksheet

Related Topics

Overview of Data Management Reports

STD – DATA Instrument to GL Reconciliation

Use the STD – DATA Instrument to GL Reconciliation report to compare account table balances to the equivalent GL account balances. The report highlights large variance between the two balances to inform you of this data quality issue, and creates "plug" records that you can insert into your account data to correct the variance.

Note: The GL balance is assumed to be correct, so the account balance should match it as closely as possible.

This report is based on a custom folder, EPF Reconciliation, that creates a union between all relevant FEM account tables together with the GL account balances from the FEM_BALANCES table. The report takes a snapshot of the GL data in FEM_BALANCES, which is not necessarily what is currently in your GL data source, for example Oracle General Ledger.

The STD – DATA Instrument to GL Reconciliation contains two worksheets.

Generally, you run this report after loading data for a new calendar period into the account and FEM_BALANCES tables. You can also resubmit the Instrument to GL Reconciliation: Ending Balances worksheet after loading the plug records into account tables, to confirm that the load was successful and that the data reconciles.

Business Area Folders

The STD – DATA Instrument to GL Reconciliation report is based on these folders.

Joins

The STD – DATA Instrument to GL Reconciliation report uses these joins to retrieve data.

Conditions

These conditions apply to the STD – DATA Instrument to GL Reconciliation report.

Page Items

The STD – DATA Instrument to GL Reconciliation report is based on these parameters.

Rows

The Instrument to GL Reconciliation: Ending Balances worksheet displays Natural Accounts included in the Natural Account hierarchy as rows (display defaults to level 20 of the hierarchy). The Instrument to GL Reconciliation worksheet has no rows.

Report Headings and Calculations (Columns)

The STD – DATA Instrument to GL Reconciliation report has these columns. If applicable to the column, also provided below is the:

Note: You can also view or even change the calculation, source, or default when you access calculation details in the Discoverer UI for specific fields.

Related Topics

GL Instrument Reports

STD – DATA GL Instrument Upload

Use the STD – DATA GL Instrument Upload report to identify GL balances that do not exist in any of the FEM account tables. The report pulls in balances by natural account and company cost center organization, and assigns default attributes to these balances so that you can load the balances as instrument records into account tables.

The STD – DATA GL Instrument Upload report contains two worksheets.

Tip: To support processing of the Transfer Pricing system, you can use this report to generate account table records for balances that otherwise only exist in the FEM_BALANCES table. Run this report after loading data for a new calendar period into the account and FEM_BALANCES tables, but before running the transfer pricing process.

Business Area Folders

The STD – DATA GL Instrument Upload report is based on these folders.

STD – DATA GL Instrument Upload worksheet:

Joins

The STD – DATA GL Instrument Upload report uses these joins to retrieve data.

STD – DATA GL Instrument Upload worksheet:

Conditions

These conditions apply to the STD – DATA GL Instrument Upload report.

STD – DATA GL Instrument Upload worksheet:

Page Items

The STD – DATA GL Instrument Upload report is based on these parameters.

STD – DATA GL Instrument Upload worksheet:

Rows

The STD – DATA GL Instrument Upload report has no rows because it has the table layout.

Report Headings and Calculations (Columns)

The STD – DATA GL Instrument Upload report has these columns. If applicable to the column, also provided below is the:

Note: You can also view or even change the calculation, source, or default when you access calculation details in the Discoverer UI for specific fields.

STD – DATA GL Instrument Upload worksheet:

Related Topics

GL Instrument Reports

Stratification Reports

Use the stratification reports to analyze and validate the quality of your account level data after it is loaded. You can identify trends and outliers in the displayed key data attributes from the FEM account tables. For example, you can check for negative or zero values where you do not expect them, such as in payment frequency.

Tip: You can resubmit these reports after processing the cash flow edits or performing other data correction activities, to confirm the results of those activities and verify that the data is clean and ready for processing.

There are nine stratification reports, and they all have similar worksheets and report elements. Each report focuses on specific account data, for example mortgages, savings, or term deposits. When you run the report, you specify through parameters the ranges or tiers that the report results are based on. For example, you determine date ranges by which values in the Origination Date worksheet are grouped.

This table lists the stratification reports and their Discoverer file names. Each report has multiple worksheets with similar titles. For all reports, the worksheet-specific terms in the Discoverer worksheet title are:

  1. Book Balance

  2. Current Net Rate

  3. Origination Date

  4. Maturity Date

  5. Payment Frequency

  6. Amort Type / Adjust Type / Repricing

  7. Line Item

  8. Natural Account

Important: Not every report has all eight worksheets. The exceptions are noted in the Discoverer Worksheet Title column of this table.

Data Management: Stratification Reports
Report Name Discoverer Workbook Title Discoverer Worksheet Title
STD – DATA Stratification MORTGAGES STD – DATA Stratification MORTGAGES Stratification Report
User Specified Tiers: <Worksheet-Specific Term>
Mortgages
STD – DATA Stratification COMMERCIAL LOANS STD – DATA Stratification COMMERCIAL LOANS Stratification Report
User Specified Tiers: <Worksheet-Specific Term>
Commercial Loans
STD – DATA Stratification CONSUMER LOANS STD – DATA Stratification CONSUMER LOANS Stratification Report
User Specified Tiers: <Worksheet-Specific Term>
Consumer Loans
STD – DATA Stratification INVESTMENTS STD – DATA Stratification INVESTMENTS Stratification Report
User Specified Tiers: <Worksheet-Specific Term>
Investments
STD – DATA Stratification CREDIT CARDS STD – DATA Stratification CREDIT CARDS Stratification Report
User Specified Tiers: <Worksheet-Specific Term>
Credit Cards

Note: This report does not have these worksheets:

  • Payment Frequency

  • Amort Type / Adjust Type / Repricing

STD – DATA Stratification CHECKING STD – DATA Stratification CHECKING Stratification Report
User Specified Tiers: <Worksheet-Specific Term>
Checking

Note: This report does not have these worksheets:

  • Payment Frequency

  • Amort Type / Adjust Type / Repricing

STD – DATA Stratification SAVINGS STD – DATA Stratification SAVINGS Stratification Report
User Specified Tiers: <Worksheet-Specific Term>
Savings

Note: This report does not have the Payment Frequency worksheet.

STD – DATA Stratification TERM DEPOSITS STD – DATA Stratification TERM DEPOSITS Stratification Report
User Specified Tiers: <Worksheet-Specific Term>
Term Deposits
STD – DATA Stratification WHOLESALE FUNDING STD – DATA Stratification WHOLESALE FUNDING Stratification Report
User Specified Tiers: <Worksheet-Specific Term>
Wholesale Funding

Related Topics

Stratification Reports Common Concepts

Overview of Data Management Reports

Stratification Reports Common Concepts

The following concepts are common to all the stratification reports. For any applicable worksheet, the report-specific terms are as shown in this table. For example, all worksheets are based in part on the EPF <Report-Specific Term> business area folder. For the STD – DATA Stratification MORTGAGES report, that would be the EPF Mortages folder.

Report Name Report-Specific Term
STD – DATA Stratification MORTGAGES Mortgages
STD – DATA Stratification COMMERCIAL LOANS Commercial Loans
STD – DATA Stratification CONSUMER LOANS Consumer Loans
STD – DATA Stratification INVESTMENTS Investments
STD – DATA Stratification CREDIT CARDS Credit Cards
STD – DATA Stratification CHECKING Checking Accounts
STD – DATA Stratification SAVINGS Savings
STD – DATA Stratification TERM DEPOSITS Term Deposits
STD – DATA Stratification WHOLESALE FUNDING Wholesale Funding

Note: Not all reports have every described worksheet. See: Stratification Reports.

Business Area Folders

The stratification reports are based on these folders.

Joins

The stratification reports use these joins to retrieve data:

Conditions

These conditions apply to the stratification reports.

Page Items

The stratification reports are based on these parameters.

Rows

The stratification reports have these rows. If applicable, the calculation for the row is provided below.

Report Headings and Calculations (Columns)

These headings and calculations are common to the stratification reports. If applicable, the source for the column is provided below.

Totals

All worksheets in the stratification reports have a total for every column.

Related Topics

Stratification Reports