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

Oracle Transfer Pricing Reports

This chapter describes the Oracle Transfer Pricing reports and the procedure for generating and viewing them.

This chapter covers the following topics:

Overview of Oracle Transfer Pricing Reports

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:

Oracle Transfer Pricing (FTP) provides you the following three types of reports:

The following table list the transfer pricing reports and their Discoverer file names.

Transfer Pricing Reports
Report Name Discoverer Workbook Title Discoverer Worksheet Title
STD - FTP Interest Margin Account Detail STD - FTP Interest Margin Account Detail FTP Interest Margin Account Detail
STD - FTP Interest Margin (Org/Product, Summary) STD - FTP Interest Margin (Org/Product Summary) FTP Interest Margin (Org/Product Summary)
STD - FTP Margin Stratification STD - FTP Margin Stratification
  • FTP Margin Stratification

  • FTP Margin Stratification Over Time

You can run these reports either from the Document tab of the Oracle Transfer Pricing application, or use the Oracle Discoverer Desktop or Discoverer Administration applications themselves. See:

STD - FTP Interest Margin Account Detail

This hierarchical report is based on account-level data and shows both the account level match funded spread and the interest margin for each product.

This reports lets you:

Business Area Folders

The STD - FTP Interest Margin Account Detail report is based on the following business area folders:

Joins

The STD - FTP Interest Margin Account Detail report makes use of the following joins to retrieve data:

Conditions

The STD - FTP Interest Margin Account Detail report uses the following condition to filter data:

Page Items

The STD - FTP Interest Margin Account Detail report is based on the following parameters:

Rows

The STD - FTP Interest Margin Account Detail report has the following row:

Report Headings and Calculations (Columns)

The STD - FTP Interest Margin Account Detail report has these headings and calculations (columns). If applicable, the calculation, source, or default value for the column is provided below.

Related Topics

Overview of Oracle Transfer Pricing Reports

Common Report Concepts

Generating and Viewing Reports

STD - FTP Interest Margin Account (Org/Product, Summary)

This hierarchical report is based on summarized ledger data and shows both the account-level match funded spread and the interest margin for each product.

Business Area Folders

The STD - FTP Interest Margin Account (Org/Product, Summary) report is based on the following business area folders:

Joins

The STD - FTP Interest Margin Account Detail (Org/Product, Summary) report makes use of the following joins to retrieve data:

Conditions

The STD - FTP Interest Margin Account Detail (Org/Product, Summary) report uses the following conditions to filter data:

Page Items

The STD - FTP Interest Margin Account Detail (Org/Product, Summary) report is based on the following parameters:

Rows

The STD – FTP Interest Margin Account (Org/Product Summary) report displays Natural Accounts included in the Natural Account hierarchy as rows (display defaults to level 3 of the hierarchy).

Report Headings and Calculations (Columns)

The STD - FTP Interest Margin Account Detail (Org/Product, Summary) report has these headings and calculations (columns). If applicable, the calculation, source, or default value for the column is provided below.

Related Topics

Overview of Oracle Transfer Pricing Reports

Common Report Concepts

Generating and Viewing Reports

STD - FTP Margin Stratification

This report is based on the account level data and lets you define up to 10 transfer rate stratification ranges. The report shows both the matched spread and interest margin for each stratification range. The report comprises two Discoverer worksheets:

Business Area Folders

Both the worksheets of the STD - FTP Margin Stratification report are based on the following business area folder:

Joins

Both the worksheets of the STD - FTP Margin Stratification report make use of the following joins to retrieve data:

Conditions

The STD - FTP Interest Margin Account Detail (Org/Product, Summary) report uses the following conditions to filter data:

Page Items

The STD - FTP Margin Stratification report is based on the following parameters:

Rows

The STD - FTP Margin Stratification report has the following row:

Instrument Type Code

Calculation:

Stratification – Transfer Rate: DECODE(LEAST(GREATEST(EPF All Account Tables.Non weighted Transfer Rate,:S1_T1L),:S1_T1H),EPF All Account Tables.Non weighted Transfer Rate,'01.  0 - '||:S1_T1H,DECODE(LEAST(GREATEST(EPF All Account Tables.Non weighted Transfer Rate,:S1_T2L),:S1_T2H),EPF All Account Tables.Non weighted Transfer Rate,'02.  '||:S1_T2L||' - '||:S1_T2H,DECODE(LEAST(GREATEST(EPF All Account Tables.Non weighted Transfer Rate,:S1_T3L),:S1_T3H),EPF All Account Tables.Non weighted Transfer Rate,'03.  '||:S1_T3L||' - '||:S1_T3H,DECODE(LEAST(GREATEST(EPF All Account Tables.Non weighted Transfer Rate,:S1_T4L),:S1_T4H),EPF All Account Tables.Non weighted Transfer Rate,'04.  '||:S1_T4L||' - '||:S1_T4H,DECODE(LEAST(GREATEST(EPF All Account Tables.Non weighted Transfer Rate,:S1_T5L),:S1_T5H),EPF All Account Tables.Non weighted Transfer Rate,'05.  '||:S1_T5L||' - '||:S1_T5H,DECODE(LEAST(GREATEST(EPF All Account Tables.Non weighted Transfer Rate,:S1_T6L),:S1_T6H),EPF All Account Tables.Non weighted Transfer Rate,'06.  '||:S1_T6L||' - '||:S1_T6H,DECODE(LEAST(GREATEST(EPF All Account Tables.Non weighted Transfer Rate,:S1_T7L),:S1_T7H),EPF All Account Tables.Non weighted Transfer Rate,'07.  '||:S1_T7L||' - '||:S1_T7H,DECODE(LEAST(GREATEST(EPF All Account Tables.Non weighted Transfer Rate,:S1_T8L),:S1_T8H),EPF All Account Tables.Non weighted Transfer Rate,'08.  '||:S1_T8L||' - '||:S1_T8H,DECODE(LEAST(GREATEST(EPF All Account Tables.Non weighted Transfer Rate,:S1_T9L),:S1_T9H),EPF All Account Tables.Non weighted Transfer Rate,'09.  '||:S1_T9L||' - '||:S1_T9H,DECODE(LEAST(GREATEST(EPF All Account Tables.Non weighted Transfer Rate,:S1_T10L),:S1_T10H),EPF All Account Tables.Non weighted Transfer Rate,'10.  '||:S1_T10L||' - '||:S1_T10H,'Other'))))))))))

Report Headings and Calculations (Columns)

Totals

Grand Total Rows Sum for Record Count

Related Topics

Overview of Oracle Transfer Pricing Reports

Common Report Concepts

Generating and Viewing Reports