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
General System Reporting

Timing Information

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

Requirement

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

Discussion

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:

Jobs run successfully on the first try
Failed jobs that were restarted and then run successfully
Failed jobs that were skipped
Time-consuming jobs
Job timing information
Summary information about each parallel phase
Overall timings for each session
Status of an in-progress patching session

Actions

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

Requirement

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

Discussion

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.

Actions

Log in as applmgr and set the environment as described in Setting the Environment in Chapter 1 of Oracle E-Business Suite Maintenance Utilities.
Use the command for your platform to run the script. The output file is written to adutconf.lst in the current working directory.

UNIX
```
$ cd $APPL_TOP/admin/<SID>/out
$ sqlplus <APPS schema username>/<APPS schema password> \
@$AD_TOP/sql/adutconf.sql
```

Identifying File Versions and Translation Levels

Requirement

I want to obtain information about file versions.

Discussion

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.

Actions

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.