in the next time use appropriate forum
BI Publisher - BI Publisher
E-Business Suite - https://forums.oracle.com/forums/category.jspa?categoryID=3
for SQL query 2 , the output shows blank cell.
are you sure what data exists?
based on Q2 looks like what Q1 and Q2 not linked between
-- AND PAPF.PERSON_ID = :PERSON_ID
but they have "P_PAYROLL_ID" so it may be interpreted as related
I wanted to know how we can link the 2 sql query inside XML Data Template.
search by "How to Define a Data Link Between Queries" in http://docs.oracle.com/cd/E10415_01/doc/bi.1013/e12187/T421739T434255.htm
there are two methods for linking queries: using bind variables or using the <link> element to define the link between queries.
First of all,sorry for putting the question on the wrong forum. Second, thanks for making my day :) , as I was able to solve the issue. Before posting the above question, I tried using "AND PAPF.PERSON_ID = :PERSON_ID" but it didn't work. Again I tried the same , and this time added "<element name="PERSON_ID" value="PERSON_ID"/>" under the <Group name ="G_Salary_Details" source="Q1"> . This time it worked without any issues.
Again thanks a lot for support.
Thanks & Regards,