8 Oracle E-Business Suite

Oracle E-Business Suite is a complete set of business applications for managing and automating processes across your enterprise.

8.1 Abandoned Nodes

During online patching, patching can fail on some nodes. You can mark this node as abandoned and proceed with the completion of the patching cycle. This metric category collects the list of abandoned nodes and raises an incident. For an abandoned node, you must first customize the discovery and disable this node and then do a rediscovery. For more information about discovery, see the Oracle Enterprise Manager Cloud Control Administrator's Guide.

8.1.1 Node Name

This metric displays the name of the node with the failed online patching.

Target Version Collection Frequency
All Versions Every 60 Minutes

8.1.2 Node Type

This metric displays the type of node with the failed online patching.

Target Version Collection Frequency
All Versions Every 60 Minutes

8.1.3 Status

This metric displays the status of the node and raises an incident if the node is marked as Abandoned.

Target Version Collection Frequency Default Warning Threshold Default Critical Threshold Alert Text
All Versions Every 60 Minutes Not Defined Abandoned Node %node_name% is abandoned. Please exclude this node from discovery customization and rerun EBS discovery.

8.2 Activity

This metric category provides information about active service processes, active concurrent requests, and active Forms sessions.

Data Source

The metrics in this category are computed by counting total active concurrent requests by application from FND_CONCURRENT_REQUESTS and FND_CONCURRENT_PROCESSES and FND_LOGIN_RESP_FORMS.

8.2.1 Active Service Processes

This metric displays the total number of processes running for the concurrent manager.

Target Version Collection Frequency
All Versions Every 15 Minutes

8.2.2 Concurrent Requests Running

This metric displays the active running concurrent requests.

Target Version Collection Frequency
All Versions Every 15 Minutes

8.2.3 Forms Sessions

This metric displays the active Forms sessions.

Target Version Collection Frequency
All Versions Every 15 Minutes

8.3 Applications System Status

This metric category shows the application system status. These metrics are collected for generating various charts for performance and usage.

8.3.1 Apps Metric Type

This metric displays the type of Applications metric.

Target Version Collection Frequency
All Versions Every 15 Minutes

8.3.2 Host Name

This metric displays the host name.

Target Version Collection Frequency
All Versions Every 15 Minutes

8.3.3 Host Platform

This metric displays the host's operating system.

Target Version Collection Frequency
All Versions Every 15 Minutes

8.3.4 Last Update Date

This metric displays the date of the last update.

Target Version Collection Frequency
All Versions Every 15 Minutes

8.3.5 Metric Name

This metric displays the name of the metric.

Target Version Collection Frequency
All Versions Every 15 Minutes

8.3.6 Service Description

This metric displays a description of this service.

Target Version Collection Frequency
All Versions Every 15 Minutes

8.3.7 Service Name

This metric displays the name of this service.

Target Version Collection Frequency
All Versions Every 15 Minutes

8.3.8 Service Status Code

This metric displays the status code associated with this service.

Target Version Collection Frequency
All Versions Every 15 Minutes

8.3.9 Service Type

This metric displays the type of this service.

Target Version Collection Frequency
All Versions Every 15 Minutes

8.4 Applications by Errored Execs

This metric category is used to send alerts when errors executions exceed certain limits set by users. These metrics are important to understand failure rate as well as using total exceutions for capacity planning.

Data Source

The metrics in this metric category are computed by counting errored executions from FND_CONCURRENT_REQUESTS.

8.4.1 Application Name

This metric displays the name of the application.

Target Version Collection Frequency
All Versions Every 1 Day

8.4.2 Application Short Name

Target Version Collection Frequency
All Versions Every 1 Day

This metric displays the short name of the application.

8.4.3 Errored Executions

This metric displays the number of errored executions.

You can set the threshold to monitor errored executions of concurrent programs.

Target Version Collection Frequency Default Warning Threshold Default Critical Threshold Alert Text
All Versions Every1 Day Not Defined 0 %value%

User Action

Investigate all the errored concurrent process executions.

8.4.4 Errored Executions (%)

This metric displays the percentage of errored executions.

Target Version Collection Frequency
All Versions Every 1 Day

8.4.5 Node Name

This metric displays the name of the node.

Target Version Collection Frequency
All Versions Every 1 Day

8.4.6 Total Executions

This metric displays the total number of executions.

Target Version Collection Frequency
All Versions Every 1 Day

8.5 Applications by Pending Requests

This metric category shows all the pending concurrent requests by application.

8.5.1 Application Name

This metric displays the name of the application.

Target Version Collection Frequency
All Versions Every 1 Day

8.5.2 Application Short Name

This metric displays the short name of the application.

Target Version Collection Frequency
All Versions Every 1 Day

8.5.3 Number of Pending Requests

This metric displays the number of pending concurrent requests.

Target Version Collection Frequency Default Warning Threshold Default Critical Threshold Alert Text
All Versions Every 1 Day Not Defined Not Defined %value%

Data Source

This metric is computed by counting pending concurrent processing requests from FND_CONCURRENT_REQUESTS.

User Action

If a large number of concurrent requests are pending, then make sure the concurrent manager is up and running or else consider adding more concurrent managers.

8.6 Concurrent Managers Configured

This metric category provides information about the number of configured concurrent managers.

8.6.1 Number of Configured Concurrent Managers

This metric shows the number of concurrent managers configured.

Target Version Collection Frequency
All Versions Every 1 Day

Data Source

FND_CONCURRENT_REQUESTS

8.7 Configuration Changes (Last 24 hours)

This metric indicates if the configuration has changed in the last 24 hours.

8.7.1 Context Files Edited

This metric displays the number of context files that have changed on the system in the last 24 hours. Changes made to context files can impact your overall processing configuration and the functioning of business processes.

If you want to get notified about these configuration changes, then set this threshold.

Target Version Collection Frequency Default Warning Threshold Default Critical Threshold Alert Text
All Versions Every 1 Hour Not Defined Not Defined %value% context files have been edited in the last 24 hours

User Action

Use this data to help diagnose sudden changes in the functioning of your applications system.

8.7.2 Invalid Database Objects

This metric displays the list of invalid objects owned by the APPS schema.

Target Version Collection Frequency Default Warning Threshold Default Critical Threshold Alert Text
All Versions Every 1 Hour Not Defined Not Defined %value% invalid objects found

User Action

Use this data to help diagnose sudden changes in the functioning of your applications system.

8.7.3 Last Update Date

This metric displays the date of the last update.

Target Version Collection Frequency
All Versions Every 1 Hour

8.7.4 Patches Applied

This metric displays the list of patches that have been applied to the system in the last 24 hours.

Target Version Collection Frequency
All Versions Every 1 Hour

User Action

Use this data to help diagnose sudden changes in the functioning of your applications system.

8.7.5 Site Level Profile Options Changed

This metric displays the number of site level profile options that have changed on the system in the last 24 hours.

Target Version Collection Frequency Default Warning Threshold Default Critical Threshold Alert Text
All Versions Every 1 Hour Not Defined Not Defined %value% site level profile options have changed in the last 24 hours

User Action

Use this data to help diagnose sudden changes in the functioning of your applications system.

8.8 Forms Database Sessions per Application

This metric category provides information about the Forms database sessions for a selected application.

8.8.1 Application Name

This metric displays the name of the application.

Target Version Collection Frequency
All Versions Every 15 Minutes

8.8.2 Application Short Name

This metric displays the short name of the application.

Target Version Collection Frequency
All Versions Every 15 Minutes

8.8.3 Number of Forms Database

This metric displays the number of form sessions for each application.

Target Version Collection Frequency Default Warning Threshold Default Critical Threshold Alert Text
All Versions Every 15 Minutes 0 Not Defined %value% Forms Database Sessions are active for Application %application_name%

Data Source

This metric is computed by counting form sessions for each application.

User Action

If the warning threshold is reached, then investigate the Oracle E-Business Suite sizing guidelines.

For more information see R12: Forms Runtime Diagnostics (FRD), Tracing And Logging For Forms In Oracle Applications (Doc ID 438652.1) on My Oracle Support:

https://support.oracle.com/

8.9 Native Services

This metric category is used to determine the status of native services. You can set the collection schedule only and not the warning or critical threshold levels.

8.9.1 Application Name

This metric displays the name of the application.

Target Version Collection Frequency
All Versions Every 15 Minutes

8.9.2 Application Short Name

This metric displays the short name of the application.

Target Version Collection Frequency
All Versions Every 15 Minutes

8.9.3 Service Actual Processes

This metric displays the number of service actual processes.

Target Version Collection Frequency
All Versions Every 15 Minutes

8.9.4 Service Application Name

The metric displays the service application name.

Target Version Collection Frequency
All Versions Every 15 Minutes

8.9.5 Service Handle

This metric displays the service handle.

Target Version Collection Frequency
All Versions Every 15 Minutes

8.9.6 Service Message

This metric displays the service message.

Target Version Collection Frequency
All Versions Every 15 Minutes

8.9.7 Service Name

This metric displays the name of the service

Target Version Collection Frequency
All Versions Every 15 Minutes

8.9.8 Service Status

This metric displays the status of the service.

Target Version Collection Frequency Default Warning Threshold Default Critical Threshold Alert Text
All Versions Every 15 Minutes 0 Not Defined Service %srvc_name% is down.

User Action

If the services are down, investigate the cause and start up the services again.

8.9.9 Service Target Processes

This metric displays the service target processes.

Target Version Collection Frequency
All Versions Every 15 Minutes

8.10 Oracle Applications Internal System Alerts

This metric category provides internal system alerts for users to take corrective actions

8.10.1 Last Update Date

This metric displays the date of the last update.

Target Version Collection Frequency
All Versions Every 15 Minutes

8.10.2 New Oracle Applications System Alert Occurrences

This metric displays the number of additional occurrences of system alerts that are in a new status.

Target Version Collection Frequency Default Warning Threshold Default Critical Threshold Alert Text
All Versions Every 15 Minutes 0 Not Defined New Oracle Applications system alert occurrences greater than %value%

User Action

You can set the threshold for New System Alert Occurrences. Check alerts and take corrective action.

8.10.3 New Oracle Applications System Alerts

This metric displays the number of system 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.

Target Version Collection Frequency Default Warning Threshold Default Critical Threshold Alert Text
All Versions Every 15 Minutes 0 Not Defined New Oracle Applications system alerts greater than %value%

User Action

You can set the threshold for New system alerts. Check alerts and take corrective action.

8.10.4 Open Oracle Applications System Alert Occurrences

This metric displays all occurrences of alerts that are currently open.

Target Version Collection Frequency
All Versions Every 15 Minutes

8.10.5 New Oracle Applications System Alerts

This metric displays all the system alerts that are in an open status. An alert must be manually moved from the new to open status.

Target Version Collection Frequency
All Versions Every 15 Minutes

8.11 Processes and Requests per Concurrent Manager

This metric category provides information about the processes and requests for each concurrent manager.

8.11.1 Available Processes

This metric displays the number of available processes.

Target Version Collection Frequency
All Versions Every 7 Minutes

8.11.2 Concurrent Manager Name

This metric displays the name of the concurrent manager.

Target Version Collection Frequency
All Versions Every 7 Minutes

8.11.3 Normal Pending Requests

This metric displays the number of pending requests.

Target Version Collection Frequency
All Versions Every 7 Minutes

8.11.4 Running Requests

This metric displays the number of running requests.

Target Version Collection Frequency
All Versions Every 7 Minutes

8.11.5 Standby Pending Request

This metric displays the number of standby pending requests.

Target Version Collection Frequency Default Warning Threshold Default Critical Threshold
All Versions Every 7 Minutes Not Defined Not Defined

User Action

You can set the threshold Standby Pending Requests (>=) and receive alerts when the warning threshold is reached. Investigate why the requests are in standby pending status. Check if any background processes are blocking the concurrent request queue.

8.12 Programs by Average Running Time

This metric category provides information about the average running time for concurrent programs.

8.12.1 Average Running Time

This metric displays the average running time for the concurrent program.

Target Version Collection Frequency Default Warning Threshold Default Critical Threshold Alert Text
All Versions Every 1 Day Not Defined Not Defined %value%

User Action

You can set the threshold for this metric for all the concurrent requests. If the concurrent programs average time reaches the threshold, that is, exceeds the average running time, then alerts are generated. If the average running time exceeds the threshold, then investigate the cause.

8.12.2 Concurrent Program Name

This metric displays the internal name of the concurrent program.

Target Version Collection Frequency
All Versions Every 1 Day

8.12.3 Maximum Running Time

This metric displays the maximum running time for concurrent programs.

Target Version Collection Frequency
All Versions Every 1 Day

8.12.4 Total Executions

This metric displays the total number of concurrent program executions.

Target Version Collection Frequency
All Versions Every 1 Day

8.12.5 User Concurrent Program Name

This metric displays the user-friendly name of the concurrent program.

Target Version Collection Frequency
All Versions Every 1 Day

8.13 Programs by Errored Executions

This metric category provides information about errored executions.

Data Source

FND_CONCURRENT_PROGRAMS table.

8.13.1 Concurrent Program Name

This metric displays the internal name of the concurrent program.

Target Version Collection Frequency
All Versions Every 1 Day

8.13.2 Executions Errored (%)

This metric displays the percentage of errored executions.

Target Version Collection Frequency
All Versions Every 1 Day

8.13.3 Total Executions

This metric displays the total number of executions.

Target Version Collection Frequency
All Versions Every 1 Day

8.13.4 Total Executions (Errored)

This metric displays the total number of errored executions.

Target Version Collection Frequency Default Warning Threshold Default Critical Threshold Alert Text
All Versions Every 1 Day Not Defined Not Defined %value%

User Action

You can set the threshold for this metric to generate alerts. Check for concurrent processing failures in Oracle E-Business Suite.

8.13.5 User Concurrent Program Name

This metric displays the user-friendly name of the concurrent program.

Target Version Collection Frequency
All Versions Every 1 Day

8.14 Programs by Executions

This metric category provides information about concurrent program executions.

8.14.1 Concurrent Program Name

This metric displays the internal name of the concurrent program.

Target Version Collection Frequency
All Versions Every 1 Day

8.14.2 Errored Executions (%)

This metric displays the percentage of errored executions.

Target Version Collection Frequency Default Warning Threshold Default Critical Threshold Alert Text
All Versions Every 1 Day Not Defined Not Defined %value%

8.14.3 Successful Executions (%)

This metric displays the percentage of successful executions.

Target Version Collection Frequency
All Versions Every 1 Day

8.14.4 Total Executions

This metric displays the total number of executions.

Target Version Collection Frequency
All Versions Every 1 Day

8.14.5 User Concurrent Program Name

This metric displays the user-friendly name of the concurrent program.

Target Version Collection Frequency
All Versions Every 1 Day

8.15 Programs by Total Running Time

This metric category provides information about concurrent program by total running time.

8.15.1 Concurrent Program Name

This metric displays the internal name of the concurrent program.

Target Version Collection Frequency
All Versions Every 1 Day

8.15.2 Successful Executions (%)

This metric displays the percentage of successful executions.

Target Version Collection Frequency
All Versions Every 1 Day

8.15.3 Total Executions

This metric displays the total number of executions.

Target Version Collection Frequency
All Versions Every 1 Day

User Action

This metric returns up to 10 programs that are exceeding the threshold value of the top running time set by the user.

8.15.4 Total Running Time

Target Version Collection Frequency
All Versions Every 1 Day

This metric displays the total running time.

8.15.5 User Concurrent Program Name

This metric displays the user-friendly name of the concurrent program.

Target Version Collection Frequency
All Versions Every 1 Day

8.16 Response

This metric category provides information about the status of the target.

8.16.1 Status

This metric displays the status of the selected target, that is whether the target is up and running.

Target Version Collection Frequency
All Versions Event-driven

8.17 Top Pending Requests

This metric category shows the top pending requests and users can get alerts by setting thresholds for the pending time.

8.17.1 Manager Name

This metric displays the concurrent manager name.

Target Version Collection Frequency
All Versions Every 1 Day

8.17.2 Pending Time

This metric returns up to a number of 10 programs that are exceeding the pending time threshold.

Target Version Collection Frequency Default Warning Threshold Default Critical Threshold Alert Text
All Versions Every 1 Day Not Defined Not Defined %value%

8.17.3 Phase

This metric displays the request phase.

Target Version Collection Frequency
All Versions Every 1 Day

8.17.4 Program Name

This metric displays the name of the program associated with the request.

Target Version Collection Frequency
All Versions Every 1 Day

8.17.5 Program Short Name

This metric displays the short name of the program associated with the request.

Target Version Collection Frequency
All Versions Every 1 Day

8.17.6 Request ID

This metric displays the ID associated with the request.

Target Version Collection Frequency
All Versions Every 1 Day

8.17.7 Request Start Date

This metric displays the start date of the request.

Target Version Collection Frequency
All Versions Every 1 Day

8.17.8 Status

This metric displays the status of the program.

Target Version Collection Frequency
All Versions Every 1 Day

8.17.9 User Name

This metric displays the user name associated with the program.

Target Version Collection Frequency
All Versions Every 1 Day

8.18 Top Running Requests

This metric category shows the top running requests.

8.18.1 Manager Name

This metric displays the concurrent manager name.

Target Version Collection Frequency
All Versions Every 1 Day

8.18.2 Phase

This metric displays the request phase.

Target Version Collection Frequency
All Versions Every 1 Day

8.18.3 Program Name

This metric displays the name of the program associated with the request.

Target Version Collection Frequency
All Versions Every 1 Day

8.18.4 Program Short Name

This metric displays the short name of the program associated with the request.

Target Version Collection Frequency
All Versions Every 1 Day

8.18.5 Request ID

This metric displays the ID associated with the request.

Target Version Collection Frequency
All Versions Every 1 Day

8.18.6 Request Start Date

This metric displays the start date of the request.

Target Version Collection Frequency
All Versions Every 1 Day

8.18.7 Running Time

This metric displays the running time of the program.

Target Version Collection Frequency Default Warning Threshold Default Critical Threshold Alert Text
All Versions Every 1 Day 0 Not Defined %value%

8.18.8 Status

This metric displays the status of the program.

Target Version Collection Frequency
All Versions Every 1 Day

8.18.9 User Name

This metric displays the user name associated with the program.

Target Version Collection Frequency
All Versions Every 1 Day

8.19 Top Scheduled Requests

This metric category provides information about the top scheduled requests.

8.19.1 Manager Name

This metric displays the concurrent manager name.

Target Version Collection Frequency
All Versions Every 1 Day

8.19.2 Phase

This metric displays the request phase.

Target Version Collection Frequency
All Versions Every 1 Day

8.19.3 Program Name

This metric displays the name of the program associated with the request.

Target Version Collection Frequency
All Versions Every 1 Day

8.19.4 Program Short Name

This metric displays the short name of the program associated with the request.

Target Version Collection Frequency
All Versions Every 1 Day

8.19.5 Request ID

This metric displays the ID associated with the request.

Target Version Collection Frequency
All Versions Every 1 Day

8.19.6 Request Start Date

This metric displays the start date of the request.

Target Version Collection Frequency
All Versions Every 1 Day

8.19.7 Scheduled to Run in (Minutes)

This metric displays the number of minutes in which the program is scheduled to run.

Target Version Collection Frequency
All Versions Every 1 Day

8.19.8 Status

This metric displays the status of the program.

Target Version Collection Frequency
All Versions Every 1 Day

8.19.9 User Name

This metric displays the user name associated with the program.

Target Version Collection Frequency
All Versions Every 1 Day

8.20 Top Users (Requests Submitted)

This metric category provides information about monitoring top users who are submitting or running more concurrent requests.

8.20.1 Number of Requests

This metric displays the number of concurrent requests submitted. If users exceed the number of requests submitted, then an alert is sent out.

Target Version Collection Frequency Default Warning Threshold Default Critical Threshold
All Versions Every 1 Day Not Defined Not Defined

8.20.2 User Name

This metric displays the user name associated with the concurrent requests.

Target Version Collection Frequency
All Versions Every 1 Day

8.21 Users by Pending Requests

This metric category provides information about monitoring top users by pending requests.

8.21.1 Number of Pending Requests

This metric displays the number of concurrent requests pending.

Target Version Collection Frequency Default Warning Threshold Default Critical Threshold
All Versions Every 1 Day Not Defined Not Defined

8.21.2 User Name

This metric displays the user name associated with the pending requests.

Target Version Collection Frequency
All Versions Every 1 Day

8.22 Users by Running Requests

This metric category provides information about monitoring top users by running requests.

8.22.1 Number of Running Requests

This metric displays the number of concurrent requests running.

Target Version Collection Frequency Default Warning Threshold Default Critical Threshold Alert Text
All Versions Every 1 Day Not Defined Not Defined %value%

8.22.2 User Name

This metric displays the user name associated with the running requests.

Target Version Collection Frequency
All Versions Every 1 Day

8.23 Web Users

This metric category provides information about the number of web users.

8.23.1 Number of Web Users (Hourly)

This metric displays the number of web users each hour.

Target Version Collection Frequency Default Warning Threshold Default Critical Threshold Alert Text
All Versions Every 1 Hour Not Defined Not Defined Number of Web Users last hour is %value%

8.24 Workflow Agent Activity

The Agent Activity shows the distribution of event messages with different statuses.

8.24.1 Errored Business Event System Messages

This metric displays the number of errored business event system messages.

Target Version Collection Frequency Default Warning Threshold Default Critical Threshold Alert Text
All Versions Every 15 Minutes Not Defined Not Defined %value% Errored Business Event System Messages

User Action

No generic action. Contact the Oracle E-Business Suite Administrator or Oracle Support.

8.24.2 Expired Business Event System Messages

This metric displays the number of expired business event system messages.

Target Version Collection Frequency Default Warning Threshold Default Critical Threshold Alert Text
All Versions Every 15 Minutes Not Defined Not Defined %value% Expired Business Event System Messages

User Action

Check the agent listeners and the database alert log.

8.24.3 Processed Business Event System Messages

This metric displays the number of processed business event system messages.

Target Version Collection Frequency Default Warning Threshold Default Critical Threshold Alert Text
All Versions Every 15 Minutes Not Defined Not Defined %value% Processed Business Event System Messages

User Action

Check if the agent listeners are up and running.

8.24.4 Ready Business Event System Messages

This metric displays the number of ready business event system messages.

Target Version Collection Frequency Default Warning Threshold Default Critical Threshold Alert Text
All Versions Every 15 Minutes Not Defined Not Defined %value% Ready Business Event System Messages

User Action

If the number of messages is large, then check whether the workflow agents are running and check that the workflow container services from Oracle E-Business Suite are up.

8.24.5 Undeliverable Business Event System Messages

This metric displays the number of undeliverable business event system messages.

Target Version Collection Frequency Default Warning Threshold Default Critical Threshold Alert Text
All Versions Every 15 Minutes Not Defined Not Defined %value% Un-deliverable Business Event System Messages

User Action

No generic action. Contact the Oracle E-Business Suite Administrator or Oracle Support.

8.24.6 Waiting Business Event System Messages

This metric displays the number of waiting business event system messages.

Target Version Collection Frequency Default Warning Threshold Default Critical Threshold
All Versions Every 15 Minutes Not Defined Not Defined

User Action

No action.

8.25 Workflow Notifications

This metric category provides information about workflow notifications.

8.25.1 Errored Workflow Notifications

This metric displays the workflow e-mail notification status by computing the number of errored and unsent workflow notifications.

Target Version Collection Frequency Default Warning Threshold Default Critical Threshold Alert Text
All Versions Every 1 Hour Not Defined Not Defined %value% errored Workflow Notifications

Data Source

This data is obtained from the WF_NOTIFICATIONS table.

User Action

Check if the e-mail address of recipient is correct and check that the SMTP server can relay e-mails to recipient's e-mail domain.

8.25.2 Unsent Workflow Notifications

This metric displays the number of unsent workflow notifications.

Target Version Collection Frequency Default Warning Threshold Default Critical Threshold Alert Text
All Versions Every 1 Hour Not Defined Not Defined %value% unsent Workflow Notifications

User Action

Check if the mailer is up and running and that the outbound thread count is greater than or equal to 1.