I am a newbie in OAF.
We have a OAF page based on a table with some records. If a user click on update button for some record a new page is opened and his "USERNAME" goes to the "LOCKED_BY" column in that table. When user click the save button the records are updated and the lock is released by updating the "LOCKED_BY" column to null.
If another user tries to update the same record for which "LOCKED_BY" column is not null, He gets a message that the 'table is locked by some other user'.
Everything works fine but We need to release lock on this screen as soon as user close screen.
So please suggest me some other technique for locking the table.