---
title: "How to configure the concurrent program for automatic custom code?"
slug: "how-to-configure-the-concurrent-program-for-automatic-custom-code"
updated: 2025-01-27T09:36:11Z
published: 2025-01-27T09:36:11Z
---

> ## 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 the concurrent program for automatic custom code?

This article explains how to configure your EBS to work with a concurrent program to upload the custom code extraction file to the Panaya servers regularly.

1. [Download the Oracle extraction tool (panaya-extractor.jar)](/v1/docs/how-to-extract-upload-a-patch-for-ongoing-changes-analysis) and upload it to the Oracle Application server
2. [Download the Panaya Shell Script](https://cdn.panaya.com/customer_education/Success Center/PTL/2022/ver2/XXPANuploadETL_sh_plsql.zip) and update the command you usually use to run an extraction, as shown in the example below  
  
**![](https://cdn.document360.io/f404076c-de23-4609-848e-2dfd4ef701b0/Images/Documentation/image-1639854786713.png)**  
  
If a connection string is required to connect to the database, check the options suggested [here](/v1/docs/unable-to-connect-to-db-error-message-while-running-the-custom-code-patches-extraction)
3. Update the waller_dir location created in previous steps
4. Copy the shell script to your FND_TOP bin folder using WinSCP  
  
**![](https://cdn.document360.io/f404076c-de23-4609-848e-2dfd4ef701b0/Images/Documentation/image-1639854805677.png)**
5. Create a link to the kernel script using fndcpesr, and verify the link was created using ls -la XX*:  
  
**![](https://cdn.document360.io/f404076c-de23-4609-848e-2dfd4ef701b0/Images/Documentation/image-1639854818916.png)**
6. Allow executable rights to the script using chmod 744 <Script file name>  
  
**![](https://cdn.document360.io/f404076c-de23-4609-848e-2dfd4ef701b0/Images/Documentation/image-1639854828531.png)**
7. Log in to the Oracle EBS business suite and create the program executable, according to the values guide shown below  
  
**![](https://cdn.document360.io/f404076c-de23-4609-848e-2dfd4ef701b0/Images/Documentation/image-1639854837750.png)**  
  
 

| Activity **Field** | **Value you should choose** | **Panaya Recommended Value** |
| --- | --- | --- |
| Executable | Any executable User name you choose | XXPAN : Automatic ETL Upload |
| Short Name | Any executable Short name you choose | XXPAN_AUTO_ETL_UPLOAD |
| Application | Custom application |  |
| Description | Any executable Description you choose | XXPAN : Automatic ETL Upload |
| Execution Method | Host | Host |
| Execution File Name | Xxpanuploadetl | XXPANuploadETL |
8. Fill in the required values.  
The value for Application should be applied according to your system setup.  
In the example below, the value for Application is Application Object Library  
  
**![](https://cdn.document360.io/f404076c-de23-4609-848e-2dfd4ef701b0/Images/Documentation/image-1639854873146.png)**
9. Fill in the rest of the values and save your changes  
![](https://cdn.document360.io/f404076c-de23-4609-848e-2dfd4ef701b0/Images/Documentation/image-1639854886458.png)
10. Create a concurrent program with the following relevant parameters  
 

| Activity **Field** | **Value you should choose** | **Panaya Recommended Value** |
| --- | --- | --- |
| Program | Any concurrent program name you choose | XXPAN : AUTOMATIC ETL UPLOAD |
| Short Name | Any concurrent program short name you choose | XXPAN_AUTO_ETL_UPLOAD |
| Application | Custom application |  |
| Description | Any concurrent program description you choose | XXPAN : AUTOMATIC ETL UPLOAD |
| Executable Name |  | XXPAN_AUTO_ETL_UPLOAD |

 

| Parameter | Description | Enable | Value Set | Default Type | Default Value | Required | Prompt |
| --- | --- | --- | --- | --- | --- | --- | --- |
| Panaya_User | Panaya user | ✓ | 100 Characters | Constant | Panaya account user | ✓ | Panaya user |
| Access Token | Panaya Access Token | ✓ | 150 Characters | Constant | Panaya access token | ✓ | [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](mailto:support@panaya.com?subject=Request%20for%20ErpID&amp;body=Request%20for%20ErpID) | ✓ | ERP ID |
| FilePath | File path | ✓ | 100 Characters | Constant | Where the ETL jar file is located | ✓ | file path |
| Apps_Pass | Apps password | ✓ | 100 Characters | Constant | Apps schema password | ✓ | apps password |
| System Pass | System User assword | ✓ | 100 Characters | Constant | System DB schema password | ✓ | system user password |
| panaya_site | Panaya site | ✓ | 100 Characters | Constant | my.panaya.com emea.panaya.com | ✓ | Panaya site |

![](https://cdn.document360.io/f404076c-de23-4609-848e-2dfd4ef701b0/Images/Documentation/image-1639854906051.png)  
  
![](https://cdn.document360.io/f404076c-de23-4609-848e-2dfd4ef701b0/Images/Documentation/image-1639854919579.png)  
  
If you begin typing the name of the concurrent program (e.g. XXPAN) and hit enter, a selection list will be displayed  
  
**![](https://cdn.document360.io/f404076c-de23-4609-848e-2dfd4ef701b0/Images/Documentation/image-1639854954946.png)**  
![](https://cdn.document360.io/f404076c-de23-4609-848e-2dfd4ef701b0/Images/Documentation/image-1639854989767.png)
11. **Save**your changes
12. Submit a Request  
![](https://cdn.document360.io/f404076c-de23-4609-848e-2dfd4ef701b0/Images/Documentation/image-1639855003444.png)  
![](https://cdn.document360.io/f404076c-de23-4609-848e-2dfd4ef701b0/Images/Documentation/image-1639855029895.png)  
![](https://cdn.document360.io/f404076c-de23-4609-848e-2dfd4ef701b0/Images/Documentation/image-1639855041990.png)  
![](https://cdn.document360.io/f404076c-de23-4609-848e-2dfd4ef701b0/Images/Documentation/image-1639855053041.png)