Advanced Queue integration overview

Advanced Queue is an interface type in Oracle E-Business Suite. It allows outbound integration with Oracle E-Business Suite and helps in transferring data to the application. It also interacts with the Oracle advanced queue. The interface services contain a common standard-based approach for integration between Oracle E-Business Suite and other third-party applications (Example: Enterprise Application Integration).

IBM® WebSphere® Adapter for Oracle E-Business Suite supports the advanced queue feature, which integrates Oracle E-Business Suite with other EIS. When the advanced queue interface is selected, the adapter generates the advanced queue header and payload business objects. Using the external service wizard you can create the advanced queue header and payload business object to start outbound or inbound at runtime.

Note: Oracle advanced queue integration is applicable for IBM Business Process Manager or WebSphere Enterprise Service Bus only.

WebSphere Adapter for Oracle E-Business Suite creates a dynamic SQL script, which uses some Oracle AQ PL/SQL API to enqueue or dequeue. After sending the business data to Oracle E-Business Suite by starting the runtime method, you can use Oracle E-Business Suite's import request to import such business data. Messages can be queried using standard SQL. This means SQL can be used to access the message properties, the message history, and the payload.

There are few supporting terms used in this feature, which are described as follows:

Queue Header contains the properties that are used in enqueue and dequeue operation. In the enterprise metadata discovery process, these properties are populated with the sample value based on the property type (Example: string, integer). The sample value with an incorrect property type causes failure in the runtime. Example: Priority (int), Delay (int), and Correlation (string).
Queue table Payload is an Oracle PL/SQL type that contains the business information required for the business process in advanced queue integration. The adapter will generate the BO for it after configuring the module for the advanced queue integration.
Queue Name is the name of Oracle advanced queue, which receives and send out the integration data.