Customer Merge Performance Issue In R12, SQL Hint in ARHCMGNB.pls Causing Bad Performance
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
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