Popular Tags
- OTBI 1,432
- Reporting 1,386
- FDI 1,087
- Analysis and Data Visualization 981
- BI Publisher 845
- Analysis 676
- Oracle Fusion Analytics 579
- Administration 555
- OBIEE 432
- OAC 426
- Analytics 395
- BI Publisher Data Models 350
- Security 291
- Answers 264
- HCM 257
- Analyses 254
- BIP 253
- Developers 244
- Data Modelling and Datasets 226
- Data Connectivity 211
- ERP Analytics Content 208
- BI Publisher Report Templates 204
- Report Output 184
- Oracle Analytics Cloud 177
- Customizing Reports 159
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
-
Is there a way users can save custom parameter selections on BI Publisher reports?Summary Users often run BI Publisher reports for the same parameter, wondering if users can save that parameter selection customization? Content Several users in my orga… -
Need to Add more Information from Seeded Data ModelSummary We've successfully customized an AR Invoice Print Layout, but we need more information that the Seeded Data Model Does not Provide Content Hi, we're in the middl…
-
(Total After) In pivot table Customize the Format labelI want to customize the auto total running in the pivot table to YTD Budget / YTD Expenditure / YTD Variance …. Does anyone knows how to make it Regards.
-
Global DFF not showing in Receivables - Transactions Real TimeI have created a Global DFF against flexfield RA_CUSTOMER_TRX. The BI Enabled checkbox is ticked. I have populated transactions with data in the flexfield and have run t…
-
Custom column to show salaries & compensationsHi experts, I'm trying to get an analysis to show the salaries and compensations of employees from SA "Payroll - Element Entries Real Time". My question is how can I sho…
-
Table to retrieve records of Work definitions from Audit reports in Oracle Cloud Fusion ERP 24DHi Team, I am seeking a database table or an SQL query that can retrieve detailed 'Audit Report' information specifically related to Work Definitions. This includes trac…
-
"Listing of question responses for qualification area" for a flagged internal survey not show result"Listing of question responses for qualification area" for a flagged internal survey qualification area is not showing results. However, when checking another qualificat…
-
How to update Data Time Zone offset in the Data Format tab of Column PropertiesSummary: OTBI report using Posting Date can be displayed in Sydney timezone but when it is used in a calculation in Edit Column Formula, it reverts back to UTC timezone.…
-
OTBI Usage Real time subject is not displaying the details of all OTBI reports/Dashboards usedHi, There is a requirement to built a dashboard to monitoring the OTBI Reports usage. I'm using the 'OTBI Usage Real Time' subject area for that. I need to capture usage…
-
How to group by based on 2 different values in 2 different subject areasHi, I need to create a formula from data fetching from below 2 subject areas. Workforce Management - Worker Assignment Real Time Workforce Management - Person Real Time …
-
How can i do Join in this two suject areas Human Capital Mgmt – Transaction X Document of RecordsWe need the report to documents of records and datas about approvals in Console Transaction. We are using this subjects areas: Human Capital Management – Transaction Adm…
-
Is it possible to use multiple letters in the 'begins with' filterSummary: We have some OTBI reports that we use an agent to schedule and they have gone over 25k rows so now they are not including the full data set (currently 44k rows)…
-
404 not found - Deeplink IssueHello everyone, I need your assistance. I'm working on OTBI deeplink and defined this deepline by using the following code. After defining this deeplink it's through me …
-
-
Which Oracle Fusion Cloud GL tables do I join to get YTD nominal balances?Trying to build an opex report but only getting the current period values not year to date. Do I have to add multiple rows of sql into the data model to add all the peri…
-
Need to Use two subject areas together; Procurement and PayablesHello All, I hope all is fine with you. I have an analysis using the subject area "Procurement - Procure To Pay Real Time". Business wants a field to be added "Invoice R…
-
BIP: Procedure Call DM Error - PLS-00306: wrong number or types of arguments in call to CAST_TO_RAWAs elaborated in the article we are in the process of developing a BIP report identified as a Procedure Call. An input parameter of type String has been included in the …
-
Initiated Onboarding Journey Numbers for 2023 DecreasingI downloaded an onboarding template that calculates the number of Initiated task's and incompletes vs. completes for 2023 and 2024. For some reason the initiated task nu…
-
Is there any function like data model in OTBI Analysis and Interactive Reporting?Hello, I am working on training users in our organization to utilize the analysis and dashboard features in OTBI. However, I have encountered a challenge: filters and me…
-
Accrual Report / "Time.Month" Formula / report formatingI'm building an OTBI report to based on Accrual Real time subject area, with the goal of displaying accrual balances. To have a report that makes sense I used Pivot Tabl…