Introducing Concurrent Processing Analyzer

In many instances, to get holistic view of concurrent processing in Oracle E-Business Suite we either use Applications Management Pack (AMP) or run several scripts and analyze the results to determine the health of CP. I guess the wait is finally over. Oracle has come up with Concurrent Processing Analyzer (CPA) for EBS, a solid tool that can give you not only a holistic view of concurrent processing, but also provides recommendations based on best practices that can fit the environment. Interestingly, this is a non-invasive script that can be run in production too.

Concurrent Processing Analyzer benefits are categorized into 4 and they are

  • Helps to identify concurrent system setup and configurations
  • Analysis and output of concurrent environment
  • Identifies and recommends concurrent best practices
  • and more importantly regular concurrent maintenance to compare trending.

Some of the benefits that we have realized by taking advantage of this tool are

  • Number of eligible records in FND_CONCURRENT_REQUESTS that can be purged.
  • Current list of patches in the system
  • Volume of daily concurrent requests
  • Request managers with Incorrect Cache size
  • Long running reports during core business hours
  • Based on current concurrent processing, it helps to identify possible bottlenecks with recommendations to resolve those based on best practices.

Here is a screen shot of the tool


To get comprehensive list of benefits that can be realized by CPA, please refer to MOS note

 Concurrent Processing – CP Analyzer for E-Business Suite [ID 1411723.1]

Kudos to ATG proactive support team. 


About Sunthar Tharmalingam
Bio: Sunthar is an Oracle Certified Professional with over 14 years of experience in multifaceted architectural design and implementation of mission-critical global Oracle Applications. He provides technical leadership to the enterprise project teams and manages the comprehensive implementation life-cycle. Sunthar has exhaustive hands-on competencies in vital Oracle technologies such as Oracle E-Business Suite, Databases, OBI Applications, Oracle Identity Management and Webcenter suites. This Blog has been categorized according to the Oracle products that integrates with Oracle E-Business Suite. Should you wish to participate as an author for a related module or category please register as a member and mail me to let me know which category you would like to write under.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: