Collected On Hand Qty different than the one from the Source (Doc ID 2056571.1)

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.

Symptoms

ISSUE

ASCP Collected On Hand Qty different than the one from the Source .


ACTUAL BEHAVIOR 

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)

 

WORKAROUND
In order to have the up-to-date data of the on-hand in the SN :

  1. 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.
  2. Run 'COMPLETE' Collections

 

EXPECTED BEHAVIOR

On hand qty to be updated correctly in the MTL_OH_QTYS_SN

 

STEPS

  1. 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'.
  2. this changes are being tracked OK in the MLOG$_MTL_ONHAND_QUANTITIE and the SN should get updated based on this.



BUSINESS IMPACT

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.

 

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