Popular Tags
- OTBI 1,413
- Reporting 1,369
- FDI 995
- Analysis and Data Visualization 957
- BI Publisher 824
- Analysis 664
- Oracle Fusion Analytics 555
- Administration 553
- OBIEE 422
- Analytics 353
- OAC 350
- BI Publisher Data Models 337
- Security 274
- Answers 262
- Analyses 253
- Developers 240
- HCM 240
- BIP 235
- Data Modelling and Datasets 218
- Data Connectivity 206
- ERP Analytics Content 199
- BI Publisher Report Templates 188
- Report Output 181
- Agents 151
- Customizing Reports 150
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
-
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… -
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 …
-
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?
-
OTBI - Benefits Enrollment Realtime - Unable to pull the dependent data for a benefit planI am trying to create a OTBI report, which includes person number, benefit plan and covered dependents for the plan. Seeing blank data for the dependent information colu…
-
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…
-
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?
-
Calculated column totals incorrecti am working on Margin analysis for the group of companies , in that i have calculated revenue column , calculated margin and Percentage of margin , individually margin … -
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…
-
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…
-
Query to identify Work Orders WHERE Work Centre IS NULLIs it possible to create an analysis in OTBI to retrieve work orders that are not associated to any work centre? Our organisation has multiple departments (work centres)…
-
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…
-
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 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 …
-
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 can I get both account-contact and orphan contact in OTBI Analysis?Hi, Is there a way for me to get all contacts that are associated in an account and contacts that don't have an account in OTBI analysis? I am using subject areas below …