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

Last updated on MAY 16, 2017

Applies to:

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

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

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