Acknowledge or Approve notification with WF: GUEST Access enabled option causes error "JBO-27122: SQL error" or "You have encountered an unexpected error"
(Doc ID 2889188.1)
Last updated on AUGUST 20, 2023
Applies to:
Oracle Workflow - Version 12.2.9 to 12.2.9 [Release 12.2]Information in this document applies to any platform.
Symptoms
Scenario1
Guest Response to Workflow Notification approval via email for PO/Iexpense throws error
"You have encountered an unexpected error"
Steps to reproduce
1.Guest access to notification is enabled.
2.When user clicks on 'Click Here to Respond', the notification screen opens.
3.User clicks on 'Approve' and the following error occurs:
At this time, notification (and PO) is approved but the error is confusing.
If system profile 'FND: Diagnostics' is set at site level (or user level),the error doesn't show up.
Basically the error is misleading which disappears if system profile 'FND;Diagnostics' is set
Scenario 2
With WF: GUEST Access to Notification profile option enabled,When users click on "click here to respond" link ,users try to acknowledge and they get the below exception.
Error Page
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
Changes
Upgrade from 12.1.3 to 12.2
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 |