Approving through Email Link 'Please Click Here to Respond' Throws Error When 'WF: GUEST ACCESS TO NOTIFICATION' Is Enabled
(Doc ID 2888659.1)
Last updated on AUGUST 10, 2022
Applies to:Oracle Workflow - Version 12.2.8 and later
Information in this document applies to any platform.
Issue happens in both worklists notifications/email notifications With "WF: GUEST Access to Notification" profile option enabled, When users
click on "click here to respond" link ,it takes to acknowledge when users trying to acknowledge they get below exception
You have encountered an unexpected error. Please contact your System Administrator for assistance.
JBO-27122: SQL error during statement preparation. Statement: SELECT
MsgAttribsEO.MESSAGE_NAME, MsgAttribsEO.NAME AS NAME1,
FROM WF_NOTIFICATIONS NtfEO, WF_NOTIFICATION_ATTRIBUTES NtfAttribsEO,
WHERE NtfEO.NOTIFICATION_ID = :1 AND NtfEO.NOTIFICATION_ID =
NtfAttribsEO.NOTIFICATION_ID AND NtfEO.MESSAGE_TYPE =
AND NtfEO.MESSAGE_NAME = MsgAttribsEO.MESSAGE_NAME AND MsgAttribsEO.NAME =
NtfAttribsEO.NAME ORDER BY length(MsgAttribsEO.NAME) desc
The issue can be reproduced at will with the following steps:
Steps to reproduce the problem
-->Log into Oracle applications as sysadmin
-->Set WF: GUEST Access to Notification : Enabled
-->Click on Click here to respond link in email/worklist notification
-->It takes to acknowledge page ,once clicked it throws error
The issue has the following business impact:
Due to this issue, users cannot approve the document.
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