Debug Table INDEX Constraint Issues ORA-00001 unique constraint violated (Doc ID 286311.1)

Last updated on OCTOBER 12, 2017

Applies to:

Oracle Advanced Benefits - Version 11.5.10.2 and later
Oracle Payroll - Version 11.5.10.2 and later
Oracle Human Resources - Version 11.5.10.2 and later
Oracle HRMS (US) - Version 11.5.10.2 and later
Oracle Self-Service Human Resources - Version 11.5.10.2 and later
Information in this document applies to any platform.
NOTE: This can be used across all EBS applications to include but not limited to: HCM, Financials, Projects, Manufacturing, Inventory, etc.

Symptoms

Trying to change data and receive

ORA-00001: unique constraint violated

 

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