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.
Dear all,
I have added a new custom field both in wpmaterial & invreserve, let say:
xxx. The idea is, user can fill xxx value in wo status of WAPPR and once
approved, xxx will copied to invreserve.xxx.
Actually, crossoverdomain has written but still getting an error:
domainid=TEST assign to INVRESERVE.REQUESTNUM
domainid=TEST
object: WPITEM
validation where clause: wpitemid=:requestnum and siteid=:siteid
crossoverfields:
sourcefield = destinationfield = SIWNUM
Error raise:
BMXAA4590E - Could not change {2} 2008/84 status to APPR.
BMXAA4590E - Could not change Work Order 2008/84 status to APPR.
BMXAA4191E - The value 163043 is not valid for Request. Specify a valid
value for Request.
How can i solve that problem?
Best Regards,
Yudi Irianto
Max75, Was, sql2008r2
WPITEMID = :REQUESTNUM ???
That doesn't seem right to me. Should be WPITEMID = :ITEMNUM
Travis Herron
--- In MAXIMO@yahoogroups.com, yudi.irianto@... wrote:
>
> Dear all,
>
> I have added a new custom field both in wpmaterial & invreserve, let say:
> xxx. The idea is, user can fill xxx value in wo status of WAPPR and once
> approved, xxx will copied to invreserve.xxx.
> Actually, crossoverdomain has written but still getting an error:
>
> domainid=TEST assign to INVRESERVE.REQUESTNUM
>
> domainid=TEST
> object: WPITEM
> validation where clause: wpitemid=:requestnum and siteid=:siteid
> crossoverfields:
> sourcefield = destinationfield = SIWNUM
>
> Error raise:
> BMXAA4590E - Could not change {2} 2008/84 status to APPR.
> BMXAA4590E - Could not change Work Order 2008/84 status to APPR.
> BMXAA4191E - The value 163043 is not valid for Request. Specify a valid
> value for Request.
>
> How can i solve that problem?
>
>
> Best Regards,
>
> Yudi Irianto
>
> Max75, Was, sql2008r2
>
>
>
Hi Travis,
wpitem is base table for wpmaterial (view) and wpservice (view), both 2
tables doesn't exist in db physically. So, WPITEM.WPITEMID linked to
WPMATERIAL.REQUESTNUM or WPSERVICE.REQUESTNUM.
Best Regards,
Yudi Irianto
"Travis Herron" <therron@pcci.edu>
Sent by: MAXIMO@yahoogroups.com
19-03-2012 19:44
Please respond to
MAXIMO@yahoogroups.com
To
MAXIMO@yahoogroups.com
cc
Subject
[MAXIMO List] Re: cannot appr wo
WPITEMID = :REQUESTNUM ???
That doesn't seem right to me. Should be WPITEMID = :ITEMNUM
Travis Herron
--- In MAXIMO@yahoogroups.com, yudi.irianto@... wrote:
>
> Dear all,
>
> I have added a new custom field both in wpmaterial & invreserve, let
say:
> xxx. The idea is, user can fill xxx value in wo status of WAPPR and once
> approved, xxx will copied to invreserve.xxx.
> Actually, crossoverdomain has written but still getting an error:
>
> domainid=TEST assign to INVRESERVE.REQUESTNUM
>
> domainid=TEST
> object: WPITEM
> validation where clause: wpitemid=:requestnum and siteid=:siteid
> crossoverfields:
> sourcefield = destinationfield = SIWNUM
>
> Error raise:
> BMXAA4590E - Could not change {2} 2008/84 status to APPR.
> BMXAA4590E - Could not change Work Order 2008/84 status to APPR.
> BMXAA4191E - The value 163043 is not valid for Request. Specify a valid
> value for Request.
>
> How can i solve that problem?
>
>
> Best Regards,
>
> Yudi Irianto
>
> Max75, Was, sql2008r2
>
>
>
You are currently linking an ITEM NUMBER in the wpitem table to a REQUEST NUMBER in the invreserve table.
Why would you not link the ITEM NUMBER in wpitem to the ITEM NUMBER in invreserve?
Your domain should be:
domainid=TEST assign to INVRESERVE.REQUESTNUM (this is right)
> >
> > domainid=TEST
> > object: WPITEM
> > validation where clause: wpitemid=:itemnum and siteid=:siteid
> > crossoverfields:
> > sourcefield = destinationfield = SIWNUM
The validation where clause is what I'm suggesting is currently wrong.
Travis Herron
--- In MAXIMO@yahoogroups.com, yudi.irianto@... wrote:
>
> Hi Travis,
>
> wpitem is base table for wpmaterial (view) and wpservice (view), both 2
> tables doesn't exist in db physically. So, WPITEM.WPITEMID linked to
> WPMATERIAL.REQUESTNUM or WPSERVICE.REQUESTNUM.
>
>
> Best Regards,
>
> Yudi Irianto
>
>
>
> "Travis Herron" <therron@...>
> Sent by: MAXIMO@yahoogroups.com
> 19-03-2012 19:44
> Please respond to
> MAXIMO@yahoogroups.com
>
>
> To
> MAXIMO@yahoogroups.com
> cc
>
> Subject
> [MAXIMO List] Re: cannot appr wo
>
>
>
>
>
>
>
> WPITEMID = :REQUESTNUM ???
>
> That doesn't seem right to me. Should be WPITEMID = :ITEMNUM
>
> Travis Herron
>
> --- In MAXIMO@yahoogroups.com, yudi.irianto@ wrote:
> >
> > Dear all,
> >
> > I have added a new custom field both in wpmaterial & invreserve, let
> say:
> > xxx. The idea is, user can fill xxx value in wo status of WAPPR and once
>
> > approved, xxx will copied to invreserve.xxx.
> > Actually, crossoverdomain has written but still getting an error:
> >
> > domainid=TEST assign to INVRESERVE.REQUESTNUM
> >
> > domainid=TEST
> > object: WPITEM
> > validation where clause: wpitemid=:requestnum and siteid=:siteid
> > crossoverfields:
> > sourcefield = destinationfield = SIWNUM
> >
> > Error raise:
> > BMXAA4590E - Could not change {2} 2008/84 status to APPR.
> > BMXAA4590E - Could not change Work Order 2008/84 status to APPR.
> > BMXAA4191E - The value 163043 is not valid for Request. Specify a valid
> > value for Request.
> >
> > How can i solve that problem?
> >
> >
> > Best Regards,
> >
> > Yudi Irianto
> >
> > Max75, Was, sql2008r2
> >
> >
> >
>
>
>
>
>
>
>