Notice: will be retired soon. Please visit our new site at
White Paper
Cost Benefits of Complete Change Lifecycle Management for the Oracle E-Business Suite.
Read now »

Stat for Oracle E-Business Suite

Simplify Your R12 Upgrade to Get Improved Change Management

Stat for Oracle E-Business Suite is a change management solution that provides you with increased visibility into – and control over – application changes, allowing your organization to be more responsive to the change process. If you’re planning on migrating to Oracle R12 in the near future, it’s no secret that the upgrade is resource intensive and time consuming to say the least. Stat ensures your Oracle R12 upgrade is seamless and undisruptive to routine business through version control, impact analysis, object/file locking, automated workflow, migrations management and powerful reporting and auditing capabilities. Ensure your organization is fully equipped for the upgrade by implementing the Stat for Oracle E-Business Suite today!

  • Simplify R12 upgrades
  • Replace Kintana to reduce OpEx and future-proof Oracle EBS support
  • Enforce separation of duties for improved compliance
  • Simplify migration with pre- and post-migration analytics
  • Automate rollback through native object support
  • Support for functional setups
  • Evaluate impact and scheduling of patches
  • Manage all apps from one repository for easier auditing


  • Third-Party Version Control Support – Archive and migrate objects from SVN, CVS and PVCS.
  • Custom Reports – Create reports according to unique requirements, including global parameters definitions, additional fields from the SQL query, layout and style preferences, and more.
  • Pre- and Post-Migration Steps on Distributed Environments – View and execute both post- and pre-migration steps on distributed databases from the window that comes up after a migration.
  • Pre- and Post-Migration Steps on Mass Migrations – Run the steps directly from the Mass Migration wizard as opposed to having to open each individual CSR.
  • Customized Migration Order – Specify the migration order in the Mass Migration Wizard for automatic CSR moves.
  • Automated Patching – Automate and enforce pre-determined, best-practice, and optimized change management processes, minimizing risk of manual error and allowing developers and DBAs to focus on higher-value activities.
  • Impact Analysis – Identify the impact that object modifications and patches have on other objects as the changes cascade through the system. This comprehensive analysis provides you with a complete report of all changes impacting a given instance, allowing for a more streamlined testing process. In addition, to determine the line-by-line impact of a past or future change, Stat provides support for comparing Oracle Form (FMB), Oracle Form Library (PLL), and Oracle Report (RDF) files.
  • Object Compare for Object Management – Compare Oracle E-Business Suite setups with most AOL setup types. You can compare Oracle E-Business Suite setups to more than 100 additional setup types for several application modules including Order Management General Ledger and others. This capability improves visibility into what has changed and allows you to compare the differences between changes — simplifying the planning for development and testing stages of the application.
  • Workflow for Project and Process Management – Track all issues, automate team processes, group tasks by project, assign status requirements and provide approval authorization. You can manage this from one central location, through either the Stat client for the Web or for Windows.
  • Regulatory Compliance Management – Ensure compliance by locking out and auditing unauthorized changes to an application. Stat enforces change policies via workflow, role-based security rights and audits of any and all changes to the underlying business logic. Stat also provides compliance-related reports for easily achieving compliance objectives.

Core Concepts

  • Support objects natively
  • Enforce separation of duties
  • Reduce or eliminate manual tasks by streamlining and automating change management processes
  • Enhance the structure of change processes
  • Evaluate the impact of patches before applying them to any environment
  • Manage change-related data centrally to provide quick access
  • Improve change processes by providing a more stable and secure environment

Change Request Management

  • Issue tracking for the help desk
  • Project management
  • Automatic escalation of assigned or past due tasks
  • Custom description templates
  • Integration with 3rd party service desks
  • Notifications as requests are worked
  • Ability to handle attachments


  • Ease of configuration
  • Integrated approvals
  • User defined tasks/workflow
  • Minimal consulting services required
  • Enforcement of required approvals
  • Email-based approvals
  • Different behavior based on change type

Version Control and Object Management

  • Compare objects between environments: Oracle Objects
  • Maintain multiple versions of objects
  • Create and edit objects
  • Data Objects (e.g. Transactional Data) archive & migration
  • Schema Objects (e.g., tables, views, index, etc.) archive & migration
  • Provide wizards to facilitate object management
  • Establish baselines
  • Lock down objects
  • Track and display object history
  • Co-exist with existing version control system
  • Compare objects between environments:
    • Oracle objects
      • Application setups
      • AOL objects
    • Developer objects
      • Forms (FMBs)
      • Form libraries (PLLs)
      • Reports (RDFs)

Migration Management

  • Migrate any or all objects
  • Define the migration path
  • Synchronize environments
  • Complete the migration
  • Post migration steps
  • Support for SSH protocol in script execution
  • Direct/Point-to-Point Migrations
  • Enforce required approvals
  • Migrate multiple projects simultaneously (mass migration)
  • Pre migration steps
  • Database refreshes
  • Roll back changes, if required (individual objects, projects, packages)

Patch Management

  • Compare patch levels between environments
  • Selection of multiple patches in a single step
  • Evaluate whether pre-requisites have been met
  • Analyze the impact of new patches on objects
  • Import patch projects
  • Schedule deployment of patches

Auditing and Reporting

  • Role-based access controls
  • Centralized repository of change data
  • Custom reports
  • Scheduled report generation
  • Audit trail of all application-level change activity
  • Pre-defined change history reports
  • Web-based interface for ad-hoc reporting
  • Distribution of reports via email, PDFs, etc.

Product Architecture

  • Centralized server for minimal overhead
  • Support for multiple database connections
  • Complete, self-contained, fully integrated solution
  • Choice of platforms (Windows, Unix, Linux)
  • Web client interface for functional users and administrators

Sys Reqs

Supported Databases


9i version 9.0.1 and higher (see note), 10g version and higher, 11g (Unicode and non-Unicode support for all Oracle DBMS)
Note: Oracle E-Business is only supported on an Oracle Stat database. Also, 9i databases are no longer supported by Oracle.  Some features may not function as expected.

Minimum Requirements

Development database: 4 GB available disk
Production database: 20 GB available disk (size can grow dramatically)

Stat Client

Operating System

Windows XP Professional (current SP recommended), Windows Vista, and Windows 7 - 32bit or 64 bit
Note: The Stat client is a 32 bit application. It can run on a 64bit workstation or Windows server. In some cases the compatibility mode may need to be set to XP

Database Connectivity

Oracle: 9, 10 and 11 (client must be compatible with RDBMS version)

Web Browser

Microsoft Internet Explorer (Windows) Versions  7.0, 8.0, and 9.0
Mozilla Firefox 3.5 and higher
Apple Safari 4 and higher
Opera 9.6 and higher
Chrome 8 and higher (see known issue CR0236176)

Minimum Requirements

CPU: 1.6 GHz or greater
Disk: 500 Mb for local install (recommended) or <1 Mb w/network install with 500 Mb on the network

Stat Central Agent

Operating System and JDK/SDK

Standalone configuration (recommended):
Windows XP Professional, 2003 Server, Windows Server 2008, Red Hat Enterprise Linux release 4 and 5, Solaris 8, Solaris 9, Solaris 10, HPUX 11.11 and 11.23 or 64bit AIX v5.2, 5.3, or 6.1 (all English-based)
Note: the Stat Central Agent can run on Windows 64bit machines
JDK/SDK Versions: 1.5.x ; 1.6.0_x (1.6.0_5 minimum)
Windows, Solaris, and RedHat Linux require Sun's JDK/SDK
HPUX 11.11, 11.23 requires HP's JDK/SDK
64bit AIX v5.2, 5.3 and 6.1 requires IBM's JDK/SDK
Standalone configuration not recommended on same machine as SQL Server Stat Database

Oracle Fusion Middleware 11i configuration (optional):
WebLogic Application Server 10.3.3 and higher

Minimum Requirements

CPU: 1 GHz (Dual Core processor recommended for 20+ users) Pentium 4 (or equivalent)
RAM: 512 MB (2 GB recommended for 20+ users)
Disk: 1 GB


Supported protocols: Outbound e-mail-SMTP, Secure SMTP; Inbound e-mail- IMAP4, Secure IMAP4, POP3 and Secure POP3

Oracle E-Business Suite


Stat supports all products, including custom products, in the Oracle's E-Business Suite Release 11i (11.5.10 and higher), 12, 12.1.1, 12.1.2 and 12.1.3 (current release is 12.1.3). 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 Oracle Agent - Hardware Platforms

All versions of Sun SOLARIS, HP-UX, AIX, Linux and Windows certified with Oracle E-Business Suite. Stat will be certified with most UNIX and Intel based platforms supported by Oracle. Contact Quest Software for updated platform certification.
JDK/SDK Versions: 1.5.x ; 1.6.x (minimum 1.6.0_5)
Windows, Solaris, and RedHat Linux require Sun's JDK/SDK
HPUX 11.11, 11.23, 11.31 requires HP's JDK/SDK
64bit AIX v5.2, 5.3 and 6.1 requires IBM's JDK/SDK

Developer Object Compare

Oracle developer object comparison is an optional feature with its own requirements. To enable object compare support for Oracle developer objects, a compatible version of Oracle Developer and the Forms Applet Jar Files component of the Oracle Forms product 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.
  • 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).

FTP, SSH Servers


Must be NT, Unix, MVS or Netware compatible; SSH2 must use standard format listing; OpenSSH (UNIX and Windows), SSH Communications Corp. (UNIX and Windows), bitwise WinSSHD, and wodSSHServer are supported. VanDyke VShell 2.1 is NOT supported.
The configuration of your SSH server determines which ciphers are used when connecting to the Stat Server. The Stat Server currently supports the following cipher and MAC configurations:

  • Blowfish
  • Triple DES
  • AES128Ctr
  • AES192Ctr
  • AES256Ctr

Message Authentication Code (MAC):

  • HMAC-MD5
  • HMAC-MD5-96
  • HMAC-SHA1-96



Stat for Oracle E-Business

Stat for Oracle E-Business
  • Apply schedule patches
  • Call pre and post patch script
  • Pass relevant parameters
  • Order sequences and dependencies

Stat for Oracle E-Business

Stat for Oracle E-Business

Version flat file, developer, schema, AOL as well as functional setups.

Stat for Oracle E-Business

Stat for Oracle E-Business

Analyze impact of patches and their relationships to objects that will be overwritten, directly and indirectly.

Stat for Oracle E-Business

Stat for Oracle E-Business

Do side-by-side comparisons of objects in an environment, that were versioned, or that are coming in a patch.

Stat for Oracle E-Business

Stat for Oracle E-Business
  • Over 200 out of the box reports for auditing and reporting
  • Many reports are centered around compliancy and change management