Oracle Application's Blog: xml reports in oracle apps without rdf

xml reports in oracle apps without rdf

Hi Friends, We are going to discuss about the xml reports in oracle apps without rdf. We will discuss the type of xml report which is not related to rdf. In Oracle apps xml reports , We have the report builder tool to develop the reports those reports we do call rdf. We can also develop the reports without the rdf. We don't need to use the rdf to develop the xml reports else xml reports itself given the option using this we can develop the reports without rdf. In XML reports we have the feature called data template using this we can develop the report in oracle apps. Using Data template , we don't need to have other report builder tool. We can develop the complete report using the xml publisher reports data template. We will discuss the data template in more detail in this further post. We will share the detail steps to create the xml reports using this data template and without using the rdf. Please find below the more detail about xml reports in oracle apps without rdf.

Steps to Create xml reports in oracle apps without rdf

Step 1:-

Here below , we will describe you in more detail about how to develop the xml publisher report using data template in oracle apps.

Step 1:- Here below is the sample of Data Template we have created for XML publisher report.
This report we have created for Supplier Invoice Extraction.

<Parameters>
This Tag helps to define the Parameter for XML reports. We define the xml report parameters under this tag.

<DataQuery>
This tag helps to define the sql query to extract the data from Oracle Apps data base. We do write the sql query here for XML report.

< Group Name>

This Tag helps to define the XML reports data group. Under the group we define the Column/Attributes of the SQL Query. We can decide which data columns of sql query we want to put in which group.

<Element Name> This Tag helps to define the sql query data columns. We need to define those columns which we want to shows in the report. Elena we do define under the Group Tag.

xml reports in oracle apps without rdf

Step 2:- Here below is the sample code we have written for data template file. We need to save this code in as an xml file in .xml extension.

<?xml version="1.0" encoding="UTF-8" ?>
<dataTemplate name="SupInvData" description="Supplier Invoice Details"
Version="1.0" >
<properties>
<property name="debug_mode" value="on"/>
</properties>
<parameters>
<parameter name="P_VENDOR_ID" dataType="character" />
</parameters>
<dataQuery>
<sqlStatement name="Q1">
<![CDATA[
select A2.VENDOR_NAME,A1.INVOICE_NUM,A1.INVOICE_DATE,A1.INVOICE_AMOUNT from ap_invoices_all a1,po_vendors a2
where a1.vendor_id=a2.vendor_id
and a2.vendor_id=:P_VENDOR_ID
]]>
</sqlStatement>
</dataQuery>
<dataStructure>
<group name="G_SUPP" source="Q1">
<element name="VENDOR_NAME" value="VENDOR_NAME" />
<element name="VENDOR_INV_AMT" value="G_INV.INVOICE_AMOUNT"
function="SUM()" />
<group name="G_INV" source="Q1">
<element name="INVOICE_NUM" value="INVOICE_NUM" />
<element name="INVOICE_DATE" value="INVOICE_DATE" />
<element name="INVOICE_AMOUNT" value="INVOICE_AMOUNT" />
</group>
</group>
</dataStructure>
</dataTemplate>

xml reports in oracle apps without rdf

Step 3:- Once we have save this above in xml file , then we can start the XML Publisher report creation part in oracle apps as below.

Step 4:- We first need to go to the Oracle Application to register this report as an xml publisher report in oracle apps r12.

xml reports in oracle apps without rdf

Step 5:- Here below we are creating the "XX SUPPLIER INVOICE DETAIL' report.
Navigation :Concurrent ==> Concurrent Program.

Important Note : In Executable , We need to define 'XDODTEXE' .

Output Type : XML
Click on the Parameters button to create report parameter.

xml reports in oracle apps without rdf

Step 6:-
As below , Copying the Report parameter for Concurrent Program from Data Template.

xml reports in oracle apps without rdf

Step 7:- As below , P_VENDOR_ID column got created.

xml reports in oracle apps without rdf

Step 8:-

Now we need to goto the XML Publisher Administrator responsibility.

Home ==> Data Definitions

xml reports in oracle apps without rdf

Step 9:-

Here below , We need to create the report Data Definition.

Note : We need to use the Short Name of Concurrent Program in Step 5 in Data Definition code field as below.

Click Apply.

xml reports in oracle apps without rdf

Step 10:- Here below , We need to upload the Data template file created in Step 2 & 3.In Data Template as highlighted below and Click on add file.

xml reports in oracle apps without rdf

Step 11:-

As of now , we are not creating the XML report layout , We will first generate the xml output from report to create the template/layout for the xml publisher report.

Step 12:-

Here below , we are running the Concurrent Program . Once the request will be complete then we need to click on the 'View Output' button.

As we have not attached any Layout/Template , Then output will be xml based.

We need to save the xml output as an .xml file.

xml reports in oracle apps without rdf

Step 13:- This is the XML output from the report in step 12.

xml reports in oracle apps without rdf

Step 14:-
Now we need to design the layout for the report. Go to Add-ins in the Word Doc.

xml reports in oracle apps without rdf

Step 15:- In Add-ins ==> Go to Load XML Data

xml reports in oracle apps without rdf

Step 16:- Then , If we want to auto generate the layout based on all the report columns.

Click on Insert ==> All Fields

xml reports in oracle apps without rdf

Step 17:- As below , Report layout has been designed.

xml reports in oracle apps without rdf

Step 18:-

After saving the xml output file, We need to create the report Templates as below.
We need to attach the report Data Definition created in Step 9 in Report Templates.