My Oracle Support Banner

Interface Trip Stop Errors With ORA-22160: Element at Index [1] Does Not Exist ORA-06510: PL/SQL: Unhandled User-Defined Exception WSH_TRXLOT_HANDLER.INSERT_ROW_BULK l_return_status ==> U (Doc ID 3054861.1)

Last updated on OCTOBER 25, 2024

Applies to:

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

Symptoms

Interface Trip Stop failed with the below error due to invalid lot number entered by the user at the time of ship confirm:

Entering WSH_TRXLOTS_HANDLER.INSERT_ROW_BULK (WSHIIXLB.pls 120.1) (09/27/2024 10:23:01 AM)
  p_mtl_lot_txn_if_rec.count ==> 1
  g_userid ==> 71309
  l_start_index ==> 1
  l_end_index ==> 1
  Unexpected error has occured. Oracle error message is ORA-22160: element at index [1] does not exist
ORA-06510: PL/SQL: unhandled user-defined exception
  Exiting WSH_TRXLOTS_HANDLER.INSERT_ROW_BULK - EXCEPTION:OTHERS (09/27/2024 10:23:01 AM, .01 seconds)
  WSH_TRXLOT_HANDLER.INSERT_ROW_BULK l_return_status ==> U
  FND_API.G_EXC_ERROR exception has occured.
  Exiting WSH_SHIP_CONFIRM_ACTIONS.INSERT_INV_RECORDS - EXCEPTION:FND_API.G_EXC_ERROR (09/27/2024 10:23:01 AM, .02 seconds)
  Insert_inv_records l_return_status ==> E




The issue can be reproduced at will with the following steps:

1. OM Super User Responsibility
2. Shipping > Transactions
3. Query Order and enter Lot number on delivery detail
4. Ship confirm the order
5. Interface Trip Stop fails.

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.