Oracle Apps - What is the purpose of XML report when compared to reports 6i & discoverer?What are the API's in OM

GeekInterview.com > Interview Questions > Oracle Apps

Go To First | Previous Question | Next Question

Oracle Apps | Question 46 of 61

What is the purpose of XML report when compared to reports 6i & discoverer?
What are the API's in OM module?

Total Answers and Comments: 1

Last Update: March 11, 2008 Asked by: kishore.panuganti

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

March 10, 2008 22:56:44

kesava.chunduri

Member Since: May 2006 Contribution: 3

RE: What is the purpose of XML report when compared to reports 6i & discoverer?What are the API's in OM module?

Hi Kishore

XML/BI Publisher gives the flexibility to users inorder to select the output type in EXCEL/HTML/PDF/FO etc as per their requirement. If a User ran a report in PDF and wants to get the same in EXCEL its not required for them to re-run the report Instead they can republish it using RePublish option in Tools and can select the output type whatever is required.

XML/BI Publisher reports gives you additional features for Reports 6i. You can get the XML Report in EXCEL/HTML/PDF etc as per the output type selected. Data Model in Reports 6i RDF will be the same but you dont require a Layout model in the RDF File. You instead create the Layout in a Word Document using the XML Publisher Destop installed. You can directly implement XML Publisher and is not required to implement Discoverer again.

Before the release of Discoverer 10g Discoverer is a license free version and after its release the license has become too costly due to which the clients are going for XML Publisher reports ignoring Discoverer.

Advantages of XML/BI Publisher:
* Cost for implementing is very less compared to the license of Discoverer.
* Can create complex layouts same as we do it in Report 6i where as complex reporting is not possible in Discoverer.
* Can run the report in 5 different Output Formats and export them.
* If you require the report in 3 different output types You dont need to run the report 5 times. You can run the report once and can republish it again in other types.
* You dont require any different web browser for running the report It can be directly run on the Concurrent Environment itself.
* You can code the report to dynamically select the layouts (templates) in XML Publisher Similar to the functionality of Format Trigger in Reports 6i which is not possible in Discoverer.

Limitations/Disadvantages of XML/BI Publisher:
* Its not recommended for ad-hoc reporting like Discoverer.
* Its very hard to debug a report unlike Discoverer.
* We cant draw Pie Charts/Graphs as like in Discoverer.

I am not very much aware of the API's in OM. Hope some one can help you out with that.

Regards
Kesava Rao Chunduri

Is this answer useful? Yes | No

Querying Data with Oracle XQuery

Querying Data with Oracle XQuery Starting with Oracle Database 10g Release 2 you can take advantage of a full featured native XQuery engine integrated with the database With Oracle XQuery you can accomplish various tasks involved in developing PHP Oracle XML applications operating on any kind of dat

Using Oracle XML DB Repository

Using Oracle XML DB Repository Another variation on accessing and manipulating XML content stored in Oracle database is provided by Oracle XML DB repository which is an essential component of Oracle XML DB mosgoogle NOTE Oracle XML DB repository also known as XML repository is a hierarchically organ

Using Oracle Database for Storing, Modifying, and Retrieving XML Data

Using Oracle Database for Storing Modifying and Retrieving XML Data With Oracle XML DB you have various XML storage and XML processing options allowing you to achieve the required level of performance and scalability One of the most interesting things about Oracle XML DB is that it allows you to per

XML Processing in PHP and Oracle Applications

Processing XML in PHP Oracle Applications As mentioned there are two alternatives when it comes to performing XML processing in your PHP Oracle application You can perform any required XML processing using either PHP s XML extensions or PEAR XML packages or Oracle s XML features mosgoogle In the fol

PHP Oracle Web Development

PHP Oracle Web Development Data processing Security Caching XML Web Services and Ajax The book is written by Yuli Vaseliev a well known author of different web development and programming books PHP Oracle Web Development Data processing Security Caching XML Web Services and Ajax is a good starting b

Getting Started with Oracle and ODP.NET

ODP NET Developer’ s Guide by Jagadish Chatarji Pulakhandam Sunitha Paruchuri A practical guide for developers working with the Oracle Data Provider for NET and the Oracle Developer Tools for Visual Studio 2005 Application development with ODP NET Dealing with XML DB using ODP NET Oracle

PHP Oracle Web Development Review

PHP Oracle Web Development Data processing Security Caching XML Web Services and Ajax The book is written by Yuli Vaseliev a well known author of different web development and programming books The author is also an expert in open source technologies and SOA Service Oriented Architecture But besides

Step by Step Oracle PL-SQL Tutorial

This introductory tutorial to PL SQL will help you to understand the basic concepts of PL SQL Please review the following tutorials and practice the sample SQL Statements on your local Oracle Database Please note that you must learn these basic things before we actually start getting in to Advanced

Working with XML in Oracle

Working with XML in Oracle Introduction to XML Extensive markup language is the language which presents data in a human readable form of text The data can be anything from a purchase order or a stock quote or weather radar or a flight schedule it can be represented using XML XML is very similar to H

What is Oracle Net Service

Oracle Net Services provides enterprise-wide connectivity solutions in distributed, heterogeneous computing environments. Oracle Net Services eases the complexities of network configuration and management, maximizes performance, and improves network diagnostic capabilities. Oracle Net, a component

User Name		Remember Me?
Password

Question Bank