Transportation Management

Get Involved. Join the Conversation.

Topic

    Ashok Revuri
    OTM Rate Inquiry XML (input)
    Topic posted September 4, 2019 by Ashok RevuriGreen Ribbon: 100+ Points, tagged Integration, Rate Management 
    36 Views, 5 Comments
    Title:
    OTM Rate Inquiry XML (input)
    Summary:
    I am looking for Rate Inquiry (Remote Query) input sample xml
    Content:

    Does anybody has - Rate Inquiry input xml of latest version? i just need a sample one.

    Appreciate your support

    Comment

     

    • amiresi sathish
       
      
      Please find the sample rate inquiry XML
      
      <Transmission>
      
          <TransmissionHeader>
      
              <TransmissionType>QUERY</TransmissionType>
      
              <TransactionCount>1</TransactionCount>
      
              <UserName>PPGTM.SATHISH</UserName>
      
              <Password>******</Password>
      
              <AckSpec>
      
                  <ComMethodGid>
      
                      <Gid>
      
                          <Xid>HTTPPOST</Xid>
      
                      </Gid>
      
                  </ComMethodGid>
      
                  <AckOption>YES</AckOption>
      
              </AckSpec>
      
          </TransmissionHeader>
      
          <TransmissionBody>
      
              <GLogXMLElement>
      
                  <RemoteQuery>
      
                      <RIQQuery>
      
                          <SourceAddress>
      
                              <MileageAddress>
      
                                  <LocationGid>
      
                                      <Gid>
      
                                          <DomainName>PUBLIC</DomainName>
      
                                          <Xid>NYC</Xid>
      
                                      </Gid>
      
                                  </LocationGid>
      
                              </MileageAddress>
      
                          </SourceAddress>
      
                          <DestAddress>
      
                              <MileageAddress>
      
                                  <LocationGid>
      
                                      <Gid>
      
                                          <DomainName>PUBLIC</DomainName>
      
                                          <Xid>BDL</Xid>
      
                                      </Gid>
      
                                  </LocationGid>
      
                              </MileageAddress>
      
                          </DestAddress>
      
                          <RateOfferingGid>
      
                              <Gid>
      
                                  <DomainName>PPGTM</DomainName>
      
                                  <Xid>DEFAULT_LTL</Xid>
      
                              </Gid>
      
                          </RateOfferingGid>
      
                          <RateGeoGid>
      
                              <Gid>
      
                                  <DomainName>PPGTM</DomainName>
      
                                  <Xid>DEFAULT_LTL_US</Xid>
      
                              </Gid>
      
                          </RateGeoGid>
      
                          <RateServiceGid>
      
                              <Gid>
      
                                  <DomainName>PPGTM</DomainName>
      
                                  <Xid>DISTANCE_DURATION</Xid>
      
                              </Gid>
      
                          </RateServiceGid>
      
                          <TransportModeGid>
      
                              <Gid>
      
                                  <Xid>LTL</Xid>
      
                              </Gid>
      
                          </TransportModeGid>
      
                          <UseRIQRoute>N</UseRIQRoute>
      
                          <ShipUnit>
      
                              <ShipUnitGid>
      
                                  <Gid>
      
                                      <DomainName>PUBLIC</DomainName>
      
                                      <Xid>123456</Xid>
      
                                  </Gid>
      
                              </ShipUnitGid>
      
                              <ShipUnitSpecGid>
      
                                  <Gid>
      
                                      <DomainName>PUBLIC</DomainName>
      
                                      <Xid>DEFAULT</Xid>
      
                                  </Gid>
      
                              </ShipUnitSpecGid>
      
                              <WeightVolume>
      
                                  <Weight>
      
                                      <WeightValue>100.0</WeightValue>
      
                                      <WeightUOMGid>
      
                                          <Gid>
      
                                              <Xid>LB</Xid>
      
                                          </Gid>
      
                                      </WeightUOMGid>
      
                                  </Weight>
      
                                  <Volume>
      
                                      <VolumeValue>0.5000</VolumeValue>
      
                                      <VolumeUOMGid>
      
                                          <Gid>
      
                                              <Xid>CUFT</Xid>
      
                                          </Gid>
      
                                      </VolumeUOMGid>
      
                                  </Volume>
      
                              </WeightVolume>
      
                          </ShipUnit>
      
                      </RIQQuery>
      
                  </RemoteQuery>
      
              </GLogXMLElement>
      
          </TransmissionBody>
      
      </Transmission>
      
    • Ashok Revuri

      Thanks Satish.

      While i try to upload this xml in OTM. i am getting below error. Have you encountered this before?

      glog_error id="[001391]">
          <log_timestamp>2019-09-04 10:22:24.690</log_timestamp>
          <process>
              <machine/>
              <gid>350464</gid>
              <start>2019-09-04 10:22:24.641</start>
          </process>
          <causes>
              <cause>
                  <error>java.lang.IllegalStateException: java.lang.IllegalArgumentException: null java.sql.Connection</error>
              </cause>
          </causes>
          <stack_trace>[001391] java.lang.IllegalStateException: java.lang.IllegalArgumentException: null java.sql.Connection
       
      java.lang.IllegalStateException: java.lang.IllegalArgumentException: null java.sql.Connection
      at glog.integration.transmission.TransmissionDBReader.open(TransmissionDBReader.java:57)

       

    • Ashok Revuri

      yes, i did :)

      • amiresi sathish

        Seems something wrong with accessing XML info to DB, I just tried same XML in my instance it worked for me.

        </RIQQuery>
                       <RemoteQueryStatus>
                          <RemoteQueryStatusCode>ERROR</RemoteQueryStatusCode>
                          <RemoteQueryStatusSubject>RateActionSession Exception</RemoteQueryStatusSubject>
                          <RemoteQueryStatusMessage>ERROR PROCESSING RATE INQUIRY</RemoteQueryStatusMessage>
                          <StackTrace>[002804] No Valid Rates Found