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 MARCH 06, 2019

Applies to:

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

Symptoms

ACTUAL BEHAVIOR
---------------
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.

EXPECTED BEHAVIOR
-----------------------
Expect the last_update_date be updated on the date the shipment was received

STEPS
-----------------------
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: <USER>
Creation Date: <CREATION DATE>
Table Name: RCV_MSL_V
Updated By: <USER>
Update Date: <CREATION DATE>

4. As per RCV_TRANSACTIONS table in file rcv_transactions.xlsx

shipment_line_id = <SHIPMENT LINE ID>
transaction_id = <TXN1>
Transaction type = RECEIVE
CREATION_DATE = <RECEIVE TXN DATE>
LAST_UPDATE_DATE = <RECEIVE TXN DATE>

shipment_line_id = <SHIPMENT LINE ID>
transaction_id = <TXN2>
Transaction type = DELIVER
CREATION_DATE = <DELIVER TXN DATE>
LAST_UPDATE_DATE = <DELIVER TXN DATE>

If the receive transactions were done after creation of RCV_SHIPMENT_LINES, 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.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.