ALM Error ORA-6550 PLS-00201 PR_FAIR_VAL_CALC must be Declared (Doc ID 1323711.1)

Last updated on MAY 19, 2011

Applies to:

Oracle Financial Services Asset Liability Management - Version: 5.5 and later   [Release: 5 and later ]
Information in this document applies to any platform.
OFSAA

Symptoms

On : 5.5 version, Calculation Engine

When attempting to run Asset Liability Management (ALM) process after upgrading to ALM 5.5, the following error occurs in the debug log but the process produced results

Error
Module Logging OFS errors: (203105) Oracle drv_oci error:
OCI Function: [4] - oexec(), oexn() SLQ Function (34) - PL/SQL Execute Oracle Error: ORA-06550: line 1, column 15, PLS-00201: identified 'PR_FAIR_VAL_CALC' must be declared ORA-06550: line 1, column 15: PL/SQL: Statement

Steps:
1. Apply ALM Service Pack 5.5.
2. Run Alm Static Deterministic process.
3. Verify results are being posted to RES_DTL table but errors shown in the debug log file.

Changes

Apply ALM Service Pack 5.5.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms