My Oracle Support Banner

DRM Data Loader Incorrectly References DIM_PRODUCTS_B When Validating Non-PRODUCT_ID Attribute Values (Doc ID 2911031.1)

Last updated on FEBRUARY 02, 2024

Applies to:

Oracle Financial Services Profitability Management - Version and later
Oracle Financial Services Asset Liability Management - Version and later
Oracle Financial Services Analytical Applications Infrastructure - Version and later
Oracle Financial Services Funds Transfer Pricing - Version and later
Information in this document applies to any platform.
Oracle Financial Service Analytical Applications (OFSAA)


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.


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

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