5 Replies Latest reply: Dec 4, 2012 11:56 PM by Hussein Sawwan-Oracle RSS

    Posting Program performance issue in General Ledger

    977159
      The program has been running long since the past few days. it used to take 23 mins but now it runs for around 40 mins.
      I checked the log file and found that it is taking more time in glpibr.concurrency() (around 9 mins) and for glpidb() to start after glpibr.concurrency() it took 10 mins.
      earlier it used to take around 3 mins for glpibr.concurrency() and 5 mins for glpidb() to start after that. I am not able to figure out why the program is running long.
        • 1. Re: Posting Program performance issue in General Ledger
          Srini Chavali-Oracle
          Pl post details of OS, database and EBS versions.

          There are many causes and reasons for posting performance issues. Pl see if this MOS Doc can help

          GLPPOS Module: Posting Program is Hanging on glpubr.concurrency() Routine [ID 1096873.1]

          HTH
          Srini
          • 2. Re: Posting Program performance issue in General Ledger
            Hussein Sawwan-Oracle
            Please enable trace and generate TKPROF file to find out why it takes that long to run.

            How To Trace a Concurrent Request And Generate TKPROF File [ID 453527.1]
            Quick Instructions For Obtaining A Trace And TKPROF For A Receivables Concurrent Program [ID 1088236.1]
            How to get a Trace first And Begin to Analyze a E-Business Applications Performance Issue [ID 117129.1]
            FAQ: Common Tracing Techniques in Oracle E-Business Applications 11i and R12 [ID 296559.1]

            Can you find any errors in the database log file? Any locks in the database?

            Thanks,
            Hussein
            • 3. Re: Posting Program performance issue in General Ledger
              977159
              I cannot get the trace from production but I tried to reproduce the same issue in development by processing the same file.The same issue got reproduced.
              Two Posting programs were running in parallel. When for one of them insert into gl_daily_balances was running the other program was in glpibr.concurrency(). it was in this concurency for 10 mins till the insert inthe other program completed. During this concurrency there was a SELECT from gl_concurrency_control and update on gl_translation_statuses.

              In Posting 1
              glpibr() 04-DEC-2012 06:32:33
              glpibr.concurrency() 04-DEC-2012 06:32:33
              << glpibr.concurrency() 04-DEC-2012 06:42:02
              glpidb() 04-DEC-2012 06:53:17
              << glpidb() 04-DEC-2012 06:56:55

              << glpibr() 04-DEC-2012 06:56:55

              In Posting 2
              glpibr() 04-DEC-2012 06:26:12
              glpibr.concurrency() 04-DEC-2012 06:26:12
              << glpibr.concurrency() 04-DEC-2012 06:26:12
              glpidb() 04-DEC-2012 06:37:20
              << glpidb() 04-DEC-2012 06:42:02

              << glpibr() 04-DEC-2012 06:42:02


              Between << glpibr.concurrency() 04-DEC-2012 06:42:02 and >> glpidb() 04-DEC-2012 06:53:17 there is INSERT into gl_balances.
              Between >> glpidb() 04-DEC-2012 06:53:17 and << glpidb() 04-DEC-2012 06:56:55 there is INSERT into gl_daily_balances.
              • 4. Re: Posting Program performance issue in General Ledger
                Hussein Sawwan-Oracle
                974156 wrote:
                I cannot get the trace from production but I tried to reproduce the same issue in development by processing the same file.The same issue got reproduced.
                Two Posting programs were running in parallel. When for one of them insert into gl_daily_balances was running the other program was in glpibr.concurrency(). it was in this concurency for 10 mins till the insert inthe other program completed. During this concurrency there was a SELECT from gl_concurrency_control and update on gl_translation_statuses.
                If you can reproduce the issue in the development environments then please enable trace/debug and generate the TKPROF file.

                Thanks,
                Hussein
                • 5. Re: Posting Program performance issue in General Ledger
                  Hussein Sawwan-Oracle
                  In addition to the the docs referenced above, please see:

                  Performance Issue with the General Ledger Posting Program [ID 1148207.1]
                  Optimal Number of Threads and Performance for General Ledger (GL) Posting R12.1.3 [ID 1390232.1]

                  Thanks,
                  Hussein