ORA-00904 on Dimension Columns During Insert into RES_DTL_xxxxxx (Doc ID 1340920.1)

Last updated on OCTOBER 08, 2024

Applies to:

Symptoms

In Oracle Financial Services Asset Liability Management (ALM), when you run an ALM process, an ORA-00904 occurs on a user defined dimension / leaf column during the insert into the Result Detail table.  You see an error like the following in the ofsrm log file in $FIC_DB_HOME/logs/FusionApps OR <ftpshare>/logs/<MISDATE>/<INFODOM>/<COMPONENT NAME>/<LOG FILE NAME>.log directory:

Module Logging OFS Access module data: insert
insert into RES_DTL_123456(ORG_UNIT_ID, GL_ACCOUNT_ID,
COMMON_COA_ID, PRODUCT_ID, CHANNEL_ID, iso_currency_cd,
result_sys_id, financial_elem_id, scenario_num, start_date_index,
result_type_cd, bucket_001, bucket_002, bucket_003, bucket_004,
bucket_005, bucket_006, bucket_007, bucket_008, bucket_009,
bucket_010, bucket_011, bucket_012, bucket_013, bucket_014,
bucket_015, bucket_016, bucket_017, bucket_018, bucket_019,
.
.
.
bucket_235, bucket_236, bucket_237, bucket_238, bucket_239,
bucket_240, leg_type)
values (:ORG_UNIT_ID, :GL_ACCOUNT_ID, :COMMON_COA_ID,
:PRODUCT_ID, :CHANNEL_ID,
:iso_currency_cd, :result_sys_id, :financial_elem_id,
:scenario_num, :start_date_index, :result_type_cd, :bucket_001,
:bucket_002, :bucket_003, :bucket_004, :bucket_005, :bucket_006,
:bucket_007, :bucket_008, :bucket_009, :bucket_010, :bucket_011,
:bucket_012, :bucket_013, :bucket_014, :bucket_015, :bucket_016,
:bucket_017, :bucket_018, :bucket_019, :bucket_020, :bucket_021,
:bucket_022, :bucket_023, :bucket_024, :bucket_025, :bucket_026,
.
.
.
:bucket_232, :bucket_233, :bucket_234, :bucket_235, :bucket_236,
:bucket_237, :bucket_238, :bucket_239, :bucket_240, :leg_type )

Module Logging OFS errors: (203105) Oracle drv_oci error: OCI Function: [4] - oexec(),
oexn() SQL Function: [0] - SQL function not found! Oracle Error:
ORA- 00904: "CHANNEL_ID": invalid identifier Driver
Function: drv_oci::Execute()

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

Module Logging OFS errors: (203055) Error Executing SQL statement.

As a result, no rows exist in the RES_DTL_xxxxxx table.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.