Popular Tags
- OTBI 1,427
- Reporting 1,383
- FDI 1,060
- Analysis and Data Visualization 976
- BI Publisher 840
- Analysis 672
- Oracle Fusion Analytics 577
- Administration 555
- OBIEE 429
- OAC 404
- Analytics 381
- BI Publisher Data Models 346
- Security 288
- Answers 264
- HCM 255
- Analyses 253
- BIP 247
- 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
-
What is the current row limit of OTBI in Oracle Fusion?Hello Experts, I’ve recently created an OTBI report to generate a customer list and managed to fetch around 500,000 rows. Can anyone confirm the maximum row limit or sug… -
How to restrict user based on Cost Center to view OTBI ReportSummary: I have created Dashboard for Budget Vs actual. The user has Access to all the Cost Center data in dashboard. How to restrict user based on Cost Center (the user…
-
Is there any way to add daily rates in ""Costing- Receipt Accounting Real Time" Subject areaI am trying to add the daily rates in "Costing - Receipt Accounting Real Time" subject area to calculate the ledger amount(in USD) converted to the specific currency(EUR…
-
OTBI Banner - 24DHi, We have recently received the 24D update in one of our development instances. In OTBI we have noticed a new yellow banner at the top of the 'Home' page in OTBI. Is t…
-
My custom report not showing results after applying Accounts paybale payment supervisor role.Hi, I am using Payable Payment - Disbursement real time subject area to generate one report but when I pull the payment amount and payment date to layout I am not seeing… -
unable to find the Negotiations Creation date in Sourcing Subject Areaunable to find the Negotiations Creation date in Sourcing Subject Area.. Below are the subject areas where we are trying to check the Negotiations Creation date. Below a…
-
How to Restrict Business Units based on user access in OTBI parameter lovIs there any way to restrict the Business Unit based on the User access in OTBI parameter Example: If user A is assigned with US BU USD and US MFG BU USD Business unit i…
-
Scale a long numberI have a horizontal bar chart showing a long dollar figure (billions) and would like to scale it down it to $#.#B. I know this can be done for a tile but cannot determin…
-
OTBI client role based reportingHi, Our customers require to have BU or role based reporting dashboards on OTBI. They do not want to have multiple reports, the requirement is single report but the data…
-
Report job runs after the end dateSummary: One of our scheduled reporting job had run beyond the defined end date. Does anyone know why report job still appear "Active" and runs beyond provided end date?…
-
Data discrepancy between HCM Oracle UI and OTBIHello all, While developing a report we saw that the data that is stored in HCM Module UI is different from what is displayed in OTBI. We need to take a gap between this…
-
unable to access OTBI reports from Product Management subject AreaUsers are unable to any OTBI analysis from product management subject area. This issue is with user who has custom item master view only responsibility Custom responsibi…
-
Need to create alert when PO Receipt date is in closed AP periodHi Team, Need to create alert when PO Receipt date is in closed AP period. When i goto OTBI, i dont see any option to create alert, any role i am missing? please help. P…
-
User selecting accounting period for running an OTBI report without triggering ERP full licenseIn a License analysis we came to know that in Financial Analyst Role the Privilege "Manage Period Close Activities" is triggering "Oracle Fusion Enterprise Resource Plan…
-
Custom OTBI - VETS - 4212 - Legislative Information Information is missing in Output FileWe have a custom VETS - 4212 OTBI Report. But all the attributes are giving values except Legislative Information attributes in the Output File. For example: Legislative…
-
Problem in query that returns information from Oracle customers by siteSummary: My query should have only the records that were modified in sysdate SELECT /*********hz_parties******************/ hp.party_id, hp.party_name, hp.jgzz_fiscal_co…
-
Prefix SET VARIABLE PARAM_EFFECTIVE_DATE not workingWe are running some of our OTBI reports with a variable for a user-prompted date (data for a specific date). Currently, the report variable uses and displays the wrong d…
-
How to remove duplicate lines of data in OTBI report.I've written a report in order to provide aggregate data for our performance documents and their rating score. My report produces the correct data, with the exception of…
-
Error running OTBI report - The user request exceeded the maximum query governing execution time.There is an OTBI report which gives results when I run using my ID but the same report is giving error - "The user request exceeded the maximum query governing execution…
-
Large Data Set not returningHi Everyone! The organization I work for has ~10 manufacturing plants across the US. Folks on the HR compensation team analyze compensation data for those locations as a…