Organization Name

Rutgers University

Description

XMLTYPE DATA IS NOT PULLED IN BI REPORTS: 

We pull the data in flat file using BI report.  The data is then fed into other systems of the university.
We need ability to pull the XMLTYPE data from the system using BI Reports.   If this cannot be provided, we request that a view with XMLTYPE column converted into appropriate parsed VARCHAR2 values be made available that can be used in BI "

SR 3-15215361791 : XMLTYPE data is not pulled in BI Reports

Enhancement 26577614 has been created

Use Case and Business Need

BI Report is not pulling the data from columns of dataype XMLTYPE.

E.g query - the following query has two columns of type xmltype - condition_filter and validation_filter:

select rule_code, description, condition_filter, validation_filter from FND_KF_CROSS_VAL_RULES fkcvr

BI report is not pulling the data from these two columns

More details

SR 3-15215361791

As noted in our Data Modeling Guide we only support specific column types.
VARCHAR2, CHAR
NUMBER
DATE, TIMESTAMP
Binary Large Object (BLOB)
Character Large Object (CLOB) - this last can store XML formatted data.
http://docs.oracle.com/middleware/12212/bip/BIPDM/GUID-F9F844BA-5831-46E5-B085-44D82258A9A9.htm#GUID-7F1DA8C3-2E42-428A-90A1-B48A917D02BB

An ER was logged for column type XMLTYPE,several years ago, but it was not implemented.:
Bug 9955978 : BI PUBLISHER RETURNS EMPTY NODE FOR COLUMN OF TYPE XMLTYPE 

Original Idea Number: d01279ec6c