ORA-14452 Executing VALIDATE_NODE_MAP_ALM When Running ALM Processes in Parallel (Doc ID 1343280.1)

Last updated on DECEMBER 14, 2016

Applies to:

Oracle Financial Services Asset Liability Management - Version 5.2 to 5.2.2 [Release 5]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

In Oracle Financial Services Asset Liability Management (ALM) 5.2.2, when you execute two ALM processes in parallel, you get the following error in the ofsrm log in $FIC_DB_HOME/log/FusionApps:

Module Logging OFS Access module data: declare begin VALIDATE_NODE_MAP_ALM(200451, 4); end;

Module Logging OFS errors: (203105) Oracle drv_oci error: OCI Function: [4] - oexec(),
oexn() SQL Function: [34] - PL/ SQL EXECUTE Oracle Error: ORA-
14452: attempt to create,
alter
or
drop an index on temporary table already in use ORA- 06512: at
"<Atomic>.POPULATE_HIERARCHICAL_DIS_RATE", line 92 ORA- 06512: at
"<Atomic>.BUILD_NODE_MAP_ALM", line 14 ORA- 06512: at
"<Atomic>.VALIDATE_NODE_MAP_ALM", line 92 ORA- 06512: at line 1
Driver Function: drv_oci::Execute() SQL Statement: declare begin
VALIDATE_NODE_MAP_ALM(200451, 4); end;

The ORA-14452 error only occurs when you submit multiple ALM processes at the same time.

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