'ORA-00904: "SESSION_DISABLE_STATEMENT": Invalid Identifier' Error in SCD Log

(Doc ID 1582748.1)

Last updated on JANUARY 19, 2016

Applies to:

Oracle Financial Services Profitability Analytics - Version 6.1 and later
Oracle Financial Services Analytical Applications Infrastructure - Version 7.3 and later
Oracle Financial Services Asset Liability Management Analytics - Version 6.1 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

When implementing Oracle Financial Services Profitability Analytics (PFTBI) or Asset Liability Management Analytics (ALMBI) 6.1, when running the SCD process on any dimension, the following ORA-00904 error appears in the SCD log in /<ftpshare>/<Infodom>/logs:

[2013/09/05 - 20:10:17]    Table Master Query: SELECT tbl_nm, stg_tbl_nm, src_key, src_prty, dt_offset FROM sys_tbl_master WHERE map_ref_num = 127
[2013/09/05 - 20:10:17]    Table Master hint Query: SELECT merge_hint, select_hint, session_enable_statement,session_disable_statement FROM sys_tbl_master WHERE map_ref_num = 127
[2013/09/05 - 20:10:17]    ClsUDBOperations::executeSelectQuery, Error, unable to create statement object based on the query supplied SELECT merge_hint, select_hint, session_enable_statement,session_disable_statement FROM sys_tbl_master WHERE map_ref_num = 127
[2013/09/05 - 20:10:17]    ERROR Message:     ORA-00904: "SESSION_DISABLE_STATEMENT": invalid identifier

[2013/09/05 - 20:10:17]    Warning : Columns merge_hint, select_hint, session_enable_statement and session_disable_statement not available in sys_tbl_master table, ignoring this and proceeding further

The SCD process loads the dimension data successfully into the target table despite the error.  However, you do not expect to get any errors in the SCD log when the process is successful.

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