Automating Oracle EBS Jobs

JAMS natively supports automation using many leading business applications, including the Oracle E-Business Suite. Integration Packs for this and other preferred applications are selected during the JAMS installation process. Once the Oracle E-Business Suite integration is enabled, users can create, manage, deploy and monitor every kind of Oracle EBS batch process job, regardless of where it resides.

Installing the Oracle E-Business Suite Integration Pack

To work with Oracle EBS in JAMS, users must install the Oracle E-Business Suite Integration Pack on the JAMS Scheduler Server and deploy an Agent to the Oracle Server. AgentD and AgentX can be used with this integration.

  • On the JAMS Scheduler Server, run the JAMS Installer.
  • On the Feature Selection step, ensure the JAMS Integration Pack for Oracle E-Business Suite component is checked. Do not clear the check boxes for any components unless those components should be uninstalled.
  • Finish the installation.
NOTE: Clearing the check boxes for components in the Feature Selection step will uninstall those components.

Configuring Oracle EBS Connection Strings

NOTE: If you're making a high volume of connections to your Oracle database, we advise consulting your DBA to ensure your Oracle Connection Pool settings are optimal for your usage.

The Oracle EBS Connection String allows users to connect to Oracle from within JAMS. This connection string must be properly configured to run Oracle Jobs in JAMS. The Oracle EBS connection should be configured on each Oracle EBS Execution Method in JAMS.

Users may override the connection string configured on an Execution Method by configuring a Connection String Parameter at the Folder level or Job level.

The connection string in the OEBSConnectionString Parameter must have the User Id and Password options defined. To define the values, enter placeholders for the User Id and Password options. For example, enter “User Id = {0}; Password = {1};”. The placeholders are replaced with values from the selected Oracle Credential field on the Source tab in the Job Definition.

NOTE: You must set up a Credential within JAMS before you create the Oracle Jobs. See Working with User Credential Definitions for more information.
NOTE: If the User on an Oracle EBS Job has OS Authentication permissions to Oracle, then JAMS will pass the credentials from the User into the defined connection string during execution, and an Oracle user is not needed in the Job's source. If the User on the Job does not have OS Authentication, an Oracle user must be defined in the dropdown list that has permissions to the oracle Database.

Configure the Oracle EBS Connection on the Execution Method

  1. Run the JAMS Client as an administrator.
  2. Select the Execution Methods shortcut from the menu.
  3. Double-click an Oracle EBS Execution Method to open the Execution Method Properties dialog.
  4. On the Parameters tab, double-click the OEBSConnectionString Parameter.  
  5. Set the Default Value to the following, with "Host=Orchid64" and "SERVICE_NAME=MVP" adjusted to values that match the given environment.
    User Id = {0}; Password = {1}; Data Source = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = Orchid64)(PORT = 1521))(CONNECT_DATA = (SERVICE_NAME = MVP)));
  6. Click Save and Close the  dialog.
  7. Click Save and Close the Execution Method dialog.

Configure the Oracle EBS Connection on the Folder level

A Connection String should ONLY be defined at the Folder level if users want to override the Execution Method level Connection Strings. The Folder level Connection String will apply to all Oracle EBS Jobs within that folder.

  1. Right-click the desired Folder and select Properties.
  2. Select the Parameters tab, and check for a Parameter named OEBSConnectionString. If this Parameter does not yet exist on the folder, click the Add Item button and select Add Parameter.
  3. In the Add a Parameter dialog, name the Parameter OEBSConnectionString.
  4. Ensure the Data Type is set to Text. 
  5. Set the Default Value to the following, with "Host=Orchid64" and "SERVICE_NAME=MVP" adjusted to values that match the given environment.
    User Id = {0}; Password = {1}; Data Source = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = Orchid64)
(PORT = 1521))(CONNECT_DATA = (SERVICE_NAME = MVP)));

  6. Save and Close the Folder Properties.

Configure the Oracle EBS Connection on the Job level

A Connection String Parameter should ONLY be defined at the Job level if users want to override Execution Method or Folder level Connection Strings.

  1. Right-click a Job and select Properties.
  2. Select the Parameters tab, and check for a Parameter named OEBSConnectionString. If this Parameter does not yet exist on the Job, click the Add Item button and select Add Parameter.
  3. In the Add a Parameter wizard, name the Parameter OEBSConnectionString.
  4. Ensure the Data Type is set to Text.
  5. On the Parameter Value step, set the Default Value to the following, with "Host=Orchid64" and "SERVICE_NAME=MVP" adjusted to values that match the given environment.
    User Id = {0}; Password = {1}; Data Source = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)
(HOST = Orchid64)(PORT = 1521))(CONNECT_DATA = (SERVICE_NAME = MVP)));

     
  6. Click Save and Close on the Job Properties.

Creating Oracle EBS Jobs in JAMS

JAMS offers OracleEBSConcurrent, OracleEBSJobSsh, and OracleEBSRequestSet Execution Methods to run Oracle EBS Jobs.

The OracleEBSConcurrent Execution Method gives users a series of automatically populated drop-down fields to run Concurrent Jobs, including the ability to view and set each parameter on the Concurrent Job from within JAMS.

The OracleEBSJobSsh Execution Method gives users a fill in the blank style form to run Concurrent Jobs from within JAMS. The advantage of the fill in the blank form over the OracleEBSConcurrent Execution Method is that field values in the Job Source may be defined as JAMS Parameters. By using Parameters in the Job Source, users can create a self-service Oracle Job from within JAMS.

The OracleEBSRequestSet Execution Method gives users a series of automatically populated drop-down fields to run Request Sets, including the ability to see each Concurrent Job (and modify the Concurrent Job's Parameters) within the Request Set.

Creating OracleEBSConcurrent Jobs in JAMS

  1. Select the desired folder for the OEBSConcurrent Job, and ensure the Job Definitions tab is selected.
  2. Click the Add button from the Control Bar to open the Add a New JAMS Job Definition dialog.
  3. In the dialog, give the new Job a Name, Description (optional), and Execution Method.
    In this case, select OracleEBSConcurrent to create an Oracle EBS Concurrent Job.
  4. Click OK. The Job Definition dialog is displayed.
  5. Define Elements, Parameters, Security, Properties, and Documentation as desired.
  6. On the Source tab, set the Oracle Credential. This user should have access to the Oracle Database.
  7. Select the Application User from the automatically populated drop-down list. 
  8. Select the Responsibility group from the automatically populated drop-down list.
  9. Select the relevant Application from the automatically populated drop-down list.
  10. Select the Concurrent Program to be run from the automatically populated drop-down list. The Parameters section of the Source will automatically populate with the Concurrent Program's available Parameters.
  11. Set Source Parameters as desired, ensuring that required Parameters have values.
  12. Click Save and Close to finish editing the Job Definition.

Creating OracleEBSJobSsh Jobs in JAMS

OracleEBSJobSsh Jobs in JAMS provide a fill-in-the-blank style form for users to configure their Concurrent Oracle Jobs in JAMS. The benefit of the fill-in-the-blank form over the automatically populated drop-down list of the OracleEBSConcurrent Execution Method is the parametrization of field values. By using Parameters in the Job Source, users can create a self-service Oracle Job from within JAMS.

  1. Select the desired folder for the OracleEBSJobSsh Job, and ensure the Job Definitions tab is selected.
  2. Click the Add button from the Control Bar to open the Add a New JAMS Job Definition dialog.
  3. In the dialog, give the new Job a Name, Description (optional), and Execution Method.
    In this case, select OracleEBSJobSsh to create an Oracle EBS Ssh Job.
  4. Click OK. The Job Definition dialog is displayed.
  5. Define Elements, Parameters, Security, Properties, and Documentation as desired.
  6. In the Source, specify the information on the Job to run in Oracle EBS. See the available fields and their Oracle counterparts below.
    JAMSOracle
    Job NameProgram Shortname
    Application Short NameProgram Application Shortname
    Responsibility Short nameResponsibility App Shortname
    Responsibility NameResponsibility Name
    UsernameUsername
    ParametersParameters

    Note that Parameters in the Parameters field are space delimited.
  7. Click Save and Close on the Job Definition.

Creating OracleEBSRequestSet Jobs in JAMS

  1. Select the desired folder for the OracleEBSRequestSet Job, and ensure the Job Definitions tab is selected.    
  2. Click the Add button from the Control Bar to open the Add a New JAMS Job Definition dialog.
  3. In the dialog, give the new Job a Name, Description (optional), and Execution Method.
    In this case, select OracleEBSRequestSet to create an Oracle EBS Request Set Job.
  4. Click OK. The Job Definition dialog is displayed.
  5. Define Elements, Parameters, Security, Properties, and Documentation as desired.
  6. On the  Source tab, set the Oracle Credential. This user should have access to the Oracle Database.
  7. Select the Application User from the automatically populated drop-down list.
  8. Select the Responsibility group from the automatically populated drop-down list.
  9. Select the relevant Application from the automatically populated drop-down list.
  10. Select the Request Set to be run from the automatically populated drop-down list. The Request Set Jobs section will populate with a list of the Concurrent Programs in the Request Set.
  11. Select a Concurrent Program and then click the Parameters button to open the parameters of a Concurrent Program within the Request Set.
  12. In the Parameters dialog, set Parameter values as desired, and then click OK.
  13. Click Save and Close to finish editing the Job.