5 Replies Latest reply: Jul 5, 2013 6:21 PM by Hussein Sawwan-Oracle RSS

    Bad performance with AP module

    User451228-OC

      hello all.

       

       

      have a performance problem with the AP module, is being very slow,

      is a very general case with all its functions but becomes slower in the case

      association specific purchase orders to invoices.

       

       

      Is there a note for a better performance of this?

      Can you recommend some patch?

       

      We have a EBS 11.5.10.2


      thanks


      best regards

        • 1. Re: Bad performance with AP module
          Hussein Sawwan-Oracle

          What is your database version? OS?

           

          Was the performance acceptable before? If yes, any changes been done since then?

           

          Is the issue with all forms/reports or with specific ones only? If the latter, please specify them.

           

          Do you have the statistics collected up to date?

           

          Please provide more details about which part of AP module is slow and whether you managed to enable trace and generate TKPROF files to get more details about this behavior.

           

          Thanks,

          Hussein

          • 2. Re: Bad performance with AP module
            User451228-OC

            hi Hussein

             

            We send the answers

             

            What is your database version? OS?

            DB: 10 g release 2

            OS: Linux Red HAt 4 Enterprice

             

            Was the performance acceptable before? If yes, any changes been done since then?

            all along

             

            Is the issue with all forms/reports or with specific ones only? If the latter, please specify them.

            relate only to the OC with the bill

             

            Do you have the statistics collected up to date?

            yes, we run the statistics

             

            Please provide more details about which part of AP module is slow and whether you managed to enable trace and generate TKPROF files to get more details about this behavior.

             

            Current Form

            ----------------------------------------

            Form Application : Payables

            Form Name : APXINWKB

            Form Path : /u01/oracle/fadevappl/ap/11.5.0/forms/US/APXINWKB.fmx

            Form Version : 11.5.1074

            Form Last Modified : $Date: 2010/02/01 05:30  $

            • 3. Re: Bad performance with AP module
              Hussein Sawwan-Oracle

              What AP patchset level you are on?

               

              What part of this form is slow? Please obtain the TKPROF file.

               

              There are many hits on MOS website that is related to this form -- Search MOS for (APXINWKB AND Performance) and go through the docs.

               

              If you want to get the latest version of the form, please let me know and I will provide you with the patch number.

               

              Thanks,

              Hussein

              • 4. Re: Bad performance with AP module
                User451228-OC

                What AP patchset level you are on?

                11i.AP.O(4551936)

                 

                we are gonna to validate in MOS

                • 5. Re: Bad performance with AP module
                  Hussein Sawwan-Oracle

                  Please obtain TKPROF file as suggested before.

                   

                  You may also review:

                   

                  Performance: Selecting A Supplier During Invoice Entry Takes Up To 30 Seconds [ID 786416.1]

                  APXINWKB Performance Issue When Trying To Release Holds [ID 981458.1]

                  11i: APXINWKB - Invoice Query Performance Unacceptable [ID 973605.1]

                  REL 11i - APXINWKB Performance Problem: Slow Response Querying Invoices in Invoice form [ID 1269912.1]

                   

                  Thanks,

                  Hussein