Friday, August 1, 2014

FDPSTP failed due to ORA-00001

ORA-00001

FDPSTP failed due to ORA-00001 : unique constraint (index_name) VIOLATED

FDPSTP failed due to ORA-00001 : unique constraint (FAH.SYS_C00201026) VIOLATED


I have come across this error while i was running the concurrent program to insert the client data into other table.

This occurs when you try to execute an INSERT or UPDATE statement that has created a duplicate value in a field restricted by a unique constraint.

The option(s) to resolve this Oracle error are :
  • Option1 is to Drop the unique constraint. 
  • Option2 is to Change the constraint to allow duplicate values. 
  • Option3 is to Modify your SQL so that a duplicate value is not created.
If you are not sure which unique constraint was violated, you can run the following SQL:

SELECT DISTINCT table_name
FROM all_indexes
WHERE index_name = 'SYS_C00201026';


To find the column and the position of it on which the unique constraint was violated run the below query :


SELECT column_name, position
FROM all_cons_columns
WHERE constraint_name = 'SYS_C00201026' --INDEX_NAME
AND owner = 'APPS' --OWNER
AND table_name = 'XX _FINC_TRANSACTIONS_TEMP'; --TABLE_NAME




Challa.

No comments:

Post a Comment