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 JUNE 28, 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.

Symptoms

On : 12.1.3 version, Transaction Fulfillment

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

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
-----------------------
The issue can be reproduced at will with the following steps:
1.  Go to Order Management -> Orders,Returns -> Import Orders>Correction
2.  Delete the order header by clicking on Delete button
3.  Find the orphan oe_lines_iface_all data

Changes

 

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