ORATraining Blog

Many of you would have noticed that while launching forms from Oracle Applications 11.5.10 using Internet Explorer (IE 7) then it might crash with following error. Though it may work perfectly fine in mozilla firefox. This is the working fix for the issue. Solution-1: 1) Take backup of jvm.dll located at c:\Program Files\Oracle\JInitiator 1.3.1.21\bin\hotspot directory. [...]

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 [...]

/*+ hint */ /*+ hint(argument) */ /*+ hint(argument-1 argument-2) */ All hints except /*+ rule */ cause the CBO to be used. Therefore, it is good practise to analyze the underlying tables if hints are used (or the query is fully hinted. There should be no schema names in hints. Hints must use aliases if [...]