My Oracle Support Banner

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 later
Information 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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.