PO Approval Notification Results In Error: ORA-20002: 3103: Attribute 'DRAFT_TYPE' Does Not Exist For Item 'POAPPRV'
(Doc ID 3000869.1)
Last updated on FEBRUARY 05, 2024
Applies to:
Oracle Purchasing - Version 12.2.11 and laterInformation in this document applies to any platform.
Symptoms
In Oracle Purchasing, modifying a Purchase Order (PO) and submitting for approval fails with the following error in the approval notification:
Failed Activity
PO Rejected
Error Message
[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: 3240: Error '-20002 - ORA-20002: 3103: Attribute 'DRAFT_TYPE'
does not exist for item 'POAPPRV/13513744-688429'. ORA-06512: at "APPS.WF_CORE",
line 318 ORA-06512: at "APPS.WF_CORE", line 315 ORA-06512: at "APPS.WF_ENGINE",
line 1656 ORA-06512: at "APPS.PO_WF_PO_NOTIFICATION", line 1440 ORA-06512: at line
1 ' in 'PLSQL' API 'PO_WF_PO_NOTIFICATION.GET_ACTION_HISTORY' Wf_En'
encountered during execution of Generate function 'WF_XML.Generate' for event
'oracle.apps.wf.notification.send'. ERROR_STACK= WF_MAIL.GetLOBMessage4(75751558,
WFMPROD, 2020: Error when getting notification content. Caused by: ORA-20002: 3240:
Error '-20002 - ORA-20002: 3103: Attribute 'DRAFT_TYPE' does not exist for item
'POAPPRV/13513744-688429'. ORA-06512: at "APPS.WF_CORE", line 318 ORA-06512: at
"APPS.WF_CORE", line 315 ORA-06512: at "APPS.WF_ENGINE", line 1656 ORA-06512: at
"APPS.PO_WF_PO_NOTIFICATION", line 1440 ORA-06512: at line 1 ' in 'PLSQL' API
'PO_WF_PO_NOTIFICATION.GET_ACTION_HISTORY'
PO Rejected
Error Message
[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: 3240: Error '-20002 - ORA-20002: 3103: Attribute 'DRAFT_TYPE'
does not exist for item 'POAPPRV/13513744-688429'. ORA-06512: at "APPS.WF_CORE",
line 318 ORA-06512: at "APPS.WF_CORE", line 315 ORA-06512: at "APPS.WF_ENGINE",
line 1656 ORA-06512: at "APPS.PO_WF_PO_NOTIFICATION", line 1440 ORA-06512: at line
1 ' in 'PLSQL' API 'PO_WF_PO_NOTIFICATION.GET_ACTION_HISTORY' Wf_En'
encountered during execution of Generate function 'WF_XML.Generate' for event
'oracle.apps.wf.notification.send'. ERROR_STACK= WF_MAIL.GetLOBMessage4(75751558,
WFMPROD, 2020: Error when getting notification content. Caused by: ORA-20002: 3240:
Error '-20002 - ORA-20002: 3103: Attribute 'DRAFT_TYPE' does not exist for item
'POAPPRV/13513744-688429'. ORA-06512: at "APPS.WF_CORE", line 318 ORA-06512: at
"APPS.WF_CORE", line 315 ORA-06512: at "APPS.WF_ENGINE", line 1656 ORA-06512: at
"APPS.PO_WF_PO_NOTIFICATION", line 1440 ORA-06512: at line 1 ' in 'PLSQL' API
'PO_WF_PO_NOTIFICATION.GET_ACTION_HISTORY'
The issue can be reproduced with the following steps:
1. Navigate to Oracle Purchasing responsibility
2. Create PO, approve and reserve.
3. Modify the PO and submit for approval.
4. Error is received in the workflow.
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 |
| Cause |
| Solution |
| References |