My Oracle Support Banner

'Error. Attributes in staging not present in Fusion' Running Dimension Loader Fn_drmDataLoader (Doc ID 2645814.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 error below occurs in FSI_MESSAGE_LOG:

Error. Attributes in staging not present in Fusion
"Error. select count(distinct v_attribute_varchar_label)
from STG_COMMON_COA_ATTR_INTF
where not exists (select 1 from rev_dim_attributes_tl
where trim(upper(attribute_name)) = trim(upper(v_attribute_varchar_label))
and dimension_id = 3)"
Process not completed due to the error : User-Defined Exception

Data is loaded into the _B and _TL tables but no data is loaded into the _ATTR table.

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.