Maximo Open Forum

Hi All, We are running into an issue with a workflow condition in Maximo that references the WOANCESTOR table.

When we check the database, the WOANCESTOR table is empty for the particular Workoder number, so the condition always evaluates to false. There is no wonum data in that table. For other work orders, there are records along with their hierarchy levels.

From what I understand, WOANCESTOR is supposed to store the work order hierarchy (ancestor–descendant relationships), but in our environment it's not getting populated.

Is it normal for this table to remain empty if no parent–child WO relationships exist?

Do we need to run any background process or action to refresh/rebuild the WOANCESTOR table if the data is missing?

Thanks

Yes, every WO in Maximo should have at least one entry in the WOANCESTOR table where the wonum and ancestor fields are the same (IE 1001 and 1001) and the hierarchylevels is 0. 

As for why you are not seeing this, that is a lot harder to know. There's not a background process required to do this. It should be happening automatically when you create the WO. It's possible these are being loaded/created in a way that prevents this WOANCESTOR logic from occurring. For example, if you have an API request creating these WOs and the WOANCESTOR object is part of the object structure, there is a delete auto generated data flag on the object structure that could be causing these records to be removed if you are not providing them. You'd need to understand why this is happening first to figure out if you have a potential Maximo bug.