tag:blogger.com,1999:blog-2002636098451095610.post4843058212768919953..comments2023-12-22T11:14:03.004+01:00Comments on IBM Maximo Customization and Development: Preventive Maintenance (PM) automatic work order generationBrunohttp://www.blogger.com/profile/13748160755424198810noreply@blogger.comBlogger7125tag:blogger.com,1999:blog-2002636098451095610.post-44505135595059212402019-04-11T09:29:14.772+02:002019-04-11T09:29:14.772+02:00Can you please explain the difference between &quo...Can you please explain the difference between "Generate WOs Due on the Current Date Plus This Number of Days" field in PM options vs Lead Time (days) in PM screen? Rajagopalanhttps://www.blogger.com/profile/04608187823622558761noreply@blogger.comtag:blogger.com,1999:blog-2002636098451095610.post-76534955578555162802018-08-06T12:57:31.049+02:002018-08-06T12:57:31.049+02:00Is nextdate field value is mandatory to generate w...Is nextdate field value is mandatory to generate work orders even if the 'Use Last Work Order's Start Date to Calculate Next Due Date' field is checked or unchecked?<br /><br />How about newly created PM and is newly created PM should have a value in nextdate field to generate workorder by work order genreation cron?Anonymoushttps://www.blogger.com/profile/06558084943171092503noreply@blogger.comtag:blogger.com,1999:blog-2002636098451095610.post-20196831400205259602018-03-16T14:50:42.979+01:002018-03-16T14:50:42.979+01:00Here is the query that we use for the WO Generatio...Here is the query that we use for the WO Generation Where Clause:<br />status='ACTIVE' AND nextdate IS NOT NULL AND (ISNULL(extdate,nextdate)-ISNULL(leadtime,0)) <= GETDATE()MaDDoGhttps://www.blogger.com/profile/16806506041749466057noreply@blogger.comtag:blogger.com,1999:blog-2002636098451095610.post-87032025500674579262017-12-06T00:30:13.579+01:002017-12-06T00:30:13.579+01:00Is it possible to use a relationship here instead ...Is it possible to use a relationship here instead of the query because the where clause it limited to 254 characters and our requirement is have more than that. Where clause is stored in the MAXVAR system table. So, we are unable to increase the width of the field.Sivakumarhttps://www.blogger.com/profile/07338234253319645737noreply@blogger.comtag:blogger.com,1999:blog-2002636098451095610.post-48991595090274518802016-11-06T11:15:13.134+01:002016-11-06T11:15:13.134+01:00Yes the NULL will be the cause of the issue. Chang...Yes the NULL will be the cause of the issue. Change the where clause to something sensible based on how often you run the crontask. For example, if you run it every day, you could set it to:<br /><br />status='ACTIVE' and nextdate - NVL(leadtime,0) - 1 <= SYSDATE<br /><br />to generate all the workorders for the following day.Anonymoushttps://www.blogger.com/profile/11109923332898970594noreply@blogger.comtag:blogger.com,1999:blog-2002636098451095610.post-43293735320798946162016-10-26T22:53:55.281+02:002016-10-26T22:53:55.281+02:00I have "NULL" in the Where Clause field ...I have "NULL" in the Where Clause field at the moment.<br />The problem I may have is, I have weekly, monthly, quarterly, and annual PM's.<br />At the moment we have 28 Sites and over 1900 Assets. Next year that will expand to over 500 Sites and I have no idea how many assets.<br />I need Cron Task to be auto-generating WO's for these based on Lead Time, Frequency & Due Date<br />So far, I have done some work in the Test environment and have not gotten any PM's to auto-generate WO's. I even had Cron Task running every 5 minutes for a while, so I could watch it.<br />Cron Task did in fact run every 5 minutes, but never created any WO's.<br />As far as I can see, everything is checked and set correctly. Could it be failing due to the "NULL" value?Anonymoushttps://www.blogger.com/profile/03586200190059827340noreply@blogger.comtag:blogger.com,1999:blog-2002636098451095610.post-68892488007108528172015-06-19T16:38:04.615+02:002015-06-19T16:38:04.615+02:00We often set PM.ADJNEXTDUE - will this be taken i...We often set PM.ADJNEXTDUE - will this be taken into account by the clause you refer to? Or do I have to build in additional logic?<br />Mirandersonhttps://www.blogger.com/profile/15779019131988982023noreply@blogger.com