Depot Repair: Generic Datafix for Synchronizing Logistics Line Status with Order Line Status
(Doc ID 2015555.1)
Last updated on FEBRUARY 14, 2018
Applies to:Oracle Depot Repair - Version 12.1.3 and later
Information in this document applies to any platform.
Each Depot Repair Logistics line includes a 'status' . Under normal circumstances it would be expected that that the Repair Order (RO) Logistics line status will be 'in synch' with the associated Sales Order (SO) Line, but occasionally the two statuses do not match, and it is necessary to use either the Refresh Logistics button  on the Repair Workbench, or to run the ‘Depot Repair Receipt Update’ / ‘Depot Repair Shipment Update’ concurrent programs.
This refresh process does not always update the logistics line status as expected. For example, the RO Logistics line stays in 'Entered' status while the SO line is already 'Booked'; or a RO Shipment line stays in 'Booked' status while the SO line is already 'Closed'.
When that is the case, a datafix is required to bring the logistics line in synch with the SO line.
This Note provides a script which can fix certain status mis-matches.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!