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.
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.
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.
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
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