Archives
-
cmclean.sql script to cleanup concurrent manager tables
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 […]
Apr 4th, 2009 | Filed under Concurrent manager, Oracle, Oracle Applications, Oracle Applications DBA -
How to submit concurrent program from command promot / shell
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 […]
Apr 3rd, 2009 | Filed under Concurrent manager, Oracle, Oracle Applications, Oracle Applications DBA -
Oracle Applications Concurrent Request phase codes and status codes
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 […]
Apr 3rd, 2009 | Filed under Concurrent manager, Oracle, Oracle Applications, Oracle Applications DBA
Recent Comments