Oracle Financial Consolidation HUB

Tags:

financial2 gl2 create new tag

First Release Version: 12.0

Oracle Financial Consolidation HUB Introduction

Oracle Financial Consolidation Hub consolidates financial data from various sources and provides a single view of an enterprise's financial position across organizational boundaries, enabling compliance with financial reporting requirements, adaption to changing business conditions, and creating a basis for ongoing performance management.

Oracle General Ledger is the central repository of financial information for an organization. The information in the General Ledger is the source data in financial and management reporting, profitability analysis, budgeting and planning, and consolidation.

Oracle's Corporate Performance Management applications share a common data through the Oracle Enterprise Performance Foundation. Enterprise Performance Foundation is used for analytical processing contains the Oracle General Ledger data as well as data from other financial data sources. The source Oracle General Ledger data is transferred and stored in the underlying architecture of the Enterprise Performance Foundation before analysis or planning is conducted.

Oracle Enterprise Performance Foundation

Oracle Enterprise Performance Foundation is a repository of data and business rules that provides the framework for the Corporate Performance Management applications. A set of pre-defined tables (Fact Tables) are used to store financial balances from the Oracle General Ledger and other financial systems. Additional fact tables (FEM_DATA1 to FEM_DATA20) are used to house other related information. Financial Consolidation Hub uses the Balances Table to:

• 1. Reads from the table to access the financial data from an enterprise's subsidiaries
• 2. Writes consolidated results back to the table.

The repository represents the "single source of truth" providing features to manage the repository metadata, generate management reports and perform analysis. Enterprise Performance Foundation is the storage area for managing the reference data and contains dimensions, dimension members, hierarchies, and business data. Each fact table includes a number of dimension columns used to model the business or organization. The dimensions are similar to the segments of an Oracle General Ledger chart of accounts.

Applications which are included in the Enterprise Performance Foundation are:

• Oracle General Ledger
• Oracle Enterprise Planning and Budgeting
• Oracle Financial Consolidation Hub
• Oracle Profitability Manager
• Oracle Transfer Pricing / Oracle Risk Manager

Comments

Links

• Related: General Ledger, Subledger Accounting, Enterprise Performance Foundation, Enterprise Budget and Planning, General Ledger Financial Reporting, Global Consolidation

This Topic Is Referenced By These Topics:
Related Links: AccountingSetup, AttachmentsGeneralLedger, AuditAbility, ChartofAccounts, DataSecurity, FA12AssetsCreateAccounting, FederalFinancials, FinancialImplementationGuide, GeneralLedger, GeneralLedgerImplementationGuide, GLFinancialReporting, GlobalConsolidation, GlobalIntercompany, GLOnlineInquiries, InternalControl, JournalEntry, MultiOrganization, OtherMinorGLFeatures, PublicSectorFinancials, PublishDocControlReport, SubLedgerAccounting

---

---

Was This Topic Useful to You?

Others rated this topic as shown. Please include your rating.

Choice

Select ...Very UsefulSomewhat UsefulNo OpinionNot Useful

Somewhat Useful (1)

Collaborating Authors and Reviewers: BillDaley - 20 Mar 2007