Monitoring Oracle E-Business Suite

This chapter covers the following topics:

Navigation and Overview

Once discovered, an Oracle E-Business Suite instance will appear in the Oracle E-Business Suite Instances section on the Oracle E-Business Suite Management page. Click on the name of the instance to go to the home page of that instance.

Oracle E-Business Suite System

Oracle E-Business Suite is discovered as a system. The members of the system include all nodes and targets that run on each node. To see the members, click on the instance target menu (labeled "Oracle E-Business Suite") and select Members > Show All.

Topology of the Oracle E-Business Suite System

The Configuration Topology Viewer provides a visual layout of the Oracle E-Business Suite system with its child targets. To access the Configuration Topology Viewer, select Members > Topology from the Oracle E-Business Suite instance target menu.

Upon service failure, the potential causes of failure as identified by root cause analysis, are highlighted in the topology view. You can view dependent relationships between services and systems from the Topology tab.

Using the topology view, you can:

Metrics

Once discovered, metrics are collected for an Oracle E-Business Suite system as well as its individual members. To see the metrics collected for any target, select Monitoring > All Metrics from the Oracle E-Business Suite instance target menu.

For more information on metrics, see: Oracle Application Management Pack for Oracle E-Business Suite Metric Reference Manual.

Setting Thresholds for Metrics

Metrics collected can be compared to predefined values to check if they are exceeding a critical threshold or a warning threshold. Incidents are generated once the threshold is exceeded. To see the thresholds defined for metrics of any target, select Monitoring > Metric and Collection Settings from the instance target menu. Here you can set the Critical/Warning thresholds used to generate incidents. You can also change the collection schedule of the metrics here.

For more information on incidents, see: Incidents for an Oracle E-Business Suite Target.

Home Page of an Oracle E-Business Suite System Instance

The home page of an Oracle E-Business Suite instance provides you with the following regions: Overview, Services, Targets Running on Nodes, Incidents and Problems, Oracle E-Business Suite Patch Recommendation, and Compliance Summary. Information about each region is provided below and in more detail in the remainder of this chapter.

the picture is described in the document text

Overview Region

The Overview region provides general information and statuses of the Oracle E-Business Suite instance.

General Section

Details about the Oracle E-Business Suite instance in the General section are shown in the following table:

General Section UI Descriptions
Field Description
Configured Components The count of member targets that fall into the status categories of Up, Down, or Other. You can drill down on a status category to view the targets that currently fall into that category.
System Name The name of the Oracle E-Business Suite instance.
Version The version of the Oracle E-Business Suite instance.
Products Licensed The number of products licensed on the Oracle E-Business Suite system.
New Internal System Alerts The number of new System Alerts generated in the Oracle E-Business Suite instance. Note that these System Alerts originate from the alerting infrastructure of Oracle E-Business Suite. These are complementary to the Oracle Enterprise Manager incidents.
Patches Applied The number of patches applied to the system in the last 24 hours.
Site Level Profile Options The number of site level profile options that have changed on the system in the last 24 hours.
Context Files Edited The number of AutoConfig context files that was changed on the system in the last 24 hours.
Monitoring Host The host of the agent which is monitoring the Oracle E-Business Suite system. This will be the host where the database is running.

Note: The New Internal System Alerts, Patches Applied, Site Level Profile Options Changed, and Context Files Edited metrics are based on information periodically summarized in the Oracle E-Business Suite database by the Oracle Applications Manager Dashboard Collection concurrent program. This program is controlled through the Preferences global link in Oracle Applications Manager. If this program has been disabled in the Oracle E-Business Suite system for any reason, then these metrics will not be updated.

Availability Status Charts

This portion of the Overview region is made up of three charts which depict the following:

Services Region

Oracle E-Business Suite and its member targets provide four major services to its customers. They are:

All these services are registered with Cloud Control once the successful discovery of the Oracle E-Business Suite target is completed. The Services section on the home page of the Oracle E-Business Suite instance has the details of services.

the picture is described in the document text

Each service has a set of critical components without which the service cannot be provided. The following table lists the critical component of each service.

Critical Components of Services
Service Critical components
Concurrent Processing

  • Internal Concurrent Manager

  • Concurrent Manager

  • Database

  • Apps Listener
Workflow Service

  • Concurrent Processing Service

  • Oracle Workflow Background Engine

  • Oracle Workflow Agent Listener

  • Oracle Workflow Notification Mailer
Forms Applications Service

  • Forms server (OC4J/WLS)

  • HTTP Server

  • Database
Self-Service Applications Service

  • OACORE Server (OC4J/WLS)

  • HTTP Server

  • Database

More information on services is provided later in this chapter.

Targets Running on Nodes

This section shows the targets running on each node in which the Oracle E-Business Suite is deployed. The data is shown in a hierarchical way with the host as the topmost parent. The nodes running on that host appear as the immediate children. The individual targets running on each node will appear as the child of each node. If the Oracle E-Business Suite instance features Online Patching, only run edition targets will be shown.

the picture is described in the document text

Tip: Click Detach to view the table on a separate page. This feature is useful if your table has more rows than can be shown in the default display.

Incidents and Problems for an Oracle E-Business Suite Target

Incidents and problems will be raised if any member of the Oracle E-Business Suite system is down or if any metric has exceeded its threshold. The Incidents and Problems region on the Oracle E-Business Suite instance home page gives an overview of the incidents raised for that instance. You can get the number of incidents grouped by severity. In addition, you can filter incidents based on the type of incident, such as availability, performance, security, and so on. You can drill down to the details of each issue by clicking on the Summary column which takes you to the Incident Manager. The Incident Manager page is where you can view more details of the event. You can track and manage the incident from here as well.

Embedded RUEI Region on the Oracle E-Business Suite Summary Page

Real User Experience Insight, or RUEI, is a powerful, web-based utility used to report on real-user traffic requested by and generated from your network. RUEI regions can now be embedded within the Oracle E-Business Suite Summary page.

The following RUEI regions are embedded in the Summary page:

The Key Performance Indicators region is shown by default. You can activate other regions using personalization features.

For more details and information on how to configure RUEI with Oracle E-Business Suite, refer to the Oracle Real User Experience Insight Installation Guide.

Patch Recommendations for Oracle E-Business Suite and Technology Stack

Oracle E-Business Suite customers must ensure Oracle recommended patches are applied to their Oracle E-Business Suite environments. These recommended patches are made available through My Oracle Support.

Patch Recommendations are provided for Oracle E-Business Suite and Technology Stack. Patches are recommended for three different components:

The Patch Recommendation functionality works as follows:

Oracle Application Management Pack for Oracle E-Business Suite Release 13.1 includes 2 major enhancements:

Oracle recommends that customers enable My Oracle Support to use the Patch Recommendations functionality. However, for those customers who have security restrictions and do not prefer to enable My Oracle Support, see the section Settings in Oracle E-Business Suite for an alternate option.

If you are enabling a My Oracle Support connection, follow the instructions in the section Settings to Enable Patch Recommendations.

Settings to Enable Patch Recommendations

The following settings must be set in order to enable the Patch Recommendation feature:

Required Privileges

The user must have the following privileges on the respective target to utilize Patch Recommendation functionality.

To View Patch Recommendations

The user must have:

To Create or Apply an Oracle Enterprise Manager Patch Plan

In addition to the above "view patch" privileges, to create or apply an Oracle Enterprise Manager patch plan the user should also have the following privileges:

Settings in the OMS

Settings in Oracle E-Business Suite

The following settings should be set in the Patch Manager section of the Preferences page:

Oracle E-Business Suite & Technology Stack Patch Recommendation Region

By default, you can find the Oracle E-Business Suite & Technology Stack Patch Recommendations region on the Oracle E-Business Suite instance target home page.

The bar graph in this region shows a summary of recommended patches to be applied on the specific Oracle E-Business Suite instance. Hover over each bar to see the number of recommended patches for a particular product. Click on any bar in the bar graph to drill down to the next section which provides details on the individual patches for each technology component of the Oracle E-Business Suite Technology stack.

the picture is described in the document text

Note: For Release 12.1 instances, the name of this region is "Oracle E-Business Suite Patch Recommendation."

Descriptions of the elements in this region are as follows:

Note: Oracle E-Business Suite Application Patch Recommendations are available for Release 12.1.3 and later.

Oracle E-Business Suite Technology Stack Patch Recommendations including Database and Application Tier Patch Recommendations are available only for Oracle E-Business Suite Release 12.2 or later.

Patch Recommendation Details

As mentioned previously, clicking on any bar in the graph in the Oracle E-Business Suite & Technology Stack Patch Recommendation region shows you the details of the patches to be applied on Oracle E-Business Suite and each technology component of the Oracle E-Business Suite Technology stack.

Oracle E-Business Suite Application Patch Recommendations

The E-Business Suite tab drills down into the Oracle E-Business Suite recommended patch details.

the picture is described in the document text

Elements in this region are as follows:

Oracle E-Business Suite Application Tier Technology Patch Recommendations

Note: This section is relevant for Oracle E-Business Suite Release 12.2 and later.

The Application Tier Technology tab includes sub-tabs detailing the recommended patches for the following Oracle E-Business Suite application tier technology components:

the picture is described in the document text

the picture is described in the document text

the picture is described in the document text

the picture is described in the document text

Elements in these regions are as follows:

Under the Oracle WebLogic Server sub-tab, you can find the following additional elements:

Note: Oracle Database and Oracle Application Tier Technology patches may be listed, despite already being applied. This may be due to the fact that some patches have bug fixes spawning to other patches. Apply all patches, in sequence, as listed in the table and then click the Refresh link to recollect the applied patch metrics from the target to view the correct patch recommendations.

Note: For Oracle WebLogic Server, it is highly recommended to apply patches on the patch file system. Applying a patch on the run file system returns a warning message recommending that you apply the patch on the patch file system.

Patches Recommended for Oracle Database

Note: This section is relevant for Oracle E-Business Suite Release 12.2 and later.

The Database tab displays Oracle E-Business Suite database patch recommendation details. In the case of RAC instances, it displays patch recommendations for all nodes of the database.

the picture is described in the document text

Elements in this region are as follows:

When applying Oracle Database patches from Oracle Enterprise Manager, you should be aware of the different modes of patching available.

Note: Currently, the Patch Recommendation feature for Oracle Database is not available for in-memory databases.

There are two modes of patching which Oracle Enterprise Manager supports for database patching: "In Place" and "Out of Place".

For Oracle E-Business Suite, the Out of Place patching mode does not work as the database home of Oracle E-Business Suite is customized and is not the same as an Oracle Database home. If patches are applied in this mode, the patch deployment will fail. Therefore, the In Place patching mode should be used while patching Oracle E-Business Suite database from Oracle Enterprise Manager.

For more details on applying database patches from Oracle Enterprise Manager, see the Oracle Enterprise Manager Lifecycle Management Administrator's Guide.

EM CLI Verbs for Listing Recommended Database Patches

To list all the patches which are recommended for Oracle Database, use the following command after logging in to EM CLI:

emcli ebs_patch_list -component="database" -target_name="Oracle E-Business Suite target name"

An example run of the command and output is as follows:

emcli ebs_patch_list  -component="database"  -target_name="orcl_Oracle E-Business Suite"
#Target Name,Host,Instance,Patch Number,Patch Version
orcl_Oracle E-Business Suite,***.***.***.***,orcl,20887355,12.1.0.2.0
orcl_Oracle E-Business Suite,***.***.***.***,orcl,21153266,12.1.0.2.0
orcl_Oracle E-Business Suite,***.***.***.***,orcl,22223463,12.1.0.2.0
orcl_Oracle E-Business Suite,***.***.***.***,orcl,19908836,12.1.0.2.0
orcl_Oracle E-Business Suite,***.***.***.***,orcl,21321429,12.1.0.2.0
orcl_Oracle E-Business Suite,***.***.***.***,orcl,21841318,12.1.0.2.0
orcl_Oracle E-Business Suite,***.***.***.***,orcl,21864513,12.1.0.2.0
orcl_Oracle E-Business Suite,***.***.***.***,orcl,21904072,12.1.0.2.0
orcl_Oracle E-Business Suite,***.***.***.***,orcl,21967332,12.1.0.2.0
orcl_Oracle E-Business Suite,***.***.***.***,orcl,22098146,12.1.0.2.0
orcl_Oracle E-Business Suite,***.***.***.***,orcl,22496904,12.1.0.2.0

EM CLI Verbs for Applying Recommended Patches

To apply Oracle E-Business Suite recommended patches to Oracle Database, use the following command after logging in to EM CLI:

emcli patch_ebs_db -ebs_db_patch_file="<fully qualified path of properties file>"

The input properties file is described in the verb itself which can be shown by using the following command:

emcli help patch_ebs_db

An example run of the command and output is as follows:

emcli patch_ebs_db -ebs_db_patch_file=/tmp/patch.properties

the picture is described in the document text

Note: Patching Oracle Database with the emcli verb 'patch_ebs_db' requires preferred credentials for the Oracle home target associated with the Oracle Database target to be set.

Compliance Standards for Oracle E-Business Suite

Compliance evaluation generates a score for a target which indicates how much the target is compliant with the standard. Violation of a standard can be classified as Critical, Warning or Minor Warning.

The management pack includes a set of compliance standards for Oracle E-Business Suite security which will be associated to every Oracle E-Business Suite instance once it is discovered. Evaluation will happen periodically, which will ensure that the Oracle E-Business Suite is configured in a secure way.

The following table lists details of the compliance standards shipped along with the compliance rules associated with them.

Compliance Standards
Compliance Standard Rules Mapped to the Standard Severity
Checks for profile validations in Oracle E-Business Suite Checks for profile errors in Oracle E-Business Suite Critical
Checks for profile validations in Oracle E-Business Suite Checks for profile warnings in Oracle E-Business Suite Warning
Checks for profile validations in Oracle E-Business Suite Checks for profiles, missing in Oracle E-Business Suite Critical
Compliance for Oracle E-Business Suite 11gR2 Database Checks for default Database password users in Oracle E-Business Suite Critical
Compliance for Oracle E-Business Suite 11gR2 Database Checks the Database will be completely compatible with the software version 11gR2 Critical
Compliance for Oracle E-Business Suite 11gR2 Database Checks if parallel execution and Oracle RAC parameter set to recommended value for Oracle E-Business Suite Critical
Compliance for Oracle E-Business Suite 12cR1 Checks if parallel execution and Oracle RAC parameter set to recommended value for Oracle E-Business Suite Critical
Compliance for Oracle E-Business Suite 12cR1 Checks the Database will be completely compatible with the software version 12cR1 Critical
Compliance for Oracle E-Business Suite 12cR1 Checks if optimizer parameters used to turn off automatic statistics is set for Oracle E-Business Suite Critical
Compliance for Oracle E-Business Suite 12cR1 Checks for default Database password users in Oracle E-Business Suite Critical
Checks for default APPL password users in Oracle E-Business Suite Checks for default application password users in Oracle E-Business Suite Critical
APPLSYSPUB unnecessary privileges check for Oracle E-Business Suite APPLSYSPUB unnecessary privileges check for Oracle E-Business Suite Warning
Server security check for Oracle E-Business Suite Server security check for Oracle E-Business Suite Warning
Checks for hashed passwords in Oracle E-Business Suite Checks for hashed passwords in Oracle E-Business Suite Warning
Checks if SSL (HTTPS) is enabled in Oracle E-Business Suite Check if SSL (HTTPS) is enabled in Oracle E-Business Suite Warning
Checks for mod security in Oracle E-Business Suite Checks for mod security in Oracle E-Business Suite Warning
Credit card encryption check in Oracle E-Business Suite Credit card encryption check in Oracle E-Business Suite Warning
Credit card encryption check in Oracle E-Business Suite Supplement credit card encryption check in Oracle E-Business Suite Warning
Credit card encryption check in Oracle E-Business Suite Enhanced hashing in Oracle E-Business Suite Warning
Compliance for Oracle E-Business Suite Database Configuration Standards Checks if the parameter work area size policy is set to the default recommendation Critical
Compliance for Oracle E-Business Suite Database Configuration Standards Checks if the use of bitmap plans optimizer parameter is set to the default recommendation Critical
Compliance for Oracle E-Business Suite Database Configuration Standards Checks if NLS date default format is set for Oracle E-Business Suite Critical
Compliance for Oracle E-Business Suite Database Configuration Standards Checks if block size for Oracle E-Business Suite is 8K Critical
Compliance for Oracle E-Business Suite Database Configuration Standards Checks if the create columns semantics is using byte by default for Oracle E-Business Suite Critical
Compliance for Oracle E-Business Suite Database Configuration Standards Checks if the total size of the SGA is configured set to the default recommendation for Oracle E-Business Suite Critical
Compliance for Oracle E-Business Suite Database Configuration Standards Checks if version 7 dictionary accessibility support for Oracle E-Business Suite is set to False Critical
Compliance for Oracle E-Business Suite Database Configuration Standards Checks if the Cost Based Optimizer is set to FALSE for Oracle E-Business Suite Critical
Compliance for Oracle E-Business Suite Database Configuration Standards Checks if the treat LIKE predicate with bind as an equality predicate optimizer parameter is set to suggested value Critical
Compliance for Oracle E-Business Suite Database Configuration Standards Checks if the index fast full scan configuration set to the default recommendation Critical
Compliance for Oracle E-Business Suite Database Configuration Standards Checks for cursor sharing mode in Oracle E-Business Suite Critical
Compliance for Oracle E-Business Suite Database Configuration Standards Checks if the system management undo parameter is set for Oracle E-Business Suite Critical
Compliance for Oracle E-Business Suite Database Configuration Standards Checks if the cost ratio for sort elimination optimizer parameter is set to suggested value for Oracle E-Business Suite Critical
Compliance for Oracle E-Business Suite Database Configuration Standards Checks if optimizer parameters used to turn off automatic statistics is set for Oracle E-Business Suite Critical
Compliance for Oracle E-Business Suite Database Configuration Standards Checks if the database system triggers has been enabled for Oracle E-Business Suite Critical
Compliance for Oracle E-Business Suite Database Configuration Standards Checks if the Real Application Clusters parameter is set to TRUE startup in cluster Critical

The Compliance Standards region on the home page of the Oracle E-Business Suite instance provides details of the evaluations performed on that instance and how many violations there are. You can click on each standard to view further details of evaluations per rule. Each standard comes with a recommendation on how to fix the violations for that standard.

Note: Compliance standards will not be set for Oracle E-Business Suite instances discovered using the previous releases of the management pack. You must rediscover an instance to attach compliance standards to it.

Monitoring Online Patching to Detect Cutover

If the Oracle E-Business Suite target features online patching, false incidents will be raised for the patch edition targets being down or the whole Oracle E-Business Suite being down during cutover. To prevent this, the system keeps checking the patching activities to see if any cutover is in progress. Corrective actions are triggered once a cutover is detected. If there is any cutover in progress, the whole Oracle E-Business Suite target will be blacked out. This is true if the patching is done either from Patch Manager or Oracle E-Business Suite console. Once the cutover is complete (success or failure) the corrective actions will end the blackout of the Oracle E-Business Suite target and black out the correct patch edition.

Important Points to Note

Abandoned Nodes

During online patching, it is possible that a few nodes can get abandoned in the run edition. An incident will be raised if the system detects an abandoned node. An error message will be displayed on the home page of the corresponding Oracle E-Business Suite instance. You must either fix the node on the Oracle E-Business Suite side and perform a rediscovery or exclude the node using discovery customization and rediscover.

Monitoring Current Activity

Activity metrics are collected for the Oracle E-Business Suite target. These metrics provide details of current activities going on the Oracle E-Business Suite instance. Select Monitoring > All Metrics from the instance target menu. Expand the metric named Activity. You can see the trends for service processes, concurrent processing, and Forms.

the picture is described in the document text

Monitoring User Sessions

When a user logs in to Oracle E-Business Suite, the system creates sessions in the database identified by a unique session ID, or SID. All of these user sessions are created using the APPS schema credential. Each database session is associated with an Oracle E-Business Suite application user. This feature enables linking the database session with the corresponding application user for monitoring and troubleshooting purposes. You will be able to pinpoint how the Oracle E-Business Suite user opened a database session and whether it is with a concurrent processing, Forms, or Self-Service application.

For information on diagnostic tests for this feature, see: Diagnostic Tests for User Monitoring.

Mandatory Settings

The following settings are mandatory:

Settings on the OMS

Set the preferred credentials of the "Oracle E-Business Suite" target type for the credential set AppsUserCredsSet. You must provide the Oracle E-Business Suite user login credentials.

For information on setting preferred credentials, see: Set Preferred Credential for Oracle E-Business Suite Application Login.

Settings on the Oracle E-Business Suite Instance

Top Sessions

The Top Sessions page will show four bar charts of database sessions triggered by the APPS database user.

To navigate to the Top Sessions page, select User Monitoring > Top Sessions from the instance target menu.

the picture is described in the document text

The level of detail shown in the bar graphs is controlled by properties set on the Preferences page. See: Setting Preferences.

You can drill down from the legend to see the details of the session. If the Oracle E-Business Suite user information is available, the Oracle E-Business Suite session details is shown with further drilling down available to the database session details. If the Oracle E-Business Suite user information is not available (that is, the database sessions were triggered by a background process and not by a user), you can drill down to the database session details directly.

Searching for User Sessions

You can search for Oracle E-Business Suite user sessions using:

To navigate to user sessions search, select User Monitoring > Search E-Business Suite User from the instance target menu.

Impact of the July 2017 Critical Patch Update for Oracle E-Business Suite

A critical bug fix was applied to the REST services deployed on Oracle E-Business Suite which are invoked by the User Monitoring feature. This fix is available as part of the July 2017 Critical Patch Update (CPU) for Oracle E-Business Suite. There is an impact of this feature due to that fix. If you have applied the CPU, refer to the readme to understand the requirements to activate this feature.

For Oracle E-Business Suite Release 12.1.3 customers: If you have not applied the CPU, but have applied Bundle Patch 1 (BP 1) on top of Oracle Application Management Pack 13.1.1.1.0, you must apply the following Oracle E-Business Suite patches to utilize the User Monitoring feature:

Monitoring JVM Usage

You can monitor JVM usage parameters specific to Oracle E-Business Suite Release 12.1. You can review the following parameters for each of the oacore J2EE containers in which a given Oracle E-Business Suite instance is deployed.

Note: The feature allowing you to monitor JVM usage is only available for Oracle E-Business Suite Release 12.1. Users wanting to monitor Oracle E-Business Suite Release 12.2 and later should consider using the Oracle WebLogic Server Management Pack Enterprise Edition, which provides JVM monitoring and JVMD.

Setup Steps

For Release 12 systems, ensure that you have set up the monitoring configuration for each "oacore" OC4J target as follows:

  1. In the Targets Running on Nodes section in the Oracle E-Business Suite instance home page, click on the "oacore" OC4J target. This will take you to the home page of the target.

  2. On the home page of the oacore OC4J target, select Target Setup > Monitoring Configuration in the instance target menu.

  3. Enter the OC4J administrator username and password for the "oacore" OC4J in the "Username for Basic authorization" and the "Password for Basic authorization" fields, respectively.

    Note: The OC4J administrator username by default is "oc4jadmin" and is specified in the system-jazn-data.xml file under the $INST_TOP/ora/10.1.3/j2ee/oacore/config directory. The oc4jadmin password by default is set to a randomized value during installation and will need to be reset as in the following example:

    In the $INST_TOP/ora/10.1.3/j2ee/oacore/config/system-jazn-data.xml file, set the value of the "credentials" element for oc4jadmin user to your chosen password preceded by a ! character. For example:

    <user>
<name>oc4jadmin</name>
<display-name>OC4J Administrator</display-name>
<description>OC4J Administrator</description>
<credentials>![new password]</credentials>
</user>

    After saving system-jazn-data.xml, restart the oacore OC4J. This step encrypts the updated password in system-jazn-data.xml.

  4. Click OK to save the information.

Ensure that the Application Server passwords are also set for Oracle E-Business Suite Release 12, as Oracle Enterprise Manager expects these passwords to be set for metrics collection for the JVM targets.

Command to Enable the Metric Collection

./emcli modify_collection_schedule -force
-targetType="oracle_apps_jvm"
-targetNames="<targetName1>,<targetName2>"
-collectionName="LockedAOLJConn"
-collectionStatus="Enabled" -preview=N -freqType="Minute"
-freqValue="1"
./emcli modify_collection_schedule -force
-targetType="oracle_apps_jvm"
-targetNames="<targetName1>,<targetName2>"
-collectionName="AMPoolCount"
-collectionStatus="Enabled" -preview=N -freqType="Minute"
-freqValue="1"
./emcli modify_collection_schedule -force
-targetType="oracle_apps_jvm"
-targetNames="<targetName1>,<targetName2>"
-collectionName="CachedObjects"
-collectionStatus="Enabled" -preview=N -freqType="Minute"
-freqValue="1"

Command to Disable the Metric Collection

emcli modify_collection_schedule
-targetType="oracle_apps_jvm"
-targetNames="<targetName1>,<targetName2>"
-collectionName="LockedAOLJConn"
-collectionStatus="Disabled" -preview=N emcli modify_collection_schedule
-targetType="oracle_apps_jvm"
-targetNames="<targetName1>,<targetName2>"
-collectionName="AMPoolCount"
-collectionStatus="Disabled" -preview=N emcli modify_collection_schedule
-targetType="oracle_apps_jvm"
-targetNames="<targetName1>,<targetName2>"
-collectionName="CachedObjects"
-collectionStatus="Disabled" -preview=N

To find out the oracle_apps_jvm target names associated with an Oracle E-Business Suite instance, go to the All Targets page and search for <ebs_instance_name>%oacore_jvm_1_apps.

Note: It is important to set the oc4j admin username and password at the EBS as per the mandatory setups mentioned above. If you enable this metric without doing that, it can result in the flooding of metric collection errors at the OMS repository.

Monitoring Templates for Oracle E-Business Suite

Monitoring templates let you standardize monitoring settings across your Oracle E-Business Suite environments by allowing you to specify the monitoring settings once and apply those to your monitored targets. You can save, edit, and apply these templates across one or more targets. A monitoring template is specified for a particular target type and can only be applied to targets of the same type. For example, you can define one monitoring template for Oracle E-Business Suite test instances and another monitoring template for Oracle E-Business Suite production instances. For more descriptions of Oracle Certified Templates and Oracle Provided Templates please see the latest Oracle Enterprise Manager Cloud Control Administrator's Guide.

Note: Currently, Oracle delivered templates may not have many out-of-box metric values. However, you can set these metric values by observing the trend in your own environment over a period of time. You can view some of the trend information by examining Average value, Low value, and High value statistics for each metric that you are monitoring using the template.

Managing Out-of-Box Monitoring Templates for Targets for Oracle E-Business Suite

Navigate to monitoring templates using the path Enterprise menu > Monitoring > Monitoring Templates.

Users must have the required privilege(s) to manage monitoring templates. The privilege(s) for the view/edit/create like/delete functions for managing out-of-box monitoring templates for the management pack are the same as that for all out-of-box monitoring templates. See: Oracle Enterprise Manager Cloud Control Administrator's Guide for more information.

the picture is described in the document text

Viewing Out-of-Box Monitoring Templates

To view out-of-box monitoring templates, select the “Display Oracle Certified Templates” check box and search for templates. All Oracle-certified templates are displayed.

Default Listing of the Monitoring Templates

Out-of-box monitoring templates are called 'Oracle Certified Templates.' By default, the Oracle Certified Templates are not displayed.

Find Out-of-Box Monitoring Templates for Oracle Application Management Pack for Oracle E-Business Suite

Search for out-of-box monitoring templates for management pack targets by selecting the "Display Oracle Certified Templates" check box and selecting the Target Type in the drop-down list. Alternatively, you can simply search for the target name.

Currently, out-of-box monitoring templates are supported for the following targets:

the picture is described in the document text

Editing Out-of-Box Monitoring Templates

Editing an out-of-box monitoring template is not permitted in all Enterprise Manager versions. Please check Oracle Enterprise Manager Cloud Control Administrator's Guide for more information.

In addition, the Edit option is enabled only if the user has the required privilege to edit a monitoring template through Enterprise Manager. Management pack templates follow the same restrictions as all out-of-box monitoring templates.

The Monitoring Templates home page lists all viewable templates. To display out-of-box templates, search using the criterion 'Oracle Certified Templates'.

To edit a template:

  1. From the Enterprise menu, select Monitoring, and then Monitoring Templates.

  2. Choose the desired out-of-box monitoring template from the table.

  3. Click Edit.

  4. Once you have finished making changes, click OK.

Copying an Out-of-Box Monitoring Template

To create a template based on an existing template, select the template, go to Actions, and select Create Like.

the picture is described in the document text

Enter the inputs for 'General', 'Metric Thresholds', and 'Other Collected Items' and click OK.

the picture is described in the document text

Deleting an Out-of-Box Monitoring Templates

Out-of-box monitoring templates cannot be deleted.

Applying a Monitoring Template to an Oracle E-Business Suite Target

An out-of-box monitoring template can be applied to a management pack target based on the target type. To apply a template, you must have at least Manage Target Metrics target privileges on the destination target(s).

  1. From the Enterprise menu, select Monitoring and then Monitoring Templates.

  2. Select the desired template from the table.

  3. Click Apply.

  4. Select the desired apply options and the target(s) to which you want the templates applied. See Oracle Enterprise Manager Cloud Control Administrator's Guide for more information.

  5. Click OK.

the picture is described in the document text

Other Features of Monitoring Templates

All other features of out-of-box monitoring templates such as 'Compare Settings' and 'View Past Apply Operations' are valid for out-of-box monitoring templates in the management pack.

Defining or Modifying the Threshold Values in the Out-of-Box Monitoring Templates

Currently, Oracle Application Management Pack for Oracle E-Business Suite supplies the out-of-box monitoring templates with default values. To define the threshold values in out-of-box monitoring templates, the following steps are involved:

  1. Observe the trend of the metrics for the targets.

  2. Determine the threshold values based on observation.

  3. Modify the threshold values by editing the template.

  4. Apply the modified template to the target.

To check the trend of the metrics for the target, on the target's home page target menu (labeled "Oracle Concurrent Manager"), navigate to Monitoring > All Metrics. Select any metric, and check 'Metric Value History'. Change the 'View Data' period based on the time of analysis.

the picture is described in the document text

Enabling Service Tests and Beacons Link

Administrators can define service tests for Oracle E-Business Suite services and can also define their own ATS transactions to determine the health of an application (for example, whether the application is rendering the correct pages and functional flows are intact). All Oracle E-Business Suite service targets support the Service Test Types of ATS and HTTPPING. For more information on service tests, service test types, beacons, and Oracle Application Test Suite (OATS), see the section "Configuring and Using Services" in the Oracle Enterprise Manager Cloud Control Administrator's Guide.

The following services have the 'Service Tests and Beacons' link enabled:

The basic steps to create such a test are as follows:

  1. Navigate to the Service target home page.

  2. Select the Service link.

  3. Click on the Monitoring Configurations tab.

  4. Select the Service Tests and Beacons link.

  5. Select 'Test Type' as 'ATS Transaction' and click Add.

  6. Enter an appropriate name.

  7. Click the Upload button and select the OATS script zip file.

  8. Add a Beacon to monitor the Service Test. The Enterprise Manager Management Beacon default is available.

  9. Enable the Service Test.

  10. Click OK.

For more detailed information, see the "Creating an ATS Service Test" section of the Oracle Enterprise Manager Cloud Control Administrator's Guide.

Seeded ATS Test Transaction for Self-Service Applications Service

A sample ATS test script is shipped out of the box for a login/logout test against Oracle E-Business Suite 12.1.x instances. This script will only work if the 12.1.x instance is not SSL configured. This ATS test transaction is configured during the discovery time of the 12.1.3 Oracle E-Business Suite instance against 'Self-Service Applications Service.' An end user needs to enable the ATS transaction and edit it with a correct Oracle E-Business Suite username and password.

  1. Click on the Monitoring Configuration tab from the Self-Service Applications Service home page.

    the picture is described in the document text

  2. Click on the "Service Tests and Beacons" link.

  3. The default ATS service test is disabled. First mark the default beacon, 'EM Management Beacon' as 'Key Beacon' in the Beacons region. Then click on the Enable button for the Service Test.

  4. Click on Edit.

  5. Enter the Oracle E-Business Suite applications username and password under Variables, Sensitive Values. Click OK.

  6. Again, click the OK button from the Service Tests and Beacons home page to ensure that the changes are saved.

  7. You can verify the service test as follows:

    Click the Verify Service Test button in the Service Tests region.

    Click the Perform Test button.

    Execution results are displayed in the results table.

  8. You need to mark this service as 'Key Service Test' so that it starts contributing to the availability.

    Select the Key Service Test check box and click the Change Key Tests button.

For more details see the chapter "Configuring and Using Services" in the Oracle Enterprise Manager Cloud Control Administrator's Guide.

Drilling Down to Oracle Applications Manager

You can drill down to the Oracle Application Manager of each Oracle E-Business Suite instance from Oracle E-Business Suite plug-in. Select Oracle Applications Manager from the instance target menu.

You can access the following sections and its subsections in Oracle Applications Manager:

Services

Performance of Services

The metrics collected from a service's critical components are used to evaluate the performance of each service. The following table lists the performance metrics for each service.

Performance Metrics for Services
Service Metric Description
Concurrent Processing Service Concurrent Requests Success Rate Successfully completed requests per hour
Concurrent Processing Service Concurrent Requests Error Rate Failed requests per hour
Forms Service Forms Response Time Average response time of forms in milliseconds
Forms Service Forms Requests per Second Average of number of requests processed by the Forms server per second
Forms Service HTTP Server Request Throughput Average of number of requests processed by the HTTP server per second
Workflow Service Pending Agent Listener Events Count of pending agent listener events
Workflow Service Pending Mailer Notification Events Count of pending mailer notification events
Workflow Service Pending Mailer Notifications Count of pending mailer notifications
Self-Service Applications Service OACore requests per second Average of number of requests processed by the oacore server per second
Self-Service Applications Service HTTP Server Request Throughput Average of number of requests processed by the HTTP server per second

Usage by Services

The metrics collected from a service's critical components are used to evaluate the resources used by each service. The following table lists the usage metrics for each service.

Usage Metrics for Services
Service Metric Description
Concurrent Processing Service Running Requests per Hour Number of requests running per hour
Concurrent Processing Service Active Service Processes Number of active services running per hour
Forms Service Forms server CPU usage Percentage of CPU used by the Forms server
Forms Service HTTP server CPU usage Percentage of CPU used by the HTTP server
Forms Service (Socket Mode) Total Memory Utilization Percentage of the total memory used by the Forms process
Forms Service (Socket Mode) Total CPU Utilization Percentage of CPU used by the Forms process
Forms Service (Socket Mode) Number of Forms Processes Total number of Forms processes that are running
Workflow Service Background Engine Deferred Items Number of items deferred by the background engine yet to be processed
Self-Service Applications Service OACore CPU usage Percentage of CPU used by the oacore server
Self-Service Applications Service HTTP server CPU usage Percentage of CPU used by the HTTP server

Charts for Services

To see charts based on the above performance and usage metrics, go to the home page of each service and click on the Charts tab.

Incidents for Services

You can set thresholds for tracking the performance and usage of services. Incidents are generated once the metrics exceed the threshold. To set the threshold, go to the home page of the service and click on the tab Monitoring Configuration. Click on the link "Performance Metrics" or "Usage Metrics". You can set the warning and critical threshold for performance and usage metrics on the respective pages.

The Services section on the Oracle E-Business Suite home page provides the details described in the following table:

Services Status Information on the Home Page
Column Description
System The Oracle E-Business Suite system whose members are providing the service.
Performance Incidents Number of performance incidents which are classified as Critical or Warning. You can drill down from here to get the details of the incidents by clicking on the number.
Usage Incidents Number of usage incidents which are classified as Critical or Warning. You can drill down from here to get the details of the incidents by clicking on the number.
Key Components Status The status of the key components. The service will be shown as "down" if any of the key components is down. You can drill down from here by clicking on the number.
Key Components Incidents Incidents (Critical and Warning) raised against key components of the service. You can drill down from here by clicking on the number.

Services Dashboard

Extending the service dashboard feature provided by Cloud Control, Oracle E-Business Suite also has a dashboard which provides a brief summary of all service-related information. You can access it by selecting Service Level Reports > Oracle Application Services from the instance target menu.

Concurrent Processing Dashboard

The Concurrent Processing Dashboard provides you with details in concurrent processing in your Oracle E-Business Suite system. The dashboard gives you a complete picture of concurrent processing on your system, both current activities as well as usage statistics.

To navigate to the Concurrent Processing Dashboard, select E-Business Suite Dashboard > CP Dashboard from the instance target menu.

Discovery of Concurrent Processing Targets

When you discover an Oracle E-Business Suite instance, the concurrent processing-related targets are discovered. This includes the Apps Listener, Internal Concurrent Manager, Output Post Processor, Internal Monitor, Service Manager, and Conflict Resolution Manager. The Oracle Application Management Pack for Oracle E-Business Suite supports the monitoring of parallel concurrent processing.

There is a provision to discover all concurrent managers during discovery of the Oracle E-Business Suite instance, although it is disabled by default. If needed, you can enable it by customizing the discovery. See the section Customization at the Instance Level in Customizing Discovery.

Note: Discovery of core managers and all concurrent managers are new features introduced in Release 12.1.0.4.0. This feature will not work if the agent is not at the same release level as the OMS.

Overview Tab

the picture is described in the document text

The Overview tab provides a summary of the concurrent processing infrastructure.

The General region includes details on the status of the concurrent processing service:

The Hourly Completed Requests region shows a pie chart for requests by status (Successful, Warning, and Errored).

The Activity Summary graph illustrates active requests in the following statuses:

The Components region lists components of the Concurrent Processing service. The table shows the following for each component:

The Incidents region lists any incidents that were triggered recently, with the following information for each:

Current Activity Tab

The Current Activity tab gives details of the concurrent processing that is taking place at any point in time.

the picture is described in the document text

The Concurrent Requests by Status region lists the number of requests for each status:

Click on the number for a status to find out more about the metric trend.

The Hourly Completed Requests region lists statistics for requests that have completed in the past hour, including:

Click on the number for each statistic to find out more details.

The Concurrent Managers by Requests lists all concurrent managers, in order of the number of requests it has in the specified status, either Running or Pending.

With "Running" selected, the following is shown for each concurrent manager:

With "Pending" selected, the following is shown for each concurrent manager:

The Top Concurrent Requests region shows the top ten (10) requests for the specified status of Running, Pending, or Scheduled.

The Top Applications region lists the top ten (10) applications for running requests or pending requests, as specified.

The Top Users region lists the top ten (10) users by number of running or pending requests, as specified.

Usage Tab

The Usage tab provides a summary of how the concurrent programs and managers have been utilized over a period of time.

the picture is described in the document text

The top ten (10) concurrent requests for the following categories are listed:

the picture is described in the document text

The top ten (10) applications for the following categories are listed:

The top ten (10) users by total number of requests are also listed, in descending order of number of requests.

User Defined Targets Tab

The User Defined Targets tab displays the details of the concurrent programs and managers being monitored. Use this tab to get information about the added concurrent programs and managers as well as to add more custom targets.

the picture is described in the document text

Adding a Concurrent Program Target

You can add a concurrent program custom target so that the system will collect metrics on activity and usage for the concurrent program.

  1. To add a concurrent program custom target, navigate to the Concurrent Processing Dashboard, select the User Defined Targets tab, and click Add CP under Concurrent Programs.

  2. For your new target, define the following:

    • Target Name Prefix - This value is determined by the system based on the instance name and cannot be updated.

    • Target Name - Enter in a target name "suffix". The actual target name will be composed of the Target Name Prefix (above) and the value of this field.

    • Target Type - The system automatically provides the value "Custom Oracle Concurrent Program".

    • Concurrent Program Short Name - Use the LOV icon to search for and select the program short name. In searching for the program name you can search by concurrent program short name, concurrent program name, or application.

    • Monitoring Host

    For the Basic Properties region, values for the following should default in. These values are used as credentials by the target for metrics collection:

    • SID

    • Machine

    • Port

    • (Database) User name

    • (Database) Password

    • ConnectString

    the picture is described in the document text

  3. When you are done, click Add to add the target.

Adding a Concurrent Manager Target

If you have decided not to discover all concurrent managers during discovery, you can add an individual concurrent manager custom target so that the system will collect metrics on activity and usage for requests run by the concurrent manager.

  1. To add a concurrent manager custom target, navigate from the Concurrent Processing Dashboard to the User Defined Targets tab and click Add CM under Concurrent Manager.

  2. For your new target, define the following:

    • Target Name Prefix - This value is determined by the system based on the instance name and cannot be updated.

    • Target Name - Enter in a target name "suffix". The actual target name will be composed of the Target Name Prefix (above) and the value of this field.

    • Target Type - The system automatically provides the value "Custom Oracle Concurrent Manager".

    • Concurrent Manager Short Name - Use the LOV icon to search for and select the concurrent manager short name. In searching for the manager name you can search by concurrent manager short name, concurrent manager name, or application.

    • Monitoring Host

    For the Basic Properties region, values for the following should default in. These values are used as credentials by the target for metrics collection:

    • SID

    • Machine

    • Port

    • (Database) User name

    • (Database) Password

    • ConnectString

    the picture is described in the document text

  3. When you are done, click Add to add the target.

Configuration of Concurrent Processing

To view the concurrent processing configuration, go to the Concurrent Processing Dashboard. From the "Oracle Concurrent Processing" target menu, select Configuration > Last Collected.

Configuration data collected includes:

Monitoring Concurrent Processing

Metrics are collected to monitor the concurrent processing. These metrics are collected at three levels:

To see metrics for all concurrent processing in your instance, choose Monitoring > All Metrics from the instance target menu in the Concurrent Processing Dashboard.

To see metrics for a concurrent manager or concurrent program, go the User Defined tab and click on the name of the target to go to its home page. From the target menu on the home page, choose Monitoring > All Metrics.

Monitoring Capacity Utilization of Concurrent Managers

Every concurrent manager has a maximum number of processes that can be active at a given point of time. The metric Capacity Utilization of Concurrent Managers tracks this. It collects the utilized capacity as a percentage of maximum allowed. You can set an alert if the usage falls below a certain percentage. The metric is available for all concurrent processing in your instance and for individual managers.

Monitoring Running Requests Based on Time

The Running Requests metric, known as Long Running Requests in previous releases, is available for all concurrent processing, an individual concurrent manager and individual concurrent program and allows you to monitor requests that are running at a given time. You can set a threshold to receive alerts if the running time exceeds a predefined value.

Monitoring Long Running Requests as a Percentage of Average Runtime

You can raise an alert if the running time exceeds a certain percentage of the average running time of previous requests. The metric Tolerance Level For Long Running Request can be used to set this alert. The metric is available for all concurrent processing, the individual concurrent manager, and individual concurrent program.

Monitoring Pending Requests Based on Time

Requests that are pending can be monitored based on time. In former releases of the management pack, these metrics were referred to as Long Pending Requests. In 12.1.0.4.0, these metrics are called Pending Requests, categorized as either Normal or Standby. You can set alerts if the pending time exceeds a predefined threshold. The metric is available for all concurrent processing, the individual concurrent manager, and individual concurrent program.

Monitoring the Number of In-Progress Requests by Status

The metric No. of Incomplete Requests by Status, formerly Concurrent Requests by Status in previous releases, can be used to set an alert if the number of inactive or pending requests exceeds a predefined limit. The metric is available for all concurrent processing and the individual concurrent program.

Monitoring the Number of Completed Requests by Status

Formerly known as Hourly Completed Requests in previous releases, the metric No. of Hourly Completed Requests by Status can be used to monitor and raise an alert if the number of requests completed (absolute and percentage) with warning or error exceeds a predefined limit. You can also raise an alert if the success rate falls below a predefined percentage. The metric is available for all concurrent processing and the individual concurrent program.

Monitoring Blocked Concurrent Requests by Time

You can raise an alert if a concurrent request is in blocked state due to a database lock. The metric Concurrent Requests in Blocked State can be used to set up this alert. The metric is available for all concurrent processing, the individual concurrent manager, and individual concurrent program.

Monitoring the Number of Blocked Requests

You can raise an alert if the number of requests in blocked state due to database locks exceeds a predefined number. The metric No. of Concurrent Requests in Blocked State can be used to set this alert. The metric is available for all concurrent processing, the individual concurrent manager, and individual concurrent program.

Note: In Release 13.1.1.1.0, this metric is disabled. See the Known Product Limitations appendix for more information.

Monitoring Specialization Rules

Specialization Rules can be defined for concurrent managers to define what kind of requests a manager can process. Both inclusion and exclusion rules can be defined. There have been cases where the number of such rules defined were large and caused performance issues. The metric No. of Include and Exclude Specialization Rules allows you to raise alerts if the number of such rules exceeds a predefined limit. This metric is available only for the concurrent manager target.

Monitoring Schedule of Requests

If a concurrent program is not scheduled as a best practice recommendation, you can raise an alert. The metric Monitor Schedule for Requests can be used to raise this alert. You can specify the expected interval in days, months, hours or minutes. When specifying the interval, only one unit of measurement can be used at a time (for example, you cannot specify a combination of hours and minutes). This metric is available only for the concurrent program target.

Monitoring Unscheduled Requests

If it is mandatory for a concurrent program to be scheduled periodically and if it is not scheduled, you can raise an alert. The metric Unscheduled Requests can be used to raise this alert. This metric is available only for the concurrent program target. You must enter the value as 0 for the alert to be raised. You must provide the recommended schedule value and recommended schedule unit by editing the monitoring configuration of the concurrent processing target. The allowed values for unit are DAYS/MINUTES/HOURS/MONTHS. If the recommended value and unit is not provided, the behavior will be to raise an alert if concurrent processing is not scheduled at all.

Monitoring Request Sets

The option to monitor requests set metrics is available only for concurrent processing in your instance.

Monitoring Running Request Sets

You can raise an alert if a request set is running for more than a predefined time. The metric Running Request Sets can be used to set this alert.

Monitoring a Request Set for Failure

You can raise an alert if a specific request set fails. The metric Failed Request Sets can be used to raise this alert.

Monitoring Request Sets That Have Not Started

You can raise an alert if a request set does not start as expected. The metric Not Started Request Sets can be used to set this alert.

Monitoring Request Sets That Are Not Scheduled

You can raise an alert if a request set is not scheduled. The metric Unscheduled Request Sets can be used to raise this alert.

Monitoring Conflict Resolution Manager

Metrics are collected to check the health of the Conflict Resolution Manager (CRM). You can raise an alert if:

You can go to the home page of the Conflict Resolution Manager target by clicking on its name from the Components region in the Overview tab of the Concurrent Processing Dashboard.

Monitoring Output Post Processor

Metrics are collected to check the health of the output post processor. Alerts will be raised if:

You can go to the home page of the Output Post Processor target by clicking on its name from the Components region in the Overview tab of the Concurrent Processing Dashboard.

Oracle E-Business Suite Summary on the Exalogic Dashboard

You can add an Oracle E-Business Suite Summary region for instances running on Exalogic machines to enable monitoring for these instances.

This region contains:

To add an Oracle E-Business Suite summary region on the Exalogic dashboard, perform the following steps:

  1. Click on the global menu Targets > Exalogic. The landing page with all the discovered Exalogic instances should be displayed.

  2. Click on any instance. The Exalogic dashboard should be displayed.

  3. Click on the personalization page icon. The page should become editable.

  4. Click on the Add Content button for a list of available regions. Click the Add icon for Oracle E-Business Suite Instances to add the region.

  5. Click Close to exit the editable page.

To remove the Oracle E-Business Suite summary region from the Exalogic dashboard, click on the personalization page icon and the page should become editable. Click on the cross icon (X) on the top right side of the region to remove the Oracle E-Business Suite summary region.

To change the location of the Oracle E-Business Suite summary region, click on the View Action Menu icon on the top right side of the region and click Move Up/Move Down to rearrange the region on the Exalogic dashboard.

End-To-End Performance Monitoring with RUEI and JVMD

The management pack now integrates seamlessly with Real User Experience Insight (RUEI) and Java Virtual Machine Diagnostics (JVMD) for monitoring performance of transactions. RUEI understands how users are interacting with your product. Using the measurements that RUEI collects, you can assess the effectiveness of user interface design, the responsiveness of web servers and the internet, and the success of user operations. JVMD looks at the finest details of code execution and to identify problems like race conditions, blocked threads, and memory leaks. To learn more about RUEI and JVMD, see Part VI - Monitoring Application Performance of Oracle Enterprise Manager Cloud Control Getting Started with Oracle Fusion Middleware Management Plug-in.

Supported Oracle E-Business Suite Versions

This feature works only for Oracle E-Business Suite Release 12.2 and above, where the middle tier is deployed on the WebLogic Server.

Prerequisites

Setting up End-to-End Monitoring

Configure Oracle E-Business Suite in RUEI

Real User Experience Insight can be configured to support drilling down to JVM Diagnostics. For example, if a page is taking too much time to load, RUEI will detect it. You can then drill down from RUEI to JVMD and find out the root cause of why the page is hanging.

  1. Log in to RUEI.

  2. Navigate to Configuration > Applications > Suites.

    the picture is described in the document text

  3. Click on New Suite. A "New Suite" window opens.

    the picture is described in the document text

  4. Enter a suite name. This is the name that can be used to uniquely identify an Oracle E-Business Suite in RUEI. Provide any name that uniquely defines the Oracle E-Business Suite instance being configured.

  5. Provide the domain name and port of the Oracle E-Business Suite applications URL in the Find Domain and Find Port fields. For instance, if http://domain.example.com:8080/AppsLogin is your Oracle E-Business Suite applications URL, "domain.example.com" will be the domain field value and 8080 will be the port field value.

  6. Enter '*' in the Find in URL field. This entry means that any request to the Oracle E-Business Suite applications URL will be monitored. Alternatively, you can provide some patterns so that only those URLs that match the given pattern will be monitored. Click Next.

  7. Enter "E-Business Suite" as the Suite Type and click Finish. The newly-created suite appears on the page.

  8. Click on the created suite name.

  9. Click on the Advanced tab.

  10. Click on the Enterprise Manager subtab.

  11. Click on 'n/a' for Enterprise name. In the name field, provide the name of the Oracle E-Business Suite instance that is discovered in Enterprise Manager where you want to drill down to JVMD or the Oracle E-Business Suite search user sessions pages. For example, "tst1223_Oracle E-Business Suite".

    the picture is described in the document text

Configure Protocols

  1. Navigate to Configuration > Security > Protocols.

    the picture is described in the document text

  2. Based on the Oracle E-Business Suite instance protocol (http/https), click on the respective protocol and provide/add the respective port on which Oracle E-Business Suite is up and running. You can also provide the port on which forms are running in the respective protocols.

Configure Link for RUEI to EM

In diagnosing an issue in RUEI, it is possible to drill down to JVM Diagnostics in Enterprise Manager, if the EM instance is linked to RUEI. Use these steps to link RUEI to EM:

  1. Click on Configuration > General > Advanced Settings > Clickout Settings. Click on Add new clickout setting.

    the picture is described in the document text

  2. Select the version of Enterprise Manager in the clickout tool list.

    the picture is described in the document text

  3. Provide host and port values of the Enterprise Manager instance.

  4. Click on Advanced. Provide the protocol (http/https).

    the picture is described in the document text

  5. Click on Save.

  6. After linking, you should be able to see the link "Inspect in Enterprise Manager" when right-mouse-clicking on any session activity in the Browse data tab.

Analyzing a Performance Issue

  1. Log in to RUEI screen and click on Browse data tab.

    the picture is described in the document text

  2. Select the date on the left hand side to filter the data accordingly. Select E-Business (Forms) from the drop-down list below Applications tab.

  3. Click on the Session Diagnostics tab below the list mentioned in the above step.

  4. Select the EBS suite name configured in section "Configure Oracle E-Business Suite in RUEI" from the Application drop down. If you are trying to search for sessions of a specific user ID, EBS responsibility ID, or ECID, select the values accordingly from the respective drop down fields. Not all values need to be selected for each drop-down list to perform the search.

  5. Click on Search.

    the picture is described in the document text

  6. Click on a session link.

    the picture is described in the document text

  7. Multiple session activities are displayed. Check the Info column. A red-colored icon identifies that the session activity ended with some error or is hanging.

    the picture is described in the document text

  8. Right click on that session activity, click on Inspect in EM 12C > Trace JVM request.

    the picture is described in the document text

  9. This will take you to the EM screen where after logging in, you will be taken to JVMD screen directly based on the failed session activity's ECID.

Drilling Down from RUEI to the Plug-In

You can drill down to the Oracle E-Business Suite Plug-in from RUEI to monitor user sessions.

Configure link for RUEI to drill down to the plug-in

  1. Navigate to Configuration > General > Advanced Settings > Clickout Settings.

    Click on Add New Clickout Setting.

  2. Select E-Business Suite Diagnostics in the click out tool list.

  3. Provide host and port values of the Enterprise Manager instance.

  4. Click on Advanced and provide the protocol (http/https).

  5. Click on Save.

  6. After creating this link, you should be able to see the link "Inspect in EBS Diagnostics" when you right-click any session activity in the Browse data tab.

Monitoring User Sessions by drilling down from RUEI

Once the "Inspect in EBS Diagnostics" link is available, select the child menu User Search to drill down to the management pack. You will see the active sessions of the Oracle E-Business Suite user like Concurrent Processing (CP), Forms, and Oracle Application Framework (OAF) sessions. You can drill down to each session to get the details.

the picture is described in the document text

Custom Metrics

You can create custom metrics in case it is not covered by the metrics shipped out of the box.

  1. Navigate to Enterprise > Monitoring > Metric Extensions.

  2. Click Create > Metric Extension.

  3. Select Applicable to as Oracle E-Business Suite.

  4. Select Adapter as SQL.

  5. Define the query. Define columns in next step.

  6. Add any target and test. Query will hit this EBS target.

  7. Submit.

  8. Select the metric you created, Actions > Save As Deployable Draft.

  9. Select the metric you created, Actions > Publish Metric Extension.

  10. Select the metric you created, Actions > Deploy to Targets.

  11. Select any target and deploy.

For more details, see "Using Metric Extensions" in Oracle Enterprise Manager Cloud Control Administrator's Guide.

Custom Compliance Rules

Follow these steps to create custom compliance rules.

  1. Navigate to Enterprise > Compliance > Library.

  2. Create > Repository Rule.

  3. In Applicable to, select Oracle E-Business Suite.

  4. Define Query, violation condition, and other details.

  5. Make sure that query has target_guid as the first column.

  6. Click Test and Submit.

  7. Now you can map this rule to a custom standard and then the custom standard to a custom framework.

    Please note that System defined compliance objects are non-editable. You cannot map any compliance object to any System defined compliance object. However, you can use Create Like to create a copy of a System defined object and then edit that.

  8. You can always edit a custom compliance object and map rule to standard, standard to framework.

For more details, see "Managing Compliance" in Oracle Enterprise Manager Lifecycle Management Administrator's Guide.

Purging of Metrics

All metrics collected by the plug-in will be purged, as per the default Management Repository Data Retention Policies. However, the metric, "Requests Completed Successfully" for the target type "Custom Oracle Concurrent Program", is not restricted by the above mentioned policy. The metric is disabled by default. If you should enable it, manually purge the data from the table EBS_AMP_CP_REQ_COM_SUCC.