Enabling Intercompany Partner Dimensions for Financial Management

Oracle Hyperion Financial Data Quality Management, Enterprise Edition supports intercompany partner (ICP) dimensions used by Oracle Hyperion Financial Management. The ICP dimension represents a container for all intercompany balances that exist for an account. ICP is a reserved dimension used in combination with the account dimension and custom dimensions to track and eliminate intercompany transaction details.

When working with ICP transaction in FDMEE, note the following:

  • ICP transactions can be loaded only from a file.

  • If the import format contains a dimension of type "ICPTRANS," then it is considered an ICP Transaction load.

  • If the import format does not contain any dimension of type "ICPTRANS," then it is considered a standard data load.

  • When ICP transactions are enabled, the following attributes are included:

    • Attr1 – Transaction ID

    • Attr2 – Transaction Sub ID

    • Attr3 – Reference ID

    • Attr4 – Transaction Date

    • Attr5 – Entity Currency Amount

    • Attr6 – Transaction Currency

    • Attr7 – Conversion Rate

    • Attr11 – Comment

    ICP transactions are included in the import format.

When registering a Financial Management application, an "Enable ICP Transactions" option is available. When this option is enabled, additional ICP dimensions are added to Dimension Details. These dimensions are registered with dimension classification "ICPTRANS" (ICP Transactions) and the attributes of the values are stored in the data table column name "ATTR." Source values of the ICP dimensions cannot be transformed by mapping. If some transformation is required, then use a script from another dimension map. Also see Entity and Intercompany.

To enable intercompany partner dimensions:

  1. On the Setup tab, under Register, select Target Application.
  2. In the Target Application summary grid, select a Financial Management application.
  3. Select the Dimension Details tab.
  4. Click Enable ICP Transactions.
  5. When the Refresh Metadata Confirmation window is displayed, click Continue and Save Later to add the ICP transactions.

    In this case, to save the ICP transactions, click Save to save the transactions with the dimension details.

    To add and save the ICP transactions immediately, click Save.

  6. Click Save.