My Oracle Support Banner

Unable To Merge Customer - APP-AR-11109 Location Already Exists for This Business Purpose and Customer or APP-AR-11147: Every from Site Does Not Have a Corresponding to Site (Doc ID 1663834.1)

Last updated on JULY 10, 2020

Applies to:

Oracle Trading Community - Version and later
Oracle Receivables - Version and later
Information in this document applies to any platform.


Unable to merge Customer (Example: CRCAM TEST CUST 7995 to CRCAM PROD CUST 8043).  Receive the following error:

APP-AR-11109 Location already exists for this business purpose and customer.

The diagnostics show there are 356 rows in HZ_LOCATIONS for Acct#7995 and Acct#8043 have the same 356 locations.

Suggested merging these customer with the "Create Same Site for All Addresses" option unchecked and receive the following error:

APP-AR-11147: Every From site does not have a corresponding To site




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
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps

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