Order Import Error: You Are Entering A Duplicate Orig_sys_line_ref For The Same Order
Last updated on JUNE 23, 2017
Applies to:Oracle Order Management - Version 12.1.1 and later
Information in this document applies to any platform.
On : 12.1.1 version, Transaction Entry
When attempting to import orders with same PO, the following error occurs.
You are entering a duplicate orig_sys_line_ref for the same order
The application UI allows you to enter the same PO for the different customer with a warning but when the order import Program runs it fails with error (You are entering a duplicate orig_sys_line_ref for the same order)
Note: Support noticed from the output, we see you are inputting 1 for ORIG_SYS_LINE_REF on the OE_LINES_IFACE_ALL table, and had customer iinput 2 for the second record and run import again. They are able to update to 2 and run but that is not the process they are looking for, because the data will be coming from EDI without any manual intervention it get inserted into IFACE, we tend to get the same PO# multiple times so when it inserts into IFACE table it will insert into ORIG_SYS_LINE_REF as 1 multiple times.
Is there a way to help the customer with their requirement?
The issue can be reproduced at will with the following steps:
1. Responsibility: Order Management Super User
2. Navigate: Order Import
3. Import duplicate PO and receive error.
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