This is an archive of the Maximo Yahoo Community. The content of this pages may be a sometimes obsolete so please check post dates.
Thanks to the community owner Christopher Wanko for providing the content.
Yes this is Production environment.
No workflow associated to work orders.
Thanks for the link I'll take a look at it.
The sender of this message is responsible for its content and addressing. Any actions not conforming to Petrobras System internal policies are forbidden.
----- Original Message -----
From: "Victor" [vikas17.j@gmail.com]
Sent: 11/14/2011 05:16 PM GMT
To: MAXIMO@yahoogroups.com
Subject: [MAXIMO List] Re: Work Order Status
Hi George,
Please let me know the following details :
-- Is this in production environment ?
-- Is there any workflow associated to those workorders ?
Here is one helpful link if can write the code for it :
http://www.techno-soft.com/index.php?/how-to-change-status-of-work-orders-in-maximo-using-mbos
Thanks & regards,
Victor.
--- In MAXIMO@yahoogroups.com, ggutierrez@... wrote:
>
> Thanks Victor,
> I figured I couldn't do it from the front end.
> How would I go about doing it in the back end?
> I just recently activated an escalation that closes work orders older then
> 180 days now I got my receiving dept on me cause they can't post to work
> orders. See what happens when my boss says turn it on.
>
> Ya its a monday :(
>
>
>
> Thank You,
>
> George Gutierrez Jr.
> Maximo Administration
> Pasadena Refining Systems
> 713.920.3908 Direct
> 832.473.5330 Cell
> U1O2 - Chave
>
>
>
> "Victor"
> <vikas17.j@...
> > To
> Sent by: MAXIMO@yahoogroups.com
> MAXIMO@... cc
> om
> Subject
> [MAXIMO List] Re: Work Order
> 11/14/2011 09:38 AM Status
>
>
> Please respond to
> MAXIMO@...
> om
>
>
>
>
>
>
>
>
>
> Hi George,
>
> If you want to do it from front end, the answer is no.
>
> Anyhow, you can modify it from back end, provided you take care of all the
> data modifications to bring it back to that status.
>
> Thanks & regards,
> Victor.
>
> --- In MAXIMO@yahoogroups.com, "George" <ggutierrez@> wrote:
> >
> > Is it possible to change a work order status from 'close' back to 'comp'?
> >
> > thx,
> > mrggutz
> >
>
Hi George,
If there is no workflow associated to the workorders, then its quite easy to sovle your problem.
You will have to update these tables :
1. WORKORDER
2. WOSTATUS
3. WOACTIVITY
Update the Status to COMP in WORKORDER and WOACTIVITY for the workorders and the child workorders associated to them
Delete the row of CLOSE status from the WOSTATUS table for these workorders and their child or task workorders.
Hope this helps.
Thanks & regards,
Victor.
--- In MAXIMO@yahoogroups.com, ggutierrez@... wrote:
>
> Yes this is Production environment.
> No workflow associated to work orders.
> Thanks for the link I'll take a look at it.
>
> The sender of this message is responsible for its content and addressing. Any actions not conforming to Petrobras System internal policies are forbidden.
>
>
> ----- Original Message -----
> From: "Victor" [vikas17.j@...]
> Sent: 11/14/2011 05:16 PM GMT
> To: MAXIMO@yahoogroups.com
> Subject: [MAXIMO List] Re: Work Order Status
>
>
>
> Hi George,
>
> Please let me know the following details :
>
> -- Is this in production environment ?
> -- Is there any workflow associated to those workorders ?
>
> Here is one helpful link if can write the code for it :
>
> http://www.techno-soft.com/index.php?/how-to-change-status-of-work-orders-in-maximo-using-mbos
>
> Thanks & regards,
> Victor.
>
> --- In MAXIMO@yahoogroups.com, ggutierrez@ wrote:
> >
> > Thanks Victor,
> > I figured I couldn't do it from the front end.
> > How would I go about doing it in the back end?
> > I just recently activated an escalation that closes work orders older then
> > 180 days now I got my receiving dept on me cause they can't post to work
> > orders. See what happens when my boss says turn it on.
> >
> > Ya its a monday :(
> >
> >
> >
> > Thank You,
> >
> > George Gutierrez Jr.
> > Maximo Administration
> > Pasadena Refining Systems
> > 713.920.3908 Direct
> > 832.473.5330 Cell
> > U1O2 - Chave
> >
> >
> >
> > "Victor"
> > <vikas17.j@
> > > To
> > Sent by: MAXIMO@yahoogroups.com
> > MAXIMO@ cc
> > om
> > Subject
> > [MAXIMO List] Re: Work Order
> > 11/14/2011 09:38 AM Status
> >
> >
> > Please respond to
> > MAXIMO@
> > om
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > Hi George,
> >
> > If you want to do it from front end, the answer is no.
> >
> > Anyhow, you can modify it from back end, provided you take care of all the
> > data modifications to bring it back to that status.
> >
> > Thanks & regards,
> > Victor.
> >
> > --- In MAXIMO@yahoogroups.com, "George" <ggutierrez@> wrote:
> > >
> > > Is it possible to change a work order status from 'close' back to 'comp'?
> > >
> > > thx,
> > > mrggutz
> > >
> >
>
>
>
>
>
>
After updating through SQL, you will have to either run the dbconfig or restart the application server to have the changes take effect.
Thanks & regards,
Victor.
--- In MAXIMO@yahoogroups.com, "Victor" <vikas17.j@...> wrote:
>
> Hi George,
>
> If there is no workflow associated to the workorders, then its quite easy to sovle your problem.
>
> You will have to update these tables :
>
> 1. WORKORDER
> 2. WOSTATUS
> 3. WOACTIVITY
>
> Update the Status to COMP in WORKORDER and WOACTIVITY for the workorders and the child workorders associated to them
> Delete the row of CLOSE status from the WOSTATUS table for these workorders and their child or task workorders.
>
> Hope this helps.
>
> Thanks & regards,
> Victor.
>
> --- In MAXIMO@yahoogroups.com, ggutierrez@ wrote:
> >
> > Yes this is Production environment.
> > No workflow associated to work orders.
> > Thanks for the link I'll take a look at it.
> >
> > The sender of this message is responsible for its content and addressing. Any actions not conforming to Petrobras System internal policies are forbidden.
> >
> >
> > ----- Original Message -----
> > From: "Victor" [vikas17.j@]
> > Sent: 11/14/2011 05:16 PM GMT
> > To: MAXIMO@yahoogroups.com
> > Subject: [MAXIMO List] Re: Work Order Status
> >
> >
> >
> > Hi George,
> >
> > Please let me know the following details :
> >
> > -- Is this in production environment ?
> > -- Is there any workflow associated to those workorders ?
> >
> > Here is one helpful link if can write the code for it :
> >
> > http://www.techno-soft.com/index.php?/how-to-change-status-of-work-orders-in-maximo-using-mbos
> >
> > Thanks & regards,
> > Victor.
> >
> > --- In MAXIMO@yahoogroups.com, ggutierrez@ wrote:
> > >
> > > Thanks Victor,
> > > I figured I couldn't do it from the front end.
> > > How would I go about doing it in the back end?
> > > I just recently activated an escalation that closes work orders older then
> > > 180 days now I got my receiving dept on me cause they can't post to work
> > > orders. See what happens when my boss says turn it on.
> > >
> > > Ya its a monday :(
> > >
> > >
> > >
> > > Thank You,
> > >
> > > George Gutierrez Jr.
> > > Maximo Administration
> > > Pasadena Refining Systems
> > > 713.920.3908 Direct
> > > 832.473.5330 Cell
> > > U1O2 - Chave
> > >
> > >
> > >
> > > "Victor"
> > > <vikas17.j@
> > > > To
> > > Sent by: MAXIMO@yahoogroups.com
> > > MAXIMO@ cc
> > > om
> > > Subject
> > > [MAXIMO List] Re: Work Order
> > > 11/14/2011 09:38 AM Status
> > >
> > >
> > > Please respond to
> > > MAXIMO@
> > > om
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > > Hi George,
> > >
> > > If you want to do it from front end, the answer is no.
> > >
> > > Anyhow, you can modify it from back end, provided you take care of all the
> > > data modifications to bring it back to that status.
> > >
> > > Thanks & regards,
> > > Victor.
> > >
> > > --- In MAXIMO@yahoogroups.com, "George" <ggutierrez@> wrote:
> > > >
> > > > Is it possible to change a work order status from 'close' back to 'comp'?
> > > >
> > > > thx,
> > > > mrggutz
> > > >
> > >
> >
> >
> >
> >
> >
> >
>
Don't forget to update the HISTORYFLAG on the WORKORDER as well. Set it
back to "0".
Peter
> After updating through SQL, you will have to either run the dbconfig or
> restart the application server to have the changes take effect.
>
> Thanks & regards,
> Victor.
>
> --- In MAXIMO@yahoogroups.com, "Victor" <vikas17.j@...> wrote:
>>
>> Hi George,
>>
>> If there is no workflow associated to the workorders, then its quite
>> easy to sovle your problem.
>>
>> You will have to update these tables :
>>
>> 1. WORKORDER
>> 2. WOSTATUS
>> 3. WOACTIVITY
>>
>> Update the Status to COMP in WORKORDER and WOACTIVITY for the workorders
>> and the child workorders associated to them
>> Delete the row of CLOSE status from the WOSTATUS table for these
>> workorders and their child or task workorders.
>>
>> Hope this helps.
>>
>> Thanks & regards,
>> Victor.
>>
>> --- In MAXIMO@yahoogroups.com, ggutierrez@ wrote:
>> >
>> > Yes this is Production environment.
>> > No workflow associated to work orders.
>> > Thanks for the link I'll take a look at it.
>> >
>> > The sender of this message is responsible for its content and
>> addressing. Any actions not conforming to Petrobras System internal
>> policies are forbidden.
>> >
>> >
>> > ----- Original Message -----
>> > From: "Victor" [vikas17.j@]
>> > Sent: 11/14/2011 05:16 PM GMT
>> > To: MAXIMO@yahoogroups.com
>> > Subject: [MAXIMO List] Re: Work Order Status
>> >
>> >
>> >
>> > Hi George,
>> >
>> > Please let me know the following details :
>> >
>> > -- Is this in production environment ?
>> > -- Is there any workflow associated to those workorders ?
>> >
>> > Here is one helpful link if can write the code for it :
>> >
>> > http://www.techno-soft.com/index.php?/how-to-change-status-of-work-orders-in-maximo-using-mbos
>> >
>> > Thanks & regards,
>> > Victor.
>> >
>> > --- In MAXIMO@yahoogroups.com, ggutierrez@ wrote:
>> > >
>> > > Thanks Victor,
>> > > I figured I couldn't do it from the front end.
>> > > How would I go about doing it in the back end?
>> > > I just recently activated an escalation that closes work orders
>> older then
>> > > 180 days now I got my receiving dept on me cause they can't post to
>> work
>> > > orders. See what happens when my boss says turn it on.
>> > >
>> > > Ya its a monday :(
>> > >
>> > >
>> > >
>> > > Thank You,
>> > >
>> > > George Gutierrez Jr.
>> > > Maximo Administration
>> > > Pasadena Refining Systems
>> > > 713.920.3908 Direct
>> > > 832.473.5330 Cell
>> > > U1O2 - Chave
>> > >
>> > >
>> > >
>> > > "Victor"
>> > > <vikas17.j@
>> > > > To
>> > > Sent by: MAXIMO@yahoogroups.com
>> > > MAXIMO@ cc
>> > > om
>> > > Subject
>> > > [MAXIMO List] Re: Work
>> Order
>> > > 11/14/2011 09:38 AM Status
>> > >
>> > >
>> > > Please respond to
>> > > MAXIMO@
>> > > om
>> > >
>> > >
>> > >
>> > >
>> > >
>> > >
>> > >
>> > >
>> > >
>> > > Hi George,
>> > >
>> > > If you want to do it from front end, the answer is no.
>> > >
>> > > Anyhow, you can modify it from back end, provided you take care of
>> all the
>> > > data modifications to bring it back to that status.
>> > >
>> > > Thanks & regards,
>> > > Victor.
>> > >
>> > > --- In MAXIMO@yahoogroups.com, "George" <ggutierrez@> wrote:
>> > > >
>> > > > Is it possible to change a work order status from 'close' back to
>> 'comp'?
>> > > >
>> > > > thx,
>> > > > mrggutz
>> > > >
>> > >
>> >
>> >
>> >
>> >
>> >
>> >
>>
>
>
>
Agreed :)
--- In MAXIMO@yahoogroups.com, peter_camarsh@... wrote:
>
> Don't forget to update the HISTORYFLAG on the WORKORDER as well. Set it
> back to "0".
>
> Peter
>
> > After updating through SQL, you will have to either run the dbconfig or
> > restart the application server to have the changes take effect.
> >
> > Thanks & regards,
> > Victor.
> >
> > --- In MAXIMO@yahoogroups.com, "Victor" <vikas17.j@> wrote:
> >>
> >> Hi George,
> >>
> >> If there is no workflow associated to the workorders, then its quite
> >> easy to sovle your problem.
> >>
> >> You will have to update these tables :
> >>
> >> 1. WORKORDER
> >> 2. WOSTATUS
> >> 3. WOACTIVITY
> >>
> >> Update the Status to COMP in WORKORDER and WOACTIVITY for the workorders
> >> and the child workorders associated to them
> >> Delete the row of CLOSE status from the WOSTATUS table for these
> >> workorders and their child or task workorders.
> >>
> >> Hope this helps.
> >>
> >> Thanks & regards,
> >> Victor.
> >>
> >> --- In MAXIMO@yahoogroups.com, ggutierrez@ wrote:
> >> >
> >> > Yes this is Production environment.
> >> > No workflow associated to work orders.
> >> > Thanks for the link I'll take a look at it.
> >> >
> >> > The sender of this message is responsible for its content and
> >> addressing. Any actions not conforming to Petrobras System internal
> >> policies are forbidden.
> >> >
> >> >
> >> > ----- Original Message -----
> >> > From: "Victor" [vikas17.j@]
> >> > Sent: 11/14/2011 05:16 PM GMT
> >> > To: MAXIMO@yahoogroups.com
> >> > Subject: [MAXIMO List] Re: Work Order Status
> >> >
> >> >
> >> >
> >> > Hi George,
> >> >
> >> > Please let me know the following details :
> >> >
> >> > -- Is this in production environment ?
> >> > -- Is there any workflow associated to those workorders ?
> >> >
> >> > Here is one helpful link if can write the code for it :
> >> >
> >> > http://www.techno-soft.com/index.php?/how-to-change-status-of-work-orders-in-maximo-using-mbos
> >> >
> >> > Thanks & regards,
> >> > Victor.
> >> >
> >> > --- In MAXIMO@yahoogroups.com, ggutierrez@ wrote:
> >> > >
> >> > > Thanks Victor,
> >> > > I figured I couldn't do it from the front end.
> >> > > How would I go about doing it in the back end?
> >> > > I just recently activated an escalation that closes work orders
> >> older then
> >> > > 180 days now I got my receiving dept on me cause they can't post to
> >> work
> >> > > orders. See what happens when my boss says turn it on.
> >> > >
> >> > > Ya its a monday :(
> >> > >
> >> > >
> >> > >
> >> > > Thank You,
> >> > >
> >> > > George Gutierrez Jr.
> >> > > Maximo Administration
> >> > > Pasadena Refining Systems
> >> > > 713.920.3908 Direct
> >> > > 832.473.5330 Cell
> >> > > U1O2 - Chave
> >> > >
> >> > >
> >> > >
> >> > > "Victor"
> >> > > <vikas17.j@
> >> > > > To
> >> > > Sent by: MAXIMO@yahoogroups.com
> >> > > MAXIMO@ cc
> >> > > om
> >> > > Subject
> >> > > [MAXIMO List] Re: Work
> >> Order
> >> > > 11/14/2011 09:38 AM Status
> >> > >
> >> > >
> >> > > Please respond to
> >> > > MAXIMO@
> >> > > om
> >> > >
> >> > >
> >> > >
> >> > >
> >> > >
> >> > >
> >> > >
> >> > >
> >> > >
> >> > > Hi George,
> >> > >
> >> > > If you want to do it from front end, the answer is no.
> >> > >
> >> > > Anyhow, you can modify it from back end, provided you take care of
> >> all the
> >> > > data modifications to bring it back to that status.
> >> > >
> >> > > Thanks & regards,
> >> > > Victor.
> >> > >
> >> > > --- In MAXIMO@yahoogroups.com, "George" <ggutierrez@> wrote:
> >> > > >
> >> > > > Is it possible to change a work order status from 'close' back to
> >> 'comp'?
> >> > > >
> >> > > > thx,
> >> > > > mrggutz
> >> > > >
> >> > >
> >> >
> >> >
> >> >
> >> >
> >> >
> >> >
> >>
> >
> >
> >
>
That's 0 (zero), not o.
________________________________
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf
Of peter_camarsh@esg.com.au
Sent: Monday, November 14, 2011 4:09 PM
To: MAXIMO@yahoogroups.com
Subject: Re: [MAXIMO List] Re: Work Order Status
Don't forget to update the HISTORYFLAG on the WORKORDER as well. Set it
back to "0".
Peter
> After updating through SQL, you will have to either run the dbconfig
or
> restart the application server to have the changes take effect.
>
> Thanks & regards,
> Victor.
>
> --- In MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com> ,
"Victor" <vikas17.j@...> wrote:
>>
>> Hi George,
>>
>> If there is no workflow associated to the workorders, then its quite
>> easy to sovle your problem.
>>
>> You will have to update these tables :
>>
>> 1. WORKORDER
>> 2. WOSTATUS
>> 3. WOACTIVITY
>>
>> Update the Status to COMP in WORKORDER and WOACTIVITY for the
workorders
>> and the child workorders associated to them
>> Delete the row of CLOSE status from the WOSTATUS table for these
>> workorders and their child or task workorders.
>>
>> Hope this helps.
>>
>> Thanks & regards,
>> Victor.
>>
>> --- In MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com> ,
ggutierrez@ wrote:
>> >
>> > Yes this is Production environment.
>> > No workflow associated to work orders.
>> > Thanks for the link I'll take a look at it.
>> >
>> > The sender of this message is responsible for its content and
>> addressing. Any actions not conforming to Petrobras System internal
>> policies are forbidden.
>> >
>> >
>> > ----- Original Message -----
>> > From: "Victor" [vikas17.j@]
>> > Sent: 11/14/2011 05:16 PM GMT
>> > To: MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com>
>> > Subject: [MAXIMO List] Re: Work Order Status
>> >
>> >
>> >
>> > Hi George,
>> >
>> > Please let me know the following details :
>> >
>> > -- Is this in production environment ?
>> > -- Is there any workflow associated to those workorders ?
>> >
>> > Here is one helpful link if can write the code for it :
>> >
>> >
http://www.techno-soft.com/index.php?/how-to-change-status-of-work-order
s-in-maximo-using-mbos
>> >
>> > Thanks & regards,
>> > Victor.
>> >
>> > --- In MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com> ,
ggutierrez@ wrote:
>> > >
>> > > Thanks Victor,
>> > > I figured I couldn't do it from the front end.
>> > > How would I go about doing it in the back end?
>> > > I just recently activated an escalation that closes work orders
>> older then
>> > > 180 days now I got my receiving dept on me cause they can't post
to
>> work
>> > > orders. See what happens when my boss says turn it on.
>> > >
>> > > Ya its a monday :(
>> > >
>> > >
>> > >
>> > > Thank You,
>> > >
>> > > George Gutierrez Jr.
>> > > Maximo Administration
>> > > Pasadena Refining Systems
>> > > 713.920.3908 Direct
>> > > 832.473.5330 Cell
>> > > U1O2 - Chave
>> > >
>> > >
>> > >
>> > > "Victor"
>> > > <vikas17.j@
>> > > > To
>> > > Sent by: MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com>
>> > > MAXIMO@ cc
>> > > om
>> > > Subject
>> > > [MAXIMO List] Re: Work
>> Order
>> > > 11/14/2011 09:38 AM Status
>> > >
>> > >
>> > > Please respond to
>> > > MAXIMO@
>> > > om
>> > >
>> > >
>> > >
>> > >
>> > >
>> > >
>> > >
>> > >
>> > >
>> > > Hi George,
>> > >
>> > > If you want to do it from front end, the answer is no.
>> > >
>> > > Anyhow, you can modify it from back end, provided you take care
of
>> all the
>> > > data modifications to bring it back to that status.
>> > >
>> > > Thanks & regards,
>> > > Victor.
>> > >
>> > > --- In MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com> ,
"George" <ggutierrez@> wrote:
>> > > >
>> > > > Is it possible to change a work order status from 'close' back
to
>> 'comp'?
>> > > >
>> > > > thx,
>> > > > mrggutz
>> > > >
>> > >
>> >
>> >
>> >
>> >
>> >
>> >
>>
>
>
>
If the work order is for an asset you will need to delete the appropriate
row from the assethistory and assetancestor tables or you will get an error
" A record already exists" when you try to close the work order the next
time.
Kevin
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of
Robertson, Dave (Pipelines)
Sent: Monday, November 14, 2011 5:24 PM
To: MAXIMO@yahoogroups.com
Subject: RE: [MAXIMO List] Re: Work Order Status
That's 0 (zero), not o.
________________________________
From: MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com>
[mailto:MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com> ] On Behalf
Of peter_camarsh@esg.com.au <mailto:peter_camarsh%40esg.com.au>
Sent: Monday, November 14, 2011 4:09 PM
To: MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com>
Subject: Re: [MAXIMO List] Re: Work Order Status
Don't forget to update the HISTORYFLAG on the WORKORDER as well. Set it
back to "0".
Peter
> After updating through SQL, you will have to either run the dbconfig
or
> restart the application server to have the changes take effect.
>
> Thanks & regards,
> Victor.
>
> --- In MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com>
<mailto:MAXIMO%40yahoogroups.com> ,
"Victor" <vikas17.j@...> wrote:
>>
>> Hi George,
>>
>> If there is no workflow associated to the workorders, then its quite
>> easy to sovle your problem.
>>
>> You will have to update these tables :
>>
>> 1. WORKORDER
>> 2. WOSTATUS
>> 3. WOACTIVITY
>>
>> Update the Status to COMP in WORKORDER and WOACTIVITY for the
workorders
>> and the child workorders associated to them
>> Delete the row of CLOSE status from the WOSTATUS table for these
>> workorders and their child or task workorders.
>>
>> Hope this helps.
>>
>> Thanks & regards,
>> Victor.
>>
>> --- In MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com>
<mailto:MAXIMO%40yahoogroups.com> ,
ggutierrez@ wrote:
>> >
>> > Yes this is Production environment.
>> > No workflow associated to work orders.
>> > Thanks for the link I'll take a look at it.
>> >
>> > The sender of this message is responsible for its content and
>> addressing. Any actions not conforming to Petrobras System internal
>> policies are forbidden.
>> >
>> >
>> > ----- Original Message -----
>> > From: "Victor" [vikas17.j@]
>> > Sent: 11/14/2011 05:16 PM GMT
>> > To: MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com>
<mailto:MAXIMO%40yahoogroups.com>
>> > Subject: [MAXIMO List] Re: Work Order Status
>> >
>> >
>> >
>> > Hi George,
>> >
>> > Please let me know the following details :
>> >
>> > -- Is this in production environment ?
>> > -- Is there any workflow associated to those workorders ?
>> >
>> > Here is one helpful link if can write the code for it :
>> >
>> >
http://www.techno-soft.com/index.php?/how-to-change-status-of-work-order
s-in-maximo-using-mbos
>> >
>> > Thanks & regards,
>> > Victor.
>> >
>> > --- In MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com>
<mailto:MAXIMO%40yahoogroups.com> ,
ggutierrez@ wrote:
>> > >
>> > > Thanks Victor,
>> > > I figured I couldn't do it from the front end.
>> > > How would I go about doing it in the back end?
>> > > I just recently activated an escalation that closes work orders
>> older then
>> > > 180 days now I got my receiving dept on me cause they can't post
to
>> work
>> > > orders. See what happens when my boss says turn it on.
>> > >
>> > > Ya its a monday :(
>> > >
>> > >
>> > >
>> > > Thank You,
>> > >
>> > > George Gutierrez Jr.
>> > > Maximo Administration
>> > > Pasadena Refining Systems
>> > > 713.920.3908 Direct
>> > > 832.473.5330 Cell
>> > > U1O2 - Chave
>> > >
>> > >
>> > >
>> > > "Victor"
>> > > <vikas17.j@
>> > > > To
>> > > Sent by: MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com>
<mailto:MAXIMO%40yahoogroups.com>
>> > > MAXIMO@ cc
>> > > om
>> > > Subject
>> > > [MAXIMO List] Re: Work
>> Order
>> > > 11/14/2011 09:38 AM Status
>> > >
>> > >
>> > > Please respond to
>> > > MAXIMO@
>> > > om
>> > >
>> > >
>> > >
>> > >
>> > >
>> > >
>> > >
>> > >
>> > >
>> > > Hi George,
>> > >
>> > > If you want to do it from front end, the answer is no.
>> > >
>> > > Anyhow, you can modify it from back end, provided you take care
of
>> all the
>> > > data modifications to bring it back to that status.
>> > >
>> > > Thanks & regards,
>> > > Victor.
>> > >
>> > > --- In MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com>
<mailto:MAXIMO%40yahoogroups.com> ,
"George" <ggutierrez@> wrote:
>> > > >
>> > > > Is it possible to change a work order status from 'close' back
to
>> 'comp'?
>> > > >
>> > > > thx,
>> > > > mrggutz
>> > > >
>> > >
>> >
>> >
>> >
>> >
>> >
>> >
>>
>
>
>
And delete from assethierarchy where wonum = {your wonum} if the work order
was against an asset.
Otherwise you'll have problems re-closing it again.
Shannon
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of
Victor
Sent: November-14-11 2:21 PM
To: MAXIMO@yahoogroups.com
Subject: [MAXIMO List] Re: Work Order Status
Agreed :)
--- In MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com> ,
peter_camarsh@... wrote:
>
> Don't forget to update the HISTORYFLAG on the WORKORDER as well. Set it
> back to "0".
>
> Peter
>
> > After updating through SQL, you will have to either run the dbconfig or
> > restart the application server to have the changes take effect.
> >
> > Thanks & regards,
> > Victor.
> >
> > --- In MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com> ,
"Victor" <vikas17.j@> wrote:
> >>
> >> Hi George,
> >>
> >> If there is no workflow associated to the workorders, then its quite
> >> easy to sovle your problem.
> >>
> >> You will have to update these tables :
> >>
> >> 1. WORKORDER
> >> 2. WOSTATUS
> >> 3. WOACTIVITY
> >>
> >> Update the Status to COMP in WORKORDER and WOACTIVITY for the
workorders
> >> and the child workorders associated to them
> >> Delete the row of CLOSE status from the WOSTATUS table for these
> >> workorders and their child or task workorders.
> >>
> >> Hope this helps.
> >>
> >> Thanks & regards,
> >> Victor.
> >>
> >> --- In MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com> ,
ggutierrez@ wrote:
> >> >
> >> > Yes this is Production environment.
> >> > No workflow associated to work orders.
> >> > Thanks for the link I'll take a look at it.
> >> >
> >> > The sender of this message is responsible for its content and
> >> addressing. Any actions not conforming to Petrobras System internal
> >> policies are forbidden.
> >> >
> >> >
> >> > ----- Original Message -----
> >> > From: "Victor" [vikas17.j@]
> >> > Sent: 11/14/2011 05:16 PM GMT
> >> > To: MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com>
> >> > Subject: [MAXIMO List] Re: Work Order Status
> >> >
> >> >
> >> >
> >> > Hi George,
> >> >
> >> > Please let me know the following details :
> >> >
> >> > -- Is this in production environment ?
> >> > -- Is there any workflow associated to those workorders ?
> >> >
> >> > Here is one helpful link if can write the code for it :
> >> >
> >> >
http://www.techno-soft.com/index.php?/how-to-change-status-of-work-orders-in
-maximo-using-mbos
> >> >
> >> > Thanks & regards,
> >> > Victor.
> >> >
> >> > --- In MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com> ,
ggutierrez@ wrote:
> >> > >
> >> > > Thanks Victor,
> >> > > I figured I couldn't do it from the front end.
> >> > > How would I go about doing it in the back end?
> >> > > I just recently activated an escalation that closes work orders
> >> older then
> >> > > 180 days now I got my receiving dept on me cause they can't post to
> >> work
> >> > > orders. See what happens when my boss says turn it on.
> >> > >
> >> > > Ya its a monday :(
> >> > >
> >> > >
> >> > >
> >> > > Thank You,
> >> > >
> >> > > George Gutierrez Jr.
> >> > > Maximo Administration
> >> > > Pasadena Refining Systems
> >> > > 713.920.3908 Direct
> >> > > 832.473.5330 Cell
> >> > > U1O2 - Chave
> >> > >
> >> > >
> >> > >
> >> > > "Victor"
> >> > > <vikas17.j@ <mailto:vikas17.j@%0b>
> >> > > > To
> >> > > Sent by: MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com>
> >> > > MAXIMO@ cc
> >> > > om
> >> > > Subject
> >> > > [MAXIMO List] Re: Work
> >> Order
> >> > > 11/14/2011 09:38 AM Status
> >> > >
> >> > >
> >> > > Please respond to
> >> > > MAXIMO@
> >> > > om
> >> > >
> >> > >
> >> > >
> >> > >
> >> > >
> >> > >
> >> > >
> >> > >
> >> > >
> >> > > Hi George,
> >> > >
> >> > > If you want to do it from front end, the answer is no.
> >> > >
> >> > > Anyhow, you can modify it from back end, provided you take care of
> >> all the
> >> > > data modifications to bring it back to that status.
> >> > >
> >> > > Thanks & regards,
> >> > > Victor.
> >> > >
> >> > > --- In MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com> ,
"George" <ggutierrez@> wrote:
> >> > > >
> >> > > > Is it possible to change a work order status from 'close' back to
> >> 'comp'?
> >> > > >
> >> > > > thx,
> >> > > > mrggutz
> >> > > >
> >> > >
> >> >
> >> >
> >> >
> >> >
> >> >
> >> >
> >>
> >
> >
> >
>