Unexpected Error When Clicking Edit Requisition from the Approval Notification (Doc ID 2893866.1)

Last updated on APRIL 22, 2024

Applies to:

Symptoms

The requisition approval notification is received by the requisition approver. 
Upon choosing the Edit Requisition Link within the notification - an error is encountered.


Error:
java.sql.SQLException: ORA-20002: 3207: User <user_first_name.user_last_name> does not have access to notification . ORA-06512: at "APPS.WF_ADVANCED_WORKLIST", line 184

Error message: 'You have encountered and unexpected error. Please contact the System Administrator for assistance.'

Error Page - Exception Details:
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement:

SELECT DECODE(wf_advanced_worklist.authentication)
FROM
po_requisition_headers_all prh,
wf_notifications wf,
wf_item_activity_statuses wias
WHERE prh.requisition_header_id = :3
AND wias.item_type = prh.wf_item_type
AND wias.item_key = prh.wf_item_key
AND wias.notification_id = wf.group_id

Replication Steps:
1. Open an Approval Notification.
2. Click the Edit requisition and/or "View Requisition Details" hyperlinks.
3. The error is received.

Cause

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