Record is Locked if the Form is Closed by Clicking the IE Browser “X”

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
value.
Problem reproduces when using Sun JRE 1.6.0 (1.6.0_13)

Problem does not reproduce using Jinitiator 1.3.1.30 or Sun JRE 1.5.0 (1.5.0_16)

Changes

Upgrade JPI

Cause

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.

Solution

Use Sun JRE 1.6.0_14.

The problem does not reproduce using JRE 1.6.0_14.

Ref:   Metalink Doc [ID 844537.1]

Advertisements

About Sher khan

Senior Oracle DBA, Oracle 10g , Oracle 11g OCE ,Oracle 12C and Oracle 11g OPN certified Specialist, OCP Certified in Oracle 9i,10g , 11g and 12C. I am working in Oracle technology since 2004. Currently working in U.A.E Email: sher487@hotmail.com
This entry was posted in Oracle Application server. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s