My Oracle Support Banner

How to Run EBS CP Analyzer Tool as a Concurrent Request (Doc ID 2012350.1)

Last updated on NOVEMBER 09, 2023

Applies to:

Oracle Concurrent Processing - Version 11.5.10.2 to 12.2.4 [Release 11.5 to 12.2]
Information in this document applies to any platform.

Goal

This is an Addendum to Note 1411723.1 - CP Analyzer script for E-Business Suite. This Document will guide the user through the steps to register and configure the Oracle EBS CP Analyzer Tool (named cp_analyzer.sql) to be executed as a standard Concurrent Request from Oracle Applications.

Currently, manual execution of the existing script (cp_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 CP Analyzer Tool as a single request, or schedule periodically without the need of SQL access or the Applications Owner (APPS) password.

Solution

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
Goal
Solution
 Follow these steps to register and run the CP Analyzer script as a concurrent program.
 1.) Copy the latest version of cp_analyzer.sql from Note 1411723.1 into the source ($FND_TOP/sql) directory.
 2.) Create a new Executable (CP_ANALYZER_SQL)
 3.) Define a new Concurrent Program (CP Analyzer Tool)
 4.) Add the new CP Analyzer Program to the Responsibility's Request Group.
 5.) Submit a new 'CP Analyzer Tool' Concurrent Request and Verify the output.
 6.) Schedule The CP Analyzer Tool Concurrent Request to Run Periodically
 Optional Method to use FNDLOAD to load the Concurrent Processing Analyzer as a Concurrent Program
References

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