User's Manual

14-12 Oracle Financial Consolidation Hub User's Guide
a different Entity, Period, Balance Type, Currency (if Functional Currency Load),
Execution Mode, and Amount Type. You cannot update the Currency Type and
Measure options as those options affect the spreadsheet layout.
Note: Ensure that the load identifier is unique prior to performing any
loads. You can enter any unique value to the load identifier.
After you submit a load, it will be visible in the Data Submission Monitor.
Note: After you upload the WebADI spreadsheet, Financial
Consolidation Hub must load the balances into Enterprise Performance
Foundation. Thus, although the WebADI spreadsheet may upload
successfully, you must verify that the data submission completes
successfully in the Financial Consolidation Hub Data Submission User
Interface.
See: Appendix B: WebADI Spreadsheets, page A-1
Standard Spreadsheet Format
The standard spreadsheet format is used when no transformation rule set is assigned to
the entity. You can use this format if your trial balance corresponds to your
consolidation dimensions and you therefore do not need to apply transformation rules.
Before the spreadsheet is uploaded, the system verifies that each dimension member is
valid and that the spreadsheet is balanced.
Note: Input the dimension member names in the spreadsheet.
Note: Double click a cell to see a list of valid values.
Pre-Transformation Spreadsheet Format
The pre-transformation spreadsheet format is used when a transformation rule set has
been assigned to an entity. You can use this format if your trial balance does not match
your consolidation dimensions and you therefore need to apply transformation rules.
Before the spreadsheet is uploaded, the system verifies that the spreadsheet is balanced.
The spreadsheet exposes all dimensions in Enterprise Performance Foundation,
including inactive ones.
Since the data submission will be transformed, Financial Consolidation Hub does not
know the list of valid dimension members when you upload them in the spreadsheet.
Therefore, it cannot provide you with a list of available members, or verify that all the
values the designated are valid at the time of upload. After the data submission has
been uploaded into Financial Consolidation Hub, it is transformed and then its values