Siebel Customer-Centric Enterprise Warehouse Installation and Configuration Guide > Configuring Siebel Strategic Sourcing Analytics > Process of Configuring Siebel Strategic Sourcing Analytics for Oracle 11i >
Configuring the Purchase Organization Hierarchy
This task is a step in the Process of Configuring Siebel Strategic Sourcing Analytics for Oracle 11i.
This configuration also applies to the Spend functional area.
The Purchase Organization hierarchy can contain 10 different levels. Each level is denoted by a number, where 1 is the top of the hierarchy and 10 is the bottom of the hierarchy. By default, the first three levels of the Purchase Organization hierarchy are set as follows:
EXT_BORG_HIER1_CODE: Organization ID
EXT_BORG_HIER2_CODE: Legal Entity ID
EXT_BORG_HIER3_CODE: Set of Books ID
The remainder of the hierarchy ports (
EXT_BORG_HIERX_CODE) are populated using whatever values are input into the
INP_BORG_HIERX_CODE ports (X denotes the level within the hierarchy).
If you want to configure your hierarchy differently than what is prepackaged, you must modify the
EXT_BORG_HIERX_CODE ports in the Source Adapter mapplet.
To modify the Purchase Organization hierarchy
- In PowerCenter Designer, open the Configuration for Oracle Applications v11i folder.
- Open the MPLT_SAI_BUSN_ORGS mapplet.
- Edit the expression for the
- Validate the expression, and save your changes to the repository.
If applicable, you may need to modify the hierarchy in the front end so that end users can use the hierarchy levels for queries and reports.