My Oracle Support Banner

Shipped Quantity Not Matching With AR Invoiced Quantity (Doc ID 1505038.1)

Last updated on JUNE 13, 2018

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 to 12.1.3 [Release 11.5.10 to 12.1]
Information in this document applies to any platform.


On : 12.1.1 version, Ship Confirm

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'.

Inventory issue with qty 31.86 , 'Staging Transfer' for qty as 32.

There should not be a discrepancy in the quantity invoiced.


To view full details, 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 a vibrant support community of peers and Oracle experts.