Stat for Oracle E-Business Suite

The next industrial revolution is here. Technology won’t rule the world but it will power it. See How ›

Ensure complete Oracle change management.

Get a powerful tool that ensures complete change management for your Oracle environment — no matter what version.



With Stat for Oracle E-Business Suite, you get a powerful tool that ensures complete change management for your Oracle environment — no matter what version. And when it comes time to upgrade to R12, Stat has you covered. With increased visibility and control over your R12 upgrade, Stat enables you to be more responsive to the change process. Stat ensures that your Oracle R12 upgrade goes smoothly while avoiding any disruption to routine business. Stat’s version control, impact analysis, object/file locking, automated workflow, migration management, as well as powerful reporting and auditing capabilities ensure your organization is optimized to manage continual change.
  • Enforce separation of duties for improved compliance
  • Automate rollback through native object support
  • Support for functional setups
  • Evaluate impact and scheduling of patches
  • Manage all apps from one repository to simplify auditing
Third-party version control support
Migrate and archive objects from PVCS, CVS and SVN.

Custom reports
Create reports according to unique requirements, including global parameters definitions, style and layout preferences, additional fields from the SQL query, and more

Pre- and post-migration steps on distributed environments
From the window that comes up after a migration, you can view and execute both pre- and post-migration steps on distributed databases.

Pre- and post-migration steps on mass migrations
Execute the steps directly from the mass migration wizard instead of opening each individual CSR.

Customized migration order
Use the Mass Migration Wizard to specify the migration order for automatic CSR moves.

Automated patching
Minimize risk of manual error and allow developers and DBAs to focus on higher-value activities by automating and enforcing pre-determined, best-practice, and optimized change management 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.

Workflow for project and process management
From one central location (through either the Stat client for the Web or for Windows), you can track all issues, automate team processes, group tasks by project, assign status requirements and provide approval authorization.

Regulatory compliance management
Lock out and audit unauthorized changes to an application to ensure compliance. The software also enables you to achieve compliance objectives by providing compliance-related reports. It enforces your change policies via workflow, role-based security rights and audits all changes to the underlying business logic.
  • Stat Environment

    Oracle: 9i version 9.0.1 and higher (see note), 10g version and higher, 11g, and 12c (Unicode and non-Unicode support for all Oracle DBMS). Oracle client must be 32-bit.
    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.
    MS SQL Server: 2005, 2008, 2012, 2014 (Unicode and non-Unicode: ISO Character Set with
    Unicode collation. Database defined with BINARY collation).
    Note: If you are running Stat on Microsoft SQL Server and your PeopleTools environment is 8.48 or higher, Stat must be on at least MSS 2005, regardless of the PeopleTools platform. Also, If PeopleSoft is configured for Unicode operation, the Stat database must be as well.

    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/8 – 32-bit or 64-bit
    Note: The Stat client is a 32-bit application. It can run on a 64-bit workstation or Windows server. In some cases the compatibility mode may need to be set to XP

    Database connectivity
    Database connectivity must be 32-bit, even on a 64-bit device.
    Oracle: 9, 10, 11, and 12 (client must be compatible with RDBMS version and must be 32-bit)
    MS SQL Server: SQL Server 2000 client, 2005 client, 2008 client, 2012 client

    Web browser
    Microsoft Internet Explorer (Windows) Versions 9, 10 and 11
    Mozilla Firefox 18 and higher
    Apple Safari 6.0 and higher
    Opera 11.5 and higher
    Chrome 23 and higher (see known issue 0236176)

    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

    Stat Central agent

    Operating system and JDK/SDK
    Standalone configuration (recommended):
    Windows Server 2008, Windows Server 2012, Red Hat Enterprise Linux release 5 and 6, Solaris 8, Solaris 9, Solaris 10, HPUX 11.11 and 11.23 or
    64bit AIX v5.2, 5.3, 6.1, or 7.1 (all English-based)
    NOTE: The Stat Central Agent can run on Windows 64bit machines JDK/SDK Versions (32-bit): 1.6.0_x (1.6.0_5 minimum); 1.7.0_x
    Windows, Solaris, and RedHat Linux require Oracle(Sun) JDK/SDK (32-bit)
    HPUX 11.11, 11.23 requires HP JDK/SDK (32-bit)
    64bit AIX v5.2, 5.3, 6.1 and 7.1 requires IBM JDK/SDK (32-bit)
    Standalone configuration not recommended on same machine as SQL
    Server Stat Database
    Oracle Fusion Middleware 11g configuration (optional):
    WebLogic Application Server 10.3.3-10.3.6

    Minimum requirements
    CPU: 2.5 GHz (Dual Core processor ) Core i3 (or equivalent)
    RAM: 2 GB
    Disk: 500 GB

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

    PeopleSoft Environment

    PeopleTools Applications
    Supports all applications that are certified by PeopleSoft to run on the following PeopleTools versions: v7.0 (all versions), v7.5 (all versions), v8.0-v8.22, and v8.4-v8.54.

    PeopleSoft Applications
    Supports all PeopleSoft Applications built on PeopleTools.

    PeopleSoft Databases
    Supports the following database platforms in conjunction with PeopleTools
    Supported Platforms:

    Oracle (8i, 9i, 10g, 11g, and 12c)
    MS SQL Server (2000, 2005, 2008, 2012, and 2014)
    DB2 UDB (7.1, 8.1, 9.1, 9.5, 9.7 on Aix, OS/390, z/OS; 10 on z/OS)

    Oracle E-Business Suite

    Stat supports all products, including custom products, in the Oracle's EBusiness Suite Release 11i (11.5.10 and higher), 12, 12.1.x, 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 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 Dell Software for updated platform certification.
    JDK/SDK Versions: 1.6.x (minimum 1.6.0_5); 1.7.0_x
    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, 6.1, and 7.1 requires IBM JDK/SDK (32-bit)

    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:

    Triple DES
    AES128Ctr, AES128CBC
    AES192Ctr, AES192CBC
    AES256Ctr, AES256CBC

    Message Authentication Code (MAC):


Documents Documents
Download printable materials to gain insight on how this product can help you simplify IT challenges.
Events Events
Peruse webcasts and in-person activities near you to explore the technology behind this product.
Community Community
Get the most from this product as you join your peers and Dell experts to access tools and learn best practices.

Go ahead. Ask us anything.

You've got questions, we've got experts that can help. Find out now.
Chat Online
2016 Global Excellence Silver Award Winner: Endpoint Security

KACE K1000 Systems Management Appliance

2016 Global Excellence Silver Award Winner: Endpoint Security
Learn More
Dell Financial Services

Improve the speed of doing business.

0% Finance Lease rate available on Dell SonicWALL systems.** Based on a 36-month Finance Lease.

Learn More
Dell Software | Contact Us

Contact a Dell Expert

Get help with all your business needs.

Learn More
Dell Software | Support

Software Product Support

Single location for all your product needs.

Learn More
 You can only compare up to 7 products. To compare this item, deselect one of the other 7 products.