My Oracle Support Banner

"ORA-00001: unique constraint (APPLSYS.FND_SECURITY_GROUPS_TL_U2) violated" Error Occurs when Defining Business Group (Doc ID 2655905.1)

Last updated on APRIL 03, 2020

Applies to:

Oracle Human Resources - Version 12.1.1 and later
Information in this document applies to any platform.


Problem Statement:

When attempting to define a business group where the security group feature is enabled, following error occurs.

ORA-00001: unique constraint (APPLSYS.FND_SECURITY_GROUPS_TL_U2) violated has been detected in FND_SECURITY_API.CREATE_GROUP.



Steps to Reproduce:

The issue can be reproduced at will with the following steps:

  1.  Login as HRMS Manager responsibility.

  2.  Rename the existing business group.
     Old Name: XXBG
     New Name: XXBG_OBSOLETE

  3.  Create a new business group with the original name.
     name: XXBG

  4. Error occurs when entering Business Group Info. (e.g.Short Name, KFF, Legislation Code, Currency...etc) and save.



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

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