Popular Tags
- OTBI 1,401
- Reporting 1,365
- FDI 961
- Analysis and Data Visualization 953
- BI Publisher 816
- Analysis 663
- Administration 553
- Oracle Fusion Analytics 543
- OBIEE 421
- Analytics 342
- OAC 336
- BI Publisher Data Models 335
- Security 271
- Answers 261
- Analyses 253
- Developers 240
- HCM 237
- BIP 232
- Data Modelling and Datasets 218
- Data Connectivity 205
- ERP Analytics Content 199
- BI Publisher Report Templates 184
- Report Output 180
- Agents 151
- Customizing Reports 146
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 to make a table fixed in an RTF templateWhen printing checks, we try to leave a fixed value at the end of the sheet, although at the bottom you can increase or decrease the invoice lines. To do this, an RTF te… -
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…
-
Language ReportLooking to create a language report for all employees to access when needed. I am using Workforce Profiles - Person Profile Real Time but when I test employee's access, …
-
Custom Dashboard throwing out errorWhenever i try to access custom dashboard it throws out this error Permissions are in place for dashboard/folder also our role has the subject area needed but then too i…