My Oracle Support Banner

Stock Order Reconcile Generates More Adjustments Than Required (Doc ID 2223591.1)

Last updated on APRIL 16, 2020

Applies to:

Oracle Retail Merchandising System - Version 14.1 to 14.1.3 [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 Transaction Code (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 in_transit_qty of ITEM_LOC_SOH table with negative status and with multiple tran_code 22 logged for the same item.




To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.