Chat now with support
Chat with Support

Stat 6.0 - User Guide

Introduction to Stat Connecting to Stat Change/Service Requests Stat Consoles Tasks and Time Entries Stat Projects Search Engines Reports and Graphs Personal Rules Object Tools and Wizards Change Management for PeopleSoft
Object Management (PeopleSoft) Object Archives (PeopleSoft) Object Migrations (PeopleSoft)
Change Management for Oracle Applications
Object Management (Oracle Applications) Patch Management Object Archives (Oracle Applications) Object Migrations (Oracle Applications)
Change Management for Generic Applications
Object Management (Generic Applications) Object Archives (Generic Applications) Object Migrations (Generic Applications)
Appendix: Troubleshooting Chart Appendix: Migration Options Appendix: User-Specific Parameters Appendix: Supported PeopleSoft Proprietary Objects Appendix: Stat Reports

Changing Process Event Statuses

A process request may fail for several reasons, some minor and others critical. Stat does not distinguish between minor and critical process event errors. In either case, the event receives a Complete with Errors process status. However, because certain functions within Stat (such as environment compare) treat failed process requests differently than requests that were processed successfully or with warnings, you can manually change the status of a process request event that failed for minor or insignificant errors so that it will be treated as having been processed successfully. After changing a status, you must explain the reason why you making the change. This explanation is then written to the Agent log file for auditing purposes.

NOTE: Changing the status of a patch-related event does not change the status of the patch itself or its associated driver files. An Apply Patch or Patch Impact event may include multiple patches, in which case changing the event to Completed does not change the associated patches or drivers to Completed. This is because the event may have failed for a reason other than a patch or driver failing. To properly change the status of a process event, you must also change the status of the patch and its associated driver files, in addition to the event. For more information, see Changing Patch Process Statuses and Viewing Patch Approvals and Patch Drivers .
Available options include Completed, Completed with Warnings, and Completed with Errors.
3
In the Required Explanation field, describe the reason why you are changing the status in sufficient detail. Then click Save.

Backing Out Patches

When a patch is applied to an environment, an archive of all impacted objects is automatically taken from the target environment. If after applying a patch to an environment you decide that you want to return the impacted file objects and schema objects to their original, ‘pre-patch’ state, you can use Stat’s Patch Backout feature.

With Patch Backout, you can restore file objects and the following schema object types: tables, views, indexes, packages, and sequences. However, some changes may not be recovered, while others may be impossible to recover due to transactional activity during or after the patch was applied. Also, new schema objects inserted into an environment by way of a patch may not be deleted.

2
In the Environment field select the environment that you want to back the last applied patch out of.
3
(Optional) If you are on Oracle Applications version AD.I and want Stat to put the environment in Maintenance Mode when the backing out the patch, select Maint in the Maintenance Mode field. If you do not want the environment put in maintenance mode, select Normal.
The Maintenance Mode field is disabled if you are on an earlier version than AD.I. For more information on Maintenance Mode, see your Oracle Applications documentation.
4
Click Save.

Object Archives (Oracle Applications)

Using Stat, developers can take ‘snapshots’ of objects as they exist in a particular environment and archive them indefinitely in the Stat Repository. These object archives are called archive sets, and they can be used to update your environments with the most recent version of objects or, if needed, to roll them back to an earlier version. This effectively makes Stat the “Undo” feature of Oracle Applications.

Once a developer locks the objects that he or she wishes to change, Stat automatically takes a snapshot of those objects before any changes occur. This is called a base archive set. The base archive set is the “pre-change” version of all the objects locked in the CSR. You can use this snapshot, like all archive sets, to restore data objects and file objects to their previous state.

As you make changes to the objects, you can also create interim archive sets. This is effectively backing up your work as you go along.

The ability to the create archive sets that include file objects and/or data objects is activated at the service domain level by your system administrator.

About Archive Sets

Using Stat, developers can take ‘snapshots’ of objects as they exist in a particular environment and archive them indefinitely in the Stat Repository. These object archives are called archive sets, and they can be used to update your environments with the most recent version of objects or, if needed, to roll them back to an earlier version. This effectively makes Stat the “Undo” feature of Oracle Applications.

Once a developer locks the objects that he or she wishes to change, Stat automatically takes a snapshot of those objects before any changes occur. This is called a base archive set. The base archive set is the “pre-change” version of all the objects locked in the CSR. You can use this snapshot, like all archive sets, to restore data objects and file objects to their previous state.

As you make changes to the objects, you can also create interim archive sets. This is effectively backing up your work as you go along.

The ability to the create archive sets that include file objects and/or data objects is activated at the service domain level by your system administrator.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating