Customer Merge (RAXMRG) Has Poor Performance Issues When Merging One Customer - Issue Occurs When Querying MTL_UNIT_TRANSACTIONS
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.
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.
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.
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