Popular Tags
- OTBI 1,428
- Reporting 1,383
- FDI 1,062
- Analysis and Data Visualization 976
- BI Publisher 840
- Analysis 673
- Oracle Fusion Analytics 577
- Administration 555
- OBIEE 429
- OAC 406
- Analytics 382
- BI Publisher Data Models 346
- Security 288
- Answers 264
- HCM 256
- Analyses 253
- BIP 247
- Developers 243
- Data Modelling and Datasets 223
- Data Connectivity 208
- ERP Analytics Content 205
- BI Publisher Report Templates 201
- Report Output 183
- Oracle Analytics Cloud 168
- Customizing Reports 156
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
-
Need help to pull Organization ID per Hierarchy LevelWe are looking to pull the Organization ID for each hierarchical level, specifically for Level 1, Level 2, and Level 3. Please see the attached screenshot for reference,… -
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…
-
Time Card StatusHi everyone, I am trying to create a BIP report for Time Card Change History which includes both "Time Entry" and "Time Card Status". For Time Card Status, I am trying t…
-
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…