My Oracle Support Banner

ORA-00904 "NODE_": invalid identifier Error Running PFT Allocation with Hierarchy (Doc ID 1457237.1)

Last updated on MARCH 12, 2021

Applies to:

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

Symptoms

On Oracle Financial Services Profitability Management (PFT), when attempting to run an Allocation that includes a Hierarchy, the following error occurs:

ERROR
Driver Function: drv_oci::Execute().
Oracle Error: ORA- 00904: : "NODE_": invalid identifier

The SQL listed under the error contains a reference to OFSA_IDT_ROLLUP with a bad Node column.

Example 1:

a.ORG_UNIT_ID IN (SELECT leaf_node FROM OFSA_IDT_ROLLUP WHERE OFSA_IDT_ROLLUP.sys_id_num = 213185 and (OFSA_IDT_ROLLUP.node_-3 = 1000019966)

Example 2:

AND PRODUCT_ID IN (
SELECT LEAF_NODE
FROM OFSA_IDT_ROLLUP
WHERE OFSA_IDT_ROLLUP.SYS_ID_NUM = 509749
AND (OFSA_IDT_ROLLUP.NODE_0- 8 IN (
SELECT REV_HIERARCHY_FILTER.LEAF_NODE
FROM REV_HIERARCHY_FILTER
WHERE REV_HIERARCHY_FILTER.SYS_ID_NUM = 651009
AND REV_HIERARCHY_FILTER.HIERARCHY_LEVEL = 8 ) ))

The error may exist in the ofspa.xxxxxx.log file in $FIC_DB_HOME/log/FusionApps (8.0.5 and lower) or in the Allocation Engine log file in /<ftpshare>/logs/<AsofDate>/<infodom>/Allocation Engine (8.0.6 and higher) or in the FSI_MESSAGE_LOG table.

In some cases, the ORA- error is not listed in the log and you get the following instead:

Module Logging OFS errors: (203105) Message String Too Long
or Not Defined

and

Module Logging OFS errors: Invalid Page

In this case, you can trigger the ORA- 00904 by running the SQL statement in SQL Developer or SQL*Plus.

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.