OBIA 22.214.171.124: Issue With SIL_InventoryProductDimension_SCDUpdate
Last updated on AUGUST 11, 2017
Applies to:Business Intelligence Applications Consumer - Version 126.96.36.199 and later
Information in this document applies to any platform.
Source: Oracle EBS R12.2.3 ;
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
3) EXPORT the data dump for the folloing tables so that we can import the
same and test.
4) Executed one iteration of SIL_InventoryProductDimension_SCDUpdate with verbose mode to verify where the data issue causing.
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