Dear community members,
from time to time we find faulty records in ReqTrans table. Those records contain no item number, no quantity and refer to a plan version /0/. Here's an example:
When Planning optimization is enabled those records prevent the master planning to be executed from explosion or net requirements:
We have already been in touch with MS support and they provided an SQL query to select and delete faulty records from ReqTrans table. But it's not an ideal solution if we have to run that query every few month, not knowing how those records are created in the first place. So if anyone of you has experienced the same issue or has an idea how to prevent that from happening again, your help would be highly appreciated!