Popular Tags
- OTBI 1,432
- Reporting 1,386
- FDI 1,087
- Analysis and Data Visualization 981
- BI Publisher 845
- 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
-
Removing Edit, Permission and Archive options for OTBI analysis and Dashboards for BI AdministratorsWe have a requirement to restrict the edit or modify access for few analysis and dashboards even though user has all access to BI Administrator roles and duties while th… -
Need to restrict OTBI report prompt values based on the user logging inI am creating an OTBI report. Need to implement the security restriction. The prompt values should be displayed based on the user who is logged in. Please help. Currentl…
-
Interaction Hyperlink to contactHi community, I am trying to build a report with all my contacts and their attributes. The report will be exported to Excel to prioritize contact maintenance done by the…
-
Access procurement approval workflows in OTBIHello, Is it possible to access the requisition/order approval workflows to add into an OTBI analysis, the people that a requisition/order is pending to be approved? Tha…
-
Webservice or REST API to fetch Data from OTBI ReportWe are trying to get data from seeded OTBI Report through webservice: https://instanceURL/analytics-ws/saw.dll? but getting the following error: GCARFLCS 16…
-
Can we find where an OTBI analysis is used in other items (filter/result of another analysis)We need to make some changes to an OTBI analysis which is used as filter in other analysis/dashboards. Is there any way to find out by which dashboards and analysis this… -
How match Fusion application and OTBI page theme colourHi, After P2T refresh, we change the Fusion application theme colour for Non-PROD PODs. But, these colour changes do not reflect in the OTBI page. (Reports and Analytics…
-
How to show reporting currency in OTBI reportNow we have 2 primary ledgers, ledger 1 with ledger currency as HKD, Ledger 2 with ledger currency as SGD. Now we have setup 2 reporting currency in USD for the 2 ledger…
-
I want to prepare an OTBI report to capture roles and data access informationDear Members, I want to prepare an OTBI report containing the below details: Username Email Job Title Company Manager Name Role Name Role Code Security Context Security …
-
Can we get the table definition or the underlying table definition for a subject areaCan we get the table definition or the underlying table definition for a subject area
-
MCPD on Assignment - get top of stackWe are using the following qualifiers for getting a recent assignment. paam.primary_flag='Y', paam.assignment_type='E', paam.effective_latest_change='Y', paam.assignment…
-
Need help with OTBI columns on AP invoice dataHi folks, I need to analyze below info from our AP invoices data. No of invoices migrated by period (from legacy system) No of invoices created manually by AP team by pe… -
Unable to restrict results with workschedule filters when it is blank or non primaryIssue: There are multiple subject areas combined together to generate results which is embedded in dashboard. A new change has been requested to include employee's works…
-
Unable to extract current date from current_timestamp for the local timezone in OTBIHi, I have a requirement to report current day sales value. I am trying to leverage CURRENT_TIMESTAMP function as it gives me my local time. But when I try to extract da…
-
Joining two subject areas in fusion SCM OTBINeed to build a dashboard in order to fetch the below information as shown attached. Please let us know how can we achieve the same. Like on hand related information we …
-
Query to get tax reporting code in customer's siteHello community I need help with a query to get the tax reporting code, of a particular tax reporting type code ("XX_AR_DESC"), which is assigned on a customer's site (n…
-
Looking for data dictionary for Oracle Talent Management 23B, specific to Recruiting subject areasHello! We recently implemented Oracle Talent Management 23B and our team is working through understanding the data columns within our 5 Recruiting subject areas: 1) Recr…
-
Restrict User to create OTBI or BIP reportsSummary: Requirement is that Users should not be able to create any OTBI reports from his account. We have already restricted the Permission for the user to access other…
-
𝐃𝐞𝐞𝐩 𝐋𝐢𝐧𝐤𝐬 (𝟐𝟑𝐁) 𝐭𝐡𝐞 𝐜𝐨𝐦𝐩𝐥𝐞𝐭𝐞 𝐨𝐯𝐞𝐫𝐯𝐢𝐞𝐰 (all of them)𝐎𝐫𝐚𝐜𝐥𝐞 𝐂𝐥𝐨𝐮𝐝 𝐅𝐮𝐬𝐢𝐨𝐧 𝐚𝐩𝐩𝐥𝐢𝐜𝐚𝐭𝐢𝐨𝐧𝐬 – 𝐃𝐞𝐞𝐩 𝐋𝐢𝐧𝐤𝐬 (𝟐𝟑𝐁) 𝐭𝐡𝐞 𝐜𝐨𝐦𝐩𝐥𝐞𝐭𝐞 𝐨𝐯𝐞𝐫𝐯𝐢𝐞𝐰 (all of them) We all know that you can create Deep Links from your OTBI / BI Publisher (incl no…
-
Can you get data from data model or report (not analysis) thought web service (XmlViewService) ?Summary: We need to get the data displayed in a data model or report in an web service (for further integrations). The web service is XmlViewService which allows Execute…