How to get GTMTrasaction data using RemoteQuery Interface
Hi All,
Using the RemoteQuery Interface, I could able to get the Contact, item data. But I can't able to get the GtmTransaction data using it.
Below is the XML which I used. Please help me on this
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<Transmission>
<TransmissionHeader xmlns:otm="http://xmlns.oracle.com/apps/otm">
<UserName/>
<Password/>
<SenderSystemId/>
<GLogXMLElementName/>
<TransmissionType>QUERY</TransmissionType>
<QueryReplyFormat>Transmission</QueryReplyFormat>
<AckSpec>
<AckOption>YES</AckOption>
</AckSpec>
</TransmissionHeader>
<TransmissionBody>
<GLogXMLElement>
<RemoteQuery>
<GenericQuery xmlns:gtm="http://xmlns.oracle.com/apps/gtm">
<GLogXMLTransaction>
<gtm:ElementName>GtmTransaction</gtm:ElementName>
<gtm:SqlQuery>SELECT gtm_transaction_GID FROM gtm_transaction WHERE gtm_transaction_gid='<Object_gid>'</gtm:SqlQuery>