Popular Tags
- OTBI 1,432
- Reporting 1,386
- FDI 1,087
- Analysis and Data Visualization 981
- BI Publisher 844
- 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
-
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…
-
Timecard Approved Data in BI Publisher ReportTeam, We are trying to get Timecard Approval Date, Approver Name Details. But we are unable to find the table name. The below MOS says that it's not feasible to get it f…
-
Need to fetch changes attribute from assignments history in OTBI ReportHi Team I want to fetch changes attribute from assignments history in OTBI Report. Which attribute its help to fetch it from assignments event subject area.
-
How to fetch seperate Posting Date for each external career site in RecruitingSummary: We are working on a Report where the requirement from the customer is to fetch the posting date and unposting date (exporation date) seperately for each of the …
-
OTBI report questionSummary: In certain situations when I put a report together it pulls the date and groups it with several person numbers. Example is attached with a screen shot. If 5 peo…