Demo- Demo in the Post is about How to Delete the Sales Order line from Oracle Order Management System using Web-Service designed by means of Oracle AS Adapter.
OracleAS Adapter for Oracle Applications provides comprehensive, bidirectional, multimodal, synchronous, and asynchronous connectivity to Oracle Applications. The Adapter supports Release 12 and Release 11i of E-business Suite.
OracleAS Adapter for Oracle Applications enables you to orchestrate discrete data into a meaningful business process and creates WSDL Web services for various interface types within Oracle E-Business Suite. It plays the role of service provider for Oracle E-Business Suite to allow seamless integration between business partners, processes, applications, and end users in heterogeneous environment.
These adapters supports the following interface types for integrating with Oracle Applications:
- Oracle XML Gateway
- Business events
- Concurrent programs
- Interface tables
- PL/SQL APIs
In this post I will cover about how to create Web Service from Oracle application Standard Public PL/SQL API.I used Oracle JDeveloper to Created the WSDL web Service Will discuss other types in coming posts.
In the Below youtube Demo I have
- Created a Web Service with Oracle AS Adapter to Delete the Open Sales Order line.
- Designed a BPEL process to Invoke the Web Service as partner link.
- Deploy the BPEL Process.
- Test the BPEL Flow.