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

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

------------------------------
Hariprasad R
------------------------------