Performance Issues With Account Merge (RAXMRG)

(Doc ID 2226436.1)

Last updated on JANUARY 25, 2017

Applies to:

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

Symptoms

Per Bug 23168607


As per the output from merge tables in ra_queries_output.zip, Labcorp merge
is completed successfully.

Even from trace file , its clear that merge is completed successfully.

Venkata.segu 2016.10.05 4:23 AM ***
  Issue exists only for few customer with lot of sites and the customer merge
request priority doesn't matter.

As per customer , customer merge requests with both P1 and P3 are scheduled
well for small merges.

This could be performance issue.

As identified earlier *** VSEGU venkata.segu 07/13/16 11:08 pm *** , costly
sqls are from Order management.

As discussed in email, please open sr with order management and give the
performance fixes to customer.

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