Database ParaIn addition to helping customers resolve issues via Service Requests, Oracle Support also builds over 60 free diagnostic tools for Oracle E-Business Suite 12.2, 12.0, 12.1, and 11i. These Support Analyzers are non-invasive scripts that run health-checks on your EBS environments. They look for common issues and generate standardized reports summarizing that provide solutions for known issues and recommendations on best practices.

Here’s an index to these tools:

• Get Proactive with Oracle E-Business Suite – Product Support Analyzer Index (Note 1545562.1)

Spotlight on Database Parameter Settings Analyzer

We publish a definitive list of Oracle Database initialization parameter settings for the optimal performance of Oracle E-Business Suite 12.2, 12.1, and 12.0:

• Database Initialization Parameters for Oracle E-Business Suite Release 12 (Note 396009.1)

This document is updated regularly; for example, it was recently updated to account for changes introduced by the April 2017 updates to the AD and TXK utilities.

It can be challenging to keep up with those changes simply by scanning Note 396009.1 yourself.  You can automate this process by using the Database Parameter Settings Analyzer:

• EBS Database Parameter Settings Analyzer (Note 1953468.1)

The Database Parameter Settings Analyzer compares your database’s parameter settings to the latest recommendations in Note 396009.1.  It reports on any differences, and makes recommendations about your sga_target, shared_pool_size, shared_pool_reserved_size and processes parameters based upon the number of active users for your environment.

This tool can be run manually or configured to run as a concurrent request, so it can be scheduled to be run periodically and included in regular database maintenance cycles.

Can this script be run against Production?

Yes. There is no DML in the Analyzer Script, so it is safe to run against Production instances to get an analysis of the environment for a specific instance. As always it is recommended to test all suggestions against a TEST instance before applying to Production.

Source: https://blogs.oracle.com/stevenchan/check-your-ebs-database-configuration-with-database-parameter-settings-analyzer

We are pleased to announce updates for the Oracle E-Business Suite Mobile Approvals 1.6 smartphone app for iOS and Android. These updates are delivered as part of Oracle E-Business Suite Mobile Release 7, which supports both Oracle E-Business Suite Release 12.1.3 and 12.2.3 and beyond.  Oracle E-Business Suite Mobile Release 7 is a coordinated release of 17 Oracle E-Business Suite mobile apps, excluding Mobile Expenses and Mobile Field Service, which have their own off-cycle releases.

For information on the Approvals app, see:

• Oracle Mobile Approvals for Oracle E-Business Suite Release Notes (Note 1642423.1)

For more details on the updates for all EBS mobile apps, see:

• Oracle E-Business Suite Mobile Apps, Release 12.1 and 12.2 Documentation Index (Note 1641772.1)

What’s New in Mobile Approvals 1.6

• Ability to reassign an approval notification
• Support for push notifications when using Oracle Mobile Cloud Service and enterprise distribution
• Mobile Foundation:
  • Ability to import custom CA or self-signed server certificates to standard apps for TLS connections to Oracle E-Business Suite
  • Ability to download the mobile app configuration automatically from the server
  • Technical updates with uptake of Oracle Mobile Application Framework (MAF) 2.4.0

Related Articles

• Building Custom EBS Mobile Apps with REST
• Webcast: Build, Deploy, and Manage Smartphone Apps for EBS
• Approvals 1.5 for E-Business Suite Now Available
• Approvals 1.4 for E-Business Suite Now Available

In addition to helping customers resolve issues via Service Requests, Oracle Support also builds diagnostic tools for Oracle E-Business Suite. Here’s an index to all of these tools:

• Get Proactive with Oracle E-Business Suite – Product Support Analyzer Index (Note 1545562.1)

What do Support Analyzers do?

These Support Analyzers are non-invasive scripts that run health-checks on your EBS environments. They look for common issues and generate standardized reports summarizing that provide solutions for known issues and recommendations on best practices.

What areas do they cover?

There are over 60 different analyzers for EBS 11i, 12.0, 12.1, and 12.2. There are analyzers for the following product families:

• E-Business Suite Core (Technology)
• Financials
• Manufacturing
• Human Capital Management  
• Customer Relationship Management  

Spotlight on Workflow Analyzer

If you haven’t tried any of these tools, I’d strongly recommend getting started with the Workflow Analyzer:

• EBS Workflow (WF) Analyzer (Note 1369938.1)

Source:https://blogs.oracle.com/stevenchan/check-workflows-health-with-workflow-analyzer