18 Managing the Records System
This chapter discusses the following topics:
18.1 Scheduling Tasks
It is possible to set up a schedule to perform retention-related tasks at times that are more convenient for your environment. This chapter discusses scheduling tasks that can be performed at a later time. It covers the following topics:
Some of the tasks performed may involve large sets of content. Tasks such as processing retention assignments, performing archives, or customizing metadata may interfere with normal daily operations or put a heavy load on the system, which is undesirable during regular business hours.
With the scheduling feature tasks can be set to be performed at a later time, during off-peak times on the system. Freezes can also be scheduled to be performed at specific times.
The following topics are discussed in this section:
18.1.1 Scheduling Screening Reports
To schedule a screening report, first screen for information using the screening function. Select the source then choose the scheduling criteria such as name for the report, start date, indication if it will recur, and the recurrence frequency for the report. You can also subscribe to the report and be notified when the report is generated.
The screening report is then put in the queue of actions to be performed. All scheduled screening reports are generated daily at midnight by default.
18.1.3 Viewing Recurring Screening Report History
To view the history of recurring scheduled screening reports:
- Choose Records then Scheduled then Scheduled Screening Reports.
- On the Scheduled Screening Reports page, choose Report History in the Actions menu of the recurring screening report whose history will be viewed.
- To view a report, click its link in the Name column.
18.1.4 Scheduling and Unscheduling Freezes
Use this procedure to schedule a recurring freeze of selected items. This optional feature will freeze any new items that match the search criteria specified from the search page.
To unschedule a freeze, select Records then Scheduled then Freezes. Select Unschedule from the Action menu of the scheduled freeze.
- Search for the items to include in the scheduled recurring freeze.
- On the Search Results page, choose Edit then Freeze All Search Results from the Table menu.
- In the open dialog, select the freeze reason from the list.
- Enter a freeze reason (optional).
- Select Schedule Recurring Freeze Inclusion then click OK.
18.1.5 Viewing Scheduled Job Information
To view a list of all scheduled jobs (reports, freezes, and any other Oracle WebCenter Content scheduled jobs):
- Choose Administration then Scheduled Jobs Administration. Choose Active Scheduled Jobs.
- The Scheduled Jobs Listing page opens, showing all scheduled jobs.
- To view details about a particular job, click the Info icon for that job. To edit details about the scheduled job, select Edit from the Actions menu for a particular item.
- The Job Information page/Edit Job Information page opens. This page can be used to edit job details such as priority, the type of job, and so forth.
18.2 Using Performance Monitoring
Performance monitoring can be enabled to check the status of batch processing, service calls, and other system information.
Several default numbers have been set as a starting point for monitoring. Actual performance variations will depend on the hardware used at the site and other variables such as total amount of content and software in use.
The frequency with which you need to update statistics depends on how quickly the data is changing. Typically, statistics should be updated when the number of new items since the last update is greater than ten percent of the number of items when the statistics were last updated.
If a large amount of disposition processing is being done (for example, at the end of the calendar year for organizations that synchronize dispositions on the calendar), you should update statistics at the end of the week rather than wait for a particular percentage of data updates.
Performance monitoring statistics are written to a database table and can be accessed later.
This section discusses the following topics:
18.2.1 Enabling Performance Monitoring
To use performance monitoring:
- Choose Records then Audit. Choose Configure then Performance Monitoring.
- On the Configure Performance Monitoring page, select the items to monitor and the time intervals for reports and alerts.
- Click Submit Update when done.
18.2.2 Checking Performance Results
After enabling performance monitoring, current performance information can be checked using this procedure:
18.2.3 Viewing Performance Alerts and Details
If any performance activities exceed the limits set on the Configure Performance Monitoring page, a message is displayed automatically when you log in to the system.
Click any link on the message to see details about the specific alert. For example, a detail page opens when the first alert message is clicked. Click any link to show details about the specific items that caused the alert.
18.3 Using Custom Scripts
Custom scripts can be created using Idoc Script, a proprietary scripting language. This functionality is enabled by default when the DoD Configuration component is enabled.
Custom scripting can be disabled by deselecting Enable Custom Script in the DoD Config section of the Configure Retention Settings page. To access that page choose Records then Configure then Settings.
When enabled, new content fields are available that allow you to define which scripts will apply to a folder or category.
Note:
You must have a thorough understanding of Idoc Script to use this feature. The software does not validate the script. You are responsible for creating usable scripts. For details about Idoc Script and its use, see Developing with Oracle WebCenter Content.
Two types of scripts can be created using the Custom Script functionality:
-
Security scripts, which allow users with the Records Administrator role to define and manage access control to content.
-
Custom Notification scripts, which notify users of events. One custom script is provided, which notifies a list of reviewers when items are due for destruction after being superseded. Notification is sent in one consolidated email when batches are run. Additional scripts can be created.
Scripts can be applied at a category or folder level but content in the category or folder does not automatically inherit the script. Consider the following scenario:
-
A custom script is created to prevent user A from viewing content.
-
A folder is created and the custom script is applied to it.
-
An item is checked in by user B to the folder.
-
User A browses through the folder and sees the title of the item checked in by user B. However, if user A tries to view the actual item, an error is returned.
To prevent user A from even seeing the title of the item, the security script must be set so items included in the object (category or folder) explicitly inherit the attributes of the script. For example, to set inheritance in a category, the following variable would be set in the config.cfg
file:
RecordsMetaInheritFromCategory=dSecurityScripts:xSecurityScripts
To set inheritance for a folder, use the RecordsMetaInheritFromFolder
variable.
Note:
Custom scripts comply with the DoD 5015.2 specification, chapter 4.19 and chapter 4.20.
This section discusses the following topics:
18.3.1 Creating or Editing Scripts
Note:
Any custom Idoc Script that is entered is NOT verified for accuracy. You should have knowledge about Idoc Script and its uses before creating scripts.
To set up a script:
18.3.2 Deleting a Custom Script
To delete a script:
- Choose Records then Configure.
- Choose Security then Custom Scripts.
- On the Configure Custom Script page, select the type of script for deletion by clicking the tab for either a Notification or a Security script.
- To delete the script, select the box next to the script name and choose Delete or Delete Script from the script's Actions menu. You can also choose Delete on the Custom Script Information page.
18.3.3 Viewing Script Information
To view a script's information:
- Choose Records then Configure.
- Choose Security then Custom Scripts.
- On the Configure Custom Script page, select the type of script for viewing by clicking the tab for either a Notification or a Security script.
- To view the script information, click the script name or choose Script Information from the script's Actions menu.
18.4 Using the Audit Trail
The audit trail is generated in the format specified by the Report Format setting on the Configure Report Settings page.
Note:
The Admin.Audit right is required to work with audit trails. This right is assigned by default to the Records Administrator role. Administrative privileges are required to check in the audit trail.
At certain points, the current audit trail can be cut off and archived and checked into the repository. This action can also be scheduled to occur on a regular basis. The audit trail must be cycled for growth reasons the same as other items. Be sure to check in the audit trail log on a regular basis to keep the file size smaller and the report generation time faster. Each current audit trail is generated from the time the system was installed or archived until the request to generate an audit trail.
An audit trail can be generated at any time. The columns within the audit trail correspond directly with the fields you can use to search within the Search Audit Trail page.
If the generated file is in PDF format, Adobe Acrobat version 6.0 or later is required to view it.
Several tasks are involved in managing Audit Trails:
18.4.1 Configuring the Audit Trail
The configuration on the Configure Audit page determines the administrator and user actions recorded for an audit trail.
Note:
The Admin.Audit right is required to perform this action. This right is assigned by default to the Records Administrator role.
To configure an audit trail:
18.4.1.1 Configure Audit Page
Important:
The Admin.Audit right is required to use this screen. This right is assigned by default to the ‘rmaadmin’ role.By default, all options are selected when you first access the Configure Audit page. To access this page, select Records > Audit > Configure > Audit Trail.
Note:
The Edit Metadata column is only visible if the Log Metadata Changes option is enabled on the Configure Retention Administration Page.Audited Objects and Features | Actions Recorded |
---|---|
Series Category Folder Period Trigger Custom Direct Trigger Indirect Trigger Supplemental Marking Security Classification Configuration Record or Content Freeze User Groups User Accounts Indirect Trigger Date Custom Security Field Related Content Type Disposition Action Metadata Set |
Select the check boxes for the actions you want recorded within the current audit trail:
Note: The User Accounts column represents records users and is not to be confused with the accounts-based security model within Universal Content Management. The Configure Audit User Accounts option tracks users and not document accounts. The User Groups options tracks users assigned to an alias group. |
Submit Update button |
Submits your updates. |
Reset button |
Resets the page to the initial settings. |
18.4.2 Specifying Metadata Fields to Audit
Use this procedure to specify which metadata fields should be included in the audit trail.
Note:
The Admin.SelectMeta right is required to perform this action. This right is assigned to the Records Administrator role by default.
- Choose Records then Audit.
- Choose Configure then Audit Fields.
- On the Audit Fields page, select the boxes for the metadata field to include in the audit trail.
- Click Submit Update when done.
Any changes take effect immediately without restarting the system.
18.4.3 Searching within the Audit Trail
Use this procedure to further refine a search within the current audit trail. For example, you can search for all delete actions, or all delete actions by a particular user, or all actions by a particular user, and so on.
When sorting the audit trail using Oracle DB, the output depends on the type of sort being performed. When sorting with Fulltext Search, sorting is case-sensitive, meaning that upper case items (capitalized items) will appear first in a list. When sorting with Oracle Text Search, a case-insensitive search is performed.
Note:
The Admin.Audit right is required to perform this action. This right is assigned by default to the Records Administrator role.
18.4.4 Setting Default Metadata for Checking In Audit Trails
Setting the default metadata is useful for setting similar check-in attributes. You must set the default metadata before checking in an audit trail for the first time. This is a required step during the setup of the software.
Note:
The Admin.Audit right is required to perform this action. This right is assigned by default to the Records Administrator role.
To set the default metadata:
18.4.5 Checking In and Archiving the Audit Trail
A user must have performed at least one action while logged into the system to generate an audit trail entry. If an empty audit trail is submitted for check-in, a message is displayed indicating there are no entries in the audit trail. Before checking in an audit trail for the first time, set the default metadata for the checkin.
Note:
The Admin.Audit right is required to perform this action. This right is assigned by default to the Records Administrator role.
18.4.6 Searching an Archived Audit Trail
To search for all checked in and archived audit trails:
Prerequisites
-
Checking In and Archiving the Audit Trail
Note:
The Admin.Audit right is required to perform this action. This right is assigned by default to the Records Administrator role.
18.4.7 Viewing an Archived Audit Trail
To view an archived audit log from the search results page, do one of the following:
-
Click the ID (quickest method)
-
Click the Info icon then click the PDF links on the Content Information page.
18.5 Using Default Reports
Reports are initially configured through menu options on the Configure Report Settings page. During configuration a profile can be specified to be used when creating or updating a report template, and a profile to be used when creating or updating a report. A report format can also be chosen and if the report or template should be included when performing searches.
Note:
If barcode labels will be printed, specify PDF for the report format. Labels will display in HTML output but they can only be printed correctly using the PDF option.
To configure default options to be used with all reports:
- Choose Records then Configure.
- Choose Reports then Settings.
- On the Configure Report Settings page, choose the report template profile from the option list or use the default profile provided.
- Choose the profile to use when creating or updating a report.
- Choose the report format to use. Options include HTML, PDF, RTF, or XLS. Note that if barcode labels are to be printed, this must be set to PDF.
- Check the box to exclude all report templates during search operations.
- Check the box to exclude all checked-in reports during search operations.
- When finished, click Submit Update.
18.5.1 User and Group Reports
After creating users and alias groups, and assigning management roles and rights to users, reports can be generated to view at a glance which users and alias groups have access to the system. The following reports are available:
Reports are generated in the format specified by the setting on the user's profile page. To see the user format that is specified, click the user name in the top right corner of the screen and the User Profile page opens. If the system format is used, that usage is specified on the Configure Report Settings page.
If the generated report file is in PDF format, Adobe Acrobat version 6.0 or later is required to view it.
To generate reports, choose Records then Reports then the report type.
Note:
The Admin.Reports right is required to produce any reports. This right is assigned by default to the Records Administrator role. The Admin role is also required.
18.5.1.1 User Report
A list can be generated of all users who have access to the system as well as a barcode list for the users. A report can also be created that can be used to produce barcode labels. The users and the bar codes assigned to them are defined in User Admin utility. This report lists overview information for each user.
Column | Description |
---|---|
User Name |
The name of the user as entered in the User Admin utility. |
Full Name |
The full name of the user as entered in the User Admin utility. |
E-mail Address |
The email address of the user. |
Creation Date |
The date and time the user was created in the User Admin utility. |
Change Date |
The date and time the user information was last modified. |
Supplemental |
Any supplemental markings assigned to a user. |
Security Classification |
The classification assigned to the user. |
Alternate Reviewer |
The alternate reviewer for this user. |
Barcode |
The barcode designation for the user. |
18.5.1.2 User Barcode Reports
A report can be generated that lists barcode information and another type that can be used to produce barcode labels. The users are defined in the User Admin utility then assigned rights and roles.
View barcode reports using HTML but print reports using PDF in order to ensure proper formatting.
18.5.1.3 User Roles Report
Use this report to view a list of all users and their assigned roles. The output of the report may not show all data for all roles. The output is dependent on the user who is generating the report and the permissions given to that user.
Column | Description |
---|---|
User |
The user name of the user as entered in the User Admin utility. |
Roles |
The roles assigned to the user. |
18.5.1.4 Group Report
Use the All Groups report to view a list of all aliases defined for the system.
Column | Description |
---|---|
Group Name |
Lists all alias groups defined in the User Admin utility. |
Description |
A short description of each alias group. |
18.5.1.5 Group-User Report
Use this report to view a list of all users and groups (aliases) currently defined for access. The users and groups (aliases) are assigned in the User Admin utility.
Column | Description |
---|---|
Group |
Lists all alias groups defined in the User Admin utility. |
User |
Lists every user assigned to an alias group. |
18.5.2 Content and Physical Item Reports
Several default reports and templates are provided with the product. These reports are available in a variety of locations within the software such as search result page, Content Information pages, and so on. The type of reports depend on the configuration of the system and what components have been enabled.
This section describes how to generate content reports using the default templates provided. For information about creating custom reports, see Developing with Oracle WebCenter Content.
The following types of reports can be produced:
-
Internal Item Detail Report: This report shows details about one item or about a group of items if several items are selected for use for the report. An external detail report is similar to this report, but it includes the bar code for the item as well as other information that pertains only to external items.
-
Search Results Report: This report shows basic information about items such as content ID and author.
-
Records Destruction Certificate Report: This report shows those items that are scheduled for destruction and which should be removed from the warehouse.
The creation of new reports is composed of two steps: finding the information for the report then choosing the appropriate report option.
-
Use searching or screening to find the information.
-
Use one of the following methods to create a report for an individual item:
-
Click the Info icon for the item. On the item's Content Information page, choose Create Reports then the type of report.
-
On the Search Results page, select the check box for an item. Choose Create Reports then Selected Items then the type of report.
-
-
To create a report for multiple items, select the check boxes of the items then choose Create Reports then Selected Items then the type of report.
-
To create a report for all items on the page (such as all search results), choose Create Reports then Full Results then the type of report.
18.6 Archiving and Transferring Information
If an environment is set up on one computer (including a retention schedule, security scheme, and so on), you may want to copy this configuration information to another computer, for example, from a development system to a production system or a mirrored site. This can be done using built-in archive import and export features.
You can also import and export records, folders, and metadata in XML format by creating a XML Standard Definition (XSD). XSD is a an XML schema language used to define the structure of an XML document. The XSD file is created to make the file usable in the Records system. This allows the content from the system to be imported into a third-party system using a different archive file format or to export data from another system and import it into the system.
This functionality is compliant with the DoD 5015.2 specification that requires the ability to create different XSD schemas.
Note:
When using the import/export process, make sure the instance to which you are importing has the same metadata fields, security groups, and accounts as the instance where the export is originating from. Errors can result if there are mismatches.
This section discusses the following topics:
18.6.1 The Archive Process
The archive process is used to back up or restore a retention schedule and other configuration settings. It is not used to archive copies of content. For details about archiving content, see Administering Oracle WebCenter Content.
Note that if you import an archive from a 10g version of the software to the 11g version that includes a Related Content table, the import must be done in two steps. First import the content items in an archive. Then import the Related Content table.
The export feature copies a variety of configuration settings to a separate .hda file that can be imported into another instance or stored in a safe location for backup purposes. The .hda file is a plain text, serialized data file that can be opened in any text editor.
Retention Schedule objects should be imported before importing other content. Content Server content should be imported before importing the content-related objects.
Note:
For details, see Archive Import/Export Rights and Permissions.
The archive export and import features enable exporting and importing of the following items:
-
Supplemental markings
-
Security classifications, also known as Classified Markings
-
Custom categories metadata and custom folder metadata
-
Custom security fields, also known as Custom Supplemental Markings
-
Periods
-
Triggers
-
Retention schedules
-
Dispositions history: a log of all actions that have been performed
-
Custom disposition actions
-
Freezes
-
Recurring scheduled tasks
-
Classification guides and classification topics. These are only available if the ClassifiedEnhancements component is enabled.
-
PCM location types
-
PCM storage space definitions
-
Custom PCM metadata
-
Reservations
Note the following considerations when using imports and exports:
-
When using PCM, the export feature copies the space management definitions (the setup and hierarchy of warehouses, rooms, and so on) but none of the metadata of the items stored at those locations is archived.
-
When importing an archive, existing items can be overwritten or can be left unchanged.
-
Set the default archive metadata format by choosing Records then Configure then Settings from the Top menu. The Configure Retention Settings page opens. Expand the General section and select the metadata format from the list.
-
When custom category metadata fields or custom folder metadata fields are imported, the order of the fields is not updated. Restart the Content Server after importing custom fields.
-
The disposition history is not updated. Only new dispositions are imported.
-
The export feature copies the retention schedule definition (that is, the defined hierarchy) and disposition instructions, not the items within the retention schedule.
-
If an additional component is enabled, there may be additional items available for export.
Note:
If your organization uses additional security (ACLs) on your retention schedule, the import and export only includes items that can be accessed by the user performing the import or export. For example, if the person does not have ACL access to a particular category, that category is not imported or exported. A message is displayed during the import or export process if any objects are not processed due to ACL access. Make sure you have ACL access to all items to export and import.
18.6.1.1 Exporting Auxiliary Metadata Sets
Note:
You must have administrative privileges to add tables to the list of schema tables used.
When exporting an auxiliary metadata set, add the AuxiliaryMetadataSets and AuxiliaryMetadataSetDefs table to the list of schema tables used. Follow this procedure to add those tables:
After adding the MetadataSet tables to the list of tables, they become available in the list of tables that can be added from the Archiver.
18.6.1.2 The Export/Import Process
The process of importing and exporting content consists of three distinct parts.
-
First import or export a retention schedule and any of the objects in that schedule. This corresponds to the Include Retention Schedules Plan portion of the Export and Import pages.
-
Then import or export the content using the Oracle WebCenter Content Archiver. For details about using the Archiver, see Administering Oracle WebCenter Content.
-
After content has been imported or exported using the Archiver, import or export the Disposition History of related objects. This corresponds to the Include Dispositions History portion of the Export and Import pages.
18.6.1.3 Archive Import/Export Rights and Permissions
The following export rights are needed for specific objects. These rights are included by default with the Records Administrator role:
-
Admin.RetentionSchedulesArchive right: to export a Retention Schedule.
-
Admin.Triggers right: to export triggers.
-
Admin.PerformActions right: to export Disposition Histories.
-
Admin.RecordManager right: to export objects other than those mentioned previously.
The following import rights are needed for specific objects:
-
Category.Edit, Folder.Edit, and Record.Edit rights: to import a Retention Schedule (because these objects are part of a Retention Schedule).
-
Admin.Triggers right: to import triggers.
-
Admin.PerformActions right: to import Disposition Histories.
-
Admin.CustomDispositionActions right: to import Disposition Actions.
-
Admin.RecordManager right: to import objects other than those mentioned previously.
-
If ACL security is enabled, make sure you have access to all retention schedule components and objects to import.
18.6.2 Managing Imports and Exports
The following tasks are performed when importing or exporting archives:
18.6.2.1 Exporting an Archive
Use this procedure to export an archive that can be imported into another instance (located on the same or a separate system) or for backup purposes. Choose which items should be exported.
Note:
For details, see Archive Import/Export Rights and Permissions.
18.6.2.2 Importing an Archive
Note:
When using the import/export process, make sure the instance to which you are importing has the same metadata fields, security groups, and accounts as the instance where the export is originating from. Errors can result if there are mismatches.
Use this procedure to import an archive that was exported on another instance (located on the same or a separate system). Choose which items in the archive should be imported. The items to import must have been included in the export of the archive.
Note:
For details, see Archive Import/Export Rights and Permissions.
If an error occurs, the error message indicates the number of items that failed, not necessarily the number of individual errors for all retention schedule components. If classified markings are imported, they should be reordered after importation.
18.6.2.3 Importing a Batch-Created Storage Hierarchy
Note:
For details, see Archive Import/Export Rights and Permissions.
Use this procedure to import a storage hierarchy definition file (StorageImport.hda) that was created using the batch storage creation feature.
18.6.3 XSD Data Transfer
XSD schemas can be used to manage records, folders, and content to comply with the DoD 5015.2 specification. Exporting and importing data using a format defined as XSD format (XML Schema Definition) conforms with standard transfer schema defaults.
The information must be mapped before proceeding with exporting or importing. After the correct mapping is in place, data can be imported and used. It can then later be transferred as needed to NARA or another system using the XSD schema for that site.
Important considerations should be evaluated before beginning the import and export process:
18.6.3.1 Special Handling of <choice> Elements
The <choice>
element type allows only one of the elements contained in the selected group to be present within a containing element. This differs from an option list where one field can have multiple possible values.
A document whose data is being exported can only contain a value in one of the fields contained in the <xs:choice>
group. This restriction determines which field to use when the XML file is generated for output. If more than one of the fields in the choice group contain a value, an error occurs and the export cannot finish because of ambiguity as to which field should be used.
The following example shows this type of <choice>
list. In this example, an employee can be only one of the three types of employees (full-time, part-time, or contractor). So only one of the three corresponding fields can be contained in the <choice>
element.
<xs:complexType name="employee"> <xs:choice> <xs:element ref="full-time" /> <xs:element ref="part-time" /> <xs:element ref="contractor" /> </xs:choice> </xs:complexType>
18.6.3.2 Required Fields on Import
If your server has required fields, all of those fields must have a value set in order to perform an import. Mapping the required fields to an XML node provides the value. However, if any of the required fields are not mapped, a profile must be created that sets these values on import. If this is not done, the import fails.
18.6.3.3 Target Namespace and Qualified Locals
Explicitly declare a target namespace in the .xsd
file and also specify that locally defined elements and locally defined attributes are qualified. The target namespace is specified by the targetNamespace
attribute.
Local elements and attributes can be qualified globally by using the elementFormDefault
and attributeFormDefault
attributes on the schema element. They can be specified separately for each local declaration using the form
attribute. Attribute values can be set to unqualified or qualified, to indicate if locally declared elements and attributes must be unqualified.
18.6.3.4 Configuring XSD for Importing and Exporting
Use this procedure to configure the schema definition for the export.
18.6.3.5 Exporting XSD Data
After configuring the data to be exported, you can proceed with the import or export process.
- Choose Records then Import/Export.
- Choose Export with Schema.
- On the Export with Schema page, choose a schema name from the list.
- Expand the existing archive batch names and select an archive batch name.
- Click Export.
18.6.3.6 Importing XSD Data
Follow a similar procedure to import an archive using XSD mapping by choosing Import with Schema from the menu.
-
Choose Records then Import/Export.
-
Choose Import with Schema.
-
On the Import with Schema page, choose a schema name from the list.
-
Select an archive file by clicking Browse and navigating to the location where archives are located.
-
Click Import.