Customer Merge Performance Issue In R12, SQL Hint in ARHCMGNB.pls Causing Bad Performance
(Doc ID 1350283.1)
Last updated on FEBRUARY 15, 2019
Applies to:
Oracle Receivables - Version 12.0.6 and laterInformation 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
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |