Top 100+ Oracle Bi Publisher Interview Questions And Answers
Question 1. What Is Bi Publisher?
Answer :
It is a reporting device for generating the reports. More than device it's miles an engine that can be included with structures helping the business.
Question 2. Is Bi Publisher Integrated With Oracle Apps?
Answer :
Yes, it is tightly integrated with Oracle Apps for reporting needs. In eleven.Five.10 times xml writer turned into used, in R12 we are able to it BI Publisher.
Oracle 10g Interview Questions
Question three. What Is The Difference Between Xml Publisher And Bi Publisher?
Answer :
Name is the distinction, initially it turned into launched on the call of xml publisher( the preliminary patchset), later on they've added greater features and known as it Business Intelligence Publisher. In BI by way of default we've got integration with Datadefinitions in R12 instance. Both these names can be used interchangeably.
Question 4. What Are The Various Components Required For Developing A Bi Publisher Report?
Answer :
Data Template, Layout template and the combination with Concurrent Manager.
Oracle 10g Tutorial
Question 5. How Does The Concurrent Program Submitted By The User Knows About The Data Template Or Layout Template It Should Be Using For Generating The Output?
Answer :
The concurrent program ‘shortname’ will be mapped to the ‘code’ of the Datatemplate. Layout template is attached to the datatemplate, this paperwork the mapping between all of the 3.
Oracle 9i Interview Questions
Question 6. What Is A Data Template?
Answer :
Datatemplate is an xml shape which contains the queries to be run against the database in order that favored output in xml format is generated, this generated xml output is then applied directly to the format template for the very last output.
Question 7. What Is A Layout Template?
Answer :
Layout template defines how the consumer perspectives the output, basically it may be evolved using Microsoft phrase file in rft (rich textual content layout) or Adobe pdf format. The facts output in xml format (from Data template) will be loaded in format template at run time and the required final output file is generated.
Oracle 9i Tutorial Oracle 8i Interview Questions
Question eight. What Are The Output Formats Supported By Layout Template?
Answer :
xls, html, pdf, eText and so forth are supported based totally on the commercial enterprise want.
Question nine. Do You Need To Write Multiple Layout Templates For Each Output Type Like Html/pdf?
Answer :
No, simplest format template can be created, BI Publisher generates preferred output format while the request is run.
Oracle 11g Interview Questions
Question 10. What Is The Default Output Format Of The Report?
Answer :
The default output layout described all through the layout template introduction can be used to generate the output, the equal can be modified throughout the request submission and it's going to overwrite the one defined at format template.
Oracle 8i Tutorial
Question eleven. Can You Have Multiple Layout Templates For A Single Data Template?
Answer :
Yes, multiple layouts can be defined, consumer has a preference here to apply considered one of them at run time all through conc request submission.
Oracle SOA Interview Questions
Question 12. Where Do You Register Data And Layout Templates?
Answer :
Layout template can be registered below xml writer administrator duty>Templates tab.
Data template might be registered below xml publisher admininstrator obligation> Data Definitions.
Oracle 10g Interview Questions
Question thirteen. I Want To Create A Report Output In 10 Languages, Do I Have To Create 10 Layout Templates?
Answer :
No, BI Publisher presents the required translation for your templates, primarily based at the variety of languages established for your oracle apps environment requires outputs are furnished.
Oracle 11g Tutorial
Question 14. What Is The Required Installation For Using Bi Pub Report?
Answer :
BI Publisher desktop tool has be established. Using this tool you can preview or take a look at the document before deploying the identical on to the example.
Question 15. How Do You Move Your Layout Or Data Template Across Instances?
Answer :
xdoloader is the software in an effort to be used.
Oracle SOA match 11g Interview Questions
Question sixteen. What Is The Tool To Map Required Data Output And Layout Templates So That They Can Be Tested In Local Machine?
Answer :
Template viewer might be used for the equal.
Question 17. Which Component Is Responsible For Generating The Output In Xml Format Before Applying It To Layout Template?
Answer :
DataEngine will take DataTemplate as the input and the output can be generated in xml layout with a view to then be implemented on format template.
Oracle Apps ERP Interview Questions
Question 18. Can Bi Publisher Reports Be Used In Oaf Pages?
Answer :
XDO template software helper java instructions are provided for the identical.
Oracle 9i Interview Questions
Question 19. Name Some Business Use Cases For Bi Reports?
Answer :
Bank EFT, consumer files, delivery documents, internal evaluation files or any transactional documents.
Question 20. How Do You Pass Parameters To Your Report?
Answer :
Concurrent application parameters ought to be handed, ensure that the parameter name/token are equal as within the conc prog defn and the records template.
Oracle 7.Three Interview Questions
Question 21. What Are The Various Sections In The Data Template?
Answer :
Parameter segment
Trigger Section
Sql assertion section
Data Structure section
Lexical Section
Question 22. What Does Lexical Section Contain?
Answer :
The required lexical clause of Key Flex subject or Descriptive FF are created below this phase.
Question 23. What Triggers Are Supported In Data Template?
Answer :
Before report and After document are supported.
Oracle BPM Interview Questions
Question 24. Where Is The Trigger Code Written?
Answer :
The code is written in the plsql package deal which is given beneath ‘defaultpackage’ tag of records template.
Oracle 8i Interview Questions
Question 25. What Is The File Supporting The Translation For A Layout Template?
Answer :
xliff is the document that helps the translation, you could regulate similar to required.
Question 26. How Do You Display The Company Logo On The Report Output?
Answer :
Copy and paste the logo (.Gif. Or any layout) at the header segment of .Rtf record. Ensure you resize in line with the enterprise standards.
Oracle ADF Interview Questions
Question 27. How To Upload Rtf Template From Backend?
Answer :
Using XDO Loader, we are able to add an RTF from Backend.
Oracle 11g Interview Questions
Question 28. How To Map Rtf Template Via Backend?
Answer :
Using FND_PROGRAM.ADD_TEMPLATE api we will map.
Question 29. What Are The Executable And Concurrent Program Used To Develop A Report Without Rdf?
Answer :
XDODTEXE is used as Executable, Java Concurrent Program is used Concurrent Program for developing a report with out RDF.
Oracle HRMS Interview Questions
Question 30. How To Repeat The Header Of The Template On Each And Every Page Of The Output?
Answer :
Use <?@section: ?> so one can repeat that specific phase in each web page of the output.Additionally to reset the web page wide variety.
Question 31. How Many Ways We Can Display Images In A Bi Publisher Report?
Answer :
It can be accomplished in five ways:
Direct Insertion into RTF Template
URL Reference
OA_MEDIA listing reference
Image from BLOB datatype from database
Using UI Beans
Question 32. What Are The Xml Publisher Tables?
Answer :
PER_GB_XDO_TEMPLATES
XDO_DS_DEFINITIONS_B
XDO_DS_DEFINITIONS_TL
XDO_DS_DEFINITIONS_VL
XDO_LOBS
XDO_TEMPLATES_B
XDO_TEMPLATES_TL
XDO_TEMPLATES_VL
XDO_TEMPLATE_FIELDS
XDO_TRANS_UNITS
XDO_TRANS_UNIT_PROPS
XDO_TRANS_UNIT_VALUES
Oracle Architecture Interview Questions
