DRM Data Loader Incorrectly References DIM_PRODUCTS_B When Validating Non-PRODUCT_ID Attribute Values
(Doc ID 2911031.1)
Last updated on DECEMBER 08, 2022
Applies to:
Oracle Financial Services Profitability Management - Version 8.1.0.0.0 and laterOracle Financial Services Asset Liability Management - Version 8.1.0.0.0 and later
Oracle Financial Services Analytical Applications Infrastructure - Version 8.1.0.0.0 and later
Oracle Financial Services Funds Transfer Pricing - Version 8.1.0.0.0 and later
Information in this document applies to any platform.
Oracle Financial Service Analytical Applications (OFSAA)
Symptoms
When running the DRM Data Loader (fn_drmDataLoader) to load the General Ledger Account dimension, the loader is referencing the DIM_PRODUCTS_B table incorrectly. The following SQL statement exists in FSI_MESSAGE_LOG for the dimension load:
Error. Value for Attribute PS_GL_CODE in stg_gl_attr_intf table not present in DIM_PRODUCTS_B table.
"Use SQL to identify Attribute Values :select distinct v_attribute_assign_value from stg_gl_attr_intf aa where
upper(trim(aa.v_attribute_varchar_label)) = 'PS_GL_CODE' and not exists
(select 1 from DIM_PRODUCTS_B bb where UPPER(TRIM(bb.PRODUCT_CODE)) = UPPER(TRIM(aa.v_attribute_assign_value)))
and aa.v_attribute_assign_value is not null"
;
As a result of this issue, the DIM_GENERAL_LEDGER_ATTR table is not getting populated.
The correct tables are listed in FSI_DIM_LOADER_SETUP_DETAILS for the General Ledger dimension.
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 |