My Oracle Support Banner

"FRM-40501 Unable To Reserve Record For Update" Error In Recipe Form When Two Users Try to Access Same Recipe (Doc ID 2932816.1)

Last updated on MARCH 03, 2023

Applies to:

Oracle Process Manufacturing Product Development - Version 12.2.10 and later
Information in this document applies to any platform.


On : 12.2.10 version:

When two users are accessing the same recipe in two different sessions, the second user receives the messages below on the Recipe form. This occurred after upgrade from 12.1.3 to 12.2.10. It worked correctly in 12.1.3.

 "Could not reserve record [2 tries]. Keep trying?"  (User responses No)
 "FRM-40501:Oracle error unable to reserve record for update or delete."

The issue can be reproduced at will with the following steps:
1. Responsibility: Formulator
2. Navigation: Recipes
3. Two users open the same recipe on the form. Second user receives above messages.


 Upgrade from 12.1.3 to R12.2.10


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

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

In this Document

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