My Oracle Support Banner

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

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.
Inv_Pick_Release_Pub WSHPSGL

Symptoms

The pick release fails with the error: ORA-01403
Error occurs when run against previous dates.
New orders work fine.

Error
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

Changes

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

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!


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