Release 12.2.2 Customer Merge Inconsistency Between Customer User Interface and OE_Hold_Sources_All Table
Last updated on JANUARY 19, 2018
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
*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
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms