{"revision":"c10276e953456835cdbb1f3a60d58ae1980be353","document":{"id":21330,"path":"integrate-applications/integration-hub/oebs-spoke.md","title":"Oracle EBS Spoke","bundle":null,"doc_type":null,"release":"australia","body":"\n# Oracle EBS Spoke\n\nManage sales orders, procurement, finance, customers, ledgers, and so on, in the Oracle EBS instance from your ServiceNow instance.\n\n## Request apps on the Store\n\nVisit the [ServiceNow Store](https://store.servicenow.com/sn_appstore_store.do#!/store/home) 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](https://www.servicenow.com/docs/r/store-release-notes/sn-store-release-notes.html).\n\n**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](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/integrate-applications/integration-hub/setup-oebs-spoke.md).\n\n## Integration Hub subscription\n\nThis spoke requires an Integration Hub subscription. For more information, see [Legal schedules - IntegrationHub overview](https://www.servicenow.com/content/dam/servicenow-assets/public/en-us/doc-type/legal/snc-addendum-integrationhub.pdf).\n\n## Spoke version\n\nOracle EBS spoke v1.15.0 is the latest version. For version history of the spoke, see [Oracle EBS spoke release notes](https://www.servicenow.com/docs/r/store-release-notes/store-integrationhub-rn-oracle-ebs.html).\n\n## Supported versions\n\nThis spoke was built for these versions, but may be compatible with later versions.\n\n- Operating system version: Red Hat Enterprise Linux release 8.9 \\(Ootpa\\)\n- Oracle database version: 12.1.0.2.0\n- Oracle E-Business Suite application tier version: 12.2.12\n- Oracle WebLogic Server version: 10.3.6.0.171017 PSU\n- Oracle WebTier version: 11.1.1.9\n- Oracle Forms and Reports: 10.1.2.3\n\n## Spoke dependencies\n\nIf you’re having trouble installing the app, ensure that these dependent plugins are installed:\n\n- ServiceNow IntegrationHub Runtime \\(com.glide.hub.integration.runtime\\)\n- Complex Object \\(com.glide.cobject\\)\n- ServiceNow Flow Designer - Dynamic Inputs \\(com.glide.hub.dynamic\\_inputs\\)\n- ServiceNow IntegrationHub Action Step - REST \\(com.glide.hub.action\\_step.rest\\)\n- ServiceNow IntegrationHub Action Template - Data Stream \\(com.glide.hub.action\\_type.datastream\\)\n\n**Note:** Some of these plugins are licensable features and require appropriate licenses, if used outside the spoke implementation.\n\n## Spoke flows\n\nThe 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.\n\n## Spoke subflows\n\nThe 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:\n\n|Subflow|Description|\n|-------|-----------|\n|AP Invoices - Create Interface Entries|Creates interface entries of AP Invoices in Oracle EBS.|\n|AP Invoices - Get Processing Details|Retrieves the concurrent program status and other details from Oracle EBS.|\n|Fetch AP invoice details|Retrieves the AP invoice details from Oracle EBS.|\n|Fixed Assets - Create Interface Entries|Creates interface entries of fixed assets in Oracle EBS.|\n|Fixed Assets - Get Processing Details|Retrieves the concurrent program status and other details from Oracle EBS.|\n|Get Journal Posted Status|Retrieves the current status of a GL journal header.|\n|Goods Receipts - Create Interface Entries|Creates interface entries of Goods Receipts in Oracle EBS.|\n|Goods Receipts - Get Processing Details|Retrieves the concurrent program status and other details from Oracle EBS.|\n|Purchase Orders - Create Interface Entries|Creates interface entries of purchase orders in Oracle EBS.|\n|Purchase Orders - Get Processing Details|Retrieves the concurrent program status and other details from Oracle EBS.|\n\n## Spoke actions\n\nThe Oracle EBS spoke provides actions to automate tasks when events occurs in your ServiceNow instance. Available actions include:\n\n\n
\n\nCategory\n\n\n\nAction\n\n\n\nDescription\n\n
\n\nApproval Management\n\n\n\nApprove or Reject Approval Request\n\n\n\nApproves or rejects the specified approval request in Oracle EBS.\n\n
\n\nCancel Approval\n\n\n\nCancels the specified approval request in Oracle EBS.\n\n
\n\nFinance\n\n\n\nCreate AP Invoice - Run Concurrent Program\n\n\n\nRuns the concurrent program that imports invoice data from the interface table to the base table of Oracle EBS.\n\n
\n\nGet AP Invoice\n\n\n\nRetrieves details of the required AP invoice.\n\n
\n\nGet Fixed Asset\n\n\n\nRetrieves details of the required fixed asset.\n\n
\n\nGet Vendor\n\n\n\nRetrieves details of the required vendor.\n\n
\n\nGet Vendor Site\n\n\n\nRetrieves details of the required vendor site.\n\n
\n\nImport Fixed Asset - Run Concurrent Program\n\n\n\nRuns the concurrent program that imports the fixed asset data from the interface table to base table of Oracle EBS.\n\n
\n\nLook up AR Invoices\n\n\n\nRetrieves details of the AR invoices.\n\n
\n\nLook up Daily Rate\n\n\n\nRetrieves details of the specified daily rate based on the input criteria.\n\n
\n\nLook up Legal Entity\n\n\n\nRetrieves details of a the required legal entity.\n\n
\n\nLook up Ship To Locations\n\n\n\nRetrieves details of the required shipped locations based on the input criteria.\n\n
\n\nInventory Management\n\n\n\nSubmit Inventory - Run Concurrent Program\n\n\n\nSubmits an inventory item CC program.\n\n
\n\nUpdate Inventory Items\n\n\n\nUpdates details of the inventory items.\n\n
\n\nPurchase Requisition Management\n\n\n\nCreate Purchase Requisition\n\n\n\nCreates purchase requisition in Oracle EBS.\n\n
\n\nSubmit Purchase Requisition - Run Concurrent Program\n\n\n\nRetrieves the concurrent status of a purchase requisition.\n\n
\n\nLook up Purchase Requisitions\n\n\n\nRetrieves Purchase Requisition Details from Oracle EBS.\n\n
\n\nInvoice Management\n\n\n\nAuthorize Payment - Apply Hold\n\n\n\nApplies hold on the specified authorized payment invoices in Oracle EBS.\n\n
\n\nAuthorize Payment - Release Hold\n\n\n\nReleases hold on the specified authorized payment invoices in Oracle EBS.\n\n
\n\nCancel Invoice\n\n\n\nCancels an invoice in Oracle EBS.\n\n
\n\nCreate AP Invoice\n\n\n\nCreates 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.\n\n
\n\nLook up AP Invoices\n\n\n\nRetrieves an Accounts Payable \\(AP\\) invoice details from Oracle EBS.\n\n
\n\nLook up Invoice Payment Status\n\n\n\nRetrieves the invoice payment status from Oracle EBS.\n\n
\n\nSubmit Invoice - Run Concurrent Program\n\n\n\nSubmits an invoice - run concurrent program in Oracle EBS.\n\n
\n\nJournal Ledger\n\n\n\nCreate Journals\n\n\n\nCreates a journal.\n\n
\n\nGet GL Journal Batch\n\n\n\nRetrieves details of the required GL journal batch.\n\n
\n\nGet GL Journal Header\n\n\n\nRetrieves details of the required GL journal header.\n\n
\n\nGet GL Ledger\n\n\n\nRetrieves details of the required GL ledger.\n\n
\n\nGet GL Subledger Account\n\n\n\nRetrieves details of the required GL subledger account.\n\n
\n\nImport Journals - Run Concurrent Program\n\n\n\nRuns the concurrent program that imports journals data from the interface table to the base table of Oracle EBS.\n\n
\n\nLook up GL Balance\n\n\n\nRetrieves details of the required GL balance based on the input criteria.\n\n
\n\nLook up GL Balances\n\n\n\nRetrieves details of the required GL balance based on the input query.\n\n
\n\nLook up GL Code Combinations\n\n\n\nRetrieves details of the required GL code combinations based on the input query.\n\n
\n\nLook up GL Journals\n\n\n\nRetrieves details of the required GL journals based on the input criteria.\n\n
\n\nLook up GL Ledgers\n\n\n\nRetrieves details of the required GL ledgers based on the input criteria.\n\n
\n\nLook up GL Subledger Accounts\n\n\n\nRetrieves details of the required GL subledger accounts based on the input criteria.\n\n
\n\nPost Journals - Run Concurrent Program\n\n\n\nRuns the concurrent program that posts the unposted journals.\n\n
\n\nReverse Journals - Run Concurrent Program\n\n\n\nRuns the concurrent program that reverses the posted journals.\n\n
\n\nMaster\n\n\n\nCreate Item\n\n\n\nCreates an item.\n\n
\n\nLook up Cost Center\n\n\n\nRetrieves details about the required cost center.\n\n
\n\nLook up Item\n\n\n\nRetrieves details about the required item.\n\n
\n\nLook up Item Category\n\n\n\nRetrieves details about the required item category.\n\n
\n\nUtility Actions\n\n\n\nGenerate Input Payload With Crossreference\n\n\n\nGenerates array type input payload for Create Actions from subflow input payload while assigning configured cross-reference field with the ServiceNow ID\\(s\\).\n\n
\n\nGet Additional EBS Fields\n\n\n\nRetrieves list of fields which can be further used as a dynamic template or dynamic object, based on an input string, Action Internal Name.\n\n
\n\nGet Records\n\n\n\nRetrieves data from any Oracle EBS module using an SQL query.\n\n
\n\nLook up Common Object Details\n\n\n\nRetrieves the common details of the object specified.\n\n
\n\nLook up Concurrent Program Status\n\n\n\nRetrieves the status of a concurrent request.\n\n
\n\nParse OEBS Record Details\n\n\n\nConverts the JSON output of 'Get Records' Action into structured Object format.\n\n
\n\nWait for Request Completion\n\n\n\nWaits until the status of the request completes.\n\n
\n\nTransfer Order Management\n\n\n\nCreate Transfer Order\n\n\n\nCreates a transfer order with the specified details.\n\n
\n\nLook up Transfer Orders\n\n\n\nRetrieves details of the required transfer orders.\n\n
\n\nProcurement\n\n\n\nCreate Goods Receipts\n\n\n\nCreates a goods receipt.\n\n
\n\nGet Advance Shipment Notice\n\n\n\nRetrieves details of the required advance shipment notice.\n\n
\n\nLook up Advance Shipment Notices\n\n\n\nRetrieves details of multiple advance shipment notices based on the input query.\n\n
\n\nAsset Management\n\n\n\nCreate Asset\n\n\n\nCreates an asset with the specified details.\n\n
\n\nLook up Asset Categories Stream\n\n\n\nRetrieves the details of the look up asset categories.\n\n
\n\nSubmit Asset - Run Concurrent Program\n\n\n\nReturns the concurrent status of the specified asset in Oracle EBS.\n\n
\n\nBills and Payments\n\n\n\nLook up Bill Details\n\n\n\nRetrieves details of the required bills.\n\n
\n\nLook up Outstanding Balances\n\n\n\nRetrieves details of the required outstanding balances.\n\n
\n\nLook up Payment Details\n\n\n\nRetrieves details of the required payments.\n\n
\n\nLook up Payment Status\n\n\n\nRetrieves status of the required payments.\n\n
\n\nCustomer\n\n\n\nCreate Customer Account\n\n\n\nCreates a customer account.\n\n
\n\nCreate Customer Account Role\n\n\n\nCreates a customer account role.\n\n
\n\nCreate Customer Contact\n\n\n\nCreates a customer account contact.\n\n
\n\nCreate Customer Relation\n\n\n\nCreates a customer relation record.\n\n
\n\nCreate Person\n\n\n\nCreates a person record.\n\n
\n\nLook up Customer Accounts\n\n\n\nRetrieves details of the required customer accounts.\n\n
\n\nLook up Customer Contacts\n\n\n\nRetrieves the required customer contacts.\n\n
\n\nUpdate Customer Account\n\n\n\nUpdates details of the required customer account.\n\n
\n\nUpdate Customer Contact\n\n\n\nUpdates details of the required customer contact.\n\n
\n\nSales Order\n\n\n\nLook up Sales Order Status Stream\n\n\n\nRetrieves status details of the required sales orders.\n\n
\n\nLook up Sales Order Stream\n\n\n\nRetrieves details of the required sales orders.\n\n
\n\nContract Management\n\n\n\nCreate Contract\n\n\n\nCreates a contract in Oracle EBS.\n\n
\n\nCreate Contract - Run Concurrent Program\n\n\n\nRetrieves the concurrent status of contract in Oracle EBS.\n\n
\n\nPurchase Order Management\n\n\n\nCancel Purchase Order\n\n\n\nCancels the purchase order.\n\n
\n\nCreate Blanket Release\n\n\n\nCreates 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.\n\n
\n\nCreate Blanket Release - Run Concurrent Program\n\n\n\nRetrieves the concurrent status of blanket release in Oracle EBS.\n\n
\n\nCreate Blanket Purchase Agreement\n\n\n\nCreates 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.\n\n
\n\nCreate Purchase Order\n\n\n\nCreates 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.\n\n
\n\nCreate Purchase Order - Run Concurrent Program\n\n\n\nRuns the concurrent program that imports the purchase order data from the interface table to the base table of Oracle EBS.\n\n
\n\nUpdate Blanket Purchase Agreement\n\n\n\nUpdates 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.\n\n
\n\nUpdate Purchase Order\n\n\n\nUpdates 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.\n\n
\n\nReceipt Management\n\n\n\nCancel PO Goods Receipt\n\n\n\nCancels 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.\n\n
\n\nCreate Goods Receipt - Run Concurrent Program\n\n\n\nCreates a good receipt in concurrent program mode.\n\n
\n\nCreate PO Goods Receipt\n\n\n\nCreates a Purchase Order \\(PO\\) goods receipt in Oracle EBS.\n\n
\n\nLook up PO Receipts\n\n\n\nRetrieves purchase order \\(PO\\) receipts from Oracle EBS.\n\n
\n\nUpdate PO Goods Receipt\n\n\n\nUpdates a Purchase Order \\(PO\\) goods receipt in Oracle EBS.\n\n
\n\nSupplier Management\n\n\n\nCreate Bank Account\n\n\n\nCreates a bank account.\n\n
\n\nCreate Supplier\n\n\n\nCreates a supplier in Oracle EBS.\n\n
\n\nCreate Supplier Site\n\n\n\nCreates a supplier site in Oracle EBS.\n\n
\n\nDeactivate Supplier\n\n\n\nDeactivates the specified supplier in Oracle EBS.\n\n
\n\nDeactivate Supplier Site\n\n\n\nDeactivates the specified supplier site in Oracle EBS.\n\n
\n\nLook up Bank Accounts Stream\n\n\n\nRetrieves the supplier bank account details.\n\n
\n\nLook up Supplier Sites Stream\n\n\n\nRetrieves the supplier site details from Oracle EBS.\n\n
\n\nLook up Suppliers Stream\n\n\n\nRetrieves the supplier details from Oracle EBS.\n\n
\n\nUpdate Bank Account\n\n\n\nUpdates the specified bank account in Oracle EBS.\n\n
\n\nUpdate Supplier\n\n\n\nUpdates the specified supplier details in Oracle EBS.\n\n
\n\nUpdate Supplier Site\n\n\n\nUpdates the specified supplier site details in Oracle EBS.\n\n
\n\nVoid Supplier Bank Account\n\n\n\nMakes the supplier bank account as void.\n\n
\n\nPrimary Data Management\n\n\n\nLook up Attachments\n\n\n\nRetrieves the file attachments related to purchase order, supplier, and other specified details from Oracle EBS.\n\n
\n\nLook up Currencies\n\n\n\nRetrieves currency details from Oracle EBS.\n\n
\n\nLook up GL Accounts Stream\n\n\n\nRetrieves GL account details from Oracle EBS.\n\n
\n\nLook up GL Cost Centers Stream\n\n\n\nRetrieves the cost center details from Oracle EBS.\n\n
\n\nLook up GL Daily Rates\n\n\n\nRetrieves GL Daily Rate details from Oracle EBS.\n\n
\n\nLook up GL Ledgers\n\n\n\nRetrieves Ledger details from Oracle EBS.\n\n
\n\nLook up GL Legal Entities\n\n\n\nRetrieves GL Legal Entity details from Oracle EBS.\n\n
\n\nLook up HR Locations Stream\n\n\n\nRetrieves the details of HR locations from Oracle EBS.\n\n
\n\nLook up Inventory Items Stream\n\n\n\nRetrieves the inventory item details from Oracle EBS.\n\n
\n\nLook up Item Categories Stream\n\n\n\nRetrieves the item category details from Oracle EBS.\n\n
\n\nLook up Operating Units\n\n\n\nRetrieves Operating Unit details from Oracle EBS.\n\n
\n\nLook up Payment Terms\n\n\n\nRetrieves payment term details.\n\n
\n\nLook up Purchase Groups\n\n\n\nRetrieves Purchasing Group details from Oracle EBS.\n\n
\n\nLook up Purchasing Organizations\n\n\n\nRetrieves Purchasing Organization details from Oracle EBS.\n\n
## Connection and credential alias requirements\n\nIntegration 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](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/platform-security/r-credentials.md).\n\nFor information about setting up the spoke, see [Set up the Oracle EBS spoke](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/integrate-applications/integration-hub/setup-oebs-spoke.md).\n\n## MID Server requirements\n\nThese 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](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/integrate-applications/integration-hub/integration-steps.md).\n\n**Note:** If your Oracle EBS instance is only accessible on a private network, you must use MID Server.\n\nTo set up the MID Server for this spoke, see [Set up MID Server for a spoke](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/integrate-applications/integration-hub/config-adv-mid-settings-for-oauth-on-mid.md).\n\n"}}