LCDGUAMD Comission Components Are Getting Defaulted As Unwaived During Unlocking (Doc ID 2981911.1)

Last updated on OCTOBER 20, 2023

Applies to:

Symptoms

On : 14.6.0.3.0 version, Production Support

ACTUAL BEHAVIOR
---------------
LCDGUAMD commission components are getting defaulted as unwaived during unlocking

EXPECTED BEHAVIOR
-----------------------
Whenever user tries to modify the contract, and visit the commission tab, System should show the waived, unwaived option as done earlier.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1) Create a new Amendment from LCDGUAMD
2) Visit Comission tab, keep GAMFCOM as UNWAIVED, and GAMPCOM as WAIVED
3) Save the contract
4) Close the screen
5) Launch the screen again :: LCDGUAMD
6) query the contract
7) Unlock the contract, and visit comission tab, now both the components are seen as UNWAIVED

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users can't able to see the changes done earlier.

Changes

 Fix : 1.Commissions are showed in order of event triggered.
2.Fix provided to update the waiver flag based on the current processing esn instead of latest esn.
Modified Unit : cfpks_cfctrcom_kernel.sql , cfpks_cfctrcom_utils.sql
Search string : BUG#35873068

Cause

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