'Duplicate Name. Please Change and Save.' Error Creating a New Dimension Member in OFSAAI 7.3.2

(Doc ID 1579010.1)

Last updated on JULY 27, 2016

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 (OFSAA) 6.x

Symptoms

In Oracle Financial Services Analytical Applications (OFSAA) 7.3.2/6.x, you cannot add new dimension members in Dimension Management >Members.  After entering the new member details, you get the following error message when clicking on Save:

Duplicate Name. Please change and save.
or
Duplicate Numeric Code. Please change and save.

Example:



Additionally, in the FUSIONSUBSYSTEMSService.log in the web server's OFSAA log directory, many errors like the following exist:

[FUSIONSUBSYSTEMS] Aug 16,13 10:37:44 : [MEMBERHANDLER]
java.sql.BatchUpdateException: ORA-00001: unique constraint (OFSAA_ATOMIC.PK_DIM_PRODUCTS_ATTR) violated

The errors prevent you from creating new members for one or more dimensions.

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