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:

Agent on local EBS system
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.
Oracle_Home must be defined as an environment variable
TNSNAMES file will be used to look up the Data Source defined within the get log job step.
When the Job step completes the log contents can be retrieved using the context variable of the job step

Get Concurrent Program Log

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.

Get Concurrent Program Output

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.

Get Concurrent Program Status

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.

Login

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.

Schedule Concurrent Request

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

Schedule Concurrent Request Set

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.

Return Step Value

Synchronize Concurrent Program

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.

Spotted a typo or can’t find help on a certain subject? Reach out to the Documentation team at docsupport@redwood.com.