FRM-40501, ORA-00054 When Trying to Use Work In Process (WIP) or Enterprise Asset Management (EAM) Forms
Last updated on MARCH 08, 2017
Applies to:Oracle Enterprise Asset Management - Version 184.108.40.206 to 12.1.3 [Release 11.5 to 12.1]
Oracle Work in Process - Version 11.5.9 to 12.1.3 [Release 11.5 to 12.1]
Information in this document applies to any platform.
FORM:WIPDJMDF.FMB - Define Discrete Job
FORM:EAMWOMDF.FMB - EAM Work Order Definition
FORM:WIPTXCMP.FMB - Completion Transactions
FORM:EAMWOCMP.FMB - EAM Work Order Completion
FORM:EAMRSMDF.FMB - EAM Resource Requirements
FORM:WIPTXMAT.FMB - WIP Material Transactions
-- Problem Statement:
On 11.5.9 in Production:
When attempting to cancel a discrete job
Could not reserve record (2 tries)
FRM-40501: Oracle Error Unable to reserve record for update or delete.
Or, for a concurrent request, you may see:
ORA-00054 : resource busy and acquire with NOWAIT specified
-- Steps To Reproduce:
The issue can be reproduced at will with the following steps:
1. WIP: Discrete: Discrete Jobs
2. Enter org and find the job
3. Tools Change Status 1: Cancel (or close...)
5. You will see the message Could not reserve record [2 tries]. Keep Trying?. Eventually, you will answer no.
Please note that this can happen in ANY WIP or EAM form.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms