My Oracle Support Banner

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.


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


To view full details, 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 a vibrant support community of peers and Oracle experts.