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
- 
             Benefits - Enrollment Real Time - Dependent Data Not Coming InWe have a basic report that is supposed to bring in Employee and Dependent data into a report and now the report is not reporting on Dependent Data anymore. Either none … Benefits - Enrollment Real Time - Dependent Data Not Coming InWe have a basic report that is supposed to bring in Employee and Dependent data into a report and now the report is not reporting on Dependent Data anymore. Either none …
- 
             How to make a table fixed in an RTF templateWhen printing checks, we try to leave a fixed value at the end of the sheet, although at the bottom you can increase or decrease the invoice lines. To do this, an RTF te… How to make a table fixed in an RTF templateWhen printing checks, we try to leave a fixed value at the end of the sheet, although at the bottom you can increase or decrease the invoice lines. To do this, an RTF te…
- 
             ttribute ItemTypeCode1 in ManageOrdersAM.oracle_apps_scm_fom_manageOrders_uiModel_applicationModule_while submitting sales order in oracle fusion, facing this issue ttribute ItemTypeCode1 in ManageOrdersAM.oracle_apps_scm_fom_manageOrders_uiModel_applicationModule_while submitting sales order in oracle fusion, facing this issue
- 
             Can we use BICC Connector to pull Audit Logs into an Object Storage or Stream?Can we use BICC Connector to pull Audit Logs into an Object Storage or Stream? Can we use BICC Connector to pull Audit Logs into an Object Storage or Stream?Can we use BICC Connector to pull Audit Logs into an Object Storage or Stream?
- 
             Usage statistics for document/report activities in Oracle FusionIs there a functionality within Oracle Fusion to monitor and display usage statistics regarding Report/Document activities that can be used by developers/administrators … Usage statistics for document/report activities in Oracle FusionIs there a functionality within Oracle Fusion to monitor and display usage statistics regarding Report/Document activities that can be used by developers/administrators …
- 
             Project Cost dashboard performance issue-Project costing-Actual cost real timeThe report includes the following key columns: Contract Number Project Number Document Total Period Cost The report itself runs fine and gives accurate cost details at t… Project Cost dashboard performance issue-Project costing-Actual cost real timeThe report includes the following key columns: Contract Number Project Number Document Total Period Cost The report itself runs fine and gives accurate cost details at t…
- 
             OTBI Analysis Project Costing Actual cost real time -How to get the person name or numberi have a requirement to include person name or Number or ID to my Project costing -Actual costing real time subject area , we want to monitor headcounts per expenditure … OTBI Analysis Project Costing Actual cost real time -How to get the person name or numberi have a requirement to include person name or Number or ID to my Project costing -Actual costing real time subject area , we want to monitor headcounts per expenditure …
- 
             How to Retrieve Supplier Name for Project-Linked Miscellaneous Inventory Issues Using Lot Numbers?We are currently using lot-controlled inventory in Oracle Fusion Cloud, where all inventory issues—including miscellaneous issues linked to projects—are processed using … How to Retrieve Supplier Name for Project-Linked Miscellaneous Inventory Issues Using Lot Numbers?We are currently using lot-controlled inventory in Oracle Fusion Cloud, where all inventory issues—including miscellaneous issues linked to projects—are processed using …
- 
             Looking for PO line quantity column in Purchasing Subject AreasHi, I am preparing an OTBI report for Purchase Order and looking for Line Quantity Column, i see Ordered Quantity column in subject area- Procurement - Purchasing Real T… Looking for PO line quantity column in Purchasing Subject AreasHi, I am preparing an OTBI report for Purchase Order and looking for Line Quantity Column, i see Ordered Quantity column in subject area- Procurement - Purchasing Real T…
- 
             How to combine Recognized Revenue and Order Line Quantity when invoice Line exist AdjustmentHi, Please refer below screenshot I using subject area ‘Costing – New COGS and Gross Margin Details Real Time’ to compose an OTBI report, and we found an issue, when inv… How to combine Recognized Revenue and Order Line Quantity when invoice Line exist AdjustmentHi, Please refer below screenshot I using subject area ‘Costing – New COGS and Gross Margin Details Real Time’ to compose an OTBI report, and we found an issue, when inv…
- 
             RTF Hyerlink appended with local pathWe are trying to add the additional fields at the level in the RTF template, existing hyerplink (which is at the header level) getting appended with local path . The hyp… RTF Hyerlink appended with local pathWe are trying to add the additional fields at the level in the RTF template, existing hyerplink (which is at the header level) getting appended with local path . The hyp…
- 
             Radar view for OTBISummary: Customize the radar view when creating OTBI Content (please ensure you mask any confidential information): Hello, we have created an OTBI analysis with Radar ty… Radar view for OTBISummary: Customize the radar view when creating OTBI Content (please ensure you mask any confidential information): Hello, we have created an OTBI analysis with Radar ty…
- 
             Consume external REST API in Fusion BIPIs there a solution to consume external REST API in BIP Report and use the response as data source? Consume external REST API in Fusion BIPIs there a solution to consume external REST API in BIP Report and use the response as data source?
- 
             Why a new role cannot run OTBI reports but can run BIP reports when permissions are the sameWe have created a new role in oracle HCM. The user will be using this role for reporting needs. They can use BIP reports with no issues. But OTBI is causing problems. Th… Why a new role cannot run OTBI reports but can run BIP reports when permissions are the sameWe have created a new role in oracle HCM. The user will be using this role for reporting needs. They can use BIP reports with no issues. But OTBI is causing problems. Th…
- 
             Oracle Fusion OTBI and Data/Role SyncHi Team, I am a Oracle Security Specialist and often have to play with data sync and validate in UI and in OBI layer reporting. When I do a HDL to Bulk terminate users I… Oracle Fusion OTBI and Data/Role SyncHi Team, I am a Oracle Security Specialist and often have to play with data sync and validate in UI and in OBI layer reporting. When I do a HDL to Bulk terminate users I…
- 
             OTBI Report for Current Invoice ApproverI am trying to build an OTBI report that shows invoices that are pending approval along with the name of the current approver. OTBI Report for Current Invoice ApproverI am trying to build an OTBI report that shows invoices that are pending approval along with the name of the current approver.
- 
             SQL query for retrieving information from Work Definitions TableWe are having issues identifying the relevant table for work definitions and their associated operations/resources. Can anyone provide a query (or give some direction) o… SQL query for retrieving information from Work Definitions TableWe are having issues identifying the relevant table for work definitions and their associated operations/resources. Can anyone provide a query (or give some direction) o…
- 
             How to join Oracle BI Analysis report and BIP data modelContent Hello Everyone, I'm trying to create a BIP data model which consists of core_hr data attributes retrieved via SQL and other attributes from Oracle BI Analysis(an… How to join Oracle BI Analysis report and BIP data modelContent Hello Everyone, I'm trying to create a BIP data model which consists of core_hr data attributes retrieved via SQL and other attributes from Oracle BI Analysis(an…
- 
             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…
- 
             how i can export all associated profiles related to each position in OTBI/BI reporthow i can export all associated profiles related to each position in OTBI/BI report how i can export all associated profiles related to each position in OTBI/BI reporthow i can export all associated profiles related to each position in OTBI/BI report