Home > Oracle Apps > Oracle Workflow not working and giving java null pointer exception..

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.

  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

Advertisements
Categories: Oracle Apps
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: