Popular Tags
- OTBI 1,429
- Reporting 1,383
- FDI 1,062
- Analysis and Data Visualization 976
- BI Publisher 840
- Analysis 673
- Oracle Fusion Analytics 577
- Administration 555
- OBIEE 429
- OAC 408
- Analytics 382
- BI Publisher Data Models 346
- Security 288
- Answers 264
- HCM 256
- Analyses 253
- BIP 248
- Developers 243
- Data Modelling and Datasets 223
- Data Connectivity 208
- ERP Analytics Content 205
- BI Publisher Report Templates 201
- Report Output 183
- Oracle Analytics Cloud 168
- Customizing Reports 156
Welcome to the Oracle Transactional Business Intelligence Community Forum!
Whether you're a seasoned user or just starting your journey with OTBI, the solution for transactional reporting in Fusion Apps, this forum is your go-to for questions and discussions. Connect with experts, seek advice, share insights, and post product recommendations in the Idea Lab.
If you're new to OTBI, visit our Doc Library and OTBI Resources pages for more details and answers to common questions - links to these and more are available in the Knowledge Base: https://community.oracle.com/products/oracleanalytics/kb/articles/62-resources-for-oracle-transactional-business-intelligence-otbi
For OTBI inquiries on subject areas and use cases, please direct your questions to one of our OTBI pillar forums (HCM, ERP, SCM, Sales, Field Service) on Customer Connect to receive tailored assistance.
Whether you're a seasoned user or just starting your journey with OTBI, the solution for transactional reporting in Fusion Apps, this forum is your go-to for questions and discussions. Connect with experts, seek advice, share insights, and post product recommendations in the Idea Lab.
If you're new to OTBI, visit our Doc Library and OTBI Resources pages for more details and answers to common questions - links to these and more are available in the Knowledge Base: https://community.oracle.com/products/oracleanalytics/kb/articles/62-resources-for-oracle-transactional-business-intelligence-otbi
For OTBI inquiries on subject areas and use cases, please direct your questions to one of our OTBI pillar forums (HCM, ERP, SCM, Sales, Field Service) on Customer Connect to receive tailored assistance.
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Oracle Transactional Business Intelligence
Discussion List
-
Find Performer of the action plan on bi Publisher tablesI'm looking for this information in the bi Publisher tables: I looked through its tables: HRT_TASK_USERS, HRT_TASKS, HRT_TASK_OBJ_RELATIONS, but I didn't find it, do you… -
How to return only the max ID grouped by selected column (SQL)?I am working on an OTBI report that uses Advanced SQL to create the analysis. The reason for using this method is specific to the type of report I am working to build, w… -
Workers with Active ProfilesHi, We can see a column Count of Profiles in Workforce Profiles – Person Profile Real Time having values 1 and 0. What exactly oracle is considering for giving 0 and 1 f…
-
OTBI Reporting for Personal Corporate Card TransactionsI need to build an OTBI report that shows all corporate card transactions that have been identified as "Classify as Personal". How can I do this?
-
Is it possible to show the "job" of the manager in the "Assignment Manager (Unsecured)" Dimension?I am creating a report to look at if employees who are direct or indirect reports for a manager are in the same function area. For example, if a top level manager is HR,… -
We are not able to find the field 'Default Expense Account' which is available in Assignment DetailsWe are not able to find the field 'Default Expense Account' which is available in Assignment Details. we have tried PVO 'HcmTopModelAnalyticsGlobalAM.AssignmentAM.Assign…
-
BIP Report with Custom FontHi can some please share steps to implement a BIP Docx report using custom fonts. Customer uses a custom font (Lusail) and want to create a report with Lusail Font.
-
Scheduled OTBI Reports Missing RecordsWe have a couple of OTBI Scheduled jobs that run monthly. We're not sure why, but when two of the scheduled agents run they are missing records. Example: One of the sche…
-
Project Number for Payables Invoices in JournalsGood Day, Where can I pull the correct project number field for payables sources? We use 3 subject areas for our report where both Journals Real Time are mainly used: - …
-
Deep Links (23B) the complete overview (all of them)We all know that you can create Deep Links from your OTBI / BI Publisher (incl notifications), otherwise check here Creating Analyses and Dashboards in Oracle Transactio…
-
Can you share a KPI via agent directly as html to an email? (FUSION OTBI)We created a dashboard that has kpis (inside kpi watchlist) and it looks fine via web. However when we create an agent to send it directly to execs emails (as HTML) ever…
-
How to track the last run details of the OTBI report?Need to find the Last Run details of the OTBI report user wise.
-
How to make prompts optional in Logical SQL based OTBI analysisHi Experts, We are trying to build OTBI analysis using logical SQL approach and there are few prompts required which are not a part of Select statement so we are trying …
-
Comma separated value input in presentation variable - OTBI report IssueHello Team, We have a requirement to have a comma separated order numbers as an input variable and have data filter criteria driven by this input to help them manage Ord…
-
Channel Details from "User System Usage" subject area not returning any value in OTBI AnalysisHi, Please suggest a solution to see the Channel Details from "User System Usage" subject area in my OTBI Analysis Report. After adding "User System Usage"."Channel"."Ch…
-
Fusion Applications BIP SOAP webservice calls - Other authentication options neededFusion Applications BIP SOAP webservice calls - Other authentication options needed: Please share any other authentication mechanism available other than Basic authentic…
-
Getting Users Assets information from Oracle FusionHello, We have an assets report that show the IT assets assigned to each user in the organization. This report was developed from Oracle E-business on premise version. R…
-
Why user with only Employee role can see OTBI report and share the same permission as BI ConsumerAs we are assigning user roles and trying to limit their access to certain reports using the OTBI permission, noticed that a user who only assigned with "employee" role …
-
How to add DFF from customer account to standard Receivables Create Transaction page using Sandbox?Hello, We have added several DFFs on the customer account level. Customer would like to see one of them on the invoice header. I started to follow community link below (…
-
OTBI Subject area new cogs and Gross margin real time cogs -present un-recognized while recognizedHi, i have created report based on subject area "new cogs and Gross margin real time" and i found sale order which was fully recognized while in the report is null , in …