Migrating from INVOICEIT to PROCESSIT

Introduction

Audience

PROCESSIT Application Migration Guide is intended for ReadSoft or Partner consultants who are familiar with PROCESSIT, and have been trained and certified on the product. The guide describes how to migrate from ReadSoft INVOICEIT to ReadSoft PROCESSIT.

To perform tasks described in this guide, the following is assumed:

  • General level understanding of service-oriented application (SOA) concepts and Oracle Fusion Middleware
  • Working level understanding of Oracle E-Business Suite (Purchasing and Accounts Payable modules

Migration Process Overview

The ReadSoft INVOICEIT to PROCESSIT Application Migration enables you to migrate invoice data objects, such as URLs, invoice images, invoice data, reminders, match hold setup rules, and invoice activity history from the INVOICEIT schema tables to the PROCESSIT schema tables. Within the PROCESSIT Migration Utility program, you can select to view the migration log, which provides allows you to view and track all of the objects that have been migrated.

The migration begins with installing the PROCESSIT Migration Utility into any Microsoft Windows workstation. The next steps involves running the migration utility from your Microsoft Windows Start Menu, and verifying that the proper INVOICEIT 3.x database connection information is available in the data source area of the screen (on the left side), and that the PROCESSIT database connection information is available on the target area of the screen (on the right side).

As the final step, you'll run the migration utility. Once completed, you may use the Search function within the PROCESSIT application to search and display migrated invoices.

Managing Existing Active Workflows

As in situations where application data is being migrated to another application, the workflow processes that are already in-flight can pose significant concern. As such, careful consideration should be given to the approach and impact of the application migration if there are active workflows.

In any environment, it is possible to have active long-running workflow processes that require human interaction that need to be considered. For example, suppose that you have an invoice approval workflow that requires several levels of approval due to the amount involved and takes several days for all respective approvers to respond. As such, this is an example of an active long-running workflow.

Active long-running workflows can impact your application migration approach, coordination, and timeline for upgrading to PROCESSIT. You should consider the most optimal approach to upgrading based upon what best suits your organization's timing, personnel, and overall objectives.

In essence, there are two viable options to consider to assist with this transition, which include:

Option 1 (Recommended Option)

Complete processing of all active workflows successfully within INVOICEIT before migrating them to PROCESSIT, then discontinuing to use INVOICEIT, and starting any new invoice processing activity with the new PROCESSIT environment.

If you are upgrading to PROCESSIT in conjunction to an Oracle E-Business Suite R12 upgrade or if Oracle E-Business Suite R12 is already implemented, this is the preferred and recommended option.

Option 2

Implement PROCESSIT as a parallel environment to your existing INVOICEIT implementation, begin any new invoice processing activity within PROCESSIT, complete processing of previous invoices already in-flight within INVOICEIT to a successful completion, migrate those invoices to PROCESSIT, discontinue the use of INVOICEIT, and begin using PROCESSIT for all invoice processing activity.

If you are upgrading to PROCESSIT while still running Oracle E-Business Suite 11i, you may proceed with either migration option. Although Option 1 is still the recommended approach.

The migration utility is looking for an invoice status of FLOW_COMPLETED in order to migrate the invoice data from INVOICEIT to PROCESSIT. Therefore, only invoices that have been completed through workflow will be migrated to PROCESSIT. The migration utility can be run multiple times, to enable invoice flows that could not be migrated originally because they were not completed, to be migrated at a later time.

Migration Prerequisites

Before you begin the migration process, these requirements must be met:

  • Available Windows workstation for installing the migration utility
  • Network access to both the INVOICEIT and the PROCESSIT databases
  • Microsoft's .NET Framework (2.0 or higher)
  • Oracle Data Access Components 11.2 Release 2(11.2.0.1.2)
  • PROCESSIT Migration Utility executable
  • INVOICEIT database server name, port, SID/service name
  • INVOICEIT xxit3 database user password
  • PROCESSIT database server name, port, SID/service name
  • PROCESSIT d4 database user password

Install Migration Utility

To migrate applications from INVOICEIT to PROCESSIT, you must install the migration utility:

  1. Navigate to the file system where the installer is located,
  2. Open setup.msi. This starts the Setup Wizard.
  3. Click Next.
  4. Select the folder where the migration utility is installed.
  5. Click Next.
  6. Confirm the installation
  7. Click Next to install the migration utility.
  8. Once the installation is complete, click Close to exit.

Open Migration Utility

Accessing the installed migration utility can be done via the Windows Start Menu:

  1. Click All Programs
  2. Select PROCESSIT
  3. Select ProjectITMigration

Invoke Data Migration

  1. Navigate to the Invoice Migration tab.
  2. Supply values for the INVOICEIT database you are migrating from:
    • User/Schema - defaulted to XXIT3
    • Password
    • Host
    • Port
    • Service Name or SID
    • Batch Size
  3. Supply values for the PROCESSIT system you are migrating to:
    • User/Schema - defaulted to D4
    • Password
    • Host
    • Port
    • Service Name or SID
    • Image repository
  4. You can test the outcome for both databases by clicking Test.
  5. Navigate to the Profile Migration tab.
  6. Review and verify the map profile of the INVOICEIT configuration parameters to PROCESSIT parameters. The list of INVOICEIT configuration options is dynamically created based upon what is included in Oracle E-Business Suite, and has been made extensible to allow for future mapping to new PROCESSIT configuration options as they emerge in future releases.
  7. Click Transfer to invoke the migration.

The migration utility transfers invoice records from tables xxit3_invoices and xit3_invoice_lines in the INVOICEIT database, to tables d4_invoices and d4_invoice_lines in the PROCESSIT database.

If required, the migration utility can be run multiple times until all invoices residing in INVOICEIT are migrated to PROCESSIT.

Only invoices that were imported into Oracle Accounts Payable are migrated to PROCESSIT.

Invoice Image Transfer Notes">

Only invoices residing within INVOICEIT with a status of FLOW_COMPLETED are migrated. This means that any invoices that are still active at the time of migration are not migrated.

If the invoice images were stored in the INVOICEIT database (i.e. not in an external archive), the invoice images are transferred from the xxit3_interface table in INVOICEIT to the d4_archive table in PROCESSIT.

If invoice images were stored in an external archive, the URL pointer to those images is migrated to PROCESSIT for access to the images.

If Oracle E-Business Suite is upgraded from release 11i to R12 (as opposed to re-implemented), and the historical 11i invoice records exist in the R12 environment with identical AP invoice IDs, then the migration utility updates the image attachment URL to the invoices in AP. This ensures that invoice images are available from the Invoice Workbench in Oracle Payables as well.

Migrating System Configuration

The migration utility transfers all relevant and comparable configuration options from INVOICEIT to PROCESSIT.

For configuration options without a one-for-one match between INVOICEIT and PROCESSIT features, and that which is available in PROCESSIT, you must perform the configuration using PROCESSIT Configuration Manager.

PROCESSIT Configuration Quick Guide

  1. Login to PROCESSIT using administrator credentials
  2. Click the Configuration Manager button in the main menu.
  3. Click Parameter Management.
  4. Review the imported parameters.
  5. Edit existing parameters or create new to configure PROCESSIT processes correctly.
  6. You can select specific categories or search for specific parameters to assist you in the review. You can also export the parameter list to facilitate a review with for instance Microsoft Excel.

Reviewing Your Migrated Invoices

Once migration is complete, you can search for and view the migrated invoices via PROCESSIT Search. The status processed is applied to invoices that were migrated from INVOICEIT to PROCESSIT.

PROCESSIT Search Quick Guide

  1. Login to PROCESSIT using administrator credentials
  2. Click the Search button in the main menu.
  3. Supply search criteria and click Seearch.

Use the search criteria field Status to search for all invoices with the status Processed.

THANK YOU!