How To Rectify QUANTITY_RECEIVED Stamped With Negative Quantity In RCV_SHIPMENT_LINES table? (Doc ID 2239715.1)

Last updated on MARCH 03, 2017

Applies to:

Oracle Inventory Management - Version 12.1.3 and later
Information in this document applies to any platform.

Goal

How to rectify QUANTITY_RECEIVED stamped with negative quantity IN RCV_SHIPMENT_LINES table ?

CAUSE

The user received the quantity 439 Each and then performed a negative correction for full quantity i.e -439 Each which did not somehow shown correctly in the system.
Observing that, user performed an another negative correction for quantity -439 Each which resulted in showing the column QUANTITY_RECEIVED stamped with negative quantity IN RCV_SHIPMENT_LINES table.

RCV_SHIPMENT_LINES
SHIPMENT_LINE_ID                            1237775
SHIPMENT_HEADER_ID                      1406017
QUANTITY_SHIPPED                           439
QUANTITY_RECEIVED                       -439
SHIPMENT_LINE_STATUS_CODE       PARTIALLY RECEIVED

RCV_TRANSACTIONS
TRANSACTION_ID    PARENT_TRANSACTION_ID   TRANSACTION_TYPE      QUANTITY       SHIPMENT_LINE_ID
1401400                   -1                                            RECEIVE                          439                 1237775
1401401                   1401400                                 CORRECT                        -439                 1237775
1401402                   1401400                                 CORRECT                        -439                 1237775

 

Solution

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