Pick Selection List Generation Completes With Log Error ORA-06502 Character To Number Conversion Error In Package INV_Quantity_Tree_PVT Procedure Lock_Tree

(Doc ID 758135.1)

Last updated on AUGUST 14, 2017

Applies to:

Oracle Inventory Management - Version 11.5.10.2 and later
Oracle Shipping Execution - Version 11.5.10.2 and later
Information in this document applies to any platform.
This document includes all versions of 11i and R12 and later

Symptoms

When attempting to pick release the following error occurs:

ERROR:

[...]
Calling program unit INV_PICK_RELEASE_PUB.PICK_RELEASE
.....
INV_QUANTITY_TREE_PVT: CREATE_TREE Entered
INV_QUANTITY_TREE_PVT: CreateTree ending with g_exc_unexpected_error.User-Defined Exception
...
INV_Pick_Release_Pub.Pick_Release l_return_status ==> U
Error occurred in Inv_Pick_Release_Pub.Pick_Release
ORA-06502: PL/SQL: numeric or value error: character to number conversion error
in Package INV_Quantity_Tree_PVT Procedure Lock_Tree
Unexpected error from INV_Pick_Release_Pub.Pick_Release. Exiting
SQLCODE: 1 SQLERRM: User-Defined Exception
Exception occurred in WSH_PICK_LIST.Release_Batch_Sub
Exiting WSH_PICK_LIST.RELEASE_BATCH_SUB - EXCEPTION:E_RETURN
...
errbuf ==> Exception occurred in WSH_PICK_LIST
Error occurred in Release_Batch_Sub
SQLCODE: 1 SQLERRM: User-Defined Exception
Exception occurred in WSH_PICK_LIST
[...]


-- Steps To Reproduce:
The issue can be reproduced at will with the following steps:

  1. enter sales order
  2. save
  3. book order
  4. navigate to shipping > relase sales orders
  5. choose an relevant shipping rule
  6. choose order number
  7. hit concurrent
  8. Pick Selection List Generation program completes with error
  9. view log file

Due to this issue, users cannot ship items on the orders

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