BI Publisher (MOSC)

MOSC Banner

Using Data Template - Blank Output

edited Sep 8, 2014 7:22AM in BI Publisher (MOSC) 6 commentsAnswered ✓

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>

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