The Applications Dashboard provides a "snapshot" of your Oracle E-Business Suite system. Information is grouped under the following tabs: Overview, Performance, Critical Activities, Diagnostics, Business Flows, Security, and Software Updates.
From the Dashboard you can navigate to the Site Map, or use the drop-down menu to navigate to any of the following pages:
Application Services
Configuration - Overview
Forms Sessions
Database Status
Applied Patches
Patch Wizard
Workflow Manager
Oracle Applications Manager uses the collection program OAM Applications Dashboard Collection (short name: FNDOAMCOL) to gather the information displayed. The default repeat interval for this program is 10 minutes. To immediately regather the data and update the display for a particular region, click the corresponding Refresh icon. If the OAM Applications Dashboard Collection request is not running when you log in to the Oracle Applications Manager, a request will be submitted automatically under your username.
Note: The status of Web Components is collected manually from the Dashboard.
This page provides an overview of the general status of your system. It includes the following regions:
Use this region to view the status of each host machine in your system. The display shows which services are installed on which host machine and the statuses of these services.
Services displayed that represent more than one service component (such as Forms) indicate the status of the worst-case component. For example, if the Forms Listener is down, but the other Forms components are running, the down status will be indicated on this page.
The Database, Concurrent Processing, Forms, and Web status indicators drill down to the Applications System Status page where you can view the status of each individual service.
Host - the host name.
Platform - the host's operating system.
Admin - indicates whether the Admin server has been installed on the host machine.
Database - indicates the status of the database instance installed on the host machine.
Concurrent Processing- indicates the status of the Internal Concurrent Manager and the services managed by the ICM.
Forms - indicates the status of the Forms Server components: Forms Listener, Metrics Server, Metrics Client, and OAM Generic Collection Service.
Web - indicates the status of the Apache Web Listener.
The purpose of this region is to alert you to system-level changes that have occurred in the last 24 hours. Use this data to help diagnose sudden changes in the functioning of your applications system.
To see the list of Patches Applied, click on the number to drill down to the Patch Summary page.
To see the list of Site Level Profile Options, click on the number to drill down to the Site Level Profile Settings page.
To see the list of Applications Context Files Edited, click on the number to drill down to the Applications Configuration Parameters page. Changes made to context files can impact your overall processing configuration and the functioning of business processes.
This region lists the number of system alerts in the categories listed below. If your system is functioning well, there should be no new alerts reported. When an alert of a particular type first occurs, it is counted as a new alert. It remains new until the status is manually changed by the administrator. If an alert of the same type occurs again while the original alert is still in open or new status, it is counted as a new occurrence.
New Alerts - alerts that have not yet been acknowledged by the administrator. An alert is acknowledged when it is manually moved from a status of "New" to a status of "Open" or "Closed."
New Occurrences - additional occurrences of alerts that are in new status.
Open Alerts - all alerts that are in an open status. An alert must be manually moved from the new to open status.
Open Occurrences - all occurrences of alerts that are currently open. Click on the number for any of these to drill down to the System Alerts and Metrics page.
This region lists the status of the web components. Status values may be "Up," "Down," or "Warning".
The status of each Web component is determined by testing the corresponding URL as defined in the component's Web agent profile option. The Warning status will be displayed if the profile option is not set. Otherwise, a status of Up or Down will be returned based on the success of the URL test. The profile options are listed with their corresponding components below.
Servlet Agent - Uses profile option APPS_SERVLET_AGENT (Apps Servlet Agent). If down, the Self-Service Framework-based Applications will not function, as well as all other servlet-based features. Look for errors in the Apache error and access logs (see above for location). Also, execute the Servlet Ping from the System Administration Diagnostics menu.
JSP Agent - Uses profile option APPS_SERVLET_AGENT (Apps Servlet Agent). If down, execute the JSP Ping from the System Administration Diagnostics menu. In addition, all nodes in FND_NODES are authorized to ping; if the OAM node belongs to that list, then the JSP Agent status will be valid. Additional nodes can be authorized by adding a preference similar to the following example:
user: #INTERNAL module: FND_PING name: ALLOWED_NODES value: www.<example domain>.com, or 192.160.3.100
TCF - Uses profile option APPS_SERVLET_AGENT (Apps Servlet Agent). If down, try running the AOL/J Diagnostic or the Servlet Ping utilities from the System Administration Diagnostics menu.
The User Initiated Alerts region is similar to the System Alerts region. You can define additional alerts to be raised for events of your choosing. With User Initiated Alerts, end users can report problems or other issues to administrators by clicking on the "Contact Admin" global button available in Oracle Application Framework-based pages. The end user can provide a description of the problem, and the framework will automatically collect the application context of the page from which the user clicked the button. This report generates an user alert, which can be viewed from the Oracle Application Manager Dashboard.
This feature is enabled when the profile "OAM: UALERT_SHOW_ICON" is set to 'Y' at the Site level and logging is enabled at the Unexpected level ("UNEXPECTED-6").
This region lists the number of alerts in these categories:
New Alerts - Alerts that have not yet been acknowledged by the administrator. An alert is acknowledged when it is manually moved from a status of "New" to a status of "Open" or "Closed."
New Occurrences - Additional occurrences of alerts that are in the New status.
Open Alerts - All alerts that are in an Open status. An alert must be manually moved from the New to Open status.
Open Occurrences - All occurrences of alerts that are currently open. Click on the number for any of these to drill down to the Alerts and Metrics page.
This page lists each Applications Server and its status. Each server type expands to display the host name, which expands to display the status of each server component.
Navigation: Applications Dashboard (Overview page) > (drill down on) Database, Concurrent Processing, Forms, or Web column (under Applications System Status)
Administration
Database- expands to display the instance name and status. Drill down on the instance name to display the Database Status Details page. Concurrent Processing - expands to display concurrent managers and services controlled by the Internal Concurrent Manager. These expand to display the instances of the managers and services and their statuses. Drill down on the instance names to display the Service Instances page.
Forms - expands to display the Forms server components: the Forms Listener, the Metrics Server, the Metrics Client, and the OAM Generic Collection Service. The component names expand to display the service instances. Drill down on the instance name to display the Service Instances page.
Web - expands to display the web component: the Apache Web Listener. The component name expands to display the service instance name. Drill down on the instance name to display the Service Instances page.
Click on the Focus icon for an item to display only its status and the status of its children.
The Performance region lists Activity and System Throughput indicators. Each of the values listed for Activity and System Throughput links to the related detail page.
Forms Sessions - the number of running Forms sessions. Drills down to the Forms Sessions page.
Database Sessions - the number of active database sessions. Clicking the value runs the Show Active Database Sessions request and returns the results page.
Running Concurrent Requests - drills down to the Search for Requests Results page showing all currently running requests.
Service Processes - drills down to the System Activity page. Service processes include all concurrent manager processes and all processes managed by the ICM. If you have set up your system to have other services managed by the GSM, those services are included as well.
Services Up - the number of service instances whose target services match the actual services. Services Down - the number of service instances whose target services do not match the actual services.
Invalid Database Objects - drills down to the Invalid Database Objects page displaying the search results for invalid objects owned by the APPS schema.
Unsent Workflow E-Mail
Completed Concurrent Requests - the percentage of concurrent requests submitted in the last 24 hours that have completed.
Sent Workflow E-Mail - the percentage of Workflow e-mail sent successfully.
The Critical Activities region lists concurrent programs that perform maintenance activities. The programs are grouped by activity type and by application. To display only a particular group, click the group's Focus icon.
To add or delete a program to the critical activities list, click the Modify Monitored Program List button to access the Modify Monitored List page.
To change the frequency that a monitored program is run, click the Update Frequency button.
For each critical activity, the following are displayed:
Program Name - Drills down to the Activity Summary page showing work metrics for those programs that have been instrumented to compute them.
Request ID - The last run request ID. Drills down to display the request in the concurrent request Search Results screen.
Last Run Date
Outcome - indicates the completion status of the request.
Oracle Recommended Frequency - The frequency that Oracle recommends a critical program be run (if applicable).
On Schedule (Oracle Recommended) - indicates whether the Oracle recommended schedule has been met (if applicable).
Onsite Frequency - the frequency that the program is currently scheduled to run. To change the frequency, use the Update Frequency button to access the Update Frequency for Monitored Critical Activities page.
On Schedule (Onsite Frequency) - indicates whether the onsite schedule has been met.
Success Rate - the percentage of completed requests that completed with a status of normal. Drill down on the value to display a success rate chart showing completion status percentage rates of Normal, Warning, and Error. Mouse over the chart to display the numeric values.
Navigation: Applications Dashboard > Critical Activities (B) Modify Monitored Program List
Use this page to add or remove programs to the critical activities list.
To add a program to the Monitored list, select the program from the Not Monitored list and click the Move shuttle button.
To add all programs from the Monitored list, click the Move All shuttle button.
To remove a program from the Monitored list, select the program from the Monitored list and click the Remove shuttle button.
To remove all programs from the Monitored list, click the Remove All shuttle button.
Click OK to apply your changes.
Navigation: Applications Dashboard > Critical Activities (B) Update Frequency
Use this screen to update the frequency that your critical activity programs are run.
The following are listed for each critical activity program:
Program Name
Application
Program Type
Oracle Recommended Frequency - the run frequency recommended by Oracle (if applicable).
Onsite Frequency - the frequency that the program is currently scheduled to run. To change the run schedule for a program, update the Onsite Frequency field and click OK. Note that this is the target frequency and may not be the frequency that the program actually runs. Monitor the success of the target frequency with the On Schedule (Onsite Frequency) field on the Applications Dashboard - Critical Activities page.
Navigation: Applications Dashboard > Critical Activities > [Program Name]
This page displays work metrics for those maintenance programs that have been instrumented to compute them. The display can be filtered by the table name or value.
Name - the name of the table that will be purged by the program.
Value - the number of rows in the table that will be purged if the program is run.
Oracle Applications Manager allows you to monitor and support business flows within Oracle E-Business Suite. User-defined key business flows are correlated with the system components responsible for the execution of those flows.
Navigation: Applications Dashboard > Business Flows tab
From the OAM console you can:
View the hierarchical representation of the business flows.
Monitor system alerts, errored requests, and errored work items for a business flow.
View the setup status for the business flows and associated subflows.
The Key Business Flows region displays the current listing of business flows, with these columns:
Status - Indicates the setup status of the business flow. Business flows that are not fully set up are listed as unavailable
Edit
To create a new business flow, click Create. Click View Details for a selected business flow to view additional information for that business flow. Click the Edit icon for a selected business flow to update it.
Use these pages to create or edit a business flow.
Navigation: Applications Dashboard > Business Flows tab > Create (B) or Edit icon for a selected business flow
Enter a name and description for the business flow.
Enter in a child flow or component for the business flow. Choose from the following:
New Business Flow - If you select New Business Flow you are prompted for a name and description of the new business flow. You can later update the new subflow with children of its own.
Existing Business Flow - You are prompted to choose a business flow from a list of values.
Work Item Type - You are prompted to choose a workflow item type from a list of values.
Component - Select from Concurrent Program, Service, Form or Function. You are prompted for a component name from a list of values.
This page displays details for a selected business flow.
Navigation: Applications Dashboard > Business Flows tab > View Details (B) for selected business flow
Subflows and components of the business flow are shown in hierarchical format. You can expand or collapse nodes on the hierarchical tree.
Maintain your business flow monitoring from this page.
Navigation: Setup (global icon) > Business Flows (side navigation)
OAM provides the following concurrent program to help you maintain your business flow setup. Schedule requests for the concurrent program from the link provided.
Metrics Refresh - schedule requests for the OAM: KBF Metrics Rollup Program to update the setup status of your business flows.
For each of the business flows listed, you can view whether monitoring is enabled and enable or disable monitoring.
Select a business flow and click Update to enable or disable monitoring. Click View Details to view if monitoring is enabled.
Information on this page helps you detect and diagnose security issues on your Oracle E-Business Suite System.
Navigation: Applications Dashboard > Security (tab)
Click the Manage Security Options button to manage SQL*Net access for your middle-tier hosts.
Security Alerts can be raised either at runtime by the application code, or at the failure of security-related diagnostic tests. The table is organized by severity, which can be Critical, Error, or Warning. It provides numerical counts of new and open alerts. Where enabled, you can drill down on the numerical links to view and manage the details of an alert and any associated diagnostic test reports. Alert details and test reports can be added to the Support Cart.
This table shows security-related diagnostic tests that failed when they were executed. The table specifies the most recent time that the test failed, and provides links that open detailed test reports. For a specific test, clicking the Diagnose icon will re-execute the test - this is useful to verify that the error still exists. For a specific application, clicking the Diagnose icon allows you to re-execute all failed tests in that application for the chosen security level.
Links to security-related documents on My Oracle Support are located here. Documents include:
Best Practices for Securing Oracle E-Business Suite
Oracle Support Services Security Alert - Frequently Asked Questions
Security Announcements and Notes
You can manage Oracle E-Business Suite Diagnostics tests from the Dashboard.
The two key tests accessible from the OAM Security tab are:
Best Practices: Database Security Tests
Best Practices: Oracle E-Business Suite Security Tests
These tests are described further in My Oracle Support Document 1337420.1, Secure Configuration Guide for Oracle E-Business Suite Release 12.2.
For more information on Oracle E-Business Suite Diagnostics, see: Oracle Diagnostics Framework User's Guide.
Use this button to access Security Options.
These pages allow you to restrict SQL*Net access to the database from your application tier hosts. If you enable the SQL*Net Access security option, you can select which hosts have SQL*Net access to the database. If you disable the SQL*Net Access security option, then all application tier hosts have SQL*Net access to the database.
Use the View SQL*Net Access page to see how SQL*Net Access is currently configured for your middle-tier hosts.
Navigation: Applications Dashboard > Security (tab) > Manage Security Options (B)
If the Manage SQL*Net Access security option is disabled, a message here indicates that it is disabled. All hosts have SQL*Net access to the database in this case.
If this feature is enabled, the table of hosts indicates which hosts have SQL*Net access and which do not.
Note: In order for the information on this page to be accurate, the following steps must be run in addition to enabling or disabling the Manage SQL*Net security option:
Run AutoConfig on the database tier
Bounce the TNS Listener
The table shows the hosts that have SQL*Net access and includes the following columns:
Name
Platform
Oracle Applications Host - Indicates whether the host is an Oracle E-Business Suite host or not. Application services (Concurrent Processing, Oracle Forms, Web, Admin, and Database services) can run on Oracle E-Business Suite hosts.
Use the Manage SQL*Net Access wizard to enable or disable SQL*Net access to the middle-tier hosts. You can register a new host and grant it access as well from this wizard.
When you disable the SQL*Net Access security option, you allow SQL*Net access to the database from your middle-tier hosts.
Oracle Applications Manager uses the program OAM Applications Dashboard Collection (short name: FNDOAMCOL) to gather the information displayed on the Dashboard under the Overview and the Performance tabs.
The Dashboard Collection Program can selectively enable and disable monitoring of various metrics, and to raise alerts for services when the service has a specified status. The Dashboard Collection Program can collect data for a metric and then raise an alert when a metric reaches a specified threshold. Note that for most components, you can collect data for monitoring purposes in two different ways: (1) through the Dashboard Collection Program, or (2) manually refreshing the data from a Dashboard page.
Metrics for the following data can be monitored for the following using the Dashboard Collection Program. In addition, data for web components can be collected manually in the dashboard.
Forms Sessions
Database Sessions
Running concurrent requests
Service processes
Services up
Services down
Invalid database objects
Unsent Oracle Workflow e-mail
Patches applied
Site level profile options
Applications context files edited
New alerts
New occurrences of an alert
Open alerts
Alerts can be raised for the following services. When a service attains a specified status, an alert is raised.
Service instances listed under Applications System Status
Web Components
Completed concurrent requests
Sent Oracle Workflow e-mail