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 428
- OAC 402
- 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
-
OTBI report for absence with Accrual, Adjustment and carryover details of an employee.I would like to create an OTBI report to display Accrual, Adjustment and carryover details of an employee. We have updated the carryover and adjustments through data loa… -
OTBI Analysis Report to get Aligned goal nameWe are creating a OTBI Report With subject area Goal Status overtime real time and Goal Alignments Real time. We want to get the Aligned goal name but we are not able to…
-
Logical SQL report does not display values from one subject area for a userWe have built a report on "Costing - Receipt Accounting Uninvoiced Receipt Accruals Real Time" and "Procurement - Purchasing Real Time", to display project details again…
-
duplicate values in OTBI Excel outputIn the OTBI report results tab showing only one record where as in the export showing expected number of rows along with duplicate rows. Please advise any property setti…
-
Procurement Spend analysis Report/Dashboard for Top level ExecutivesOur executives looking for for the real-time report/dashboard that will show spend analysis for all associates under their hierarchy (irrespective if transaction require…
-
How to restrict data access in OTBI reports: buyer can only retrieve their own POHi Experts, (Please advise the category of posting this inquiry, I am choosing OTBI as a start, if it is more suitable to Purchasing category then please help to migrate…
-
Sign In Sign Out Audit report in Oracle FusionSummary: Hello, We have requirement to extract User Sign In, Sign Out and IP Address details through Oracle BIP/OTBI reports. Is there any Seeded report available in Ora…
-
How to get the Take-Home Pay (Net Pay) of EMP in Oracle HCMI am working on generating reports related to Take-Home Pay (Net Pay) in Oracle HCM, which is the net amount of income a worker receives after deductions (such as taxes,…
-
conditional formatting in RTF for duplicateSummary: Is it possible to format rows so that a value is filled with yellow when the value is present in the data more than once? Content (please ensure you mask any co…
-
Oracle Procurement Cloud BIP Report - Does trigger require parameters unique to the trigger SQL?Summary: Trigger SQL returned no data when sharing the same parameter with the report logic. Content (please ensure you mask any confidential information): We are using … -
Banner on Reports & Analytics pageHi , We have noticed a new yellow banner at the top of the 'Home' page in all our environments on Reports & Analytics page since it got upgraded to 24D stating "The Mark…
-
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…
-
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…