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
-
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… -
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 …
-
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 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…
-
Salary Basis JoinI am building a OTBI report that requires the 'Benefits - Enrollment Real Time' and the 'Compensation - Salary Details Real Time' subject areas. I need to include 'Salar…
-
How we de output Header on CSV even when there is no data with SOAP API?Hello, We have a report that we schedule through SOAP API payload, and the requirement is to have the header on the CSV output even when there is no data. Currently, on …
-
OTBI - Analysis Dashboard - Payables Invoices security context by BUHello, we are creating a report using OTBI for payables we have a question related the security access. Our customer want to query invoices depends of user, if the user …
-
what standard reports available which print Fixed Asset DFF AttributesWe would like to know what oracle standard reports available which display Fixed asset DFF attributes especially for Asset category and transaction DFF details. we have …
-
Database Resource Condition session variableSummary: Hi. We are trying to create new Database Resource Conditions to give visibility to users of specific data, right now we use the following variable: HRC_SESSION_…
-
OTBI: How to categorize Front Loaded Accrual Balance and get the employee HeadcountI have a requirement to get Headcount of the employees based on Annual Leave Accrual Balance where it should be categorized like 0-5 and 6-10 and 11-15 and 16-20 and >20…
-
How do you add department name to the new Redwood ChangeSalaryReport RTF template?With the new 24D redwood update, the Change Assignment, Change Position, etc. transaction rtf has the department list in the notification. However, for the Change Salary…
-
Can we auto populate values in Element entries Input Values?Summary: Hi Team, We have a requirement wherein users want to auto populate element entry Input values on the basis of selection made in another Input value. For e.g., F…
-
How can I dynamically set default values for menu parameters in BIP?Hi, How can I dynamically set default values for menu parameters in BIP? Expected behavior: Create a list of values for the menu parameters. 2024-11 2024-12 2025-01 …
-
How to send analysis results by email when analysis is included in a dashboardWhen you open an OTBI analysis based on subject area, email feature is available at the of the results page. If you include the same analysis in a simple dashboard, emai… -
How to create a hierarchical org chart visual from BIP Report?We have a DFF on Departments called Dept Level - represented in the yellow node. There are cases where some level is missing, e.g. CCD has a L5 dept TTT underneath, and …
-
Which field holds data for GL Transfer Date in "Payables Invoices - Transactions Real Time Subject AWhich field holds data for GL Transfer Date in "Payables Invoices - Transactions Real Time Subject Area" Business wants to see GL Transfer Date in OTBI report which extr…
-
Dashboard Prompt Not Updating Analysis TableSummary: I'm having an issue with my dashboard setup. I have a dashboard that includes a prompt and an analysis. However, when I select a value on my prompt, the table i…