Collected On Hand Qty different than the one from the Source
Last updated on JUNE 28, 2017
Applies to:Oracle Advanced Supply Chain Planning - Version 12.1.3 and later
Information in this document applies to any platform.
ASCP Collected On Hand Qty different than the one from the Source .
The on hand quantities in both tables ( base and SN ) do not match. As per the investigation , the root cause is in the database functionality not working, the SN should be updated with the changes found in the MLOG.
-the TRANSACTION_QUANTITY value (snapshot MTL_OH_QTYS_SN ) does not match the PRIMARY_TRANSACTION_QUANTITY value (base table MTL_ONHAND_QUANTITIES_DETAIL)
In order to have the up-to-date data of the on-hand in the SN :
- Run a 'COMPLETE' RCS on MTL_OH_QTYS_SN , thus getting the data straight from the base table and truncating the mlog to have a count of 0.
- Run 'COMPLETE' Collections
On hand qty to be updated correctly in the MTL_OH_QTYS_SN
- FAST 'Refresh Collection Snapshots' on the snapshot 'MTL_OH_QTYS_SN' , this SN is not updated with the changes ( NOTE : issue occurs only when removing qty , when adding it worked fine ) from the base table 'MTL_ONHAND_QUANTITIES_DETAIL'.
- this changes are being tracked OK in the MLOG$_MTL_ONHAND_QUANTITIE and the SN should get updated based on this.
The issue has the following business impact:
Due to this issue, users cannot use the correct value of the on-hand in planning , thus leading to new PLO generated.
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