Remote Query Reply Interface not sending data to an External system

[nikesh mohanlal]

Hi All,
Client: ALLEX
Version: 5.5 CU4
Urgency: Yes
The client wants sends request data(RemoteQuery) to OTM from an external system.
I know that OTM receives it and then process it and then send the REmoteQueryReply back to external system automatically with the help of RemoteQueryReply interface and also read the Integration guide.
But, somehow the data(RemoteQuery reply) is not sent back to an External system.
Is there any procedure to check the procedure for sending from external system and receiveing data to an externsl system?
Also,is an outbound transmission is displayed as an response to an inbound transmission, in the above case.
The client has used a Java program which creates the XML conforming to OTM Schema standard and it is sent to OTM.
Also, here the case is that the externsl system is the Application server.Something that the data is come from the Java file present in the Application server and sent back to application server.
Please let me know what is the correct steps to get the reply back to OTM.
From the log files, it looks like that somewhere some data is missing in the configurationby which the prepared result is not able to sent to an external system.
Attached file is for reference.
Kindly let me know at the earliest.
Thanking in advance.
Regards,
Nikesh.

[MURTHYKO]

Re: Remote Query Reply Interface not sending data to an External system

Could you pls update the external system you created?

- Lakshman

[nikesh mohanlal]

Re: Remote Query Reply Interface not sending data to an External system

Murthyko,

I am sorry I did not get you.
If you need external system details,kindly have a look into the attached word document.
I have got some update,as that the data sent to OTM has source location and destination location in Japanese characters.Do by default, the data sent to OTM in XML supports 'UTF-8' standard or we need to explicitly specify when we send the data.Also the Sender hostname is to be included when we send the RemoteQuery. I think to get the RemoteReplyQuery, we need to configure itineraries,rates,locations and shipment related information in OTM,then only it will fetch the data back. If the data is sent via RemoteReplyQuery Interface, will an entry be made in Outbound transmission manager?

Please let me know at the earliest.
I am new to this integration topic.Any documents or supporting pre-requiste will be helpful to understand in-depth.

Also attaching the latest application log files for reference.

Thanks.

Regards,
Nikesh.

[MURTHYKO]

Re: Remote Query Reply Interface not sending data to an External system

Hi Nikesh,

Thanks for the prompt reply. I would like to know how exactly you created your wsdl url, in the document. I was facing problem at that point.

Thanks & Regards,
Lakshman

[nikesh mohanlal]

Re: Remote Query Reply Interface not sending data to an External system

It works fine for the outbound transmission only.but when I do using the Remotequery interface, I face this problem. Can you discuss the problem you had and the solution, so that I can get more details.The client is asking what all should be the mandatory input requiremnets to send data from one system to OTM and receive it back.May be if you don't mind, kindly send me the Remote QueryXML, so that I shall understand the structure of the XML and then say them to test it. This is a generic concept and I thinkk the data is not sent properly to OTM or any set up is not configured properly in OTM..
Regards,
Nikesh.

[MURTHYKO]

Re: Remote Query Reply Interface not sending data to an External system

Dear Nikesh,

My requirement is client want to know "what would be the LTL rate for a given TL type of shipment. As we are using Czarlite for LTL rates, we want to hi that through Remote Query and get the response and store in a custom table and provide as a report". Could you pls help me how can i achieve this functionality. I am attching the Remote Query XML here.

Cheers,
Lakshman

[MURTHYKO]

Re: Remote Query Reply Interface not sending data to an External system

Forgot to attach the xml. sorry.

[nikesh mohanlal]

Re: Remote Query Reply Interface not sending data to an External system

Hi,

Tnaks for the sent file.
I had seen and checked out that there were some parameters not sendt properly.
Let me know if this si the right transmission xml to be sent to OTM.
I need to send the data to OTM and get it back with the help of Web Service.
Also,please note that the characters used are some Japanese characters.

Please let me know where to be change?
This is the standard feature of OTM.

Regards,
Nikesh.

[MURTHYKO]

Re: Remote Query Reply Interface not sending data to an External system

Hi Nikesh,

I am also trying for the first time. I prepared the xml based on the XSd and inputs I am passing from OTM front end in Rate Inquiry.

In case if you can send the details of "Servlet" and "WSDL" of Rate Inquiry, that you would be a great help for me.

Could you Pls share you "WSDL Document" setup in OTM, which may help me somehow.

Cheers,
Lakshman

[MURTHYKO]

Re: Remote Query Reply Interface not sending data to an External system

Nikesh,

Could you pls send me the corrected XML to me?

--Lakshman

[nikesh mohanlal]

Re: Remote Query Reply Interface not sending data to an External system

Hi,

Version: CU 5

Did you get any solution?
I would require a document on how the whole process flows?
Below is the scenario as described below:There is an external system and an OTM instance.Now we need to fetch the Rates and Routes for a given locations(Ship From and Ship To given in the input),along with the shipment related information from OTM.We have manually tested the xml file with uploading it in OTM(uplaoding the xml file action present in Integration manager menu) and on uploading it we get the response i.e.,RemoteQueryReply instantly.So we make sure that RemoteQuery and RemoteQueryReply standard OTM interface works fine.Please let me know if this process is wrong ?Now the input data in xml comes to OTM as inbound transmission(see the attached file for details).Now when the input xml comes from the external system, an entry is marked as inbound transmission.And then the RemoteQueryreply interface calculates the rates and routes.Then it should send the reply back data to the external system.So is there any way to check out in OTM(ex:some entries in Transmission manager), that the rates and routes is calculated and send back to OTM.Also,how the whole process flows a brief description ,if given will be a guiding document.Any specific logs to check whether the data is sent or not.Please let me know how to check the conformity of the RemoteQuery and remoteQueryReply interface works out and to check,if OTM functionality works fine or not in OTM.Any idea how to take over on this.

[nikesh mohanlal]

Re: Remote Query Reply Interface not sending data to an External system

Hi,
Can anyone let me know if there is any record added for succesful transmission of RIQ Query process(I mean inbound into otm and outbound from otm to ana external system).
I know for inbound it is there,but for outbound?
It's bit urgent.
Regards,
Nikesh.

[otmuser]

Re: Remote Query Reply Interface not sending data to an External system

Lakshman,

Were you be able to get LTL rates when you used the RIQRequest XML file.My problem is I am not getting the LTL rates for a given OD pair when i upload the request xml.What all i get is only the TL rates.Somehow the request is not considering the NMFC code or the Flexcommodity qualifier gid on the xml.I would like to know the right XPath for that GID

[josephliang]

Re: Remote Query Reply Interface not sending data to an External system

1. AckSpec only supports EMAIL, QUEUE and HTTPPOST as ComMethods
2. RemoteQuery interface does not support AckSpec

We had submitted an ER last year for the same requirement. However, Oracle has no plan to include this in future releases yet.

[jpavankumar_apps]

Re: Remote Query Reply Interface not sending data to an External system

Hi ,

I have configured rate offering and rate record in OTM 5.5. Iam able to do Rate inquiry from OTM. But while sending the same details that i have passed in Rate Inquire through OTM, through Remote Query XML request getting Exception as getShortPostalCode is null.. can any once send a valid Remote Query XML request and Reply that has postal code in request.