Popular Tags
- OTBI 1,429
- Reporting 1,383
- FDI 1,062
- Analysis and Data Visualization 976
- BI Publisher 840
- Analysis 673
- Oracle Fusion Analytics 577
- Administration 555
- OBIEE 429
- OAC 408
- Analytics 382
- BI Publisher Data Models 346
- Security 288
- Answers 264
- HCM 256
- Analyses 253
- BIP 248
- Developers 243
- Data Modelling and Datasets 223
- Data Connectivity 208
- ERP Analytics Content 205
- BI Publisher Report Templates 201
- Report Output 183
- Oracle Analytics Cloud 169
- Customizing Reports 156
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
-
Hide or make null a value in pivot tableHi all, I am building a pivot table as per the above and as you can see the total shows a value of less than 10 which is contrary to our policies. How do I make the row … -
What occurred when FUSION_APPS_HCM_ESS_APPID was the last update user, a month after termination?We are using the Subject Area User System Usage to show our Auditors when a User last accessed the system. We were hoping to use this subject area to also show when the …
-
Checking audit for the saved customization reportSeveral users are experiencing deletion of saved customization report in OTBI. As for their experience, it happens once or twice a year. Is there a way to check the logs…
-
derive FTP output parameters - Remote Filename and Remote Directory automaticallyHI, We have created BIP reports with pl/sql type and when we try to schedule them with output option → FTP, it requires to input Remote Directory and Remote Filename. Is…
-
How to filter Scheduled Ship Date based on Pacific Time Zone (PST/PDT) in OTBI Reports.I have an OTBI report that retrieves a list of orders with missed scheduled ship dates. The filtering criteria for the report is set as "Fulfillment Lines - Scheduling D…
-
New Headcount Planning in Workforce Job level GranularityWe are looking for a solution of updating Start Date and adding new Headcount/Hire for a new/existing jobs in the middle of Plan/Forecast Year. Since the compensation ca…
-
Unique privilege or grant identifies the primary user- Security ConsoleA user with the "Application Implementation Consultant" role has permission to view all Business Unit information. This role (ORA_ASM_APPLICATION_IMPLEMENTATION_CONSULTA…
-
Need to display the custom error message on OTBI reports. Please provide the workaroundNeed to display the custom error message in OTBI report , wherein error message is displayed basis the report column value whether the same is in correct format or not .… -
Subject Area: Project Billing- Invoices Real TimeWhen using the Fusion OTBI subject area; - Project Billing- Invoices Real Time; the field 'Invoice Number' does not return any data for ALL records. Can anyone confirm i…
-
Conections reports oti biHi, I need to create a report about the last conections and the fisrt one when the user enter in tha plataform HCM Cloud Thanks -
Oracle Incentive - OTBI - Participant PositionI am looking for Participant Details along with his/ her POSITION from OTBI. Any pointers on which subject Area to be used. I can see Participant Details in few Incentiv…
-
Excel compatibility with Oracle BI?We are using the version of Excel 1997, which is too old and is only capable of threat with 65,000 lines. Which other versions of Excel are compatible with Oracle BI Clo…
-
Estimated End Date associated with an Absence - OTBII am having trouble getting the Estimated End Date associated with the absence to pull into an OTBI report. Is there a way to pull in this value?
-
Advice needed. Got a request to create a new role for OTBI access only; no access to BIP.The role will need the following access in OTBI: Ability to create, edit, delete, archive and unarchive reports in the My Folder No Ability to create, copy, modify or de…
-
Filter results of an OTBI report based on logged in userI am creating a data model for approval transactions. Is there a way to filter the results of the approvals based on the logged in user (Approver)
-
Duplicate element entry report with entry detailsI have a requirement where I need to report on more than one element entry for a person where the input values differ. Attached is the OTBI analysis details on how I hav…
-
How do I get the performance tiles to aggregate properly when using multiple subject areas?Hello Experts, I've run into an issue when creating performance tiles from joined subject areas. The tile (using a simple count measure) I'm using seems to aggregate pro…
-
Report Job History defaultsHello, When searching for the reports I recently ran, by navigating to Report Job History, it defaults to 1 week ago date, slowing down the search itself. How can we cha…
-
How to move BIP report extraction output file from UCM to object storageRequest is to move the BIP report output file from UCM to object storage . Please advice if there is any configuration to be done at HCM side so that BIP output files ca…
-
Line Manager Email notification with their Employees Due and OverDue TrainingsWe have the OTBI report that sends an email to line managers with their direct reports due and overdue trainings via agents. And, we have recently found that, there is a…