My Oracle Support Banner

Orphan Records Are In Oe_lines_iface_all And Unable To Query It In The OI Correction Form (Doc ID 1391902.1)

Last updated on DECEMBER 12, 2023

Applies to:

Oracle Order Management - Version 11.5.10.2 to 12.2 [Release 11.5.10 to 12.2]
Oracle Purchasing - Version 11.5.10.2 to 12.2 [Release 11.5 to 12.2]
Information in this document applies to any platform.


Symptoms

ACTUAL BEHAVIOR

There are records in the OE_LINES_IFACE_ALL table that can't be seen from the Import Corrections form.


EXPECTED BEHAVIOR

Expect all lines in Order Management interface table should be visible in the corrections form.

STEPS
1. Go to SQL Developer or equivalent tool to query data from database
2. Query data from OE_LINES_IFACE_ALL and get the Orig_sys_header_ref
3. Try to query the same data from Corrections form, going to Order Management responsibility>Orders, Returns>Import Orders>Corrections
4. Query by Orig_sys_header_ref noted from step2 and no data is returned

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.