12.2 E-Business Suite Workflow Mailer Outbound Notifications To A Role Recipient Cause SVC-GSM-WFMLRSVC Crash Or Database Lock With Error 'oracle.apps.fnd.cp.gsc.Processor.run java.lang.NullPointerException'
Last updated on MAY 17, 2018
Applies to:Oracle Workflow - Version 12.2.4 to 12.2.7 [Release 12.2]
Information in this document applies to any platform.
E-Business Suite 12.2 Workflow, 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.
12.2 upgrade was recently completed.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms