Performance issue in Lease Center while displaying contracts details
Last updated on MARCH 01, 2017
Applies to:Oracle Lease and Finance Management - Version 188.8.131.52 and later
Information in this document applies to any platform.
Checked for relevance 29-Mar-2015
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:
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
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