Purchase Order Approval Process Fails with ERROR_MESSAGE=3835: ORA-20002: 2018: 3103: Attribute 'DOCUMENT_ID' does not exist (Doc ID 1428156.1)

Last updated on JUNE 10, 2014

Applies to:

Oracle Purchasing - Version 12.1.3 and later
Information in this document applies to any platform.
***Checked for relevance on 10-Jun-2014***

Symptoms

Purchase Orders with Open PO Acknowledgments are stuck In Process status with the following error at time of Purchase Order Approval:

EMAIL_PO_NOTIFICATION
#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 'DOCUMENT_ID' does not exist for item '173271/PO'.

Wf_Engine.GetItemAttrNumber(173271, PO, DOCUMENT_ID)
wf_notification.GetAttrDoc2(4582243, PO_EMAIL_HEADER, text/html)
Wf_Notification.GetAttrDoc(4582243, PO_EMAIL_HEADER, text/html)
Wf_Notification.GetText2(4582243, text/html)
Wf_Notification.GetBody(4582243, text/html)
WF_NOTIFICATION.GetFullBody(nid =' encountered during execution of Generate function 'WF_XML.Generate' for event 'oracle.apps.wf.notification.send'. ERROR_STACK=NT_ID' does not exist for item '173271/PO'.

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