Analytics Software

Since I was hijacking user007's thread, I thought I would create my own.

Has anyone successfully loaded BOM Items in OBIA 7.9.5?

The steps from the Installation and Configuration Guide Section 10.2.2.10 do not work because pmserver.cfg does not exist on Informatica 8.1.1 on Windows or Linux.

10.2.2.10 How to Configure the Bill of Materials Explosion
http://download.oracle.com/docs/cd/E12127_01/doc/bia.795/e12083/anyimp_enterprisesales.htm#CACHHAJF

I tried setting Custom Properties ShareConnections_SDE_ORAR12_Adaptor.SDE_ORA_BOMItemFact=Yes for both the Integration Service and the Oracle_BI_DW_Base Repository Service, but

1.3.31 No Data Is Loaded Into W_BOM_ITEM_F And W_BOM_ITEM_FS
http://download.oracle.com/docs/cd/E12127_01/doc/bia.795/e12087/chapter.htm#CHDFJHHB

The mapping SDE_ORA_BOMItemFact needs to call a Stored Procedure (SP) in the Oracle EBS instance, which inserts rows into a global temporary table (duration SYS$SESSION, that is, the data will be lost if the session is closed). This Stored Procedure does not have an explicit commit. The Stored Procedure then needs to read the rows in the temporary table into the warehouse.

In order for the mapping to work, Informatica needs to share the same connection for the SP and the SQL qualifier during ETL.This feature was available in the Informatica 7.X release, but it is not available in the Informatica release 8.1.1 (SP4). As a result, W_BOM_ITEM_FS and W_BOM_ITEM_F are not loaded properly.

Workaround

For all Oracle EBS customers:

1. Open package body bompexpl.
2. Look for text "END exploder_userexit;", scroll a few lines above, and add a "commit;" command before "EXCEPTION".
3. Save and compile the package.

Does anyone have rows in W_BOM_ITEM_FS after an OBIA 7.9.5 ETL? If so, how did you get it working.

Thanks,
-Michael