For the best web experience, please use IE11+, Chrome, Firefox, or Safari

Stat for Oracle E-Business Suite

Manage and automate Oracle E-Business Suite changes

Request Pricing

Oracle E-Business Suite is critical to your business. Which is why you need a reliable change management system. Yet most organizations manage Oracle application changes manually, which can lead to tedious rework and audit issues. But what if you could automate the process of managing Oracle application changes and patches? This would save time, reduce risk and support DevOps.

With Stat® for Oracle E-Business Suite, you get complete application change management for your EBS environment in a single tool. Stat makes it easy to schedule Oracle application change deployments by release or target environment, automate pre- and post-migration steps and integrate with existing tools via REST API and business rules. Implement DevOps in your ERP environment, without compromising compliance, with Stat.

Key Benefits

Time-saving automation
Reduce risk and save time by using automation to version, manage and migrate Oracle application setups.
Preventative controls
Define and enforce controls for testing, approvals and compliance to prevent audit issues and rework.
DevOps support for ERP teams
Build and release application changes faster through increased visibility and automation.
REDUCTION
in audit time
REDUCTION
in migration time
IMPROVEMENT
in SLA attainment

Features

Off-hours code migrations

Avoid business interruption by scheduling code migrations after hours, without manual intervention.

Support for third-party version control software

Archive and migrate objects from SVN, CVS and PVCS. Take advantage of Jira integration and ServiceNow integration.

Custom reports

Customize reports with unique requirements, such as global parameter definitions, additional fields from SQL queries and style preferences.

Pre- and post-migration steps on distributed environments

Determine and complete both pre- and post-migration steps on distributed databases from the window that comes up after a migration.

Pre- and post-migration steps on mass migrations

Quickly complete the steps directly from the mass migration wizard, instead of opening each CSR.

Pre- and post-migration steps for custom commands

Use automation to quickly complete steps and run custom commands with business rules.

Dev tools integration

Take advantage of REST Web Services API for third-party applications.

Customized migration order

Determine the migration order in the mass migration wizard for automatic CSR moves.

Automated patching

Avoid manual errors and concentrate on more critical activities by automating and enforcing predetermined and optimized change processes.

Impact analysis

Streamline the testing process by identifying the impact that object modifications and patches have on other objects as the changes flow through the system, then get a complete report of all changes impacting a given instance. Stat also allows you to compare Oracle Form (FMB), Oracle Form Library (PLL), and Oracle Report (RDF) files, to determine the line-by-line impact of a past or future change

Object compare for object management

Compare Oracle E-Business Suite setups with nearly all AOL setup types and to more than 100 additional setup types for several application modules, including Order Management General Ledger and others. This simplifies the planning for development and testing stages of the application by improving visibility into what has changed and allowing you to compare the differences between changes.

Software version control and rollback

Archive any combination of objects/files in each version as you capture an unlimited amount of interim application versions or “snapshots.” Use selective retrieval and rollback by object/file.

Workflow for project and process management

Centrally manage and maintain control over a variety of activities (through the Stat client for the web or for Windows). Monitor all issues, automate change processes, organize tasks by project, assign status requirements and deliver automated approval authorization.

Regulatory compliance management

Lock out and audit unauthorized application changes to ensure compliance. Enforce change policies by workflow, role-based security rights and audits of any changes to the underlying business logic. Get compliance-related reports that help you achieve compliance objectives and meet the requirements of a SOX compliance audit.

Tour

Tour

    Intuitive console

  • Easily manage change requests, tasks, schedules and notifications.

    • Workflow

  • Configure Stat workflows to enforce your change management process.

    • Object control

  • Add, lock and version objects in the change request.

    • Object management

  • Manage objects in archive sets for versioning, migrating and restoring.

    • Change migration

  • Schedule or migrate (deploy) changes in real time to a target environment.

    • Migration details

  • Captures and logs object migration (deployment) associated with the change.

    • Event logs

  • Stat provides detailed agent and event logs for all object migrations.

    • Reporting

  • Offers more than 200 reports, including migration (deployment) details.

Specifications

Stat Environment

Stat Repository DBMS
  • Oracle 11g R2,12c R1, 12c R2 and 18c (Unicode and non-Unicode support for all Oracle DBMS).

    • Note: Oracle E-Business is only supported on an Oracle Stat database.

  • Character Set with Unicode collation. Database defined with BINARY collation).
Minimum disk space
  • Development database: 4 GB available disk
  • Production database: 20 GB available disk (size can grow dramatically)

Operating system
  • Windows 7 (32-bit or 64-bit), Windows 8 (32-bit or 64-bit), and Windows 10 (32- bit or 64-bit) Windows Server
  • Windows Server® 2008, 2008 R2, 2012, 2012 R2, and 2016

Note: Be aware of the following:

  • The Stat Client can run on a workstation or Windows server. In some cases the compatibility mode may need to be set to Windows XP.
  • When Stat is running on a Microsoft Server operating system, opening a CSR may cause an Internet Explorer security prompt to appear. To prevent this, add about:security_stat.exe to the Trusted sites zone.
  • Beginning with the Stat release after Stat 6.2, the 32-bit Stat Windows Client will no longer be included
Database connectivity
  • To create a successful connection, the architecture (bitness) or the database client/driver must match the architecture (bitness) of the Stat Client. For example, the 64-bit Stat Client requires an applicable 64-bit database client/driver, and the 32-bit Stat Client requires an applicable 32-bit database client/driver.
Oracle Instant Client
  • The client version must be compatible with the RDBMS version. Microsoft SQL Server Native Client 11.x
Web browser
  • Microsoft Internet Explorer 11 or later
Oracle E-Business Object Compare

Oracle E-Business object comparison is an optional feature with its own requirements. To enable object compare support for Oracle E-Business objects, a compatible version of Oracle Developer Suite and the Forms Applet Jar Files component must be installed. Additional requirements are needed for the following:

  • To enable object compare support for Oracle developer objects in patches, the Oracle JVM and the file stat_db.jar must be installed in the Stat repository.
  • To enable object compare support for form library files that have attached libraries, the FORMS60_PATH environment variable must be set to reference a staging directory (FORMS_PATH for FORMS 10).
Minimum requirements
  • CPU: 1.6 GHz or greater
  • RAM: 1 Gb RAM
  • Disk: 500 Mb for local install (recommended) or <1 Mb w/network install
  • with 500 Mb on the network

Operating System
  • Windows® 7 (32-bit or 64-bit), Windows 8 (32-bit or 64-bit), and Windows 10 (32-bit or 64-bit)
  • Windows Server® 2008, 2008 R2, 2012, 2012 R2, and 2016 Red Hat® Enterprise Linux® releases 6 and 7 Oracle® Solaris Intel 10 and 11 IBM® AIX® 7.1, 7.2 (English-based)

NOTE: Running the Stat Central Agent on the same computer as the SQL Server® Stat Database is not recommended.

Application Server

The Stat Central Agent uses the Wildfly application server. Beginning with Stat 6.2, Weblogic is no longer supported.

  • Java SE Development Kit
  • Java 8

Releases

Stat® supports all products, including custom products, in the Oracle® E-Business Suite Release 12.1.x and 12.2.x. Some Stat features will depend on the AD product release

Technology stack
  • All components of the technology stack for the Oracle E-Business Suite should be in compliance with Oracle's certification requirements
  • Stat will be certified with most UNIX® and Intel® based platforms supported by Oracle. Contact Quest® Support for updated platform certification.
  • JDK/SDK version 8

Resources

Stat® for Oracle E-Business Suite
Datasheet
Stat® for Oracle E-Business Suite
Stat® for Oracle E-Business Suite
Read Datasheet
Avoid the Common Pitfalls of ERP Change Management: Part One
E-book
Avoid the Common Pitfalls of ERP Change Management: Part One
Avoid the Common Pitfalls of ERP Change Management: Part One
In this first chapter, you’ll learn how to define an effective change management process that reduces the potential risks associated with your enterprise resource planning (ERP) application changes.
Read E-book
Mastering the Art of Version Control and Migration Management with Stat
Technical Brief
Mastering the Art of Version Control and Migration Management with Stat
Mastering the Art of Version Control and Migration Management with Stat
Modern corporate IT infrastructures are constantly changing. Maintenance, such as user provisioning and regular updates to operating systems, server software and applications, is just a small part of the picture. IT departments must also frequently change
Read Technical Brief
Curtiss-Wright Electro-Mechanical Corporation: Optimizing change management
Case Study
Curtiss-Wright Electro-Mechanical Corporation: Optimizing change management
Curtiss-Wright Electro-Mechanical Corporation: Optimizing change management
Curtiss-Wright Electro-Mechanical Corporation has unified and automated change management processes to increase efficiency, lower costs and streamline compliance.
Read Case Study
Three Change Control Challenges You Can Solve with Stat®
White Paper
Three Change Control Challenges You Can Solve with Stat®
Three Change Control Challenges You Can Solve with Stat®
Unauthorized changes, manual deployments and governance are all challenges that can be addressed with change control tools and processes. This is because nearly everything that goes wrong with a database is due to human intervention, and can be mitigated or avoided altogether when people are prevent
Read White Paper
DevOps Cookbook for ERP Teams
E-book
DevOps Cookbook for ERP Teams
DevOps Cookbook for ERP Teams
How ERP developers can enjoy the advantages of DevOps without incurring the risk of noncomplianceIf all the cool kids have DevOps, then what’s keeping the ERP teams from getting it? The problem is that progress toward DevOps can introduce the risk of noncompliance to the organization’s f
Read E-book
Migrating Oracle Application Setups | The Stat® Way
Technical Brief
Migrating Oracle Application Setups | The Stat® Way
Migrating Oracle Application Setups | The Stat® Way
Oracle E-Business Suite is the backbone of your organization, which is why it’s critical to manage changes properly. Using manual methods is a common approach, but it’s often an expensive, time-consuming and error-prone process. What if you could use automation to version, manage and mig
Read Technical Brief
Quest Partner Webcast FY21 Q2 EMEA
On Demand Webcast
Quest Partner Webcast FY21 Q2 EMEA
Quest Partner Webcast FY21 Q2 EMEA
Quest has the technology solutions your customers need to connect, manage and secure a remote workforce.
Watch Webcast

Get Started Now

Prevent rework, avoid audit issues and improve DevOps with Stat automation.
Request Pricing

Related Products

Stat Product Line
Stat Product Line

Automate application change management for PeopleSoft and Oracle E-Business...
Stat for PeopleSoft
Stat for PeopleSoft

Simplify change management requirements for PeopleSoft applications.

Support and Services

Product Support

Self-service tools will help you to install, configure and troubleshoot your product.

Support Offerings

Find the right level of support to accommodate the unique needs of your organization.

Professional Services

Search from a wide range of available service offerings delivered onsite or remote to best suit your needs.

Education Services

Training courses delivered through online web-based, on-site or virtual instructor-led.