Extracting Patches for Ongoing Changes
  • 2 Minutes to read
  • Dark
    Light
  • PDF

Extracting Patches for Ongoing Changes

  • Dark
    Light
  • PDF

Article Summary

Panaya's Release Dynamix for Oracle EBS requires running a Java program on your Oracle Apps Server.
This article explains how to upload new Patches for Release Dynamix projects for ongoing changes. If you are working on a standalone Patches project in Panaya, follow the instructions provided in this article
Important
You must have uploaded at least one Custom Code extract to Panaya before uploading a patch extract for analysis.
Please also verify the code extraction (ETL) was uploaded in the last three months (90 days) for your system, else the Patch analysis will not succeed.
Before running the Patches Extraction Process,
please make sure that you meet the requirements


 

Uploading a Patch

  1. Log in to Panaya
  2. Click on the Menu button  and select a Project
    Select a project of type Testing or Ongoing Changes or create a new project
    To view the types of existing projects, use the Menu button to select All Projects.
  3. Select the Development tab
  4. Create a new Feature / Requirement or select an existing one from the list
  5. Click on the Requirement ID or Name to open up the Requirement / Feature details
  6. Select the Risk Analysis tab
  7. Select Code Changes
  8. Select Upload new Patches 
  9. Click on Download the Oracle extraction tool to download the extraction tool.
Always download the most updated version from this dialog box. We do not recommend using older versions previously downloaded.  


Extracting 

  1. Upload the downloaded panaya-ptl-extractor.jar file to your Oracle Application Server
  2. Change your working directory to the location of the panaya-ptl-extractor.jar
  3. Create directory that will contain only the ZIP files of the patches that you want to analyze before they have been installed
    Do not unzip or install the files.
  4. Using your Oracle Apps OS user (with access to the Oracle environments), execute one of the following commands -
java -jar panaya-ptl-extractor.jar <APPS password> <Patches directory>
or
java -jar panaya-ptl-extractor.jar [-prompt] <Patches directory> 
 
Parameters explanation
A) <APPS password> - Mandatory - The password of your APPS schema in the DB
B) <Patches directory> - Mandatory - The location of the patches you downloaded
C) [-prompt] - Optional -  this will open a dialog box for the user to enter the apps password. This will mask the password for cases where other users attempt to sign in to the system and execute the command ps -ef. 
 
An output directory will automatically be created for you during the patches extraction process. The directory's name will be output_<date>_<time>.
 

When running, the screen will look like this:


At the end of the process, one ZIP File will be created in your output directory (e.g., PTL_20121015_1259.zip), which you'll be asked to upload to the Panaya website.

If you don't have access from your Application server to the Panaya website, please copy the file from there.

If you are using a controlled release patch, here for additional instructions.
Follow the instructions described here if you are running the Patches extractor on the 12c database.

  1. Click browse and locate the zipped file created by the patches extraction process. You can also drop the ZIP file onto the cloud area.
  2. Click Upload
    The duration of the upload depends upon the size of the file. You can view the status of your Patches upload in the Code Changes section.
  3. Upon completion, you will be able to analyze Impact and Risk.