Popular Tags
- OTBI 1,433
- Reporting 1,386
- FDI 1,087
- Analysis and Data Visualization 981
- BI Publisher 845
- 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
-
OTBI Analysis to get Working Days count and total hours spent by employee in given date RangeDear Team, I was trying create a Dashboard with multiple Analysis and Graphs. One requirement is to get Working Days count in the given Date Range and Total Work Hours s… -
Saved Customization report being deleted in OTBIUser cases: There are multiple users encountering deleted saved customization report in OTBI and it happens intermittently. Description of need: To have an audit log on …
-
SA- Payroll Element Entries Real Time - Filtering Displayed Input Value using Input Value nameHello all, Trying to create an allowance report using the SA - Payroll Element Entries Real Time, I have this so far I would like to remove the 'Input Value Name' column…
-
Payroll Legal Entity Registration Unit Field NavigationHello everyone, I have a requirement that needs to be pulled into the report, and I want to map it first in the UI/Front End. Can anyone provide where to find this field…
-
Issue when subsequently calculating from formulas containing FILTER functionBackground I have a single Oracle DB table set up as a basic Subject Area, comprising of one row per person per calendar month, showing data as of the last day of the ca…
-
How can we confirm impacted reports before removing the subject area access from some rolesThere are many reports are developed using some subject area and saved in different folders. Can i check how many reports would be impacted before removing the access? F…
-
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…