Change workorder tasks to use a different autonumber value

If you generate workorders from PM’s that have a lot of job tasks, you may have noticed that the parent workorder numbers are not in order or sequential. It may seem like the workorder numbers are skipping when they shouldn’t be, but in fact, what’s happening is this. When a PM, that has job tasks associated with it, is generated into a workorder, those individual tasks use up workorder autonumber keys. So if your job plan has 30 tasks, it will use 30 workorder autonumber keys and I think this is unnecessary. If you have a lot of PM’s, this number can get high pretty quickly. I think the workorder autonumber should be used only for that purpose. So here is how you setup different autonumber keys for workorder tasks so that you don’t use all the autonumber values.

First off, there are three modules, not including the workorder module that use the WORKORDERNUM autokey.  They are WOACTIVITY, WOCHANGE, and WORELEASE.  You can create three different autokeys for each module if you want, but I will show you how to create one for WOACTIVITY as the process is all the same.

Go to Database Configuration bring up the WOACTIVITY Object. Then go to the Attributes tab and search for WONUM. Expand the WONUM Attribute. In the Advanced section change the value Autonumber property to be WOACTIVITYNUM. In the details section enter &AUTOKEY& into the Default Value and save. You should get a message that the WOACTIVITYNUM autoseed does not exist and it asks if would you like to create it? Of course you do so click Yes.

Now go to Organizations -> Select Action -> Autonumber Setup -> Organization Level and you should now see WOACTIVITYNUM. It is recommended that you add a prefix to the autoseed.

Lastly, stop the webserver and run configdb.bat. Or you could config the DB from within Maximo.

Now when you generate a PM, the tasks should now have their own autonumber values.

Did You Know...

As Maximo Experts, we have developed several add-on products for Maximo that mobilize the work force, simplifies assignments, provides ad-hoc reporting capabilities and facilitates the seamless integration of Service Requests into Maximo.

Check out our products by clicking on the following links: EZMaxMobileEZPlanner and EZInsight.

Find Out More

5 thoughts on “Change workorder tasks to use a different autonumber value

  1. Hey Chon,

    I followed your instructions however when you go to site level and create a new row, it only allows you to choose a value from a lookup. We cannot create a WOACTIVTYNUM because of this restriction. We then went into the autokey table,added a new row, and applied that new autonum to the db object. That didn’t seem to work either. Not sure if we are using a different version of Maximo because at the site level we can only choose a lookup.

    Thanks Chon

  2. I have a requirement to set different autonumbering sequence for different cloned applications of views created from Work Order table.Does it seem feasible?

Leave a Reply