ERP integration · Oracle

Oracle E-Business Suite EDI and B2B integration

EDI integration for Oracle E-Business Suite through e-Commerce Gateway, open interfaces and XML Gateway.

Integration supported
Implementation services available
Cloud, on-premises or hybrid

Discuss your Oracle E-Business Suite integration ERP implementation services

Overview

Connecting Oracle E-Business Suite with your trading partners

Oracle E-Business Suite includes several mechanisms for exchanging business documents with trading partners. The e-Commerce Gateway produces and consumes flat files that an EDI translator converts to and from X12 or EDIFACT, while open interface tables, such as those used by Order Import, let external systems load transactions that EBS then validates and processes. XML Gateway and Integrated SOA Gateway add XML messaging and web service options.

ECOM integrates EBS with trading partners through PRISM or IBM Sterling, choosing the interface that fits each document and your existing customizations. ECOM also provides EBS implementation and upgrade support, so partner integrations stay aligned with ERP changes.

Read the in-depth guideOracle E-Business Suite EDI integration guide: e-Commerce Gateway and open interfaces

Methods

Integration approaches for Oracle E-Business Suite

e-Commerce Gateway

EBS module that generates and imports flat files for standard EDI transactions.

Open interface tables

Staging tables and concurrent programs, such as Order Import, that validate and create transactions.

XML Gateway

XML-based messaging for business documents, including OAGIS-style messages.

Integrated SOA Gateway

Exposes EBS business services as REST or SOAP web services.

Document mapping

How EDI documents map to Oracle E-Business Suite

Typical mappings between common X12 documents and Oracle E-Business Suite business objects. Actual designs depend on your configuration and partners.

EDI document	Oracle E-Business Suite object	Direction
850 Purchase Order	Sales order (Order Import)	Into Oracle E-Business Suite
855 Order Acknowledgment	Order acknowledgment	From Oracle E-Business Suite
856 Advance Ship Notice	Shipping confirmation	From Oracle E-Business Suite
810 Invoice	Receivables invoice	From Oracle E-Business Suite

Planning

Implementation considerations

Customizations
Many EBS instances have custom extensions that affect which interface is safest to use.
Concurrent processing
Inbound interfaces depend on concurrent programs, so scheduling and error handling must be planned.
Upgrade path
Integration choices should account for future EBS upgrades or a move to Oracle Fusion Cloud ERP.

Trading partners