Query to check Override address in EBS workflow notification Mailer:
SQL>
select fscpv.parameter_value
from fnd_svc_comp_params_tl fscpt
,fnd_svc_comp_param_vals fscpv
where fscpt.display_name = ‘Test Address’
and fscpt.parameter_id = fscpv.parameter_id;
PARAMETER_VALUE
——————————————————————————–
NONE
SQL Query to update Override email address from backend in EBS :
SQL> update fnd_svc_comp_param_vals
set parameter_value = ‘TEST_EMAIL@DOMAIN.COM’
where parameter_id =
( select parameter_id
from fnd_svc_comp_params_tl
where display_name = ‘Test Address’);
1 row updated.
SQL> commit;
Commit complete.
Verify that override email address is updated:
SQL> select fscpv.parameter_value
from fnd_svc_comp_params_tl fscpt
,fnd_svc_comp_param_vals fscpv
where fscpt.display_name = ‘Test Address’
and fscpt.parameter_id = fscpv.parameter_id;
PARAMETER_VALUE
——————————————————————————–
TEST_EMAIL@DOMAIN.COM
SQL>
Your style is really unique in comparison to other people I’ve read stuff from.
Many thanks for posting when you’ve got the opportunity, Guess I will just bookmark this page.
Visit my homepage :: nordvpn coupons inspiresensation
It’s very trouble-free to find out any topic
on net as compared to textbooks, as I found this piece of writing at
this web page.
my site: nordvpn coupons inspiresensation
This website was… how do you say it? Relevant!! Finally I’ve found something that helped me.
Thanks a lot!
My website … nordvpn coupons inspiresensation
350fairfax Nordvpn Coupons Inspiresensation
What’s up, for all time i used to check web site posts here in the early hours in the break of day, as i love to gain knowledge of more and more.
Thanks for sharing your thoughts on vpn.
Regards
Having read this I thought it was rather enlightening. I appreciate
you taking the time and effort to put this informative article together.
I once again find myself spending a significant amount of time both reading and leaving comments.
But so what, it was still worthwhile! https://tinyurl.com/23mmjj8a gamefly free trial
Awesome! Its genuinely remarkable post, I have got much clear idea regarding from this post
Very well presented. Every quote was awesome and thanks for sharing the content. Keep sharing and keep motivating others.
It’s actually a nice and helpful piece of information.
I am glad that you shared this helpful info with us.
Please stay us up to date like this. Thanks for sharing. What
is a vpn meaning https://tinyurl.com/2atd6fak
I am sure this post has touched all the internet users, its really really fastidious paragraph on building up new blog.
Howdy! Do you know if they make any plugins to assist with SEO?
I’m trying to get my blog to rank for some targeted
keywords but I’m not seeing very good gains.
If you know of any please share. Thank you!