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.
Question for the group..
Without using db triggers.. When a workorder is generated from a PM how can you set the target finsh 30 days after the target start if the PM frequency is 1 month?
Seems like this should and could be a Maximo function.. I have seen for years people using DB triggers to make this happen..
What are others using? Got any good ideas that I could test?
We used job plans with a month of hours in the duration field.
Chris McClinch
On Thu, Apr 26, 2012 at 9:45 AM, shannon <ssutton@emcor.net> wrote:
> **
>
>
> Question for the group..
>
> Without using db triggers.. When a workorder is generated from a PM how
> can you set the target finsh 30 days after the target start if the PM
> frequency is 1 month?
>
> Seems like this should and could be a Maximo function.. I have seen for
> years people using DB triggers to make this happen..
>
> What are others using? Got any good ideas that I could test?
>
>
>
Ah good idea...
I am using 7.5 and we have discovered this field..
Field: Finish Constraint Offset
Table.Column: PM.FNCONOFFSET
The amount of time (in hours) to be added to the Target Finish date in
order to calculate the Finish No Later Than date of the work record.
So far it doesn't seem to be working as the description says it does...
Shannon Sutton
CMMS Specialist
EMCOR Government Services
Office: 571-403-8940
Cell: 571-970-7965
From: Chris McClinch <chris.mcclinch@gmail.com>
To: MAXIMO@yahoogroups.com
Date: 04/26/2012 09:46 AM
Subject: Re: [MAXIMO List] Adjusting Target Finish Date based on
Contractual Requirements
Sent by: MAXIMO@yahoogroups.com
We used job plans with a month of hours in the duration field.
Chris McClinch
On Thu, Apr 26, 2012 at 9:45 AM, shannon <ssutton@emcor.net> wrote:
> **
>
>
> Question for the group..
>
> Without using db triggers.. When a workorder is generated from a PM how
> can you set the target finsh 30 days after the target start if the PM
> frequency is 1 month?
>
> Seems like this should and could be a Maximo function.. I have seen for
> years people using DB triggers to make this happen..
>
> What are others using? Got any good ideas that I could test?
>
>
>
This message is for the named person's use only. It may contain confidential,
proprietary or legally privileged information. No confidentiality or privilege
is waived or lost by any mistransmission. If you receive this message in error,
please immediately delete it and all copies of it from your system, destroy any
hard copies of it and notify the sender. You must not, directly or indirectly,
use, disclose, distribute, print, or copy any part of this message if you are
not the intended recipient.
We use 6.2.6, and we do exactly what Chris said earlier. There's no offset thing like this in 6.x.
Travis Herron
--- In MAXIMO@yahoogroups.com, Shannon Sutton <ssutton@...> wrote:
>
> Ah good idea...
>
> I am using 7.5 and we have discovered this field..
>
>
> Field: Finish Constraint Offset
> Table.Column: PM.FNCONOFFSET
> The amount of time (in hours) to be added to the Target Finish date in
> order to calculate the Finish No Later Than date of the work record.
>
> So far it doesn't seem to be working as the description says it does...
>
>
>
> Shannon Sutton
> CMMS Specialist
> EMCOR Government Services
> Office: 571-403-8940
> Cell: 571-970-7965
>
>
>
>
> From: Chris McClinch <chris.mcclinch@...>
> To: MAXIMO@yahoogroups.com
> Date: 04/26/2012 09:46 AM
> Subject: Re: [MAXIMO List] Adjusting Target Finish Date based on
> Contractual Requirements
> Sent by: MAXIMO@yahoogroups.com
>
>
>
>
>
>
> We used job plans with a month of hours in the duration field.
>
> Chris McClinch
>
> On Thu, Apr 26, 2012 at 9:45 AM, shannon <ssutton@...> wrote:
>
> > **
> >
> >
> > Question for the group..
> >
> > Without using db triggers.. When a workorder is generated from a PM how
> > can you set the target finsh 30 days after the target start if the PM
> > frequency is 1 month?
> >
> > Seems like this should and could be a Maximo function.. I have seen for
> > years people using DB triggers to make this happen..
> >
> > What are others using? Got any good ideas that I could test?
> >
> >
> >
>
>
>
>
>
>
> This message is for the named person's use only. It may contain confidential,
> proprietary or legally privileged information. No confidentiality or privilege
> is waived or lost by any mistransmission. If you receive this message in error,
> please immediately delete it and all copies of it from your system, destroy any
> hard copies of it and notify the sender. You must not, directly or indirectly,
> use, disclose, distribute, print, or copy any part of this message if you are
> not the intended recipient.
>
Hi,
Create an escalation on the workorder to find the PM workorders where the PM frequency is 1 month and the targcompdate is not 30 days after the targstartdate . Then in that escalation use an action to update the targcompdate to targstartdate + 30.
:targstartdate+30
Dave Bone
--- In MAXIMO@yahoogroups.com, "shannon" <ssutton@...> wrote:
>
> Question for the group..
>
> Without using db triggers.. When a workorder is generated from a PM how can you set the target finsh 30 days after the target start if the PM frequency is 1 month?
>
> Seems like this should and could be a Maximo function.. I have seen for years people using DB triggers to make this happen..
>
> What are others using? Got any good ideas that I could test?
>
We use a update type of report to include update SQL statement to update the target completion dates to the end of the month of the report date, if the target completion date is not set to the end of the month yet.
Then we schedule the report to run every hour. It works not bad.
Has anyone found out how to best use these fields? There seems to be a dearth of documentation on the constraints and offsets.