There is one table INVENTORY which is being updated via job.
There is a screen built using ADF 12.2.1.2.0 version. Users have ability to update (ADF BC) this table data via screen.
The requirement is to acquire a lock when user clicks SAVE button on the screen. At the same time, if the JOB runs and tried to update the data it should fail to do so.
I am looking for the solution where in the lock is acquired on table row when user performs save operation and after commit it is released.