Users have been experiencing row locking issues today?
I check the blocking session, and I found this:
12-FEB-2016 15:09:09 User APPS@prodapp.local ( SID= 17 ) with the statement: SELECT COUNT (*) FROM AP_INVOICE_LINES_ALL WHERE INVOICE_ID = :b1 AND ROWNUM = 1
is blocking the SQL statement on
APPS@prodapp.local ( SID=220 ) blocked SQL -> UPDATE AP_PAYMENT_SCHEDULES SET AMOUNT_REMAINING = AMOUNT_REMAINING - AP_UTILITIES_PKG.AP_ROUND_CURRENCY( :B7 , :B6 ), PAYMENT_STATUS_FLAG = DECODE(AMOUNT_REMAINING - AP_UTILITIES_PKG.AP_ROUND_CURRENCY( :B7 , :B6 ), 0,'Y', ((GROSS_AMOUNT / :B5 ) * (:B5 - NVL(AP_INVOICES_PKG.GET_AMOUNT_WITHHELD(:B2 ),0))), 'N', 'P'), LAST_UPDATE_DATE = SYSDATE, LAST_UPDATED_BY = :B4 , LAST_UPDATE_LOGIN = :B3 WHERE INVOICE_ID = :B2 AND PAYMENT_NUM = :B1
Why is a counting sql blocks?