# AD Job Timing Report
Timing statistics for the entire session
Example :
$ cd $APPL_TOP/admin/<SID>/out
$ sqlplus <APPS username>/<APPS password> @$AD_TOP/admin/sql/adtimrpt.sql \
<session id> <output file>
Run the report with this command, where <session_id> is the session of the timing
statistics you want to see, and <output file> is the name of the file where the statistics
will be written.
# AD Configuration Report
The report output file is written to adutconf.lst in the current working directory.
SQL*Plus PAUSE and NEWPAGE settings
Rollback segment information
Information about the product group
Whether Multi-Org is installed and list of operating units
Whether Multiple Reporting Currencies (MRC) functionality is installed
List of registered products
Information on all registered schemas
Information about all installed products, including shared and dependent products
Status of localization modules
The base language and other installed languages
NLS init.ora settings
Example :
$ cd $APPL_TOP/admin/<SID>/out
$ sqlplus <APPS schema username>/<APPS schema password> \
@$AD_TOP/sql/adutconf.sql
#AD File Identification Report
Identifies the version and translation level of Oracle Applications files
$ adident Header $FND_TOP/lib/wfload.o $FND_TOP/lib/libfnd.a
#ADCHECK
ADCheck - Checks integrity of downloaded Patches from Metalink
The MD5 digest
is a 128-bit string output that uniquely identifies the patch and the SHA-1 is a 160-bit
string output
Example :
$ adchkdig -file <File> [ -md5 <MD5_digest> -sha1 <SHA-1_digest> ]
Timing statistics for the entire session
Example :
$ cd $APPL_TOP/admin/<SID>/out
$ sqlplus <APPS username>/<APPS password> @$AD_TOP/admin/sql/adtimrpt.sql \
<session id> <output file>
Run the report with this command, where <session_id> is the session of the timing
statistics you want to see, and <output file> is the name of the file where the statistics
will be written.
# AD Configuration Report
The report output file is written to adutconf.lst in the current working directory.
SQL*Plus PAUSE and NEWPAGE settings
Rollback segment information
Information about the product group
Whether Multi-Org is installed and list of operating units
Whether Multiple Reporting Currencies (MRC) functionality is installed
List of registered products
Information on all registered schemas
Information about all installed products, including shared and dependent products
Status of localization modules
The base language and other installed languages
NLS init.ora settings
Example :
$ cd $APPL_TOP/admin/<SID>/out
$ sqlplus <APPS schema username>/<APPS schema password> \
@$AD_TOP/sql/adutconf.sql
#AD File Identification Report
Identifies the version and translation level of Oracle Applications files
$ adident Header $FND_TOP/lib/wfload.o $FND_TOP/lib/libfnd.a
#ADCHECK
ADCheck - Checks integrity of downloaded Patches from Metalink
The MD5 digest
is a 128-bit string output that uniquely identifies the patch and the SHA-1 is a 160-bit
string output
Example :
$ adchkdig -file <File> [ -md5 <MD5_digest> -sha1 <SHA-1_digest> ]