Is there anywhere where I can see the details of what happens when I submit the MRP process? I'm wondering why the 'Building PartList Level: 7' Activity is so long in the Generate Suggestions

[Stevensi1018 (Steven Simard)]

Everything is fast enough except for that one activity which takes about 27-28 minutes in a process that runs for 29 minutes.

I’m wondering if something is wrong or missing in our configurations because a normal regen for all sites takes 1h30 which is a lot of time where we’re not able to use the PO Suggestions. We run them during night but unfortunately, we’ve been getting a couple of problems lately which makes the suggestions empty and we have nothing during the day

[JasonMcD (Jason McDermott)]

If it’s because of SQL, you can try this.

Intro:

Process MRP Failing

No kidding, I had a huge issue with TFOrdDtl 11 months ago and now I see what you mean - I am not alone there! So, I have a whole write-up on the site here about this… BUT - I can’t get to it since I am not a “Regular” at the moment. But the solution is to get into SSMS and “force a good plan” from the query store. That was gibberish to me until a walkthrough from a great Epicor consultant (they do exist).

Guide:

Process MRP Failing

Here you go. Pick a flavor: Why is this step of MRP taking so long.pptx (690.4 KB) Why is this step of MRP taking so long.pdf (651.8 KB)

[Stevensi1018 (Steven Simard)]

Just activated the Query Store in SSMS so I’ll take a look at it later. Thanks, it helps!