Q31) Difference between OTBI & BIP Report? Ans: OTBI REPORTS: OTBI is the standard reporting system like Oracle standard reports in R12. But in R12 we or user did not have that flexibility to change its output as per the requirement but in Oracle fusion Oracle has provided this feature through OTBI. In OTBI oracle has provided standard Data Models & standard layouts but there is also flexibility that user can change the report output as per the need so its quite user friendly reporting system.
BIP REPORTS: BIP is the customize reporting tool. Oracle Fusion has provided BIP to create custom reports or to meet the need of the business which is not achievable through OTBI reporting tool.
BIP is most similar like Oracle RDF report in which we creates Data Models, 2 Different groups & Link groups to link the data. We can create Before and After Report triggers in form of event triggers. We can Create Parameters and List of Values also. We can also use custom Package also in the BIP.
We can also create Lexical Parameters in Oracle Fusion BIP reports so that we can change the report query dynamically based on conditions. We can creates Lexical parameters with the help of Event trigger but this is also possible if you using Oracle Fusion PAAS service if you are using Oracle Fusion SAAS then you cannot use Event Trigger.
Q32) Can we use the DFF FlexField columns in the OTBI report output? Ans: Yes, We can include the DFF flexfield columns in the OTBI reports.
Q33) How to enable the DFF FlexField columns in the OTBI report? Ans: Login to FUSION Application. 1. Navigate to the DFF created in the Manage Descriptive Flexfield. 2. Find the newly added Segment. 3. Mark it BI enabled. 4. After marking as BI Enabled, customer needs to deploy the flexfield. 5. Run the “Import Oracle Fusion Data Extensions For Transactional Business Intelligence” process from the scheduled process area. 6. Wait for the process to complete successfully. 7. Verify in OTBI if you can see the newly added segment.
Q34) What are the steps to create the OTBI reports in oracle fusion? Ans: Navigation: Tools –> Reports & Analytics –> Browse Catalog –> New –> Analysis.
Q35) What is the difference between Reports and Extracts? Ans: Report will give full file & extracts will give the data based on conditions.
Q36) What are the different BI reports templates that we can use? Ans: RTF, Excel, Drag and Drop.
Q37) What is the schedule process name to send email notification about user account details Ans: Send email to Multiple users.
Q38) What is Auto provision Rules? Ans: Auto Provision Rules is used to assign a Roles to the users based on Criteria
Q40) What Is File De-Batching? Ans: When a file contains multiple messages, you can choose to publish messages in a specific number of batches. During De-Batching, the file reader, on restart, proceeds from where it left off in the previous run, thereby avoiding duplicate messages. File De-Batching is supported for files in XML and native formats.
Below Youtube channel having the detail video’s on ORACLE Fusion, Oracle Apps, PLSQL, SQL and Other Technologies.
If you need any additional help or you have any query you can write at [email protected]
Oracle BI Publisher Interview Questions
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
What is a Data Template?
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.|
Q What is BI Publisher?
Ans: BI Publisher is a reporting tool for generating the reports. More than tool it is an engine that can be integrated with systems supporting the business.
Learn Oracle BI Certification Course to Build Your Skills & Career
31)How to do conditional formatting in XML Publisher?
Conditional formatting in BI Publisher/XML Publisher can be done in these some of the following ways :
1. if statements:
2. if then else statements
3. choose statements : for multiple conditions
There are more ways for conditional formatting in addition to the above like column formatting ,row formatting etc.
32)What are the XML publisher tables?
33)How does the concurrent program submitted by the user knows about the datatemplate or layout template it should be using for generating the output?
The concurrent program ‘short name’ will be mapped to the ‘code’ of the Data template. Layout template is attached to the data template, this forms the mapping between all the three.
34) 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 concurrent program ‘short name’ will be mapped to the ‘code’ of the Datatemplate. Layout template is attached to the data template, this forms the mapping between all the three.
35) What Is A Data Template?
Data template is an xml structure which contains the queries to be run against the database so that desired output in xml format is generated, this generated xml output is then applied on to the layout template for the final output.
36)What Triggers Are Supported In Data Template?
Before report and after report are supported.
37)‘IF ELSE’ condition in XML publisher
XML Publisher supports the common programming construct “if-then-else”. This is extremely useful when you need to test a condition and conditionally show a result. For example:
You can also nest these statements as follows:
Use the following syntax to construct an if-then-else statement in your RTF template:
For example, the following statement tests the AMOUNT element value. If the value is greater than 1000, show the word “Higher”; if it is less than 1000, show the word “Lower”; if it is equal to 1000, show “Equal”:
38)How to get SYSDATE in the header section dynamically when we run the report
You cannot insert form fields in the Header section, but you can just insert the code to achieve this. For example: insert this in the header section to view the sysdate: You could format the date as you would like..
39) How to write a loop in rtf template design?
40) How to design sub templates in rtf layout?
41)How to call a header or footer?
Using this tag:
We have to use header section and footer section of the page.
How run BIP report in Oracle Fusion?
What is Bip in Oracle Cloud?
What is Oracle BIP report?
What is XML Publisher in Oracle Apps?