My Oracle Support Banner

Termination Quote Line Update Results in Performance Issues on Gain/Loss Formula for High Asset Volume (Doc ID 2816525.1)

Last updated on NOVEMBER 09, 2021

Applies to:

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

Symptoms

On : 12.2.9 version, Asset Management

ACTUAL BEHAVIOR
---------------
Find that termination quote line update results in performance issues on due to Gain/Loss Formula call for each quote-line-type during recalculate quote quote-level amounts for high asset volume.

EXPECTED BEHAVIOR
-----------------------
Expect better performance.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Using lease super user responsibility, create a full termination quote with high asset volume.
2. Update any quote-amounts which result in call to the API: OKL_AM_TERMNT_QUOTE_PVT.recalculate_quote
3. In that API, Gain/Loss Formula OKL_AM_CREATE_QUOTE_PVT.get_net_gain_loss is called in a Loop for all Quote-line-types and due to high asset-volume this formula is called (Number-of-Quote-Lines-types * Number-of-Assets) times, which resulting in Termination Quote UI time-out and Quote-updates never completes.


Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.