Notificatiion Mailer Fails To Send Email With Lob Attachment With Problem parsing XML-> org.xml.sax.SAXException: Problem obtaining the MESSAGE (Doc ID 2090359.1)

Last updated on FEBRUARY 29, 2016

Applies to:

Oracle Workflow - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

Symptoms

The AP approval workflow was modified to send a customized approval notification that shows a document attachment as an attachment link in the notification.
This notification works fine when it is opened from the online worklist in Oracle EBS, but when this notification is sent by email, this feature does not work as expected.

The following error is observed in the mailer log file located at $APPLCSF/$APPLLOG/FNDCPG*.txt:

SYSADMIN(0):-1:Thread[outboundThreadGroup1,5,outboundThreadGroup]:192.168.1.13:59333:1449783837168:15:ERROR:[SVC-GSM-WFMLRSVC-49617-10006 : oracle.apps.fnd.wf.mailer.SMTPMessageHandler.prepareMessages(String)]:FormatterException -> oracle.apps.fnd.wf.mailer.FormatterException: Problem parsing XML-> org.xml.sax.SAXException: Problem obtaining the MESSAGE content -> java.sql.SQLException: ORA-22275: invalid LOB locator specified
ORA-06512: at "SYS.DBMS_LOB", line 640
ORA-06512: at line 2
...
...
Caused by: org.xml.sax.SAXException: Problem obtaining the MESSAGE content -> java.sql.SQLException: ORA-22275: invalid LOB locator specified
ORA-06512: at "SYS.DBMS_LOB", line 640
ORA-06512: at line 2

 

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