Oracle^® Business Intelligence Applications Installation and Configuration Guide > Configuring Oracle's Supply Chain Analytics family of products > Process of Configuring Supply Chain Analytics for Oracle 11i >

Configuring the Bill of Materials Explosion for Oracle 11.5.9 and above version

This task is a step in the Process of Configuring Supply Chain Analytics for Oracle 11i.

Starting from 11.5.9 version, the BOM_EXPLOSION_TEMP table is changed to temp table, duration = SYS$SESSION. To be able to extract data from the BOM_EXPLOSION_TEMP table, you need to follow these configuration steps:

To configure the bill of materials explosion options for Oracle 11.5.9 and above

1. Click Start, click Run, type regedit, click OK.
2. Go to the following registry key:

   HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\PowerMart\Parameters\Configuration

3. On the Edit menu, point to New, and then click String Value.
4. Enter the String Value as:
   • Name: ShareConnections_<folder name>.SDE_ORA_BOMItemFact
   • Data: Yes
   • The folder name is SDE_ORA1159_Adaptor or Oracle 11.5.9 Version and SDE_ORA11510_Adaptor for Oracle 11.5.10 version
5. Re-start the PowerCenter server (Informatica Service).