A consolidation hierarchy in Oracle EPM (typically in Oracle FCCS or HFM) is the structured parent-child relationship between legal entities that defines how subsidiary financial data is combined upward through the group structure to produce the consolidated group financial statements. Each entity in the hierarchy has a parent, an ownership percentage, and a consolidation method — which together determine how the entity’s financial data contributes to the group result. A 100%-owned subsidiary contributes all of its financial data (revenue, costs, assets, liabilities) to the parent through full consolidation. A 40%-owned associate where the group exercises significant influence but not control contributes only its share of net profit to the group P&L through the equity method. A 50%-owned joint venture may be consolidated proportionally — contributing 50% of its revenue, costs, assets, and liabilities — depending on the applicable IFRS treatment.
Consolidation Hierarchy Architecture in FCCS
| Hierarchy Element | Definition | FCCS Implementation |
|---|---|---|
| Parent entity | The entity that receives consolidated data from its children | Parent member in the Entity dimension hierarchy |
| Child entity | The subsidiary or associate contributing financial data | Child member in the Entity dimension hierarchy |
| Ownership % | The percentage of the child’s equity owned by the parent | Configured in FCCS Ownership Management application |
| Consolidation method | Full, Proportional, Equity Method, No Consolidation | Assigned per entity in Ownership Management; drives which consolidation rules apply |
| Minority interest (NCI) | The portion of equity not owned by the group | Calculated automatically by FCCS from ownership % and consolidation method |
| Alternate hierarchy | A second view of the entity structure for management reporting | Supported in FCCS — enables management and statutory hierarchy views from same Entity dimension |
Alternate Hierarchies in GCC Group Structures
GCC family-owned conglomerates and diversified holding companies frequently require more than one view of the entity hierarchy. The statutory consolidation hierarchy reflects the legal ownership structure — each entity consolidated under its legal parent. The management reporting hierarchy reflects how the business is actually managed — a Saudi entity that is legally owned by a UAE holding company but operationally managed as part of the GCC Industrial Division may need to appear under the GCC Industrial Division in the management P&L, even though it sits under the UAE holding in the legal consolidation. Oracle FCCS supports alternate hierarchies in the Entity dimension — enabling both the statutory and management views to exist in the same application, with the statutory hierarchy driving the legal consolidation and the alternate hierarchy driving the management reporting structure.
What Goes Wrong in Practice
The most common consolidation hierarchy failure with direct financial reporting impact is an entity whose ownership percentage has changed — through acquisition of additional shares, partial disposal, or a group restructuring — but whose FCCS Ownership Management configuration has not been updated to reflect the change. FCCS continues to consolidate the entity using the prior ownership percentage, producing minority interest calculations that are incorrect for the current period’s ownership structure. For periods following any change in group ownership structure, the FCCS Ownership Management configuration must be updated before the consolidation run executes — not after the group financial statements are reviewed and a discrepancy is discovered.
How Loop Wise Solutions Designs Consolidation Hierarchies
We design consolidation hierarchies from the group’s legal ownership structure documentation — typically the group structure chart maintained by the company secretariat function — validated against the audited subsidiaries list in the most recent statutory financial statements. We document the consolidation method basis for each entity (full, proportional, equity) with the IFRS standard that justifies it, so that the hierarchy configuration is auditable and can be explained to the external auditor without requiring the EPM architect’s involvement in the audit process.
