Redwood Documentation

Product Documentation

 

You are currently viewing the legacy RunMyJobs documentation site. This site will be taken down later this month.
All current and future RunMyJobs documentation, including versions 2023.3 and later, can be found here.
Please update your bookmarks. Use the version dropdown menu to select the documentation you need.

›Oracle EBS

RunMyJobsERP Systems

Modules

  • ERP Modules

Oracle EBS

  • The Oracle Applications Connector
  • Prepare Oracle Application Instance
  • Connecting to Oracle Applications Instances
  • Intercepting Oracle Applications Jobs
  • Oracle Applications Job Interception Configuration
  • Technical Requirements and Sizing Recommendations
  • Using the Oracle Apps Definition Type
  • Importing Oracle Applications Concurrent Programs
  • Importing Oracle Applications Request Sets
  • Importing Oracle Applications Functions and Procedures
  • Calling Oracle Applications Functions and Procedures

Oracle Health Insurance

  • The Oracle Health Insurance Connector
  • Connecting to Oracle Health Insurance Instances
  • Importing Oracle Health Insurance Workload

PeopleSoft

  • The PeopleSoft Connector
  • Connecting to PeopleSoft Instances
  • Importing PeopleSoft Workload
  • Intercepting PeopleSoft Jobs
  • PeopleSoft Job Interception and Monitoring Configuration
  • Peoplesoft Plug-In
← Importing Oracle Applications Functions and ProceduresThe Oracle Health Insurance Connector →

Calling Oracle Applications Functions and Procedures

You execute PL/SQL documents against Oracle Applications systems using the following syntax:

PLSQL
APPL_SHORT_NAME=<application_short_name>
APPL_PACKAGE_NAME=<package_name>
APPL_METHOD_NAME=<doc_full_path>

The APPL_SHORT_NAME and APPL_PACKAGE_NAME are used to validate security, only users that can access the package from the application are allowed to execute the PL/SQL as defined in the document. The APPL_METHOD_NAME points to a document.

The PL/SQL stored in the DocumentMyDoc.pls, for example, should only be executed by users who can run methods of the ALR_PROFILE in the Alert (ALR) application; the process definition would have the following Source:

PLSQL
APPL_SHORT_NAME=ALR
APPL_PACKAGE_NAME=ALR_PROFILE
APPL_METHOD_NAME=doc:Partition1:/Partition2.MyApplication/MyDoc.pls

You add parameters to the process definition as required in your PL/SQL source.

Parameter names starting with _ are not passed on to Oracle Applications and can be used for Redwood Server-specific functionality.

See Also

The Oracle Applications Connector

← Importing Oracle Applications Functions and ProceduresThe Oracle Health Insurance Connector →
  • See Also
Docs
Getting StartedInstallationFinance InstallationConcepts
TroubleshootingArchiving
Learn and Connect
Support Portal
BlogEventsResources
ISO/ IEC 27001 Information Security Management
Automate to be human

2023 All Rights Reserved |

Terms of Service | Policies | Cookies | Glossary | Third-party Software | Contact | Copyright | Impressum |