Skip Headers

Oracle Transfer Pricing User Guide
Release 12.1
Part Number E13524-03
Go to Table of Contents
Contents
Go to previous page
Previous
Go to next page
Next

Alternate Rate Output Mapping Rules

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:

Overview of Alternate Rate Output Mapping Rules

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:

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

Standard Navigation Paths

Creating Alternate Rate Output Mapping Rule

Prerequisites

Register Alternate Output Columns for Account Tables

Procedure

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.

  1. Navigate to the Alternate Rate Output Mapping rule home page.

  2. Complete standard steps for this procedure. See: Creating Rules.

Additional steps to create Alternate Rate Output Mapping Rule

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:

  1. Select the account table for which you want to output transfer pricing results in alternate columns.

  2. (Optional) Select an alternate column mapping for the following result types:

  3. (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

Standard Navigation Paths

Registering Alternate Output Columns for Account Tables

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

Overview of Alternate Rate Output Mapping Rules

Standard Navigation Paths