Interview Questions.

Q1. Name Some Business Use Cases For Bi Reports?
Bank EFT, client reports, delivering archives, interior examination records or any tractional archives.

Q2. What Triggers Are Supported In Data Template?
Prior to report and After report are upheld.

Q3. What Is A Data Template?
Datatemplate is a xml structure which contains the questions to be gone against the data set so that ideal result in xml design is created, this produced xml yield is then applied on to the format layout for the last result.

Q4. What Is A Layout Template?
Design layout characterizes how the client sees the result, essentially it very well may be created involving Microsoft word record in rft (rich message arrangement) or Adobe pdf design. The information yield in xml design (from Data format) will be stacked in design layout at run time and the expected last result record is created.

Q5. What Are The Output Formats Supported By Layout Template?
xls, html, pdf, eText and so forth are upheld in light of the business need.

Q6. How Do You Pass Parameters To Your Report?
Simultaneous program boundaries ought to be passed, guarantee that the boundary name/token are same as in the conc prog defn and the information layout.

Q7. How To Upload Rtf Template From Backend?
Utilizing XDO Loader, we can transfer a RTF from Backend.

Q8. Do You Need To Write Multiple Layout Templates For Each Output Type Like Html/pdf?
No, main design layout will be made, BI Publisher creates wanted yield design when the solicitation is run.

Q9. What Component Is Responsible For Generating The Output In Xml Format Before Applying It To Layout Template?
DataEngine will accept DataTemplate as the information and the result will be created in xml design which will then be applied on format layout.

Q10. What Is The Difference Between Xml Publisher And Bi Publisher?
Name is the distinction, at first it was delivered on the name of xml distributer( the underlying patchset), later on they have added more highlights and called it Business Intelligence Publisher. In BI as a matter of course we have combination with Datadefinitions in R12 occasion. Both these names can be utilized conversely.

Q11. What Are The Xml Publisher Tables?
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

Q12. What Is Bi Publisher?
It is a revealing device for creating the reports. More than device a motor can be coordinated with frameworks supporting the business.

Q13. Where Do You Register Data And Layout Templates?
Design layout will be enlisted under xml distributer head responsibility>Templates tab.

Information layout will be enlisted under xml distributer admininstrator responsibility> Data Definitions.

Q14. What Are The Various Sections In The Data Template?
Boundary segment
Trigger Section
Sql proclamation segment
Information Structure area
Lexical Section
Q15. What Are The Executable And Concurrent Program Used To Develop A Report Without Rdf?
XDODTEXE is utilized as Executable, Java Concurrent Program is involved Concurrent Program for fostering a report without RDF.

Q16. What Is The File Supporting The Trlation For A Layout Template?
xliff is the document that upholds the trlation, you can alter equivalent to required.

Q17. Is Bi Publisher Integrated With Oracle Apps?
Indeed, it is firmly coordinated with Oracle Apps for revealing requirements. In 11.5.10 cases xml distributer was utilized, in R12 we can it BI Publisher.

Q18. Where Is The Trigger Code Written?
The code is written in the plsql bundle which is given under 'defaultpackage' tag of information format.

Q19. What Are The Various Components Required For Developing A Bi Publisher Report?
Information Template, Layout format and the incorporation with Concurrent Manager.

Q20. I Want To Create A Report Output In 10 Languages, Do I Have To Create 10 Layout Templates?
No, BI Publisher gives the expected trlation to your formats, in view of the quantity of dialects introduced in your prophet applications climate requires yields are given.

Q21. How Do You Move Your Layout Or Data Template Across Instances?
xdoloader is the utility that will be utilized.

Q22. What number of Ways We Can Display Images In A Bi Publisher Report?
It very well may be done in 5 ways:

  Direct Insertion into RTF Template
  URL Reference
  OA_MEDIA registry reference
  Picture from BLOB datatype from information base
  Utilizing UI Be
Q23. Might You at any point Have Multiple Layout Templates For A Single Data Template?
Indeed, various formats can be characterized, client has a decision here to utilize one among them at run time during conc demand accommodation.

Q24. What Is The Required Installation For Using Bi Pub Report?
BI Publisher work area instrument has be introduced. Utilizing this instrument you can review or test the report prior to sending something very similar on to the case.

Q25. How To Map Rtf Template Via Backend?
Utilizing FND_PROGRAM.ADD_TEMPLATE programming interface we can plan.

Q26. How To Repeat The Header Of The Template On Each And Every Page Of The Output?
Use <?@section: ?> to rehash that particular segment in each page of the output.also to reset the page number.

Q27. What Does Lexical Section Contain?
The necessary lexical provision of Key Flex field or Descriptive FF are made under this part.

Q28. 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?
The simultaneous program 'shortname' will be planned to the 'code' of the Datatemplate. Format layout is joined to the datatemplate, this structures the planning between all the three.

Q29. How Do You Display The Company Logo On The Report Output?
Reorder the logo (.gif. or on the other hand any configuration) on the header segment of .rtf record. Guarantee you resize per the organization norms.

Q30. Could Bi Publisher Reports Be Used In Oaf Pages?
XDO layout utility assistant java classes are accommodated something very similar.

Q31. What Is The Default Output Format Of The Report?
The default yield design characterized during the format layout creation will be utilized to produce the result, the equivalent can be changed during the solicitation accommodation and it will overwrite the one characterized at format.

Q32. What Is The Tool To Map Required Data Output And Layout Templates So That They Can Be Tested In Local Machine?
Layout watcher will be utilized for something very similar.