Order Management Is Not Inserting Appended Order Lines From EDI Source Order To OE_LINE_ACKS Table (Doc ID 2642282.1)

Last updated on FEBRUARY 23, 2022

Applies to:

Goal

Order Management is not inserting appended/new order lines from EDI source order to the OE_LINE_ACKS table.

Business scenario is an external sales order validation process in place that takes the EDI 850 transactions and will process them for any errors and/or additions.  For example, if the customer PO has 5 lines and 4 of those lines are validated and loaded,  those 4 lines will be inserted into the OE_LINE_ACKS file as expected, which is normal.  However, once the 5th line is corrected in the external validation system,  the Order Import process will append that line to the existing sales order where  the other 4 lines are.   It is noticed that there is no insertion for the 5th line (or any subsequently appended lines to any order) into the OE_LINE_ACKS table.  

The expectation is that all lines (even the APPENDED EDI order source lines) should create a record in the OE_LINE_ACKS table and be visible in the POAO/855 when it is run again after the appended lines are added to the order.

Why is there no record in the OE_LINE_ACKS table for newly appended lines on an existing sales order?

Solution

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