My Oracle Support Banner

ALM Dynamic Deterministic Process Fails at SELECT From FSI_FCAST_IRCS Table When Forecast Rate Method is Defined (Doc ID 2441491.1)

Last updated on MARCH 17, 2021

Applies to:

Oracle Financial Services Asset Liability Management - Version 8.0.2 and later
Oracle Solaris on x86-64 (64-bit)
Oracle Solaris on SPARC (64-bit)
Oracle Financial Services Profitability Management (PFT)
Oracle Financial Services Funds Transfer Pricing (FTP)
Oracle Financial Services Asset Liability Management (ALM)
Oracle Financial Services Balance Sheet Planning (BSP)
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Enterprise Performance Management (EPM)


When defining a forecast IRC and run the ALM Dynamic Deterministic Process, the process fails with the following shown at the end of the log:

The process succeeds when no forecast rates method is defined. Once we define a method, the process fails.
The defined forecast method is flat rate.
This same issue is happening with other forecast IRC methods as well.


1. Define a forecast IRC
2. Create ALM Dynamic Deterministic Process as per customer's specifications
3. Run the process
4. Check results, including ofsrm log ending




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.