After header data in OE_HEADERS_IFACE_ALL is deleted, orphan data left in the interface table OE_LINES_IFACE_ALL.
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.
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
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