OEOIMP: For An Internal Requisition With Multiple Deliver To Locations Order Import Errors with "You Are Trying to Insert an Existing Order or Update an Order That Does Not Exist." (Doc ID 2235690.1)

Last updated on MAY 23, 2023

Applies to:

Symptoms

When an internal requisition is created with multiples lines, and each line has a deliver to location that is tied to the same customer but for different addresses,  "Order Import" errors with the following:


Error

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"
10. Query on the Order Lines data and find that there is an orphaned record

Changes

Release 12:
Patch 12576879:R12.PO.B - INTERNAL SALES ORDER ARE NOT CREATED CORRECTLY FROM MULTIPLE INTERNAL REQUISITIO , is applied
POXCISOB.pls 120.5.12010000.11.

Release 11i:
Patch 8692047 - This patch resolves the issue of isolated so header is created if deliver-to is same customer, different address , is applied
POXCISOB.pls 115.21.11510.15

Cause

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