Introduction to Oracle ERP
Oracle E-Business Suite is a comprehensive enterprise application suite covering financials, order management, procurement, human capital management, and asset lifecycle management for large organizations.
Used by large enterprises and global organizations running complex, high-volume business operations
Common in manufacturing, government, healthcare, and financial services industries with long-established Oracle environments
Connecting Oracle EBS to iPaaS.com enables critical business data, including orders, customers, inventory, and financials to move reliably between your ERP and Ecommerce, fulfillment, and other systems in your tech stack
API Version Support
The integration works with Oracle E-Business Suite through its REST services, reached at your Oracle environment's host with the credentials configured in your subscription's connection settings. Because Oracle EBS does not push live events for these flows, records are captured on a recurring poll and on demand through a Manual Sync. See the Oracle ERP Connections and Settings and Oracle ERP API Endpoints articles for details.
Data Flows
The table below summarizes the data the integration can move between iPaaS.com and Oracle ERP, and in which direction. Arrows show the direction of transfer:
→ iPaaS.com writes the data to Oracle ERP
← iPaaS.com reads the data from Oracle ERP
←→ the data can move in both directions
Allow Initialization? indicates whether that data can be bulk-loaded from Oracle ERP when a subscription first connects. Whether a given flow is enabled, and in which direction, is configured per subscription during implementation.
iPaaS.com | Direction | Oracle ERP | Allow Initialization? |
Product | ← | Item | |
Product Inventory | ← | Item Inventory | |
Customer Company | ← | Company | |
Sales Order | ←→ | Sales Order |
Oracle E-Business Suite supplies items and inventory, customer companies, and sales orders to iPaaS.com, and iPaaS.com writes sales orders back into Oracle. Sales orders carry their line items, addresses, and shipment tracking.
Versions and Release Notes
The integration follows its own version numbers. The current version is 1.0.
Version | Release Notes |
1.0 (current) | Initial release: capture of items and inventory, customer companies, and sales orders from Oracle E-Business Suite, and sales orders written back to Oracle. |
Features by Release
The capabilities below are grouped by the version in which they became available. For the current behavior and any limitations of a given feature, see the linked reference articles and the Oracle ERP Known Limitations article.
Version 1.0 (current) — Enterprise ERP catalog, customers, and orders
Items and inventory: item (product catalog) and inventory records captured from Oracle E-Business Suite into iPaaS.com.
Customer companies: customer company and address records captured from Oracle E-Business Suite.
Sales orders: sales orders — with their line items, addresses, and shipment tracking — captured from Oracle E-Business Suite, and written back to Oracle from iPaaS.com.