Performance Issue With Party Merger Program ARHPMERGE
(Doc ID 1241455.1)
Last updated on FEBRUARY 11, 2021
Applies to:
Oracle Order Capture - Version 11.5.9 and laterInformation in this document applies to any platform.
Goal
The performance of the concurrent program ARHPMERGE is poor , related to ASO tables. The following SQLs are the most expensive ones :
SELECT QUOTE_LINE_ID
FROM
ASO_QUOTE_LINES_ALL WHERE INVOICE_TO_PARTY_ID = :p_from_id
SELECT QUOTE_LINE_ID
FROM
ASO_QUOTE_LINES_ALL WHERE INVOICE_TO_CUST_PARTY_ID = :p_from_id
SELECT SHIPMENT_ID
FROM
ASO_SHIPMENTS WHERE SHIP_TO_CUST_PARTY_ID = :p_from_id
SELECT QUOTE_LINE_ID
FROM
ASO_QUOTE_LINES_ALL WHERE INVOICE_TO_PARTY_SITE_ID = :p_from_id
SELECT SHIPMENT_ID
FROM
ASO_SHIPMENTS WHERE SHIP_TO_PARTY_SITE_ID = :p_from_id
Solution
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
Goal |
Solution |