ORA-00001 Running fn_drmDataLoader for Org Unit Dimension (Doc ID 1935952.1)

Last updated on DECEMBER 02, 2016

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 7.3 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Dimension Member Loader
DRM Dimension Loader

Symptoms

When attempting to execute fn_drmDataLoader for the Org Unit dimension, the following error occurs in FSI_MESSAGE_LOG:

Error:
ORA-00001: unique constraint (<atomic>.DIM_ORG_UNIT_TL) violated

The same error can occur for the other dimensions.  For example:

ORA-00001: unique constraint (<atomic>.DIM_COMMON_COA_TL) violated

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