My Oracle Support Banner

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 later
Information 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




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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.