Shipped Quantity Not Matching With AR Invoiced Quantity
(Doc ID 1505038.1)
Last updated on MARCH 22, 2021
Applies to:
Oracle Shipping Execution - Version 11.5.10.CU1 to 12.1.3 [Release 11.5.10 to 12.1]Oracle Order Management - Version 11.5.10.1 to 12.1.3 [Release 11.5.10 to 12.1]
Information in this document applies to any platform.
Symptoms
On : 12.1.1 version, Ship Confirm
ACTUAL BEHAVIOR
---------------
There is a difference in the Shipped Quantity(qty) displayed on Shipping Transaction Form under Lines/LPN tab and that of
AR invoice - Quantity field. For eg. shipped quantity shows 31.86 and on AR invoice it shows 32.
Based on the HTMomse12 order output, the table OE_ORDER_LINES (LIN) shows:
- Order Qty = 32
- Shipping Qty = 31.86
- Shipped Qty = 32
- Invoiced Qty = 32
In the table WSH_DELIVERY_DETAILS (DET), the picked and shipped qty is 31.86 UOM = TON with 0.14 qty as 'Cancelled'.
MTL_MATERIAL_TRANSACTIONS (TRN) - PICKED LINES
Inventory issue with qty 31.86 , 'Staging Transfer' for qty as 32.
EXPECTED BEHAVIOR
-----------------------
There should not be a discrepancy in the quantity invoiced.
Changes
Cause
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
Symptoms |
Changes |
Cause |
Solution |
References |