Entity and Intercompany
The Entity dimension represents the organizational structure of the company, such as the management and legal reporting structures. Entities can represent divisions, subsidiaries, plants, regions, countries, legal entities, business units, departments, or any organizational unit. You can define unlimited entities.
The Intercompany dimension represents all intercompany balances that exist for an account. This is a reserved dimension that is used in combination with the Account dimension and any custom Oracle Hyperion Financial Management dimension.
Financial Management requires that members of the Entity dimension have the IsICP property set for those members that are intercompany members. When an application is populated, Oracle Hyperion EPM Architect populates the ICP (intercompany) dimension with the appropriate members based on the Entity members that are flagged as ICP (intercompany) entities.
E-Business Suite has two scenarios for mapping source segments to the Entity dimension: 1) an intercompany segment exists in the source chart of accounts and 2) an intercompany segment does not exist in the source chart of accounts. For PeopleSoft, the business unit is mapped to the entity and the affiliate is mapped to the ICP.
The properties set by Oracle Hyperion Financial Data Quality Management, Enterprise Edition are shown below. (Any properties not set are defaulted by the application or Performance Management Architect.
Table 1-4 Entity and Intercompany Required Properties
| Property | Application Type | Population Method/Value |
|---|---|---|
| Name | Consolidation, System | Populated from the code/value in the source accounting entity. |
| Description | System | Populated from the name in the source accounting entity. |
| IsICP | Consolidation |
If the intercompany segment exists in the source, then this flag is set automatically per the rules defined. If the intercompany segment does not exist, then you specify how this property is set. See Entity and Intercompany. For ICP transaction data to load correctly, you must manually set the property ISICP="Y" for those accounts participating in ICP. In Performance Management Architect, you can use the Property Grid to modify the property. If using Financial Management Classic application administration, extract the metadata, update, and then re-import it back. After modifying the property, you can load data correctly for ICP transactions. |
| Currency | Consolidation, Essbase, Planning |
For Financial Management target applications: The entity currency is set based on the default defined in the mapping rule for the Entity dimension. (All members are assigned the same currency.) As the administrator, ensure that the functional currency of the source is consistent with the default Entity currency. |
Note:
These are the only properties that are set as part of the FDMEE integration, all others are defaults when you create new members. If a property was originally set by FDMEE, and you change it later, the property is overridden.