Popular Tags
- OTBI 1,413
- Reporting 1,373
- FDI 999
- Analysis and Data Visualization 962
- BI Publisher 825
- Analysis 666
- Oracle Fusion Analytics 556
- Administration 554
- OBIEE 424
- OAC 360
- Analytics 359
- BI Publisher Data Models 338
- Security 277
- Answers 263
- Analyses 253
- HCM 243
- Developers 240
- BIP 236
- Data Modelling and Datasets 218
- Data Connectivity 206
- ERP Analytics Content 200
- BI Publisher Report Templates 189
- 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
-
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…
-
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
-
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 … -
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…
-
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… -
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…
-
Concatenated values for Depreciation Expense and Depreciation Reserve AccountHi, I am working on an OTBI report and using the Subject Area "Asset Balances Real Time". I am looking for Depreciation Expense and Depreciation Reserve Account(Concaten…
-
Delay in syncing data for OTBI real time usage subject area?I Have developed an OTBI report (Analysis) to get the Audit data like usage of OTBI reports in last 6 months using OTBI Real time usage subject Area. but to test that I …
-
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…
-
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…