Status Change on Work Order

daveschultz

Well Known Member
We are trying to not allow our users to change a status of a work order, once it gets to a certain status. So when a work order gets to the complete status, they should not be able to change the status there. We thought that this worked by setting the Lock Flag to 4 (this is how our users swear it worked in the past). This is still allowing people to change the status and Oracle has said that is how it is supposed to work. I think I may be able to do this through row security, but wondering how others are doing it.

Thanks

Dave
E1 9.0.2
Tools 9.1.0.4
 

daveschultz

Well Known Member
Thanks Larry. Just to clarify, you have coded it so that if the status is X the user cna change it, but if the status is Y, only certain roles can change it?

Thanks
Dave
 

Larry_Jones

Legendary Poster
Dave,

we just added code that once the Mfg WO Status goes past 96 (Completion / Variance Accounting) it cannot be changed except by special dispensation from the Pope.
 

RussellCodlin

Reputable Poster
Great thanks. Russell we are using service/equipment work orders.

If that's the case and you don't want anybody changing the status of a work order then just adjust the work order activity rules to not allow them to go backwards once they've hit a certain status. That will apply to all users. The lock flag prevents certain changes to the work order at a particular status but not changes to the status itself.

If you have a look at the Oracle documentation you'll see an example of a setup where once an order has been changed to MJ it can't be changed back. https://docs.oracle.com/cd/E16582_01/doc.91/e15155/set_up_work_order_system.htm#EOAWO00023
 
Top