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,
We would like to send a mail notification for material receipts that is a mail should send to the user that requesting the item "MatRecTrans.RequestedBy" telling him that "your requested items has been received and waiting your inspection".
The problem is , we want send one mail per person for multiple items , that is if he requested 10 items and the items has received , he should receive one mail contains the items - not 10 mails.
I was thinking in escalation with action class but the escalation would run for every record.
So any ideas
Best regards,
Amir Anwar
Senior Software Engineer
Beshay Steel Egypt
I was just getting to a similar request myself.
I believe there's a new syntax that you can use to have multiple items
listed in a Communications Template. I was thinking of trying to use that
on an PR escalation, instead of putting it on MATRECTRANS.
I haven't tried it out yet, but will be doing so shortly. I'll let you know
the results if you haven't found a solution by then.
Shannon Rotz
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of
amir samir
Sent: September-30-13 7:08 AM
To: maximogroup
Subject: [MAXIMO List] Escalation and Custom Action
Dear All,
We would like to send a mail notification for material receipts that is a
mail should send to the user that requesting the item
"MatRecTrans.RequestedBy" telling him that "your requested items has been
received and waiting your inspection".
The problem is , we want send one mail per person for multiple items , that
is if he requested 10 items and the items has received , he should receive
one mail contains the items - not 10 mails.
I was thinking in escalation with action class but the escalation would run
for every record.
So any ideas
Best regards,
Amir Anwar
Senior Software Engineer
Beshay Steel Egypt
Shannon ,
I haven't any solution so far , about using the PR table , it worth try but what if the warehouse received multiple items in multiple POs for the same user. Also what if you received the PO partially , if you unchecked repeat , the escalation won't hit again , if you check "Repeat" then the user will receive the mails every time the escalation run until he inspect the item.am I right??
Best regards,
Amir Anwar
Senior Software Engineer
Beshay Steel Egypt
________________________________
From: Incomm Solutions Inc. <shannonrotz@yahoo.ca>
To: MAXIMO@yahoogroups.com
Sent: Tuesday, October 1, 2013 5:26 PM
Subject: RE: [MAXIMO List] Escalation and Custom Action
I was just getting to a similar request myself.
I believe there's a new syntax that you can use to have multiple items
listed in a Communications Template. I was thinking of trying to use that
on an PR escalation, instead of putting it on MATRECTRANS.
I haven't tried it out yet, but will be doing so shortly. I'll let you know
the results if you haven't found a solution by then.
Shannon Rotz
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of
amir samir
Sent: September-30-13 7:08 AM
To: maximogroup
Subject: [MAXIMO List] Escalation and Custom Action
Dear All,
We would like to send a mail notification for material receipts that is a
mail should send to the user that requesting the item
"MatRecTrans.RequestedBy" telling him that "your requested items has been
received and waiting your inspection".
The problem is , we want send one mail per person for multiple items , that
is if he requested 10 items and the items has received , he should receive
one mail contains the items - not 10 mails.
I was thinking in escalation with action class but the escalation would run
for every record.
So any ideas
Best regards,
Amir Anwar
Senior Software Engineer
Beshay Steel Egypt
Yes, but I would normally put it on repeat, and then add a time check. For instance: assuming my escalation runs every day, I would check only for receipts that were entered (MATRECTRANS.TRANSDATE) in the last day. Otherwise you have the problem you described, plus your users will get receipts for everything that was done prior to the implementation.
For getting to the receipts from the PR: you would have to use a relationship of some kind, to join to the POLINE table (via PRLINE.PONUM), then to the receipt.
If that doesn’t work (and it may not – I haven’t tried it yet), at the minimum you could have the Escalation check for receipts against a PO line that came from the user’s PR, i.e.
prnum in (select prnum from prline, poline, matrectrans
where prline.ponum = poline.ponum and prline.polinenum = poline.polinenum
and poline.ponum = matrectrans.ponum and poline.polinenum = matrectrans.polinenum
and trunc(matrectrans.transdate) = trunc(sysdate)-1)
Then you could say:
Receipts have been entered against PR :PRNUM, described as :DESCRIPTION
That wouldn’t give them a huge amount of detail, but it would alert them to the fact that a receipt had been made. Or, to give them a bit more detail, you could put the Escalation against the PRLINE object, but then they would get an e-mail for each PR line.
Keep in mind that I’m thinking out loud here – :)
Shannon Rotz
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of amir samir
Sent: October-01-13 8:41 AM
To: MAXIMO@yahoogroups.com
Subject: Re: [MAXIMO List] Escalation and Custom Action
Shannon ,
I haven't any solution so far , about using the PR table , it worth try but what if the warehouse received multiple items in multiple POs for the same user. Also what if you received the PO partially , if you unchecked repeat , the escalation won't hit again , if you check "Repeat" then the user will receive the mails every time the escalation run until he inspect the item.am I right??
Best regards,
Amir Anwar
Senior Software Engineer
Beshay Steel Egypt
_____
From: Incomm Solutions Inc. <shannonrotz@yahoo.ca>
To: MAXIMO@yahoogroups.com
Sent: Tuesday, October 1, 2013 5:26 PM
Subject: RE: [MAXIMO List] Escalation and Custom Action
I was just getting to a similar request myself.
I believe there's a new syntax that you can use to have multiple items
listed in a Communications Template. I was thinking of trying to use that
on an PR escalation, instead of putting it on MATRECTRANS.
I haven't tried it out yet, but will be doing so shortly. I'll let you know
the results if you haven't found a solution by then.
Shannon Rotz
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of
amir samir
Sent: September-30-13 7:08 AM
To: maximogroup
Subject: [MAXIMO List] Escalation and Custom Action
Dear All,
We would like to send a mail notification for material receipts that is a
mail should send to the user that requesting the item
"MatRecTrans.RequestedBy" telling him that "your requested items has been
received and waiting your inspection".
The problem is , we want send one mail per person for multiple items , that
is if he requested 10 items and the items has received , he should receive
one mail contains the items - not 10 mails.
I was thinking in escalation with action class but the escalation would run
for every record.
So any ideas
Best regards,
Amir Anwar
Senior Software Engineer
Beshay Steel Egypt
Shannon ,
Good thinking , in my case I would prefer to run the escalation on person object , that is if the warehouse received multiple PO for the same user , he would receive one mail , not as many as the number of PO/PR
Best regards,
Amir Anwar
Senior Software Engineer
Beshay Steel Egypt
________________________________
From: Incomm Solutions Inc. <shannonrotz@yahoo.ca>
To: MAXIMO@yahoogroups.com
Sent: Tuesday, October 1, 2013 6:45 PM
Subject: RE: [MAXIMO List] Escalation and Custom Action
Yes, but I would normally put it on repeat, and then add a time check. For instance: assuming my escalation runs every day, I would check only for receipts that were entered (MATRECTRANS.TRANSDATE) in the last day. Otherwise you have the problem you described, plus your users will get receipts for everything that was done prior to the implementation.
For getting to the receipts from the PR: you would have to use a relationship of some kind, to join to the POLINE table (via PRLINE.PONUM), then to the receipt.
If that doesn’t work (and it may not – I haven’t tried it yet), at the minimum you could have the Escalation check for receipts against a PO line that came from the user’s PR, i.e.
prnum in (select prnum from prline, poline, matrectrans
where prline.ponum = poline.ponum and prline.polinenum = poline.polinenum
and poline.ponum = matrectrans.ponum and poline.polinenum = matrectrans.polinenum
and trunc(matrectrans.transdate) = trunc(sysdate)-1)
Then you could say:
Receipts have been entered against PR :PRNUM, described as :DESCRIPTION
That wouldn’t give them a huge amount of detail, but it would alert them to the fact that a receipt had been made. Or, to give them a bit more detail, you could put the Escalation against the PRLINE object, but then they would get an e-mail for each PR line.
Keep in mind that I’m thinking out loud here – :)
Shannon Rotz
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of amir samir
Sent: October-01-13 8:41 AM
To: MAXIMO@yahoogroups.com
Subject: Re: [MAXIMO List] Escalation and Custom Action
Shannon ,
I haven't any solution so far , about using the PR table , it worth try but what if the warehouse received multiple items in multiple POs for the same user. Also what if you received the PO partially , if you unchecked repeat , the escalation won't hit again , if you check "Repeat" then the user will receive the mails every time the escalation run until he inspect the item.am I right??
Best regards,
Amir Anwar
Senior Software Engineer
Beshay Steel Egypt
_____
From: Incomm Solutions Inc. <shannonrotz@yahoo.ca>
To: MAXIMO@yahoogroups.com
Sent: Tuesday, October 1, 2013 5:26 PM
Subject: RE: [MAXIMO List] Escalation and Custom Action
I was just getting to a similar request myself.
I believe there's a new syntax that you can use to have multiple items
listed in a Communications Template. I was thinking of trying to use that
on an PR escalation, instead of putting it on MATRECTRANS.
I haven't tried it out yet, but will be doing so shortly. I'll let you know
the results if you haven't found a solution by then.
Shannon Rotz
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of
amir samir
Sent: September-30-13 7:08 AM
To: maximogroup
Subject: [MAXIMO List] Escalation and Custom Action
Dear All,
We would like to send a mail notification for material receipts that is a
mail should send to the user that requesting the item
"MatRecTrans.RequestedBy" telling him that "your requested items has been
received and waiting your inspection".
The problem is , we want send one mail per person for multiple items , that
is if he requested 10 items and the items has received , he should receive
one mail contains the items - not 10 mails.
I was thinking in escalation with action class but the escalation would run
for every record.
So any ideas
Best regards,
Amir Anwar
Senior Software Engineer
Beshay Steel Egypt
Shannon ,
Since morning and I was trying to find a solution and while I was reading your mail , my solution is worked so far , just want to share it with the group.
I had run the escalation on MatRecTrans table with no repeat , then in the action class , I returned the MboSet the collecting all items that match the current mbo - requested by :
public void applyCustomAction(MboRemote mbo, Object[] params) throws MXException, RemoteException
{
MboSetRemote mbosetremote=mbo.getMboSet("$MatRecTrans","MATRECTRANS","status='WINSP' and requestedby='"+mbo.getString("requestedby")+"' and siteid='"+mbo.getString("siteid")+"'");
then i run a loop to collect the data and within the loop i have insereted a record in escalationrepeattrack object of the all the record in the set and hence when the first escalation action is complete , it won't hit for the other user records because they are checked as complete in escalationrepeattrack :
for (int i=0;mbosetremote.getMbo(i)!=null;i++)
{
items.append(i+1).append("\t"+mbosetremote.getMbo(i).getString("itemnum")).append("\t"+mbosetremote.getMbo(i).getString("description")).append("\t"+mbosetremote.getMbo(i).getString("ponum")).append("\t"+mbosetremote.getMbo(i).getString("quantity")).append("\t"+mbosetremote.getMbo(i).getString("RECEIVEDUNIT")).append("\r\n");
esrtrack = (EscalationRepeatTrackingRemote) esrtrackset.add();
esrtrack.setValue("ownerid", mbosetremote.getMbo(i).getInt("matrectransid"));
esrtrack.setValue("objectname","MATRECTRANS");
esrtrack.setValue("refpointid",2101609);
esrtrack.setValue("escalation","WINSP-ITEMS");
try
{
esrtrackset.save();
}
catch(Exception e)
{
continue;
}
}
esrtrackset.close();
I hope I made myself clear.
Best regards,
Amir Anwar
Senior Software Engineer
Beshay Steel Egypt
________________________________
From: Incomm Solutions Inc. <shannonrotz@yahoo.ca>
To: MAXIMO@yahoogroups.com
Sent: Tuesday, October 1, 2013 6:45 PM
Subject: RE: [MAXIMO List] Escalation and Custom Action
Yes, but I would normally put it on repeat, and then add a time check. For instance: assuming my escalation runs every day, I would check only for receipts that were entered (MATRECTRANS.TRANSDATE) in the last day. Otherwise you have the problem you described, plus your users will get receipts for everything that was done prior to the implementation.
For getting to the receipts from the PR: you would have to use a relationship of some kind, to join to the POLINE table (via PRLINE.PONUM), then to the receipt.
If that doesn’t work (and it may not – I haven’t tried it yet), at the minimum you could have the Escalation check for receipts against a PO line that came from the user’s PR, i.e.
prnum in (select prnum from prline, poline, matrectrans
where prline.ponum = poline.ponum and prline.polinenum = poline.polinenum
and poline.ponum = matrectrans.ponum and poline.polinenum = matrectrans.polinenum
and trunc(matrectrans.transdate) = trunc(sysdate)-1)
Then you could say:
Receipts have been entered against PR :PRNUM, described as :DESCRIPTION
That wouldn’t give them a huge amount of detail, but it would alert them to the fact that a receipt had been made. Or, to give them a bit more detail, you could put the Escalation against the PRLINE object, but then they would get an e-mail for each PR line.
Keep in mind that I’m thinking out loud here – :)
Shannon Rotz
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of amir samir
Sent: October-01-13 8:41 AM
To: MAXIMO@yahoogroups.com
Subject: Re: [MAXIMO List] Escalation and Custom Action
Shannon ,
I haven't any solution so far , about using the PR table , it worth try but what if the warehouse received multiple items in multiple POs for the same user. Also what if you received the PO partially , if you unchecked repeat , the escalation won't hit again , if you check "Repeat" then the user will receive the mails every time the escalation run until he inspect the item.am I right??
Best regards,
Amir Anwar
Senior Software Engineer
Beshay Steel Egypt
_____
From: Incomm Solutions Inc. <shannonrotz@yahoo.ca>
To: MAXIMO@yahoogroups.com
Sent: Tuesday, October 1, 2013 5:26 PM
Subject: RE: [MAXIMO List] Escalation and Custom Action
I was just getting to a similar request myself.
I believe there's a new syntax that you can use to have multiple items
listed in a Communications Template. I was thinking of trying to use that
on an PR escalation, instead of putting it on MATRECTRANS.
I haven't tried it out yet, but will be doing so shortly. I'll let you know
the results if you haven't found a solution by then.
Shannon Rotz
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of
amir samir
Sent: September-30-13 7:08 AM
To: maximogroup
Subject: [MAXIMO List] Escalation and Custom Action
Dear All,
We would like to send a mail notification for material receipts that is a
mail should send to the user that requesting the item
"MatRecTrans.RequestedBy" telling him that "your requested items has been
received and waiting your inspection".
The problem is , we want send one mail per person for multiple items , that
is if he requested 10 items and the items has received , he should receive
one mail contains the items - not 10 mails.
I was thinking in escalation with action class but the escalation would run
for every record.
So any ideas
Best regards,
Amir Anwar
Senior Software Engineer
Beshay Steel Egypt
Hi Amir,
you need to use the communication template and use relationship to list
these item list in the communication template message. This can be achieved
without a custom class or action.
Warm regards,
ViK
Linkedin : http://www.linkedin.com/profile/view?id=116944905&trk=tab_pro
On Mon, Sep 30, 2013 at 7:37 PM, amir samir <amir_s_anwar@yahoo.com> wrote:
> **
>
>
> Dear All,
> We would like to send a mail notification for material receipts that is a
> mail should send to the user that requesting the item
> "MatRecTrans.RequestedBy" telling him that "your requested items has been
> received and waiting your inspection".
> The problem is , we want send one mail per person for multiple items ,
> that is if he requested 10 items and the items has received , he should
> receive one mail contains the items - not 10 mails.
> I was thinking in escalation with action class but the escalation would
> run for every record.
> So any ideas
>
> Best regards,
> Amir Anwar
> Senior Software Engineer
> Beshay Steel Egypt
>
>
>