Difference Of 1 USD Is Observed After Doing A Rollover In CLTB_ROLL_SETTLEMENTS And ACTB_DAILY_LOG (Doc ID 2609391.1)

Last updated on NOVEMBER 25, 2021

Applies to:

Symptoms

ACTUAL BEHAVIOR
---------------
Difference of 1 USD is observed after doing a rollover in  rollover SETTLEMENTS and accounting log

EXPECTED BEHAVIOR
-----------------------
After Save of the Rollover, Settled amount should be the same in amount_settled in rollover SETTLEMENTS and LCY_AMOUNT in accounting log.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Steps

1)Create a back dated currency loan
2)Open CLDMROLL screen for rollover.
3)During rollover in "Component Details" section, Liquidate penal_int and main_int component, and capitalized principal components.
4)Also in "Debit Details" section provide details for the amount Liquidated i.e penal_int+main_int amount.
5)Also in "Credit Details" section provide details for the amount capitalized i.e principal amount.
6)Save the rollover.
7)Check ACTB_DAILY_LOG and CLTB_ROLL_SETTLEMENTS tables. When compared there is a difference of 1 USD for amount_settled in CLTB_ROLL_SETTLEMENTS and LCY_AMOUNT
in ACTB_DAILY_LOG.


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot proceed with rollover account with correct amount in amount_settled in rollover SETTLEMENTS and LCY_AMOUNT in accounting log 

Cause

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