Oracle Workflow not working and giving java null pointer exception..

May 17, 2012

Oracle Workflow not working and giving java null pointer exception..

Recently we had an issue in our production environment where the POP3 server for Workflow was migrated to a new host and hence while changing/updating the same from ‘Workflow Manager’ GUI, it was throwing below error

java.lang.NullPointerException: Host {xxx-xx-xx.com}, Name [null] and/or Port [1521] is null

we looked for a script which could have updated the POP3 server from backend. Below was the script – endorsed by Oracle.

sqlplus apps/pwd
@$FND_TOP/sql/afsvcpup.sql
At first prompt identify from list the component id for WF Mailer and enter its value : 10006
At second prompt identify the parameter id for POP3 and enter its value
At third prompt enter the new value for parameter POP3 : <new_value>
Bounce the workflow notification mailer

This helped to update POP3 server and workflow notification mailer started without any error.

Anand

Oracle Apps

Posted by:

anandmandilwar

Enterprise Solutions Architect with 8x AWS Certified & Project Management Professional (PMP). Passionate about solving customer problems through innovative solutions and improving operational efficiency by automating everything possible.

About Me

I’m a Hands-On Technical & Entrprise Solutions Architect based out of Houston, TX. I have been working on Oracle ERP, Oracle Database and Cloud technologies for over 20 years and still going strong for learning new things.

You can connect me on Linkedin and also reach out to me

I am certified for 8x AWS, OCP (Oracle Certified Professionals), PMP, ITTL and 6 Sigma.

Disclaimer

This is a personal blog. Any views or opinions represented in this blog are personal and belong solely to the blog owner and do not represent those of people, institutions or organizations that the owner may or may not be associated with in professional or personal capacity, unless explicitly stated.
All content provided on this blog is for informational purposes only. The owner of this blog makes no representations as to the accuracy or completeness of any information on this site or found by following any link on this site.

The owner will not be liable for any errors or omissions in this information nor for the availability of this information. The owner will not be liable for any losses, injuries, or damages from the display or use of this information. Any script available on the blog post MUST be tested before they are run against Production environment.

My Journey to the cloud…