The community will be in read-only from Tuesday 11:59pm (PST) to Wednesday 7:30am (PST)
The community will be in read-only from Tuesday 11:59pm (PST) to Wednesday 7:30am (PST)
Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Problem to send notification to current value of project manager OOTB Token @ Feld Level

SOLVED
Go to solution
Highlighted
Phanishwar
Collector

Problem to send notification to current value of project manager OOTB Token @ Feld Level

Hi,

I am trying to send notification at Filed level . The business requirement is to send to notification whenever there is change to project manager field(KNTA_PROJECT_MANAGER OOTB ) to previous manager(old value) and new Manager (new Value) . I store the new value in other custom field and using to send notification to new manager(custum field token) and old manager(KNTA_PROJECT_MANAGER). When the project manager field is changed first time , Notification does not go to new manager(new value)..why?.it seems that token send notification using previous value on SAVE.

Pls help!!
7 REPLIES
Mahen M
Honored Contributor

Re: Problem to send notification to current value of project manager OOTB Token @ Feld Level

Hi Phanishwar,
The mail trigger event occurs first and then the 'save' event.

You cannot send mail to new value, This is a known inconsistency in PPM 7.1, I asked HP some time back about the possibility, They told it is not possible, You can ask them again if they have any work arounds, Else you can raise an Enhancement request.

Thanks.

Regards,
Mahendran M
Phanishwar
Collector

Re: Problem to send notification to current value of project manager OOTB Token @ Feld Level

it means that mail is sent using token previous value, does it mean that it picks the previous value from database??..if that is the case we can update the storage in database at field change first (this is possible by calling a autonomous function (SUpport DML sqls)in rule. the when clicked on save , the previous value would be the new value as we have updated. this will not work if tokens value does not sync with database update??

any thought pls
Phanishwar
Collector

Re: Problem to send notification to current value of project manager OOTB Token @ Feld Level

where does old and new value is stored in PPM. is that at application level? pls share your views..thx!
Phanishwar
Collector

Re: Problem to send notification to current value of project manager OOTB Token @ Feld Level

Hi Mahendran,

Yes it is working by backend update. Update the new value in the hidden field at field change first by calling autonomous function which will updtae the hidden field with the new value . Now after that SAVE event will call the mail trigger that willl use the updated value in DB!!...This is one of work around...for PPM7.1 inconsistency..:)

Thanks for you input helped me think this way!!
Mahen M
Honored Contributor
Solution

Re: Problem to send notification to current value of project manager OOTB Token @ Feld Level

You mean custom PL/SQL Function?

Regards,
Mahendran M
Phanishwar
Collector

Re: Problem to send notification to current value of project manager OOTB Token @ Feld Level

yes...as we know that we cannot call a function with update statement so in declare section of function put pragma autonomous_transaction ....now you can call the function in rule tab as :

select f1, f1 from dual..f1 updates a hidden field with new value(pass token in F1 as parameter)..You can return any value from function which can be stored in another filed. The hidden field which is updated TOKEn of that is use dto send notificatoin....
Mahen M
Honored Contributor

Re: Problem to send notification to current value of project manager OOTB Token @ Feld Level

Great, glad that your problem is resolved.

Regards,
Mahendran M
//Add this to "OnDomLoad" event