File Version Help!

Need help determining a file verison in Oracle Apps. Here is a handy query that will assist you in detemining the current version a file.


SELECT afl.filename, max(afv.version),APP_SHORT_NAME, SUBDIR
FROM applsys.ad_file_versions afv, applsys.ad_files afl
WHERE afv.file_id = afl.file_ID
AND afl.filename in
('APXINWKB.fmb','APXHRUPD.rdf','CUSTOM.pll') -- insert your file names here
GROUP BY afl.filename, APP_SHORT_NAME,SUBDIR

Unix users:

If the file is not in the above tables, use the following commands to determine the version number of a file.

Change to the directory where file is:
cd $AP_TOP/reports/US

Run following command with file name:
strings -a APXHRUPD.rdf | grep '$Header'

Inside the Oracle Concurrent Manager

Here is a nice article by Terry Oakes and Don Burleson concerning troubleshooting the Concurrent Managers

The concurrent managers in the Oracle e-Business suite serve several important administrative functions. Foremost, the concurrent managers ensure that the applications are not overwhelmed with requests, and the second areas of functions are the management of batch processing and report generation.
This article will explore tools that are used by experienced administrators to gain insight and improved control over the concurrent management functions. We will explore how the concurrent managers can be configured via the GUI, and also explore scripts and dictionary queries that are used to improve the functionality of concurrent management.

Follow this link for the remainder of the article.
Inside the Oracle Concurrent Manager