Skip to main content
Availability8.6.9 or later

What Is Monitored

Requests, managers, objects

How It Works

Queries on the FND tables

Deploy

One wizard, one component

KPIs

14 concurrent-processing KPIs

Overview

GermainUX watches the concurrent processing of your Oracle E-Business Suite (EBS). You see how many requests are running, waiting and failing, how many processes each concurrent manager has, and how many FND database objects are invalid. A Standard Manager that stops shows up as a pending backlog that grows while its active processes fall to zero. Your team finds the stopped manager in minutes, instead of from a ticket about a report that never ran.

Request Backlog

Running and pending concurrent requests over time, so a queue that stops draining stands out.

Manager Health

Active processes of the Internal, Standard and Conflict Resolution managers, and terminated processes across all managers.

Failed Requests

Requests that completed with an error or a warning, so a failing interface or report program shows up as a climbing count.

Invalid Objects After Patching

The number of invalid FND objects, so you know whether a patch left anything to recompile.

Questions It Answers

  • Is the Standard Manager running, and since when has it been down?
  • Are concurrent requests piling up in the pending queue?
  • Did more requests end in error today than on a normal day?
  • Did the last database restart leave terminated processes behind?
  • Did the patch we applied last night leave invalid FND objects?
  • Is the EBS database reachable from GermainUX right now?

What Is Monitored

Analytics, Alerts and Automation

AI Analysis

Ask AI Explore questions such as “When did pending concurrent requests last exceed 50?” and get the answer without building a report. Outlier detection flags an unusual rise in errored or pending requests.

Dashboards and Reports

Build dashboards and reports on the EBS KPIs: the request backlog next to the active processes of each manager, failed requests per day, and invalid objects before and after a patch window. Click a value to open it in the Analysis screen. It compares the selected period with the previous days and shows how the KPI moved. In the example below, the Standard Manager stopped: pending requests climbed while its active processes stayed at zero, then drained after the restart.
Analysis screen for the EBS Query Pending Concurrent Requests KPI, with pending requests climbing while the Standard Manager is down and draining after it restarts

Analysis of Pending Concurrent Requests - GermainUX

SLAs and Alerts

The EBS KPIs ship without SLAs, because the right thresholds depend on your workload. Add SLAs on the KPIs that matter to you, for example:
  • EBS Query Pending Concurrent Requests above your normal backlog
  • EBS Query Active Processes Standard Manager Queue at 0
  • EBS Query Terminated Concurrent Processes above 0
  • EBS Query Invalid DB Objects above 0
Then get an alert by email, SMS, Slack or Teams when one is breached.

Correlation with Other Technologies

Correlate the EBS KPIs with the Oracle Database underneath, and with the experience of the users in the EBS pages, to tell a database problem from a concurrent-manager problem.

How It Works

EBS databaseEBS FND Query ComponentKPIsAlerts
The query monitor runs on a GermainUX Engine that can connect to the EBS database. Each run also records whether the database was reachable, in the Database Availability KPI.

Before You Start

  • A GermainUX Engine can connect to the EBS database over JDBC.
  • A database account can run SELECT on APPLSYS.FND_CONCURRENT_REQUESTS, APPLSYS.FND_CONCURRENT_PROCESSES, APPLSYS.FND_CONCURRENT_PROGRAMS and APPLSYS.FND_CONCURRENT_QUEUES.
  • For the invalid-objects count, the account is the schema that owns the FND objects. The query reads user_objects, so it counts only the objects the connected schema owns.
  • The account’s user name and password are stored as credentials in GermainUX.

Deploy

1

Open the Database Query Monitor Deployment wizard

In the left menu, go to Settings > Wizards. On the Database Query Monitor Deployment card, click Add.
2

Connect to the EBS database

On the Database step, fill in the fields, and then click Next:
3

Choose the EBS component

On the Component step, select EBS FND Query Component as the Component, and then click Next.
Database Query Monitor Deployment wizard on the Component step with EBS FND Query Component selected

Database Query Monitor Deployment Wizard with the EBS Component - GermainUX

4

Deploy it to the Engine

On the Deployment step, fill in the fields, and then finish the wizard:
Repeat the wizard for each EBS instance you want to monitor.

Validate

1

Wait for the first run

The first values arrive after the first scheduled run, for example within five minutes with 0 */5 * * * *.
2

Compare a count with the database

In GermainUX Workspace, open the EBS Query Pending Concurrent Requests KPI. In SQL*Plus or SQL Developer, run the same count with the monitoring account:
The KPI shows the same value for the last run.
3

Check the database availability

Open the Database Availability KPI and check that the EBS database shows 100.

Troubleshooting

Open the Database Availability KPI. If the EBS database shows 0, the Engine can’t connect: check the host, port and service name of the database, the credentials, and the network path from the Engine. If it shows 100, check that the account can run select count(1) from APPLSYS.FND_CONCURRENT_REQUESTS.
The invalid-objects query reads user_objects, which lists only the objects the connected schema owns. Connect with the schema that owns the FND objects.
The wizard’s default schedule, 0 0 * * * *, runs the queries once an hour. Edit the monitor and set a shorter schedule, for example 0 */5 * * * *.
The error and warning counts include every request still in FND_CONCURRENT_REQUESTS. They fall when old requests are purged. Watch the change from one run to the next, or add an SLA on the increase, rather than on the total.

Security and Privacy

Oracle E-Business Suite monitoring stores counts only: the number of requests, processes, programs, queues and invalid objects. It doesn’t read request parameters, user names or business data. When the database can’t be reached, the Database Availability KPI stores the connection error, which can include the database host and the account name. Treat it as possibly containing personal or customer data. To mask, anonymize or exclude this data, see Data Privacy.

KPIs

All EBS KPIs are data model GenericMetric. See KPIs and SLAs.

Query Monitoring

How query monitors work

Oracle Database

The database underneath EBS

Automation

More Automation Features

Get Help

The GermainUX team can help you add queries for the concurrent programs and managers that matter to your business.

Contact GermainUX Support

The GermainUX team helps you get up and running faster, empower your team, turn data into actionable insights, and optimize performance to deliver measurable business outcomes.

Can't Find What You Need?

Search all GermainUX docs with Ctrl + K, or use the feedback buttons at the bottom of this page to tell us what is missing.

The content of this document is proprietary to GERMAIN SOFTWARE.