Any help appreciated to resolve this error. This happened after we upgraded to Oracle EBS 12.2.13 version.
[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 '-6502 - ORA-06502: PL/SQL: numeric or value error: invalid LOB locator specified: ORA-22275
ORA-06512: at "APPS.WF_NOTIFICATION", line 5481
ORA-06512: at "SYS.DBMS_LOB", line 1149
ORA-06512: at "APPS.WF_NOTIFICATION", line 5476
ORA-06512: at "APPS.PO_WF_REQ_NOTIFICATION", line 1904
ORA-06512: at "APPS.PO_WF_REQ_NOTIFICATION", line 645
ORA-06512: at line 1
' i' encountered during execution of Generate function 'WF_XML.Generate' for event 'oracle.apps.wf.notification.send'. ERROR_STACK=
WF_MAIL.GetLOBMessage4(3321367, WFMAIL, 2020: Error when getting notification content. Caused by: ORA-20002: 3240: Error '-6502 - ORA-06502: PL/SQL: numeric or value error: invalid LOB locator specified: ORA-22275
ORA-06512: at "APPS.WF_NOTIFICATION", line 5481
ORA-06512: at "SYS.DBMS_LOB", line 1149
ORA-06512: at "APPS.WF_NOTIFICATION", line 5476
ORA-06512: at "APPS.PO_WF_REQ_NOTIFICATION", line 1904
ORA-06512: at "APPS.PO_WF_REQ_NOTIFICATION", line 645
ORA-06512: at line 1
' in 'PLSQLCLOB' API 'PO_WF_REQ_NOTIFICATION.GET_PO_REQ_APPROVED_MSG'
Wf_Notification.GetAttrInfo(3321367,
HDR_1)
WF_NOTIFICATION.WriteToClob()
Wf_Notification.GetAttrClob(3321367, PO_REQ_APPROVED_MSG, text/html)
Wf_Notification.oldGetAttrClob(3321367, PO_REQ_APPROVED_MSG, text/html)
WF_NOTIFICATION.GetFullBody(nid => 3321367, disptype => text/html)
WF_MAIL.GetLOBMessage4(nid => 3321367, r_ntf_pref => MAILHTML), Step -> Getting text/html body)
WF_XML.GenerateDoc(oracle.apps.wf.notification.send, 3321367)
WF_XML.Generate(oracle.apps.wf.notification.send, 3321367)
WF_XML.Generate(oracle.apps.wf.notification.send, 3321367)
Wf_Event.setMessage(oracle.apps.wf.notification.send, 3321367, WF_XML.Generate)
Wf_Event.dispatch_internal()