Popular Tags
- OTBI 1,432
- Reporting 1,386
- FDI 1,087
- Analysis and Data Visualization 981
- BI Publisher 844
- 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
-
Filter with an OR conditionI have two fields: Field A and Field B I want to pull all records, which may have value 'SPLTAG' in either of the two columns. How do I create a combination filter acros… -
Sick absence duration sum issueHello, I'm trying to produce an analysis showing total days lost to sickness per quarter for each department. I'm working in the Workforce Management - Absence Real Time…
-
-
Is there a field in OTBI to tell if a Receipt was created in Redwood vs Classic page?Im looking for a field in OTBI that I can use to develop a report to identify if a Receipt was created in the new Redwood Expected Shipments Lines page vs the Classic Re… -
Issue on exporting entire dashboardI’m currently experiencing an issue when trying to export the entire dashboard to Excel. The export function only allows a maximum of 500 records to be displayed and exp…
-
Person Records Secured By AOR Does Not Restrict Data Reflected In OTBI ReportsSummary: Hello Everyone ! I am trying to secure the data returned by HR_ANALYST job role by using an AOR with a scope of Department. Although, it works fine in the HCM U…
-
Need 'PO First Approved Date' in the OTBI Subject AreaPlease guide me where we can find in report “PO first approved date”. Because the current reporting is completely wrong since it is always giving the “PO last approved d…
-
FDI People Leaders Dashboard issueIn the FDI People Leaders dashboards, on the Hires and Terminations pages, the graphs for Hiring Trend by Gender and Termination Trend by Gender, as well as the Hiring P…
-
How can a senior manager see information on people who have left the organisation?We have come across an interesting problem; a difference between what a line manager can see versus what an HR Professional can see. If an analytic (based on assignments…
-
Add KPIs and Negotiation Dashboard to Redwood Sourcing Landing PageSummary: Is it possible to add OTBI-based KPIs and visualizations to the Sourcing Landing Page in Redwood, specifically to build a negotiations dashboard (e.g., invited …
-
How to fix inconsistent positions of column?Hello, I have an odd problem with my report. When the 'activity description' column is at the end, additional columns are showing at the right. When it is placed before … -
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…
-
report dates parameters not incrementedHi, I defined a Data Model, with DATE FROM/DATE TO as parameters, in the following way: p_date_from: {$SYSDATE() - 7$} p_date_to: {$SYSDATE()$} Then I created a report u… -
Retrieve records for Supplier Audit reports in OracleHi I am trying to find below attributes from the Tools- Audit reports from UI but not able to find the table and attributes for Supplier Audit report. Please advise!
-
How to Automatically Refresh Dashboard in OTBI?Hi Gurus, We have an operational dashboard build which is displayed on the Production Floor. Is there a way to make it auto-refresh. We have observed that user need to a…
-
ESS Job, Including the there future run time, Analytics and Pre-build Subject area requiredHi, I need to have details about the ESS process name, and there schedule time interval and next run analytics report. Need to monitor the schedule process. Thanks and r…
-
add invoice life cycle details to OTBI analysis?Is it possible to add the Order Life Cycle details to an OTBI analysis? We have created OTBI analysis using subject area "Procurement - Purchasing Real Time". Now we wan…
-
Headcount filter by quarter end date too low and jumps aroundI want to report on headcount and FTE (also by age, grade etc.) for each department over the past 10 or so reporting/fiscal quarters. I am running an Analysis in OTBI, u…
-
Requisition DFF not appearingwe have BI enabled DFF at requisition distribution level for capturing project information which has been using for several years but it was not BI enabled recently we h… -
Function WITH clause is not working in BI Publisher report. ORA-32034: Unsupported Use Of WITH ClaHello Expert , In the TEST instance only, we encounter a problem with some BIP reports. The same report works as expected in the PROD instance. According to my analysis,…