BI Publisher (MOSC)

MOSC Banner

XML Report using Data template

edited June 2013 in BI Publisher (MOSC) 7 commentsAnswered
I want create XML report using Data Template. I am using BI Publisher Desktop 10.1.3.2 contains the XML Publisher 5.6.3 core libraries and is intended to develop templates for XML Publisher 5.6.3. And EBS is Oracle Application 12.0.6.

 

 

I am using following code as a .xml file.

 

<?xml version="1.0" encoding="WINDOWS-1252" ?>
<dataTemplate name="
CSTPD " description="Products Demo " version="1.0">
<parameters>

</parameters>
<dataQuery>
<sqlStatement name="Q_Invoice">
<![CDATA[
              select ai.Invoice_id invoice_id
             ,ai.Invoice_amount invoice_amount
             ,ai.vendor_id vendor_id
             ,ai.amount_paid amount_paid
          ,ai.invoice_date invoice_date
          ,ail.line_number line_number
          ,aid.distribution_line_number distribution_line_number

Howdy, Stranger!

Log In

To view full details, sign in.

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