MRCSAL1 Load/Copy/Merge MDS Taking Too Long (Doc ID 405690.1)

Last updated on FEBRUARY 03, 2023

Applies to:

Symptoms

On 11.5.10 in Production:
When running Load/Copy/Merge MDS - MRCSAL1 - a performance issue arises in the following sql:

select /*+ LEADING (OOL) +*/ ool.inventory_item_id ,
NVL(items.product_family_item_id,(-23453)) ,(-23453) ,
NVL(items.mrp_planning_code,6) ,items.bom_item_type ,
DECODE(items.pick_components_flag,'Y',1,2) ,NVL(items.full_lead_time,0) ,
NVL(items.fixed_lead_time,0) ,NVL(items.variable_lead_time,0) ,
DECODE(NVL(items.repetitive_planning_flag,'N'),'N',1,2) ,:b0 ,:b1 ,
to_number(to_char(sou.new_schedule_date,'j')) ,
to_number(to_char(sou.new_schedule_date,'j')) ,
to_number(to_char(sou.new_schedule_date,'j')) ,

from oe_order_lines_all ool ,mtl_system_items items ,mrp_sales_order_updates sou
where (((((((((((((((((NVL(items.mrp_planning_code,6)<>6 and

The issue can be reproduced at will with the following steps:
1. Under MFG Responsibility
2. Change Organization - select FDC
3. Go to SCP->MDS->Load/Copy/Merge
4. Enter Required Parameters and Launch. It takes just under 5 hours to Complete.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.