PLS- 00905: object VALIDATE_NODE_MAP_ALM is invalid Errors Running ALM Processes (Doc ID 2251328.1)

Last updated on APRIL 03, 2017

Applies to:

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

Symptoms

On ALM 8.0.0, when attempting to run ALM processes, there are errors in the ALM debug log.  Check of invalid objects in the atomic schema show several procedures are invalid and will not recompile.  The following errors are thrown:

ERROR

From ALM debug err log:

Module Logging OFS errors: (203105) Oracle drv_oci error: OCI Function: [4] - oexec(),
oexn() SQL Function: [34] - PL/ SQL EXECUTE Oracle Error: ORA-
06550: line 1, column 15: PLS- 00905: object
EPM_OFSATM.VALIDATE_NODE_MAP_ALM is invalid ORA- 06550: line 1,
column 15: PL/ SQL: Statement ignored Driver Function:
drv_oci::Execute() SQL Statement: declare begin
VALIDATE_NODE_MAP_ALM(205774, 3); end;

PLS-00905: object EPM_OFSATM.POPULATE_HIERARCHICAL_MM is invalid
PLS-00905: object EPM_OFSATM.POPULATE_HIERARCHICAL_FB is invalid

These 2 stored procedure have the same error when tried to recompile:
PLS-00753: malformed or corrupted wrapped unit

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