Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

BOM Fact Soft Delete

2773003Jun 25 2015

We are in 7.9.6.3 and would like to soft delete BOM Item fact records. I can see that Oracle provided two seeded tasks for this purpose:

SIL_BOMItemFact_IdentifyDelete (sources data from W_BOM_ITEM_F_PE and W_BOM_ITEM_F)
SIL_BOMItemFact_SoftDelete (sources data from W_BOM_ITEM_F_DEL and W_PARAM_G)

The problem I have is that I am not able to find the way that Oracle is populating W_BOM_ITEM_F_PE (In DAC this table is not a target for any tasks, in other words the task _Primary is missing), without this the soft delete process will not work.

Any suggestions will be appreciated.

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 23 2015

Added on Jun 25 2015

#business-intelligence-applications

0 comments

419 views