8 Setting Up PCM Offsite Storage

This section explains how to set up and manage offsite storage in Physical Content Management. Offsite storage is an optional feature that enables users to set up requests for storage and to track storage processing.

This chapter covers the following topics:

Concepts

Tasks

8.1 Using Offsite Storage

With this release of Oracle URM functionality has been added to to allow customers to integrate storage with Iron Mountain SafeKeeper PLUS and other offsite storage facilities.

Important:

Iron Mountain configurations will vary from customer to customer. Be sure to test the integration in a development instance before using for production data.

The Offsite Storage link is an automated interface process for daily inventory and activity management between Oracle URM and offsite storage. This interface provides the following features:

  • the automated creation of requests, both reference and permanent, for boxes and files from offsite storage.

  • the automated creation of pickup requests for new and refiled boxes and files for storage and return to the offsite location.

  • transfer of transmittal and individual list data for new boxes and files, and transmittal and list maintenance for existing boxes and files.

  • the creation of a nightly log file listing inventory transaction history for a given day. This serves as a confirmation and data synchronization between the two systems.

To use this functionality, first map default values for different types of storage file formats to districts where the content is stored. Types of file formats include legal storage, insurance, loans, medical, and other storage types. Default districts are provided and default values for the fields used for storage.

After setting up the mapping, specify the storage parameters on the check-in page for physical content. After the content is checked in, a criteria workflow can be started to handle the approval of items pending transfer. This workflow must be created and enabled before the Offsite functionality can work. See the Oracle Fusion Middleware Setup Guide for Universal Records Management for details about setting up this workflow. While not required, it is recommended that this workflow be used.

Iron Mountain is currently the primary offsite provider. After the appropriate configurations are in place, the files are first stored on the computer before being sent to and from Iron Mountain using File Transfer Protocol (FTP). After the files are compiled, they are uploaded to the /toplus directory in the software directory structure.

A confirmation file is sent from Iron Mountain and stored in the /fromplus directory in the Iron Mountain directory structure. A nightly history download log is also stored in the /fromplus directory after each night's district job is processed. Verify beforehand that the chosen FTP location has these directories already created.

Pickup lists are automatically created for items that must be transferred. Manual pickup lists can also be created as needed.

8.1.1 Setting Up Default Customer Information

First set up default customer information about the account to be used by the offsite provider. These defaults identify your company to the provider and are used to monitor and process offsite requests.

Follow these steps to configure defaults for offsite storage.

  1. Click Physical then Settings from the Top menu.

    The Configure Physical Content Management Page is displayed.

  2. Click Enable Offsite Storage Functionality then click Submit Update. The Configure Physical Content Management Page is displayed.

  3. Refresh the browser window. Click Physical then Offsite Storage then General Setup.

    The Offsite Storage General Setup Page is displayed.

  4. Fill in the necessary fields:

    • Customer ID: the customer ID used with this offsite storage facility.

    • Default District: the district to use. Select from a predefined list. If the district has not previously been defined, the definition must be mapped beforehand. See "Mapping New Districts" for details.

    • FTP Address: enter the address associated with the FTP site.

    • FTP User: enter the user associated with the FTP site.

    • FTP Password: enter the password associated with the FTP site.

    • Transfer checkboxes: choose options associated with the transfer:

      • Automatically transfer new items: enable automatic transfer of new items.

      • Automatically return checked-in items: enable automatic returns of items that have been checked in.

      • Enable workflow: start a workflow for this transfer action. The workflow must be created before this step. See the Oracle Fusion Middleware Setup Guide for Universal Records Management for details about creating the workflow.

      • Use general requestor for Offsite Requests: choose a user from the list to use as the requestor. There is a limit of five characters for this value.

    • Box Identifier: choose what identifier will be associated with the box. Options include Name or Title.

  5. When done click Submit Update.

    A message is displayed indicating the offsite storage data has been configured.

8.1.2 Mapping New Districts

Several default districts are provided with Physical Content Management to use for offsite storage. Reconfigure any of these districts as necessary for your particular offsite solution.

The district mapping uses a wizard which steps through each stage of the process. When one stage is finished, the wizard displays the next screen in the process. For details about each screen and the fields displayed, see "District Mapping Screens".

The values used to populate the option lists for each field are based on data provided by Iron Mountain. For details about the field values, consult Iron Mountain documentation.

Follow this procedure to map district data:

  1. Click Physical then Offsite Storage then Map District Metadata from the Top menu.

    The Choose District Mapping Page is displayed.

  2. Select a district to configure from the list by scrolling through the list and highlighting a selection. Click Configure to select the district.

  3. The next screen in the wizard appears. The process for mapping information is the same on each screen. Scroll through the values provided for the different fields and highlight a selection.

    Click Save to proceed to the next screen in the process. Click Exit the Wizard to exit the process without saving selections. Click Reset to clear the selections on the current screen. To move forward or back in the process and skip screens, select a different page from the page menu at the top of the screen.

    Eight screens are available for configuration:

    1. map box metadata

    2. map standard file metadata

    3. map account file metadata

    4. map insurance (1) metadata

    5. map insurance (2) metadata

    6. map law metadata

    7. map loan file metadata

    8. map medical file metadata

  4. When finished configuring districts, click Save. A message is displayed indicating a successful exit from the wizard.

8.1.3 Creating Manual Pickup Requests

This function can be used to create requests to the offsite storage provider for pick up of materials.

Use this procedure to set up pickup requests:

  1. Click Physical then Offsite Storage then Create Manual Pickup Request from the Top menu.

    The Create Manual Pickup Page is displayed.

  2. Select a district ID from the list of IDs.

  3. Enter a pickup location or select a location by using the Browse button to look at stored locations.

  4. Enter the remainder of the information on the page.

  5. To discard entries, click Reset. When done, click Submit Update.

8.1.4 Browsing Uploaded Files

You can browse all of the uploaded files and view the status of the files. If a file has failed to upload, the upload request can be resent from this page.

Use this procedure to view files:

  1. Click Physical then Offsite Storage then Uploaded Files List from the Top menu.

    The Browse Uploaded Files Page is displayed.

  2. To work with a file, check the box next to the file name. To delete a file, select Delete from the Table menu or the item's Action menu. To resend a file for processing, select Resend.

8.1.5 Browsing Processed Files

You can browse all of the processed files and view the status of the files. If a file has errors, you can then use this page to correct the errors.

Use this procedure to view files:

  1. Click Physical then Offsite Storage then Processed History Files List Listfrom the Top menu.

    The Browse Processed History Page is displayed.

  2. To delete a file, check the box next to the file name then select Delete from the Table menu or the item's Action menu.

8.1.6 Transferring Files to Offsite Storage

Transferring files for offsite storage occurs in two stages: files must first be generated then transfered.

To generate files for files for transferring, click Physical then Offsite Storage then click Generate Offsite Transfer Files from the Top menu.

To upload, download, or process the files, click Physical then Offsite Storage then click Upload, Download, Process Offsite Files from the Top menu. The files will be automatically transferred with other scheduled batch processes during the nightly services that are processed.