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
- 
             Latest data changes are not reflecting in the OTBI report immediatelyHello All, We have an AOR drill-down OTBI report, but the latest changes to data are not reflecting immediately. For example, when we assign an AOR to an employee, it so… Latest data changes are not reflecting in the OTBI report immediatelyHello All, We have an AOR drill-down OTBI report, but the latest changes to data are not reflecting immediately. For example, when we assign an AOR to an employee, it so…
- 
             How to cancel schedule of OTBI Agent of users who scheduled under their personal folders?Few OTBI reports have been scheduled by users under their folders and now they are no longer a part of the organization but the reports still seem to be running with the… How to cancel schedule of OTBI Agent of users who scheduled under their personal folders?Few OTBI reports have been scheduled by users under their folders and now they are no longer a part of the organization but the reports still seem to be running with the…
- 
             How to report on Historical Organization Hierarchies?We have 6 historical versions of our organization tree, but when trying to report on the previous versions in reporting, only the latest organization hierarchy is showin… How to report on Historical Organization Hierarchies?We have 6 historical versions of our organization tree, but when trying to report on the previous versions in reporting, only the latest organization hierarchy is showin…
- 
             Are there alternative ways to format display when there are "no results"?I'm wanting to see if there is an elegant way to display elements where there are no results in the context of other data. For example, I've got a Projects dashboard I b… Are there alternative ways to format display when there are "no results"?I'm wanting to see if there is an elegant way to display elements where there are no results in the context of other data. For example, I've got a Projects dashboard I b…
- 
             access denied ("oracle.security.jps.JpsPermission" "AppSecurityContext.setApplicationID."Having this error when trying to access report i have tried adding roles to BI publisher but still persists access denied ("oracle.security.jps.JpsPermission" "AppSecurityContext.setApplicationID."Having this error when trying to access report i have tried adding roles to BI publisher but still persists
- 
             Counting number of rows up to a specified value by an idHello, I have a dataset with id, test date, test_type, test result. ID Test_Date Test_Type Test_Result 1 2024-03-21 A Fail 1 2024-04-21 A Fail 1 2024-04-30 A Pass 1 2025… Counting number of rows up to a specified value by an idHello, I have a dataset with id, test date, test_type, test result. ID Test_Date Test_Type Test_Result 1 2024-03-21 A Fail 1 2024-04-21 A Fail 1 2024-04-30 A Pass 1 2025…
- 
             How to ensure the relevant BU Data Access for OTBI reports?Hello, I assigned the Employee role to a user in order to give access to the reports in Reports and Analytics tab. However, when the user runs the report, all data from … How to ensure the relevant BU Data Access for OTBI reports?Hello, I assigned the Employee role to a user in order to give access to the reports in Reports and Analytics tab. However, when the user runs the report, all data from …
- 
             divide two row values using same column of OTBI analysisHi, Each of the two rows is derived from analysis of same subject area. The reason for this design is i cannot accommodate two different conditions in same analysis so I… divide two row values using same column of OTBI analysisHi, Each of the two rows is derived from analysis of same subject area. The reason for this design is i cannot accommodate two different conditions in same analysis so I…
- 
             OTBI Report based on AOR.Hi Team, There is a requirement to have the OTBI report output based on AOR. I have done the necessary setup and have verified from UI that the data is restricted based … OTBI Report based on AOR.Hi Team, There is a requirement to have the OTBI report output based on AOR. I have done the necessary setup and have verified from UI that the data is restricted based …
- 
             OTBI Unable to see a DFF in the Procurement Purchasing Agreement real timeOTBI Unable to see a DFF in the Procurement Purchasing Agreement real time. I have 4 DFF's and I am unable to see it. I ran the " Import Oracle Fusion Data Extensions fo… OTBI Unable to see a DFF in the Procurement Purchasing Agreement real timeOTBI Unable to see a DFF in the Procurement Purchasing Agreement real time. I have 4 DFF's and I am unable to see it. I ran the " Import Oracle Fusion Data Extensions fo…
- 
             Which table holds audit data or historic LC Expiration date under supplier master business classfi..Which table holds audit data or historic LC Expiration date under supplier master business classification as 'POZ_BUS_CLASSIFICATIONS' holds only one row which is curren… Which table holds audit data or historic LC Expiration date under supplier master business classfi..Which table holds audit data or historic LC Expiration date under supplier master business classification as 'POZ_BUS_CLASSIFICATIONS' holds only one row which is curren…
- 
             Send notification to line manager based on reportI have built a schedule based on a report however even though the report contains the data it is not bring this back in the email. This is the message in the email I rec… Send notification to line manager based on reportI have built a schedule based on a report however even though the report contains the data it is not bring this back in the email. This is the message in the email I rec…
- 
             Scheduled query not bring back and dataHi, I have created a report to send a notification when a certain trigger has been hit but it is not bring back the data, I have created the test data so know there data… Scheduled query not bring back and dataHi, I have created a report to send a notification when a certain trigger has been hit but it is not bring back the data, I have created the test data so know there data…
- 
             How to add an imagen in the report RTFI have a query to extract the image from the items, but I can't add it to a report because the image or the table field doesn't have the information in base64 (encoded).… How to add an imagen in the report RTFI have a query to extract the image from the items, but I can't add it to a report because the image or the table field doesn't have the information in base64 (encoded).…
- 
             Overtime status is not showing data in workrelation subject areaHi Team, We had defined overtime status at job level. like below. but the information is not showing workrelationship subject area. Request you to help on to fix the iss… Overtime status is not showing data in workrelation subject areaHi Team, We had defined overtime status at job level. like below. but the information is not showing workrelationship subject area. Request you to help on to fix the iss…
- 
             How to add parameterized OTBI report on InfoletSummary: Hi Team, We have created parameterized OTBI Report and a dashboard with prompt. However when we add them to infolet , but infolet is not asking for parameter an… How to add parameterized OTBI report on InfoletSummary: Hi Team, We have created parameterized OTBI Report and a dashboard with prompt. However when we add them to infolet , but infolet is not asking for parameter an…
- 
              
- 
             Aggregation by Period (ex. Month) CalculationHello, Working within Netsuite Analytics Warehouse workbook using the data visualization table. Goal: to generate the total feet shipped per month. Table 1 (by Item Code… Aggregation by Period (ex. Month) CalculationHello, Working within Netsuite Analytics Warehouse workbook using the data visualization table. Goal: to generate the total feet shipped per month. Table 1 (by Item Code…
- 
             No data elements displayed in the subject area created by manual queryHi community! I have created a manual query that I was able to run and preview the data as shown but cannot see any data displayed while creating a workbook. Could someo… No data elements displayed in the subject area created by manual queryHi community! I have created a manual query that I was able to run and preview the data as shown but cannot see any data displayed while creating a workbook. Could someo…
- 
             How to create a condition based column in Column selector in OTBI Report?We are creating an OTBI report in which we want to use column selector . Inside that column selector, we are trying to add the condition based column but we are unable t… How to create a condition based column in Column selector in OTBI Report?We are creating an OTBI report in which we want to use column selector . Inside that column selector, we are trying to add the condition based column but we are unable t…