Skip to content
Release: Australia · Updated: 2026-03-12 · Official documentation · View source

Configure integration services for Oracle EBS

For configuring integration services, provide the connection end point and the Oracle EBS ERP credentials that you set up for your authentication profile. Also, create a separate web service record for each service request that you want to customize.

[Omitted video] Description: Configure integration services for Oracle EBS.

Before you begin

  • Verify that the application scope is set to Oracle EBS spoke.
  • Verify that the MID Server is installed and configured in your ServiceNow instance to connect to the ERP server. For more details, see Installing the MID Server.

    Note: The MID Server integration is required only for an Oracle EBS ERP integration using SOAP services.

  • For REST type service, REST API details, as provided by ERP.

Role required: sn_fcms_intg.integration_user

About this task

If the application requires multiple Oracle EBS ERP instances, create separate web services for each ERP instance. You can create Integration Service records for entities using the sn_fcms_intg_service table.

Procedure

  1. Navigate to All > Finance – ERP Integration > ERP Source Configuration.

  2. Open the ERP source for which you need to configure integration services.

    For example, Oracle EBS.

  3. In the Integration Services list, select the service that you want to configure.

Image omitted: oracle-ebs-fullpull.png
Look up Legal Entities from Oracle EBS
  1. On the integration service record, fill in the fields.
FieldDescription
EntityThe type of entity for which you want to configure the integration services.
ApplicationName of the application. For example, Oracle EBS.
ERP Source configurationThe ERP source mapped to the entity. For example, Oracle EBS.
ActiveThe status of the interaction service. By default, the check box is inactive.
SubflowThe subflow used to fetch primary data.
Properties

Creates a JSON record in the integration service, which is then passed to the ERP subflows to retrieve complete data.

To pass JSON into the subflow, create a property named "query" and assign it a JSON query as its value, like this:

[
  {
    "parameter": "LEGAL_ENTITY_NAME",
    "operator": "=",
    "value": "Vision ADB",
    "operand": "NONE"
  }
]
  • Enabling Full Pull:

Use this property to fetch the complete data.

  • Create a property named "full_pull" and set its value to true.
  • Additionally, you can create another property like, "initial_load_start_date_time" and set its value to 2025-02-15T04:10:34.
  • Enabling Delta Pull:

Use this property to fetch the incremental data.

Set the value of the "full_pull" property to false.

OrderOption to choose the order in which the entity should be displayed.
  1. Select Update.

    The integration service is configured for the selected entity.

Parent Topic:Configure the Source-to-Pay integration with Oracle EBS

Related topics

ERP source configuration for Oracle EBS

Define ERP source configuration for Oracle EBS

Load data to ERP user-mapping table for Oracle EBS

Look up primary data in Oracle EBS

Scheduled jobs to look up primary data in Oracle EBS