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
-
How to LinkExpense and Advance (Financials Query Report Development)Hi Oracle Community, I’m working on developing a query report in Oracle Cloud Financials and need assistance with linking an expense and an advance. I have an expense an… -
Oracle Community Idea Raised - No ResponseWe have raised an Idea in Oracle Community (below is the link): https://community.oracle.com/products/oracleanalytics/discussion/19536/restriction-of-data-in-reports-and… -
Secured BI Publisher with asignment based AoR SecurityHi, I created a BI Publisher report that are based on the secured view PER_ASSIGNMENT_SECURED_LIST_V and assigned the privilege "Report Assignment" to the user's custom …
-
Automating Email Recipient Updates in Oracle Fusion HCM BI Publisher: Seeking Community InsightsHello Oracle Community, Problem Statement: We frequently receive multiple tickets from the business requesting updates to the email/distribution list recipient list in B…
-
Pivot table in RTF TemplateContent Hello, I am trying to create a pivot table for an asset number per row and period name and depreciation amount in columns. I have followed this doc to create the…
-
Calculating percentage for each row based on the column total in OTBI reportHi All, I'm trying to calculate the percentage for each row based on the column total in OTBI report as per below sample, when i tried with pivot table and set the show … -
setup printer with oracle fusion cloudhi we need to setup zebra Industrial Label Printer which is configured in our on-prem network, we need to setup it in oracle fusion application to print label and barcod…
-
How to keep the column's width fixed in OTBI?Hello, I have a concern with my Activity report, the 'Activity Description' column keeps widening every time we use the 'Activity Type' prompt. Original View/Width After… -
Missing Data in Simphony Export – Guest Check GST TableA data export configuration was created in Simphony using the standard template named “FiscalStandardExp”, which includes the following subject areas: FCR Invoice Contro… -
How can I print a chart from an interactive report?I need printing chart fom interactive report object. Are there someone to have get this, already
-
How can a third party reporting software Power BI be connected to Oracle Reports in FusionSummary: One of my client is using Power BI for reporting purpose they want to continue using power BI with fusion on a Realtime basis , So is there a way to sync up Pow…
-
Custom prompt based on values last 3 , last 6 , Last 9 and Last 12 monthsHi! We have a requirement to create custom prompt based on values such as: -last 3 months -last 6 months -Last 9 months -Last 12 months Above parameters work based on cu…
-
OTBI column formula assistance - Change 5 days to 5 working daysI am trying to amending the below column formula to count 5 working days instead of 5 days (which it is at the moment)? I need to exclude Saturdays and Sundays. Can anyo…
-
How can I get both account-contact and orphan contact in OTBI Analysis?Hi, Is there a way for me to get all contacts that are associated in an account and contacts that don't have an account in OTBI analysis? I am using subject areas below …
-
Concatenated values for Depreciation Expense and Depreciation Reserve AccountHi, I am working on an OTBI report and using the Subject Area "Asset Balances Real Time". I am looking for Depreciation Expense and Depreciation Reserve Account(Concaten…
-
Query to identify Work Orders WHERE Work Centre IS NULLIs it possible to create an analysis in OTBI to retrieve work orders that are not associated to any work centre? Our organisation has multiple departments (work centres)…
-
Building Customized reportsHello, I want to be able to have more options under my edit columns >"add fields" section when customizing and adding more fields. We need more transactions, GL account … -
How to export all rows at one go in OTBI DashboardsSummary: Hi, We have Dashboard created with OTBI Report , when we export data by OTBI report 1440 records are exported. But when we export by Dashboard only 13 rows are …
-
What role should be given to end users?Is it necessary for end users to only be able to view the latest version of the report, without being able to edit or view the dashboards? To prevent them from editing t…
-
PAY_RUN_BALANCES missing the last_updated_columnI'm a newbie to Fusion. I'm looking for a date column to pull the data from the pay_run_balances table for a quart-yearly HR payroll plans vs actuals report. The table i…