Error. LoaderValidation User-Defined Exception Error Executing DRM Dimension Loader After Upgrade to OFSAA 7.3.2 / 6.0

(Doc ID 1518821.1)

Last updated on JULY 01, 2015

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 7.3.2 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI) - Version 7.3
Oracle Financial Services Analytical Applications (OFSAA) - Version 6.x

Symptoms

On OFSAAI 7.3.2, when attempting to run drm Dimension loader for a user defined dimension after upgrading from 5.2.2 to 6.0, the following error occurs:

ERROR
Starting DRM Dimension Loader
select count(1) from (select distinct from stg_bus_unit_b_intf group by having count(1) >1)
Error. select count(1) from (select distinct from stg_bus_unit_b_intf group by having count(1) >1)
Error. LoaderValidation User-Defined Exception

STEPS
The issue can be reproduced at will with the following steps:
1. Run the drm dimension loader for a user defined processing dimension:

fn_drmDataLoader('OFSAUT_TIAA_DIM_LD_BUS_UNIT_20121203_3','20121203',7); END;

2. See error in FSI_MESSAGE_LOG

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms