'Error. Attributes in Staging Not Present in Fusion' on Attributes Running the Dimension Loader (fn_drmDataLoader)

(Doc ID 2141966.1)

Last updated on MAY 31, 2016

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 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)
from stg_org_unit_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 = 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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms