How to configure DBA-free patch analysis

This article explains how to configure your EBS to work with a concurrent program to download a patch from Oracle and run the Panaya PTL extractor on your EBS. 

1. Download the Panaya Shell Script 
2. If you require a connection string, use the code on line 246 instead of 244, and be sure to fill in your hostname, port, and service name, as shown below:
   
   
3. Copy the shell script to your AU_TOP bin folder using WinSCP (or other file transfer tool)
   4. Create a link to the kernel script using the command fndcpesr, and verify the link was created using ls -la XX* -
   5. Allow executable rights to the script using chmod 744 XXPAN_PTL_EXTRACT.prog
   6. Upload the concurrent definitions to your Oracle EBS business suite using an Ldt file, and run this command-
   
   
   • FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct XXPAN_PTL_EXTRACT.ldt - WARNING=YES  UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE
     
     This will create a concurrent program called XXPAN PTL extract on your EBS application server:
     
     
      7. Fill in the values for all the following parameters and save your changes
     

     Parameter	Description	Enable	Value Set	Default Type	Default Value	Required
     Panaya_User	Panaya  user	✓	100 Characters	Constant	Panaya account user	✓
     Panaya Access Token	Panaya access token	✓	150 Characters	Constant	Panaya Access Token	✓
     ErpId	Erp id	✓	100 Characters	Constant	Panaya system id To get your ErpID, contact Panaya Support.	✓
     Destination Directory	File path	✓	100 Characters	Constant	Where the PTL will be created, mount share point.	✓
     Destination URL For sent email	The PTL URL path sent to you via email	✓	100 Characters	Constant	Link to where the PTL will be created, mount share point.	✓
     Apps_Pass	Apps password	✓	100 Characters	Constant	Apps schema password	✓
     Metalink Username	My Oracle Support username	✓	100 Characters	Constant	MOS username	✓
     Panaya Site URL	Panaya site	✓	100 Characters	Constant	my.panaya.com emea.panaya.com	✓
     Metalink   Password	My Oracle Support password	✓	100 Characters	Constant	password	✓

The following 3 Parameters need to be entered carefully with each patch analysis request, and the language and code line of the patch must be the same as maintained in Oracle Support for a specific patch:

Patch 1: Patch Number   (For example,  832349.A)
Patch 1: Platform or Language   (Need to select a value from available options)
Patch 1: Code Line                       (Need to select a value from the available option)

For the Patch Platform/Language and Code Line values, be sure to select them from the available options when you click on those fields in the program:

The completed form and all the fields should look something similar to this: