Oracle EBS Process Definitions
The following Redwood Finance Automation process definitions allow you to interact with Oracle EBS systems.
System_OraApps_ConcurrentProgramImport
Purpose
You use this job definition to import Oracle Applications or Oracle EBS jobs into Redwood Finance Automation. Requires the ProcessServerService.OraApps.limit license key.
Parameters
| Parameter | Description | Documentation | Direction | Data Type | Default Value |
|---|---|---|---|---|---|
| OraApps_SystemName | Applications System name | The name of the Oracle Applications system in Redwood Finance Automation | In | String | |
| SRS | Include Non-SRS programs? | This allows you to limit the selection to Standard Request Submission-compliant (SRS) concurrent programs (default) | In | String | |
| ApplicationShortName | Application Short name | The short name of the application that holds the concurrent program. | In | String | |
| ConcurrentProgramName | Concurrent Program name | The concurrent program name, note that although the end-user friendly name will be selected, the technical name is used to identify the program | In | String | |
| OVERWRITE | Overwrite Existing Process Definitions? | By default, existing process definitions are not overwritten; when you wish to re-import a concurrent program, ensure this parameter is set to Y | In | String | N |
| PARTITION | Partition | The partition for the process | In | String | |
| APPLICATION | Application | The Redwood Finance Automation application to use for the process | In | String |
System_OraApps_ConcurrentProgramMultipleImport
Purpose
You use this job definition to import Oracle Applications or Oracle EBS concurrent program into Redwood Finance Automation. Requires the ProcessServerService.OraApps.limit license key.
Parameters
| Parameter | Description | Documentation | Direction | Data Type |
|---|---|---|---|---|
| OraApps_SystemName | Applications System name | The name of the Oracle Applications system in Redwood Finance Automation; this parameter allows you select an Oracle Applications system from a list. | In | String |
| ApplicationShortName | Application Short name | The short name of the application that holds the concurrent program. | In | String |
| ConcurrentProgramName | Concurrent Program name | The concurrent program name; SQL type wildcards (% for any number of characters and _ for one character) are accepted. | In | String |
| OVERWRITE | Overwrite Existing Process Definitions? | In | String | |
| SRS | Include Non-SRS programs? | In | String | |
| PARTITION | Partition | In | String | |
| APPLICATION | Application | In | String |
System_OraApps_InstallInterceptFunctionality
Purpose
Installs the interception capabilities in the designated Oracle Applications server. This process installs the necessary PL/SQL trigger that performs the intercept.
Parameters
| Parameter | Description | Documentation | Data Type |
|---|---|---|---|
| OraApps_SystemName | Applications System name | The name of the Oracle Applications system in Redwood Finance Automation; this parameter allows you select an Oracle Applications system from a list. | String |
System_OraApps_PackageMethodImport
Purpose
Creates a process that allows you to execute a stored procedure or funtion in the Oracle Applications system.
Parameters
| Parameter | Description | Documentation | Data Type |
|---|---|---|---|
| OraApps_SystemName | Applications System name | The name of the Oracle Applications system in Redwood Finance Automation; this parameter allows you select an Oracle Applications system from a list. | String |
| ApplicationShortName | Application Short name | The short name of the application from which you would like to use a procedure or function. You select the application short name from a list. | String |
| PackageName | Package API name | The package name containing the procedure or function | String |
| PackageMethodName | Package Method name | The name of the procedure or function you want to call; you can select it out of a list. | String |
System_OraApps_RequestSetImport
Purpose
You use this job definition to import Oracle Applications or Oracle EBS request set into Redwood Finance Automation. Requires the ProcessServerService.OraApps.limit license key.
Parameters
| Parameter | Description | Direction | Data Type | Default Value |
|---|---|---|---|---|
| OraApps_SystemName | Applications System name | In | String | |
| ApplicationShortName | Application Short name | In | String | |
| RequestSetName | Request set name | In | String | |
| OVERWRITE | Overwrite Existing Process Definitions? | In | String | N |
| PARTITION | Partition | In | String | |
| APPLICATION | Application | In | String |
System_OraApps_RequestSetMultipleImport
Purpose
Import Multiple Request Set definitions for creating Oracle Applications process definitions. This process can be used to create multiple process definitions reading request set definitions out of the Oracle Applications system.
Parameters
| Parameter | Description | Direction | Data Type |
|---|---|---|---|
| OraApps_SystemName | Applications System name | In | String |
| ApplicationShortName | Application Short name | In | String |
| RequestSetName | Request set name | In | String |
| OVERWRITE | Overwrite Existing Process Definitions? | In | String |
| PARTITION | Partition | In | String |
| APPLICATION | Application | In | String |
System_OraApps_UnInstallInterceptFunctionality
Purpose
Removes the interception capabilities from the designated Oracle Applications server. This process removes the PL/SQL trigger that performs the intercept.
Parameters
| Parameter | Description | Documentation | Data Type |
|---|---|---|---|
| OraApps_SystemName | Applications System name | The name of the Oracle Applications system in Redwood Finance Automation; this parameter allows you select an Oracle Applications system from a list. | String |