Customer Merge Has Poor Performance
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***
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
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