Total Pageviews

Monday, December 10, 2012


XML PUBLISHER By Avinash And Rahul

XML PUBLISHER

What is XML Publisher?
Oracle XML Publisher is a powerful windows GUI to allow you to incorporate oracle data and xml templates to create uniform reports. XML Publisher is the standard enterprise reporting solution across many of Oracle's application suites. It is also now available as a standalone reporting solution for non applications customers or for those applications customers that wish to use XML Publisher outside of their application suite.


A quick note on the naming of XML Publisher, the product has been renamed to 'Business Intelligence Publisher'. Inside the E Business Suite, PeopleSoft Enterprise and JD Edwards E1 the name remains as 'XML Publisher'. It is the same product as the BI Publisher but under the older name.This is a future reporting tool because in all the extended versions of Oracle EBS(i.e R12 & Fusion) ,this tool is used.
This document provides a clear understanding of quick and easy method to generate
reports and xml templates.The tools to accomplish this are built into report builder 6i
and 10g.

What are the advantages of XML Publisher over RDF reports?

XML Reports are easy to design because in this user design the layout in Microsoft word instead of report builder layout.So if report designer have knowledge about Microsoft word then half of the work finished.They can design layout with the help of
XML Template or BI Publisher .

Secondly,the end-user can view the report output file as they desired.They can view the same output file in different formats(i.e Excel,PDF,RTF etc.) as per there business requirements.So XML Reports Provides the ease to end user to perform n number of operations as per there requirement.(like on excel file they can perform sorting,all calculations,v-lookup,filtering and n number of activities.)

But in rdf reports we don’t have such facility.





Steps for designing XML Reports?

Initial steps are same like rdf reports design -:

Write Query as per Business Requirement or MD50 provided to you.
Then go to report builder data modelSql Query and copy the query
and perform all other operations as per your requirement.
Now we have to design the layout in Microsoft word for this we have 2 methods
In Report Builder.
Filegenerate to fileXML



Save that .xml file on appropriate location and pass the parameters if any.
After few seconds an output .xml file should be generated consisting of XML Codes.



Now switch to Microsoft word and click on Add-Ins tabDataLoad XML data
Browse the saved .xml file.
Now design your layout as per your requirement or the layout given in your MD50 document.After drawing layout you have to insert XML tags in that layout.
For XML tags you have two methods -:
Click on Insert Field
Now click on the desired tag and press insert tab.But dnt forget about the grouping.
2.)If the report is not complex then this approach is fine,but if the report is bulky and takes lot of time in generating Xml codes or hang up while generating xml codes.
Then we have to follow different approach.

Now you dnt have any .xml output file.So as you switch to the Microsoft word
click on the legacy tool (located at the top of window)test from field



Now switch to Report Builderclick F4 on desired fieldcopy the xml tag
After copying this Xml tag from report builder,switch to your Microsoft word and double click on text form filed add text help in window you write <?copy the xml tag here?>And follow this process for each and every desired field required in report layout.
Now design layout and save as reportname.rtf and save this .rtf in same report folder.

6.) Now we have to register the report and follow the same report registration process:
Move the .rdf to the appropriate top on server.
Now ,switch to applicationsystem administratorconcurrentprogramexecutable

Executable= AWC_XXVENDORDETAILS(executable name)
Short Name= AWCVENDET(Short name of executable)
Application =Payables(Appropriate application name)
Description= AWC_XXVENDORDETAILS(Description about report)
Execution Method=Oracle Reports (For Reports its always be oracle reports)
Execution file name = XX_VENDOR_DETAILS(Name of your rdf)

Now go to concurrent-ProgramDefine

Program= AWC_XXVENDORDETAILS(Name of concurrent program)
Short Name = AWC_XXVENDORDETAILS(short name of conc program)
Application =Payables(appropriate application name)
Executable Name = AWCVENDET(executable name)
Method=Oracle Reports
Output Format =XML(if you designing xml reports thn its mandatory )
Style =BACS(As per your requirement)

Then click on parameter button and define all your parameter .


Now switch to user responsibilityF11paste application name in application fieldctrl+F11copy the request group name
Then Switch to userRequestF11paste group name and write application namectrl+F11

Now Switch to responsibility XML Publisher Administration Data Definition
Create data definitionApply

Name= AWC_XXVENDORDETAILS_DD(Name of data definition)
Code= AWCVENDET(Short name of concurrent program)
Application = Payables(Application Name)
Start Date= 08-Jun-2010

Now Switch to Template Create Template

1. Name= AWC_XXVENDORDETAIL_TT(Name of template)
2. Code= AWCVENDET(Short name of conc program)
3. Application= Payables(Application Name)
4. Data definition= AWC_XXVENDORDETAILS_DD(Data definition name)
5. Type=RTF
6. Start Date = 08-Jun-2010
7. File= C:\Documents and Settings\gffdg\Desktop\Vendor
Detail\XX_VENDOR_DETAILS.rtf(Path of your .rtf template)
8 .Language= English
9. Territory= India(As per your setup)

Now click on apply.





Now Switch to the appropriate responsibility Run the report to view output.

No comments:

Post a Comment