Popular Tags
- OTBI 1,401
- Reporting 1,365
- FDI 961
- Analysis and Data Visualization 953
- BI Publisher 816
- Analysis 663
- Administration 553
- Oracle Fusion Analytics 543
- OBIEE 421
- Analytics 342
- OAC 336
- BI Publisher Data Models 335
- Security 271
- Answers 261
- Analyses 253
- Developers 240
- HCM 237
- BIP 232
- Data Modelling and Datasets 218
- Data Connectivity 205
- ERP Analytics Content 199
- BI Publisher Report Templates 184
- Report Output 180
- Agents 151
- Customizing Reports 146
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
-
OTBI Dashboard Dependent Prompt is not taking another prompt value in sql ?We are trying to create dependent prompt in OTBI. Dependent prompt is created using sql as we need to put some additional conditions. We are using following syntax but i… -
OTBI Query to Retrieve the Most Up To Date Record of a Learners Learning AssignmentI have been having issues with trying to pull the most up to date learning assignments for people for a report. I have been using WLF_ASSIGNMENT_RECORDS_F and it is all …
-
Time Series Calculations - Using a Count Measure for YTDHello all, I'm attempting to create a measure using the time series calculation of TODATE to achieve YTD numbers. For example, if I need to achieve YTD invoice amounts t…
-
Setup IBAN for EMEA population in OracleSummary: We need to setup Banking Info within Oracle and unsure how to set this up for the EMEA population using “IBAN”. Can anyone guide me the process do the same? Con…
-
Simplest programmatic way of scheduling BI Publisher jobs in Fusion FinancialsSummary: Any light touch report scripted report submission tools that can be used with Fusion Financials for BI Publisher scheduled job submission Content (please ensure…
-
Language ReportI had created a roster report for employees to run which will generate a list of employees and the language that they speak in case they need a translator. However, I am…
-
Graph not displaying the linesSummary: Hi, I want the graph to display the lines independently of if there are employees under each rating. It is only showing the data for the ratings where there are…
-
I need to make a report in OTBI that only shows information for its AORI have a report that shows the salary history of the employees, which should work for a custom role that we have in the company, which works through the areas of respons…Sebastian Ramos Felix - HCM Specialist 1 view 2 comments 0 points Most recent by Sebastian Ramos Felix - HCM Specialist
-
OTBI filter helpI want add the condition for the filter to pull last month whole data based on running month. Column name is "Assignment Absences Details"."Date Start" Please help
-
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… -
Converting an OTBI report to a BIP reportI have an OTBI report that is causing an access error for the user. Could we convert this report to a BIP report and remove any access restrictions to ensure it function…
-
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?…