Configure integration services for Oracle EBS

  • Release version: Australia
  • Updated March 12, 2026
  • 2 minutes to read

    • 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.

    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.
      Figure 1. Look up Legal Entities from Oracle EBS
      Look up Legal Entities from Oracle EBS
    4. On the integration service record, fill in the fields.
      Table 1. Integration service record
      Field Description
      Entity The type of entity for which you want to configure the integration services.
      Application Name of the application. For example, Oracle EBS.
      ERP Source configuration The ERP source mapped to the entity. For example, Oracle EBS.
      Active The status of the interaction service. By default, the check box is inactive.
      Subflow The 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.
      Order Option to choose the order in which the entity should be displayed.
    5. Select Update.
      The integration service is configured for the selected entity.