|Oracle E-Business Suite Maintenance Procedures|
Part Number E13675-03
This chapter describes how to use the reporting and tracking features in Oracle E-Business Suite.
This chapter covers the following topics:
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:
Jobs run successfully on the first try
Failed jobs that were restarted and then run successfully
Failed jobs that were skipped
Job timing information
Summary information about each parallel phase
Overall timings for each session
Status of an in-progress patching session
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.
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.
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.
$ cd $APPL_TOP/admin/<SID>/out $ sqlplus <APPS schema username>/<APPS schema password> \ @$AD_TOP/sql/adutconf.sql
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.
Copyright © 2000, 2009, Oracle and/or its affiliates. All rights reserved.