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

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 hundreds of Community platforms