EAM Work Order Component Pick Release Not Updating Allocations (Doc ID 1966202.1)

Last updated on JUNE 04, 2024

Applies to:

Symptoms

When attempting to do EAM Work Order Component Pick Release, it is not updating allocations.

When a non-project work order with a material requirement greater than the on-hand quantity is released, an allocation is automatically created for that on-hand quantity. Once additional material is received into the same org, and we run the Work Order Component Pick Release job, allocations do not occur. The concurrent request completes normal, but the output shows the work orders that met the criteria to have the allocations occur, but there is an error message of "Error Returned status: U
Returned message: An unexpected error was encountered: wip_picking_pvt.allocate: ORA-01403: no data found.
Parameters passed to allocate():
p_days_to_alloc=;p_days_forward=7;p_wip_entity_type=6;p_organization_id=126;p_pick_grouping_rule_id=1009;l_print_pickslips=T"

Workarounds:
-Using the 'request more' function on each individual work order DOES update the allocation, but is very time consuming since we have to go into each work order.

ERROR

"Error Returned status: U
Returned message: An unexpected error was encountered: wip_picking_pvt.allocate: ORA-01403: no data found.
Parameters passed to allocate():
p_days_to_alloc=;p_days_forward=7;p_wip_entity_type=6;p_organization_id=126;p_pick_grouping_rule_id=1009;l_print_pickslips=T"

An unexpected error was encountered: wip_picking_pvt.allocate: ORA-01403: no data found

STEPS

Steps to reproduce:
-Create work order with material requirement > On-Hand quantity.
-Ensure auto-request material flags are set to 'Yes'
-Release work order, note allocations are updated
-Receive material into same sub-inventory/locator
-Run Work Order Component Pick Release request, note allocations are not updated for the remaining quantity.

Changes

Cause

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