Skip to main content

Introduction

This document covers the process that must be followed if you are upgrading an Oracle E-Business Suite 11i or 12.x environment to version 12.2.x and Wands for Oracle was already installed on your current 11i or 12.x E-Business Suite instance.

If you need assistance during the installation process, please contact our support team at e4asupport@insightsoftware.com.

Prerequisites

Please confirm your environment meets the prerequisites to run this version of Wands for Oracle by reviewing the prerequisites section in the Installation Guide - Oracle12.2 document.

Before attempting to install or upgrade please ensure that you have completed the following steps as set out in the Post Installation Tasks section of the Oracle E-Business Suite Upgrade Guide, Release 12.0 and 12.1 to 12.2, Part No. E48839-08:

  1. Apply the Latest AD and TXK for Release 12.2 (Page 5-4)

  2. Mandatory Steps for Custom Schema Upgrade for 11i / 12.0 / 12.1

Note: Do not run ADSplice when you are at the Oracle E-Business Suite Release 12.2.0 level. Before running ADSplice, you must upgrade to R12.AD.C.Delta.5 and 12.TXK.C.Delta.5 Release update packs or higher for AD and TXK.

Known Issues

Please review Oracle support note 1577707.1 section 6 for any known issues that might affect your upgrade before running the ADSplice steps below.

Upgrade

Pre-Upgrade Steps

Follow these instructions in order to prepare the system for the upgrade and to deploy the install files:

  1. Locate the Wands for Oracle install file. This is the complete zip file that was downloaded from our web site (which contained this installation guide). FTP it to the server as the applications user.

  2. Unzip the Wands for Oracle install file.

  3. Connect to the Run Edition file system on the target installation environment. Take careful note of the file system you are attached to as the steps below must be executed on the Run Edition file system.

Configure the Excel4apps custom applications

For the Excel4apps custom applications that already exist in the current Oracle E-Business Suite installation you must run ADSplice on the Run Edition file system to ensure that the custom application is correctly configured. This will ensure that customizations are preserved when applying patches or upgrades to your environment.

Run the ADSplice Utility

ADSplice is an Oracle utility that configures a product definition for custom applications. It requires some configuration files which must first be prepared.

  1. As the Applications node technology stack owner (applmgr), navigate to the folder on the server where you unzipped the install file.

  2. Navigate to the Wands for Oracle install folder that will have been created by the unzip process earlier.

  3. For UNIX systems, change permissions on the file “install.sh” to allow it to be executed.

  4. Run the Wands for Oracle installer to deploy the ADSplice configuration files by running the install.sh script in hot patch (-h) mode with the DEPLOY_ADSPLICE_FILES option as follows:

    UNIX:

./install.sh -h DEPLOY_ADSPLICE_FILES

Windows:

C:\>install.cmd -h DEPLOY_ADSPLICE_FILES

  1. Below is an example of the output that the installer will generate.

[applmgr@oracle122 wands_oracle21.1.0.0]$ ./install.sh –h DEPLOY_ADSPLICE_FILES

Installer Mode: DEPLOY_ADSPLICE_FILES

Wands for Oracle Installer Started

Enter the APPS username [APPS]: apps

Enter the APPS password:

Database Connection Details from Environment Context File:

/home/ebs122/oracle/VIS/fs1/inst/apps/VIS_oracle122/appl/admin/VIS_oracle122.xml

==========================================================

Server: oracle122

Port: 1525

Sid: VIS

Enter Y to use the following connection settings [Y]: Y

Enter Y to create custom tables in the APPS schema [N]: Y

Database Connection Details used for this installation: oracle122:1525:VIS

ADSPLICE Files Deployed Successfully

ADSPLICE Files Deployed Successfully

Custom Tables Created Successfully

Installer completed successfully

Program Exit Status=0

[applmgr@oracle122 wands_oracle21.1.0.0]$

  1. Review the output from the Wands for Oracle Installer and proceed to run ADSplice below unless instructed otherwise.

  2. Change directory to the admin directory under $APPL_TOP and run the ADSplice utility as follows:

[applmgr@oracle122 admin]$ cd $APPL_TOP/admin

[applmgr@oracle122 admin]$ adsplice

  1. Respond to the application prompts and specifically accept the default values for the following items:

Enter the directory where your AD Splicer control file is located.

The default directory is [/oracle/VIS/apps/apps_st/appl/admin] :

Please enter the name of your AD Splicer control file [newprods.txt] :

Do you wish to regenerate your environment file [Yes] ?

  1. The ADSplice process will now run. When prompted to regenerate your environment file i.e. Run AutoConfig, please select Yes.

    1. Review the ADSplice log file to ensure the procedure completed successfully.

    2. Review the AutoConfig log file to ensure it completed successfully.

  2. After splicing all custom applications on the Run Edition file system, you must run adop phase=fs_clone. This ensures that all custom products are synchronized to the other file system.

  3. Once the above steps have been completed the existing Excel4apps custom applications will be synchronized across the run and patch file system. Initiate an adop prepare phase and connect to the Patch edition file system on the target installation environment.

  4. Resume installation steps in the Installation Guide - Oracle12.2 document at section 4.2.2 “Verify the Excel4apps custom applications”.

Was this article helpful?

We're sorry to hear that.