Error:- APP-SQLAP-10771: Could not reserve record.

02:15 0 Comments A+ a-



Error:- APP-SQLAP-10771: Could not reserve record.

Solution :-

Step (1) Run the query given below-:

SELECT vlo.object_id, vlo.session_id, substr(dbo.object_name, 1, 40) OBJECT_NAME
FROM v$locked_object vlo, dba_objects dbo
WHERE vlo.object_id = dbo.object_id
AND dbo.object_name like 'AP_%'
ORDER BY dbo.object_name;

Output look likes-:

OBJECT_ID
SESSION_ID
OBJECT_NAME
41097
495
AP_INVOICES_ALL

Step (2)  Now again Run the Query given below-:

SELECT l.*, ao.owner object_owner, ao.object_name
FROM SYS.all_objects ao, v$lock l
WHERE l.TYPE = 'TM'
AND ao.object_id = l.id1
AND ao.object_name in ('AP_ALLOCATION_RULES','AP_ALLOCATION_RULE_LINES','AP_INVOICES_ALL','AP_INVOICE_DISTRIBUTIONS_ALL','AP_INVOICE_LINES_ALL');

Output:-

ADDR
KADDR
SID
TYPE
ID1
ID2
LMODE
00000003BDC546F0
00000003BDC54748
495
AE
352852
0
4


REQUEST
CTIME
BLOCK
OBJECT_OWNER
OBJECT_NAME
0
13825
0
AP
AP_INVOICE_ ALL
 


Step (3)  Now again Run the Query given below-:


SELECT SID, SERIAL#
FROM v$session
where sid='495'   


Note-: SID should be =< SID from dba_objects Table

Output :- 

SID
SERIAL#
495
19801


Step (4)  Now again Run the Query given below-:

ALTER SYSTEM KILL SESSION '495,18758' IMMEDIATE


Error:- APP-SQLAP-10771: Could not reserve record.

For More Information Visit on www.OracleAppsGuide.comOr Subscribe your email-id on OracleAppsGuide