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 407
- 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 can I generate payments with bank reference with the reference brought from self-service procureWe need to make monthly referenced payments where the bank reference changes constantly and the bank account is the same. -
manager name splitHi I am writing an analysis where I need first and last name of manager sepertaly from Oracle HCM BI. I got the first name using Left. How do I take the last name. If I …
-
Dashboard (Launchpad) - Links Hidden/Unhidden based on role ?Hi folks I've a request to build a dashboard which acts as a launchpad to a series of reports. (Rather than running the reports through the catalog) The request is that …
-
HCM Audit report.We'd like to understand what auditing is available and how detailed auditing would be enabled. It may just be an OTBI report, it may require some settings changes. It's …
-
I need a query to get maintenance dispatch list details in maintenance management moduleHello, I need a query to get maintenance dispatch list detail shown in this screenshot.
-
Try to find in which table I can find Default Expense Account discerptionHello everyone, I am working in BI Report and I am trying to find Default Expense Account discerption. I found the code but I could not find the discretions. the code fo…
-
What are the ERP extract pvos to extract all (accounted and unaccounted) Fixed Asset transactions?We need to augment FAW data model to bring in a new fact containing all the FA transactions both accounted and unaccounted. This dataset needs to be used for reporting b…
-
If a EFF is does not have a value is there a way to pull it into reporting?We have some positions that have Extensible Flex Fileds Values for Backgrounds and Certifications - there are some positions where this information is not entered yet (s…
-
Custom DFF not visible in OTBI subject areaHi, There is a custom section in Talent profile and that has some custom DFF. Few of the DFF are not visible in OTBI subject area "Workforce Profiles - Person Profile Re…
-
How do we get server details and Credentials for setting up Printer in Oracle fusion.How do we get server details and Credentials for setting up Printer in Oracle fusion.
-
Want to know the exact name and subject area in OTBI for adding 'Reference Number' fieldSummary: Hi Team, OTBI - Could you please suggest the correct subject area and field name for adding Reference Number field (Highlighted in Yellow below) available in th…
-
When passing a parameter to OTBI analysis in Page Composer it is not filtering as expectedOBTI Analysis Embedded into BPA Change Order.docx Description: I am trying to do page customization using the page composer for the "BPA Change Order Approval Notificati…
-
Tables which stores extract run detailsHi Team, I am working on the BIP report to fetch HCM Extract run details, please help to get the tables which stores this data. Thanks, Saurabh Mharolkar
-
-
How to store results of an OTBI Report to Document of Records against EmployeesI need to store the output of a BIP Report to the Document of Records against employees. Is there a solution to this problem? Thank you so much for your time and help! R…
-
mapping between EBS tables and oracle fusion cloud tablesSummary mapping between EBS tables and oracle fusion cloud tables Content Hi Team , as the schema changed from EBS to oracle fusion cloud so Is there any document that m…
-
OTBI Pivot table limits number of rowsHi, I have an OTBI report for Total Comp Deferred Cash Payments year wise. This is a simple report from subject area - Payroll - Element Entries History Real time. We ar…
-
Data discrepancy between HCM Oracle UI and OTBIHello all, While developing a report we saw that the data that is stored in HCM Module UI is different from what is displayed in OTBI. We need to take a gap between this…
-
How to restrict OTBI reports data not to send to external mail idsUsers are able to access and schedule OTBI reports. We want to restrict not to send users to external email domains other than organization domains.
-
How to filter population with a seniority date less than 365 from today in OTBII tried to convert the enterprise seniority date filter in SQL and insert: "Worker"."Enterprise Seniority Date" >= (SYSDATE -365)