Chat now with support
Chat with Support

Stat 7.0 - Web User Guide

Stat Web Queries CSRs Workflow Tasks CSR Logs Change Management Object Migration Process Requests CSR History CSR Migration Path Job Monitor Test Connect Reports

Archive Set Object Information

To see the details of your archive set, double-click on it in the Archive Set table. This re-opens the archive set window. The Details tab should look familiar since this is the tab you filled out when you created the archive set. The next tab, Objects, now contains all of the object information for the archive set.

* 
NOTE: After adding objects to an archive set, the Migration Flags tab is added to the Archive Set Window. For more information, see Deleting Objects .

The Objects tab displays the following information:

Migr Order

For schema objects, file objects, and setup objects only, indicates the order in which the object will be migrated relative to the other objects in the archive set. Objects assigned a lower number are migrated before objects assigned higher numbers.

* 
NOTE: The default migration order is based on object type and is defined in the Object Type Maintenance table. You can override the default order by specifying a higher or lower value for one or more objects. You can change the migration order values manually, or you can use the Default Order and Reorder buttons, which are described below.
Class

Indicates the class of object. Object classes include data and file.

Type

The object type.

Object

The object name.

Version

A version number internal to Stat. It indicates the number of times the object has been modified/archived in Stat for a given environment.

Status

Reflects the current status of the object. Possible statuses include:

•
Archived – Indicates Stat finished archiving the object
•
Archive Pending – Indicates Stat is in the process of archiving the object
•
Wait Lock – Indicates Stat is waiting for Stat to issue the objects in this CSR a lock. You can archive only locked objects.
•
Delete Pending – Indicates Stat is in the process of deleting the objects
•
Re-archive Pending – Indicates Stat is in the process of archiving the object again
Errors

Indicates the number of errors found. See the Logs window for further details.

Warning

Indicates the number of warnings found. See Logs window for further details.

Source Information

If the object is a data object, this field shows the number of tables and rows in Stat used to complete the archive. If it is a file object, the field shows the exact file location of the archive source in the archive set.

Object Count

This information is displayed at the bottom of the window. It shows the total number of objects in the archive set and how many of these have been archived.

Generation Schema

For any Oracle Apps file type that has been marked as a database script (including SQL Scripts and SPL/SQL, PKB, and PKH file object types as well as custom object types marked as database scripts), this drop-down list displays the list of products that are present in Stat for the source environment. If a value is selected in this column, the object is generated on the target environment using this schema. If the value is blank, the default APPS schema is used.

Buttons

The Objects tab features the following short cut buttons:

•
Add – Adds selected objects to the archive set. Press this button and Stat displays a list of the objects.
•
Delete – Deletes all of the objects in the selected archive set. You cannot delete objects from a base or final archive set.
•
Re-Archive – Instructs Stat to re-archive the objects
•
Refresh – Refreshes the current display
•
Print – Prints the contents of the window
•
Export – Exports the contents of the window
* 
NOTE: Once an archive set has been migrated, you cannot add or delete objects from it. You should create a new archive set instead.
•
Default Order – For schema objects, file objects, and setup objects only, restores the migration order of selected objects to the default order as defined in the Object Type Maintenance table
•
Reorder – For schema objects, file objects, and setup objects only, changes the migration order of selected objects starting with the numerical value specified in the field positioned above the button and in the order in which they are listed in the Objects tab. This provides a convenient way to change the migration order of multiple objects simultaneously. For example, assuming 5 as the starting value, the first selected object is assigned the value 5, the next selected object is assigned 6, and so on.
•
View – For file, schema, and setup object types only, displays the definition of the selected object in a separate window.
•
Download – Allows users to download the selected file or schema object from archive.

Copying Archive Sets

When you copy an archive set, the copy retains the migration order set on the source archive set.

To copy an archive set:
1
In the Archive Sets table, select the archive set you want to copy and click Copy.
* 
NOTE: Only archive sets with a complete-type status can be copied.
This opens the Archive Set window where you can edit the properties of the copied archive set as needed, including the archive type and source environment.
When copying archive sets, be aware of the following:
•
You can select a different source environment, but if the objects don't exist in the new source, you have to add the missing objects if you want to include them in the copy.
•
When you save a copy as a final archive set, the number of objects in the archive set must equal the number of objects in the base archive set. If not, Stat prompts you to add the objects when you try to save the archive set.
2
Add a description of the archive set, and (optionally) edit the properties of the archive set as needed.
3
Click OK.

Deleting Objects

Stat lets you delete unwanted objects from selected Oracle Applications environments along a migration path. After adding the unwanted objects to an archive set, you can mark them for deletion. When you migrate an archive set containing objects marked for deletion to an environment, Stat deletes them from that environment. However, you can always recover deleted objects since they remain archived in the Stat Repository.

To mark objects for deletion:
1
Add the objects to the archive set.
2
When the Archive Set has completed, open the Migration Flags tab of the archive set.
3
In the Action field, change the setting to Delete.
4
Click OK.

If you decide that you do not want to delete an object marked for deletion before you migrate it, go back to the Migration Flags tab and in the Action field change the setting to Copy. Stat is now configured to migrate the object as it normally would by placing a copy of the object in the target environment rather than deleting it.

* 
IMPORTANT: When you migrate an object marked for deletion, the object is deleted from that environment and cannot be included in any later archive sets taken from that environment. Because of this, it is recommended that you create an interim archive set of all of the objects that are marked for deletion before you migrate them. You can then migrate the interim archive set to each environment in which you want to delete the objects.

Archive Set Logs

The Logs tab of the Archive Set window displays any messages Stat logged during the archive process.This tab provides you with a complete list of messages logged by Stat. It is a running log of the activities involved with the archive sets.

The Logs tab displays the following information:

Date and Time

The date and time the message was logged.

Object

Archive sets are created by processes run by different objects in Stat. These object processes each have their own capabilities and tasks. The Object column displays the Stat object that reported the message. These objects include:

•
Mgr – The manager object creates, destroys, and instructs all the other objects
•
Trg – Indicates the target environment
•
Src – Indicates the source environment
Type

There are three types of messages: Information, Error, and Warning.

Information

The text of the message.

Buttons

The Objects tab features the following short cut buttons:

•
Next Error – Navigates you through your error/warning messages
•
Print – Prints the contents of the window. Pressing this button automatically sends a job to the printer. There are no print options.
•
Export – Exports the information in this window. Pressing this button opens a Save As window. Several file types are available for selection using the vertical scroll. An Excel format is most useful for evaluating this data.
•
Clear – Clears the logs generated for this archive set
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating