To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Reporting and Analytics for ERP
Discussion List
-
Reporting hierarchy for Budget vs Actuals ReportSummary Associate a new account hierarchy for Budget vs Actuals Report using FRS / SamrtViewContent Hi, We have a requirement to create a Budget vs Actuals report. As pa…
-
Revoke Roles in Security Console R12 Still Showing Assigned in BI ReportSummary Since R12 upgrade revoking roles in Security Console, the revoked users' roles still appear to be assigned in our existing custom BI report (SQL below)Content In…
-
fixed assetsSummary Cannot find reporting that shows assets with adjustted cost basisContent From fixed assets module, I'm generally using the Journal Entry Reserve Report to query …User_2025-01-29-20-33-47-986 62 views 0 comments 1 point Most recent by User_2025-01-29-20-33-47-986
-
Actual Cost is showing 0 in Project OTBI reports after R12 upgradeSummary Actual Cost is showing 0 in Project OTBI reports after R12 upgradeContent Hi, We are facing an issue like Actual costs are showing '0' for Project Analytics (OTB…
-
How to change the Costs Column for periodsSummary How to change the Costs Column for periodsContent Hi, I have a requirement to show the Budget and Actual costs with figures for month on month basis. So kindly g…
-
How to add Administration menu in Fusion R12 in BI Home pageSummary Administration Menu is not available after upgrading to Fusion Cloud R12Content How to get Administration menu next to the advanced menu in Fusion R12 in BI Cata…
-
How to set the currency for an individual BI AnalysisSummary Instructions for ensuring that data is always displayed in the correct currency on your reports and dashboards.Content Unless otherwise specified in the analysis…
-
Order Type Column in DOO Subject AreasSummary Searching for 'ORDER TYPE' column in DOO-Fullfillment real-time SAContent Hi All , Someone can help to find ORDER TYPE column in DOO fulfillment Real-time SA , T…
-
How to make the Graph OTBI ReportSummary How to make the Graph OTBI Report with feature drill down to applicationContent Hi, We have require to prepare the OTBI graph report with the feature drill down …
-
Project Portfolio Management Cloud OTBI Release 13: Subject Area Description DocumentSummary This document provides a comprehensive description of each subject area including the key business questions that can be answered using the same.Content Use this…
-
OTBI Report - Payment Document CountSummary CFO is requesting a report that will show the number of ACH/CHECK/WIRE PaymentsContent Hello All, I am trying to build a report that will show the amounts of che…User_2025-01-28-19-14-07-225 157 views 4 comments 0 points Most recent by User_2025-01-28-19-14-07-225
-
Managing Events ProfitabilitySummary Managing Events ProfitabilityContent we are using Oracle Fusion financials, procurement and inventory management to manage our daily transactions. in our line of…
-
Program or Portfolio Level ReportingSummary Project Portfolio Reporting in ERP Projects CloudContent Hi, We have a requirement to produce a Portfolio or Program level reporting from Project Costing Cloud, …
-
How to set the currency for an individual BI AnalysisSummary Instructions for ensuring that data is always displayed in the correct currency on your reports and dashboards.Content Unless otherwise specified in the analysis…
-
R12 Fixed Assets Subject Areas RedesignSummary In R12, Fixed Assets subject areas had a design overhaul. This document explains what changes have been made and the reasons for and benefits of these changes.Co…
-
Invoices Selected for Payment-Need a report to be generated for a specific supplierSummary Invoices Selected for Payment-Need a report to be generated for a specific supplierContent Hello, We have a need for developing a custom report in specified form…
-
How to remove the Edit link of an Dashboard when calling it from an Action Link within Fusion ApplicSummary How to remove the Edit link of an Dashboard when calling it from an Action Link within Fusion Application?Content How to remove the Edit link of an Dashboard whe…
-
BIP - Asset Details ReportSummary Asset Details ReportContent This report can help in getting extract of Assets from Fusion Assets for reporting , conversion data compare etc.
-
HTTP method GET is not supported by this URL in Chrome- SmartviewContent "HTTP method GET is not supported by this URL"- We are getting this error when drilling through the transaction from Smartview when using Chrome browser. We are …
-
Attach LOV to parameter of a custom ESS JobSummary Attach LOV to parameter of a custom ESS JobContent Can we attach an LOV to a parameter of a custom ESS Job? Has anyone done it? The Value set is an independent v…
-
Expose an BI Publisher Report Paramter's LOV in ESS jobSummary BI Publisher report can be exposed as ESS job. How can the LOV for the report parameter be exposed in ESS?
-
Adding subtotal breaks into a BI Publisher table reportSummary How do I add subtotal breaks into BI Publisher report?Content In an Analysis created with subject areas it's easy to add subtotals by going into the view under C…
-
Fill group by data in Group by columns and sub totals in a BI Publisher reportSummary Fill group by data in Group by columns and sub totals in a BI Publisher reportContent Current Output 1. Group by column data is merged 2. Group by column data is…User_2025-01-28-19-49-26-512 96 views 2 comments 2 points Most recent by User_2025-01-28-19-49-26-512
-
ending balance for OTBI - General Leader Transactional Balance Real TimeSummary I need to show in the same OTBI report the beginning and ending balance for a period name and the sum of the year (based on the period name)Content Hi I am doing…
-
Basic GL detail report requestSummary Looking for a basic GL detail report with supplier nameContent Looking for a basic GL detail report with supplier name and no blank lines in between rows, does t…
-
Query for AP Invoice LiabilitySummary queries for AP Invoice LiabilityContent Good afternoon, Are there sources for Fusion-specific financial queries - for instance: 1. AP Invoice liability, calculat…User_2025-01-28-07-55-23-615 238 views 2 comments 0 points Most recent by User_2025-01-28-07-55-23-615
-
OTBI Multiplying ValuesSummary OTBI Multiplying ValuesContent Hi Everyone, We are running into an issue where our OTBI reports are multiplying the balances of COA segments by 16. So all of our…
-
How to create prompt dashboard that accomodate same column name from different subject areaSummary Create prompt dashboard to accomodate 2 different subject areaContent Hi.. I have OTBI dashboard report that has 2 content report and each content comes from dif…
-
Financials ReportsSummary Financials reports resourcesContent You can refer to the following resources for information about Financials reports: * List of seeded reports * Sample reports …
-
ERP - Building Oracle Transactional Business Intelligence Reports in Financials Cloud: November 17,Content Submit your questions for the ERP - Building Oracle Transactional Business Intelligence Reports in Financials Cloud session to have them answered during the live…