Oracle E-Business Adapter

Pre-built ERP Oracle E-Business Adapter from Tidal
Announcement icon

Adapter Overview

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

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

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