Pick Release Issues Error Ora-01403 Inv_pick_release_pub
Last updated on JULY 17, 2017
Applies to:Oracle Inventory Management - Version 11.5.8 to 11.5.10 [Release 11.5]
Information in this document applies to any platform.
The pick release fails with the error: ORA-01403
Error occurs when run against previous dates.
New orders work fine.
Error occurred in Inv_Pick_Release_Pub.Pick_Release
ORA-01403: no data found in Package INV_Pick_Release_PUB Procedure Pick_Release
Unexpected error from INV_Pick_Release_Pub.Pick_Release. Exiting
See the error in multiple request log.
including the following:
l1051165_req.txt- shows error:
l1053324_req.txt- shows error:
l1060152_req.txt- shows error:
16-31jan04_batch.txt- shows error
Some items may have been changed to not transactable and this maybe causing the issue.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms