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
- 
             HCM - OTBI report no results when joining Goals with Checklists SAHello, We have an OTBI report to display employment data, Performance goals data and answers to a questionnaire used in check-in. We are using following subject areas: W… HCM - OTBI report no results when joining Goals with Checklists SAHello, We have an OTBI report to display employment data, Performance goals data and answers to a questionnaire used in check-in. We are using following subject areas: W…
- 
             In Sales CRM, Custom Fields from Custom object are not visible in OTBI Subject Area.Hi, In Sales Opportunities, we have created fields in Custom child objects, but those fields are not getting captured in any Sales CRM Related subject areas. We have use… In Sales CRM, Custom Fields from Custom object are not visible in OTBI Subject Area.Hi, In Sales Opportunities, we have created fields in Custom child objects, but those fields are not getting captured in any Sales CRM Related subject areas. We have use…
- 
             How can a senior manager see information on people who have left the organisation?We have come across an interesting problem; a difference between what a line manager can see versus what an HR Professional can see. If an analytic (based on assignments… How can a senior manager see information on people who have left the organisation?We have come across an interesting problem; a difference between what a line manager can see versus what an HR Professional can see. If an analytic (based on assignments…
- 
             Need 'UOM Conversion details' in Subject areaOTBI dashboard is being developed for CSRs to view the availability of items in different UOMs with their conversion factors UOM conversions exist in the application, ho… Need 'UOM Conversion details' in Subject areaOTBI dashboard is being developed for CSRs to view the availability of items in different UOMs with their conversion factors UOM conversions exist in the application, ho…
- 
             Need 'PO First Approved Date' in the OTBI Subject AreaPlease guide me where we can find in report “PO first approved date”. Because the current reporting is completely wrong since it is always giving the “PO last approved d… Need 'PO First Approved Date' in the OTBI Subject AreaPlease guide me where we can find in report “PO first approved date”. Because the current reporting is completely wrong since it is always giving the “PO last approved d…
- 
             How can I give the subject area access in OTBI to a user from fusion ?I'm doing data validation in FDI , and found that I'm getting SOAP server error for HCM - Talent Acquisition related metrics. and I'm getting SRC value null for HCM - Wo… How can I give the subject area access in OTBI to a user from fusion ?I'm doing data validation in FDI , and found that I'm getting SOAP server error for HCM - Talent Acquisition related metrics. and I'm getting SRC value null for HCM - Wo…
- 
             Fixed Assets - Columns: "Net Book Value" vs "NBV Before Impairment"We are currently implementing Fixed Assets in Oracle Fusion ERP and would like assistance from FA SMEs as we have begun work on OTBI dashboards and reports: The 23B Data… Fixed Assets - Columns: "Net Book Value" vs "NBV Before Impairment"We are currently implementing Fixed Assets in Oracle Fusion ERP and would like assistance from FA SMEs as we have begun work on OTBI dashboards and reports: The 23B Data…
- 
             Filter with an OR conditionI have two fields: Field A and Field B I want to pull all records, which may have value 'SPLTAG' in either of the two columns. How do I create a combination filter acros… Filter with an OR conditionI have two fields: Field A and Field B I want to pull all records, which may have value 'SPLTAG' in either of the two columns. How do I create a combination filter acros…
- 
             Create custom app tile for OTBI DashboardWe created a dashboard that is used by Recruiters. They access this by going to Tools → My Reports → and navigating to the appropriate tab. I was wondering if it is poss… Create custom app tile for OTBI DashboardWe created a dashboard that is used by Recruiters. They access this by going to Tools → My Reports → and navigating to the appropriate tab. I was wondering if it is poss…
- 
             Schedule an OTBI agent to send the analysis using parametersHello, We have created an OTBI analysis, for which the parameters are as follows: --Year to Date; --Ledger ; Also, I created an agent to send daily by e-mail the report … Schedule an OTBI agent to send the analysis using parametersHello, We have created an OTBI analysis, for which the parameters are as follows: --Year to Date; --Ledger ; Also, I created an agent to send daily by e-mail the report …
- 
             Need 'PO First Approved Date' in the OTBI Subject AreaPlease guide me where we can find in report “PO first approved date”. Because the current reporting is completely wrong since it is always giving the “PO last approved d… Need 'PO First Approved Date' in the OTBI Subject AreaPlease guide me where we can find in report “PO first approved date”. Because the current reporting is completely wrong since it is always giving the “PO last approved d…
- 
             Sick absence duration sum issueHello, I'm trying to produce an analysis showing total days lost to sickness per quarter for each department. I'm working in the Workforce Management - Absence Real Time… Sick absence duration sum issueHello, I'm trying to produce an analysis showing total days lost to sickness per quarter for each department. I'm working in the Workforce Management - Absence Real Time…
- 
              
- 
             Is there a field in OTBI to tell if a Receipt was created in Redwood vs Classic page?Im looking for a field in OTBI that I can use to develop a report to identify if a Receipt was created in the new Redwood Expected Shipments Lines page vs the Classic Re… Is there a field in OTBI to tell if a Receipt was created in Redwood vs Classic page?Im looking for a field in OTBI that I can use to develop a report to identify if a Receipt was created in the new Redwood Expected Shipments Lines page vs the Classic Re…
- 
             Issue on exporting entire dashboardI’m currently experiencing an issue when trying to export the entire dashboard to Excel. The export function only allows a maximum of 500 records to be displayed and exp… Issue on exporting entire dashboardI’m currently experiencing an issue when trying to export the entire dashboard to Excel. The export function only allows a maximum of 500 records to be displayed and exp…
- 
             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… 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…
- 
             FDI People Leaders Dashboard issueIn the FDI People Leaders dashboards, on the Hires and Terminations pages, the graphs for Hiring Trend by Gender and Termination Trend by Gender, as well as the Hiring P… FDI People Leaders Dashboard issueIn the FDI People Leaders dashboards, on the Hires and Terminations pages, the graphs for Hiring Trend by Gender and Termination Trend by Gender, as well as the Hiring P…
- 
             Add KPIs and Negotiation Dashboard to Redwood Sourcing Landing PageSummary: Is it possible to add OTBI-based KPIs and visualizations to the Sourcing Landing Page in Redwood, specifically to build a negotiations dashboard (e.g., invited … Add KPIs and Negotiation Dashboard to Redwood Sourcing Landing PageSummary: Is it possible to add OTBI-based KPIs and visualizations to the Sourcing Landing Page in Redwood, specifically to build a negotiations dashboard (e.g., invited …
- 
             Time Card StatusHi everyone, I am trying to create a BIP report for Time Card Change History which includes both "Time Entry" and "Time Card Status". For Time Card Status, I am trying t… Time Card StatusHi everyone, I am trying to create a BIP report for Time Card Change History which includes both "Time Entry" and "Time Card Status". For Time Card Status, I am trying t…
- 
             report dates parameters not incrementedHi, I defined a Data Model, with DATE FROM/DATE TO as parameters, in the following way: p_date_from: {$SYSDATE() - 7$} p_date_to: {$SYSDATE()$} Then I created a report u… report dates parameters not incrementedHi, I defined a Data Model, with DATE FROM/DATE TO as parameters, in the following way: p_date_from: {$SYSDATE() - 7$} p_date_to: {$SYSDATE()$} Then I created a report u…