Customer Merge Performance Issue In R12, SQL Hint in ARHCMGNB.pls Causing Bad Performance

(Doc ID 1350283.1)

Last updated on MAY 31, 2018

Applies to:

Oracle Receivables - Version 12.0.6 and later
Information in this document applies to any platform.

Symptoms

Customer Merge is taking up to 1.5 hours to run.

The issue is in Pl/Sql package arp_cmerge_arcus (ARHCMGNB.pls 120.37.12000000.5) there is a SQL hint that forces the optimizer to use a very poor plan.


Culprit Hint.

SELECT /*+ index (su,hz_cust_site_uses_n1) */ site_use_id

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