---
title: "Automatic Oracle Custom Code Upload via API"
slug: "automatic-custom-code-upload-via-api"
updated: 2025-01-27T09:36:50Z
published: 2025-01-27T09:36:50Z
---

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

# Automatic Oracle Custom Code Upload via API

**Prerequisites** .NET Framework, [version 4.6.2](https://dotnet.microsoft.com/en-us/download/dotnet-framework/net462) and above

## **Configuring Oracle Wallet**

Follow [these instructions to extract the Panaya certificate](/v1/docs/how-to-download-panayas-certificate) from your browser, then -

1. Create a new wallet in the default location ($ORACLE_HOME/wallets/) named as the RDBMS owner
2. Upload the CER to the Oracle Wallet
3. Save and give it a password (a1234567 for example) and check the "auto login"
4. Change the following 2 lines in the script to align with your Oracle Wallet definition ![](https://cdn.document360.io/f404076c-de23-4609-848e-2dfd4ef701b0/Images/Documentation/image-1639855983880.png)

---

## **Creating Program Executable**

Create the program executable as described below.

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

---

## **Creating a Concurrent Program**

Create a concurrent program with the relevant parameters as described below.

| 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 Table**

| Parameter | Description | Enable | Value Set | Default Type | Default Value | Required | Prompt |
| --- | --- | --- | --- | --- | --- | --- | --- |
| Panaya_User | Panaya user | ✓ | 100 Characters | Constant | Panaya account user | ✓ | Panaya user |
| Panaya_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&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 |

---

## **Linking the concurrent program**

Link the concurrent program to the relevant Request Group.

---

## **Saving in a Custom Top Folder**

Save the [Panaya Shell Script](https://cdn.panaya.com/customer_education/Success Center/PTL/2022/ver2/XXPANuploadETL_sh_plsql.zip) under your custom top folder (/bin).