Stock Order Reconcile is Generating More Adjustments than Required

(Doc ID 2223591.1)

Last updated on APRIL 09, 2017

Applies to:

Oracle Retail Merchandising System - Version 14.1 to 14.1.2 [Release 14.1]
Information in this document applies to any platform.


When a shipment has multiple cartons for the same item and distro number, the STOCK_ORDER_RECONCILE_SQL.APPLY_ADJUSTMENTS_DOC_CLOSE generates one Tran Code 22 for each line using all the lost quantity.

Steps To Recreate:

  1. Create an allocation for one item.
  2. Ship the item using multiple cartons.
  3. Add the allocation to the DOC_CLOSE_QUEUE.
  4. Run DOCCLOSE batch
  5. Notice the ITEM_LOC_SOH.IN_TRANSIT_QTY with negative status and with multiple Tran code 22 logged for the same item.




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