Popular Tags
- OTBI 1,442
- Reporting 1,390
- FDI 1,103
- Analysis and Data Visualization 984
- BI Publisher 850
- Analysis 679
- Oracle Fusion Analytics 583
- Administration 555
- OAC 444
- OBIEE 433
- Analytics 401
- 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 193
- 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
- 
             Trying to create a new custom role to allow users to see a Supplier Master Report in OTBIUsers are getting the following error when they try to run the Supplier master report. We don't want to give certain users the PO Supplier role (which currently allows u… Trying to create a new custom role to allow users to see a Supplier Master Report in OTBIUsers are getting the following error when they try to run the Supplier master report. We don't want to give certain users the PO Supplier role (which currently allows u…
- 
             Issue with developing analyses for requisition to purchase order cycle timeSummary: We are trying to create a custom analyses as per requirement of customer to analyze the purchase requisition to purchase order cycle time but not able to identi… Issue with developing analyses for requisition to purchase order cycle timeSummary: We are trying to create a custom analyses as per requirement of customer to analyze the purchase requisition to purchase order cycle time but not able to identi…
- 
             Group By Supplier in OTBISummary: Hi! How can i "group by" the amounts of paid invoices by supplier? I need the "Gross Amount" to be summed to one cell of payment amount, or just present the pay… Group By Supplier in OTBISummary: Hi! How can i "group by" the amounts of paid invoices by supplier? I need the "Gross Amount" to be summed to one cell of payment amount, or just present the pay…
- 
             Can't resize columns in BIP Microsoft word add-inIn the BI Publisher add in for Microsoft word I'm unable to drag or manually enter width to shrink a column. All I can do is enlarge the column and when I do that it ove… Can't resize columns in BIP Microsoft word add-inIn the BI Publisher add in for Microsoft word I'm unable to drag or manually enter width to shrink a column. All I can do is enlarge the column and when I do that it ove…
- 
             How can I build a "read only" role for Payroll run results? I also need one for Time & Labor...We have users in our organization that need access to the results of the payroll run (earnings, deductions and taxes), but are not allowed to do the payroll related proc… How can I build a "read only" role for Payroll run results? I also need one for Time & Labor...We have users in our organization that need access to the results of the payroll run (earnings, deductions and taxes), but are not allowed to do the payroll related proc…
- 
             OTBI Pivot Table hide null valuesHello! I would like to hide columns that have null values in a OTBI Pivot Table, for example: These are columns made of incentive compensation measure results for a sing… OTBI Pivot Table hide null valuesHello! I would like to hide columns that have null values in a OTBI Pivot Table, for example: These are columns made of incentive compensation measure results for a sing…
- 
             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… 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…
- 
             Special characters not to be used for OTBIPlease suggest the special characters that are not to be used so that data will not be synced to view data in OTBI. Special characters not to be used for OTBIPlease suggest the special characters that are not to be used so that data will not be synced to view data in OTBI.
- 
             ZMM Notes columns - SOURCE_OBJECT_CODE, SOURCE_OBJECT_UID in Receivables - Transactions Real Time?Summary: Is anyone familiar with the subject area - Receivables - Transactions Real Time? I am looking for the equivalent of SOURCE_OBJECT_CODE, SOURCE_OBJECT_UID column… ZMM Notes columns - SOURCE_OBJECT_CODE, SOURCE_OBJECT_UID in Receivables - Transactions Real Time?Summary: Is anyone familiar with the subject area - Receivables - Transactions Real Time? I am looking for the equivalent of SOURCE_OBJECT_CODE, SOURCE_OBJECT_UID column…
- 
             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… 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…
- 
             How to identify missing Associations in a Taxable Benefits Calculation CardHi, We have started Payrolling Benefits this tax year and have identified an issue where a Calculation Component, along with the Calculation Component Details have been … How to identify missing Associations in a Taxable Benefits Calculation CardHi, We have started Payrolling Benefits this tax year and have identified an issue where a Calculation Component, along with the Calculation Component Details have been …
- 
             API to run custom BI Publisher reportSummary: I need to call report via API Content (please ensure you mask any confidential information): I'm performing this API call: https://xxxxx-test.fa.ocs.oraclecloud… API to run custom BI Publisher reportSummary: I need to call report via API Content (please ensure you mask any confidential information): I'm performing this API call: https://xxxxx-test.fa.ocs.oraclecloud…
- 
             Knowledge Management Article Views- Unable to view the data for Knowledge Article Status.Hello, I attempted to run an OTBI analysis using the 'Knowledge Management - Article Summary Historical' Subject Area to retrieve data on "# of Article Views," "# of Art… Knowledge Management Article Views- Unable to view the data for Knowledge Article Status.Hello, I attempted to run an OTBI analysis using the 'Knowledge Management - Article Summary Historical' Subject Area to retrieve data on "# of Article Views," "# of Art…
- 
             How to enable email bursting for Print Commercial Document Report?Hi, I was trying out the bursting method for print commercial Document process but it seems to be failing even on the slightest changes to the bursting query. I wanted t… How to enable email bursting for Print Commercial Document Report?Hi, I was trying out the bursting method for print commercial Document process but it seems to be failing even on the slightest changes to the bursting query. I wanted t…
- 
             Require navigation path and calculation in OTBI Subject area 'costing - work Order Costs Real Time'In OTBI Subject area 'costing - work Order Costs Real Time', we require the application navigation path and calculation logic for the following fields: 1) Work Order Cos… Require navigation path and calculation in OTBI Subject area 'costing - work Order Costs Real Time'In OTBI Subject area 'costing - work Order Costs Real Time', we require the application navigation path and calculation logic for the following fields: 1) Work Order Cos…
- 
             How to get the manager assigned to the department to show in a OTBI reportHi team!I need to add this manager to my data model, so please can you help me with what tables or code I need to add in my SQL? In my report, the column will be called … How to get the manager assigned to the department to show in a OTBI reportHi team!I need to add this manager to my data model, so please can you help me with what tables or code I need to add in my SQL? In my report, the column will be called …
- 
             How to access the link between OTBI column names to fields in the Oracle data tablesI'm designing reporting using OTBI, however there may be a requirement to query the tables directly using BIP. I would like to understand, where I am selecting columns f… How to access the link between OTBI column names to fields in the Oracle data tablesI'm designing reporting using OTBI, however there may be a requirement to query the tables directly using BIP. I would like to understand, where I am selecting columns f…
- 
             Unable to Add More Than 5 Columns in OTBI Pivot TableHi everyone, I’m creating a report in Oracle Fusion OTBI based on a data model, and I want the report to be displayed as a pivot table. However, when I try to select the… Unable to Add More Than 5 Columns in OTBI Pivot TableHi everyone, I’m creating a report in Oracle Fusion OTBI based on a data model, and I want the report to be displayed as a pivot table. However, when I try to select the…
- 
             Employee Final Feedback not returning value in OTBIWe Are using the subject area Workforce Performance - Performance Rating Real time and we want to get the below columns Digital Signature Employee Final Feedback We are … Employee Final Feedback not returning value in OTBIWe Are using the subject area Workforce Performance - Performance Rating Real time and we want to get the below columns Digital Signature Employee Final Feedback We are …
- 
             BICC extract failing for HcmTopModelAnalyticsGlobalAM.OrganizationAM.PerDeptTreeStructureBICVOSummary: We are getting error while extracting data from below data store. the BICC job runs for phenomenally long time and then errors out. This is happening only in on… BICC extract failing for HcmTopModelAnalyticsGlobalAM.OrganizationAM.PerDeptTreeStructureBICVOSummary: We are getting error while extracting data from below data store. the BICC job runs for phenomenally long time and then errors out. This is happening only in on…