Submit a Concurrent Request Using CONCSUB

Introduction: CONCSUB is a utility to submit the concurrent request from operating system level to run concurrent program, without having to log on to oracle applications.

Syntax:
CONCSUB <APPS username>/<APPS password> \
<responsibility application short name> \
<responsibility name> \
<username> \
[WAIT=N|Y|<n seconds>] \
CONCURRENT \
<program application short name> \
<program name> \
[PROGRAM_NAME=”<description>”] \
[REPEAT_TIME=<resubmission time>] \
[REPEAT_INTERVAL= <number>] \
[REPEAT_INTERVAL_UNIT=< resubmission unit>] \
[REPEAT_INTERVAL_TYPE=< resubmission type>] \
[REPEAT_END=<resubmission end date and time>] \
[START=<date>] \
[IMPLICIT=< type of concurrent request> \
[<parameter 1> ... <parameter n>]

You will find the CONCSUB executable under location $FND_TOP/bin/

Purpose:

The usage of CONCSUB can be categorized into the following.

• Submitting Concurrent Requests
• Controlling Concurrent Managers

Submitting Concurrent Requests: CONCSUB is used to submit both the standard and custom concurrent requests from operating system level. The following is an example to submit "Active Users" request.

CONCSUB APPS/APPS SYSADMIN “System Administrator” SYSADMIN WAIT=N CONCURRENT FND FNDSCURS PROGRAM_NAME='"Active Users"'

Controlling Concurrent Managers: COCNSUB is also used to shutdown the concurrent managers, however to start the concurrent manager you have to use startmgr utility, I will discuss srartmgt in a different post.

CONCSUB apps/apps_password SYSADMIN ‘System Administrator’ SYSADMIN WAIT=N CONCURRENT FND SHUTDOWN

Some times you may also require to abort the concurrent managers, in such situation you can specify ABORT

CONCSUB apps/apps SYSADMIN ‘System Administrator’ SYSADMIN WAIT=N CONCURRENT FND ABORT

Metalink Reference:
457519.1 - How to Submit a Concurrent Request Using CONCSUB Syntax

Regards,

Satya.

http://dbaschool.blogspot.com