Performance Issue when Opening Invoice Line Details Page after 19c Upgrade
(Doc ID 2871102.1)
Last updated on SEPTEMBER 16, 2024
Applies to:
Oracle Lease and Finance Management - Version 12.2 and laterInformation in this document applies to any platform.
Symptoms
On : 12.2.9 version,
Find that after 19c upgrade, there is performance issue when there are high-volume invoice lines with receivable applications, it is taking 3-minutes to open the line-details page for approx. 600-invoice lines.
SQL ID: 73u31p457fz20
SELECT /*+ leading ( sch ) index(LINES RA_CUSTOMER_TRX_LINES_N3) */
SUM(NVL(AD.AMOUNT_CR,0))- SUM(NVL(AD.AMOUNT_DR,0)) TAX_APPLIED
FROM
AR_RECEIVABLE_APPLICATIONS_ALL APP, AR_PAYMENT_SCHEDULES_ALL SCH,
AR_DISTRIBUTIONS_ALL AD, RA_CUSTOMER_TRX_LINES_ALL LINES WHERE APP.STATUS =
'APP' AND APP.APPLIED_PAYMENT_SCHEDULE_ID = SCH.PAYMENT_SCHEDULE_ID AND
SCH.CLASS IN ('INV','CM') AND SCH.CUSTOMER_TRX_ID = :B2 AND
APP.APPLICATION_TYPE = 'CASH' AND APP.RECEIVABLE_APPLICATION_ID =
AD.SOURCE_ID AND AD.SOURCE_TABLE = 'RA' AND AD.REF_CUSTOMER_TRX_LINE_ID =
LINES.CUSTOMER_TRX_LINE_ID AND LINES.LINK_TO_CUST_TRX_LINE_ID = :B1 AND
LINES.LINE_TYPE = 'TAX'
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Using lease super user responsibility, navigate to Lease.
2. Navigate to Operations > Invoices.
3. Enter the invoice number and Go.
4. Click on the invoice number hyperlink to view the invoice lines and you notice the performance issue.
Changes
19c Upgrade was done.
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 |
Changes |
Cause |
Solution |
References |