Customer Merge Has Poor Performance
(Doc ID 1186295.1)
Last updated on MARCH 01, 2021
Applies to:Oracle Quoting - Version 12.0.6 and later
Information in this document applies to any platform.
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
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