How to Run an .sql Script as Concurrent Request in E-Business Suite
(Doc ID 1575955.1)
Last updated on JULY 15, 2016
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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!