My Oracle Support Banner

Order Lines Showing In OE_LINES_IFACE_ALL Table But Not In Order Correction Form (Doc ID 2866523.1)

Last updated on MAY 03, 2022

Applies to:

Oracle Order Management - Version 12 and later
Information in this document applies to any platform.



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.



Expect to see header and line details when queried from 'Correction' form



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





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

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