Link is not working between parent and child queries in XML Publisher report
Hi All,
I am using Oracle Applications : 12.2.4 and Oracle BI Publisher Desktop 11.1.1.7
I have BI(XML) publisher data template as below and did not define template for output.
I am trying to generate XML data only.
<dataTemplate name="XX_LINK_EMP_DT" description="Employees Report" version="1.0">
<properties>
<property name="debug_mode" value="on"/>
</properties>
<dataQuery>
<sqlStatement name="Q1">
<![CDATA[
SELECT department_id dept_id,
department_name
FROM dept
WHERE department_name = 'Marketing'
]]>
</sqlStatement>
<sqlStatement name="Q2">
<![CDATA[
SELECT employee_id,
first_name,
job_id,
salary,
department_id
FROM emp
]]>
</sqlStatement>
</dataQuery>
<link name="DEPTEMP_LINK" parentQuery="Q1" parentColumn="DEPT_ID"