My Oracle Support Banner

Formula Results Assumption Does Not Generate Result Type 2 (Doc ID 2224885.1)

Last updated on FEBRUARY 17, 2017

Applies to:

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

Symptoms

On : 8.0.2 version, Calculation Engine

Formula Results assumption does not generate results for ALM Static Deterministic process.

ERROR
FSI_MESSAGE_LOG shows:
Exception while evaluating Formula-Result assumption. ORA-06502: PL/SQL:numeric or value error: character string buffer too small

EXPECTED BEHAVIOR
Expect Output for Formula Results with Result_Type 2 in RES_DTL result table.

STEPS:
1. Defined and run an ALM static deterministic process. The source is represented by only one record.
2. Defined Formula Results assumption which was created only for the <Product, Currency> combination of the specific deal records.
    The Formula type is defined as “Liquidity Gap” using an “ALM function”: FE(Leaf, FE, Lag)
3. After running the process, noticed that the process does not generate the corresponding output for Formula Results which should have RESULT_TYPE=2.

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.