Saturday, March 27, 2010

Oracle Release 12 : "Diagnostics: Apps Check" Concurrent Request

Readers,

Yesterday, When I ran " Diagnostics: Apps Check" Concurrent request in our Production Release 12 instance, it failed and found the following error in the log file,

+-----------------------------
| Starting concurrent program execution...
+-----------------------------

Arguments
------------
201

------------
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+
/bin/ksh: line 1: f60desm: not found


Concurrent Manager encountered an error while running SQL*Plus for your concurrent request 18203944.

Review your concurrent request log and/or report output file for more detailed information.


+---------------------------------------------------------------------------+


So, the error is " /bin/ksh: line 1: f60desm: not found " and f60desm is not available in Release 12 instance.

When I investigate further, I found the patch 8310984 which will fix this issue as mentioned in the Oracle Support Note : Diagnostics: Apps Check report with parameter Assets error: bin/ksh: f60desm: not found [ID 863890.1]

Because, our current file version in the system is,

strings -a OMCHECK.sql |grep '$Header'
$Header: OMCHECK.sql 120.2.12000000.9 2008/09/30 06:39:10 vybhatia ship $

Note : Script contains host f60desm help=yes >> &output_file

But, Patch provides the following upper version,

$Header: OMCHECK.sql 120.2.12000000.13 2009/05/23 07:55:26 nshah ship $

Note : Script contains host frmbld help=yes >> &output_file

After applying the patch, " Diagnostics: Apps Check" Concurrent request got completed successfully.

Yours comments are most welome !!!

No comments:

Post a Comment