The below code is the simplest way of doing a job submission for a concurrent program in eBusiness Suite:
CONCSUB <db user>/<db password> <user> <role> <application group> WAIT=<Y|N> CONCURRENT <application> <application short name> PROGRAM_NAME="<long name>"
So, as an example take the following command:
CONCSUB apps/<password> SYSADMIN "System Administrator" SYSADMIN WAIT=N CONCURRENT FND FNDSCURS PROGRAM_NAME='"Active Users"'
What this command means is:
- to run a job as the user “SYSADMIN”,
- using the “System Administrator” responsibility
- from the “SYSADMIN” application group,
- without waiting for it to complete.
- it should submit a concurrent program
- from the application “FND”
- which has the short name of “FNDSCURS”
- and the program name of “Active Users”
This approach is going to be good for shell scripts that need to schedule things easily. However, if some more complex is going on (e.g. database information needs to be merged into the parameter) then it’s not going to help much. In this case, it is much easier to do that totally using PL/SQL.