Production Scheduler-Launch PS Plan errors out with MSC_WO_CONSUMED_ITEM_BOM_PK?
Module: Production Scheduler
Concurrent Program: Launch PS Plan
Error in log file:
Failure populating reference tables. Exception message: ERROR AT:
INSERT INTO msc_int_wo_consumed_item_bom ( OI__work_order_code, OI__branch_code, OI__operation_set_name, OI__consumed_item_set, OI__item_code, OI__is_planned_item, OI__quantity, OI__remaining_quantity, OI__preference, OI__scrap_factor, OI__lead_time_offset, OI__end_time_offset, OI__parent_work_order_code, OI__15 ) ( SELECT /*+ leading(MSC_INT_WORK_ORDER SUP ) */ sup.TRANSACTION_ID, msc_int_work_order.OI__branch_code, msc_int_work_order.OI__routing_code || ':' || res_req.OPERATION_SEQ_NUM || ':' || res_req.OPERATION_SEQUENCE_ID || ':' || res_req.RESOURCE_SEQ_NUM , MSC_DEMANDS.SR_INSTANCE_ID || ':' || case when max(MSC_DEMANDS.PRIMARY_COMPONENT_ID) is NULL then MSC_DEMANDS.INVENTORY_ITEM_ID else case when exists ( select 1 from msc_int_item where OI__item_code = msc_demands.SR_INSTANCE_ID || ':' || msc_demands.primary_component_id and OI__item_type = 'Phantom' ) then MSC_DEMANDS.INVENTORY_ITEM_ID else max(MSC_DEMANDS.PRIMARY_COMPONENT_ID) end end , MSC_DEMANDS.SR_INSTANCE_ID || ':' || MSC_DEMANDS.INVENTORY_ITEM_ID, 'Yes', sum(MSC_DEMANDS.USING_REQUIREMENT_QUANTITY), sum(MSC_DEMANDS.USING_REQUIREMENT_QUANTITY - nvl(MSC_DEMANDS.ISSUED_QUANTITY,0)) , null, '0', '0', '0', null, null FROM