My Oracle Support Banner

Update DFF on Element Entry Screen Errors: APP-FND-01206 This record already exists or Update_Element_Entry API, Errors: ORA-00001: unique constraint (SYS.I_SQLOBJ$NAME_TYPE) violated (Doc ID 1083811.1)

Last updated on JANUARY 03, 2017

Applies to:

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


Problem Statement:

Trying to add a new Descriptive FlexField value to an Element Entry, at SAVE the following error is seen:

APP-FND-01206 This record already exists

When attempting to update the same record using the Update_Element_Entry API.(in correction mode), the API call fails with:

APPS.PAY_ELEMENT_ENTRY_API.UPDATE_ELEMENT_ENTRY. Element_entry_id = 91314 object_version_number =3 ORA-00001: unique constraint (SYS.I_SQLOBJ$NAME_TYPE) violated


Recent DB upgrade to 11g.


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.