Siebel Customer-Centric Enterprise Warehouse Installation and Configuration Guide > Configuring Siebel Customer-Centric Enterprise Warehouse for Oracle 11i >

Setting the Organization ID

The Organization ID for Oracle Applications defaults to 204 as the invoice information in Oracle Applications does not have an Organization ID for inventory organizations. This column must be configured with the correct Organization ID or the ADI is not able to resolve dimension keys, such as the Product key and Sales Product Key, for the applicable fact load.

For example, by default the Sales Order Lines table supplies the load mapping with the Product key. However, if it does not, the ADI performs a lookup to retrieve the Product key from IA_PRODUCTS. The lookup uses the Organization ID to help resolve the Product key. The ADI uses the SOURCE_ID, CREATED_ON_DT, and the PRODUCT_ID, where the PRODUCT_ID is defined as the INP_INV_ITEM_ID concatenated with the ORGANIZATION_ID. If the wrong Organization ID is provided, then the Product ID is not defined correctly, which results in a failed lookup for the Product key, and the Product key is not loaded into the applicable fact table during the load.

If your business has multiple Organization IDs for inventory organizations, you can use the most commonly used Organization ID, or the master Organization ID as defined in your Oracle Applications instance.

To reset the Organization ID

1. In PowerCenter Designer, open the Configuration for Oracle Applications v11i folder.
2. Edit all applicable Source Adapter mapplets.

   The following is a list of applicable mapplets for Oracle 11i:

   • MPLT_SAI_SALES_IVCLNS
   • MPLT_SAI_GL_REVENUE
   • MPLT_SAI_GL_REVENUE_UPDATE
3. Double-click the Expression transformation to open the Edit Transformation box.
4. In the Ports tab, edit the expression for the VAR_ORGANIZATION_ID.

   By default, it is set to 204. Edit it by setting it to the master organization ID.

5. Validate and save your changes to the repository.