Five key Fusion Cloud Applications monitoring features for better user adoption

August 4, 2022 | 10 minute read
Bala Mahalingam
Consulting Solution Architect A-Team
Text Size 100%:

Introduction

Application monitoring is a critical area every SaaS cloud customer should plan during the implementation. Application monitoring is a process of collecting relevant data to help your organization track/audit long-running jobs, application usage and proactively identify potential jobs for tuning. Understanding the functionalities implemented within your Oracle Fusion Cloud Applications and defining monitoring governance will help your organization to improve the user adoption of your deployed SaaS applications.

In continuation to my blogs on implementing multi-pillar Fusion applications and  Fusion applications cloud instance strategy and Global Single Instance guidelines, I wanted to share my experience on application monitoring features from Oracle Fusion Applications Suite. Integration flows monitoring is a separate topic and not included on this blog. This blog will provide you with the top five monitoring features and guidelines in Oracle Fusion Applications Suite.

FA Monitoring

Why do you need pro-active Fusion Applications monitoring?

Customers who deploy Oracle Fusion Cloud Applications must plan to monitor the deployed features, business processes, application usage, reports adoption, and potentially identify areas for performance improvements. After going live, continuous monitoring of your application pro-actively will help you to optimize the best user adoption. Common monitoring scenarios of users experiencing performance lagging on OTBI rendering, BIP reports, long-running ESS jobs, Several ESS jobs running simultaneously, and user application performance due to custom configurations. Monitoring these scenarios will help you triage issues before opening service requests with support yourself.

The most common application monitoring guidelines for Oracle Fusion Applications Suite are

  1. Plan your applications administrator role and define the activities during your implementation. Someone in your organization must own the responsibility of application monitoring for ongoing application adoption.
  2. Key monitoring guidelines available for application monitoring are given below.
  • Understand the subscribed and implemented offerings/functionalities.
  • Guide your functional and technical team on effective collaboration with Oracle support.
  • Create a process (for example long running reports) and educate your business users to help them troubleshoot issues. Refer to troubleshooting details on standard documentation to troubleshoot an issue proactively and to provide more information when you open a support ticket with Oracle.
  • Inspect application usage and audit to measure actual end-user experience.
  • Proactively identify potential performance bottlenecks by monitoring – Business Intelligence Publisher (“BIP”) reports audit, OTBI usage, ESS/Scheduled jobs.
  • Manage the users, roles & usage reports.
  • Define your enterprise alerts & notification contacts.
  • Manage your environment status, maintenance periods, and emails/notifications via Cloud Portal.
  • Review the new features summary and readiness material and create a governance process to educate your business & technical teams on upcoming features adoption.
  • Encourage business and technical teams to join and leverage Oracle Cloud Customer Connect Community. Users can get help from the community and share.

Fusion Cloud Application Monitoring Features

Fusion Cloud Applications Suite has five key monitoring features that help customers monitor the application effectively. The table below provides the available monitoring features for Fusion Cloud Applications.

Feature / Tool

Description

1. Cloud Portal

Oracle Cloud provides distinct consoles to manage the services and features of your Oracle Cloud Account. Infrastructure Console (OCI), Infrastructure Classic Console, and Application console.

2. Scheduled Processes

Scheduled processes do tasks that are too complex or time-consuming to do manually, for example importing data or updating many records. You can run scheduled jobs on a recurring schedule and send notifications based on how the process ends. The administrator/user can monitor the completed jobs, and long-running jobs and get logs and details.

3. OTBI Usage

Analyze six months of usage trends and patterns with a simpler selection of OTBI usage metrics, including for example user, report, and subject area usage patterns. Historical data older than six months is purged each week.

4. BI Publisher Audit

Audit Data for your BI Publisher reports in Fusion Applications. Audit reports will enable you to view the audit data for your reports including custom reports. BI Publisher Audit and Performance monitoring will be enabled by default. For customers who are using BIP for reports & custom reports, this will help on optimizing your reports.

5. Monitoring Reports

Fusion Cloud Application provides several pre-built reports to help manage and monitor users & roles. Refer to corresponding application pillar standard documentation for pillar-specific monitoring features.

Cloud Portal

Oracle Cloud provides distinct consoles (Cloud Portal) you can use to manage the services and features of your Oracle Cloud Account.

  • Infrastructure Console OR Infrastructure Classic Console
    • You will see Infrastructure Classic at the top of the page when you are using the Infrastructure Classic Console.
  • Application Console

The key Cloud administration tasks performed through Infrastructure Classic Console or Applications Console are:

  • View and monitor service details
  • Manage your accounts & subscriptions
  • Manage users
  • Perform service-specific maintenance and administration
  • Monitor uptime and status of a service instance
  • Export metric data, usage, and reports

Scheduled Processes

Oracle Fusion Applications uses the built-in enterprise Scheduler framework to define, schedule, and run jobs. Oracle provides pre-built scheduled processes to perform several business functions including importing records, validating information, and generating reports.

Scheduled processes are available across Oracle Fusion Cloud Applications and are based on functionality from Oracle Enterprise Scheduler (ESS). Because many processes can run at the same time, think of the queue of submissions as a high-speed interstate. For additional information, refer to Best Practices of Scheduled Processes and specific scheduled jobs across all applications. 

Fusion Applications: ESS Frequently Asked Questions (FAQs) (Doc ID 2723272.1) support tech-note has wealth of information on ESS. Additional Optimization Opportunities for Scheduled Processes (Doc ID 2820161.1) provides sample queries that may be used to create your monitoring BIP reports for monitoring scheduled jobs.

You may also navigate to search, view, and analyze scheduled processes through Click Navigator > Tools > ScheduledProcesses.

ESS custom jobs and ESS schedules are not copied during environment refreshes. Plan your job scheduling carefully based on your subscriptions to avoid performance issues. For example, having a large amount of custom BIP reports using the scheduler could impact the performance.

OTBI Usage

Oracle Fusion Applications has pre-built subject areas that provide real-time information on OTBI analysis and dashboard usage, logical and database SQLs, execution time and errors.

Subject areas to monitor OTBI usage and performance:

  • OTBI Usage Real Time: Monitors OTBI usage, including user, analysis and dashboard, and subject area usage trends.
  • OTBI Performance Real Time: Monitors usage trends and OTBI analysis execution time, execution errors, and database physical SQL execution statistics.

From this subject area, report developers and administrators gain insight into OTBI usage and performance trend, commonly used subject areas and report errors. This subject area provides data to monitor and diagnose OTBI reporting performance. Limit access to selected users for this subject area. Usually, application administrators who are monitoring the applications only will get access to these subject areas.

The OTBI Usage Real Time and Performance Real Time subject areas provide report authors and administrators real-time insight into usage and performance.

  • User pattern
  • Analysis and dashboard usage pattern
  • Subject area usage pattern
  • Common errors
  • Reporting data load 
  • Reporting performance 

OTBI usage subject areas capture each OTBI query execution and related database SQL execution details for six months. To ensure better performance, add proper filters to ensure optimal reporting performance. You can enable this feature in your environments quickly.

The diagram below provides steps required to enable OTBI Usage feature.

OTBI Usage Process

Refer to the support article How To Configure And Use Audit For Usage and Performance In OTBI For Fusion SaaS Cloud Customers (Doc ID 2731495.1) for details. A sample OTBI Usage Dashboard is given below showing 30-day usage, reports count, execution count. Users can use the filters to get relevant details.

OTBI Usage Dashboard Sample

 

BIP Audit

Audit Data for your BI Publisher reports in Fusion Applications can turn on or turn off the audit logging with a few clicks and view the Audit Data in a few simple steps. The sample Audit reports will enable you to view the audit data including custom BIP reports. BI Publisher Audit and Performance monitoring will be enabled by default. A retention period of 90 days has been set for BI Publisher Audit data in the Fusion SaaS environment.

The diagram below provides steps required to enable BIP Audit feature.

BIP Audit Reports Config Process

The following 6 reports are available as sample Reports built using Audit Data:

1. Audit Reports

a. Audit Data for Report Execution

b. Audit Data for Catalog Object Updates

2. Usage Reports

a. Hourly Concurrency

b. Report Execution-Time Metrics

c. Report Performance by Report Type

d. Runtime Statistics

Monitoring Reports

Oracle Fusion Applications comes with several seeded reports to help customers to monitor the applications. The table below lists the key reports for usage metrics, and user management.

 

Report

Description

Capture SaaS Usage Metrics for Financials

Captures the SaaS financials metrics that track business and operational activities. Available through Cloud Portal.

Generate Cloud Usage Metrics

Generates usage-based metrics for Oracle Fusion Cloud.

Inactive Users Report

Lists users who have been inactive for a specified period.

Locked Users

Identifies which users are unable to use the application because it is locked.

User Role Membership Report

Lists the roles assigned with each user.

User and Role Access Audit Report

Extract’s function and data security information for users and roles.

Generate Audit Report

Generates an audit report for the events and user actions.

User Password Changes Audit Report

Lists the user password changes audit

User and Role Access Audit Report

Extract’s function and data security information for users and roles.

Application adoption, usage, and object metrics and Dashboards. Customer Experience Sales and B2B Service module user adoption;

User Adoption subject areas with sample prebuilt reports that you can use as a starting point for user adoption.

HCM Transaction Console monitoring.

Refer to the tech-note Oracle HCM Cloud Common Features Release 13 Transaction Console (Doc ID 2430452.1)

Transaction Console (TAC) is a modernized application designed for administrators to monitor the entire lifecycle of transactions, including administrative actions to recover failed processes and enable Alert Initiator on Error.This is applicable for HCM.

Conclusion

Oracle Fusion applications cloud provides you with several features to continuously monitor your deployed application. Planning your application monitoring requirements by leveraging the monitoring features and defining a governance process for application monitoring increases user adoption.

References

Note: Always refer to the latest documentation

Bala Mahalingam

Consulting Solution Architect A-Team

Bala has over 27 years of techno-functional and hands-on product development, implementation, solution architecture  and consulting delivery experience with most of his career spent in architecture, design, development and deployment of applications and technology both on-premises and cloud. His expertise on data management, data integration, data quality and data governance has enabled him to help several customers globally in Hi-Tech, healthcare, financial, life-sciences, automotive and manufacturing industries.


Previous Post

Only Admins can break the Glass

Kiran Thakkar | 2 min read

Next Post


Connecting to Private ODI Marketplace with VNC Viewer

Matthieu Lombard | 11 min read