Hi Frnds,
I have a query regarding DAC - Subject Area: 'Supply Chain - BOM Items'. Details are:
Source: Oracle EBS R12.1.3
BI Apps v7.9.6.3
As per config guide '6.2.2.12 How to Deploy Objects in Oracle EBS for Exploding the BOM', we applied patch 10422612:R12.OPI.B which includes package OPI_OBIA_BOMPEXPL_WRAPPER_PKG in apps schema. And also, I restricted the records using filter for Inventory Organization to limit it to < 100,000.
After all these settings, the WF SDE_ORA_BOMItemFact -> Session SDE_ORA_BOM_Explosion was running for more than 18 hrs but then also the session log was stucked at 'Message: Stored procedure [OPI_OBIA_BOMPEXPL_WRAPPER_PKG_OBIA_SP_CALL1] uses database connection [ORA_R1213] in code page [UTF-8 encoding of Unicode]'
Then while searching for the similar issue I found another patch 12903772:R12.OPI.B includes package OPI_OBIA_BOMPEXPL_WRAPPER_P. So it requires updating the mapping to point to new package. This package was having an issue with TEMP table synonym OBIA_BOM_EXPLOSION_TEMP, which I fixed.The description of the patch says:
===========
This package has procedure OBIA_SP_CALL which uses hierarchical query using
CONNECT BY to explode the all BOMs. So it will explode all the BOM at a time
and results are stored in temporary table BOM_EXPLOSION_TEMP on source.
Note that, this procedure needs lot of temp space on source side.
===========
But with this patch as well, there is no luck. Again it is running for hrs with same old message in session log.
Just wanna check if anyone faced similar issues while exploding BOM and what was the solution applied ?
Any pointers will be of great help.
Cheers,
Deepak