Popular Tags
- OTBI 1,417
- Reporting 1,378
- FDI 1,013
- Analysis and Data Visualization 967
- BI Publisher 831
- Analysis 668
- Oracle Fusion Analytics 565
- Administration 554
- OBIEE 426
- OAC 375
- Analytics 365
- BI Publisher Data Models 340
- Security 284
- Answers 264
- Analyses 253
- HCM 247
- Developers 240
- BIP 238
- Data Modelling and Datasets 220
- Data Connectivity 206
- ERP Analytics Content 200
- BI Publisher Report Templates 192
- Report Output 181
- Customizing Reports 153
- Agents 151
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
-
Pull a report of OTBI User Folder AccessSummary We need to be able to pull a report of all user access to all OTBI folders. Content We need to be able to pull a report of all user access to all OTBI folders. T… -
Deep Links (23B) the complete overview (all of them)We all know that you can create Deep Links from your OTBI / BI Publisher (incl notifications), otherwise check here Creating Analyses and Dashboards in Oracle Transactio…
-
Benefits - Enrollment Real Time - Dependent Data Not Coming InWe have a basic report that is supposed to bring in Employee and Dependent data into a report and now the report is not reporting on Dependent Data anymore. Either none …
-
How to change the week definition to ISO-8601 (1st day of the week being a Monday)In OTBI the week definition is using the American standard, Week = Sunday - Saturday. But in Europe we do use ISO-8601. Week = Monday - Sunday. Also week number itself c…
-
In the AOR Subject Area, why is my Last Update Date and Last Updated By values being overwritten?I am unsure as to why the Last Update Date and Last Updated By values are being overwritten in my OTBI report. My AORs are still assigned correct, it just appears that a…
-
unsupported report object's type - [catalog]Currently we are using the following webservice to upload a report into BI Publisher https://fa-exsj-test-saasfaprod1.fa.ocs.oraclecloud.com/xmlpserver/services/External…
-
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.…
-
Need help with your site display name?Hi OA Community! Have you updated your profile to show your name, but are still seeing a generic ID? If so, message me and I'll fix it for you. There's an intermittent s… -
How to Effective Date a Headcount Report?I have a headcount report in OTBI HCM, that is running from the Worker Assignment Real Time subject area. When it runs, its always latest and greatest. How do I effectiv…
-
Fixed Assets - Clarity on Depreciation Source CodeWe are currently implementing Fixed Assets in Oracle Fusion ERP and would like assistance from FA SMEs as we have begun work on OTBI dashboards and reports: In the Fixed… -
How to query fusion tables in SQL developerSummary: We have a data model to select the email_address_id from fusion.PER_EMAIL_ADDRESSES but we want to be able to query this table or data from this table (or IRC_C…
-
Turnover by Ethnicity - Report AssistanceSummary: We are currently running into issues creating a Turnover report by Ethnicity due to how ethnicity is handled in Oracle. This is causing employees to be duplicat…
-
OTBI Usage and Performance Dashboard SampleReal Time OTBI Usage & Performance Two subject areas are available to monitor OTBI usage and performance: OTBI Usage Real Time: Monitors OTBI usage, including user, anal…
-
OTBI Logical SQL complex query assembler - Updated to 10 subject areasSummary Combine analyses from up to 10 different subject areas Content While building a report on OTBI, you will encounter some cases where the Subject Area will only pr…
-
OTBI link Receivables Customer Real Time to Transactions Real TimeHi- Financials Receivables Cloud BI Using the Real Time Subject Areas how can I get a list of all Customers & their Details (Sites, Accounts, Contacts, Addresses) and de…
-
How to identify missing Associations in a Taxable Benefits Calculation CardHi, We have started Payrolling Benefits this tax year and have identified an issue where a Calculation Component, along with the Calculation Component Details have been …
-
OTBI Analysis result via SOAP request/response with proper column namesHi, I am using OTBI and I have created an Analysis. This works great. Now I want fetch the result via a SOAP call. This also works fine. I use the XmlViewService and the…
-
Unexpected Language Variation in Data Extraction - BIP ReportHi community, We are experiencing an unusual behavior with the "Environment Health and Safety - Incidents Real Time" subject area in a BI Publisher (BIP) report regardin…
-
How to add column headers for pivoted fields in layoutHello - I cannot find a solution to this yet I see many unanswered questions. I just need a firm 'no' if it's not possible. If it is, a brief explanation of how would be… -
Monitoring and analyzing HCM workflow email bounces--Please advise if this post belongs in a different forum-- As we know, bursting emails is possible in BIP, and OTBI provides bursting via agents. Recipients receive mes…