ORA-00001 unique constraint violated

ORA-00001 unique constraint violated

by

Introduction: – While cloning, we just faced the error as ORA-00001 unique constraint violated. In autoconfig log showing as java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (APPLSYS.FND_DATABASE_INSTANCES_U1) violated ORA-06512: at “APPS.FND_APP_SYSTEM”, line 507 ORA-06512: at “APPS.FND_NET_SERVICES”, line 951 ORA-06512: at line 1. Why ORA-00001 unique constraint APPLSYS.FND_DATABASE_INSTANCES_U1 violated? After looking through many autoconfig logs, we came to the … Read more