XML / BI Puublisher Issues

Location of XML Publisher (rtf,XDO) files on server

 This article is for those who are looking for answer of following Questions.

  • What is the location of rft files on Oracle sever.
  • How to know the change history of XML publisher (BI Publisher) files.
  •  What is XDO_LOBS table and what type of information in  this table.
  • Where oracle stores XML Publisher files.

Oracle doesn’t store XML Publisher (XDO)  (pdf, rtf, xml, xsl…etc)  files in file system though it stores in the XDO.XDO_LOBS table.
Table XDO.XDO_LOBS is used for storing locale (language and territory) sensitive binary and text files. It is mainly used for storing language layout templates.

 To find particular report and its history use following command

select *from XDO.XDO_LOBS where file_name = ‘File_Name’;

File_Data column contain all XML publisher files and you can download these files using TOAD.

 XDO.XDO_LOBS Columns

Name Datatype Length Madatory
LOB_TYPE VARCHAR2 30 Yes
APPLICATION_SHORT_NAME VARCHAR2 50 Yes
LOB_CODE VARCHAR2 80 Yes
LANGUAGE 6 Yes  
TERRITORY VARCHAR2 6 Yes
FILE_NAME VARCHAR2 120 Yes
XDO_FILE_TYPE VARCHAR2 30 Yes
FILE_STATUS VARCHAR2 1 Yes
FILE_CONTENT_TYPE VARCHAR2 120 Yes
FILE_DATA BLOB 4000  
PROGRAM VARCHAR2 30  
PROGRAM_TAG VARCHAR2 50  
CREATED_BY NUMBER 15 Yes
CREATION_DATE DATE    
LAST_UPDATED_BY NUMBER 15 Yes
LAST_UPDATE_DATE DATE   Yes
LAST_UPDATE_LOGIN NUMBER 15 Yes