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

Last updated on SEPTEMBER 08, 2017

Applies to:

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

Goal

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.

Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms