My Oracle Support Banner

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 JANUARY 04, 2021

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.