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.
On : 12.2.9 version, Asset Management
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.
Expect better performance.
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.
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