Popular Tags
- OTBI 1,454
- Reporting 1,397
- FDI 1,140
- Analysis and Data Visualization 988
- BI Publisher 863
- Analysis 684
- Oracle Fusion Analytics 596
- Administration 555
- OAC 476
- OBIEE 434
- Analytics 408
- BI Publisher Data Models 359
- Security 296
- HCM 269
- BIP 265
- Answers 265
- Analyses 255
- Developers 246
- Data Modelling and Datasets 229
- Oracle Analytics Cloud 216
- ERP Analytics Content 214
- Data Connectivity 211
- BI Publisher Report Templates 205
- Fusion Data Intelligence 193
- 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
-
Scale a long numberI have a horizontal bar chart showing a long dollar figure (billions) and would like to scale it down it to $#.#B. I know this can be done for a tile but cannot determin… -
OTBI client role based reportingHi, Our customers require to have BU or role based reporting dashboards on OTBI. They do not want to have multiple reports, the requirement is single report but the data…
-
Report job runs after the end dateSummary: One of our scheduled reporting job had run beyond the defined end date. Does anyone know why report job still appear "Active" and runs beyond provided end date?…
-
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…
-
unable to access OTBI reports from Product Management subject AreaUsers are unable to any OTBI analysis from product management subject area. This issue is with user who has custom item master view only responsibility Custom responsibi…
-
Need to create alert when PO Receipt date is in closed AP periodHi Team, Need to create alert when PO Receipt date is in closed AP period. When i goto OTBI, i dont see any option to create alert, any role i am missing? please help. P…
-
User selecting accounting period for running an OTBI report without triggering ERP full licenseIn a License analysis we came to know that in Financial Analyst Role the Privilege "Manage Period Close Activities" is triggering "Oracle Fusion Enterprise Resource Plan…
-
Custom OTBI - VETS - 4212 - Legislative Information Information is missing in Output FileWe have a custom VETS - 4212 OTBI Report. But all the attributes are giving values except Legislative Information attributes in the Output File. For example: Legislative…
-
Problem in query that returns information from Oracle customers by siteSummary: My query should have only the records that were modified in sysdate SELECT /*********hz_parties******************/ hp.party_id, hp.party_name, hp.jgzz_fiscal_co…
-
Prefix SET VARIABLE PARAM_EFFECTIVE_DATE not workingWe are running some of our OTBI reports with a variable for a user-prompted date (data for a specific date). Currently, the report variable uses and displays the wrong d…
-
How to remove duplicate lines of data in OTBI report.I've written a report in order to provide aggregate data for our performance documents and their rating score. My report produces the correct data, with the exception of…
-
Error running OTBI report - The user request exceeded the maximum query governing execution time.There is an OTBI report which gives results when I run using my ID but the same report is giving error - "The user request exceeded the maximum query governing execution…
-
Large Data Set not returningHi Everyone! The organization I work for has ~10 manufacturing plants across the US. Folks on the HR compensation team analyze compensation data for those locations as a…
-
Can an Agent to Generate OTBI Report and Email increment to the next GL period?I have an OTBI that produces all the the voided AP payments in a given period. Can I create a process where by the OTBI report and report agent increment to the next per…
-
Fixed Assets - Asset Balances Real Time: Ending BalanceThe Fixed Assets - Asset Balances Real Time: Ending Balance is showing a sum of Cost and Depreciation. How can I make it show the NBV?
-
BIP report working fine for admin login but exceeding time limit for user loginSummary: We have a BIP report that delivers report within 2 minutes for admin login but when HR specialist (user) logs in to run the same report, it exceeds time limit C…
-
Supplier Bank Account info: how to filter "Assignment Inactive On"Hi Experts, Would like to reach out to you regarding the proper way of filtering Supplier Bank Account's "Assignment Inactive On" field. Please refer to the screenshot t…
-
Action link not working for Logical SQL AnalysisHi Experts, We have created two analysis which will be a master drill down report, both of these analyses are created through logical SQL, the two analyses are summary a…
-
From to period is not working in OTBI reportWhen i am trying to add a parameter, for budget period name , i am using between in the prompts but it's not giving the from to period. Sometimes it's giving error and s…
-
What is the latest limit on OTBI export for CSV & Excel.I was able to export 75k in excel & 500k records in csv with OTBI. However, I keep on reading that excel has a limit of 25k & csv has 75k as a limit. Do we have a way to…