Oracle E-Business Suite

ActiveBatch supports the Oracle E-Business Suite platform. Within the overall rubric of Oracle Applications – Apps, Oracle Corporation's E-Business Suite (also known as Applications/Apps or EB-Suite/EBS) consists of a collection of enterprise resource planning (ERP), customer relationship management (CRM), and supply-chain management (SCM) computer applications either developed by or acquired by Oracle. The software utilizes Oracle's core Oracle relational database management system technology. The E-Business Suite contains several product lines, including:

 

  • Oracle CRM

  • Oracle Financials

  • Oracle HRMS

  • Oracle Mobile Supply Chain Applications

  • Oracle Order Management

  • Oracle Procurement

  • Oracle Project Portfolio Management

  • Oracle Quotes

  • Oracle Transportation Management

  • Oracle Warehouse Management Systems

  • Oracle Inventory

  • Oracle Enterprise Asset Management

 

Job Step Prerequisites

 

The following requirements must be adhered to when using the Oracle E-Business Suite job steps:

 

  1. Agent on local EBS system

  2. Java 1.8 must be installed and abatemgr.conf file should be updated with the path if the Execution Agent does not detect it automatically by the agent.

  3. Oracle_Home must be defined as an environment variable

  4. TNSNAMES file will be used to look up the Data Source defined within the get log job step.

  5. When the Job step completes the log contents can be retrieved using the context variable of the job step

 

 

This job step retrieves a Concurrent Program log file.

 

 

Job Step Properties

 

Job ID – This property is the Job ID for the Concurrent Program.

 

Connection Properties – A group of properties (as described below) that is necessary for connecting to an Oracle EBS system.

 

  • Apps User Account – This property represents a User Account object that contains the security credentials for accessing the Oracle EBS database. The user must be an APPS user or access to the APPS objects.

  • Data Source – This property represents the Oracle Data Source for the Oracle EBS database.

  • EBS User Account – This property represents a User Account objects that contains the credentials for the Oracle EBS user that will run the concurrent program.

 

Return Step Value

 

String – The log data.

 

 

This job step retrieves the Concurrent Program output stream.

 

 

Job Step Properties

 

Job ID – This property is the Job ID for the Concurrent Program.

 

Connection Properties – A group of properties (as described below) that is necessary for connecting to an Oracle EBS system.

 

  • Apps User Account – This property represents a User Account object that contains the security credentials for accessing the Oracle EBS database. The user must be an APPS user or access to the APPS objects.

  • Data Source – This property represents the Oracle Data Source for the Oracle EBS database.

  • EBS User Account – This property represents a User Account objects that contains the credentials for the Oracle EBS user that will run the concurrent program.

 

Return Step Value

 

String – The output data.

 

 

This is a job step that retrieves the Concurrent Program status.

 

 

Job Step Properties

 

Job ID – This property is the Job ID for the Concurrent Program.

 

Connection Properties – A group of properties (as described below) that is necessary for connecting to an Oracle EBS system.

 

  • Apps User Account – This property represents a User Account object that contains the security credentials for accessing the Oracle EBS database. The user must be an APPS user or access to the APPS objects.

  • Data Source – This property represents the Oracle Data Source for the Oracle EBS database.

  • EBS User Account – This property represents a User Account objects that contains the credentials for the Oracle EBS user that will run the concurrent program.

 

Return Step Value

 

String – The status of the job.

 

 

This job step checks and then stores the specified credentials that can then be used by the other Oracle EBS job steps. While the step is referred to as a “Login” there is no formal login to the Oracle EBS system. This step is a convenience in that it avoids you having to specify the “Connection Properties” information for each underlying step.

 

 

Job Step Properties

 

Connection Properties – A group of properties (as described below) that is necessary for connecting to an Oracle EBS system.

  • Apps User Account – This property represents a User Account object that contains the security credentials for accessing the Oracle EBS database. The user must be an APPS user or access to the APPS objects.

  • Data Source – This property represents the Oracle Data Source for the Oracle EBS database.

  • EBS User Account – This property represents a User Account objects that contains the credentials for the Oracle EBS user that will run the concurrent program.

 

 

This job step allows you to schedule a Concurrent Request.

 

 

Job Step Properties

 

Responsibility – This property represents the Responsibility role.

 

Application – This property represents the owning application

 

Program – This collection of properties represents the program to run and various options that are available as part of the Concurrent Request. When you select the property you’ll see an ellipsis to the far right. Clicking on that symbol causes a special editor to appear to enter and validate related properties.

 

Connection Properties – A group of properties (as described below) that is necessary for connecting to an Oracle EBS system.

 

  • Apps User Account – This property represents a User Account object that contains the security credentials for accessing the Oracle EBS database. The user must be an APPS user or access to the APPS objects.

  • Data Source – This property represents the Oracle Data Source for the Oracle EBS database.

  • EBS User Account – This property represents a User Account objects that contains the credentials for the Oracle EBS user that will run the concurrent program.

 

Language – This parameter indicates the language.

 

Wait for Completion – This Boolean property indicates whether the job step should wait for the Concurrent Request to be completed.

 

Write to ActiveBatch Log – This Boolean property indicates whether any output should be merged into the ActiveBatch log.

 

MOAC Settings – This collection of properties concerns Multi-Organization context.

 

Description – This free form property is a description of the concurrent request.

 

Start Time – An optional Start Date. By default, when omitted, the program will run immediately. Typically you would leave this blank to allow ActiveBatch to completely control the scheduling and execution of the program. If specified, the format is MM/dd/yyyy hhmmss (where “hh” is in 24-hour format).

 

Return Step Value

 

ConcurrentRequestInformation – This property consists of several properties returned from a successful job step; for example, the Job ID, Log and Output are returned (the latter two only if Wait for Completion is true).

 

 

This job step allows you to schedule a Concurrent Request Set.

 

 

Job Step Properties

 

Responsibility – This property represents the Responsibility role.

 

Application – This property represents the owning application Request Set – This property is name of the Request Set to run.

 

Connection Properties – A group of properties (as described below) that is necessary for connecting to an Oracle EBS system.

 

  • Apps User Account – This property represents a User Account object that contains the security credentials for accessing the Oracle EBS database. The user must be an APPS user or access to the APPS objects.

  • Data Source – This property represents the Oracle Data Source for the Oracle EBS database.

  • EBS User Account – This property represents a User Account objects that contains the credentials for the Oracle EBS user that will run the concurrent program.

 

Language – This parameter indicates the language.

 

Wait for Completion – This Boolean property indicates whether the job step should wait for the Concurrent Request Set to be completed.

 

Write to ActiveBatch Log – This Boolean property indicates whether any output should be merged into the ActiveBatch log.

 

MOAC Settings – This collection of properties concerns Multi-Organization context.

 

Start Time – An optional Start Date. By default, when omitted, the program will run immediately. Typically you would leave this blank to allow ActiveBatch to completely control the scheduling and execution of the program. If specified, the format is MM/dd/yyyy hhmmss (where “hh” is in 24-hour format).

 

Return Step Value

 

ConcurrentRequestInformation – This property consists of several properties returned from a successful job step; for example, the Job ID, Log and Output are returned (the latter two only if Wait for Completion is true).

 

 

This job step synchronizes a Concurrent Program (or Request Set).

 

 

Job Step Properties

 

Job ID – This property is the Job ID for the Concurrent Program.

 

Connection Properties – A group of properties (as described below) that is necessary for connecting to an Oracle EBS system.

 

Apps User Account – This property represents a User Account object that contains the security credentials for accessing the Oracle EBS database. The user must be an APPS user or access to the APPS objects.

Data Source – This property represents the Oracle Data Source for the Oracle EBS database.

EBS User Account – This property represents a User Account objects that contains the credentials for the Oracle EBS user that will run the concurrent program.

 

Return Step Value

 

String – The status of the job.