Customer Merges Ending In Error, Merge-From customer Site Did not have Usage
(Doc ID 1573454.1)
Last updated on SEPTEMBER 22, 2023
Applies to:
Oracle Shipping Execution - Version 12.0.0 and laterOracle Order Management - Version 12.0.0 and later
Oracle Trading Community - Version 12.0.1 and later
Information in this document applies to any platform.
Symptoms
When attempting to merge two customers into a single customer account using the Merge Customers program,
the following error occurs.
ERROR
-----------------------
P_SITE_ID ==> -99
Call Get_Location_id
Entering WSH_UTIL_CORE.GET_LOCATION_ID (WSHUTCOB.pls 120.13.12000000.10) (04/05/2013 03:24:31 AM)
P_MODE ==> CUSTOMER SITE
P_SOURCE_ID ==> -99
p_transfer_location ==> TRUE
Entering WSH_UTIL_CORE.ADD_MESSAGE (WSHUTCOB.pls 120.13.12000000.10) (04/05/2013 03:24:31 AM)
P_MESSAGE_TYPE ==> E
P_MODULE_NAME ==> wsh.plsql.WSH_UTIL_CORE.GET_LOCATION_ID
msg_buffer ==> There is no location set up for the Ship To or Deliver To site.
E:There is no location set up for the Ship To or Deliver To site.
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run the Merge Customers program to merge the accounts of two different customers.
2. Merge program ends in error
3. Review the log file, see the above error
BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot merge these two customer accounts.
Cause
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
Symptoms |
Cause |
Solution |
References |