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.com Or Subscribe your email-id on OracleAppsGuide