Oracle Application Technology

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.

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

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

Anand