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.

Symptoms

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

Changes

Recent DB upgrade to 11g.

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