Pick Release Errors With Cannot Update Delivery Detail Error Occurred in WSH_PICK_LIST.Create_Move_Order_Lines
(Doc ID 3053046.1)
Last updated on OCTOBER 15, 2024
Applies to:
Oracle Shipping Execution - Version 12.2.4 and laterInformation in this document applies to any platform.
Symptoms
Pick release errors with the following:
Cannot update delivery detail: XXXXXXXXX
Error occurred in WSH_PICK_LIST.Create_Move_Order_Lines
SQLCODE: 1 SQLERRM: User-Defined Exception
Exception occurred in WSH_PICK_LIST.Release_Batch_Sub
Error occurred in Release_Batch_Sub
SQLCODE: 1 SQLERRM: User-Defined Exception
Exception occurred in WSH_PICK_LIST
ERROR :
Cannot update delivery detail: XXXXXXXX
Unexpected error : ORA-08102: index key not found, obj# 2145669, file 235, block
Error occurred in WSH_PICK_LIST.Create_Move_Order_Lines
SQLCODE: 1 SQLERRM: User-Defined Exception
Exception occurred in WSH_PICK_LIST.Release_Batch_Sub
Error occurred in Release_Batch_Sub
SQLCODE: 1 SQLERRM: User-Defined Exception
Exception occurred in WSH_PICK_LIST
ERROR :
Cannot update delivery detail: XXXXXXXX
Unexpected error : ORA-08102: index key not found, obj# 2145669, file 235, block
The issue can be reproduced at will with the following steps:
1. OM Super User
2. Shipping
3. Release Sales Order
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 |