Prerequisites

To complete this tutorial, you should have:

Scenario:

Let’s say if you want to create simple report which display Employee information based on parameter provided by user.

Creating XML schema.

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27

<?xml version="1.0"?>
<dataTemplate description="EMPLOYEEDETAILS" name="EMPLOYEEDATA">
<parameters>
<parameter name="EMP_NAME" dataType="number"/>
</parameters>
<dataQuery>
<sqlStatement name="TMP"> 
select papf.full_name FULL_NAME, papf.employee_number,papf1.full_name supervisor_name
from per_all_people_F papf
, per_all_assignments_F paaf
, per_all_people_f papf1
where papf.person_id = paaf.person_id
and trunc(sysdate) between papf.effective_start_date and papf.effective_end_Date
and trunc(sysdate) between paaf.effective_start_date and paaf.effective_end_date
and paaf.supervisor_id = papf1.person_id
and trunc(sysdate) between papf1.effective_start_date and papf1.effective_end_Date
and (papf.employee_number=:EMP_NAME or :EMP_NAME is null ) 
</sqlStatement>
</dataQuery>
<dataStructure>
<group name="G_EMPLOYEE" source="TMP">
<element name="FULL_NAME" value="FULL_NAME"/>
<element name="EMPLOYEE_NUMBER" value="EMPLOYEE_NUMBER"/>
<element name="SUPERVISOR_NAME" value="SUPERVISOR_NAME"/>
</group>
</dataStructure>
</dataTemplate>

Step 1: Login to EBS instance

Step 2 Navigate to Application Developer- Application-Validate

Step 3:

Step 4: Click on program

Step 5: Define concurrent program

Step 6: Define parameter

Step 7: Navigate to XML publisher Administrator

Step 8: Click on Create data definition

Step 9: define name and Code for it and Select Application

Step 10: Upload txt file in which you have created.(XML schema)

Step 11:navigate to Template and Click on Create template

Step 12 : Define name and code, Code should be same as your data definition and Select application and data definition.

Step 13: Define Responsibility or use Existing responsibility

Step 14: I am using System Administrator Responsibilty and Copy the Request group name

Step 15: Select Report name and your Application name

Step 16: Click on submit

Step 17: To run Report go to view and Click on request

Step 18: Click on submit a new request

Step 19: Select single request

Step 20: enter Report name and pass Parameter and Click on submit

Step 21:

Step 22: To see the output Click on View output

Step 23: Output

In this lesson, you learned how to:

	Install Oracle XML Publisher Desktop / BI Publisher Desktop
	Set an Oracle Reports Report Output to XML
	Use Concurrent Manager to Create a Sample XML File
	Create an RTF Template
	Create a Data Definition for the Report
	Use the Template Manager to Upload the Template
	Run the Report with the Template

Reference:

http://www.oracle.com/webfolder/technetwork/tutorials/obe/fmw/bi/xmlp_ebiz/index.html

Print PDF