Repair Order Logistics Line Status Is Not Refreshed

(Doc ID 2021190.1)

Last updated on NOVEMBER 18, 2016

Applies to:

Oracle Depot Repair - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

Repair Order Logistics Line is in 'Booked' status, even after receiving the material in the Subinventory.
Refresh Logistics is done but the status is not getting refreshed.

- The Return line is 'Booked' Status.
- The Order is available.

(R) Depot Repair
(N) Repair Order > Workbench

Query SR and Repair Order
 - Item = 101010 - Test Item
 - RO Status = Open

Logistics tab:
 Line 1 = Return
   . Order  = 180000
   . Status = Booked
   . Item   = 101010
   . Qty    = -1

 Line 2 = Ship
   . Order  = 180000
   . Status = Booked
   . Item   = 101010
   . Qty    = 1

=> Return Line  is still in BOOKED and not in RECEIVED status.

Checked on Inventory Transactions and could find that Receipt of this item into corresponding sub inventory has been successful.
But the Installed Base has not been updated.

Expected Behavior

Status should be updated to "Received" as the material is already in the Subinventory.

Error

While checking the Installed Base Transaction Error Processing window, the following error message was found:

   Invalid value for the column TERMINATION_REASON.
   Program Error: An unexpected error was encountered.
   Error code - 1
   Error message - User-Defined ExceptionAction: Contact your system administrator.

Steps

1. Enter a Repair Order for an Item with serial control at Sales Order Issue
2. If no Reference is provided, system prompts for registering new instance
3. Click 'Yes'
4. Instance created without Serial Number
5. Select the RMA line and receive the item by entering a serial number
6. After receiving the item, RMA line gets updated with the new Instance.

=> The old instance gets expired.

Here the issue occurs if the Contract is associated with the previous created Item Instance.
Termination Reason code is missing.

Business Impact

Repair Order can not progressed further in Production.

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