Metadata within the source system changes over time, as well as the metadata and hierarchies in the target system.
The management of hierarchies is an ongoing process, with frequent changes due to updates in business functions and organizations. When managing hierarchies between source and target systems, users generally create new hierarchies, replace old hierarchies with new hierarchies or update hierarchies.
Managing hierarchies between systems becomes difficult because of the size of the hierarchies, the latency between system updates, and the needs of operational systems versus analytical systems. When managing hierarchies as part of the general ledger integration process, keep in mind the following assumptions:
The only operations between hierarchy management in the source system and target application is to create or update the hierarchies by merging in the target. ERP Integrator never deletes hierarchies or members in a target application. If additional members or hierarchies are not specified, they are ignored by ERP Integrator.
When you integrate a hierarchy from the source system to the target system, select the node from the source that serves as the root node in the target.
The integration pushes the hierarchy into the target system, and reports any errors encountered during the process.
You can use the Process Details page to view errors logged in ERP Integrator. You can also select the Log link to review the Oracle Data Integrator log file. For Performance Management Architect applications, you can also view profile creation errors in the Job Console. See Viewing Process Details or the appropriate product documentation for additional information.
A hierarchy selection in the dimension mapping is optional. However, you must at least determine how to handle members not in a hierarchy. For example, create children of a selected node, as orphans, (for Performance Management Architect only) or to not bring orphans over.