Oracle Fusion Connector 1.0.0.0
The Oracle Fusion Connector lets you submit Oracle Fusion Enterprise Scheduler Service (ESS) jobs and job sets.
Prerequisites
- RunMyJobs 9.2.9 or later.
- Connection Management Extension 1.0.0.4 or later. This will be installed or updated automatically if necessary when you install the Oracle Fusion Connector.
- An Oracle Fusion Connection.
- Privileges Required to Use the Oracle Fusion Connector
Contents
| Object Type | Name |
|---|---|
| Application | GLOBAL.Redwood.REDWOOD.Oracle |
| Application | GLOBAL.Redwood.REDWOOD.Oracle.REDWOOD.OracleFusion |
| Constraint Definition | REDWOOD.Redwood_OracleFusionConnectionConstraint |
| Extension Point | REDWOOD.Redwood_OracleFusionConnection |
| Job Definition | REDWOOD.Redwood_OracleFusion_SubmitESSJob |
| Job Definition | REDWOOD.Redwood_OracleFusion_SubmitESSJobSet |
| Job Definition Type | REDWOOD.Redwood_OracleFusion |
| Library | REDWOOD.Redwood_OracleFusion |
Setup
To install the Oracle Fusion Connector:
-
Click its tile in the Catalog, select the version you want, and then click Install <version number>.
-
Create an Oracle Fusion Connection.
-
To customize timeouts, create or edit the associated registry entries.
Customizing Timeouts
To update timeouts for the Oracle Fusion Connector, create or update the following Registry entries.
| Configuration Option | Description | Minimum | Maximum | Default |
|---|---|---|---|---|
| /configuration/jcs/apps/OracleFusion/ConnectTimeout | Duration to wait for a connection to be established. | 1 second | 600 seconds | 20 seconds |
| /configuration/jcs/apps/OracleFusion/SocketTimeout | Duration to wait for reads to be completed. | 1 second | 600 seconds | 30 seconds |
Job Definitions
Redwood_OracleFusion_SubmitESSJob
Lets you submit an Oracle Fusion ESS job and monitor it to completion.
Parameters
| Tab | Name | Description | Documentation | Data Type | Direction | Default Expression | Values |
|---|---|---|---|---|---|---|---|
| Parameters | connection
|
Connection | The Connection for Oracle Fusion. | String | In |
|
|
| Parameters | jobdefinitionID
|
Job Definition Path | The path of the ESS job definition to run. Example: /oracle/apps/ess/financials/xyz/JobName |
String | In |
|
|
| Parameters | application
|
Application Name | The application name of the ESS job to run. | String | In |
|
CrmEss, FscmEss, EarHcmEss |
| Parameters | description
|
Description | A description of the ESS job, for use as a search tag. The description you enter here displays in the Oracle Fusion Submission Notes field, and can be used for searching and filtering. | String | In |
|
|
| Parameters | downloadLogs
|
Download Logs | Lets you choose whether ESS job logs should be downloaded. | String | In | No | Yes, No |
Redwood_OracleFusion_SubmitESSJobSet
Lets you submit an Oracle Fusion ESS job set and monitor it to completion.
Parameters
| Tab | Name | Description | Documentation | Data Type | Direction | Default Expression | Values |
|---|---|---|---|---|---|---|---|
| Parameters | connection
|
Connection | The Connection for Oracle Fusion. | String | In |
|
|
| Parameters | jobsetID
|
Job Set Path | The path of the ESS job set definition to run. Example: /oracle/apps/ess/financials/xyz/JobSetName |
String | In |
|
|
| Parameters | application
|
Application Name | The application name of the ESS job. | String | In |
|
CrmEss, FscmEss, EarHcmEss |
| Parameters | description
|
Description | A description of the ESS job set, for use as a search tag. The description you enter here displays in the Oracle Fusion Submission Notes field, and can be used for searching and filtering. | String | In |
|
|
| Parameters | downloadLogs
|
Download Logs | Lets you choose whether ESS job set logs should be downloaded. | String | In | No | Yes, No |
Procedures
Running an Oracle Fusion ESS Job
To run an Oracle Fusion ESS job and monitor it to completion:
-
If you need to supply additional Oracle Fusion ESS parameters, duplicate the Redwood_OracleFusion_SubmitESSJob Job Definition, add a Job Definition Parameter with a Group Name of
ESS Job Parametersfor each Oracle Fusion ESS job parameter you want to supply. The names and values of these Parameters will be passed to Oracle Fusion in the order in which they are defined in the Parameter Group.Note: When you duplicate the Job Definition, you must either clear the Folder field or specify a Folder of your own.
-
Right-click the Redwood_OracleFusion_SubmitESSJob Job Definition or the custom Job Definition you created in the last step and choose Submit.
-
Configure the Parameters as needed.
-
Click Submit.
Running an Oracle Fusion ESS Job Set
To run an Oracle Fusion ESS job set and monitor it to completion:
-
If you need to supply additional Oracle Fusion ESS parameters, duplicate the Redwood_OracleFusion_SubmitESSJobSet Job Definition and add a Job Definition Parameter for each Oracle Fusion ESS job set parameter you want to supply. Use the following guidelines:
-
For a job set top-level parameter, use this format for the Parameter name:
submit.argument<number> -
For other job set parameters, use this format for the Parameter name:
<StepName>_submit.argument<number> -
Parameters may be organized into Parameter Groups by Step Name, but this is not required.
Note: When you duplicate the Job Definition, you must either clear the Folder field or specify a Folder of your own.
-
-
Right-click the Redwood_OracleFusion_SubmitESSJobSet Job Definition or the custom Job Definition you created in the last step and choose Submit.
-
Configure the Parameters as needed.
-
Click Submit.