How To Rectify QUANTITY_RECEIVED Stamped With Negative Quantity In RCV_SHIPMENT_LINES table?
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.
How to rectify QUANTITY_RECEIVED stamped with negative quantity IN RCV_SHIPMENT_LINES table ?
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.
SHIPMENT_LINE_STATUS_CODE PARTIALLY RECEIVED
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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms