MRP error: Parameters for master plan do not exist

One of our customer had an issue with MRP; it failed with the following error:

Parameters for master plan do not exist.

In our case, the problem was that records in ReqPo and ReqTrans were referencing a plan version (ReqPlanVersion) that did no longer exist. How this situation came to be is unknown to us.

What we did to resolve this:

1. Create a reqPlanVersion on SQL, making sure that the recid matches the recid of the plan version that is missing, for example:
   INSERT INTO [dbo].[REQPLANVERSION]
   ([ACTIVE]
   ,[REQPLANDATAAREAID]
   ,[REQPLANID]
   ,[RECVERSION]
   ,[RECID])
   VALUES
   (1
   ,'prd'
   ,'PlanToDel'
   ,1
   ,5637154609)

   Don’t forget to change the REQPLANDATAAREAID and RECID values to the values for your environment. The value for REQPLANID can be any value, we chose ‘PlanToDel‘.

2. Create a new plan called PlanToDel in the form Master Planning > Setup > Plans > Master plan
3. Optional steps we did while troubleshooting
   1. Delete plan version using Master Planning > Periodic > Plans > Delete Plan
   2. Run MRP for this plan for 1 item

4. Delete the new plan called PlanToDel in the form Master Planning > Setup > Plans > Master plan

So in summary, we just created the missing record and then used standard AX functionality to clean the data.