Error - ORA-01403: No Data Found When Calling INV_Pick_Wave_Pick_Confirm_Pub While Executing Get_Serial_Quantity
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
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