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
-
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…
-
Report with Workforce Compensation Real Time Subject area returns duplicate resultsI have a report that I've created using the Workforce Compensation Real Time Subject area, in the report I have the fields: Person Number Assignment Number Assignment St…
-
How to group columns in OTBISummary: Would like to know how to group columns in OTBI, and only keep the groups in pivot. Content (please ensure you mask any confidential information): I am trying t…