My Oracle Support Banner

INVIDITM.fmb FRM-40501:Oracle Error: Unable to Reserve Record for Update or Delete (Doc ID 1068405.1)

Last updated on FEBRUARY 15, 2018

Applies to:

Oracle Item Master - Version 11.5.10.2 and later
Information in this document applies to any platform.
Form:INVIDITM.FMB - Define Item Information
This document includes all versions of Oracle EBS 11i and R12 and later
FRM-40501:Oracle Error: Unable to Reserve Record for Update or Delete
blocking / blocked sessions locking the mtl_system_items_b

Symptoms

When Multiple users try to create new item master records, the following error occurs:

ERROR:
======
FRM-40501:Oracle Error: Unable to Reserve Record for Update or Delete.

STEPS TO REPRODUCE:
===================
1) Inventory / Items / Master Items
2) Have several users create items at the same time.
3) Sessions become locked and the error is presented.

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!


In this Document
Symptoms
Cause
Solution
References


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