My Oracle Support Banner

Customer Merge Has Poor Performance (Doc ID 1186295.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle Quoting - Version 12.0.6 and later
Information in this document applies to any platform.

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

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
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.