Customer Merge Has Poor Performance (Doc ID 1186295.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Quoting - Version 12.0.6 and later
Information in this document applies to any platform.
***Checked for relevance on 03-Dec-2013***

Symptoms

Poor performance when running the Customer Merge concurrent process.
The following recommended indices have been created but the performance is still poor:

INDEX_OWNER INDEX_NAME COLUMN_NAME
ASO ASO_QUOTE_HEADERS_ALL_N19 INVOICE_TO_CUST_ACCOUNT_ID
ASO ASO_QUOTE_HEADERS_ALL_N20 END_CUSTOMER_CUST_ACCOUNT_ID


ASO ASO_QUOTE_LINES_ALL_N6 END_CUSTOMER_CUST_ACCOUNT_ID
ASO ASO_QUOTE_LINES_ALL_N5 INVOICE_TO_CUST_ACCOUNT_ID 


A database trace was collected and the top statement was as follows:
SELECT DISTINCT CUSTOMER_MERGE_HEADER_ID ,QUOTE_LINE_ID , 
INVOICE_TO_CUST_ACCOUNT_ID ,END_CUSTOMER_CUST_ACCOUNT_ID 
FROM 
ASO_QUOTE_LINES YT, RA_CUSTOMER_MERGES M WHERE ( 
YT.INVOICE_TO_CUST_ACCOUNT_ID = M.DUPLICATE_ID OR 
YT.END_CUSTOMER_CUST_ACCOUNT_ID = M.DUPLICATE_ID ) AND M.PROCESS_FLAG = 'N' 
AND M.REQUEST_ID = :B2 AND M.SET_NUMBER = :B1

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