How to Run an .sql Script as Concurrent Request in E-Business Suite
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.
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.
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