How to extract & upload a patch for analysis?

This information is relevant for standalone Patches or Upgrade projects. If you are using Release Dynamix, follow these instructions instead
Panaya’s solution requires running a Java program on your Oracle Apps Server. This program extracts the vanilla versions of the relevant files that exist in the patch in order for Panaya to present the impact on your Oracle environment.
You must upload 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 3 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
Extracting The Patches Files
To upload a patch:
  1. Login to Panaya
  2. Use the Menu button to select a Patches Project
  3. From with the Patches Project, hover over the Overview tab and select Changed Content

  4. In the Project Setup section, select Upload Content

  5. Click on Download the Oracle extraction tool to download the extraction tool
  6. It is recommended to download the most updated version from the Panaya Upload Content screen. Do not use older versions.
  7. Upload the panaya-ptl-extractor.jar file to your Oracle Application Server
  8. Change your working directory to the location of the panaya-ptl-extractor.jar
  9. Create a directory that will contain only the ZIP files of the patches that you want to analyze before they have been installed
  10. Do not unzip or install the files
  11. Using your Oracle Apps OS user (with access to the Oracle environments), execute one of the following commands
java -jar panaya-ptl-extractor.jar [-prompt] <Patches directory> 
Parameters explanation -
<APPS password> - Mandatory - The password of your APPS schema in the DB
<Patches directory> - Mandatory - The location of the patches you downloaded
[-prompt] - 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., 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.
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
Upload The Patches Extract File
  1. Select Click to browse and locate the zipped file created by the patches extraction process. You can also drop the ZIP file onto the cloud area.
  2. It is also possible to drop your customizations XLS file here. For more information click here.
  3. Select Start upload
  4. The duration of the upload depends upon the size of the file
  5. When the upload process is complete, you will be able to view the list of uploaded files below
  6. In order to activate the analysis of the patches, follow the Review & Analyze process
If the Review and Analyze wizard has not been followed, no tests will be created for your project!