My Oracle Support Banner

How to run ASCP Performance Analyzer Tool as a Concurrent Request (Doc ID 1556409.1)

Last updated on OCTOBER 20, 2019

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.1.1 and later
Information in this document applies to any platform.


This is an Addendum to Note 1554183.1 - ASCP Performance Analyzer script for E-Business Suite ASCP Monitoring and Maintenance. This Document will guide the user through the steps to register and configure the Oracle ASCP Performance Analyzer Tool (named ascp_perf_analyzer.sql) to be executed as a standard Concurrent Request from Oracle Applications.

Currently, manual execution of the existing script (ascp_perf_analyzer.sql) requires a System Administrator or DBA user with access to SQL*Plus and Applications Owner (APPS) password. The creation of this Concurrent Request needs to be performed by a System Administrator; however, this will be a one time task. Once installed, end users with the proper Responsibility will have the ability to execute the ASCP Performance Analyzer Tool as a single request, or schedule periodically without the need of SQL access or the Applications Owner (APPS) password.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
 Follow these steps to register and run the ASCP Performance Analyzer script as a concurrent program.
 1.) Copy the latest version of ascp_perf_analyzer.sql from Note 1554183.1 into the source ($MSC_TOP/sql) directory.
 3.) Define a new Concurrent Program (ASCP Performance Analyzer Tool)
 4.) Add the new ASCP Performance Analyzer Program to the Responsibility's Request Group.
 5.) Submit a new 'ASCP Performance Analyzer Tool' Concurrent Request and Verify the output.
 Error in concurrent request MSCACA_SQL: EBS Advanced Supply Chain Planning (ASCP) Setup and Performance Monitoring Analyzer Analyzer

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.