Skip to Content

Maintenance Plan Completion Date MHIS-LRMDT update process issue


While going through the table MHIS, I observed that the Completion date field (MHIS-LRMDT) was sometimes showing the last Completion date as in IP10 and sometimes the second last Completion date and not the current one. I Goggled and came across this article of April 2012 which gave me my answer:

I even tested the scenario and it is like that i.e. the MHIS-LRMDT field only gets updated in MHIS table when the next call is generated. So for instance if the last status (row) in IP10 is On Hold and second last is with completion Date, then this Date does not appear in the MHIS-LRMDT field. If the HOLD job is in Called state then the Completion date appears.

If that is the scenario then I would like to know how to get the Last Completion date when current status is On Hold and last Order was completed (i.e. No Called Object). It is important as we have multiple reports which are showing the wrong Last Completion dates.



Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers