Oracle EBS Spoke
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.14.0 is the latest version.
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. | |
| 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.