My Oracle Support Banner

Fn_drmDataLoader Dimension Load Fails with 'Error. LoaderValidation ORA-01403: No Data Found' on Attribute (Doc ID 3047160.1)

Last updated on SEPTEMBER 19, 2024

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 8.1.2 and later
Oracle Financial Services Data Foundation - Version 8.1.2 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI)
Oracle Financial Services Asset Liability Management (ALM)
Oracle Financial Services Funds Transfer Pricing (FTP)
Oracle Financial Services Profitability Management (PFT)

Symptoms

When attempting to load product dimension members from the STG_PRODUCTS_INTF staging tables using the fn_drmDataLoader program, the following errors occurs in FSI_MESSAGE_LOG:

Error:

Starting DRM Dimension Loader
Force_Member_Delete Flag is set to N
Deleted 1 records from DIM_PRODUCTS_B
Deleted 1 records from DIM_PRODUCTS_TL
Inserted 43 records into DIM_PRODUCTS_B
Inserted 43 records into DIM_PRODUCTS_TL
Error. LoaderValidation ORA-01403: no data found
select distinct trim(upper(v_attribute_varchar_label)) from stg_products_attr_intf
Process not completed due to the error : User-Defined Exception


Steps To Replicate Issue:

1. Load data into STG_PRODUCTS_B_INTF, STG_PRODUCTS_TL_INTF and STG_PRODUCTS_ATTR_INTF  tables.
2. Run fn_drmDataLoader('<Batch Name>_20240505_1','20240505',4) for Product dimension.
3. Check FSI_MESSAGE_LOG and found error above.

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


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