My Oracle Support Banner

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

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.