1 Reply Latest reply on Feb 12, 2016 7:24 AM by Jignesh Makwana

    Row locking

    Beauty_and_dBest

      Hi ALL,

       

      EBS R12.2.4

      11gR2

      OL6.5

       

       

      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?

       

       

      Kind regards,

      jc