Automatic Custom Code Upload via Middleware

Prev Next

This article explains how to how to set up automatic custom code upload using Middleware
For other methods, click here

Prerequisites

  • TLS 1.2 protocol support 
  • Oracle EBS DB version 12.1.0.2 and above

Before you continue

  • It is highly recommended to set up the Middleware connection on a demo Panaya system.
    Contact Panaya Support to set up a Panaya demo system. 

Important

  • Use a Panaya administrator user with the API Execute and Code Box - Upload ETL permissions
  • Retrieve your system ID from Panaya Support or by using an API Call command
  • Use Postman, CURL, or another similar tool to test the upload before configuring your Middleware
  • The API upload limit is 2 per day. When performing connection tests, request Panaya Support to increase the limit to up to 20 calls per day
  • File upload is done in multipart/form-data
  • Postman/Curl automatically retrieves HTTPS certificates, if your system requires manual installation of certificates, download the Panaya certificate and install it prior to initiating any calls.
  • In case Proxy is defined for your server, your Middleware should include the user/pass/URL:port of the proxy in order to reach the Panaya site.

Good to Know

  • After a file has been uploaded to Panaya and begins processing, a new file cannot be uploaded until the first upload has been processed.
  • If you try to upload a new file during the processing of a previous upload, you will receive the following error message -
     "status":"401", "error":"Unauthorized", "cause" :"ETL is currently processed on Panaya server.", "panaya_code":"4019"
  • If you see this message, contact Panaya Support in order to reset the automatic upload process

The process of uploading an extraction file to Panaya consists of the following steps - 

  1. Generate an extraction file by running the extraction process
  2. Scheduling the extraction process - this automates the creation of the extraction file on schedule (e.g. Once a week)
  3. Authentication - the middleware will authenticate with the Panaya account via the login API method and receive a token
  4. Upload the middleware will fetch the file from its location and upload it via the upload ETL API method