Popular Tags
- OTBI 1,442
- Reporting 1,390
- FDI 1,103
- Analysis and Data Visualization 982
- BI Publisher 850
- Analysis 679
- Oracle Fusion Analytics 583
- Administration 555
- OAC 444
- OBIEE 433
- Analytics 400
- BI Publisher Data Models 353
- Security 292
- Answers 264
- HCM 262
- BIP 260
- Analyses 255
- Developers 244
- Data Modelling and Datasets 228
- Data Connectivity 210
- ERP Analytics Content 208
- BI Publisher Report Templates 204
- Oracle Analytics Cloud 191
- Report Output 184
- Fusion Data Intelligence 170
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
- 
             Retrieve records for Supplier Audit reports in OracleHi I am trying to find below attributes from the Tools- Audit reports from UI but not able to find the table and attributes for Supplier Audit report. Please advise! Retrieve records for Supplier Audit reports in OracleHi I am trying to find below attributes from the Tools- Audit reports from UI but not able to find the table and attributes for Supplier Audit report. Please advise!
- 
             How to Automatically Refresh Dashboard in OTBI?Hi Gurus, We have an operational dashboard build which is displayed on the Production Floor. Is there a way to make it auto-refresh. We have observed that user need to a… How to Automatically Refresh Dashboard in OTBI?Hi Gurus, We have an operational dashboard build which is displayed on the Production Floor. Is there a way to make it auto-refresh. We have observed that user need to a…
- 
             ESS Job, Including the there future run time, Analytics and Pre-build Subject area requiredHi, I need to have details about the ESS process name, and there schedule time interval and next run analytics report. Need to monitor the schedule process. Thanks and r… ESS Job, Including the there future run time, Analytics and Pre-build Subject area requiredHi, I need to have details about the ESS process name, and there schedule time interval and next run analytics report. Need to monitor the schedule process. Thanks and r…
- 
             add invoice life cycle details to OTBI analysis?Is it possible to add the Order Life Cycle details to an OTBI analysis? We have created OTBI analysis using subject area "Procurement - Purchasing Real Time". Now we wan… add invoice life cycle details to OTBI analysis?Is it possible to add the Order Life Cycle details to an OTBI analysis? We have created OTBI analysis using subject area "Procurement - Purchasing Real Time". Now we wan…
- 
             Headcount filter by quarter end date too low and jumps aroundI want to report on headcount and FTE (also by age, grade etc.) for each department over the past 10 or so reporting/fiscal quarters. I am running an Analysis in OTBI, u… Headcount filter by quarter end date too low and jumps aroundI want to report on headcount and FTE (also by age, grade etc.) for each department over the past 10 or so reporting/fiscal quarters. I am running an Analysis in OTBI, u…
- 
             Function WITH clause is not working in BI Publisher report. ORA-32034: Unsupported Use Of WITH ClaHello Expert , In the TEST instance only, we encounter a problem with some BIP reports. The same report works as expected in the PROD instance. According to my analysis,… Function WITH clause is not working in BI Publisher report. ORA-32034: Unsupported Use Of WITH ClaHello Expert , In the TEST instance only, we encounter a problem with some BIP reports. The same report works as expected in the PROD instance. According to my analysis,…
- 
             Retrieve only managers with at least one report having a specific legal entityHello experts, we would like to create an OTBI report with a list of managers (only managers name and person number). In particular we would like to retrieve only manage… Retrieve only managers with at least one report having a specific legal entityHello experts, we would like to create an OTBI report with a list of managers (only managers name and person number). In particular we would like to retrieve only manage…
- 
             Getting this error in OTBI: ACI0A5LNOne of our users, when trying to access a report in OTBI get the following error when they click to view report Any idea how can I resolve this? Getting this error in OTBI: ACI0A5LNOne of our users, when trying to access a report in OTBI get the following error when they click to view report Any idea how can I resolve this?
- 
             Seniority Dates v3 causing issueWe are currently building a report using the "Payroll - Payroll Run Results Real Time" subject area. When we add attributes from the "Workforce Management - Person Senio… Seniority Dates v3 causing issueWe are currently building a report using the "Payroll - Payroll Run Results Real Time" subject area. When we add attributes from the "Workforce Management - Person Senio…
- 
             Alter OTBI column properties on multiple columns in one actionIn an OTBI Analysis, is it possible to change the column properties on multiple columns (without having to access column properties on each column separately) - IE; can … Alter OTBI column properties on multiple columns in one actionIn an OTBI Analysis, is it possible to change the column properties on multiple columns (without having to access column properties on each column separately) - IE; can …
- 
             i am working on OTBI report Payables Invoices - Transaction real time Subject areai am working on OTBI report Payables Invoices - Transaction real time Subject area . where i am pulling the details of Account Debit and Account Credit , accounting date… i am working on OTBI report Payables Invoices - Transaction real time Subject areai am working on OTBI report Payables Invoices - Transaction real time Subject area . where i am pulling the details of Account Debit and Account Credit , accounting date…
- 
             How to fetch Sales Engineer column from OTBI in oracle fusion using subject areasHi, We have a requirement to fetch the sales engineer column from Leads page using OTBI Subject areas. But we are unable to fetch the sales engineer column using subject… How to fetch Sales Engineer column from OTBI in oracle fusion using subject areasHi, We have a requirement to fetch the sales engineer column from Leads page using OTBI Subject areas. But we are unable to fetch the sales engineer column using subject…
- 
             Dunning History report showing letters sent based on InvoiceHi All, Do we have any seeded report or real time area where we can find history of dunning letters sent or at what stage dunning letters are based on Invoice. I have qu… Dunning History report showing letters sent based on InvoiceHi All, Do we have any seeded report or real time area where we can find history of dunning letters sent or at what stage dunning letters are based on Invoice. I have qu…
- 
             OTBI - How to create Drill Down with custom data model reportsHi everyone, I’m working with two custom Data Model Reports in Oracle BI Publisher, and I’d like to know if there’s a way to drill down from one report (Project) to anot… OTBI - How to create Drill Down with custom data model reportsHi everyone, I’m working with two custom Data Model Reports in Oracle BI Publisher, and I’d like to know if there’s a way to drill down from one report (Project) to anot…
- 
             What is the difference between Archiving and Downloading BI objects?What is the difference between .catalog and .xdmz/.xdoz BI objects, the archive and download options thru OTBI (/analytics) and Oracle Analytics Publisher (/xmlpserver)?… What is the difference between Archiving and Downloading BI objects?What is the difference between .catalog and .xdmz/.xdoz BI objects, the archive and download options thru OTBI (/analytics) and Oracle Analytics Publisher (/xmlpserver)?…
- 
             How do I change YTD to FYTD in a measure column?In the General Ledger Transactional Balances Real Time, there are measures for "Entered YTD CR" and "Entered YTD DR". This gives totals for the calendar year. How do I u… How do I change YTD to FYTD in a measure column?In the General Ledger Transactional Balances Real Time, there are measures for "Entered YTD CR" and "Entered YTD DR". This gives totals for the calendar year. How do I u…
- 
             How to restrict OTBI reports data not to send to external mail idsUsers are able to access and schedule OTBI reports. We want to restrict not to send users to external email domains other than organization domains. How to restrict OTBI reports data not to send to external mail idsUsers are able to access and schedule OTBI reports. We want to restrict not to send users to external email domains other than organization domains.
- 
             Item Description error from Dashboard Promptcurrently working on Purchase history dashboard , using subject area- Procurement -Purchasing real time , when we are searching with item description (long item descript… Item Description error from Dashboard Promptcurrently working on Purchase history dashboard , using subject area- Procurement -Purchasing real time , when we are searching with item description (long item descript…
- 
             How To Set First Day And Last Day Of Previous Month As Default Value For Parameters?Hi everyone, I’d like to know if there’s any way to set the Default Value of a Parameters date field to automatically get the first and last day of the previous month, o… How To Set First Day And Last Day Of Previous Month As Default Value For Parameters?Hi everyone, I’d like to know if there’s any way to set the Default Value of a Parameters date field to automatically get the first and last day of the previous month, o…
- 
             Update “Contact Us” Section Contact Details in Journeys Checklist TemplateHi, In Oracle HCM Journeys (Checklist template → Display Settings), the “Contact Us” section by default shows the contact details of Payroll and other HR roles. Currentl… Update “Contact Us” Section Contact Details in Journeys Checklist TemplateHi, In Oracle HCM Journeys (Checklist template → Display Settings), the “Contact Us” section by default shows the contact details of Payroll and other HR roles. Currentl…