Skip Headers

Oracle E-Business Suite Maintenance Procedures
Release 12.1
Part Number E13675-03
Go to Table of Contents
Go to previous page
Go to next page

Reporting and Tracking

This chapter describes how to use the reporting and tracking features in Oracle E-Business Suite.

This chapter covers the following topics:

Timing Information

Use the reports in this section to gather job timing statistics.


How can I monitor the time it takes to complete individual system patching or maintenance sessions?


When you run AD Administration or AutoPatch, they automatically capture timing information about processing sessions that run parallel tasks.

Stored in database tables, this information can be accessed as the AD Job Timing Report. You can access the content of this report from either the OAM Timing Reports feature or the command line.

The information captured includes:


Information about timing sessions for both AD Administration and AutoPatch is collected in a single action and can be viewed in Oracle Applications Manager.

Note: For more information about this interface and its contents, see AutoPatch Timing Details and AD Administration Timing Details in Oracle E-Business Suite Patching Procedures.

Note: For instructions on running a job timing report manually from the command line during a current session, or for a previous session, see AD Job Timing Report in Oracle E-Business Suite Maintenance Utilities.

General System Reporting

Use the reports in this section to gather general system statistics and status information.

Installed Configuration Information


How can I view information such as undo information, list of operating units, or NLS init.ora settings?


The AD Configuration script (adutconf.sql) is an SQL script that reports on the configuration of an Oracle E-Business Suite system. You can use the report (adutconf.lst) in troubleshooting, or simply to document the status of your installation. For example, it contains information about undo segments, registered products and schemas, Reporting Currencies settings, and NLS database initialization parameters.

Note: For more information, see AD Configuration Report in Oracle E-Business Suite Maintenance Utilities.


  1. Log in as applmgr and set the environment as described in Setting the Environment in Chapter 1 of Oracle E-Business Suite Maintenance Utilities.

  2. Use the command for your platform to run the script. The output file is written to adutconf.lst in the current working directory.


    $ cd $APPL_TOP/admin/<SID>/out
    $ sqlplus <APPS schema username>/<APPS schema password> \

Identifying File Versions and Translation Levels


I want to obtain information about file versions.


When collecting information about your system, perhaps for sending to Oracle Support, you may need to determine the version and translation levels of your files.


You can obtain version and translation levels of your files by running AD File Identification (adident).

Note: For more information, see AD File Identification Report in Oracle E-Business Suite Maintenance Utilities.