Premium Discount Points of Forward Rate details are rounded off to 5 digits while moving from CYTM_FWDRATE_DETAILS to CYTM_FWDRATE_HISTORY (Doc ID 2748455.1)

Last updated on JUNE 21, 2021

Applies to:

Symptoms

ACTUAL BEHAVIOR
---------------
Premium discount points in Forward rate maintenance is saved in 5 decimal digits leading to variance in rates

EXPECTED BEHAVIOR
-----------------------
It is expected that complete digits of Premium discount points should be moved from cytm_fwdrate_details to cytm_fwdrate_history

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Perform forward rate maintenance
2. Verify the data in history table for same base date if premium / discount points are saved completely without truncate


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users find difference in rates between two dates causing inconsistency in FX reports

Cause

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