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 SEPTEMBER 05, 2018

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)

Symptoms

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.

STEPS TO REPRODUCE

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

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.