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.