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

Last updated on MARCH 08, 2017

Applies to:

Oracle Enterprise Asset Management - Version 12.1.3 and later
Information in this document applies to any platform.

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.



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