Creating BI Publisher Report in Oracle EBS
Prerequisites
To complete this tutorial, you should have:
1. | The E-Business Suite 11.5.10 instance or higher. This tutorial is based on the E-Business Suite R12 instance.
You must have the following responsibilities: |
2. | Java Runtime Environment (JRE) 1.4. and Microsoft .Net 2.0 on your Windows PC. | 3. | Microsoft Word 2000 or Microsoft Word 2003 on your Windows |
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