Error: The INSERT statement conflicted with the FOREIGN KEY constraint “FK_BATCHREVENUEADDITIONALAPPLICATIONS_OPPORTUNITYID”. The conflict occurred in database “<NAME>, table “dbo.OPPORTUNITY”, column’ID’."

When validating a revenue batch, users may receive the exception "The INSERT statement conflicted with the FOREIGN KEY constraint "FK_BATCHREVENUEADDITIONALAPPLICATIONS_OPPORTUNITYID". The conflict occurred in database "BBTAS", table "dbo.OPPORTUNITY", column’ID’" for specific rows in the batch.  If the batch is closed and re-opened, this exception will no longer appear.

Download and install the latest version and patch, if applicable. 

Environment

 2.9.1001.45
 2.93.2034

Was this article helpful?