Interface Trip Stop Errors With API Handle_Tolerances Failed With Unexpected Error
(Doc ID 2854407.1)
Last updated on AUGUST 18, 2022
Applies to:
Oracle Shipping Execution - Version 12.1.3 and laterInformation in this document applies to any platform.
Symptoms
Interface Trip Stop errors with the following:
ERROR
-----------------------
_fullfilled_flag is True, need to call cancel_details for source_line = 1649553
l_remain_detail_index = 1 detail_id = 5528140
Entering WSH_INTERFACE.CANCEL_DETAILS (WSHDDINB.pls 120.2.12010000.4) (03/02/2022 05:04:22 PM)
COUNT of Details ==> 1
Entering WSH_INTERFACE.PROCESS_DETAILS (WSHDDINB.pls 120.2.12010000.4) (03/02/2022 05:04:22 PM)
COUNT of Details ==> 1
p_cancel_delete_flag ==> C
Calling program unit INV_TROLIN_UTIL.QUERY_ROW
Entering WSH_UTIL_CORE.DEFAULT_HANDLER (WSHUTCOB.pls 120.21.12010000.7) (03/02/2022 05:04:22 PM)
P_ROUTINE_NAME ==> WSH_INTERFACE.PROCESS_DETAILS
P_MESSAGE_TYPE ==> U
msg_buffer ==> Error in Routine WSH_INTERFACE.PROCESS_DETAILS, Oracle Error - 1 User-Defined Exception
Exiting WSH_UTIL_CORE.ADD_MESSAGE (03/02/2022 05:04:22 PM, 0 secondsExiting WSH_UTIL_CORE.DEFAULT_HANDLER (03/02/2022 05:04:22 PM, 0 seconds)
Unexpected error has occured. Oracle error message is User-Defined Exception
Exiting WSH_INTERFACE.CANCEL_DETAILS (03/02/2022 05:04:22 PM, .01 seconds)
l_return_status ==> U
API Handle_Tolerances failed with an unexpected error
The unexpected error is User-Defined Exception
UNEXPECTED ERROR IN Handle_Tolerances
Unexpected error has occured. Oracle error message is User-Defined Exception
Exiting WSH_SHIP_CONFIRM_ACTIONS.HANDLE_TOLERANCES - EXCEPTION:OTHERS (03/02/2022 05:04:22 PM, .15 seconds)
Return status after calling WSH_SHIP_CONFRIM_ACTIONS.Handle_Tolerances ==> U
fnd_api.g_exc_unexpected_error at source_line_id ==> xxxxxx
l_remain_detail_index = 1 detail_id = 5528140
Entering WSH_INTERFACE.CANCEL_DETAILS (WSHDDINB.pls 120.2.12010000.4) (03/02/2022 05:04:22 PM)
COUNT of Details ==> 1
Entering WSH_INTERFACE.PROCESS_DETAILS (WSHDDINB.pls 120.2.12010000.4) (03/02/2022 05:04:22 PM)
COUNT of Details ==> 1
p_cancel_delete_flag ==> C
Calling program unit INV_TROLIN_UTIL.QUERY_ROW
Entering WSH_UTIL_CORE.DEFAULT_HANDLER (WSHUTCOB.pls 120.21.12010000.7) (03/02/2022 05:04:22 PM)
P_ROUTINE_NAME ==> WSH_INTERFACE.PROCESS_DETAILS
P_MESSAGE_TYPE ==> U
msg_buffer ==> Error in Routine WSH_INTERFACE.PROCESS_DETAILS, Oracle Error - 1 User-Defined Exception
Exiting WSH_UTIL_CORE.ADD_MESSAGE (03/02/2022 05:04:22 PM, 0 secondsExiting WSH_UTIL_CORE.DEFAULT_HANDLER (03/02/2022 05:04:22 PM, 0 seconds)
Unexpected error has occured. Oracle error message is User-Defined Exception
Exiting WSH_INTERFACE.CANCEL_DETAILS (03/02/2022 05:04:22 PM, .01 seconds)
l_return_status ==> U
API Handle_Tolerances failed with an unexpected error
The unexpected error is User-Defined Exception
UNEXPECTED ERROR IN Handle_Tolerances
Unexpected error has occured. Oracle error message is User-Defined Exception
Exiting WSH_SHIP_CONFIRM_ACTIONS.HANDLE_TOLERANCES - EXCEPTION:OTHERS (03/02/2022 05:04:22 PM, .15 seconds)
Return status after calling WSH_SHIP_CONFRIM_ACTIONS.Handle_Tolerances ==> U
fnd_api.g_exc_unexpected_error at source_line_id ==> xxxxxx
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Responsibility: Order Management Super User
2. Shipping > Interfaces
3. Run Interface Trip Stop
4. Error
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |