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