Corporation Switch User Manual

16-2 Oracle Financial Consolidation Hub User's Guide
spreadsheet is uploaded, the system verifies that each dimension member is valid and
that the entry is balanced. Balancing is only enforced depending on the data type
options. Unlike the data submission spreadsheet loader, the dimension member
combinations on each row of the adjustment spreadsheet loader do not need to be
unique.
See: WebADI Spreadsheets, page A-1
Note: Although the WebADI spreadsheet may upload successfully, you
should verify that the adjustment is completed successfully in the
Financial Consolidation Hub Adjustment window.
Uploading Adjustments using XML files
You can upload multiple adjustments into Financial Consolidation Hub at the same
time through a zip file of XML files. Financial Consolidation Hub will perform the same
validation it does for uploading adjustments via WebADI, and each adjustment will be
tracked on the Adjustment Main Page user interface just like WebADI adjustments.
1. Navigate to the Consolidation > Adjustment page.
2. Click Upload via XML.
To view the XML format, click Preview XML Format. The following tables describe
the valid values for the XML file.
Values for Header Region (UPLOAD_ENTRY_HEADERS_API)
XML Tag Value
p_entry_name Free form text field
p_description Free form text field
p_hierarchy_id Consolidation Hierarchy name
p_category_code Category name
p_entity_id Operating Entity name
p_balance_type_code Any data type name specified in the Foundation user
interface
p_start_cal_period_id Calendar Period name