7 Replies Latest reply on Nov 11, 2019 9:51 AM by Beauty_and_dBest

    EBS 12.1.3 - Sales Report Concurrent Program

    Beauty_and_dBest

      EBS 12.1.3

      11.1.0.7

      OL6

       

      Hi ALL,

       

      We have a custom Sales Report that usually runs for 3 hours, but last night it runs for 10 hours.

      How do I trace the report if it needs new indexing?

      How do I use Statspack to analyze this report as a concurrent program?

      Can I use TKPROF to analyze this report?

      How do I enable tracing in a concurrent program?

      What other ways can I make it improve its performance?

       

       

      Please help....

       

      Kind regards,

      jc