Previous	Next		Contents	Index	Navigation		Library

• Use a SQL script to select data from external tables and insert into the Hierarchy API table

• Use customized forms

• Use download hierarchy procedure when transferring data from one Oracle Sales Compensation implementation into another. The steps would include using the download hierarchy procedure in your test implementation of Oracle Sales Compensation for example, exporting the Hierarchy API table from the test database, importing the Hierarchy API table into the production database

Only one dimension hierarchy can be transferred at a time. The concurrent procedure for transferring the data UPLOAD HIERARCHY will request information on the name of the dimension, the name of the hierarchy to be transferred, the start period and end period that should be defined for this hierarchy. This will allow the dimension hierarchy to be uniquely defined. The UPLOAD HIERARCHY concurrent procedure also requests the name of the unique column in the Dimension table which uniquely identifies each entry in the dimension table. If a value for the unique column is not entered as a parameter, it defaults to the name of the dimension value column of the dimension hierarchy.

During this procedure the hierarchy data will be loaded row by row. In case of error, that row will be marked as unable to load and the process of transferring the data will continue. After making changes you may use the Reload Hierarchy procedure to reload the hierarchy.