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) and upload it to the Oracle Application server
2. Download the Panaya Shell Script and update the command you usually use to run an extraction, as shown in the example below
   
   
   
   If a connection string is required to connect to the database, check the options suggested here
3. Update the waller_dir location created in previous steps
4.  Copy the shell script to your FND_TOP bin folder using WinSCP
   
   
    
5.  Create a link to the kernel script using fndcpesr, and verify the link was created using ls -la XX*:
   
   
    
6. Allow executable rights to the script using chmod 744 <Script file name>
   
   
    
7. Log in to the Oracle EBS business suite and create the program executable, according to the values guide shown 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

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
   
   
    
9. Fill in the rest of the values and save your changes
   
    
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
    ErpId	Erp id	✓	100 Characters	Constant	Panaya system id To get your ErpID, contact Panaya Support	✓	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

    
    
    
    
    If you begin typing the name of the concurrent program (e.g. XXPAN) and hit enter, a selection list will be displayed
    
    
    
11. Save your changes
12. Submit a Request