Internal Requisition With Multiple Deliver To Locatons Fails To Import With Error "You Are Trying To Insert An Existing Order" (Doc ID 1280075.1)

Last updated on APRIL 04, 2025

Applies to:

Symptoms

When an internal requisition is created that is having multiples lines, and each line has a deliver
to location that is tied to the same customer but for different addresses, only one
header record is being populated into the Order Management Interface tables. But mulitple
are required as multiple sales orders are needed to accommodate each deliver-to-location/customer association.

ERROR:
You are trying to insert an existing order or update an order that does not exist. Please enter a correct operation code.

Steps To Reproduce:
1. Create two locations used as Internal Location
2. Using Purchasing responsibility navigate to Setup->Organizations->Locations
3. Setup  Location 1 and Location 2
4. Create a single customer with two addresses
- Address 1 - Ship To - tied to Location 1
- Address 2 - Ship To - tied to Location 2
5. Create an internal Reqisition - having two lines - referencing the two locations
- Line 1 - Location 1
- Line 2 - Location 2
6. Execute the Create Internal Orders
7. Execute the Import Orders process in Order Management.
8. Navigate to Order Management - Order Import ->Corrections
9 Can see error in report details "You are trying to insert an existing order"
9. Query on the Order Lines data and find that there is an orphaned record

Cause

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