Top 21 Most Important Oracle Fusion OTBI Interview Questions
Hi friends, we are going to discuss about some of the Oracle Fusion OTBI Interview Questions. We will share some of the most important oracle fusion otbi interview questions which helps for the preparation for Oracle Fusion technical interviews. These otbi interview questions really help you in you interviews. Please find below the complete detail about Top 33 Most Important Oracle Fusion OTBI Interview Questions.
 |
| Top 21 Most Important Oracle Fusion OTBI Interview Questions |
Top 33 Most Important Oracle Fusion OTBI Interview Questions
Question 1:- What is OTBI Report in Oracle Fusion OTBI ?
Answer: OTBI is the new reporting tool in oracle fusion. OTBI reporting tool is a very user-friendly tool. Using OTBI , we can develop the new report using drag and drop functionality in oracle fusion. We don't need the technical expertise in OTBI reports even business users can develop the reports using this tool using drag and drop feature.
Question 2:- What is Subject area in Oracle Fusion OTBI ?
Answer: Oracle Fusion has given the Subject Areas for each module and Under These subject areas we have different business objects. These Business Objects having all the Information's about that Oracle Fusion Modules and by which we can just drag and drop the columns from these business objects and design the OTBI reports without writing any SQL query. This is the good part of the Subject Area in Oracle Fusion OTBI reports. OTBI reports automatically creates all the sql query to design the OTBI reports.
For Example : Oracle Fusions has given many subject areas for Financials , but we need to identify the exact Subject area as per our Requirment and under this Subject area we need to identify the right Business Object which have all the required columns on which we want to design the OTBI reports.
Question 3:- What is My Folder in Oracle Fusion OTBI Reports ?
My Folders:-
My Folders' is your
own folder. It means it is specific to each user. when you will create your
report under this folder then no one in the application can see and access
these reports because these are saved and created under your My folder. So this
is totally yours personal Development.
Question 3:- What is Shared Folder in Oracle Fusion OTBI Reports ?
Shared Folders:-
Shared Folders is your Application common Folder. It means it is shared across users of the application as per the roles. Shared folders have many Sub-folders related to the Work related and Module Related.
Question 4:
How to Give Permissions for the OTBI reports in Oracle Cloud for Users: User Access permissions in Oracle cloud reports?
User can run and view the OTBI report output based on the permission given to that user. User access permissions are very important step to run the Oracle cloud OTBI reports.
There are two types of Data access/Permissions in the OTBI reports
1. Reports Access
2.Data Access
1.Reports Access :-
To execute the report or to see the report in the report folder we should have the access to that report. Reports access are further sub-divided into three parts.
• Execute Access
• Modify Access
• Run , Modify & Delete access
To run the report we should have the execute access.
To modify or edit the report code or layout we should have Modify access
To do all the Run , Modify & Delete access , We should have this third access
2.Data Access :-
After providing the Report access , How we can restrict the user to see the Particular Business Unit Data or Particular Ledger Data . These things do control through this Data Access. If you are running the OTBI report and you report is not showing any data or completing in error , this might be an issue of Data Access.
|
| Top 21 Most Important Oracle Fusion OTBI Interview Questions |
Question 5:-
What are the Steps to Give Permission for the OTBI reports ?
Answer:
Step 1:-Go to the OTBI report and Click on more Option highlighted as below
Step 2:- Click on More Option and Select the Permissions Option as highlighted below.
Step3:- As below by default , BI Administrator Role have all the report access but if you want to provide access to some specific roles or users then you need to follow the below steps.
Click on the '+' icon as highlighted below.
Step 4:-We can provide the Report access on these levels.
In List option , we need to select 'Application Roles' if we want to assign the reports based on roles.
Select the role and drag to right side.
Step 5:-
If you want to assign the reports access based on Application user then we need to select the Users from the List. Select the desired user
Question 6:- How to implement OTBI Data security in Oracle Cloud ?
Answer:
Go to Setup and Maintenance and then Search the ‘Manage Data Access for Users’ as below.
 |
| Top 33 Most Important Oracle Fusion OTBI Interview Questions |
Click on the ‘+’ icon to create the Data Access for Application User.
 |
| Top 33 Most Important Oracle Fusion OTBI Interview Questions |
Question 7:- What is dashboard in Oracle Fusion OTBI Reports ?
Answer:
Dashboard In oracle fusion is also one of the report tools or we can say data dashboard in which we can display the OTBI reports. In One dashboard we can show multiple OTBI reports/graphs as per the requirement.
|
| Top 21 Most Important Oracle Fusion OTBI Interview Questions |
Question 8:- What is dashboard prompts in Oracle Fusion OTBI Reports ?
Answer:-
Dashboard prompts helps to create the parameters in the OTBI dashboards. Using Dashboard prompts , we can create the parameterized dashboard in oracle fusion OTBI Reports.
Question 9:- What is required OTBI steps before creating the dashboard prompts for the OTBI report ?
Answer:
If we are creating the dashboard prompt for the OTBI report dashboard , then we must need create the prompts first in the OTBI report and both OTBI and Dashboard prompts should be from same subject area and using same column.
|
| Top 21 Most Important Oracle Fusion OTBI Interview Questions |
Question 10:- What is filters in Oracle Fusion OTBI reports ?
Answer:
Filters is the some thing like static conditions in otbi reports which we can put in the otbi report while designing. It helps to extract the OTBI reports data based on tat condition.
Question 11:- Can we implement the drill down features in the Oracle Fusion OTBI reports ?
Answer: Yes, We can implement the drill down feature in the Oracle Fusion OTBI reports. Oracle Fusion OTBI has provided the feature which helps to drill down the from OTBI report to the Actual oracle application transaction.
For Example , we can drill down from for AP invoice from report to the actual AP invoice created in the Oracle Cloud application.
Question 12:- What are steps to implement the drill down in OTBI reports ?
Answer:-
Step 1:- To define the action drill down link on Invoice Number column in OTBI report, click on Column properties and navigate to the Interaction tab. This drill will take you to the Create Payment page where you can enter the invoice details and make the payment.
Step 2:- Click on Add Action Link, give a link text and select the “Navigate to a Web Page” option.
Step 3:- Enter the URL of the target page (Manage Invoices in view mode in this case) in the format as shown below in the Action URL and click on Define Parameters.
https://hostname/fscmUI/faces/deeplink?objType=@{1}&action=@{2}&objKey=InvoiceId= @{3}
For Example :-
https://test1.dev.oraclecorporations.com/fscmUI/faces/deeplink?objType=@{1}&action=@{2}&objKey=InvoiceId= @{3}
Step4:- We need to enter the url created in Step5 in the Action Window
|
| Top 21 Most Important Oracle Fusion OTBI Interview Questions |
Question 13:- Explain some of the features of OTBI report ?
Answer:
Can be used by both End user and technical team
Lot of out of box reports and delivered subject areas
New Subject Areas or their modification requires working with Oracle through SR
Lack of detailed documentation on delivered Subject Areas
Building rich, visual and interactive reports and publish it to multiple users.
Creating reports using real time transactional data.
Enabling the business users to access, analyse, and use the transactional information.
Perform self- service, ad-hoc analysis.
Make better operational decisions based on real time analysis.
Question 14:- Difference between OTBI & BIP Report ?
Answer:
OTBI:-
The difference between OTBI and BIP is that , 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( Data models is same as Oracle RDF data model used to built sql query and fetch data) and provided standard layouts also but there is also flexibility in the OTBI is this user can use the standard data model and change the report output as per the need so its quite user friendly reporting system.
Second this in OTBI ,Oracle has created Data models for most of its important data tables so user can create reports on any data bases on these data models. But we cannot do changes in Standard OTBI Data Models but there is a provision by which we can do change in the standard data model but then we need to save it in a Different name.
BIP :-
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 , Different -2 groups then Link groups with Data Links. 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.
But in Oracle R12 , we have very important useful tool set that Formula Columns , Placeholder and summary columns but these tool set is not available in BIP reports. We can do some calculation in BIP on columns but we cannot write separate code in BIP like Formula column in Oracle RDF. This is a Big limitation in BIP reports because Formula Columns and Placeholder and Summary Columns quite useful in designing Complex reports.
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.
|
| Top 21 Most Important Oracle Fusion OTBI Interview Questions |
Question 16:- Can we use the DFF FlexField columns in the OTBI report output ?
Answer:
Yes, We can include the DFF flexfield columns in the OTBI reports. Oracle Fusion has provided this feature to include that.
Question 17:- How to enable the DFF FlexField columns in the OTBI report
Answer:
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.
Question 18:-
What are the steps to create the OTBI reports in oracle fusion ?
Answer:
We need to follow this below navigation to create the OTBI report .
OTBI Reports Creation:
Navigation : Tools-> Reports & Analytics-> Browse Catalog -> New -> Analysis
0 comments:
Post a Comment