5 Replies Latest reply on Apr 19, 2016 10:40 AM by Beauty_and_dBest

    Can not process payment?

    Beauty_and_dBest

      Hi ALL,

       

      12.2.4

       

       

       

      All users complaining that they can't able to process customer payments.

      Error below appeared most of receipt applications.

      Capture.PNG

      What could be the reason?

      Is there any effects if the users are using multiple session, same access, and same form?

       

      Please help...

       

      Kind regards,

      jc

        • 1. Re: Can not process payment?
          Beauty_and_dBest

          I found this blog > FRM-40501: Could not reserve record [2 tries]; Oracle Apps Record-Locking - Blue Gecko

           

          But it does not say how to kill the blocker or offender

           

          Does this mean stop/start or bounce the instance can help?

           

           

           

          Kind regards,

          • 2. Re: Can not process payment?
            Pravin Takpire

            APXINWKB APP-10771 Could Not Reserve Records Due to Database Record Lock (Doc ID 140969.1)

            Check this.

            Start/Stop bounce of the instance will help but it is not optimal solution.

            regards

            Pravin

            1 person found this helpful
            • 3. Re: Can not process payment?
              Bashar.

              Use this query to find out the locked objects and generate the kill command for the ones causing the error:

               

              select b.sid, b.serial#, b.status, lockwait, b.username, a.object_name, b.osuser, b.machine, b.program, module, action, logon_time, 'alter system kill session ''' || b.sid || ',' || b.serial# || ''';' kill_command

              from dba_objects a, v$session b, v$locked_object c

              where a.object_id = c.object_id

                and b.sid = c.session_id

                and username = 'APPS'

                and a.object_type = 'TABLE'

                and a.owner = 'AR'

              order by sid,serial#;

               

              Regards,

              Bashar

              1 person found this helpful
              • 4. Re: Can not process payment?
                Wulfhart Thiel

                All Sessions who wait for another session delivers a quick overview the Data Dictionary View DBA_WAITERS. In the system few entries which should not be to be seen then also after few seconds any more should be to be seen in this View only very much. Speak: A session waits only briefly for a resource which is blocked by another session.

                 

                SQLPLUS>

                 

                SELECT holding_session, mode_held, waiting_session

                  FROM dba_waiters

                ORDER BY holding_session;

                 

                If this list grows or some entries continuously continue, the blocking session with utllockt.sql should be examined (Script is to be found under oracle home/admin). The Script generates a tree-like Structur what is to be seen which session by which is blocked from. one dissolve of the block scenario is thereby quickly possible.

                1 person found this helpful
                • 5. Re: Can not process payment?
                  Beauty_and_dBest

                  Thanks ALL

                   

                  Issue resolved when personalization was disabled and running of Create Accounting was set to "once a day"  instead of setting it to run every 5 minutes.