How to extract & upload a patch for ongoing changes analysis?

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.
Before running the Patches Extraction Process,
please make sure that you meet the requirements
 
To upload a patch -
  1. Login 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 from the list
    Use the All Development View Selection to display Requirements / Features Only (All Requirements / All Features)

  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

    It is recommended to download the most updated version from this dialog box. Do not use older versions previously downloaded.

To extract your code -

  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 a directory that will contain only the ZIP files of the patches that you want to analyze before they have been installed
  4. Do not unzip or install the files
  5. 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 up 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. 
     
    During the patches extraction process, an output directory will automatically be created for you. The name of the directory 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 Panaya web site.

    If you don’t have access from your Application server to the Panaya web site, please copy the file from there.

    Note
    If you are using a controlled release patch, please click here for additional instructions.
    If you are running the Patches extractor on 12c database, follow the instructions described here
  6. Click on browse and locate the zipped file created by the patches extraction process. You can also drop the ZIP file onto the cloud area.
  7. 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.


     
  8. Upon completion, you will be able to analyze Impact and Risk