Could Not Reserve Record [2 Tries] Keep Trying?
Last updated on JUNE 28, 2017
Applies to:Oracle Advanced Supply Chain Planning - Version 12.1.3 and later
Information in this document applies to any platform.
*** Checked for currency on 26-JUN-13 ***
Two distinct symptoms
1) User1 goes into the workbench and queries item - and scrolls down to see lines appear that are order type = Sales Order
-- User1 does not click release or do anything but scroll down the screen...
User2 goes into the workbench and queries the same item.
-- User2 scrolls down and as soon as they get to part of workbench where the sales order line would appear, they get stuck in a loop of error messages and have to kill the session.
Decision window opens with message "Could not reserve record [2 tries]. Keep
trying?". Click yes and same message (except [4 tries], then [6 tries]
If you click on No, error message FRM-40501: ORACLE error: unable to reserve record for update or delete.
If you click on OK, the decision box pops up again Could not reserve record
And the user is hung in a perpetual loop.
2) Concurrent Workbench exports will hang until the Original Export completes
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 hundreds of Community platforms