After header data in OE_HEADERS_IFACE_ALL is deleted, orphan data left in the interface table OE_LINES_IFACE_ALL.

(Doc ID 1466633.1)

Last updated on OCTOBER 03, 2017

Applies to:

Oracle Order Management - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.
*** Checked for relevance on 03-Oct-2017 ***

Symptoms

ACTUAL BEHAVIOR

After header is deleted, orphan data left in sales order line interface tables oe_lines_iface_all and oe_credits_iface_all.

Users cannot find and delete these orphan data through

Order Management (OM) -> Order,Returns -> Import Orders -> Corrections because its unique index in oe_lines_iface_all.
 

EXPECTED BEHAVIOR

After header is deleted, orphan data should not be left in ont.oe_lines_iface_all table and it's same to ont.oe_credits_iface_all table.

STEPS

1.  Go to Order Management Responsibility -> Orders,Returns -> Import Orders -> Correction Window
2.  Delete the order header by clicking on Delete button
3.  Find the orphan oe_lines_iface_all data

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