FRM-40501:Oracle Error:&nbs…

INVIDITM: FRM-40501:ORACLE ERROR: UNABLE TO RESERVE RECORD FORUPDATE 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 andlater   [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 andlater
Symptoms
When Multiple users try to create new item master records, thefollowing error occurs:

ERROR:
======

FRM-40501:Oracle Error: Unable to Reserve Record for Update orDelete.

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 OptionFlexfields:Shared Table Lock is set to Null Values

And there were blocking / blocked sessions locking themtl_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 thevalue at the Site level to Yes

4. Run the following script to determine if there are currentblocking 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 nomore Locks

6. Retest the issue.

7. Migrate the solution as appropriate to otherenvironments.