Popular Tags
- OTBI 1,401
- Reporting 1,365
- FDI 961
- Analysis and Data Visualization 953
- BI Publisher 816
- Analysis 663
- Administration 553
- Oracle Fusion Analytics 543
- OBIEE 421
- Analytics 342
- OAC 336
- BI Publisher Data Models 335
- Security 271
- Answers 261
- Analyses 253
- Developers 240
- HCM 237
- BIP 232
- Data Modelling and Datasets 218
- Data Connectivity 205
- ERP Analytics Content 199
- BI Publisher Report Templates 184
- Report Output 180
- Agents 151
- Customizing Reports 146
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
-
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… -
How to migrate TrueType Font from One Instance to another in the Oracle Fusion CloudWe have used the TrueType fonts 3OF9_NEW.TTF and MICR.ttf in the UAT instance. The check format has been validated and approved by the bank, so we would like to migrate …
-
Why is CASE function always returning ELSE statement?Within our Case function we are comparing a number of months with "Timestampdiff" function with a descriptive flexfield that has numbers. We added the "Timestampdiff" fu…
-
Oracle BICC | Detailed documentation BIVOsSummary: Hi, We are looking for documentation on the individual BIVOs. The lineage table is known (https://community.oracle.com/customerconnect/discussion/47653/r13-x-hc…
-
Oracle HCM - inactive organisations in promptsHello, I have some organisations (ex : services or legal enity) that are inactive in the system (EX : OLD SERVICE). It doesn't affect any reports but it still appears in…
-
Payroll balance analyses timing out for relatively small data setsI recently noticed that my Payroll Balance OTBI analyses have started to time out. I'm aware that the Payroll Balances tables have few indices and are subject to perform…
-
hierarchiesis possibile to create otbi subject area "General Ledger - Transactional Balances Real Time with hierarchies?
-
How do i perform a lookup within a OTBI analysis reportSummary: I need to perform lookup through Grade Name field to map Grade names for Direct managers adjacent to Direct Manager field in the same report (where I have Perso…
-
How to see if the employee has executed custom BI reports that are linked to springboardSummary: Hi! There is a requirement for me to enable checking (like an analysis) if employees have executed custom BI reports that are linked to springboard. What can I …
-
Getting error while connecting with Oracle BI ConnectionSummary: Getting error while connecting with Oracle BI Connection Content (please ensure you mask any confidential information): I login with user created specifically f…
-
Can we add Report and Analytics area same as payables under expenses moduleSummary: Is there a way to add the report and analytics option to access the report directly from the expenses area same as payables. Please find attached screenshot of …
-
Expense cost center, balancing segment, account, natural account is not visible in OTBISummary: While I create an OTBI for an Expense Report I saw the field Cost Center, Balancing Segments, Natural Account, Company, Product, Project and Account when I clic…
-
How to limit values prompt dashboard values when using choice list valuesHello, In a dashboard Prompt we are using column prompts we want to limit the values based on the business unit access for users. The OTBI Dashboard is showing only the …
-
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…
-
OTBI is NOT pulling Pending Workers Licenses/Certifications InformationHello, Need some assistance here! We are trying to create a report that will pull all licenses/certifications that have been updated in the last 7 days specifically for …
-
Budget date in budgetary control balances screen vary in "budget_date" column in XCC_TR_LINES tableSummary: We wanted to display the budget date column in custom report where we have found discrepancies in fusion screen and "BUDGET_DATE" column in XCC_TR_LINES table, …
-
How do you keep Row Numbers cascading?When adding a Row Number Column in OTBI using RCOUNT(1), how do you prevent the row numbers from changing order when you sort the report by a different column? We want t…
-
How to Call ff_exec.run_formula in Oracle BI Publisher ReportSummary: Hello Oracle Experts, I am working on Oracle Fusion Cloud BI Publisher (BIP) report and need to call the ff_exec.run_formula function to retrieve Fast Formula r…
-
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…