Order Lines Are Present In Table OE_LINES_IFACE_ALL But Do Not Show In The Order Correction Form (Doc ID 2866523.1)

Last updated on MARCH 03, 2025

Applies to:

Symptoms

While trying to import sales order through Order Import program, it was found that before running Order Import, sales order header and lines are showing in oe_headers_iface_all  and oe_lines_iface_all table without any error but the same order when tried to check from 'Correction' form under Order management responsibility , only the header details are visible but not the lines.

The issue can be reproduced by below steps:

A. Verify data in interface table

From SQL Developer or any other equivalent tool, run the following queries and confirm that the data exists in both headers and  lines  interface tables

1. SELECT * FROM oe_headers_iface_all where orig_sys_document_ref = 'XXXXXX';

2. SELECT * FROM oe_lines_iface_all where orig_sys_document_ref = 'XXXXXX';

B. Verify data from Corrections form

1. Go to Order Management Responsibility
2. Navigate to Orders,Returns>Import Orders> Corrections
3. Query the data by Order Reference  = orig_sys_document_ref  that is 'XXXXXX' ( same as in above SQL queries)
4. Notice that Sales Order Header details are visible
5. Select the header record an click on Lines button
6. Notice that no records are displayed

Cause

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