Oracle EBS Spoke

concept australia Updated Oct 5, 2026 12 min read oebs-spoke.md
Raw file servicenow.com

Manage sales orders, procurement, finance, customers, ledgers, and so on, in the Oracle EBS instance from your ServiceNow instance.

Request apps on the Store

Visit the ServiceNow Store website to view all the available apps and for information about submitting requests to the store. For cumulative release notes information for all released apps, see the ServiceNow Store version history release notes.

Note: The packages should be redeployed when you are upgrading to the Oracle EBS spoke v1.1 from Oracle EBS spoke v1. For more information, see Set up the Oracle EBS spoke.

Integration Hub subscription

This spoke requires an Integration Hub subscription. For more information, see Legal schedules - IntegrationHub overview.

Spoke version

Oracle EBS spoke v1.15.0 is the latest version. For version history of the spoke, see Oracle EBS spoke release notes.

Supported versions

This spoke was built for these versions, but may be compatible with later versions.

  • Operating system version: Red Hat Enterprise Linux release 8.9 (Ootpa)
  • Oracle database version: 12.1.0.2.0
  • Oracle E-Business Suite application tier version: 12.2.12
  • Oracle WebLogic Server version: 10.3.6.0.171017 PSU
  • Oracle WebTier version: 11.1.1.9
  • Oracle Forms and Reports: 10.1.2.3

Spoke dependencies

If you’re having trouble installing the app, ensure that these dependent plugins are installed:

  • ServiceNow IntegrationHub Runtime (com.glide.hub.integration.runtime)
  • Complex Object (com.glide.cobject)
  • ServiceNow Flow Designer - Dynamic Inputs (com.glide.hub.dynamic_inputs)
  • ServiceNow IntegrationHub Action Step - REST (com.glide.hub.action_step.rest)
  • ServiceNow IntegrationHub Action Template - Data Stream (com.glide.hub.action_type.datastream)

Note: Some of these plugins are licensable features and require appropriate licenses, if used outside the spoke implementation.

Spoke flows

The Oracle EBS spoke provides a sample flow, Look up Daily Rates to demonstrate automating tasks. The flow runs daily and retrieves the Daily Currency Exchange Rates from Oracle EBS for the current date and saves the details in your ServiceNow instance.

Spoke subflows

The Oracle EBS spoke provides sample subflows to demonstrate automating tasks. To customize a sample subflow, copy it to the required application scope. Available sample subflows include:

Subflow Description
AP Invoices - Create Interface Entries Creates interface entries of AP Invoices in Oracle EBS.
AP Invoices - Get Processing Details Retrieves the concurrent program status and other details from Oracle EBS.
Fetch AP invoice details Retrieves the AP invoice details from Oracle EBS.
Fixed Assets - Create Interface Entries Creates interface entries of fixed assets in Oracle EBS.
Fixed Assets - Get Processing Details Retrieves the concurrent program status and other details from Oracle EBS.
Get Journal Posted Status Retrieves the current status of a GL journal header.
Goods Receipts - Create Interface Entries Creates interface entries of Goods Receipts in Oracle EBS.
Goods Receipts - Get Processing Details Retrieves the concurrent program status and other details from Oracle EBS.
Purchase Orders - Create Interface Entries Creates interface entries of purchase orders in Oracle EBS.
Purchase Orders - Get Processing Details Retrieves the concurrent program status and other details from Oracle EBS.

Spoke actions

The Oracle EBS spoke provides actions to automate tasks when events occurs in your ServiceNow instance. Available actions include:

Category

Action

Description

Approval Management

Approve or Reject Approval Request

Approves or rejects the specified approval request in Oracle EBS.

Cancel Approval

Cancels the specified approval request in Oracle EBS.

Finance

Create AP Invoice - Run Concurrent Program

Runs the concurrent program that imports invoice data from the interface table to the base table of Oracle EBS.

Get AP Invoice

Retrieves details of the required AP invoice.

Get Fixed Asset

Retrieves details of the required fixed asset.

Get Vendor

Retrieves details of the required vendor.

Get Vendor Site

Retrieves details of the required vendor site.

Import Fixed Asset - Run Concurrent Program

Runs the concurrent program that imports the fixed asset data from the interface table to base table of Oracle EBS.

Look up AR Invoices

Retrieves details of the AR invoices.

Look up Daily Rate

Retrieves details of the specified daily rate based on the input criteria.

Look up Legal Entity

Retrieves details of a the required legal entity.

Look up Ship To Locations

Retrieves details of the required shipped locations based on the input criteria.

Inventory Management

Submit Inventory - Run Concurrent Program

Submits an inventory item CC program.

Update Inventory Items

Updates details of the inventory items.

Purchase Requisition Management

Create Purchase Requisition

Creates purchase requisition in Oracle EBS.

Submit Purchase Requisition - Run Concurrent Program

Retrieves the concurrent status of a purchase requisition.

Look up Purchase Requisitions

Retrieves Purchase Requisition Details from Oracle EBS.

Invoice Management

Authorize Payment - Apply Hold

Applies hold on the specified authorized payment invoices in Oracle EBS.

Authorize Payment - Release Hold

Releases hold on the specified authorized payment invoices in Oracle EBS.

Cancel Invoice

Cancels an invoice in Oracle EBS.

Create AP Invoice

Creates an Accounts Payable (AP) invoice in Oracle EBS. Note: The internal name of the latest version of the action is create_ap_invoice_v3. To use it, you must install the latest version of the spoke from the ServiceNow store.

Look up AP Invoices

Retrieves an Accounts Payable (AP) invoice details from Oracle EBS.

Look up Invoice Payment Status

Retrieves the invoice payment status from Oracle EBS.

Submit Invoice - Run Concurrent Program

Submits an invoice - run concurrent program in Oracle EBS.

Journal Ledger

Create Journals

Creates a journal.

Get GL Journal Batch

Retrieves details of the required GL journal batch.

Get GL Journal Header

Retrieves details of the required GL journal header.

Get GL Ledger

Retrieves details of the required GL ledger.

Get GL Subledger Account

Retrieves details of the required GL subledger account.

Import Journals - Run Concurrent Program

Runs the concurrent program that imports journals data from the interface table to the base table of Oracle EBS.

Look up GL Balance

Retrieves details of the required GL balance based on the input criteria.

Look up GL Balances

Retrieves details of the required GL balance based on the input query.

Look up GL Code Combinations

Retrieves details of the required GL code combinations based on the input query.

Look up GL Journals

Retrieves details of the required GL journals based on the input criteria.

Look up GL Ledgers

Retrieves details of the required GL ledgers based on the input criteria.

Look up GL Subledger Accounts

Retrieves details of the required GL subledger accounts based on the input criteria.

Post Journals - Run Concurrent Program

Runs the concurrent program that posts the unposted journals.

Reverse Journals - Run Concurrent Program

Runs the concurrent program that reverses the posted journals.

Master

Create Item

Creates an item.

Look up Cost Center

Retrieves details about the required cost center.

Look up Item

Retrieves details about the required item.

Look up Item Category

Retrieves details about the required item category.

Utility Actions

Generate Input Payload With Crossreference

Generates array type input payload for Create Actions from subflow input payload while assigning configured cross-reference field with the ServiceNow ID(s).

Get Additional EBS Fields

Retrieves list of fields which can be further used as a dynamic template or dynamic object, based on an input string, Action Internal Name.

Get Records

Retrieves data from any Oracle EBS module using an SQL query.

Look up Common Object Details

Retrieves the common details of the object specified.

Look up Concurrent Program Status

Retrieves the status of a concurrent request.

Parse OEBS Record Details

Converts the JSON output of 'Get Records' Action into structured Object format.

Wait for Request Completion

Waits until the status of the request completes.

Transfer Order Management

Create Transfer Order

Creates a transfer order with the specified details.

Look up Transfer Orders

Retrieves details of the required transfer orders.

Procurement

Create Goods Receipts

Creates a goods receipt.

Get Advance Shipment Notice

Retrieves details of the required advance shipment notice.

Look up Advance Shipment Notices

Retrieves details of multiple advance shipment notices based on the input query.

Asset Management

Create Asset

Creates an asset with the specified details.

Look up Asset Categories Stream

Retrieves the details of the look up asset categories.

Submit Asset - Run Concurrent Program

Returns the concurrent status of the specified asset in Oracle EBS.

Bills and Payments

Look up Bill Details

Retrieves details of the required bills.

Look up Outstanding Balances

Retrieves details of the required outstanding balances.

Look up Payment Details

Retrieves details of the required payments.

Look up Payment Status

Retrieves status of the required payments.

Customer

Create Customer Account

Creates a customer account.

Create Customer Account Role

Creates a customer account role.

Create Customer Contact

Creates a customer account contact.

Create Customer Relation

Creates a customer relation record.

Create Person

Creates a person record.

Look up Customer Accounts

Retrieves details of the required customer accounts.

Look up Customer Contacts

Retrieves the required customer contacts.

Update Customer Account

Updates details of the required customer account.

Update Customer Contact

Updates details of the required customer contact.

Sales Order

Look up Sales Order Status Stream

Retrieves status details of the required sales orders.

Look up Sales Order Stream

Retrieves details of the required sales orders.

Contract Management

Create Contract

Creates a contract in Oracle EBS.

Create Contract - Run Concurrent Program

Retrieves the concurrent status of contract in Oracle EBS.

Purchase Order Management

Cancel Purchase Order

Cancels the purchase order.

Create Blanket Release

Creates blanket release in Oracle EBS.Note: The internal name of the latest version of the action is create_blanket_release_v2. To use it, you must install the latest version of the spoke from the ServiceNow store.

Create Blanket Release - Run Concurrent Program

Retrieves the concurrent status of blanket release in Oracle EBS.

Create Blanket Purchase Agreement

Creates a blanket purchase agreement.Note: The internal name of the latest version of the action is create_blanket_purchase_agreement_v2. To use it, you must install the latest version of the spoke from the ServiceNow store.

Create Purchase Order

Creates purchase orders in Oracle EBS.Note: The internal name of the latest version of the action is create_purchase_order_v3. To use it, you must install the latest version of the spoke from the ServiceNow store.

Create Purchase Order - Run Concurrent Program

Runs the concurrent program that imports the purchase order data from the interface table to the base table of Oracle EBS.

Update Blanket Purchase Agreement

Updates the details of the specified blanket purchase agreement.Note: The internal name of the latest version of the action is update_blanket_purchase_agreement_v2. To use it, you must install the latest version of the spoke from the ServiceNow store.

Update Purchase Order

Updates the purchase order in Oracle EBS.Note: The internal name of the latest version of the action is update_purchase_order_v3. To use it, you must install the latest version of the spoke from the ServiceNow store.

Receipt Management

Cancel PO Goods Receipt

Cancels the purchase order (PO) goods receipt.Note: The internal name of the latest version of the action is create_po_goods_receipt_v2. To use it, you must install the latest version of the spoke from the ServiceNow store.

Create Goods Receipt - Run Concurrent Program

Creates a good receipt in concurrent program mode.

Create PO Goods Receipt

Creates a Purchase Order (PO) goods receipt in Oracle EBS.

Look up PO Receipts

Retrieves purchase order (PO) receipts from Oracle EBS.

Update PO Goods Receipt

Updates a Purchase Order (PO) goods receipt in Oracle EBS.

Supplier Management

Create Bank Account

Creates a bank account.

Create Supplier

Creates a supplier in Oracle EBS.

Create Supplier Site

Creates a supplier site in Oracle EBS.

Deactivate Supplier

Deactivates the specified supplier in Oracle EBS.

Deactivate Supplier Site

Deactivates the specified supplier site in Oracle EBS.

Look up Bank Accounts Stream

Retrieves the supplier bank account details.

Look up Supplier Sites Stream

Retrieves the supplier site details from Oracle EBS.

Look up Suppliers Stream

Retrieves the supplier details from Oracle EBS.

Update Bank Account

Updates the specified bank account in Oracle EBS.

Update Supplier

Updates the specified supplier details in Oracle EBS.

Update Supplier Site

Updates the specified supplier site details in Oracle EBS.

Void Supplier Bank Account

Makes the supplier bank account as void.

Primary Data Management

Look up Attachments

Retrieves the file attachments related to purchase order, supplier, and other specified details from Oracle EBS.

Look up Currencies

Retrieves currency details from Oracle EBS.

Look up GL Accounts Stream

Retrieves GL account details from Oracle EBS.

Look up GL Cost Centers Stream

Retrieves the cost center details from Oracle EBS.

Look up GL Daily Rates

Retrieves GL Daily Rate details from Oracle EBS.

Look up GL Ledgers

Retrieves Ledger details from Oracle EBS.

Look up GL Legal Entities

Retrieves GL Legal Entity details from Oracle EBS.

Look up HR Locations Stream

Retrieves the details of HR locations from Oracle EBS.

Look up Inventory Items Stream

Retrieves the inventory item details from Oracle EBS.

Look up Item Categories Stream

Retrieves the item category details from Oracle EBS.

Look up Operating Units

Retrieves Operating Unit details from Oracle EBS.

Look up Payment Terms

Retrieves payment term details.

Look up Purchase Groups

Retrieves Purchasing Group details from Oracle EBS.

Look up Purchasing Organizations

Retrieves Purchasing Organization details from Oracle EBS.

## Connection and credential alias requirements

Integration Hub uses aliases to manage connection and credential information. Using an alias eliminates the need to configure multiple credentials and connection information profiles when using multiple environments. If the connection or credential information changes, you don't need to update any actions that use the connection. For more information, see Connections and Credentials.

For information about setting up the spoke, see Set up the Oracle EBS spoke.

MID Server requirements

These actions use REST calls, which can run on an instance or MID Server. Use the connection record associated with the Oracle EBS alias to configure where actions run as well as set MID Server selection attributes. For more information about running actions on the MID Server, see Integration steps.

Note: If your Oracle EBS instance is only accessible on a private network, you must use MID Server.

To set up the MID Server for this spoke, see Set up MID Server for a spoke.

Search documentation
Search document titles and file paths on the australia branch