My Oracle Support Banner

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:

Oracle Time and Labor - Version 12.0 and later
Information in this document applies to any platform.


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.


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
 1) Install the Analyzer by running otl_analyzer.sql as APPS to create the package definition.
 2) Create a new Concurrent Program (OTL Analyzer)
 3) Add the new OTL Analyzer Program to the Responsibility's Request Group.
 4) Submit a new 'OTL Analyzer' Concurrent Request and Verify the output.

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