How to run EBS Oracle Time and Labor (OTL) Analyzer as a Concurrent Request (Doc ID 1589250.1)

Last updated on DECEMBER 09, 2022

Applies to:

Goal

This is an Addendum to <Note 1580490.1> - OTL Analyzer. This Document will guide the user through the steps to register and configure the Oracle EBS OTL Analyzer Tool (named otl_analyzer_cp.sql) to be executed as a standard Concurrent Request from EBUsiness Suite R12. This is one time setup, but you will need to periodically update the otl_analyzer_cp.sql with the latest version from this note.
Currently, manual execution of the existing script (otl_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 OTL Analyzer as a single request, or schedule periodically without the need of SQL access or the Applications Owner (APPS) password.

Solution

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