Managing GAAP, Statutory, and Management Consolidations

by Migrating from Enterprise to the Oracle Hyperion Close Suite

Challenge

  • Hyperion Enterprise legacy system was inflexible, lacking dynamic dimensionality/reporting capabilities
  • picture12Lack of alignment with Chart of Accounts usage, ancillary dimensionality (Responsibility Center, Office, Location, Project Codes), as well as consolidation and reporting processes
  • Local offices consolidating inside of the Oracle GL system, as well as maintaining external spreadsheets; journal entries were entered manually in both Oracle and Enterprise
  • Enterprise translation differences did not balance as inconsistencies existed with exchange rates
  • Local offices had no access to the consolidation system and lacked detailed reporting capabilities
  • Inefficient processes resulted in excessive spreadsheet usage, misuse of time and lack of visibility
  • Lacking bridge between statutory, US GAAP and internal management reporting

Solution

  • Focused on the development of core dimensionality, mainly the Chart of Accounts, Responsibility Center, Reporting Unit, Location, and Tracking (bridge between Statutory, US GAAP, and Mgmt reporting)
  • Utilized FDMEE/ODI to drill back from the consolidation solution into the source systems
  • picture13Business rules facilitated the automation of cash flow, KPI reporting, allocations, intercompany eliminations, equity accounting, journal entries, and the Planning data in HFM.
  • The Reporting solution encompassed a self-service component and direct delivery (publication)
  • Process Management to assist with close process and the data submission and approval process.

Benefits

  • Scalable, dynamic solution provides more granular levels of data efficiently, requiring less time gathering data and reconciling, and allowing more time for business analysis
  • Increased dimensionality, standardized self-service reporting, and ad-hoc analysis capabilities
  • Deployment provides a common platform for Corporate Accounting, Tax, Treasury and local office analysis / reporting from a single, consistent source of information
  • Automation of journal entries with no manual intervention and are pushed back down to Oracle.
  • Enablement of Process Management allowed for the de-centralization of the data integration process, with the local offices submitting their data (reset accountability)

Return to Client List