Popular Tags
- OTBI 1,448
- Reporting 1,394
- FDI 1,123
- Analysis and Data Visualization 988
- BI Publisher 856
- Analysis 682
- Oracle Fusion Analytics 591
- Administration 555
- OAC 454
- OBIEE 433
- Analytics 403
- BI Publisher Data Models 356
- Security 293
- HCM 268
- BIP 264
- Answers 264
- Analyses 255
- Developers 246
- Data Modelling and Datasets 229
- Data Connectivity 210
- ERP Analytics Content 210
- BI Publisher Report Templates 204
- Oracle Analytics Cloud 197
- Fusion Data Intelligence 187
- Report Output 184
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 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…
-
Does a general Subject Area reference exist anywhere?I know of the existing Subject Area references which list the FAQs and roles that secure that subject area. Is there a more detailed reference that can give me instructi…
-
Is there are way to get the list of reports data and the column details used in reach reportI want the list of reports using XYZ column. We used to get this in Onpremise installation from Catalog, but i am unable to export the list of reports and their path and…
-
I want to place hyperlinks with dynamic values in my BIP reportquestion. I am creating a BIP report and I am facing the below issue. What I'd like to do is have a mechanism that, when clicked, opens another BIP report. If I just wri…
-
SQL Syntax for Max Salary Record?We would like the most recent salary amount. We used the query below but when we run the SQL we get the error that ORA-00923: FROM keyword not found where expected. Is t…
-
Report for vacant positions and open job requisitionsSummary: Hi, I was wondering if anyone has a report that shows active vacant positions with active open job requisitions? We are looking to pull: * Active position curre…
-
SCM - Inventory reports in OTBIHi, Could you please help with reports that can be built in OTBI specific to Inventory module. Would like to see below information in OTBI report Inventory Item Details …