For AI agents: A markdown version of this page is available at https://docs.datadoghq.com/integrations/oracle-fusion.md. A documentation index is available at /llms.txt.

Oracle Fusion Applications

Supported OS Linux Windows Mac OS

Integration version1.0.0
This product is not supported for your selected Datadog site. ().

Overview

Oracle Fusion Cloud Applications is a suite of cloud-based enterprise applications built on Oracle Cloud Infrastructure (OCI). It spans enterprise resource planning (ERP), supply chain management and manufacturing (SCM), human capital management (HCM), customer experience (CX), and enterprise performance management (EPM).

The Datadog Oracle Fusion Cloud Applications integration provides valuable insights into your Oracle Fusion and EPM environments by:

  • Monitoring Enterprise Service Scheduler (ESS) jobs across 4 business applications: ERP, SCM, HCM, and CX
  • Monitoring EPM jobs across five module types: FCCS, Planning, FreeForm, Tax Reporting, and EPCM, covering most job types
  • Helping identify bottlenecks and performance impact
  • Auditing user activity including sign-in events, target user changes, user role assignment changes, and metadata permission checks

Note: The Oracle Cloud Infrastructure Integration collects OCI metrics from the oci_fusion namespace. OCI audit logs include Oracle Fusion and EPM sign-in events.

After parsing your Oracle Fusion Cloud Applications and Oracle Fusion EPM data, Datadog populates an out-of-the-box Oracle Fusion Overview dashboard. The integration also offers recommended monitors to help you get started alerting on ESS and EPM job performance, enabling proactive management and improved operational efficiency.

To onboard, visit the Oracle Fusion Applications integration tile and add a new account.

Setup

To onboard, visit the Oracle Fusion Applications integration tile and add a new account.

Onboarding overview

Integration accounts are scoped by OCI Identity Domain, meaning that if an Oracle Fusion and Oracle EPM instance share an OCI identity domain, they should share a single Datadog account. However, Datadog accounts can also be configured to only monitor Fusion or only monitor EPM.

Required permissions

The individual running the onboarding script must have the Identity Domain Administrator role for the OCI identity domain, the Service Administrator role for the Oracle EPM instance, and access to IT Security Manager credentials for the Oracle Fusion instance.

The user must also have configured OCI CLI credentials for the tenancy. Steps for that can be found here.

Creating the confidential application

Datadog’s onboarding script begins by creating a confidential application, which enables Datadog to configure OAuth for your Fusion and EPM instances. The confidential application is used to generate client credentials, scoped to only the specified Fusion and EPM instances.

Creating the Oracle Fusion user

After creating the confidential application, the script creates a user in your Oracle Fusion instance with client ID matching the confidential application, enabling OAuth access to the instance.

Creating the Datadog integration role

Users must manually configure a custom role, which the onboarding script assigns to the user automatically. To create this custom role:

  1. Log in to Oracle Fusion as an administrator.
  2. Navigate to: Navigator > Tools > Security Console > Roles > Create Role.
  3. Set the following:
    • Role Name: (any descriptive name)
    • Role Code: DD_INTEGRATION_ROLE (must be exactly this)
    • Role Category: Default
  4. Under Role Hierarchy, add these 3 roles by their codes:
    • ESSMonitor
    • ORA_FND_INTEGRATION_SPECIALIST_JOB
    • ORA_FND_INTERNAL_AUDITOR_JOB
      Note: Oracle Fusion is likely to pull in sub-roles automatically for each of these roles. This is expected. Keep all sub-roles that are added.
  5. Click Save.
  6. Make the role API-assignable through Role Provisioning Rules:
    1. Go to Setup and Maintenance and search for Manage Role Provisioning Rules.
    2. Click Add to create a new mapping, using these values:
      • Mapping Name: DD Integration Role Mapping (or any name)
      • From Date: today’s date
      • Conditions: leave blank
    3. Under Associated Roles, click Add Row and search for the custom role you created.
    4. Select Requestable, leave all other checkboxes unchecked, and click Save and Close.

Required roles

RoleCodePurpose
ESS MonitorESSMonitorRead ESS job requests and job logs
Integration SpecialistORA_FND_INTEGRATION_SPECIALIST_JOBAccess ERP Integration REST endpoints
Internal AuditorORA_FND_INTERNAL_AUDITOR_JOBRead-only access to audit data

Creating the Oracle Fusion EPM user

After creating the Oracle Fusion user, an associated user is automatically generated in the OCI identity domain. Datadog’s onboarding script then adds this user to the EPM instance by assigning the Service Administrator role, which is necessary for accessing any job or audit reports. After assigning the EPM role, users must navigate to Tools > Access Control > Role Assignment Report, and verify the Datadog integration user is present. Otherwise, Oracle EPM does not automatically register the new user.

Note: If Oracle Fusion is not configured, the script generates a new OCI user associated to the confidential application. This role is then added to the EPM instance users.

Data Collected

Metrics

oracle.fusion.ess.jobs
(count)
The number of Oracle Fusion ESS jobs that transitioned to the given state within the reporting window.
Shown as job
oracle.fusion.ess.job.execution_attempt
(gauge)
The maximum number of execution attempts for Oracle Fusion ESS jobs that reached a terminal state.
oracle.fusion.ess.job.retried_count
(gauge)
The total number of retries for Oracle Fusion ESS jobs that reached a terminal state.
oracle.fusion.ess.job.elapsed_time
(gauge)
The maximum elapsed time for Oracle Fusion ESS jobs that reached a terminal state.
Shown as millisecond
oracle.fusion.epm.jobs
(count)
The number of Oracle Fusion EPM Hyperion Planning (HPL) jobs observed within the reporting window. Includes in-progress jobs.
Shown as job
oracle.fusion.epm.job.elapsed_time
(gauge)
The maximum elapsed time for Oracle Fusion EPM HPL jobs that reached a terminal state.
Shown as millisecond
oracle.fusion.avg_application_response_time_monthly
(gauge)
Average server response time for all HTTP requests in a production instance for a calendar month. Excludes reports, analytics, document parsing, data integration, and searches.
Shown as millisecond
oracle.fusion.environment_availability_status
(gauge)
Availability status of the Fusion Applications environment.
oracle.fusion.service_availability
(gauge)
Monthly Service Availability Level expressed as an uptime percentage.
Shown as percent

Uninstallation

In addition to uninstalling the tile and/or deleting credentials, consider deleting the created confidential application in your OCI identity domain and deleting the associated integration user.

Support

Need help? Contact Datadog support.

To onboard, visit the Oracle Fusion Applications integration tile and add a new environment.

Missing Oracle Fusion EPM data? In your Oracle Fusion EPM instance, navigate to Tools > Access Control > Role Assignment Report, and verify the Datadog integration user is present. This triggers a user sync, which EPM does not do automatically.

Missing audit events?

  • For Oracle Fusion: Navigate to Setup and Maintenance, search for Manage Audit Policies, and set all audit levels to high
  • For Oracle Fusion EPM: Navigate to Tools > Audit > Enable Auditing > Enable for all services
  • Oracle Fusion and EPM user sign-in events can be monitored through the Oracle Cloud Infrastructure integration

Note: Oracle Fusion ERP, SCM, HCM, and CX data is collected every 5 minutes or less. Oracle Fusion EPM data is collected hourly.

Further Reading

Additional helpful documentation, links, and articles: