How to submit a concurrent request directly from the operating system(unix)?

Oracle Apps Interview QuestionsCategory: AOL-SysAdminHow to submit a concurrent request directly from the operating system(unix)?
Questions Master asked 4 years ago
2 Answers
Shailender Thallam Staff answered 4 years ago

Write a PL/SQL script to submit concurrent request using FND_REQUEST.Submit() API in a file and execute that file in shell script using SQLPLUS

Example
sqlplus -s  apps/apps @XX_SUBMIT_CP.sql

Shailender Thallam Staff answered 4 years ago

You can also use CONCSUB utility in unix to submit concurrent program from unix.
 
Syntax:
CONCSUB <APPS username>/<APPS password> \
<responsibility application short name> \
<responsibility name> \
<Oracle Applications username> \
[WAIT=N|Y|<n seconds>] \
CONCURRENT \
<program application short name>&nbsp;\
<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> \