OTM Integration: Choose Ship Method on Sales Order Line Not Calling OTM Server (Doc ID 2111812.1)

Last updated on JUNE 28, 2017

Applies to:

Oracle Shipping Execution - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Integrations & Conc. Program

While on the sales order line, perform the action of selecting a Ship Method for Oracle Transportation Management (OTM):
Sales Order Line -->Action--> "Choose Ship Method".
This does not return the list of Ship Methods to choose from.

The debug log of the process shows the following:

Exiting WSH_OTM_RIQ_XML.FETCH_XML_MATCH (11/09/2015 12:16:49 PM, .03 seconds)
  x_return_status ==> E
  Exiting WSH_OTM_RIQ_XML.CHECK_RESPONSE_STATUS (11/09/2015 12:16:49 PM, .03 seconds)
  Check_Response_Status Failed ==>
  FND_API.G_EXC_ERROR exception has occured.
  Exiting WSH_OTM_RIQ_XML.PARSE_RIQ_OUTPUT_XML - EXCEPTION:FND_API.G_EXC_ERROR (11/09/2015 12:16:49 PM, .03 seconds)
  Parse_RIQ_Output_XML Failed ==>
  FND_API.G_EXC_ERROR exception has occured.
  Exiting WSH_OTM_RIQ_XML.PROCESS_ONE_HEADER - EXCEPTION:FND_API.G_EXC_ERROR (11/09/2015 12:16:49 PM, 2.33 seconds)
  Process_One_Header Failed ==>
  Entering WSH_OTM_RIQ_XML.CLEAR_GLOBALS (WSHGLRXB.pls 120.5.12010000.3) (11/09/2015 12:16:49 PM)
  x_return_status ==> S
.
.
*****************************************************
After Calling FTE for GET_RATE_CHOICE ... : 09-NOV-15 15:16:49
After Calling FTE Process Lines:E
Please see the log file /usr/tmp/l1028185.dbg for more information.
LEAVING OE_MSG_PUB.ADD_TEXT
Failed to rate shipments. Please see message details for more information.


LEAVING OE_MSG_PUB.ADD_TEXT
ERROR IN PROCEDURE Get_Freight_Choices: User-Defined Exception
UNEXPECTED ERROR IN Get_Freight_Choices :User-Defined Exception
GET_MSG_TBL STARTED , COUNT : 0
 m1 : 1
 m1 : 2



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Order Management Super User Responsibility
2. Create Sales order
3. Navigate to Sales Order Line
4. Select Action--> "Choose Ship Method"


Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms