If you're looking for Oracle BI Publisher Interview Questions & Answers for Experienced or Freshers, you are at the right place. There are a lot of opportunities from many reputed companies in the world. According to research, Oracle BI Publisher has a market share of about 0.7%. So, You still have the opportunity to move ahead in your career in Oracle BI Publisher Engineering. Mindmajix offers Advanced Oracle BI Publisher Interview Questions 2021 that helps you in cracking your interview & acquire your dream career as Oracle BI Publisher Engineer.
Oracle BI Publisher is a new java-based product available with the technology stacks of EBS, Peoplesoft, Siebels, JD Edwards, and BI Enterprise Edition (OBIEE). It provides users with:
1. A template-based, easy-to-use publishing solution
2. A tool to rapidly develop and maintain report formats formats
The Oracle XML Publisher data engine enables you to rapidly generate any kind of XML data structure against any database in a scalable, efficient manner. The data template is the method by which you communicate your request for data to the data engine. It is an XML document whose elements collectively define how the data engine will process the template to generate the XML.
|If you would like to Enrich your career with an Oracle BI Publisher certified professional, then visit Mindmajix - A Global online training platform: “Oracle BI Publisher Training” Course. This course will help you to achieve excellence in this domain.|
The Template Builder is an extension to Microsoft Word that simplifies the development of RTF templates. The Template Builder is tightly integrated with Microsoft Word and allows you to perform the following functions:
1. Insert data fields
2. Insert data-driven tables
3. Insert data-driven forms
4. Insert data-driven charts
5. Preview your template with sample XML data
6. Browse and update the content of form fields
Extract boilerplate text into an XLIFF translation file and test translations
Valid template file types are:
eText – Inbound, eText – Outbound, PDF, RTF, XSL-FO, XSL-HTML, XSL-TEXT, and XSL-XML.
Ans: The data engine supports the following functionality:
1. Schema generation
2. Default RTF template generation
4. Single and multiple data queries
5. Query links
7. Aggregate functions (SUM, AVG, MIN, MAX, COUNT)
8. Event triggers
9. Multiple data groups
10. Unicode for XML Output
Unicode is a global character set that allows multilingual text to be displayed in a single application. This enables you to develop a single multilingual application and deploy it worldwide.
11. Canonical format
The data engine generates data elements using the canonical ISO date format: YYYY-MM-DDTHH24:MI:SS.FF3TZH:TZM for a mapped data element, and ######.## for number elements in the data template XML output.
Select this check box if you want this template to be translatable. Only RTF templates are translatable. After the template definition is created, the following fields are not updateable: Application, Code, and Type. Update the template from the View Template page.
Ans: If the requirement is to display a different layout based on a user parameter value or a List of Value selection, then the parameter can be passed to the RTF layout and conditionally display the layout.
On the Report Editor, you first need to define a parameter with the name DeptName. If this parameter has to be associated with a List of Value (LOV), then create a LOV on the Report Editor page.
Next, in the parameter definition select parameter type as “Menu” and then select the LOV from the selection.
In the RTF template define a parameter using syntax –
Now when the user selects a department name from the List of Value on the report viewer page, the value gets passed to the RTF layer into the DeptName parameter. To display the layout based on this user selection, you can use an IF statement or a CHOOSE statement to evaluate the parameter value and call the associated sub-template.
Use CHOOSE statement when too many conditional tests are to be done and default action is expected for rest of the values, for example, for each department here we have a different sub-template and if the user parameter has a department name with no associated sub template, then a default sub-template can be called in otherwise section.
PAGE LAYOUTàWATERMARK (Word 2007)
Format → Background → Printed Watermark (Word 2003)
Developer→ controls→ legacy tools→ text field
Ans: Placed before the column name→ PT
No, BI Publisher provides the required translation for your templates, based on the number of languages installed in your oracle apps environment requires outputs are provided
BI Publisher desktop tool has been installed. Using this tool you can preview or test the report before deploying the same on to the instance.
xdoloader is the utility that will be used.
Ans: Template viewer will be used for the same.
DataEngine will take DataTemplate as the input and the output will be generated in XML format which will then be applied to layout template
XDO template utility helper java classes are provided for the same.
Bank EFT, customer documents, shipping documents, internal analysis documents, or any transaction documents
Concurrent program parameters should be passed, ensure that the parameter name/token is the same as in the conc prog defn and the data template
Parameter section Trigger Section SQL stmt section Data Structure section Lexical Section
The required lexical clause of Key Flex field or Descriptive FF are created under this section
Before report and After report are supported
The code is written in the plsql package which is given under ‘defaultpackage’ tag of the data template.
xliff is the file that supports the translation, you can modify the same as required.
Copy and paste the logo (.gif. or any format) on the header section of .rtf file. Ensure you resize per the company standards.
While BI Publisher may be a step in the right direction for Oracle, be sure to investigate your organization’s delivery needs and do not assume they can be met natively in R12.
As a Senior Writer for Mindmajix, Saikumar has a great understanding of today’s data-driven environment, which includes key aspects such as Business Intelligence and data management. He manages the task of creating great content in the areas of Programming, Microsoft Power BI, Tableau, Oracle BI, Cognos, and Alteryx. Connect with him on LinkedIn and Twitter.