---
title: "How to configure DBA-free patch analysis"
slug: "how-to-configure-dba-free-patch-analysis"
updated: 2025-01-27T09:38:10Z
published: 2025-01-27T09:38:10Z
---

> ## Documentation Index
> Fetch the complete documentation index at: https://success.panaya.com/llms.txt
> Use this file to discover all available pages before exploring further.

# 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.

**Prerequisites**

- TLS 1.3 protocol support
- A successful connection to Panaya using wget:

wget --no-check-certificate https://emea.panaya.com/ **or** wget --no-check-certificate [https://my.panaya.com/](https://my.panaya.com/)

1. [Download the Panaya Shell Script](https://cdn.panaya.com/customer_education/Success%20Center/PTL/2023/XXPAN_PTL_EXTRACT.zip)
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:  
  
**![](https://cdn.document360.io/f404076c-de23-4609-848e-2dfd4ef701b0/Images/Documentation/245_245.jpg)**
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](https://cdn.panaya.com/customer_education/Success%20Center/PTL/XXPAN_PTL_EXTRACT.ldt), 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:  
  
![](https://cdn.document360.io/f404076c-de23-4609-848e-2dfd4ef701b0/Images/Documentation/concurrent%20XXPAN%20PTL%20extract(1).jpg)  
 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](/v1/docs/how-to-create-your-token) | ✓ |
| ErpId | Erp id | ✓ | 100 Characters | Constant | Panaya system id To get your ErpID, contact [Panaya Support](/v1/docs/check-out-panayas-support-portal). | ✓ |
| 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:

![](https://cdn.document360.io/f404076c-de23-4609-848e-2dfd4ef701b0/Images/Documentation/patch%20lang.jpg)

![](https://cdn.document360.io/f404076c-de23-4609-848e-2dfd4ef701b0/Images/Documentation/patch%20code%20line.jpg)

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

![](https://cdn.document360.io/f404076c-de23-4609-848e-2dfd4ef701b0/Images/Documentation/completed%20form(1).jpg)

Important!

Using this method, you cannot use split/special request/one-off patches.