'Duplicate Name. Please Change and Save.' Error Creating a New Dimension Member in OFSAAI 7.3.2
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
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.
Duplicate Numeric Code. Please change and save.
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.
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