Performance Issue Creating Termination Quote For Large Contracts With > 100 Assets (Doc ID 342283.1)

Last updated on SEPTEMBER 06, 2016

Applies to:

Oracle Lease and Finance Management - Version 11.5.9 to 11.5.10.2 [Release 11.5]
Information in this document applies to any platform.
Checked for relevance 28-Junr-2015

Symptoms

Creating a Termination quote for a lease contract that has more than 100 assets takes a long time to complete or times out.

A trace file generated for the process shows this select statement as problematic:

SELECT ID, OBJECT_VERSION_NUMBER, SFWT_FLAG, RGD_CODE, SAT_CODE, RGP_TYPE, CLE_ID, CHR_ID, DNZ_CHR_ID, PARENT_RGP_ID, COMMENTS, ATTRIBUTE_CATEGORY, ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE5, ATTRIBUTE6, ATTRIBUTE7, ATTRIBUTE8,
ATTRIBUTE9, ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12, ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15,
CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN
FROM Okc_Rule_Groups_V
WHERE nvl(OKC_Rule_Groups_V.chr_id,-9999) = :b3
AND nvl(OKC_Rule_Groups_V.cle_id,-9999) = :b4
AND OKC_Rule_Groups_V.dnz_chr_id = decod
e(:b3,-9999,OKC_Rule_Groups_V.dnz_chr_id,:b2)
AND RGD_CODE = decode(:b1,null,RGD_CODE,:b1)





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