This chapter describes the procedure to output transfer pricing results to the seeded or user-defined alternate columns instead of default columns of the application.
This chapter covers the following topics:
In Oracle Transfer Pricing, you can output transfer pricing results either to the default columns of the application or to the seeded or user-defined alternate columns selected using the Alternate Rate Output Mapping rule.
The Alternate Rate Output Mapping rule is referenced by the Transfer Pricing Process rule to output transfer rate, option cost, and adjustment calculation results for each instrument record in an account table for a transfer pricing process run. See: Transfer Pricing Process Rule and Alternate Rate Output Mapping Rules.
The procedure for working with and managing the Alternate Rate Output Mapping rule is mostly similar to that of other Oracle Transfer Pricing business rules. It includes the following steps:
Searching for Alternate Rate Output Mapping rules. See: Searching for Rules.
Viewing and Updating Alternate Rate Output Mapping rules. See: Viewing and Updating Rules.
Duplicating Alternate Rate Output Mapping rules. See: Duplicating Rules.
Deleting Alternate Rate Output Mapping rules. See: Deleting Rules.
Extracting and Loading Alternate Rate Output Mapping rules. See: Extracting and Loading Rules.
Before creating Alternate Rate Output Mapping rules, you need to register alternate output columns for account tables. See: Registering Alternate Output Columns for Account Tables.
Related Topics
Register Alternate Output Columns for Account Tables
You create an Alternate Rate Output Mapping rule to select the alternate columns to output transfer rate, option cost, and adjustment calculation results for each instrument record in an account table for a transfer pricing process run.
Navigate to the Alternate Rate Output Mapping rule home page.
Complete standard steps for this procedure. See: Creating Rules.
In addition to the standard steps for creating rules, the procedure for creating Alternate Rate Output Mapping rule and version involves the following extra steps after standard step 9:
Select the account table for which you want to output transfer pricing results in alternate columns.
(Optional) Select an alternate column mapping for the following result types:
Transfer Rates: Transfer Rate, Matched Spread, and Remaining Term Transfer Rate.
Important: Option Cost output columns are displayed only for tables registered with the Option Cost classification.
Option Costs: Historic Option Adjusted Spread, Historic Static Spread, Current Option Adjusted Spread, and Current Static Spread.
Adjustments: Other Adjustment Rate and Other Adjustment Amount.
(Optional) Deselect the Apply Mappings to All Tables option: The default setting of the Apply Mappings to All Tables option is selected. This functionality lets you copy alternate column mappings from the current page to all other account tables in which the selected result columns are available and replaces any previous selections in the other account tables. If a result type exists in the target table but is not displayed on the current page (for example, when the target table is classified for Option Cost, but the current source table does not have the Option Cost classification), the rule maps results to default columns in the target table (in our example, it would map to Historic Option Adjusted Spread Alternate column, Historic Static Spread Alternate column, etc.). If you deselect the Apply Mappings to All Tables option, the rule saves mappings to the default columns on any table for which you have not explicitly selected alternate output columns.
Related Topics
Overview of Alternate Rate Output Mapping Rules
During table registration, select alternate output columns for different types of transfer pricing results for each account table. You can select a seeded or user-defined alternate output column for a particular transfer pricing result type by registering the column with a Column Property Assignment appropriate to the result type.
Once you make appropriate Column Property Assignment to the alternate columns, they become available in the Alternate Rate Output Mapping rule under the appropriate result types. Selecting alternate output columns for each Transfer Pricing Column Property Assignment type is typically a one-time setup process. However, the application lets you modify the alternate output columns setup if necessary.
Note: For further information on the Table Column Property Assignment step of the table registration process, see: Performing Table and Column Registration Tasks, Oracle Financial Services Implementation Guide.
For more information on the FTP-specific alternate account table columns and Column Property Assignments, see: Confirming Oracle Transfer Pricing Table Column Property Assignments, Oracle Financial Services Implementation Guide.
Related Topics