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

Data Objects

Data objects are user-defined or third party data sets residing in your PeopleSoft environments that your system administrator has configured Stat to support. You can lock, archive, and migrate data objects the same way you do PeopleSoft proprietary objects and file objects. Stat currently supports data objects in PeopleSoft environments running on Oracle only.

Schema Objects

Stat supports locking, archiving, and migrating schema object definitions on Oracle databases version 9i or higher and on Microsoft SQL Server 2005/2008.

Stat supports certain schema object definitions for PeopleSoft environments running on Oracle databases version 10 or higher. If you are running PeopleSoft on a supported Oracle database version 10 or higher, you can lock, archive, and migrate schema objects. Stat currently supports the following schema object types:

The following schema objects may be archived from and migrated to Microsoft SQL Server 2005/2008 databases:

Object Locking and Reservations (PeopleSoft)

Object locking is an important part of any change management practice since it coordinates all of the developers’ efforts and prevents work from being overwritten. Stat supports two levels of object locking functionality.

The first level is the locking of the objects in the Stat Repository. This is a logical lock, which means that the lock shows up in the Stat application, but developers can still go directly into PeopleSoft or a file directory and make changes to the object even if the lock on the object isn’t theirs. As long as the developers use a CSR to modify objects, the coordination of development is maintained.

The second level is the physical locking of objects in PeopleSoft environments. This second level of locking is optional. It can be turned on for all the environments and file locations in a service domain or a select few. You can also exclude specific PeopleSoft proprietary object types from the physical locking. Your system administrator and file server administrator configure these options. When activated, physical locking works in conjunction with logical locking.

The following sections apply to locking in general, whether you are using just one or both levels of locking. Specific information about physical locking is found in the sections, “Physical PeopleSoft Locking Option” and “Physical File Locking Option” later in this chapter.

Understanding Object Reservations and Locks

Locks and reservations are issued to the developer assigned to the object, regardless of who actually requested the lock. That person may or may not be the assigned developer. This is a security measure determined by user class rights.

A lock indicates that the assigned developer has exclusive change/edit rights on the object. A reservation indicates that the object is currently locked by another developer and you are waiting for the object to become available. Once the object becomes available, Stat converts the reservation to a lock and notifies the holder of the new lock via email. Remember, the holder of the reservation is the developer assigned to the object in the CSR. If you request the lock but are not the assigned developer, you will not receive an email when the reservation turns into a lock.

Stat supports the Physical Locking for the objects types that can be added to a PeopleSoft Definition Security Group.

For certain objects types, PeopleSoft has the following conditions:

These conditions are dictated by PeopleSoft object security requirements, not Stat. To see if a particular SQL or Application Package object is of the variety that can be physically locked in Stat, look in PeopleSoft and see if they have been included in the object security group.

For a complete list of PeopleSoft proprietary object types that you can logically lock in Stat, see Appendix: Supported PeopleSoft Proprietary Objects .

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating