This discussion is archived
1 Reply Latest reply: Mar 31, 2012 6:42 AM by 677284 RSS

Invoke RIQQuery in OTM using webservice

677284 Newbie
Currently Being Moderated
First of all, I can get the expected results from the Rate Inquiry page, only by setting the shipfrom and shipto location.

But when I try to invoke the RIQQuery by using webservice, I cannot get the TransmissionBody back.

I tracked the log for above operations and they are almost the same exception for some line difference at the end.

Thanks in advance for any suggestions!

From web page:
2012-03-31 14:59:01.240     0     Debug     Workflow     Starting workflow Process Control (24809199) in response to 10s: 2012-03-31 06:59:01 Asia/Shanghai [timer - 1]
2012-03-31 14:59:01.243     0     Debug     Workflow     Completing workflow Process Control (24809199) [timer - 1]

From web service:
2012-03-31 15:00:11.691     793084     Debug     Workflow     Completing workflow Simple Workflow (25806349) [publishWait - 4]
2012-03-31 15:00:11.693     793084     Debug     Workflow     Publishing topic PostTransmission: user=GUEST.ADMIN, transmissionId=285 on queue integrationOutbound, group null [publishWait - 4]
2012-03-31 15:00:11.695     793084     Debug     Workflow     Starting workflow Simple Workflow (24159432) in response to PostTransmission: user=GUEST.ADMIN, transmissionId=285 [integrationOutbound - 1]
2012-03-31 15:00:11.785     793084     Debug     Workflow     Completing workflow Simple Workflow (24159432) [integrationOutbound - 1]
  • 1. Re: Invoke RIQQuery in OTM using webservice
    677284 Newbie
    Currently Being Moderated
    Also below is my transmission code:

    <SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:SOAP-ENC="http://schemas.xmlsoap.org/soap/encoding/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
         <SOAP-ENV:Body>
              <m:Transmission xmlns:m="http://xmlns.oracle.com/apps/otm">
                   <m:TransmissionHeader>
                        <m:UserName>GUEST.ADMIN</m:UserName>
                        <m:Password>CHANGEME</m:Password>
                        <m:AckSpec>
                             <m:ComMethodGid>
                                  <m:Gid>
                                       <m:Xid>HTTPPOST</m:Xid>
                                  </m:Gid>
                             </m:ComMethodGid>
                             <m:ServletURL>http://10.182.206.128:7001/WebDemo/testservlet</m:ServletURL>
                             <m:AckOption>YES</m:AckOption>
                             <m:ContactGid>
                                  <m:Gid>
                                       <m:Xid>EBS.3540</m:Xid>
                                  </m:Gid>
                   </m:ContactGid>
                        </m:AckSpec>
                   </m:TransmissionHeader>
                   <m:TransmissionBody>
                        <m:GLogXMLElement>
                             <m:RemoteQuery>
                                  <m:RIQQuery>
                                       <m:SourceAddress>
                                            <m:MileageAddress>
                                                 <m:City>MELBOURNE</m:City>
                                                 <m:LocationGid>
                                                      <m:Gid>
                                                           <m:DomainName>GUEST</m:DomainName>
                                                           <m:Xid>MEL1</m:Xid>
                                                      </m:Gid>
                                                 </m:LocationGid>
                                                 <m:ProvinceCode>VI</m:ProvinceCode>
                                                 <m:CountryCode3Gid>
                                                      <m:Gid>
                                                           <m:Xid>AUS</m:Xid>
                                                      </m:Gid>
                                                 </m:CountryCode3Gid>
                                            </m:MileageAddress>
                                       </m:SourceAddress>
                                       <m:DestAddress>
                                            <m:MileageAddress>
                                                 <m:City>SYDNEY</m:City>
                                                 <m:LocationGid>
                                                      <m:Gid>
                                                           <m:DomainName>GUEST</m:DomainName>
                                                           <m:Xid>SYD1</m:Xid>
                                                      </m:Gid>
                                                 </m:LocationGid>
                                                 <m:ProvinceCode>NS</m:ProvinceCode>
                                                 <m:CountryCode3Gid>
                                                      <m:Gid>
                                                           <m:Xid>AUS</m:Xid>
                                                      </m:Gid>
                                                 </m:CountryCode3Gid>
                                            </m:MileageAddress>
                                       </m:DestAddress>
                                       <m:ShipUnit>
                                            <m:WeightVolume>
                                                 <m:Weight>
                                                      <m:WeightValue>0</m:WeightValue>
                                                      <m:WeightUOMGid>
                                                           <m:Gid>
                                                                <m:Xid>LB</m:Xid>
                                                           </m:Gid>
                                                      </m:WeightUOMGid>
                                                 </m:Weight>
                                                 <m:Volume>
                                                      <m:VolumeValue>0</m:VolumeValue>
                                                      <m:VolumeUOMGid>
                                                           <m:Gid>
                                                                <m:Xid>CUFT</m:Xid>
                                                           </m:Gid>
                                                      </m:VolumeUOMGid>
                                                 </m:Volume>
                                            </m:WeightVolume>
                                       </m:ShipUnit>
                                  </m:RIQQuery>
                             </m:RemoteQuery>
                        </m:GLogXMLElement>
                   </m:TransmissionBody>
              </m:Transmission>
         </SOAP-ENV:Body>
    </SOAP-ENV:Envelope>

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points