Duplicate Records in Sales Order Interface for Internal Orders
(Doc ID 1595200.1)
Last updated on AUGUST 05, 2024
Applies to:
Oracle Order Management - Version 12.1.3 and laterOracle Purchasing - Version 12.1.3 and later
Information in this document applies to any platform.
Symptoms
When attempting to import the internal sales order into order management using the Order Import concurrent process the following error occurs.
Error
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.
Steps
1. Go to Purchasing Responsibility >Requisitions>Requisitions
2. Create the internal requisition and approve.
3. Go to View>Requests>Submit a New Request>Select “Create Internal Orders” and Submit
4. Go to Order Management Responsibility >Orders, Returns>Import Orders>Corrections
5. Query the data in Order Management Interface tables by entring Order source as Internal and Order Reference as Internal Requisition number
6. Notice that data exists in oe_headers_iface_all table and oe_lines_iface_all table.
7. Go to Purchasing Responsibility and Run “Create Internal Orders” Program again
8. Go to Order Management responsibility and follow same steps as above and notice duplicate data is inserted into Order Management interface tables
Cause
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
| Symptoms |
| Cause |
| Solution |
| References |