Update of iSetup Preferences Or Create Preferences Throws Error JBO-26048: (Doc ID 2261961.1)

Last updated on MAY 05, 2017

Applies to:

Oracle iSetup - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, iSetup : Administration : Preferences : Update of preferences errors with:

Interface '&API_NAME' metadata has been changed. Your preference 'NMV Preferences 01' is no longer valid. Please create a new preference.

OR

Create Preferences with the existing interface throws error:

oracle.apps.fnd.framework.OAException: oracle.jbo.DMLConstraintException: JBO-26048: Constraint "AZ_API_PREF_SRC_ATTRIBUTE_B_U1" violated during post operation:"Insert" using SQL Statement "INSERT INTO AZ_API_PREF_SRC_ATTRIBUTES_B(ATTRIBUTE_CODE,CREATED_BY,CREATION_DATE,DATA_SOURCE,ENABLE_REPORT_FLAG,KEY_FLAG,LAST_UPDATED_BY,LAST_UPDATE_DATE,PREFERENCE_CODE) VALUES (?,?,?,?,?,?,?,?,?)".

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