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:

Symptoms

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

ERROR
-----------------------
You have encountered an unexpected error. Please contact your System Administrator for assistance.

Exception Details.

oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException:
JBO-27122: SQL error during statement preparation. Statement: SELECT
NtfAttribsEO.TEXT_VALUE, NtfAttribsEO.NOTIFICATION_ID,
NtfAttribsEO.NAME,
MsgAttribsEO.TYPE, MsgAttribsEO.MESSAGE_TYPE,
MsgAttribsEO.MESSAGE_NAME, MsgAttribsEO.NAME AS NAME1,
MsgAttribsEO.DISPLAY_NAME,
MsgAttribsEO.FORMAT, NtfAttribsEO.NUMBER_VALUE,
NtfAttribsEO.DATE_VALUE, MsgAttribsEO.SUBTYPE,
MsgAttribsEO.RENDER, MsgAttribsEO.SEQUENCE
FROM WF_NOTIFICATIONS NtfEO, WF_NOTIFICATION_ATTRIBUTES NtfAttribsEO,
WF_MESSAGE_ATTRIBUTES_VL MsgAttribsEO
WHERE NtfEO.NOTIFICATION_ID = :1 AND NtfEO.NOTIFICATION_ID =
NtfAttribsEO.NOTIFICATION_ID AND NtfEO.MESSAGE_TYPE =
MsgAttribsEO.MESSAGE_TYPE
AND NtfEO.MESSAGE_NAME = MsgAttribsEO.MESSAGE_NAME AND MsgAttribsEO.NAME =
NtfAttribsEO.NAME ORDER BY length(MsgAttribsEO.NAME) desc
at
oracle.jbo.server.BaseSQLBuilderImpl.processException(BaseSQLBuilderImpl.java:3383)

at
oracle.jbo.server.OracleSQLBuilderImpl.processException(OracleSQLBuilderImpl.java:4022)

STEPS
-----------------------
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

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot approve the document.

Cause

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