If parting the Red Sea sounds easier than upgrading to Oracle E-Business Suite R12, then you need to read the 10 Commandments of a Successful R12 Upgrade.

Quest Software didn’t have to look far for a solution to help simplify its own upgrade to Oracle E-Business Suite R12. See how Stat shaped up in our case study.

Read now »

Case Study

Stat® for Oracle E-Business Suite is a Cost-Saving Hit with HBO®

Read now»

Upgrading to R12? Watch Our Webcast Series

In these five-minute webcasts, our EBS experts reveal step-by-step guidance that’ll make your R12 upgrade fast and painless.

Learn more »

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

Get Started

Features
Screenshots
Docs

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

Workflow

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

Take a tour of Stat for Oracle E-Business Suite

Screenshots 1 of 5

Screenshot #2 Screenshot #3 Screenshot #4 Screenshot #5