My Oracle Support Banner

FRM-40501: ORACLE error: Unable to reserve record for update or delete in OKSAUDET.fmb (Doc ID 412050.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Service Contracts - Version 11.5.9 to 11.5.10.2 [Release 11.5]
Information in this document applies to any platform.
Checked for relevance on 15-Nov-2013


Symptoms

-- Problem Statement:
On 11.5.9 in Production:
When attempting to open an active contract for update, the following error occurs:

ERROR
"Could not reserve the record(2 tries). Keep Trying?"
Click on 'No' , then get FRM-40501: ORACLE error: unable to reserve record for update


-- Steps To Reproduce:
The issue can be reproduced at will with the following steps:
1. Go to 'Service Contracts manager' responsibility
2. Navigator--> Launch Pad
3. Click on View--> Find and Enter the contract Number 'SVC00000031'
4. Hit 'Search' Button
5. From the query results section , right click and open the contract.
6.Click on 'Open for Update' button to open the contract for update from
7.Summary-->Parties tab
8.Click on 'OK' button from the confirmation window
9. Getting the Message as "Could not reserve the record(2 tries). Keep Trying?"
10. Once I click on 'No' , then getting the FRM-40501: ORACLE error: unable to reserve record for update
11. Then, the "Open for Update" button on the form disappeared

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.