Stat for Oracle E-Business Suite

• 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

• 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

• 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)

• 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)

• 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

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

• 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

Supported Databases

DBMS

Oracle:
9i version 9.0.1 and higher (see note), 10g version 10.1.0.2 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
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 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

E-mail

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

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

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:
Ciphers:

• Blowfish
• Triple DES
• AES128Ctr
• AES192Ctr
• AES256Ctr

Message Authentication Code (MAC):

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