After updating a record and not saving, if the form is closed by clicking the IE browser “X”, the record is locked. The user cannot update that record when he runs the same form again.
The error below occurs when the user runs the form again and tries to update that record:
FRM-40501: Oracle error: unable to reserve record for update or delete.
Help=>Display Error shows error: ORA-00054: resource busy and acquire with NOWAIT specified
The record is locked until the related frmweb process is terminated based on the FORMS_TIMEOUT
Problem reproduces when using Sun JRE 1.6.0 (1.6.0_13)
Problem does not reproduce using Jinitiator 220.127.116.11 or Sun JRE 1.5.0 (1.5.0_16)
This is due to BUG 8454193 – CLOSING THE FORM BY CLICKING THE IE BROWSER ‘X’ LOCKS THE RECORD WHEN USING JPI 1.6
This is a bug with the Sun JRE and not with Forms so it has been closed as not a Forms bug.
Use Sun JRE 1.6.0_14.
The problem does not reproduce using JRE 1.6.0_14.
Ref: Metalink Doc [ID 844537.1]