How to run EBS Oracle Time and Labor (OTL) Analyzer as a Concurrent Request
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.
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.
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