Depot Repair Order Logistics Lines Show Order Number But Order Lines Do Not Exist

(Doc ID 456714.1)

Last updated on NOVEMBER 14, 2017

Applies to:

Oracle Depot Repair - Version 11.5.10.2 to 11.5.10.2 [Release 11.5]
Information in this document applies to any platform.
FORM:CSDREPLN.FMB - Repairs


Symptoms

Repair Order Logistics lines have a status of 'ENTERED' and an order number stamped on them, but in Order Management the lines are not visible on the Sales Order number stated and the Repair line cannot be processed futher nor can they be resubmitted to Order Management.

The following queries can be used to identify the Logistics lines with the issue:

To identify the data corruption in LOGISTIC lines :

select * from csd_product_txns_v
where order_header_id is not null
and order_line_id is null

Verify that repair number(s) returned by above query has the data corruption in the logistic line. To
verify this open the repair order returned by above query in DWB and see if some product line in
logistic tab has the order number populated but does not have the corresponding order line in sales order.

To identify the data corruption in ACTUAL lines:

select * from csd_repair_actual_lines_v
where order_header_id is not null
and order_line_id is null;

Verify that the Repair number(s) returned by above query has the data corruption in the Actual line. To verify this open the Repair Order returned by above query in the Depot Repair WorkBench and see if the Actual line in Actuals tab has the Order number populated, but does not have the corresponding Order ine in the Sales Order.

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