'Error. Attributes in Staging Not Present in Fusion' on Attributes Running the Dimension Loader (fn_drmDataLoader)
Last updated on MAY 31, 2016
Applies to:Oracle Financial Services Analytical Applications Infrastructure - Version 126.96.36.199.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
In Oracle Financial Services Analytical Applications (OFSAA) 7.3.5, when you run the Dimension Loader program fn_drmDataLoader to load a dimension attribute table like DIM_ORG_UNIT_ATTR, you get the following error in FSI_MESSAGE_LOG:
Error from fsi_message_log
Error. Attributes in staging not present in Fusion
Error. select count(distinct v_attribute_varchar_label)
where not exists (select 1 from rev_dim_attributes_tl
where trim(upper(attribute_name)) = trim(upper(v_attribute_varchar_label))
and dimension_id = 1)
Data is loaded successfully into DIM_ORG_UNIT_B and DIM_ORG_UNIT_TL but the load into DIM_ORG_UNIT_ATTR fails.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms