Performance Problem in Lease Center Form Assets Tab (Doc ID 2259908.1)

Last updated on APRIL 27, 2017

Applies to:

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

Symptoms

On : 12.2.4 version, Customer Service

ACTUAL BEHAVIOR
---------------
Find that after searching a contract in lease center form and navigating to Asset tab, performance issue is observed. It takes 10 minutes or more.

SQL that has the performance problem:

SELECT ID1 COL1, ID2 COL2, ASSET_ID COL3, ASSET_NUMBER COL4, NAME COL5,
 DESCRIPTION COL6, QUANTITY COL7, DNZ_CHR_ID COL8, PARENT_LINE_ID COL9,
 ASSET_STATUS COL10, MANUFACTURER_NAME COL11, MODEL_NUMBER COL12,
 ORIGINAL_COST COL13, LINE_STATUS COL14, NULL COL15
FROM
OKL_CS_ASSET_LINES_V WHERE 1 = 1 and dnz_chr_id = :dnz_chr_id ORDER BY COL4
 ASC

EXPECTED BEHAVIOR
-----------------------
Expect the performance to take one second.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigate to lease center agent >> lease center search
2. Query a contract and Open
3. Navigate to Assets tab and notice the performance.

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