Oracle Global Trade Management (MOSC)

MOSC Banner

How to get GTMTrasaction data using RemoteQuery Interface

edited May 6, 2016 9:16PM in Oracle Global Trade Management (MOSC) Question

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>

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center