Popular Tags
- OTBI 1,429
- 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 408
- Analytics 382
- BI Publisher Data Models 346
- Security 288
- Answers 264
- HCM 256
- Analyses 253
- BIP 248
- 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 169
- 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
-
Filtering report data based on the time on or before the current date at either noon or midnightI have a small summary report of a few columns to make sure that the PVO data we extract for the SubledgerJournalDistributionExtract PVO matches up to what is in oracle.… -
Absence Plans in OTBIHi, We are creating a custom dashboard for Absence Management. Has anyone worked on the Adjustments in the absence dashboards or reporting. Does anyone know the name of … -
How to restirct users to modify reports in Shared/Custom folder?We need a solution to restrict users to modify reports in Shared/Custom folder, but so far we didn find any solution and Oracle support asked us to raise a question in c…
-
Query to send quartely check in email notificationHello, I am developing a query to send Goals and Performance check in notifications via email using eligibility table. Can you please provide the tables that needs to be…
-
How to modify the subject line for emails published from Oracle BI PublisherWhen the report is published from Oracle BI Publisher to our email, the subject line contains "Oracle BI Publisher Notification: [XXXX Extract]: Job was completed succes…
-
How to create multilevel pie chart / bar chart in OTBI with single anlaysisI am creating OTBI report as per business requirement where I need to represent the data in multilevel Pie chart. We tried in Graph (Pie chart) page in OTBI but we could…
-
How to create Multi Level Pie chart or Bar chart in single analysis output in OTBIWe are creating OTBI report as per business requirement where we need to represent the data in multilevel Pie chart. We tried in Graph (Pie chart) page in OTBI but we co…
-
Ethnicity causing Workforce Trend SA to produce inaccurate headcountWhen adding ethnicity to the Workforce Trend SA it causes the Period Start and End headcount to double/triple for those that have selected two or more races. I have atta…
-
OTM Mobile - Automated Real-Time Geolocation Capture for Driver TrackingHi Everyone, I hope you are doing well. Do anyone know if the current OTM Mobile or some Oracle's software solution can automatically capture and transmit real-time geol…
-
Fusion BI Catalog Folder Management Best PracticesSummary A white paper on Fusion BI Catalog Folder Management Best Practice Content This white paper provides the best practices for working with BI catalog folders, and …
-
EVALUATE function with REGEXP_SUBSTR dbfunction not working as expected within OTBI reportingHi, We need to use REGEXP_SUBSTR function to get 6th segment value from Depreciation Expense Concatenated Segments. For example, we have a concatenated segment value of …
-
How to create an OBTI with Requisition charge account by PRHi, I would like to simply create an OTBI with the concatenated charge account segments of my purchase requisition, by line number. This is where is the information : I … -
OTBI data model thought (BI Publisher) web service errorWe are trying to fetch the data displayed in an OTBI data model through an web service for further integrations. We use BI Publisher web services -> ReportServicesSoapBi…
-
Audit table for AP_CHECKS_ALLHi, Is there any audit table available for AP_CHECKS_ALL table. In this table, CLEARED_DATE field is getting updated after check is cleared by bank. But i want to know, …
-
How to use the prompt in the Filter conditionCurrently we donot have a prompt and report fetches the data for the sysdate, with the filter condition as CURRENT_DATE BETWEEN "- Enrollment Results"."Enrollment Covera…
-
Automated Reports have stopped being sent to stakeholdersHi All, Can someone please help on the below issue. We are facing issues where the below automated/scheduled reports have stopped being sent to different stakeholders si…
-
Need assistance to restrict users from editing and deleting BI reports by using custom rolesI have created 3 roles for accessing different departments, SBC_HR_Reports_Access - copied from Human Capital Management Application Administrator - for accessing human …
-
In what HCM Cloud subject area can I find billing rate information?I am looking at Benefits - Billing Real Time subject area but can't find the proper fields for Billing Rack Rate, Billing Rate Currency and Billing Rate Effective Date. …
-
I need to know How to add Extensible Flex to Sales Order Report layout/ RTF Oracle FusionHello, As a business requeriment. I need to show Extensible flexfield on Sales Order Report. The flex configuration is: On RTF File i am adding the following: But when i…
-
How to restrict the PPM contract data based on the roles of the user logged in in OTBI DashboardSummary: We are trying to restrict the data based on the roles available for the user logged in specifically Principal Investigator role (PI role). Content (required): V…