How to Control Row Removal in ADF BC by Andrejus Baranovskis

There is a flaw in ADF BC remove operation. Row could be successfully removed in ADF BC – it dissapears from UI as well, but if there is DB integrity constraint violation – row is not removed in DB and error message is displayed to the user. This could be misleading to the user, he sees message about failed removal, but at the same time row is not present anymore. Easier to explain with example. Let’s imagine we want to remove IT_PROG job (there are employees assigned with this job and row removal would fail in DB):