Oracle Oracle Financial Consolidation Hub, Руководство пользователя

Страница: 130 / 220

14-10 Oracle Financial Consolidation Hub User's Guide
period, the balances rule runs in snapshot mode and synchronizes both Corporation
and Distribution.
After the above submission, new journals are posted to company 16 in February. The
Data Submission page indicates an Impacted status for Corporation. Distribution's
status remains unchanged. To integrate this new data into consolidation, you perform
data submission for Corporation. This time the balances rule runs in incremental mode
and accesses changes in companies 16 and 17. This synchronizes the changes in
company 16 into Corporation.
Setting Up Data Submission for External Sources
Data is submitted for external sources using a spreadsheet loader. You can define rules
to transform and check this data by assigning transformation and validation rule sets to
entities.
See: Transformation Rule Set, page 6-6
See: Validation Rule Sets, page 14-10
Transformation Rule Sets
You can use a transformation rule set to convert submitted data to a standardized chart
of accounts.
See: Setting Up Interface Data Transformer, Oracle General Ledger User Guide
Before you can use a lookup table or PL/SQL function for data transformation, you
must create and register it.
See: Task 10: Data Transformation and Validation, page 5-15
Validation Rule Sets
Validation rule sets enable you to validate submitted data before upload. Validation
rule sets run after transformation rule sets. A validation rule set comprises validation
rules, which are applied to each row of loaded data.
Validation rules are comprised of the following types:
• Conditions
• Lookup tables
• PL/SQL functions
If any row of data is invalid, the entire data is not submitted.
Condition Rule
A condition rule defines a set of conditions that indicate that a trial balance is invalid.