My Oracle Support Banner

Staging Table Dimension Loader Error. LoaderValidation ORA-01747: invalid user.table.column, table.column, or column specification (Doc ID 2645810.1)

Last updated on MARCH 12, 2020

Applies to:

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

Symptoms

When executing the Dimension Loader program, fn_drmDataLoader, the ORA-01747 error below occurs in FSI_MESSAGE_LOG:

Starting DRM Dimension Loader
Error. LoaderValidation ORA-01747: invalid user.table.column, table.column, or column specification
"
select count(*) from
DIM_COMMON_COA_B aa ,
DIM_COMMON_COA_HIER bb
, cc
where aa.COMMON_COA_ID = bb.child_id
and aa.COMMON_COA_ID =
cc.
and aa.enabled_flag = 'Y'
and cc.v_enabled_flag = 'N'"


The SQL shows that the "cc" table and related columns is missing.

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.