'Error. Attributes in staging not present in Fusion' Running Dimension Loader Fn_drmDataLoader
(Doc ID 2645814.1)
Last updated on JULY 17, 2024
Applies to:
Oracle Financial Services Asset Liability Management - Version 8.0.0 and laterOracle 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 |