Popular Tags
- OTBI 1,360
- Reporting 1,350
- Analysis and Data Visualization 895
- FDI 879
- BI Publisher 787
- Analysis 652
- Administration 542
- Oracle Fusion Analytics 535
- OBIEE 415
- BI Publisher Data Models 321
- Analytics 309
- OAC 270
- Answers 259
- Security 253
- Analyses 251
- Developers 234
- HCM 219
- BIP 212
- Data Modelling and Datasets 208
- Data Connectivity 205
- ERP Analytics Content 192
- Report Output 178
- BI Publisher Report Templates 177
- Agents 148
- Customizing Reports 141
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
-
How to fetch Recipient details from Leave Donation Real Time Subject Areai was trying to fetch the absence donation Recipient details like (First name Last name of Recipient and Alias details ) i was not able to drag and drop those columns. I… -
How to only show workers who have multiple managersMy org is switching to Oracle, and most of my experience in reporting is in Tableau. I'm struggling on how to filter to only show workers who have more than one manager.…
-
How to restrict OTBI dashboard report output when User field isn't in subject area?Hello, I'm setting up an OTBI dashboard which will only return rows in report(s) based on user details, i.e. User is equal to/is in @{NQ_SESSION.USER}. However, the subj…
-
How to fetch the Contribution requested by employee (Cash disbursement) in OTBICan someone help to fetch the details of the hours which are raised for cash disbursement in OTBI
-
DFF fetching only code in OTBIWe have many DFFs configured in HCM. On front end HCM, we can see the full description eg for local job title, but in OTBI the field only returns the job code. Is there …
-
OTBI - Subject Area Overview & Standard KPI Calculation GuidelinesHello everyone, I wanted to ask if there is a way to generate a list in BI Publisher (Cloud) that provides an overview of the available Subject Areas along with their re…
-
I have enabled descriptive flexfield for expenses based on expense type selectionI have enabled descriptive flexfield for expenses based on expense type selection for 2 expense types to display the same value set(free text) to capture values captured…
-
Dunning letters seeded report questions on SendDunningBatchProcess reportI am new to Fusion and trying to modify the report and/or data model for the Dunning process. I see 3 issues so far: Account Number column is blank even though when I se…
-
Hide Subject area and catalog folders which are not neededHi All, Can we hide the subject area while creating any new analysis in OTBI which are not relevant or client has not bought the license for that module ? Similarly , ca…
-
Budgetary Control Results Report by TransactionWhat are the tables that contain transactional information pertaining to budget control data? Could we have query of "Budgetary Control Results Report by Transaction" re…
-
Oracle Fusion Budgetary Control Transaction Subject Areas.Hi, I use the budgetary control transaction subject area to show a transaction with purchase order transaction type. I want to display the item number of the purchase or…
-
OTBI Fields translation spreadsheet to BI FieldsHello! I have an outdated version (19C) of an excel spreadsheet of OTBI Subject Areas where you can find the column name/table in BI Publisher. Cover Page tab is titled … -
Where to find Taxable Benefit, Associations, Tax Reporting Unit, Effective Start dateHi, I'm attempting to extract the Effective Date of the Tax Reporting Unit in Associations for a Taxable Benefit in OTBI. I'm using Subject Area Payroll - Calculation Ca…
-
Disable auto run in OTBI analysisHi Team, OTBI analysis report running automatically without giving parameters and getting results which creates confusion to business/user. So could you please try to he…
-
OTBI Dashboard Prompt Timestampadd Formula for Default End Date Covering through EOD 11:59:59pmI needed to default the begin and end date dashboard prompt for First Day of Previous Month through Last Day of Previous month using the following timestamp formulas res…
-
Assistance Needed for Implementing Custom CSS in OTBI ReportsI am working on Fusion Application and I want to create a CSS file that I can use for custom styling in my analyses. Specifically, I want to utilize classes from this CS…
-
Why is the modified date changing on the seeded OTBI reports?Hi, I have noticed that modified dates on the seeded OTBI reports are changing. I do know that whenever there is a patch applied to the instance the modified dates may c…
-
"sensitive data access audit real time" subject area does not show resultsWe are recently searching for audit information and found the subject area "sensitive data access audit real time", however, no results are shown.I searched the document…
-
Data Model with single parameter not returning sql query resultsi am trying to create a very, very simple data model, to turn into a bip report, that contains one parameter. the data model query works independently of the parameter (…
-
Replace function is not working in OTBI Dashboard PromptHi Team , we have created dashboard prompt where we have two parameters . Parent department and Child Department. Parent department is sql result type and have presentat…