MRCSAL1 Load/Copy/Merge MDS Taking Too Long
(Doc ID 405690.1)
Last updated on FEBRUARY 03, 2023
Applies to:
Oracle Materials Requirement Planning - Version 11.5.10 to 11.5.10.2 [Release 11.5]Information in this document applies to any platform.
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
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 |
Cause |
Solution |
References |