XML Publisher in Oracle Apps
- Drawbacks of Oracle Reports Layout design is Complicated.
- Normal text Output.
- The user cannot change output format (PDF, Excel, HTML, .rtf) at run time.
Difference Between Rdf report and XML Publisher?
Oracle Report (.rdf) XML Publisher(11i) BI Publisher (R12)
1. Develop .rdf file as per client 1. Develop .rdf report as per clientRequirement Requirement
a. Build Data modal(SQL Query) a. Build Data modal(SQL Query)
b. Deign Layout Model
2. Transfer .rdf file from local machine 2. Transfer .rdf file from local machine
to server. to server.
3. Define Executable. 3. Define executable.
4. Define Concurrent Program. 4. Define Concurrent Program.
5. Attach Concurrent Program to 5. Attach Concurrent Program to
the Request Group. the Request Group.
6. Run Concurrent Program through 6. Run Concurrent Program through
SRS Window. SRS Window.
7. Download XML output to Local Machine.
8. Open Msword document and load
XML output and design layout and
save as ".rtf".
9. Register data definition using the
responsibility "XML publisher
Administrator"(code=CP Shortname).
10. Register Template and upload .rtf
file using the responsibility
"XML publisher Administrator".
Step1: Develop .rdf report
Open Report Builder --> Cancel
Create user parameter:
Navigation: Data modal -> user parameter
click on create button -->
go to Property pallet rename to P_CONC_REQUEST_ID
go to report triggers F11 of Before report
SRW.USER_EXIT('FND SRWINIT');
click on compile button -> close inner window.
go to report trigger F11 of After report
SRW.USER_EXIT('FND SRWEXIT');
click on compile button -> close inner window.
go to Data modal
click on SQL place on Report editor.
select * from emp ->ok
give me user credentials
user name: apps
password: apps
host name: vis
save as "AVI_EMP_XML_REPORT.rdf".
Step2:
Transfer file from local machine to server.
Path: .../PO/11.5.0/reports/US
Step3:
Define Executable --> Executable Method (Oracle Reports).
Step4: define Concurrent program
output:
format : XML
Style: A4
Step5: Attach Concurrent program to the Request Group.
Step6: click on Switch Responsibility button select Required Responsibility.
Step7: Run Concurrent program through SRS window.
click on view output button
file -> save as "AVI_EMP_XML_REP.xml"
save.
Step8: Open msword document
go to data --> load xml data --> select xml file --> click on open button --> ok.
Step9: Design layout insert all fields -> click on preview --> click pdf --> ok
then save as "AVI_EMP_XML_TEMPLATE.rtf"
Step10: Register data definition
Navigation: XML Publisher Administrator --> Home --> Data Definitions.
click on create data definition button --> Name: AVI_XML_DD
code: C.P short Name in upper case.
--> click on apply
--> copy name
select * from XDO_DS_DEFINITIONS_TL
where DATA_SOURCE_NAME='AVI_XML_DD'
Step11: define template and upload (.rdf) file.
Navigation: XML Publisher Administrator --> Home --> Templates
--> click on create template button.
Name: AVI_XML_TEMPLATE
Code: AVI_EMP_XML_REPORT
Application: purchasing --> Data Definition: Data definition name
select type as .rtf
default output type pdf.
click on browse button select .rtf file --> click on open
--> select language as English
territory: United States
--> click on apply button --> copy name
select * from XDO_TEMPLATE_TL
where ='AVI_XML_TEMPLATE'
go to switched to required responsibility --> Run Concurrent Program.
No comments:
Post a Comment