Static Driver Table Allocation Hangs with Error 'ORA-00904: "F0"."NODE_": Invalid Identifier' (Doc ID 2183978.1)

Last updated on SEPTEMBER 19, 2016

Applies to:

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

Symptoms

In Oracle Financial Services Profitability Management (PFT) 8.0, when you run a Static Driver Table Allocation, the Allocation hangs in the backend and fails to output results.  The following errors are output to FSI_MESSAGE_LOG:

ERROR:- ORA-00904: "F0"."NODE_": invalid identifier
ERROR:- ORA-00904: "F0"."NODE_": invalid identifier
ERROR:- ORA-00904: "F0"."NODE_": invalid identifier
ERROR:- ORA-00904: "F0"."NODE_": invalid identifier


There is no ORA- error in the ofspa.xxxxxxxxx.log in $FIC_DB_HOME/log/FusionApps but you do see the bad SQL causing the errors in FSI_MESSAGE_LOG:

Module Logging OFS Access module data: declare begin AUTONOMOUS_TRXN_PFT( 202331.000000,
          'OFSPFTINFO_Task1_202331_EXEC_20160430_1', '
CREATE
OR REPLACE VIEW VW_TID_LS_11392 AS
Select distinct ''K'' Leaf_Type, table_sys_id, Parent_row_num,
          coalesce(Leaf_1, - 99100) Leaf_1, coalesce(Leaf_2, - 99100)
          Leaf_2, coalesce(Leaf_3, - 99100) Leaf_3, 0 as amount from(
select t.* , coalesce(f0.leaf_node, f0_id) Leaf_1,
          coalesce(f1.leaf_node, f1_id) Leaf_2, coalesce(f2.leaf_node,
          f2_id) Leaf_3
from fsi_m_alloc_table_id_values t left outer join
          ofsa_idt_rollup F0 on F0.sys_id_num=201688
and F0.node_- 2 in (300100100000, 300100200000, 300100300000,
          300100400000)
and F0.node_- 2=t.F0_id left outer join ofsa_idt_rollup F1 on
          F1.sys_id_num=- 99100
and F1.node_01 in (- 1)
and F1.node_01=t.F1_id left outer join ofsa_idt_rollup F2 on
          F2.sys_id_num=- 99100
and F2.node_01 in (- 1)
and F2.node_01=t.F2_id
where table_sys_id=202322) union all
etc.


The "node" value is incorrectly listed as "F0.node_".

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