My Oracle Support Banner

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

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
Goal
Solution
 1) Copy the script into the source ($PRODUCT_TOP/sql) directory
 2) Modify script_name.sql script
 3) Create a new Executable (SCRIPT_SQL)
 4) Define a new Concurrent Program (Data Collection Script)
 5) Add the new Script Program to the Responsibility's Request Group.
 6) Submit a new 'Data Collection Script' 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.