My Oracle Support Banner

"Location Already Exists for This Business Purpose and Customer" While Importing Sales Orders. (Doc ID 2119950.1)

Last updated on OCTOBER 02, 2023

Applies to:

Oracle Order Management - Version 12.1.3 to 12.2 [Release 12.1 to 12.2]
Information in this document applies to any platform.


When attempting to import order (EDI or otherwise) with a customer ship_to address from an existing location -
the following error occurs.


"Location already exists for this business purpose and customer"

The issue occurs when you passed an existing ship to location value to field 'ORIG_SHIP_ADDRESS_REF' in OE_HEADERS_IFACE_ALL, and related data to interface table 'OE_CUSTOMER_INFO_IFACE_ALL'.


1. Order Management Super User responsibility
2. Run Order Import concurrent program


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.