NZOUG Call for Papers - Conference 20-21 October 2008

Keen to head down-under? Check out this message from the New Zealand Oracle Users Group.

The New Zealand Oracle Users Group is pleased to announce… Call for Papers and Training for the 2008 Conference We only require your ABSTRACT of not more than 150 words at this stage. We invite all users and suppliers of Oracle technology and applications and related products to submit presentations, including Oracle Users with an interesting story, case study or any useful tips Oracle Partners playing a key role in the Oracle world Third party suppliers of products and services that will assist Oracle technology and application users Presentation topics may include but are not limited to Oracle Aplications such as eBS, JDE, Peoplesoft and Hyperion, and Oracle Development, Middleware and Database technologies. Everything is welcome for submission but delegates are especially interested in hearing case studies of real life scenarios and situations, lessons learnt and best practices. Both Technical and Business streams will run throughout the conference programme with presentations covering the implementation, use and support of the whole range of Oracle and associated third party products and services. If your paper is selected for presentation: You’ll be admitted to the conference free of charge upon submission of your full written paper, and Your paper will be published in the conference proceedings.
SUBMITTING AN ABSTRACT
How do I submit an abstract? Visit our submission website and complete the Call for Papers submission, by 20 June 2008 Also anyone can submit topics you are interested in, and we’ll try to source a presenter for the topic. We’ll post further information about this and for presenters on our website in due course. Remember to visit our website for all up to date information on regional events, the conference, and other news. We look forward to receiving your completed submissions by 20 June 2008
HOW DO I REGISTER FOR THE CONFERENCE?
We are not quite ready to open registration but watch this space (or keep an eye on our website) in the next few weeks for an announcement.
WHAT DISCOUNTS CAN WE GET?
There will be an early bird discount for all registrations before the 1st September 2008. Watch this space for these great rates.
VENUE AND DATES
Rotorua 20th and 21st October 2008 Novotel Rotorua Lakeside – Rotorua
NEED MORE INFORMATION?
Any questions please contact our conference management company, The Conference Company. By phone on +64 9 360 1240 or by email at nzoug@tcc.co.nz

Clearing Email Notifications and manually setting the Workflow/Java Notification Mailer Override/Test Address via SQL for the Oracle eBusiness Suite

Update: 14-Mar-2012 Added supported back-end method to update Workflow Notification Mailer attributes. Warning: This post also contains unsupported SQL updates, use at your own risk!

I think the Workflow Notification Mailer is excellent, but one of my pet hates is the setup process for a mailer. I never seem to be able to get it setup cleanly. One thing that really bugs me is that the Service Component Manager (Workflow Mailer Service) needs to be running before you can set the "Override Address". So when setting up a mailer you have to be very careful that the "Manual" startup option is set or your Mailer will start after configuration or when you startup the Workflow Mailer Service. Similarly caution is needed when cloning non-Prod environments from Prod when the Prod Override Address is not set, but Test/Dev etc need to be set.

Additionally, there's no button anywhere with a label like "Click me to update all Mail_Status pending Notifications as Sent" which is what the following accomplishes:

update WF_NOTIFICATIONS
set mail_status = 'SENT'
where mail_status = 'MAIL';

# Note: Change the apps_password in the following command
sqlplus apps @$FND_TOP/patch/115/sql/wfntfqup.sql APPS apps_password APPLSYS

Okay, so here's how you get the current Override Address via SQL on the backend:

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; 

And now here's a very unsupported way to update the Override Address - please try this on a Test environment first to make sure it works for you! Note this will update all Mailers you have setup. Recommended to stop and start the mailers after making this change. Also make sure you change the email address to your Test Address and change the NONE to your current value (from previous SQL) if necessary:

update fnd_svc_comp_param_vals
set    parameter_value = 'MyTestAddress@MyCompany.com'
where  parameter_value = 'NONE'
and    parameter_id =
( select parameter_id
 from   fnd_svc_comp_params_tl
 where  display_name = 'Test Address'
);

commit;

Update: 14-Mar-2012 - There is a supported way to make back-end updates to Workflow Notification Mailer (and other service components). This is documented in Support Note 1399464.1. In short run the following and follow the prompts:

sqlplus apps @$FND_TOP/sql/afsvcpup.sql

PS. See Metalink Note 467229.1 if you get the dreaded "ORA-20000: Oracle Error = -20000 - ORA-20000: 330 Alert messages exist in WF_NOTIFICATION_OUT. Ensure these messages are processed before running wfntfqup.sql"

PPS. Anil has a nice post clear post where the Override Address (Test Address) lives these days here.