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 SEPTEMBER 30, 2021
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.
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:
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.
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