Popular Tags
- OTBI 1,455
- Reporting 1,397
- FDI 1,144
- Analysis and Data Visualization 988
- BI Publisher 865
- Analysis 684
- Oracle Fusion Analytics 596
- Administration 556
- OAC 479
- OBIEE 434
- Analytics 409
- BI Publisher Data Models 359
- Security 296
- HCM 269
- BIP 265
- Answers 265
- Analyses 255
- Developers 246
- Data Modelling and Datasets 229
- Oracle Analytics Cloud 218
- ERP Analytics Content 215
- Data Connectivity 211
- BI Publisher Report Templates 205
- Fusion Data Intelligence 195
- 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
-
Seeded Report to track User's last login in Oracle Fusion 24CHi Team, Is there any Seeded Report to track User's last login in Oracle Fusion 24C? Appreciate your responses. -
-
Issue while creating Data Model with HTTP POST Method in OTBIWhen attempting to run a data model in Oracle Transactional Business Intelligence (OTBI) that utilizes an HTTP dataset, an error occurs indicating that no response is re…
-
In OTBI How to set TIMEZONE using Data format setting properties?When we change the column properties in the Data Format tab regarding the TIMEZONE, it always reverts to the default setting. We cannot set the timezone as required. The…
-
Migrating an OTBI Dashboard to another instances gives errorI have an OTBI dashboard that is working in an instance. However when I migarte to another instance I get lot of SQL errorrs. Some ofthe errors are Code: 43113. [nQSErro…
-
HCM Extract failing with error "user: fusion_apps_hcm_ess_appid, permission: 2240"HCM Extract failing with error, please let me know how to resolve this issue: ================ BIPJobExecutable Execution failed with Client received SOAP Fault from ser…
-
Performance when extracting journal entriesI am having trouble with poor performance when extracting GL journal entries. The number of journal entries is about 5 million per month and it takes a long time to outp…
-
Report UsageI've been tasked with establishing a report catalog for my company that shows reports used by the company and organized by functional area. I first need to identify repo…
-
We need to insert audit actions in role reports according to cons sec. Wich table is appropriate?This is SQL code --**FUNCIONARIOS ATIVOS PARA A------------------------------------ SELECT DISTINCT PU.USERNAME AS "USUARIO" ,PPNF.FULL_NAME AS "NOME COMPLETO" --,ROLL.E…
-
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 …