Program: WIP Mass Load
Symptoms:
Error message:
System cannot add or change material requirement because requested job/operation_seq_num/invetory_item_id_new combo has already existed.
Cause:
Although there ware some errors in the WIP Mass Load load report, the discrete job was created and it was missing some components (for Operation Pull / P100).
WIP mass load was show Completed.
Other information:
Some other errors as below:
ERROR
"System cannot add resource or material because the requested operation_seq_num does not exist"
"System cannot add or change material requirement because requested job/operation_seq_num /inventory_item_id_new combo has already existed.".
Other Cause:
The cause of the issue is invalid / incorrect data in wip_job_schedule_interface and
wip_job_dtls_interface tables
The cause for this data has been determined as user inserted the records to add items that are
already part of the BOM.
All the transactions failed because of the same reason. All of them failed with "System cannot
add or change material requirement because requested job/operation_seq_num/invetory_item_id_new
combo has already existed.". They failed because the user try to add items that are already part of the BOM.
Solution:
Check interface table and fix data.
1. delete duplicate components.
Sammi 2010.08.13
