FRM-40501:Oracle Error:&nbs…

INVIDITM: FRM-40501:ORACLE ERROR: UNABLE TO RESERVE RECORD FOR UPDATE OR DELETE [ID 1068405.1] 转到底部 

--------------------------------------------------------------------------------

修改时间:2010-9-14类型:PROBLEM状态:PUBLISHED优先级:3 注释 (0)    
 

In this Document
  Symptoms
  Cause
  Solution

 

--------------------------------------------------------------------------------

 

Applies to:
Oracle Item Master - Version: 11.5.10.2 and later   [Release: 11.5 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
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
The issue is caused by the following setup: Profile Option Flexfields:Shared Table Lock is set to Null Values

And there were blocking / blocked sessions locking the mtl_system_items_b table.

 

Solution
To implement the solution, please execute the following steps:

1. Go into the responsibility: System Administrator

2. Navigate to Profile / System.

3. Query Profile Option Flexfields:Shared Table Lock and set the value at the Site level to Yes

4. Run the following script to determine if there are current blocking sessions running in the application.

select sid,
decode(block ,0,'NO','YES') BLOCKER,
decode(request,0,'NO','YES') WAITER
from v$lock
where request > 0 or block > 0 order by block desc;

5. Kill any Blocking Sessions and rerun script to confirm no more Locks

6. Retest the issue.

7. Migrate the solution as appropriate to other environments.