Ora Training Blog

Click here to download cmclean.sql REM REM FILENAME REM   cmclean.sql REM DESCRIPTION REM   Clean out the concurrent manager tables REM NOTES REM   Usage: sqlplus <apps_user/apps_passwd> @cmclean REM REM REM   $Id: cmclean.sql,v 1.4 2001/04/07 15:55:07 pferguso Exp $ REM REM REM +==============================+ set verify off; set head off; set timing off set pagesize 1000 column manager format […]

We can submit concurrent programs from OS command / shell prompt using CONCSUB utility. Following is the syntax of the same: 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 […]

  Table Name: FND_CONCURRENT_REQUESTS Column Name: PHASE_CODE   Value  Meaning  C  Completed  I  Inactive  P  Pending  R  Running   Table Name: FND_CONCURRENT_REQUESTS Column Name: STATUS_CODE   Value  Meaning  D  Cancelled  U  Disabled  E  Error  M  No Manager  R  Normal  I  Normal  C  Normal  H  On Hold  W  Paused  B  Resuming  P  Scheduled  Q  Standby  S […]