Terminate Expire Contracts : Performance Issue

(Doc ID 2364910.1)

Last updated on FEBRUARY 23, 2018

Applies to:

Oracle Lease and Finance Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Agreement Modules

ACTUAL BEHAVIOR
---------------
Terminate expire contracts : Performance issue

Able to see below query executing more time:

SELECT SUM(NVL(CUST_TRX_LINES.AMOUNT_DUE_REMAINING, (CUST_TRX_LI
NES.EXTENDED_AMOUNT * PAY_SCH.AMOUNT_DUE_REMAINING / PAY_SCH.AMO
UNT_DUE_ORIGINAL) )) LINE_AMT_DUE_COMBINED FROM ( SELECT SUM(NVL
(PAY_SCH.AMOUNT_DUE_ORIGINAL,0)) AMOUNT_DUE_ORIGINAL, SUM(NVL(PA
Y_SCH.AMOUNT_DUE_REMAINING,0)) AMOUNT_DUE_REMAINING, CUST_TRX.CU
STOMER_TRX_ID CUSTOMER_TRX_ID FROM RA_CUSTOMER_TRX_ALL CUST_TRX,
 AR_PAYMENT_SCHEDULES_ALL PAY_SCH WHERE CUST_TRX.CUSTOMER_TRX_ID
 = PAY_SCH.CUSTOMER_TRX_ID AND AMOUNT_DUE_REMAINING > 0 AND PAY_
SCH.STATUS = 'OP' AND PAY_SCH.CLASS = 'INV' GROUP BY CUST_TRX.CU
STOMER_TRX_ID) PAY_SCH, RA_CUSTOMER_TRX_LINES_ALL CUST_TRX_LINES
, RA_CUSTOMER_TRX_LINES_ALL TAX_PARENT_LINES WHERE PAY_SCH.CUSTO
MER_TRX_ID = CUST_TRX_LINES.CUSTOMER_TRX_ID AND PAY_SCH.CUSTOMER
_TRX_ID = TAX_PARENT_LINES.CUSTOMER_TRX_ID AND CUST_TRX_LINES.LI
NE_TYPE IN ('LINE','TAX') AND NVL(CUST_TRX_LINES.LINK_TO_CUST_TR
X_LINE_ID,CUST_TRX_LINES.CUSTOMER_TRX_LINE_ID) = TAX_PARENT_LINE
S.CUSTOMER_TRX_LINE_ID AND NVL(CUST_TRX_LINES.INTERFACE_LINE_ATT
RIBUTE6, TAX_PARENT_LINES.INTERFACE_LINE_ATTRIBUTE6) = :B1 GROUP
 BY NVL(CUST_TRX_LINES.INTERFACE_LINE_ATTRIBUTE6, TAX_PARENT_LIN
ES.INTERFACE_LINE_ATTRIBUTE6)
=====================================================

 



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Terminate expire contracts : Performance issue


Changes

 

Cause

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