4 Replies Latest reply: Dec 7, 2013 11:28 AM by Q_STEPHENSON RSS

    ORA-00001 - Unique Constraint error in Oracle forms 6i




      I am using Forms 6i. I have an issue while inserting records into a custom table.  Below is the functionality.


      When I check the check box,  and press the 'APPROVE' button, the record gets inserted into the custom table. But while inserting I am getting 'ora-00001-unique constraint violated error'.


      But the custom table doesn't have any data in it. (So the inserting record should not be a duplicate record).


      Any suggestions would be of great help.