Customer Merge Has Poor Performance (Doc ID 1186295.1)

Last updated on APRIL 25, 2023

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