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: