Adapter for Oracle E-Business

Enterprise-wide solution with more advanced scheduling functionality than the native Oracle scheduler.
Announcement icon

Gartner® Market Guide: Service Orchestration & Automation Platforms

Read Report

Automate Oracle E-Business, New and Legacy Applications in One Enterprise Solution

Adapter Overview

Integrate Oracle Applications Into Enterprise Workflows

Oracle E-Business Suite allows organizations to deliver many key processes critical to running a successful business. Even so, many organizations make the strategic decision to retain legacy applications and non-Oracle applications solutions, even in the most widely deployed Oracle E-Business environment. By implementing Tidal Workload Automation Adapter for Oracle E-Business Suite, organizations can now consolidate and combine the processing of legacy applications with all Oracle E-Business applications to deliver one business process automation solution, using one common interface, throughout the enterprise.

More About This Adapter

Advanced Scheduling Automation for the Enterprise

Tidal Workload Automation Adapter for Oracle E-Business Suite expands and extends Oracle E-Business workflows to other platforms, applications, and even other instances of Oracle E-Business Suite. The Tidal scheduling solution for Oracle e-Business Suite dramatically simplifies job scheduling, reduces errors, and pinpoints potential issues, all of which combine to deliver faster ROI for Oracle applications. The adapter easily incorporates and manages ad hoc jobs submitted from multiple Oracle-defined jobs, offering granular control by site, application, responsibility, and user. By seamlessly integrating Oracle Concurrent Manager functions with Workload Automation queue management, the adapter gives IT operations staff the ability to balance production and user-submitted jobs. With Tidal Workload Automation Adapter for Oracle E-Business Suite, Workload Automation platform provides users with an enterprise-wide solution and more advanced scheduling functionality than the native Oracle scheduler.

Figure 7. Tidal Workload Automation Adapter for Oracle E-Business Suite provides industry-leading integration; including drop-down lists of existing Oracle E-Business Suite request data.

Oracle ERP

Figure 8. Configuring a job for Oracle apps.

Oracle ERP

How Tidal Workload Automation Adapter for Oracle E-Business Suite Works

Installed on the Oracle E-Business forms server, the adapter is used to create request sets of E-Business Suite jobs. To help prevent errors, the adapter comes pre-configured with lists of requests and report sets. The adapter automatically brings up Oracle forms used to request jobs and define parameters. Workload Automation variables can be added so that once created, report forms do not need to be accessed repeatedly to enter new parameters. If, for instance, a report must run weekly or monthly, the form retains these parameters.

Dependencies can also be set and managed, and priorities and queues can be allocated. Abnormal behavior is reported in the scheduler console to enable user intervention.

By leveraging the Oracle native scheduler, Workload Automation can support all Oracle process types, including Oracle reports, procedural language/structured query language (PL/SQL) stored procedures, Java stored procedures, Java concurrent programs, and SQL*Plus. Because the familiar Oracle request form is used and reports have the same names and syntax as they do in Oracle E-Business Suite, users can be scheduling Oracle jobs in minutes. Workload Automation and Oracle work as one integrated solution, even supporting non- Oracle users who can input Oracle processes and run native Oracle jobs using the same Workload Automation interface across multiple systems and applications environments.

This scheduling solution for Oracle E-Business Suite delivers full enterprise scheduling capabilities that enable organizations to manage Oracle E-Business Suite processes in the broader context of heterogeneous IT environments. Oracle users can have greater control over and visibility into the execution of their processes and understand their relationship with other technologies in the data center. Key capabilities include the following:

Universal Workflow Management – Workflow management is an essential part of any enterprise resource planning (ERP) solution, because it allows critical transactions from various databases and applications to occur at the right time, every time. Workload Automation provides immediate problem detection and, in many cases, will automatically launch error resolution steps, enabling Oracle E-Business Suite jobs to be delivered efficiently and accurately. By leveraging Workload Automation workflow automation, organizations have seen rapid ROI from their Oracle applications investments.

Event-Driven Processing – In addition to time- and date-based job scheduling, the adapter can dynamically introduce single jobs and entire workflow processes into a schedule when triggered by business events from a wide range of application adapters and platform-supported agents. Also, using Tidal Workload Automation Adapter for the Oracle E- Business Suite, users can define events that can be used for alerting and invoking an automated response through email and/or inserting additional jobs into the schedule.

Flexible Monitoring and Alerting – Job status and output is automatically logged and can be viewed using the scheduler console. Alerts can be automatically sent to browser-enabled devices for anytime, anywhere status information and can be configured to initiate process recovery steps. Automated actions are extensive and are easily defined.

IT Policy Alignment – Each job can contain several process definitions, allowing granular controls and error recovery procedures that make it possible for IT staff to consistently follow documented best practices.

Information Technology Infrastructure Library (ITIL) processes in the areas of request fulfillment, incident management, and change management can be supported and can include interfaces and integration techniques available for a range of ITIL-oriented operations environments.

Robust Security and Audit Support – Security policy—and changes to it—are tied to enterprise security management tools and processes. The Integrated security management features of Workload Automation can be applied to the implementation of Oracle applications connections, various roles, and jobs to enable secure management and use of required security credentials. Security features include:

  • Validation of username and password against the Oracle E-Business Suite database during job definition and submission
  • Confirmation of user responsibility rights before a run request is submitted    Password encryption when invoking Oracle E-Business Suite forms
  • Add and edit capabilities for an Oracle E-Business Suite job within Workload Automation

Features Summary

  • Seamless application program interface (API Integration)  with Oracle Concurrent Manager
  • Support for Multiple Oracle E-Business Suite instances
  • Connection for Oracle E-Business Suite to others to others platforms and applications with unlimited dependencies for Oracle requests and report sets
  • Synchronized monitoring of all Oracle E-Business Suite report run requests
  • Real-time status reports and real-time interactions with Oracle jobs
  • Support for parameter substitutions for E-Business Suite Processes
  • Queue and priority management for all job instance requests
  • Enhanced re-run functionality to overcome common database lockout errors

Where We Run

The Cloud

Tidal’s enterprise-wide automation platform transcends the inherent limitations associated with standalone point products or native cloud schedulers. We can automate and orchestrate cross-application workloads and enterprise-wide business processes that traverse multiple clouds and hybrid environments – all from a single-pane-of-glass view.


Tidal helps you optimize the value and performance of your legacy infrastructure while opening new opportunities to leverage next-gen applications and workflows. From pure on-prem to hybrid on-prem and cloud engagements – the answer is Tidal.

  • CentOS
  • Linux Kernel 2.6.18 & above
  • Linux PPC
  • Microsoft Windows
  • Microsoft Windows Server
  • Open VMS
  • Oracle Cloud
  • Oracle Enterprise Linux
  • Red Hat Enterprise Server
  • Suse Enterprise
  • Tandem NSK
  • Ubuntu
  • UNIX
  • HPUX (PA-RISC, Itanium)
  • Solaris (Sparc, X86)
  • AIX
  • OS/400 iSeries
  • z/Linux
  • z/OS