OBIA 7.9.6.4: Issue With SIL_InventoryProductDimension_SCDUpdate (Doc ID 2289718.1)

Last updated on AUGUST 11, 2017

Applies to:

Business Intelligence Applications Consumer - Version 7.9.6.4 and later
Information in this document applies to any platform.
Source: Oracle EBS R12.2.3 ;

Symptoms

Issue with data load process for W_INVENTORY_PRODUCT_D .

With SCD Flag as Y , multiple versions of records got created . The expectation is at least one record ( latest record ) to get marked as effective_to_date as 01-JAN-3714 and Current Flag equals 'Y . However , this is not happening and Effective to date is getting populated same as effective from date due to  incorrect effective date the fact records are getting populated the inventory product_wid with Zero.

The following steps taken to narrow down the issue :
1) SIL_INVENTORYPRODUCTDIMENSION_SCDUPDATE has an issue, not updating the Effective_from_dt and Effective_to_dt
2) Export the following workflows from the repository manager and provide the
XML
SDE_ORA_InventoryProductDimension
SDE_ORA_InventoryProductDimension_Full
SIL_InventoryProductDimension
SIL_InventoryProductDimension_Full
SIL_InventoryProductDimension_SCDUpdate
SIL_InventoryProductDimension_SCDUpdate_Full

3) EXPORT the data dump for the folloing tables so that we can import the
same and test.
W_ORA_INVPROD_DS_TMP
W_ORA_ITEM_CATEGORY_TMP
W_INVENTORY_PRODUCT_DS
W_INVENTORY_PRODUCT_D

4) Executed one iteration of SIL_InventoryProductDimension_SCDUpdate with verbose mode to verify where the data issue causing.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms