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

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

    2db13fe1-2a0b-4beb-be3f-425532a5e54a

      Hi,

       

      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.

       

      Thanks

      Deepti