title: BI Publisher Interactive Template no data found
body: <p>Version 11g Release 1 (11.1.1.7)</p>
  
  <p>I have created the data sources in BIP with seperate single data set using a simple select * SQL for each data source.
  The view sample data works fine.
  The issue comes when trying to create a report template using BIP interactive format (xpt).</p>
  
  <p>I create the data table and when I drag the column from left pane in to data table, a No Data Found error is all I get.</p>
  
  <p>It is random since it works fine for other data sources with select * from same database and since the view sample data works in the data source the the chance the SQL is causing this error is nil.</p>
  
  <p>I have recreated these data sources and error still occurs.</p>
  
  <p>Think this is a bug with BIP?</p>
  
  <p>edit: including SQL and generated xml for a data source, I can't share any names though.
  SQL:</p>
  
  <p><code>SELECT
  *
  FROM
  view;</code></p>
  
  <p>XML:</p>
  
  <pre><code>&lt;output rootName="DATA_DS" uniqueRowName="false"&gt;
  &lt;nodeList name="data-structure"&gt;
  &lt;dataStructure tagName="DATA_DS"&gt;
  &lt;group name="G_1" label="G_1" source="zzz"&gt;
  &lt;element name="xxx" value="xxx" label="xxx" dataType="xsd:string" breakOrder=""        
  fieldOrder="1"/&gt;
  &lt;element name="mmm" value="mmm" label="mmm" dataType="xsd:string"   
  breakOrder="" fieldOrder="2"/&gt;
  &lt;element name="yyy" value="yyy" label="yyy" dataType="xsd:string" breakOrder=""    
  fieldOrder="3"/&gt;
  &lt;element name="aaa" value="aaa" label="aaa" dataType="xsd:string" breakOrder=""  
  fieldOrder="4"/&gt;
  &lt;element name="bbb" value="bbb" label="bbb" dataType="xsd:string" breakOrder=""   
  fieldOrder="5"/&gt;
  &lt;element name="ccc" value="ccc" label="ccc" dataType="xsd:long" breakOrder="" 
  fieldOrder="6"/&gt;
  &lt;element name="ddd" value="ddd" label="ddd" dataType="xsd:double" breakOrder="" 
  fieldOrder="7"/&gt;
  &lt;element name="eee" value="eee" label="eee" dataType="xsd:string" breakOrder="" 
  fieldOrder="8"/&gt;
  &lt;element name="fff" value="fff" label="fff" dataType="xsd:long" breakOrder="" 
  fieldOrder="9"/&gt;
  &lt;element name="ggg" value="ggg" label="ggg" dataType="xsd:long" breakOrder="" 
  fieldOrder="10"/&gt;
  &lt;element name="ggg" value="ggg" label="ggg" dataType="xsd:string" breakOrder="" 
  fieldOrder="11"/&gt;
  &lt;element name="hhh" value="hhh" label="hhh" dataType="xsd:long" breakOrder="" 
  fieldOrder="12"/&gt;
  &lt;element name="iii" value="iii" label="iii" dataType="xsd:string" breakOrder="" 
  fieldOrder="13"/&gt;
  &lt;element name="jjj" value="jjj" label="jjj" dataType="xsd:string" breakOrder="" 
  fieldOrder="14"/&gt;
  &lt;/group&gt;
  &lt;/dataStructure&gt;
  &lt;/nodeList&gt;
  &lt;/output&gt;
  </code></pre>
  
  <p>error message when dragging a data column into data table:
  xxx
  "No data found: /DATA_DS/G_1/xxx"</p>