Oracle Oracle Financial Consolidation Hub, User Manual, Page: 131 / 220

Submitting Data 14-11
Lookup Table Rule
A lookup table rule defines a table of valid dimension member values for specified
dimensions. You can select multiple columns in the lookup table to compare against
and specify whether these columns match a column in the data loaded or match a fixed
value. If a trial balance does not have a dimension member value that is in the lookup
table, then the data submission fails.
Before you can use a lookup table rule for data validation, you must create and register
it .
See: Task 10: Data Transformation and Validation, page 5-15
PL/SQL Function Rule
A PL/SQL function rule evaluates the validity of each row in the trial balance. The
PL/SQL function takes ROWID as the input parameter, and must return SUCCESS for
each row so data submission can proceed.
Before you can use a PL/SQL function rule for data validation, you must create and
register it.
See: Task 10: Data Transformation and Validation, page 5-15
Submitting Data for External Sources
For entities with external sources, you can submit data for a given entity, period,
currency, and balance type. You submit data for external entities using a spreadsheet
loader, which can be accessed from the Data Submission page.
Each data submission is for a period, entity, currency, and balance type and you can
perform multiple data submissions for the same parameters.
Each external data submission must be balanced.
Note:
If you are submitting data for a user defined data type, the data
submission may or may not be required to be balanced, according to
the parameters set for the data type.
Spreadsheet Loader
The spreadsheet loader is a Web ADI spreadsheet that you can use to enter balances
data for an entity. If you submit data for an entity with an assigned transformation rule
set, the spreadsheet is in the pre-transformation format. Otherwise, the spreadsheet is in
the standard format. For both formats, enter a unique combination of dimension
members on each row of the spreadsheet. Each format performs different checks on the
data submission.
Once you generate a spreadsheet uploader using the Web interface, you can reuse it for