1 Reply Latest reply: Mar 31, 2012 8:42 AM by 677284 RSS

    Invoke RIQQuery in OTM using webservice

    677284
      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
          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>