My Oracle Support Banner

Order Import Error: You Are Entering A Duplicate Orig_sys_line_ref For The Same Order (Doc ID 1358701.1)

Last updated on JUNE 21, 2023

Applies to:

Oracle Order Management - Version 12.1.1 and later
Information in this document applies to any platform.
Order Import
Duplicate Orig_sys_line_ref
Purchase Order


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.




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.