Value Chain Planning - EBS (MOSC)

MOSC Banner

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center