My Oracle Support Banner

Last_update_by Columns Are Not Updated In RCV_SHIPMENT_LINES Table When Receiving Intransit Shipments (Doc ID 2424385.1)

Last updated on JULY 20, 2018

Applies to:

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


In Manage Shipments form or RCV_SHIPMENT_LINES table, time stamp (last_update_date) would not update upon receipt of the Intransit Shipment
Although other fields , like status are been updated (i.e. from Partially received to Fully received) upon receiving but the Last update date field do not.

Expect the last_update_date be updated on the date the shipment was received

The issue can be reproduced at will with the following steps:
1. Navigate to Manage Shipments form and query by the Intransit Shipment Number
2. Select the Shipment line and Go to Help menu to view the record History
3. It shows the following - example

Created By: TPLDE
Creation Date: 18-APR-2018
Table Name: RCV_MSL_V
Updated By: TPLDE
Update Date: 18-APR-2018

4. As per RCV_TRANSACTIONS table in file rcv_transactions.xlsx

shipment_line_id = 10056714
transaction_id = 10626310
Transaction type = RECEIVE
CREATION_DATE = 16-May-18 16:13:15
LAST_UPDATE_DATE = 16-May-18 16:13:15

shipment_line_id = 10056714
transaction_id = 10626311
Transaction type = DELIVER
CREATION_DATE = 16-May-18 16:13:15
LAST_UPDATE_DATE = 16-May-18 16:13:15

If the receive transactions were done on 16th May, then the status of the shipment lines change from EXPECTED to FULLY Received and hence the last_update_ date on the rcv_shipment_lines table should have changed.


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.