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

Last updated on AUGUST 25, 2017

Applies to:

Oracle Sourcing - Version 12.1.3 and later
Information in this document applies to any platform.

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms