My Oracle Support Banner

How to run EBS Payroll Analyzer as a Concurrent Request (Doc ID 1909330.1)

Last updated on DECEMBER 03, 2019

Applies to:

Oracle Payroll - Version to 12.2 [Release 11.5 to 12.2]
Information in this document applies to any platform.
This is an Addendum to - Payroll Analyzer.


This Document will guide the user through the steps to register and configure the Oracle EBS Payroll Analyzer (named pay_analyzer.sql) to be executed as a standard Concurrent Request from Oracle Applications.

Currently, manual execution of the existing script (pay_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 Payroll 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
 Follow these steps to register and run the Payroll Analyzer script as a concurrent program.
 1) Copy concurrent request file
 2) Create a new Concurrent Program (Payroll Analyzer)
 3) Add the new Payroll Analyzer Program to the Responsibility's Request Group.
 4) Submit a new 'Payroll Analyzer' Concurrent Request and Verify the output.
 Reporting Problems or Feedback

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