My Oracle Support Banner

ALM Convexity and YTM Fields are Populating With Zero in Consolidation Master Table and Duration / Modified Duration are Negative or Zero (Doc ID 2169024.1)

Last updated on JUNE 11, 2021

Applies to:

Oracle Financial Services Asset Liability Management - Version 6.0.3 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Enterprise Performance Management (EPM)


On Oracle Financial Services Asset Liability Management (ALM), several Convexity, Yield to Maturity (YTM) and modified duration fields are populating with zero for non amortizing (AMRT_TYPE_CD = 700) instruments.  Other instruments are generating negative duration and modified duration results.

Columns like Convexity, YTM and Modified Duration are populating as zero in the FSI_O_CONSOLIDATED_MASTER table while it has values in Result Master.  Other instruments are generating duration and modified duration either with negative or zero values.

Expect correct values generated in consolidated master table.

The issue can be reproduced at will with the following steps:
1. Create a Discount rule with Discount Method as Forecast Remaining term.
2. Create a Static Deterministic Process and map the above Discount Rule to it.
3. Map a instrument record which is not same as reporting currency.
4. Assign exchange rate to it (Used Currency in Instrument Record to Reporting Currency in the process),.
5. Choose Product/Currency as a combination in Output Preferences in the process screen.
6. Execute the process and validate the output tables - Result Master and Consolidated Master table.


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

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