Scribd
Upload
8 views15 pages

Oracle BI Publisher XML Output Guide

The document provides instructions for generating an XML file from a PL/SQL concurrent program in Oracle Apps, loading that XML data into a Microsoft Word document to create a table, and then configuring Oracle XML Publisher to use the Word file as a template to generate reports from the same XML data. Key steps include running the concurrent program to save XML output, loading that into Word to make a table, and defining the data template in XML Publisher using the Word file.

Uploaded by

abdullahroman
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
8 views15 pages

Oracle BI Publisher XML Output Guide

The document provides instructions for generating an XML file from a PL/SQL concurrent program in Oracle Apps, loading that XML data into a Microsoft Word document to create a table, and then configuring Oracle XML Publisher to use the Word file as a template to generate reports from the same XML data. Key steps include running the concurrent program to save XML output, loading that into Word to make a table, and defining the data template in XML Publisher using the Word file.

Uploaded by

abdullahroman
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

Assuming we have installed oracle BI publisher desktop

Now run the oracle _apps_Creating plsql base concurrent program_for xml output and Save the xml output to file i.e.

Open a new Microsoft word document

Click on add-Ins

Now load XML Data browse the saved xml file

This message appear

Now insert Table Wizard

Select form click next

Select data set click next

Select fildes and click next

If needed define sort and click next

Rename the label if required and click next

Resize the table if needed

Now insert data for employee also

Saved RTF file


for-each c_dept Department No. deptno Department Name dname Location loc Following Employees are work under this department. Employee No Employee Name F empno ename end c_dept

Job job

Manager mgr

Hire date hiredate

Salary sal

Commission comm E

group c_emp by mgr

mgr
E m p n o F e m p n o E n a m e e n a m e J o b H ir e d at e hi r e d at e S a l C o m m

j o b

s a l

c o m m E

end c_emp by mgr

Log on to APPS

Select Data Definition under XML Publisher Administrator

Select create data definition

Name: DEPT_EMP_REP_TEXT_XML *Code: DEPT_EMP_REP_TEXT *Application: XXERP Custom Application * note: application must be same as the concurrent program application and code must be same as the concurrent program short name

now add data template

Now Select templates

Click on create template

Name: DEPT_EMP_REP_TEXT_XML2 Code: DEPT_EMP_REP_TEXT_XML2 Application: XXERP Custom Application Data Definition:DEPT_EMP_REP_TEXT_XML2 Type: RTF

File: browse the file Language: English

If layout has no value system administration concurrent program update may need.

You might also like