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

Last updated on JULY 11, 2017

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.
*** Checked for relevance on 11-Jul-2017 ***

Symptoms


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

ERROR

"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'.


STEPS

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



Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms