My Oracle Support Banner

Release 12.2.2 Customer Merge Inconsistency Between Customer User Interface and OE_Hold_Sources_All Table (Doc ID 2113004.1)

Last updated on MARCH 28, 2019

Applies to:

Oracle Order Management - Version 12.2.2 and later
Information in this document applies to any platform.


On : 12.2.4 version, Customer Usage

As per referenced <Note 1377743.1> , the explanation provided for Transfer vs Merge
Scenarios. I need clarification on an issue for which a fix was suggested to be
available as part of 12.2 baseline

Note Indicates:
*Consistency in Display of Credit Hold Flag after Customer Merge
Currently, when customers are merged, the target customer inherits credit holds from
merged customers at the Account and Bill-To site levels. Although Order Management
continues to apply holds for the target customer that are inherited from the merged
customers, the credit hold flag for inherited credit holds is not displayed as selected
 when viewed in customer detail. In Release 12.2., this inconsistency has been
addressed and inherited credit holds will be displayed as selected in the customer
detail screen.
Basically what seems to happen in the background is below.
When an account is placed it on hold, there was a record created in OE_HOLD_SOURCES_ALL
table having the HOLD_ENTITY_ID as SITE_USE_ID. When we merge the account, the record
in OE_HOLD_SOURCES_ALL will get updated with the new account id which is causing the
orders to be placed on hold .

When merging accounts, surprised to see the records being updated with a new account_id.

1) Responsibility : Order Management Super User
2) Merge Customer ABC and Customer 123
3) Customer ABC > Credit Hold check box is checked at customer level as well as Bill To Site level
4) Customer 123 > No Profile created for Bill 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

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