User's Manual

Setting Up Oracle Enterprise Performance Foundation 5-1

Setting Up Oracle Enterprise Performance

Foundation

Overview

Oracle's Corporate Performance Management applications, including Financial

Consolidation Hub, share a common data model called Oracle Enterprise Performance

Foundation. Enterprise Performance Foundation provides a storage area for managing

reference data that contains dimensions, dimension members, hierarchies, and business

data. Financial Consolidation Hub, Enterprise Planning and Budgeting, and

Profitability Manager use this reference data. Oracle General Ledger users can transfer

their reference and financial data into Enterprise Performance Foundation. Other

customers can load reference and transactional data from third party systems using

spreadsheet loaders and open interfaces.

EPF comes with a set of pre-defined fact tables; a table called FEM_BALANCES

(Balances table) that is used to store financial balances loaded from Oracle General

Ledger or any other financial system, and 20 tables called FEM_DATA1 to

FEM_DATA20 to be used for other purposes. Financial Consolidation Hub uses the

Balances table in two key ways:

• Reads from the table to access the financial data from an enterprise's subsidiaries.

• Writes consolidated results back to the table.

This provides you with a single data source when you perform any financial or

management reporting.

Each fact table includes a number of dimension columns. These dimensions are used to

model your business and are analogous to the segments of an Oracle General Ledger

chart of accounts. Since Oracle's analytical applications share a common data model,

some of these dimensions may be relevant to Financial Consolidation Hub while others

may not.