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:
- Create an allocation for one item.
- Ship the item using multiple cartons.
- Add the allocation to the DOC_CLOSE_QUEUE.
- Run DOCCLOSE batch
- 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