User's Manual

Submitting Data 14-1
14
Submitting Data
Overview
Data Submission enables you to submit trial balances for operating entities. Depending
on the source system, the methods for submitting balances are as follows:
• Oracle Source - To source from Oracle General Ledger, you can automatically
submit financial data from General Ledger to Financial Consolidation Hub.
• External Source - These are all source systems other than Oracle General Ledger.
You can copy and paste the trial balance from these systems into a spreadsheet
loader provided by Financial Consolidation Hub. You can optionally apply
transformation rules as needed to convert data from the external source system into
the format you use in Financial Consolidation Hub.
• Open Interface Tables - You can push data from your source system into open
interface tables, and then push the data into Financial Consolidation Hub.
This chapter will cover Oracle and external sources.
See: Open Interface Tables, page B-1.
Additional Data Types
If you have additional data types assigned to the entity, you can run data submission
for those data types. For an entity, each balance type can have a different designated
source system.
Data Submission and the Enterprise Performance Foundation
When you submit balances in Financial Consolidation Hub, the balances are written to
the FEM_BALANCES table in the Enterprise Performance Foundation. Financial
Consolidation Hub provides all of the necessary tools to monitor and maintain the
balances. For information on how to monitor the balances using the EPF user interface,