Popular Tags
- OTBI 1,360
- Reporting 1,350
- Analysis and Data Visualization 895
- FDI 879
- BI Publisher 787
- Analysis 652
- Administration 542
- Oracle Fusion Analytics 535
- OBIEE 415
- BI Publisher Data Models 321
- Analytics 309
- OAC 270
- Answers 259
- Security 253
- Analyses 251
- Developers 234
- HCM 219
- BIP 212
- Data Modelling and Datasets 208
- Data Connectivity 205
- ERP Analytics Content 192
- Report Output 178
- BI Publisher Report Templates 177
- Agents 148
- Customizing Reports 141
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
-
24C OTBI Enhancement: Email a link to analysis results - Not workingWe see a new 24C feature listed as OTBI product enhancement. But we do not see any option on how to use that functionality. Can someone please assist here. The link Orac… -
One Prompt to query against multiple columns in an analysisI'm trying to figure out a way in OTBI when querying the Natural Account Segment - Value object, to also query against Natural Account Segment - Level 31, Level 30, Leve… -
How to suppress rows and columns with 0 value on a pivot table?I have a pivot table, and I want to be able to hide entire rows or columns if all of the values are NULL. How can I achieve this? I tried the obvious things such as filt…
-
What is the subject area that would have "returned quantity of a PO" information?Hi Experts, May I ask what is the subject area that would have "returned quantity of a PO" information? I have another CCC post submitted in "Inventory Management" categ…
-
OTBI report to see where catalog DM or item is usedWe need to understand if DM is used in any report or not. The same for some images. Is there any way to iddentify it ? Thanks
-
Why "contains all" or "is like" operator is displayed between the prompt name and the list of valuesI created a OTBI prompt for a dashboard. Unfortunately the operator "contains all" is displayed between the prompt name and the list of values. Why the operator is displ…
-
Extracting Goal SuccessCriteriaText from hrc_txn_data that is greater than 4000 Characters using OraSummary Extracting SuccessCriteriaText for Performance Goals in Draft or Pending Approval from hrc_txn_data using SQL when SuccessCriteriaText is having more than 4000 C…
-
Issue with OTBI agentsHello Oracle Community, A client has been encountering an issue with their OTBI agents, which have been running smoothly for the past few years. Recently, the agents no …
-
BICC: How to find current run extractsSummary: I an trying to submit BICC extracts through esswebservice. I see extracts are being submitted and completed without any issues. However, when I check UCM for th…
-
Why does an OTBI report run successfully for me but when the end user runs it, its spinning?The client created an OTBI Analysis for an Asset Categories report with the following columns; Major Category Default Life in Years Minor Category Asset Book Asset Cost … -
OTBI link Receivables Customer Real Time to Transactions Real TimeHi- Financials Receivables Cloud BI Using the Real Time Subject Areas how can I get a list of all Customers & their Details (Sites, Accounts, Contacts, Addresses) and de…
-
Employee Name and Person Number in Project Billing - Invoices Real Time Subject area are incorrectI tried to report on details of an invoice generated by Fusion using OTBI. When I choose the 'Project Billing - Invoices Real Time' subject area, it has the details, the…
-
How to get sickness plan entitlement values in OTBI?I'm trying to build an analysis which gives me sickness plan entitlement values using Workforce Management - Absence Real Time I can get it to show all the fields/data I…
-
Issue with Credit Memo Output FormatHello, We are facing an issue with the output format for credit memos. The requirement is to display both the invoice and adjustment line items in two separate rows. How…
-
Resizing Rows and Columns - OTBIHello! I'm creating an analysis in OTBI. How do I set columns widths using column properties, to keep those widths persisted? When I input values in the Additional Forma…
-
Subject Area: Costing - New COGS and Gross Margin Details Real Time not giving any resultSummary: Analysis created using "Costing - New COGS and Gross Margin Details Real Time" subject area is not giving any output Content (required): I tried to create a sim…
-
Document Type I9 not pulling on OTBI reportsDocument Type I9 not pulling on OTBI reports while creating reports from subject area Document of Record Real Time even though we can see it on UI query we are using SET…
-
Issue with Date Format in OTBI Report Export to ExcelHello, I am encountering an issue with an OTBI report. The 'Invoice Creation Date' column is formatted to display only the date (without the time) in the OTBI report. Ho…
-
Person Records Secured By AOR Does Not Restrict Data Reflected In OTBI ReportsSummary: Hello Everyone ! I am trying to secure the data returned by HR_ANALYST job role by using an AOR with a scope of Department. Although, it works fine in the HCM U…
-
Job change - OTBI reportHello, I would like to create an OTBI report to highlight the date of an employee's business title change. I don't want to use a specific reason code (ex promotion) beca…