Error:- APP-SQLAP-10771: Could not reserve record.
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
