My Oracle Support Banner

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 FEBRUARY 07, 2021

Applies to:

Oracle FLEXCUBE Universal Banking - Version 12.3 and later
Information in this document applies to any platform.

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

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.