Could Not Reserve Record [2 Tries] Keep Trying? (Doc ID 1365424.1)

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 ***

Symptoms

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.

error loop:
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

Cause

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