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
-
I received below error when trying to fetch details from content server dataset in the data model.No such data source found in the data source config. Or you do not have access permission. Could not get data source connection for: FA_UCM_PROVISIONED -
Need to stop extract file creation at BICC in case of no incremental dataAt BICC, First extracts are full table extract. next schedule extracts will generate incremental data files. For these incremental schedules, if there is no incremental …
-
Regarding Budget Control Analysis ReportHi All, I am looking for a Budget control Analysis Report where I show the Detailed information of the Spend amount with PO/Requsition number and amount. For that I am t…
-
-
Transpose rows to columns for RatingsI want to show the ratings of two specific performance document section names in columns. I named the header like the section name. I used a "CASE WHEN" statement for "A…
-
Subject area that contains Talent Profile Metrics and Succession Plan Metrics DetailsHello there, We are encountering challenges in identifying the appropriate subject area that contains Talent Profile Metrics and Succession Plan Metrics details. Could y…
-
What is the retention period for fa_fusion_soainfra.wftaskhistory table in Fusion?What is the retention period for fa_fusion_soainfra.wftaskhistory table in Fusion? Can I control the retention period and how?
-
recruiting - recruiting real time Candidate AttachementHi Experts, I'm trying to fetch candidate attachment files/URLs by using this recruiting - recruiting real time OTBI. Unfortunately, I can't see any attachment files or …
-
ORA-00939: too many arguments for function error when used substr in SQL Query in DataModelHi, I have created a DataModel using below query : select HZP.PARTY_NAME, HZP.PARTY_NUMBER from HZ_PARTIES HZP where 1=1 AND HZP.PARTY_NAME IN (substr(:P_STRING1,:P_STAR…
-
how to stop send otbi report in emailHi, I Send OTBI Report In email and choose repeat to be daily. I receive the report in email successfully now i want to stop the daily email .
-
Production to Stage for BIP ReportsSummary Easiest way to copy BIP reports from Production to Stage environments Content Hi all - we have two ways that we use BIP reports on our dashboards: 1) Embedded Co…
-
Can you convert field [Recruiting-Recruiting Real Time] from Date to Date & Time in OTBI?We would like the time associated with the job application in the field 'Job Application - Electronic Signature' Can I convert this field to date & time instead? If so, …
-
SQL Error on Date ParameterI have been trying to de-bug my code for a while. When I am working in SQL Connect on my desktop my code works perfectly, but when I bring it over into OTBI to create a …
-
Custom SQL in OTBI reportHello, I have the following problem. I would like to have the signing authorities in a OTBI report; the main issue is that I have the codes but not the meanings (I've be…
-
How to Schedule a BI Publisher Report with Dynamic time range in parameter ValuesIssue Description: We need to view the BIP Reports -'Execution History by User' and 'BIP Reports Execution Summary'. To accommodate this, we are utilizing one of Oracle'…
-
What is the subject area for Oracle pricing/Sales AgreementsWhat is the subject are name for Oracle pricing/Sales Agreements
-
MATERIALS REQUIREMENT TOTALHello and good day! Dearest Oracle Community friends, I am trying to create an OTBI for materials requirement below, would anyone know how to create the formula for tota… -
OTL Audit Report HelpI am trying to create an analysis in OTBI to show the different versions of an employees timecard. I need to see the trail of the changes and when they were done. We are…
-
Is there a way that a BI Administrator can archive/unarchive a specified user's catalog items?I have the BI Administrator role and can see the entire user base of My Folders. However, I cannot drill down to see reports nor do I have the capability of archiving/un…
-
Outer Join OTBI - Vacant PositionsSummary: I am trying to produce an analytic that can show the number of "Vacant" positions. The analytic requires two subject areas and I believe I may need an outer joi…