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

Last updated on JULY 17, 2024

Applies to:

Symptoms

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.

Cause

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