How to Run an .sql Script as Concurrent Request in E-Business Suite (Doc ID 1575955.1)

Last updated on JULY 15, 2016

Applies to:

Oracle Concurrent Processing - Version 11.5.1 to 12.1.3 [Release 11.5 to 12.1]
Information in this document applies to any platform.

Goal

What are the steps to register and configure an sql script to be executed as a standard Concurrent Request from Oracle Applications.

Manual execution of the existing script requires a System Administrator or DBA user with access to SQL*Plus and Applications Owner (APPS) password. The creation of the 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 script as a single request, or schedule periodically without the need of SQL access or the Applications Owner (APPS) password.

So instead of using:

you can define a concurrent request to do this job.

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