BI Publisher (MOSC)

MOSC Banner

Link is not working between parent and child queries in XML Publisher report

edited Nov 29, 2019 4:01AM in BI Publisher (MOSC) 4 commentsAnswered

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"

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center