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.
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!