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
-
Hiring manager and recruiter's full names not displayed in anaylsisHello experts, we are creating an otbi analysis with the following info: job req number, hiring manager’s and recruiter’s full names. However these last 2 info appear fr… -
Supplier DFF creation using REST APIs as a part of Supplier creation EndpointHi Team, Business wanted to create Supplier DFFs along with the Supplier creation endpoint that is /fscmRestApi/resources/11.13.18.05/suppliers. Business is using a libr…
-
Oracle BI Publisher Silent InstallationThe Official installer for the BIPublisherDesktop is provided in .exe format. The official command that is being used is BIPublisher64.exe /S /v/qn The installation fail…
-
-
Due Date field from Receivables Transaction Real Time is not displaying any data/valueEven though we tried with the most basic fields but the Due Date value is not getting displayed (Screenshot 1). Only when we are adding due date field from Receivables: …
-
How to source: Profile Item Id in OTBI to populate spreadsheet loaderI'm trying to build a spreadsheet loader to load license and certifications specifically Responsible Manager which sits in Responsible Person Region in Skills and Qualif…
-
OTBI Performance tiles for non measure fieldsHi, We would like to create a performance tile in OTBI analysis that will count distinct SR references that were opened in the last 2 days. Meaning, we want to use a dim…
-
Embed Hyperlink on Fusion UI to OTBI analysis with parametersHI, I want to embed a Hyperlink on my Fusion UI to an OTBI analysis with parameters. Thus: I have added a Hyperlink Component on Fusion UI and gave destination path to a…
-
Implement a dynamic default value for a DFF field based on another DFFCan anyone help with a SQL query - To implement a dynamic default value for a DFF field based on another DFF field in edit mode, ensuring that values captured in Task 1 …
-
Embedding OTBI Report Directly in HCM without Page Composer or Page IntegrationHi there, I'm wondering if there are other ways to embed reports or include links to reports directly in HCM without using Page Composer or Page Integration tools. I saw…
-
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