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
-
How to get sickness plan entitlement values in OTBI?I'm trying to build an analysis which gives me sickness plan entitlement values using Workforce Management - Absence Real Time I can get it to show all the fields/data I… -
Issue with Credit Memo Output FormatHello, We are facing an issue with the output format for credit memos. The requirement is to display both the invoice and adjustment line items in two separate rows. How…
-
Subject Area: Costing - New COGS and Gross Margin Details Real Time not giving any resultSummary: Analysis created using "Costing - New COGS and Gross Margin Details Real Time" subject area is not giving any output Content (required): I tried to create a sim…
-
Document Type I9 not pulling on OTBI reportsDocument Type I9 not pulling on OTBI reports while creating reports from subject area Document of Record Real Time even though we can see it on UI query we are using SET…
-
Issue with Date Format in OTBI Report Export to ExcelHello, I am encountering an issue with an OTBI report. The 'Invoice Creation Date' column is formatted to display only the date (without the time) in the OTBI report. Ho…
-
Job change - OTBI reportHello, I would like to create an OTBI report to highlight the date of an employee's business title change. I don't want to use a specific reason code (ex promotion) beca…
-
Dashboard Prompt Not Updating Analysis TableI'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 in my anal…
-
OTBI Report Too Slow / Not Generating ResultsSummary: Have created a report to pull all roles for all users (Audit purposes), and admittedly there is an excessive amount of data to pull. That being said, when runni…
-
How to Show Two Columns As OneI have a report in OTBI that uses the Workforce Management - Processed Time Cards Real Time subject area. Two fields are included in the query, Absence Type and Hours Ty…
-
how can i extract "The date that the invoice was sent to the client"how can i extract The date that the invoice was sent to the client The amount of days between when the final approver approved an invoice to when the invoice was sent to…
-
Can we create Inventory transaction costs report?Can we create Inventory transaction costs report using two subject areas Inventory Transactions real time & Costing standard cost time? Item Name Transaction Date Invent…
-
sql query to get recorded absences on their time cards in oracle fusion cloudHi All, SQL query to get recorded absences on their time cards in oracle fusion cloud hcm
-
How to translate the data in a BIP Report to another language?We have created a BIP Report where English(en-US) is the default language. We want the data as well of the BIP Report to be translated to another language(Specifically S… -
How to Access OTBI report using Groovy within Oracle FusionHow to Access OTBI report using Groovy within Oracle Fusion
-
Need translated names in the otbi report.we have developed otbi report for Workforce Structure for one of the UAE client, in that customer requires translated names to be reflected along with the English names.…
-
Merging 2 PVOs for 1 BICC ExtractHello Team, Can we merge 2 PVO to create a single extract for BICC. Currenly we tried and it is giving 2 extracts. Any guidance would be helpful. Regards,
-
Projects - Performance Reporting Real TimeHere In above report I am trying to print class category column values as a separate column like GP Budget,GP Plan Year and GP Project Category. also want to print the v… -
How to navigate to fusion Sales Order page from otbi analysis aggregated fieldWe are trying to develop an OTBI report showing past due orders as a bar graph with range of days and count of orders in that range. Requirement is to click on 'count of…
-
Can i create custom heading in OTBI report?This is an example of what i want to achieve the first image is created in excel, the second is in OTBI can we have Custom Header like in excel. Regards, Omran
-
OTBI Expression not workingHello, We're creating an OTBI report that fetch employees time card details. Please see below requirements If employee did not work on a holiday, it should return 'PH' I…