Message Schemas for the Polling Operations
The Microsoft BizTalk Adapter for Oracle E-Business Suitesurfaces various inbound operations related to polling depending on the target object in Oracle E-Business Suite. For interface tables, interface views, tables, and views, a single Poll operation is surfaced whereas you can have multiple custom polling operations for PL/SQL APIs, functions, and stored procedures.
You configure the polling operations by setting binding properties in the Oracle E-Business adapter. For more information about these binding properties, see Read about the BizTalk Adapter for Oracle E-Business Suite binding properties. You set the PollingStatement binding property to specify a SQL statement, stored procedure, function or a procedure within a package for the polling query. The result set of this query is returned as data to your code in the polling operation.
Message Structure for the Polling Operations
The following table shows the XML message structure for the various polling operations.
Note
See entity descriptions after the table.
| Operation | Target Object | XML Message | Description |
|---|---|---|---|
| Poll | - Interface Tables - Interface Views - Tables - Views |
<?xml version="1.0" encoding="utf-8" ?> <Poll xmlns="[Version]/[TargetObject]/[Schema]/[TargetObject_Name]"> <DATA> <SelectRecord> <Column1>[Value]</Column1> <Column2>[Value]</Column2> … </SelectRecord> </DATA> </Poll> |
For example, the XML message for the Poll operation on Interface Tables will be as follows:<?xml version="1.0" encoding="utf-8" ?> <Poll xmlns="[Version]/InterfaceTables/[Schema]/[InterfaceTable_Name]"> <DATA> <SelectRecord> <Column1>[Value]</Column1> <Column2>[Value]</Column2> … </SelectRecord> </DATA> </Poll> |
| [CustomPollingOperation] | - PL/SQL APIs - Stored Procedures - Functions |
PL/SQL APIs<?xml version="1.0" encoding="utf-8" ?> <[CustomPollingOperation] xmlns="[Version]/PollingPackageAPis/[Schema]/[PL/SQL API]"> <[CustomPollingOperation]Result>[Value]</[CustomPollingOperation]Result> </[CustomPollingOperation]>Functions <?xml version="1.0" encoding="utf-8" ?> <[CustomPollingOperation] xmlns="[Version]/PollingFunctions/[Schema]"> <[CustomPollingOperation]Result> <COL1>[Value]</COL1]> <COL2>[Value]</COL2> … </[CustomPollingOperation]Result> </[CustomPollingOperation]>Stored Procedures <?xml version="1.0" encoding="utf-8" ?> <[CustomPollingOperation] xmlns="[Version]/PollingFunctions/[Schema]"> <[CustomPollingOperation]Result> <PRM1>[Value]</PRM1> <PRM2>[Value]</PRM2> … </[CustomPollingOperation]Result> </[CustomPollingOperation]> |
The structure of the result set in the polling operation is determined by the data type of the elements in the target object. |
Entity descriptions:
[Version] = http://schemas.microsoft.com/OracleEBS/2008/05.
[CustomPollingOperation] = Name of the custom polling operation.
[Schema] = Name of the Oracle schema. For example, SCOTT.
[PL/SQL API] = Name of the PL/SQL API on which a custom polling operation is performed.
See Also
Messages and Message Schemas for BizTalk Adapter for Oracle E-Business Suite