Interview Question For Oracle Fusion

Interview Question For Oracle Fusion 

(Q1) What is BI Publisher?

Ans: It is a reporting tool for generating the reports. More than tool it is an engine that can be integrated with systems supporting the business.

(Q2) What are the Reporting tools available in the Oracle Fusion?

Ans: 1. BIP Reports
2. OTBI reports
3. Smart View Reports
4. Financial Reporting Studio

(Q3) What is the required installation for using BI Pub report?

Ans: BI Publisher desktop tool has to be installed. Using this tool you can preview or test the report before deploying the same on to the instance.

(Q4) What is a data template?

Ans: 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

(Q5) What Triggers Are Supported In Data Template?

Ans: Before report and after report are supported.

(Q6) What are the various components required for developing a BI publisher report?

Ans: 1. Data Template
2. Layout template
3. Integration with Oracle Concurrent Manager

(Q7) What are the output formats supported by layout template?

Ans: xls, html, pdf, eText etc are supported based on the business need.

(Q8) What is XML Publisher?

Ans: Oracle XML Publisher is a template-based publishing solution delivered with the Oracle E-Business Suite. It provides a new approach to report design and publishing by integrating familiar desktop word processing tools with existing E-Business Suite data reporting. At runtime, XML Publisher merges the custom templates with the concurrent request data extracts to generate output in PDF, HTML, RTF, EXCEL (HTML), or even TEXT for use with EFT and EDI transmissions.

(Q9) What is the difference between XML publisher and BI Publisher?

Ans: XML Pub operates entirely within EBS and can only be used within EBS. BIP can be installed as a standalone version running off of several OC4J compliant engines, such as Application Server and Tomcat. BIP can be pointed anywhere, so you could do reports out of an OLTP or warehouse database, MSSQL and even within EBS. Licensing is already included in EBS, and the standalone costs whatever plus maintenance.

(Q10) What is a layout template?

Ans: Layout template defines how the user views the output, basically it can be developed using Microsoft word document in rft (rich text format) or Adobe pdf format. The data output in xml format (from Data template) will be loaded in layout template at run time and the required final output file is generated.

(Q11) What are the navigation to build BIP report in Oracle Fusion?

Ans: In Oracle Fusion, navigate to Build the BIP Report.

• Navigation of the Data Model:  Tools > Report and Analytics > Browse Catalogue > New > Data Model

• Navigation of Data Templates: Tools > Report and Analytics > Browse Catalogue > New > Report

(Q12) What exactly is a data model?

Ans: Data Model is a BI Publisher object that includes a set of instructions for retrieving and structuring data for reports. The report’s data model specifies the report’s data source, data structure, and parameters.

(Q13) What are the Data Model Components?

Ans: Data Model Components are

1. Data Set

2. Event Triggers

3. Flexfields

4. List of value

5. Parameters

6. Bursting.

(Q14) What exactly is a data set?

Ans: The logic in a Data Set is used to retrieve data from a single data source. A data set should retrieve data from a variety of sources, including a database, an existing data file, and a web service call, among others.

(Q15) Is it possible to use Triggers in a BIP Report?

Ans: Yes, Event Triggers can be used in BIP reports. Before and after data triggers, as well as scheduling triggers, are all supported by the Data Model.

A call to execute a set of functions specified in a PL/SQL package stored in an Oracle database is used in the Before Data and After Data triggers. For scheduled reporting, the Schedule Trigger is used.

(Q16) What are the terms “split by” and “deliver by”?

Ans: Split by – Select how you want the data to be split.

Deliver by – Choose who you’d like the data to be delivered.

(Q17) What is the best way to schedule BIP reports?

Ans: Following options are available to schedule BIP Reports

1. Select Report and Analytics > New > Report Job

2. Go to the Create section > Published Reporting > Report Job.

3. Select  Catalog > Select Report > More > Schedule

4. You can also use ESS Job to schedule the report.

(Q18) How you can make a report in different languages in BIP?

Ans: We will use the translation feature to make the report available in different languages. Templates can be translated from the properties page, and XLIFF files for a single template can be generated from the properties page. To create the XLIFF files, click extract translation.

(Q19) What is the use of Save As Sample button in BIP reports and can we create report without saving sample data?

Ans:  Save As Sample Button is to save the sample data in data model. Without saving sample data we cannot create report.

(Q20) How to Increase the Report Run time?

Ans:  We can increase it from Data Model Properties by giving Query Runout time

(Q21) Can we generate XML TAGS for Null Fields?

Ans:  Yes we can. We have to Check the Che box from Data Model Properties

(Q22) What is My Folder and Shared Folder in Fusion Reports?

Ans: The ‘My Folders‘ tab is your own. That ensures it’s exclusive to any person. Once you make a report in this tab, no one in the company should be allowed to read and view these files as they are encrypted and produced in the My tab. And this is your professional creation completely.

Shared Folders is the Through Software Directory. This implies the framework is shared by users according to the roles. Shared directories have several Work-related and Module-related subfolders.

(Q23) How to create Fusion BI-Publisher reports?

Ans: 

Oracle has already delivered a lot of BIP Reports in the Fusion Instance, However during a course of implementation it is a common requirement to develop new ones, There are few common steps involved they are :

• Step1: Create a SQL Query which comprises of DB Tables ( that exist in Fusion Schema).

• Step2: Under Published Reporting -> Data Model, Create a New Data Set (of SQL Query type)

• Step3: Give a Name to Data Set (for this example say PersonAssignment_ds)

• step4: You would need to take special care while selecting Data Source (Logic Below): If you are Building Finance reports use : ApplicationDB_FSCM, If you are Building HCM reports use : ApplicationDB_HCM, If you are Building CRM Reports use : ApplicationDB_CRM

• Step5: Depending on the number of Parameters( Bind Variables) used a Popup window will appear, Give a Name to the Parameters.

• Step6: At last will save the report, click on data-report and see the output.

(Q24) How to create Oracle Fusion OTBI Reports?

Ans: 

Following are the steps to build OTBI Reports

• Step1-> Login To Fusion Applications with a User login

• Step2> Click on the Navigator icon and then select ‘Reports and Analytics under Tools option.

• Step3> Click on the BI catalog icon (an open book) on top left hand side.

• Step4> Choose New Analysis from the drop-down list and then select an appropriate Subject Area (Workforce Management – Worker Assignment Real Time, for example).

• Step5> Now we would select one folder from left-hand side, inside table folder will find tables respective columns, will drag and drop required column to the dashboard to create the OTBI report.

(Q25) What is BIP Report?

Ans: 

BIP is the analysis platform for Business Intelligence Publisher and is used to produce the Oracle Cloud Complex reports. It is especially used to produce the statuary reports where we need to create the different templates. This is a technological resource that still includes the SQL experience and the cloud application’s technological awareness.

(Q26) How many Types of Roles Available in Oracle Fusion?

Ans: 

Oracle has provided these four Types of roles.

• Abstract role

• Job roles

• Duty roles

• Data roles

(Q27) What Is ESS job in Oracle Fusion?

Ans: 

The ESS job in Oracle apps is the same as the concurrent program. When we have to run the BIP reports in the Fusion Program otherwise we have to log these reports in Oracle Fusion as an ESS task. So we will operate this report as a schedule process in the Fusion as well as the parallel request in the Oracle applications.

(Q28) What is UCM in Oracle Fusion?

Ans: 

UCM stands for Universal Content Management and this server is available in Oracle cloud, following are the features of cloud UCM

• UCM is used in Oracle Cloud SAAS Environment

• We use UCM Cloud for Inbound and Outbound Integration

• UCM is same like FTP server in ebs

• UCM has different location with each have different paths

• We are not allowed to create new location and path under UCM

• We are bound to use existing locations under UCM

• 
  

(Q29) How to load Supplier data in Fusion?

Ans: 

Through FBDI process we can load Supplier data into Fusion following steps are involved

1. Download the template from the Metalink

2. Maintain the data in csv template format

3. Generate Zip file from template file

4. Load the file data into Interface table

5. Move the data into base table