XML Report Preview : Java.Sql.Sqlexception: No Corresponding Lob Data Found (Doc ID 418374.1)

Last updated on OCTOBER 04, 2016

Applies to:

BI Publisher (formerly XML Publisher) - Version 5.6.2 to 5.6.3 [Release 5]
Information in this document applies to any platform.
FNDRSRUN.fmb version 11.5.154
Checked for relevance on 10-MAR-2013


Symptoms

One gets the following error when clicking on the Preview button of the FNDRSRUN forms for a XML
Publisher custom report:

java.sql.SQLException: No corresponding LOB data found : SELECT FILE_DATA,
DBMS_LOB.GETLENGTH(FILE_DATA), FILE_NAME, LAST_UPDATE_DATE FROM XDO_LOBS WHERE
LOB_TYPE = :1 AND APPLICATION_SHORT_NAME = :2 AND LOB_CODE = :3 AND LANGUAGE =
:4 AND TERRITORY ...........

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