Popular Tags
- OTBI 1,448
- Reporting 1,394
- FDI 1,123
- Analysis and Data Visualization 988
- BI Publisher 856
- Analysis 682
- Oracle Fusion Analytics 591
- Administration 555
- OAC 454
- OBIEE 433
- Analytics 403
- BI Publisher Data Models 356
- Security 293
- HCM 268
- BIP 264
- Answers 264
- Analyses 255
- Developers 246
- Data Modelling and Datasets 229
- Data Connectivity 210
- ERP Analytics Content 210
- BI Publisher Report Templates 204
- Oracle Analytics Cloud 197
- Fusion Data Intelligence 187
- Report Output 184
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
-
-
What is the OTBI Subject Area for State Wise Minimum Wage?Hi Team - Can anyone please let me know the OTBI subject area for State Wise Minimum Wage. The DB tables for the same are PAY_VALUE_DEFINITIONS_F and PAY_RANGE_ITEMS_F. …
-
Cross Subject Area join between Checklists and Helpdesk Request Subject AreasThere are Checklists created for certain Helpdesk Service requests. We need the data from both checklist and helpdesk on an OTBI Analysis cum Dashboard. Is it possible? …
-
Performer of the Action Plan [Talent management] information in BI publisher tablesI'm looking for this information in the bi Publisher tables: I looked through its tables: HRT_TASK_USERS, HRT_TASKS, HRT_TASK_OBJ_RELATIONS, but I didn't find it, do you…
-
My approved AP invoices OTBI AnalysisHow do I default in an OTBI Analysis invoice approver to be the User running the report? Or at least have in the Approver drop down list a single available value: my nam…
-
MAX EMAIL ADDRESS in one rowHow to display in one row the Work email (if exists) or home email if the work email is null? this function does not work MAX(CASE WHEN "Person Email Addresses"."Email T…
-
Filtering OTBI report off of the current system date?I am building a report that pulls counts of total Development goals from "Workforce Career Development - Development Goal Overview Real Time." Looking to filter the popu…
-
Migrated 3 custom AR reports, 1 returning an error (All has DFFs)I have migrated 3 AR OTBI reports from one instance to another and earlier I was not able to find those DFFs in OTBI though it was configured but post running the progra…
-
Disable More > Export/Print of an OTBI ReportClient requested if there's a way to disable the option to export/print the OTBI Analysis from the Catalog's view. They only want to keep the option to open and run the …
-
Is it possible get the query for oracle.apps.financials.payables.shared.publicView.ReportsPayeePVOHi, I would thank for any help to know how to get the query below ESS job LIST OF VALUES (not by hand, or googling). Examples: or oracle.apps.financials.payables.shared.…
-
Find Performer of the action plan on bi Publisher tablesI'm looking for this information in the bi Publisher tables: I looked through its tables: HRT_TASK_USERS, HRT_TASKS, HRT_TASK_OBJ_RELATIONS, but I didn't find it, do you…
-
How to return only the max ID grouped by selected column (SQL)?I am working on an OTBI report that uses Advanced SQL to create the analysis. The reason for using this method is specific to the type of report I am working to build, w… -
Workers with Active ProfilesHi, We can see a column Count of Profiles in Workforce Profiles – Person Profile Real Time having values 1 and 0. What exactly oracle is considering for giving 0 and 1 f…
-
OTBI Reporting for Personal Corporate Card TransactionsI need to build an OTBI report that shows all corporate card transactions that have been identified as "Classify as Personal". How can I do this?
-
Is it possible to show the "job" of the manager in the "Assignment Manager (Unsecured)" Dimension?I am creating a report to look at if employees who are direct or indirect reports for a manager are in the same function area. For example, if a top level manager is HR,… -
We are not able to find the field 'Default Expense Account' which is available in Assignment DetailsWe are not able to find the field 'Default Expense Account' which is available in Assignment Details. we have tried PVO 'HcmTopModelAnalyticsGlobalAM.AssignmentAM.Assign…
-
BIP Report with Custom FontHi can some please share steps to implement a BIP Docx report using custom fonts. Customer uses a custom font (Lusail) and want to create a report with Lusail Font.
-
Scheduled OTBI Reports Missing RecordsWe have a couple of OTBI Scheduled jobs that run monthly. We're not sure why, but when two of the scheduled agents run they are missing records. Example: One of the sche…
-
Project Number for Payables Invoices in JournalsGood Day, Where can I pull the correct project number field for payables sources? We use 3 subject areas for our report where both Journals Real Time are mainly used: - …
-
Deep Links (23B) the complete overview (all of them)We all know that you can create Deep Links from your OTBI / BI Publisher (incl notifications), otherwise check here Creating Analyses and Dashboards in Oracle Transactio…