Customer Merge (RAXMRG) Has Poor Performance Issues When Merging One Customer - Issue Occurs When Querying MTL_UNIT_TRANSACTIONS

(Doc ID 1519942.1)

Last updated on JUNE 08, 2016

Applies to:

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

Symptoms

Attempting to run Customer Merge (RAXMRG) for one customer and it completes successfully in 0:14:49

The process should complete in < 2 minutes for 1 merge.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Customer Merge is executed multiple times (up to 100+) per day. End users must wait for the merge to complete before continuing. This is highly inefficient.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms