1 2 Previous Next 25 Replies Latest reply on Nov 3, 2019 11:27 AM by Beauty_and_dBest Go to original post
      • 15. Re: EBS Performance Issue
        mdtaylor

        Hi jc,

         

        Here is the PROD EBS environment located?  Is it using SMTP on the EBS Linux server or some other server? 

         

        Please login to Oracle Applications Manager, then Workflow and ensure all Workflow processes are scheduled:

         

        Screen Shot 2019-10-15 at 1.09.58 PM.png

         

        Open the Workflow Notification Mailer concurrent Manager log and look for errors.  You can do this in Oracle Applications Manager or Administer Manager forms.

         

        Oracle Workflow Release 12 Diagnostics (Doc ID 469822.1)

         

        select recipient_role, count(*) from wf_notifications where  mail_status = 'MAIL' and status = 'OPEN'

        group by recipient_role order by count(*) desc;

         

        select recipient_role, count(*) from wf_notifications where status = 'OPEN' and mail_status = 'FAILED'

        group by recipient_role order by count(*) desc;

         

        Look to see if you have some excessive notifications that are hanging up the workflow mailer preventing PO notifications from processing in a timely manner.

         

        Regards,

        Michael

        • 16. Re: EBS Performance Issue
          Beauty_and_dBest

          Thanks Michael,

           

          We have separate email server.

           

          We will check that tasks you suggested....brb

           

          Hi Michael,

           

          I counted the  'OPEN'  mail and the total is  12,  while the FAILED ones are 134.

           

          How do I check what is the cause of their failure? Or what column in the Wf table shows the error?

           

          The  total count of the wf_notification table is 2,609,754.

          But if I count all mail_status='FAILED' , the clount is only 139? which is  negligible agains 2M?

           

           

          Please help ...

           

          Kind regards,

          • 17. Re: EBS Performance Issue
            Beauty_and_dBest

            Hi ALL,

             

            We have frmweb process that is consistently running at  100% cpu.

            How do I fix this, or check if this has error , or already runaway process?

             

            Please help...

             

             

            Kind regards,

            • 18. Re: EBS Performance Issue
              mdtaylor

              Hi jc,

               

              you should kill any frmweb session running at 100% CPU. It has already runaway and most likely the user has already reconnected. I will look for the auto kill scripts I have used.

               

              Regards,

              Michael

              • 19. Re: EBS Performance Issue
                Beauty_and_dBest

                Thanks Micheal,

                 

                Please share me the script, I am afraid to kill it as it might not really runaway

                I can not understand why Oracle not able to cleanup runaway frmweb process?

                To think that it is already in latest version tech stack, so they should have perfected this issue?

                 

                But would you think this has related to WF notification failure?

                 

                 

                Kind regards,

                • 20. Re: EBS Performance Issue
                  Beauty_and_dBest

                  Hi Kanda, and ALL,

                   

                  Re: $ sar -f /var/log/sa/sa19

                   

                  How do I plot it in a graph? so It is presentable to my boss to look at?

                   

                   

                  Kind regards,

                  • 21. Re: EBS Performance Issue
                    Kanda-Oracle

                    Hi

                    you get the o/p in a spreadsheet and may be able to create a graph.

                     

                    the idea is , when you get the sar output for a day or two.. you would get a pattern when it is slow..

                     

                     

                    Thanks!

                    • 22. Re: EBS Performance Issue
                      user587033

                      Hi,

                      Were you able to pinpoint the issue of point 5? We are also experiencing the same issue in our EBS environment. Some users getting different users login credentials to their EBS login form!

                      I appreciate if you could share any insights.

                       

                      Thank you.

                      • 23. Re: EBS Performance Issue
                        Beauty_and_dBest

                        Hi friend,

                         

                        Sorry I still not sure which one resolved the issue

                        Can you try increasing the ulimits?

                         

                         

                        Regards,

                        • 24. Re: EBS Performance Issue
                          user587033

                          Thanks for the reply. I will try that. Was it a client issue?

                          • 25. Re: EBS Performance Issue
                            Beauty_and_dBest

                            I think both, try CC cleaner on client pc/laptops

                             

                            And /etc/security/limits.conf

                            * soft    memlock       1048576

                            * hard    memlock       2097152

                            * soft    stack          131072

                            * hard    stack          131072

                            * hard    nofile          65535

                            * soft    nofile          65535

                            * hard    nproc           65535

                            * soft    nproc           65535

                             

                             

                            Regards,

                            1 2 Previous Next