In Oracle Cloud, you can pass through the actual client IP from a load balancer by configuring the load balancer to use the “Client IP”…
Leave a CommentCategory: Apps(11i, R12) Basics
Most Oracle DBA & Oracle Apps DBAs are already aware that the technology world is moving fast and that is a fact that no one…
Leave a CommentInactive Connection Timeout is a feature in WebLogic that allows you to configure the amount of time a connection can be inactive before it is…
Leave a CommentWorkflow Deferred Agent Listener is a background process that is responsible for processing the deferred workflow activities. This process is automatically started when the system…
1 CommentPurge ATP Temp Tables is a concurrent program in Oracle EBS R12.2 that is used to clean up temporary tables created by the Advanced Planning…
Leave a CommentIn this post we will discuss on key steps that we need to follow to install Integrated SOA Gateway (ISG) on a standalone SOA Weblogic server.
Oracle E-Business Suite Integrated SOA Gateway (ISG) enables supported interface types published in Oracle Integration Repository. These interfaces can be transformed into SOAP and REST web services.
Oracle E-Business Suite SOAP Services
- SOAP-based web services are deployed on Oracle SOA Suite running on Oracle WebLogic Server
- Steps to configure SOAP services span across Oracle E-Business Suite as well as Oracle SOA Suite
- Interface types enabled for SOAP services are PL/SQL, Concurrent Program, XML Gateway (Inbound), and Business Service Object.
1 Comment
Oracle E-Business Suite Integrated SOA Gateway is the intrinsic part of Oracle Ebusiness Suite for service enablement.
Key points:
- A central location where all service related business interfaces are stored
- All application users can browse through these business interfaces to know what type of services are available for service consumption.
- Provides a complete catalog of integration interfaces within Oracle E-Business Suite.
- Any changes in interface definitions and descriptions are automatically reflected with EBS release
- Displays each interface details including source information, methods within the interface, and Web service information if the interface can be service enabled.
- Supports custom integration interfaces
- Enforces security rules to allow only authorized users to perform administrative tasks
We already described in earlier post what is web service. Service enablement is one of the “essential features” or “process flow” in Oracle E-Business Suite Integrated SOA Gateway. You can say it is that “magic ingredient” which allows native packaged integration interface definitions written in PL/SQL, Java, and other formats and stored in Oracle Integration Repository to be transformed into Web services.
“Service enablement” involves:
- Generating service artifacts, such as XSD
- To validate XML messages, WSDL or WADL to describe the Web service,
- Deploying web services on an application server so that the services are available to clients over the Web.
Before going into ISG Concepts, it is important to briefly understand what is a Web Service and some other related terms which can be new for beginner.
Web Services:
- Web Service in simple terms is a “software system” for machine-to-machine interaction over a network.
- Its interface is described in certain format which can be processed by machine.
- WSDL is one kind of interface format which can be created using SOAP messages
- WADL is another kind of interface format created using REST messages
- Web Services are self-describing, reusable software components encapsulating discrete functionality. Example: Employee creation can be one self-contained web service.
Leave a Comment
In our EBS system, we found that SYSADMIN login was slow. It was taking around 4-5 minutes to login and when inside the EBS application it was taking 2-3 minutes every time we were navigating in the self-service pages. This issue was not occurring for normal EBS users. We thought of applying the trace to SYSADMIN user to find the root cause of it.
2 Comments