Performance issue in Lease Center while displaying contracts details

(Doc ID 1532647.1)

Last updated on MARCH 01, 2017

Applies to:

Oracle Lease and Finance Management - Version 11.5.10.2 and later
Information in this document applies to any platform.
Checked for relevance 29-Mar-2015

Symptoms

On Lease Management:
When accessing the OKL lease center form, below query on okl_k_hdrs_full_uv gets executed to fetch the contracts details:

SELECT chr_contract_number,
  chr_sts_meaning,
  product_name,
  chr_start_date,
  chr_end_date,
  program_contract_number,
  chr_currency_code,
  chr_id,
  cust_object1_id1,
  chr_cust_acct_id
  FROM okl_k_hdrs_full_uv
 WHERE chr_id = :chr_id

Even though this query performs more or less reasonable within few seconds, it still causes some recognizable time-lag due to inefficient coding in underlying view okl_k_hdrs_full_uv as that one accesses quite some tables (i.e. by selecting from views as opposed to base tables directly) that are not required for the query result.

After removing obsolete table accesses, the query performs about 15% more efficient.

Steps to Reproduce
(R) Lease Center
1/ open Lease Center and search for a specific contract => trace and see the performance

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