Oracle Cloud offers a broad portfolio of software as a service applications, platform as a service, and social capabilities, all on a subscription basis. Oracle Cloud delivers instant value and productivity for end users, administrators, and developers alike through functionally rich, integrated, secure, enterprise cloud services.
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

Subscribe to the OracleAppsHub to receive notifications when there are new posts:

 get RSS feed
 Oracle Fusion Applications (OFA) is a portfolio of next generation suite of software applications from Oracle Corporation. It is distributed across various product families; including financial management, human capital management, customer relationship management, supply chain management, procurement, governance, and project portfolio management
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

eCommerce Gateway

Posted on September 21st, 2011 by Sanjit Anand ||Email This Post Email This Post

Have you tried OracleappsHub in ipad/iphone/smart Phone? Don't wait. try it today

There are are the two out-of-box integration capabilities for E2E available in Oracle Applications:

  • Oracle E-Commerce Gateway (formerly EDI Gateway)
  • Oracle XML Gateway

if you are new about EDI , refer to this post

dgreybarrow Oracle E-Commerce Gateway

eCommerce Gateway enables to expose internal business objects in a standardized format thus the trading partners integrate with the external business objects to send/receive information to/from Oracle E-Business Suite”

  • Support EDI Transactions
  • Executes Batch Processing
  • ASCII file format
  • Interface Files are EDI Standards Independent
  • EDI Translator is required
  • eCommerce Gateway interface is a Concurrent Program Packaged ‘Out of the Box’ key business transactions

A typical Transactional Flow can be best understood as in context of Ecommerce Gateway is as below:



Oracle e-Business Suite in conjunction with Oracle e-Commerce Gateway supports 23 EDI transactions. Oracle e-Business Suite generates and consumes ASCII flat files.

The ASCII flat files are sent to/received from a third party EDI translator who transforms the flat file content into the ASC X12 or EDIFACT equivalent. ASC X12 is the EDI standard for North America and Canada. EDIFACT is the EDI standard for Europe and Asia.

  • Purchasing
    • Outbound 850/ORDERS
    • Outbound 860/ORDCHG
    • Inbound 832/PRICAT
    • Inbound 843/QUOTES
    • Inbound 856/857/DESADV
    • Outbound 824/APERAK
  • Order Management
    • Inbound 850/ORDERS
    • Inbound 875/ORDERS
    • Outbound 855/ORDRSP
    • Inbound 860/ORDCHG
    • Outbound 865/ORDRSP
  • Shipping
    • Outbound 856/DESADV
  • Inventory
    • CUSDEC (No ASCX12 equivalent)
  • Payables
    • Inbound 810/INVOIC
    • Outbound 820/PAYORD-REMADV
    • Outbound 824/APERAK
  • Receivables
    • Outbound 810/INVOIC
    • Outbound 812/DEBADV-CREADV
  • Supplier Scheduling
    • Outbound 830/DELFOR
    • Outbound 862/DELJIT
  • Release Management
    • Inbound 830/DELFOR
    • Inbound 862/DELJIT
    • Inbound 866 (No EDIFACT equivalent)

Next we will have a look on XML gateway.

Related Posts

Posted in EDI, Integration | No Comments »Email This Post Email This Post |

Have you tried OracleappsHub in ipad/iphone/smart Phone? Don't wait. try it today
Leave a Comment

Please note: Comment moderation is enabled and may delay your comment. There is no need to resubmit your comment.