When Open The Supplier RFQ Workflow Notifications Seeing The Error ORA-20002 (Doc ID 1996381.1)

Last updated on OCTOBER 10, 2022

Applies to:

Symptoms

When attempting to open and RFQ notification, the following error occurs:

ERROR
Error : ORA-20002: 3103: Attribute 'LOGIN_VIEW_DETAILS_URL' does not exist for item 'PONPBLSH/27191-756234-988118'. ORA-06512: at "APPS.WF_NOTIFICATION", line 5774 ORA-06512: at line 6


WORKFLOW ERROR:
NOTIFY_ADD_CONTACT #MAIL WF_ERROR
[WF_ERROR] ERROR_MESSAGE=3835: Error '-20002 - ORA-20002: 2018: Unable to generate the notification XML. Caused by: 2020: Error when getting notification content. Caused by: ORA-20002: 3103: Attribute 'LOGIN_VIEW_DETAILS_URL' does not exist for item 'PONPBLSH/27191-756234-988118'.
  
Wf_Engine.GetItemAttrText(PONPBLSH, 27191-756234-988118, LOGIN_VIEW_DETAILS_URL)
Wf_Notification.GetAttrClob(14329625, PON_INV_RESP_ADD_CONT_BODY, text/html)
Wf_Notification.oldGetAttrClob(14329625, PON_INV_RESP_ADD_CONT_BODY, text/html)
WF_NOTIFICATION.GetFullBody(nid => 143' encountered during execution of Generate function 'WF_XML.Generate' for event 'oracle.apps.wf.notification.send'. ER
ROR_STACK=
WF_MAIL.GetLOBMessage3(14329625, WFMAIL, 2020: Error when getting notification content. Caused by: ORA-20002: 3103: Attribute 'LOGIN_VIEW_DETAILS_URL' does
not exist for item 'PONPBLSH/27191-756234-988118'.
  
...

NOTIFY_BIDDERS #MAIL WF_ERROR
[WF_ERROR] ERROR_MESSAGE=3835: Error '-20002 - ORA-20002: 2018: Unable to generate the notification XML. Caused by: 2020: Error when getting notification co
ntent. Caused by: ORA-20002: 3103: Attribute 'LOGIN_VIEW_DETAILS_URL' does not exist for item 'PONPBLSH/27191-756234-988118'.
  
Wf_Engine.GetItemAttrText(PONPBLSH, 27191-756234-988118, LOGIN_VIEW_DETAILS_URL)
Wf_Notification.GetAttrClob(14329626, PON_INVITE_RESPONSE_BODY, text/html)
Wf_Notification.oldGetAttrClob(14329626, PON_INVITE_RESPONSE_BODY, text/html)
WF_NOTIFICATION.GetFullBody(nid => 1432962' encountered during execution of Generate function 'WF_XML.Generate' for event 'oracle.apps.wf.notification.send'
. ERROR_STACK=
WF_MAIL.GetLOBMessage3(14329626, WFMAIL, 2020: Error when getting notification content. Caused by: ORA-20002: 3103: Attribute 'LOGIN_VIEW_DETAILS_URL' does
not exist for item 'PONPBLSH/27191-756234-988118'.


STEPS TO REPRODUCE
The issue can be reproduced at will with the following steps:
1. Supplier go to Sourcing application
2. Open a notification
3. See the error

Cause

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