OTBI
Discussion List
-
Report and Dashboard prompts on multi tab DashboardSummary Prompts not clearing and show selections from other report promptsContent I have a multi tab Dashboard with two to three reports on each tab. Each report has it'…User_2025-01-28-20-19-02-475 67 views 1 comment 2 points Most recent by SantoshKumarBhairi Reporting and Analytics for ERP -
How to Add the OTBI Dashboard to the Financial Reporting Center?Summary How to Add the OTBI Dashboard to the Financial Reporting Center?Content How to Add the OTBI Dashboard to the Financial Reporting Center? OR If i can make it more…User_2025-02-11-09-27-02-564 199 views 6 comments 2 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
Can we have a multiple bursting in one reportSummary Can we have a multiple bursting in one reportContent Hello, Can we have multiple bursting in one report, I can create multiple burstings within the data model an…Koteswararao Yenikepalli 634 views 1 comment 2 points Most recent by Anil Kola-Oracle Reporting and Analytics for ERP -
How do we distinguish between custom reports and standard reports?Summary We want to know how many custom reports are created in reporting center. How do we distinguish between custom reports and standard reports?Version Oracle Fusion …Patrick Chrabieh 225 views 2 comments 7 points Most recent by Skolli-Oracle Reporting and Analytics for ERP -
If we need to run a report or a query on all the profile options currently set for our client in FusSummary If we need to run a report or a query on all the profile options currently set for our client in Fusion, is there any way?Version 21AUser_2025-02-08-12-06-31-659 41 views 1 comment 1 point Most recent by OmkarAdkar Reporting and Analytics for ERP
-
Account Segment Group ObjectsContent Our team is looking to group together certain accounting segments for use in some of their reporting and imports. They currently have specific payroll object gro… -
Configuring Key Flexfield Segments in Oracle Financials Cloud to leverage OTBI for ad-hoc analysesSummary Configuration Steps to enable OTBI reporting of Key Flexfields (KFF's) in GL, Budgetary Control and Fixed Assets (Rel 11)Content To report on Key Flexfield Segme…Anand DN-Oracle 1.7K views 8 comments 12 points Most recent by Chris Lynch - AST Reporting and Analytics for ERP -
Budget balances not available in General Ledger subject areasSummary Can we query budget balances in General Ledger subject areas?Content Budget balances not available in General Ledger subject areas like 'General Ledger - Balance… -
Can Saved Custom Groups be used in Calculations/Formulas?Summary Using Custom Groups in Calculated ItemsContent In OTBI, I've designed an analysis where I've created custom groups of the Natural Account Segment Code using GL -…User_2025-02-11-07-08-23-440 20 views 1 comment 2 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for ERP
-
Fixed Asset Report- OTBISummary Fixed Asset Report- OTBIContent I created a Fixed Asset OTBI report. The report is working well only recently it starts dropping data. its only reflecting 25000 …
-
Help with OTBI Filter ErrorSummary Error when filtering for a date rangeContent Hello, I am having 2 issues. 1. I am trying to create a filter using Invoice Date where report would show all invoic…Marlowe Matoba 29 views 2 comments 3 points Most recent by Elisa Ortiz Rincon Reporting and Analytics for ERP
-
OTBI Drill down to External Cash Transaction - Blank transaction pageContent I cant get the drill down to External Cash Transactions to work in my OTBI Analysis. Everything seems to be fine and I am redirected as expected. The problem is …Stefan pettersson 34 views 7 comments 2 points Most recent by Anil Kola-Oracle Reporting and Analytics for ERP
-
Bursting A Report With SubTemplatesSummary How to burst a report using a sub template.Content Hi Experts, We have a custom report which uses a sub-template. The report also uses bursting to email. But the… -
OTBI report - Issue with Expense Transactions Real Time subject areaSummary OTBI report using this subject area no longer shows data from prior assignmentsContent We have an SR for this issue but I'm wondering if anyone else has noticed … -
ExternalReportWSSService sample payload to pass template nameSummary ExternalReportWSSService sample payload to pass template nameContent Hi, Can we pass report template name to ExternalReportWSSService SOAP service which triggers…Vinod Kumar Mohanraj 363 views 3 comments 1 point Most recent by Arun Raj Reporting and Analytics for ERP
-
OTBI Analysis: Using TIMESTAMPADD to derive last day of the month based on Period Name in Subject ArContent Hello There, I have an OTBI analysis for Subject Area: "General Ledger - Balances Real Time". The analysis has a column "Time"."Accounting Period Name" OR "Time"…
-
OTBI Report for element entriesContent Hello Guys, I need to create an OTBI report for element entries, but when i try to creare the analysis the system show me the following error: No Results The spe…Giuseppe Iacono 113 views 3 comments 1 point Most recent by Anil Kola-Oracle Reporting and Analytics for ERP -
Report results pull in journals 1 hour prior to parametersSummary User selects date greater than 3/10/2021 at 12PM, yet the report results is pulling in journals with a timestamp 1 hour prior to set parameterContent User select…User_2025-02-05-22-11-22-331 29 views 1 comment 1 point Most recent by User_2025-02-05-22-11-22-331 Reporting and Analytics for ERP
-
Deep Links Results in Blank PageContent Hello, I have created my first Oracle Cloud ERP OTBI report with deep links to invoice. When I run the report, I have a hyperlink as expected, but the result is …Marlowe Matoba 65 views 9 comments 2 points Most recent by SimonTomey Reporting and Analytics for ERP
-
Geography Municipalities ExtractionContent Hello Guys, We need to create a report in order to extract Geography Municipalities data, where could we find this information? Best Regards, GiuseppeGiuseppe Iacono 24 views 0 comments 0 points Most recent by Giuseppe Iacono Reporting and Analytics for ERP
-
Inventory Reconciliation with GL - ReportContent All - I have a requirement to show the Inventory Reconciliation with GL and I see two OOB reports (Costing balances and Inventory Valuation) to satisfy the requi…Hari Thyagaraj 52 views 2 comments 0 points Most recent by Ahmed Eldemerdash Reporting and Analytics for ERP
-
OTBI custom folder security in production VS test environmentsSummary How are you managing your OTBI custom folder security from Production to Test when different?Content I our current environment we have several self service users… -
Project Actual Costs - Account CodeSummary Project Actual Costs - Account CodeContent We are creating a report using the Project Costing - Actual Costs Real Time subject area. We are pulling cost distribu…MLubbert 49 views 2 comments 1 point Most recent by User_2025-02-05-11-02-18-093 Reporting and Analytics for ERP
-
Projects Unprocessed Costs Error DetailsSummary Get detail of Projects Unprocessed Costs ErrorsContent I am trying to build a report using the Project Costing - Unprocessed Costs Real Time to build a report wi…Sharon Harper 33 views 2 comments 0 points Most recent by Sharon Harper Reporting and Analytics for ERP
-
TIMESTAMPADD function in OTBI reporting in UTC and not ESTContent We are using the below function to fetch the data for the previous month in OTBI Reporting & noticed it extracting the data based on UTC time zone and not EST. I…Murali Gangidi 98 views 6 comments 2 points Most recent by Anil Kola-Oracle Reporting and Analytics for ERP
-
Inventory Reconciliation ReportSummary Inventory Reconciliation to GL ReportContent Hello All - I have a requirement to create a sub-ledger report that shows inventory subledger detail and its reconci…Hari Thyagaraj 58 views 1 comment 0 points Most recent by Dhruvjoshi23 Reporting and Analytics for ERP
-
Safest/default Path to Publishing changes to GL (Essbase) Trees: Publish Chart of Account DimensionSummary We have been experiencing issues in making changes to GL tree structures in OTBI, so I wanted to be clear on what the options are for each step, to eliminate the… -
Subject Area for Supplier CountrySummary I want to be able to bring the suppliers country into a report but can't find the right subject areaContent Hello, I have created an analysis in OTBI and I want …User_2025-02-04-19-45-49-438 21 views 2 comments 1 point Most recent by User_2025-02-04-19-45-49-438 Reporting and Analytics for ERP
-
Number of Accounting Periods in Accounts Receivable for OTBI ReportingContent We have a thirteen period calendar setup in Oracle, each period is four weeks. When we attempt to write OTBI reports we are only seeing 12 periods. My question i…Robert G Wilkinson 23 views 1 comment 2 points Most recent by User775911-Oracle Reporting and Analytics for ERP
-
OTBI data modelSummary Is there a place where we can understand the data model (tables) for OTBI reports?Content Is there a place where we can understand the data model (Tables) for OT…Jeff Hare CPA CISA CIA 99 views 5 comments 3 points Most recent by Jeff Hare CPA CISA CIA Reporting and Analytics for ERP