Application error ORA-0001: unique constraint (AP.AP_INVOICES_U1) violated occurred in AP_AI_TABLE_H
We are testing our Oracle R12 environment and several of our Testers in different Operating Units have encountered this error while trying to enter/add a new Invoice in the Invoice Workbench:
APP-SQLAP-10000: ORA-0001: unique constraint (AP.AP_INVOICES_U1) violated occurred in AP_AI_TABLE_HANDLER_PKG.INSERT_ROW<-AP-INVOICES_PKG.INSERT_ROW<-APXINWKB
But when asked to re-create this error, they are not able to. I too am unable to reproduce the error.
According to the Testers who encountered the error above, the error did not happen again after they erase their entries and started over.
Please advice what could be causing this error message. Thanks.