Using Data Template - Blank Output
Hi all,
We are on R12.1.3 and I am starting to develop a report to show invoices coming through the ap invoices interface table.
However, when I run the report, I get a blank output page. Here are the steps etc so far:
I've created a data template file as an initial test:(Attribute5 contains a date and timestamp)
<?xml version="1.0" encoding="UTF-8"?> <dataTemplate name="AP Daily Import Summary" version="1.0" description="AP Daily Import Summary" > <parameters> <parameter name="P_DATE" dataType="date"/> </parameters> <dataQuery> <sqlStatement name="Q1"> <![CDATA[ SELECT COUNT(INVOICE_ID) COUNTI,SUM(INVOICE_AMOUNT) SUM_INV_AMOUNT FROM AP_INVOICES_INTERFACE WHERE SOURCE='EXS01A' AND STATUS='PROCESSED' AND TO_CHAR(:P_DATE,'DD/MM/YYYY')=TO_CHAR(TO_DATE(ATTRIBUTE5,'DD/MM/YYYY HH24:MI:SS'),'DD/MM/YYYY') ]]> </sqlStatement> </dataQuery> <dataStructure> <group name="G_Q1" source="Q1"> <element name="COUNTI" dataType="VARCHAR2" value ="COUNTI"/> <element name="SUM_INV_AMOUNT" dataType="VARCHAR2" value ="SUM_INV_AMOUNT"/> </group> </dataStructure> </dataTemplate>