Skip Headers

Oracle E-Business Suite Patching Procedures
Release 12.1
Part Number E12148-04
Go to Table of Contents
Contents
Go to previous page
Previous
Go to next page
Next

Patch Reporting Utilities

As you apply patches and perform other maintenance tasks that modify your system, you may need to refer to the numerous reports that are automatically created as a record of these activities. This chapter explains how to do this, and lists the options available. For example, you can query the patch information files to see lists of patches applied and files affected, or you can generate a report about the version and translation level of your files. You can also generate reports that contain statistics about maintenance sessions, including the number of jobs in each session, the time taken to complete each job, and the time taken to complete the whole session.

This chapter covers the following topics:

Applied Patches

With the Applied Patches reporting tool, you can view information about the patches applied to your system. This patch history includes information such as:

How Patch Information Is Stored

AutoPatch stores patch information in the database automatically each time it successfully applies a patch. However, if the patch is not applied successfully, or when you run AutoPatch in pre-install mode, patch history is not written directly to the database, but instead is written to these patch information files:

Note: In the file name, hh is in 24-hour format.

Both files are located in the <APPL_TOP>/admin/<SID> directory. Each time you run AutoPatch, it checks this directory for the existence of the patch information files. If it finds them, it automatically uploads the information they contain to the patch history database. If the upload is successful, AutoPatch then deletes the files from the directory. The AutoPatch log file records whether the upload was successful or unsuccessful.

AutoPatch Modes

The way you run AutoPatch affects the way it stores patch history information. When you apply a patch in test mode (using apply=no on the command line), AutoPatch does not write to the patch information files, and it does not upload patch history information to the database. When you apply a patch in pre-install mode (using preinstall=y on the command line), AutoPatch writes patch history information to the patch information files, and it uploads the contents of these files to the database the next time it runs. See: AutoPatch Modes.

Note: Running AutoPatch interactively or non-interactively does not affect the way information is stored in the database.

The Applied Patches Interface

The Applied Patches reporting tool is a Web-based utility in Oracle Applications Manager. The Simple Search page serves as a home page.

Simple Search page

From this page, you can perform a simple search or access the Advanced Search page. You can use either of these pages to query the database for applied patches (the default) or to see a history of changed files. The results of either type of query appear at the bottom of the search page.

Patch Details page

In the search results for both applied patches or file history, there is a Details column. Clicking any link in this column accesses the Patch Details page. From this page, you can go to the Timing Details page, the Files Copied page, the Bug Fixes page, or the Action Summary page.

Note: The discussion of each page contains more detail. The OAM help feature also contains information about the Applied Patches utility.

Accessing Applied Patches Information

To query the patch history database for information about patches applied to your system and the files affected, log in to Oracle Applications Manager and choose Applied Patches from the Site Map.

Step 1: Log in to Oracle Applications Manager

Follow the instructions in Accessing Patch Wizard to access OAM. From the Applications Dashboard, click the Site Map tab.

Step 2: Go the Simple Search page

From the Site Map, Applied Patches is on the Maintenance tab under the Patching and Utilities heading. Click the Applied Patches link to go to the Simple Search page.

Step 3: Select search criteria

From the Simple Search page, you can perform a query for applied patches or file history. Or, you can go to the Advanced Search page to perform a more detailed search.

Note: See detailed descriptions of individual pages in this chapter. See also Analyzing Applied Patches.

Applied Patches Search Pages

This section describes queries for applied patches.

Simple Search

You can perform a Simple Search from this page by entering the required information in the input fields.

Applied Patches Page - Simple Search

the picture is described in the document text

There are four fields in the Simple Search section:

You must enter a value in at least one of the fields. If you do not, an error page reminds you to go back and enter a value. To submit the query, click the Go button. The Reset button clears the entered search criteria.

Advanced Search

Click the Advanced Search button to see the Applied Patches Advanced Search page, then enter the search criteria information.

Applied Patches Page - Advanced Search

the picture is described in the document text

On the Advanced Search page, there are additional search criteria to narrow the results of a query:

Search Results

After a search, the results appear at the bottom of the search page. If the results section contains multiple pages of retrieved information, use the Previous and Next links or the drop-down list to navigate from page to page. The retrieved patch information is presented in increments of 25 line items per page. Each line item represents an applied patch.

The details provided for each patch are:

Click a Details icon in the report to open the Patch Details report, which provides details for a specific patch. From the Patch Details report, you can drill down and access reports showing timing details for the patch, all files copied to the file system by this patch, all bug fixes that were applied by this patch, and all actions taken by the patch driver.

Note: For more information on the Patch Details report, see: Patch Details.

File History Search Pages

To search for files that have been updated by a patch, click the File History option in the Select Feature drop-down list on the Applied Patches search pages.

Simple Search

You can perform a Simple Search from this page by entering the required information in the input fields.

File History Page - Simple Search

the picture is described in the document text

The following fields are in the Simple Search section:

To submit the query, click the Go button. The Reset button clears the entered search criteria.

Note: If you have not entered a value in the File Name field, a message prompts you to go back and complete the field.

Advanced Search

Click the Advanced Search button. Then enter the search criteria information on the Advanced Search page.

File History Page - Advanced Search

the picture is described in the document text

There are additional search criteria on the Advanced Search page to narrow the results of a query:

Search Results

After a search, the results appear at the bottom of the page. Each line item represents a file that was changed due to its inclusion in a patch. The details provided for a file are:

If a file has never been patched, the message "The above criteria resulted in no rows" appears in the APPL_TOP Name column. If the number of files retrieved exceeds 200, the report lists only the first 200 files. Use the filter to reduce the number of files in the report.

Patch Details

From the Applied Patches page, click the Details icon in a selected row from the results section, or from the File History page, click the patch number link in the Patch Details column, to open the Patch Details report. This report provides details for a specific patch. The patch summary information is carried over and appears at the top of the Patch Details report.

Patch Details Report

the picture is described in the document text

This report contains the following information:

To see additional details for a patch, click one of the following buttons on the report:

Codelevel Introduced

From the Patch Details page, click the Codelevel Introduced icon to access the Codelevel Introduced report.

Codelevel Introduced Report

the picture is described in the document text

This report contains the following information about the codelevel introduced:

You can sort each of these columns by clicking the column title at the top of the report.

Timing Details

The AutoPatch Timing Details can also be accessed through the Timing Reports link from the Maintenance tab on the OAM Site Map.

See Timing Reports for more information on Timing Details.

Files Copied

The Files Copied report lists all files copied to the file system as a result of the actions in the selected driver file. You access this report by selecting a driver file in the Patch Details report and clicking the Files Copied button.

Files Copied Report

the picture is described in the document text

This report contains the following information about the files copied:

You can sort each of these columns by clicking the column title at the top of the report. If there are no files copied in the patch, no rows are displayed. If the number of files copied exceeds 200, the report lists only the first 200 files. Use the filter to reduce the number of files in the report.

Bug Fixes

The Bug Fixes report lists all bug fixes included in the selected driver file. Select a driver file in the Patch Details report and click the Bug Fixes button.

Bug Fixes Report

the picture is described in the document text

This report contains the following information about bug fixes:

You can sort each of these columns by clicking the column title at the top of the report. If there are no bug fixes in the patch, no rows are displayed. If the number of bug fixes exceeds 200, the report lists only the first 200. Use the filter to reduce the number of items in the report.

Action Summary

The Action Summary report provides summary information for the actions of a selected driver file. Each line item represents a performed action. You access this report either by selecting a driver file in the Patch Details report and clicking the Action Summary button, by clicking the Action icon in the File History search results, or by clicking a bug fix number in the Bug Fix column of the Bug Fixes report.

Action Summary Report

the picture is described in the document text

The Action Summary report contains the following summary information:

You can sort each of these columns by clicking the column title at the top of the report. If the number of actions exceeds 200, the report lists only the first 200. Use the filter to reduce the number of items in the report.

Action Details

To access this report, click the Details icon in a selected row of the Action Summary report. The Action Summary information is carried over and presented at the top of the report.

Action Details Report

the picture is described in the document text

This report contains the following information about action details:

N/A in the report represents action details that are not specified. For example, in the Arguments field, N/A means no additional arguments were specified.

Timing Reports

The Timing Reports utility provides the job history of applied patches. It captures statistics about, and job timing information for, AutoPatch and AD Administration maintenance sessions that run parallel workers. Both AutoPatch and AD Administration store information about a processing session in database tables. You can access this information, either during the session or after it is complete, through the OAM interface.

Note: You can also access job timing information during a current session or for a completed session by running adtimrpt.sql from the command line. This script creates the adt<session_id>.lst report. For more information, see: AD Job Timing Report, Oracle E-Business Suite Maintenance Utilities.

During a parallel session, AD utilities assign processing jobs to workers. For jobs that affect the database, job actions are grouped in phases to reduce dependencies between jobs - workers do not have to wait for another worker to complete a dependent job before completing their assigned task. See: Using Parallel Processing, Oracle E-Business Suite Maintenance Utilities.

The Timing Reports utility lists processing tasks and provide details about the elapsed time for phases, jobs, and sessions. The information includes:

The Timing Reports Interface

The Timing Reports interface consists of a main page, a Timing Details page, and a View Log Files page which provides links to reports about specific maintenance session information.

Main Page

From the Timing Reports main page, you can view a list of all in-progress, stopped, aborted, and completed maintenance sessions. Click the Details icon to access the Timing Details page or click the Log Files icon to access the View Log Files page.

Timing Details Page

There are two types of Timing Details reports - those associated with an AutoPatch session and those associated with an AD Administration session.

Note: The discussion of each page contains more detail. The OAM help feature also contains information about the Timing Reports.

View Log Files Page

This page contains a list of log files generated for the corresponding maintenance session.

Accessing Timing Reports

To access the Timing Reports main page, log in to Oracle Applications Manager and choose Timing Reports from the Site Map.

Step 1: Log in to Oracle Applications Manager

Follow the instructions in Accessing Patch Wizard to access OAM. From the Applications Dashboard, click the Site Map tab.

Step 2: Access Timing Reports

From the Site Map, Timing Reports is on the Maintenance tab under the Patching and Utilities heading. Click the Timing Reports link to go to the main page.

Step 3: Filter the results

There is a filter at the top of the page that allows you to narrow the contents of the list. You can filter based on the following status of the tasks: Any tasks, In-progress tasks, Completed tasks, Stopped tasks, or Aborted tasks. You can also filter by Task Name, Status, Start Date, and Run Time. Click Go to activate the filter.

Note: See descriptions of individual pages in this chapter for details. See also AD Administration in Oracle E-Business Suite Maintenance Utilities.

Timing Reports Main Page

The Timing Reports main page shows information for each maintenance session.

Timing Reports Main Page

the picture is described in the document text

AutoPatch Timing Details

Click the Details icon of a selected row (with an AutoPatch task name) in the Timing Reports list to open the AutoPatch Timing Details report. This report provides details for a specific session of AutoPatch.

AutoPatch Timing Details Report

the picture is described in the document text

The AutoPatch Timing Details report lists every task performed in a maintenance session. The Timing Details section contains the following information for each task:

Use the filter to adjust the list of tasks based on their elapsed time. The default list shows all tasks with elapsed time of greater than 4 seconds. Use the Expand All link to see all sub-tasks and the Collapse All to see just the top-level task.

When you access the AutoPatch Timing Details report for a stopped or in-progress task, the page defaults to display the most recently performed sub-tasks. For in-progress tasks, you can use the Refresh icon to get the latest running tasks. The Refresh icon is a picture of a page with a blue circular arrow.

Run Information

Additional AutoPatch task information is available by clicking the plus-sign icon for the Run Information section at the bottom of the page. The subsections in Run Information are General, Timing Summary, and Files Installed on this APPL_TOP.

AutoPatch Timing Details Report - Run Information

the picture is described in the document text

General

This subsection contains the following information:

Timing Summary

This subsection contains the following information:

Files Installed on this APPL_TOP

This subsection contains the following information:

AD Administration Timing Details

Click the Details icon of a selected row (with an AD Administration task name) in the Timing Reports list to open the AD Administration Timing Details report. This report provides details for a specific session of AD Administration.

AD Administration Timing Details Report

the picture is described in the document text

The Timing Details and Run Information sections contain the same types of information for each task as the AutoPatch Timing Details report. See: AutoPatch Timing Details.

In-Progress Timing Details

You can use the In-Progress Timing Details page to monitor the job while it is running. Click the Refresh icon to view the steps that are in progress.

In-Progress Timing Details Page

the picture is described in the document text

In the In-Progress AD Utility section, you can filter the results by elapsed time.

The AutoPatch Timing Details section contains the following information for each task:

Job Timing

The underlined Task Names in the AutoPatch Timing Details report and the AD Administration Timing Details report link to the Job Timing report for that particular task. This report provides timing information for each job within the selected task and allows you to drill down into each task to view any exception reports.

Job Timing Report

the picture is described in the document text

Click a Task Name on the Timing Details report to open the Job Timing report. The Job Timing Summary information appears at the top of the Job Timing report and the details appear at the bottom.

The summary information includes:

The Job Timing Details section contains the following information for each job:

The filters at the top of the Details section allow you to adjust the list of jobs based on the property and run time of jobs. You can filter based on the following properties of the jobs: Phase, Product, Directory, File, Action, or Restarted. Click Go to activate the filter.

Click the Phase Info button to open the Phase Information report.

Phase Information

Clicking the Phase Info button provides timing information by phase for a task selected in either the AutoPatch Timing Details report or the AD Administration Timing Details report.

Phase Information Report

the picture is described in the document text

The general information presented at the top of the Phase Information report are:

The Phase Information details include:

Product Information

Clicking the Product Info button displays timing information for all products, with the aggregate timing information for database tasks being shown in the Total Job Time column for each product.

Overall Product Summary

the picture is described in the document text

Clicking the link for an entry in the Product column displays full status details for a specific product. The example shown below is for FND.

Specific Product Details

the picture is described in the document text

Exceptions

Clicking the Exceptions number in the Job Timing report opens the Exception report. This report is available only for jobs that have an Exceptions value greater than zero in the Job Timing report. It provides a list of exceptions encountered during the maintenance session.

Exception Report

the picture is described in the document text

The general information includes:

The Exception details include:

View Log Files

Clicking the Log Files icon of a selected row opens the View Log Files page. This page lists all the log files generated for a specific maintenance session. You can view log files of completed jobs or jobs that are in progress.

View Log Files Page

the picture is described in the document text

The View Log Files page contains the following information:

The following buttons apply to the Log Files section:

The Log Files section contains the following information:

View Log Details

Details of each log file are displayed on the View Log Details page. To access this page, select the radio button next to one of the log files and click the View button. The page displays up to 500 lines. It automatically defaults to the last page in the log file.

View Log Details Page

the picture is described in the document text

The View Log Details page contains the following information:

You can use the following buttons to navigate to specific portions of the log file:

Contents of ...

This section displays the contents of the log file. Click the Go to bottom link to navigate to the last page of the log file. From the last page of the file, click the Return to top link to go back to the first page.

Software Updates

Software Updates is a portal from which you can view all the patching-related activities of your system. From the Software Updates main page, you can access information such as:

The Software Updates Interface

The Software Updates page is a Web-based utility in Oracle Applications Manager. From this page, you can get an overview of all patching-related information.

Accessing Software Updates

To view patching-related activities for your system, log in to Oracle Applications Manager and click the Software Updates tab.

Step 1: Log in to Oracle Applications Manager

Follow the instructions in Accessing Patch Wizard to access OAM.

Step 2: Click on the Software Updates tab

From the Applications Dashboard, click the Software Updates tab.

Software Updates Page

This section describes the Software Updates page.

Software Updates Page

the picture is described in the document text

The top of the page indicates the version of your Oracle E-Business Suite system.

Applied Patch Check

Use the Applied Patch Check field to check if a patch or a series of patches have been applied to your system. Enter a patch ID or a series of IDs separated by commas to check if the patch or patches have been applied to your system. The table below the field contains two columns: Applied and Not Applied. Your queried patch ID appears in the corresponding column depending on whether it has been applied or not.

Patch Recommendation Requests

This section lists the latest three patch recommendation requests from the Patch Wizard main page. From this section, you can view the following information: Filter Name/Patch List, Total (Applied and Unapplied), Unapplied, Status, and Details.

Click the Full List button in the Patch Recommendation Results section to go directly to the Patch Wizard main page. Click the Details icon to go directly to the Recommended Patches Results of the associated patch. See: Patch Wizard.

Maintenance Activities

This section lists the latest eight jobs from the Timing Reports page. From this section, you can view the following information: Task Name, Status, Last Updated, Details, and Log Files.

Click the Full List button in the Maintenance Activities section to go directly to the Timing Reports main page. Click the Details icon to go directly to the Timing Details report of the associated task, or click the Log Files icon to go directly to the View Log Files page of the associated task. See: Timing Reports.

Related Links

This section lists the links related to patching activities for your system.