This chapter describes the Oracle Transfer Pricing reports and the procedure for generating and viewing them.
This chapter covers the following topics:
Oracle Transfer Pricing (FTP) leverages fact data defined in two core business areas, EPF and FTP, to provide you with reports to analyze data from business processes in your application or to evaluate the quality of your business data. The EPF and FTP business areas reside in a standard Oracle Applications end user layer (EUL_US) and are populated through facts, joins, and lookup tables. See:
Core EPF Business Area and its Components, Oracle Financial Services Reporting Administration Guide.
Core FTP Business Area, Oracle Financial Services Reporting Administration Guide.
Overview of the Reports, Oracle Financial Services Reporting Administration Guide.
Oracle Transfer Pricing (FTP) provides you the following three types of reports:
Data Management reports: Use the data management reports to evaluate the quality of your data. See: Overview of Data Management Reports, Oracle Financial Services Reporting Administration Guide.
Audit reports: Use the Oracle Financial Services (OFS) audit reports to view the results of cash flow edits and cash flow processing. See: Overview of Oracle Financial Services Audit Reports, Oracle Financial Services Reporting Administration Guide.
Transfer Pricing reports: Use the transfer pricing reports to find out the account level match funded spread and the interest margin for each product in your portfolio or for a transfer rate stratification range.
The following table list the transfer pricing reports and their Discoverer file names.
| Report Name | Discoverer Workbook Title | Discoverer Worksheet Title |
|---|---|---|
| STD - FTP Interest Margin Account Detail See: STD - FTP Interest Margin Account Detail, Oracle Financial Services Reporting Administration Guide. |
STD - FTP Interest Margin Account Detail | FTP Interest Margin Account Detail |
| STD - FTP Interest Margin (Org/Product, Summary) See: STD - FTP Interest Margin (Org/Product, Summary), Oracle Financial Services Reporting Administration Guide. |
STD - FTP Interest Margin (Org/Product Summary) | FTP Interest Margin (Org/Product Summary) |
| STD - FTP Margin Stratification See: STD - FTP Margin Stratification, Oracle Financial Services Reporting Administration Guide. |
STD - FTP Margin Stratification |
|
For information on how to run these reports, see: Generating and Viewing Reports.
Related Topics
You can run the reports from your application, or use the Oracle Discoverer Desktop or Discoverer Administration applications themselves. See: Oracle Business Intelligence Discoverer Desktop User's Guide and Oracle Business Intelligence Discoverer Administration Guide.
Navigate to the Documents tab.
Click the report you want to run.
Tip: Use the Back button of the browser to navigate back to your application. Open a new browser window to view both your application and the Discoverer Plus application simultaneously.
Related Topics
Overview of Oracle Transfer Pricing Reports
Oracle Business Intelligence Discoverer Plus User's Guide
Oracle Business Intelligence Discoverer Viewer User's Guide
The following concepts are common to the reports. Not all concepts, for example conditions and totals, apply to every report.
Business Area Folders: Folders set up in the Discoverer end user layer (EUL) or business area that contain database objects, such as data and fact tables, on which reports are based.
Joins: Temporary relationships between two tables in a database query that let you retrieve the exact data that you want.
For example, the join Line Items Dimension Hierarchy -> EPF Balances is a one-to-many (1:n) join between Line Items Dimension Hierarchy.Level20 id and EPF Balances.Line Item.
Conditions: Restrictions added to business area folders that limit the data available, within a given table, to a set of users.
Related Topics