Depot Repair: Generic Datafix for Synchronizing Logistics Line Status with Order Line Status
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.
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