My Oracle Support Banner

Pick Release Issues Error Ora-01403 Inv_pick_release_pub (Doc ID 268219.1)

Last updated on FEBRUARY 14, 2019

Applies to:

Oracle Inventory Management - Version 11.5.8 to 11.5.10 [Release 11.5]
Information in this document applies to any platform.
Inv_Pick_Release_Pub WSHPSGL


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


Some items may have been changed to not transactable and this maybe causing the issue. 


To view full details, 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 a vibrant support community of peers and Oracle experts.