Error - ORA-01403: No Data Found When Calling INV_Pick_Wave_Pick_Confirm_Pub While Executing Get_Serial_Quantity

(Doc ID 2028176.1)

Last updated on MARCH 04, 2016

Applies to:

Oracle Inventory Management - Version 12.2.4 and later
Information in this document applies to any platform.


While calling standard API INV_Pick_Wave_Pick_Confirm_Pub, custom package fails with error - ORA-01403: No Data Found

Expected Behavior

The procedure successfully completes while executing local procedure get_serial_quantity


1. Use custom package to call standard API inv_pick_wave_pick_confirm_pub.pick_confirm
2. Standard API is using private local procedure “inv_mo_line_detail_util. are_allocations_complete” to validate allocation
3. Procedure fails while executing “get_serial_quantity” local procedure due to variable type definition mismatch.


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