OEOIMP Unable To Create New Customer With Same Address As Existing Customers (Doc ID 736684.1)

Last updated on APRIL 04, 2025

Applies to:

Symptoms

On 12.0.4 in Production:
When importing orders from a custom Web store into Oracle Order Management, the order import interface is used to create customers on the fly if the customer does not exist. This is standard functionality. If the customer exists, then the Web is passing the customer id and the site id so that Oracle will know the customer to be used on the order.

The problem occurs during the import when trying to import orders for new customers that have the same address as existing customers (such as spouses, children or parents); the order import fails with the message that the address is a duplicate address. This is incorrect since the address is for a totally different customer.

ERROR:
L_MSG_DATA=3DNew Customer added for reference TESTING_SOLD_TO_IMPORT95
Order Number : Line Number :
Message :New Customer added for reference TESTING_SOLD_TO_IMPORT95
L_MSG_DATA=3DDuplicate SHIP_TO ADDRESS found for =
TESTING_SHIP_ADDRESS_IMPORT95. Please correct the data.
Order Number : Line Number :
Message :Duplicate SHIP_TO ADDRESS found for =
TESTING_SHIP_ADDRESS_IMPORT95. Please correct the data.
L_MSG_DATA=3DDuplicate BILL_TO ADDRESS found for =
TESTING_SOLD_TO_ADDRESS_IMPORT95. Please correct the data.
Order Number : Line Number :
Message :Duplicate BILL_TO ADDRESS found for =
TESTING_SOLD_TO_ADDRESS_IMPORT95. Please correct the data.

STEPS
The issue can be reproduced at will with the following steps:
1. Populate the order import interface with customer data such that the customer does not already
exist, but the address data exists for another customer.

Changes

Cause

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