EAM Work Order Component Pick Release Not Updating Allocations
(Doc ID 1966202.1)
Last updated on JUNE 04, 2024
Applies to:
Oracle Enterprise Asset Management - Version 12.1.3 and laterInformation 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.
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |