Stat for Oracle E-Business Suite
Upgrade to Oracle R12 with ease and simplicity in less time
Get complete change management for your Oracle environment with Stat – no matter what version. And when it comes time to upgrade, Stat provides you with increased visibility and control over your R12.2 upgrade, so you can be more responsive to the change process without disruption to routine business.
Stat for Oracle E-Business Suite enables you to:
- Simplify and streamline R12 and R12.2 upgrades
- Easily identify all customizations before upgrading
- Apply patches without impacting business users
- Add custom file objects and configure post-deployment functions
- Compare and manage more than 100 functional object setups
Features
Off-hours code migrations
Schedule migrations of code during off hours, without manual or user intervention.
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 automated 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.
Tour
Intuitive console
Workflow
Object control
Object management
Change migration
Migration history
Event logs
Reporting
Specifications
- DBMS
- Oracle® 10g version 10.1.0.2 and higher, 11g, and 12c (Unicode and non-Unicode support for all Oracle DBMS). Oracle client must be 32-bit.
- Microsoft® SQL Server® 2005, 2008, 2012, 2014 (Unicode and non-Unicode: ISO.
Note: PeopleSoft® 8.54 and higher requires Oracle 64 bit client.
Note: Oracle E-Business is only supported on an Oracle Stat database.
- 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 disk space
- Development database: 4 GB available disk
- Production database: 20 GB available disk (size can grow dramatically)
- Operating system
Windows Vista®, Windows® 7, Windows 8 (32-bit or 64-bit), and Windows 10
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 Windows XP.
- Database connectivity
- Database connectivity must be 32-bit, even on a 64-bit device.
- Oracle 10, 11, and 12 (client must be compatible with RDBMS version and must be 32-bit)
- SQL Server 2005, 2008, 2012, and 2014 client
- Web browser
- Microsoft Internet Explorer (Windows) Versions 9, 10 and 11
- Mozilla Firefox 43.0 and higher
- Google 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
- Operating system and JDK/SDK
Standalone configuration (recommended):
- Windows Server® 2008, Windows Server 2012, Windows® 7, Windows8, Windows 10
- Red Hat® Enterprise Linux® releases 5. 6 and 7
- Oracle® Solaris 8, Solaris 9, Solaris 10
- HP-UX 11.11 and 11.23 or 64-bit
NOTE: Standalone configuration not recommended on same computer as the SQL Server® Stat Database
NOTE: The Stat Central Agent can run on Windows 64-bit computers
- IBM® AIX® v5.2, 5.3, 6.1, or 7.1 (all English-based)
- JDK/SDK versions (32 or 64-bit) 7 or 8
- Oracle Fusion Middleware 11g and 12c configuration
- Server Stat Database
NOTE: HP-UX 11.11, 11.23 requires HP JDK/SDK (32-bit)
NOTE: 64-bit AIX v5.2, 5.3, 6.1 and 7.1 requires IBM JDK/SDK.
- Minimum requirements
- CPU: 2.5 GHz (Dual Core processor ) Core i3 (or equivalent)
- RAM: 2 GB
- Disk: 500 MB
- Supported protocols: Outbound email-SMTP, Secure SMTP; Inbound email- IMAP4, Secure IMAP4, POP3 and Secure POP3
- Releases
Stat™ supports all products, including custom products, in the Oracle® EBusiness Suite Release 11i (11.5.10 and higher), 12, 12.1.1, 12.1.2, 12.1.3 (current release is 12.1.3), and 12.2 (current release is 12.2.5).
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, IBM, 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 us for updated platform certification. JDK/SDK Versions (32-bit): 7 and 8
- Windows, Solaris, and RedHat Linux require Oracle JDK/SDK (32-bit)
- HPUX 11.11, 11.23, 11.31 requires HP JDK/SDK (32-bit)
- 64-bit AIX v5.2, 5.3, 6.1, and 7.1 requires 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).
- Requirements
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 Central Agent. The Stat Central Agent currently supports the following cipher and MAC configurations: Ciphers:
- Blowfish
- Triple DES
- AES128Ctr, AES128CBC
- AES192Ctr, AES192CBC
- AES256Ctr, AES256CBC
Message Authentication Code (MAC):
- HMAC-MD5
- HMAC-SHA1
- HMAC-MD5-96
- HMAC-SHA1-96
Resources
Stat Extended Object Support
Simplify change management requirements for Oracle E-Business Suite applications
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.
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
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.
- More Resources
- Communities
- Research Docs
- Customer Stories
Take the next step
Related Products
Stat for PeopleSoft
Simplify change management requirements for PeopleSoft applications.
Foglight for Oracle
Deliver remote database monitoring and compare performance data across the IT environment
Support & 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.
Training & Certification
Training courses delivered through online web-based, on-site or virtual instructor-led.