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

Last updated on MARCH 08, 2017

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.


Cause

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