INVIDITM: FRM-40501:ORACLE ERROR: UNABLE TO RESERVE RECORD FOR UPDATE OR DELETE (Doc ID 1068405.1)

Last updated on AUGUST 21, 2016

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

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