Ledger Load Failed with ORA-00904: TP_LEAF: Invalid Identifier (Doc ID 1377635.1)

Last updated on NOVEMBER 15, 2011

Applies to:

Oracle Financial Data Manager - Version: 4.5.40 and later   [Release: 4.5 and later ]
Information in this document applies to any platform.
Oracle Financial Services Applications (OFSA)

Symptoms

When attempting to run Ledger Load procedure after adding a new non-key leaf, the following error occurs.

Error:
Warning ORA-00904: "TP_LEAF": invalid identifier


Steps:
1. Added a new leaf: TP_LEAF using RUN_ADD_LEAF procedure.
2. Run ledger_stat_load procedure:
 
SQL> EXEC OFSA_UTIL.LEDGER_STAT_LOAD();
BEGIN OFSA_UTIL.LEDGER_STAT_LOAD(); END;

*
ERROR at line 1:
ORA-00904: "TP_LEAF": invalid identifier
ORA-06512: at "SYS.DBMS_SYS_SQL", line 909
ORA-06512: at "SYS.DBMS_SQL", line 39
ORA-06512: at "OFSD.OFSA_UTIL", line 2571
ORA-06512: at line 1

Changes

Added a new non-key leaf.

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