Monday, June 10, 2013

What's new in EBS 12.2?

New or changed technology-related features in EBS 12.2 include:

  • Streamlined installation:
    • Use of native installation tools for Oracle Fusion Middleware and Oracle Database technology stack components.
    • Option for installing EBS 12.2 on to existing database servers.
    • Capability of installation into existing Real Application Clusters environments.
    • Database deployment on Automatic Storage Management (ASM) and other file systems.
  • Support for online patching.
  • Use of Oracle WebLogic Server instead of AutoConfig for many (but not all) of AutoConfig's previous functions.
  • Use of Oracle WebLogic Server instead of Oracle Containers for Java (OC4J).
  • Integration between Oracle Enterprise Manager 11g Fusion Middleware Control and Oracle Applications Manager to monitor EBS environments with Oracle WebLogic Server technology.
  • Enhanced internationalization features, including new languages and calendars, and improved diagnostics.
  • Enhanced user interface features for Navigator menu, progress indicators, and table sorting.
  • Integration with AutoVue Document Print Services to print file attachments.
  • Undo and copy OA Framework personalizations.
  • Support for Mobile Safari on Apple iPads.
  • Enhanced Integrated SOA Gateway functionality for use with Oracle SOA Suite 11g and Oracle EBS Adapter.
  • Enhanced Workflow Worklist notification and management features.

For complete details for individual EBS products, see:

Concurrent Processing - CP Analyzer for E-Business Suite

The Concurrent Processing Analyzer is a Self-Service Health-Check script which reviews the overall Concurrent Processing Footprint, analyzes the current configurations and settings for the environment providing feedback and recommendations on Best Practices.

  • This is a non-invasive script which provides recommended actions to be performed on the instance it was run on and can be run at any time.  For production instances, always apply any changes to a recent clone to ensure an expected outcome.
Benefits
  • Immediate Analysis and Output of Concurrent Environment
    • E-Business Applications Concurrent Processing Analyzer Overview
      • Total Purge Eligible Records in FND_CONCURRENT_REQUESTS
      • E-Business Suite Version
      • Concurrent Processing Database Parameter Settings
      • Applied ATG Patches
      • Known 1-Off Patches on top of Rollups
    • E-Business Applications Concurrent Request Analysis
      • Long Running Reports During Business Hours
      • Elapsed Time History of Concurrent Requests
      • Requests Currently Running on a System
      • FND_CONCURRENT_REQUESTS Totals
      • Running Requests
      • Total Pending Requests by Status Code
      • Count Pending Regularly Scheduled/Non Regularly-Scheduled Requests
      • Count of Pending Requests on Hold/Not on Hold
      • Listing of Scheduled Requests
      • Listing of Pending Requests on Hold
      • Listing of Pending Requests Not on Hold
      • Volume of Daily Concurrent Requests for Last Month
      • Identify/Resolve the Pending/Standby Issue, if Caused by Run Alone Flag
      • Tablespace Statistics for the fnd_concurrent tables
    • E-Business Applications Concurrent Manager Analysis
      • Concurrent Managers Active and Enabled
      • Concurrent Manager Processes by Workshift
      • Active Manager for Applications that are not Installed/Used
      • Total Target Processes for Request Managers (Excluding Off-Hours)
      • Request Managers with Incorrect Cache Size
      • Concurrent Manager Request Summary by Manager
      • Check Manager Queues for Pending Requests
      • Check the Configuration of OPP
  • Identifies Concurrent System Setup and configurations
  • Identifies and recommends Concurrent Best Practices
  • Easy to add Tool for regular Concurrent Maintenance
  • Execute Analysis anytime to compare trending from past outputs
Audience
  • DBA's / System Administrator's should run the script and review the output
  • Pending the output, one may interact with the the following End-User types to resolve the identified Opportunity Improvement areas:
    • Apps Access (Toad or SQL Developer)
    • Filesystem access (apps logfiles) $APPLCSF/$APPLLOG
    • SYSADMIN access permissions
  • Output usually will be reviewed by a group of people pending the problems
  • This script was designed for Concurrent Processing in 11.5.x and later.

Where to Run Script & How to fix Items Identified in Script:
You may run the script on a Production environment as it's non-invasive.  We recommend fixing items identified from the output first in a clone of production to test/verify the expected outcome.

For script and more information, Concurrent Processing - CP Analyzer for E-Business Suite [ID 1411723.1]