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 NOVEMBER 12, 2024

Applies to:

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

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