TRANSFERRED_TO_OE_FLAG Not Set To Y After Running Create Internal Orders

(Doc ID 1595200.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

On : 12.1.3 version, Transaction Entry

When attempting to import the internal requisition into order management using the Order Import concurrent process the following error occurs.

Error:
Message :You are entering a duplicate orig_sys_line_ref for the same order.
L_MSG_DATA=You are entering a duplicate orig_sys_line_ref for the same order.
Order Number : Line Number :
Message :You are entering a duplicate orig_sys_line_ref for the same order.
L_MSG_DATA=You are trying to insert an existing order or update an order that does not exist. Please enter a correct operation code.

Replication Steps:
1. Create the internal requisition and approve.
2. Engage the Create Internal Orders process.
3. Data is moved into the oe_headers_iface_all table and oe_lines_iface_all table.
 - Requisition Header and Line Level are not updated so that the transferred_to_oe_flag is set to Y.



Cause

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