My Oracle Support Banner

E-Business Suite Workflow Mailer Outbound Notifications To A Role Recipient Cause Mailer Crash With Error 'oracle.apps.fnd.cp.gsc.Processor.run java.lang.NullPointerException' (Doc ID 2357700.1)

Last updated on AUGUST 10, 2018

Applies to:

Oracle Workflow - Version 12.1.3 to 12.2.7 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Symptoms

E-Business Suite , Workflow Mailer Outbound Processing issues

The Workflow Mailer goes down frequently, with a status of 'System Deactivated' and the following error in the log:

UNEXPECTED:[SVC-GSM-WFMLRSVC-202672-10006 : oracle.apps.fnd.cp.gsc.Processor.run()]:java.lang.NullPointerException

In other cases users may report a database lock being held by the following select statement:

UPDATE WF_NOTIFICATIONS
SET FROM_USER = :B5 ,
FROM_ROLE = NVL(:B4 ,FROM_ROLE),
TO_USER = :B3 ,
SUBJECT = :B2 ,
LANGUAGE = USERENV('LANG')
WHERE NOTIFICATION_ID = :B1

The issue can be reproduced at will with the following steps:
1. Monitor the Workflow Mailer in Workflow Manager.

The issue has the following business impact:
Due to this issue, users cannot send email notifications.

Changes

Recently upgraded

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.