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
-
R13 Fuison Financials report listContent Dear all, I'm looking for a list of R13 Fusion Financials all standard reports/analysis. Could anyone kindly share? Thanks a lot Angie -
Translation report for Foreign Currency Translation Reserve (FCTR) reconciliation.Summary Translation report for Foreign Currency Translation Reserve (FCTR) reconciliation.Content Hi, Is there any report in Oracle cloud ERP for Foreign currency transl…
-
OTBI - To Display Sum of a column based on other column in New ColumnSummary OTBI - To Display Sum of a column based on other column in New ColumnContent Hi, I want to Display Sum of a column based on other column in New Column in OTBI An…
-
Is it possible to repete LOV(Data validation)to each row in BI Excel template outputSummary In the excel template row grouping we have created LOV for a single column, while generating excel reports and LOV applied to first row only, I need to repeat LO…
-
Receivable Aging ReportSummary issues when selecing multiple ledgersContent Hello all, Did anyone manage to customize the Receivables to Ledger Reconciliation Report in order to select multipl…
-
R13.19A OTBI Direct Database Query Privilege ChangeSummary In R13.19A OTBI direct database query has been disabled by default. To prevent reports generating system errors, BI Administrator can modify BI privileges to rev… -
BI report parameter entries - allow manual entries or search a value in the drop-down listSummary Need to allow users to make manual entries or click on the drop-down list to search for a report parameterContent All of our BI reports are set up with a drop-do… -
OTBI Calculated Measure sum is incorrectSummary Trying to sum two columns by row
-
premature availability of BI Output files in SFTP causes problemsSummary BI Output files found in SFTP are available for download before being completely writtenContent I am using BI Publisher within our deployment of Oracle Fusion Fi…
-
Fusion Financials: Configuring Accounting Segments for OTBI reportingSummary This document describes how to configure the accounting segments in Fusion Financials cloud to facilitate consumption of the accounting segments in Oracle Transa…
-
FX Rate Reports from FusionSummary Extract of given days' FX RatesContent Hi There, We are trying to use a report to see what FX Rates were used in Fusion on a given day in the past. The provided … -
How to open a Financial Report in SmartviewSummary Using FRS- report in SmartviewContent Hi all, We have created a few reports in Oracle Financial Report Studio in Oracle Fusion R11.1.7 We are able to open the re…
-
How to stop notifications for PO's at instance level.Content How to stop notifications/transmissions for Purchase Orders at instance level? Version Rel 13 19A
-
Any way to pull Previous year's generated 1099s?Summary Any way to pull Previous year's generated 1099s?Content We are reviewing our 1099 process and wanted to look at what we have generated in previous years... Is an… -
How to create dependent LOV Parameters for custom ESS Jobs using view criteria in cloud?Content How to create dependent LOV Parameters for custom ESS Jobs using view criteria in cloud? Please Find attached Screen shot explaining the issue in detail. Your re…
-
OTBI Dashboard - Drilldown FunctionalitySummary OTBI Dashboard - Drilldown FunctionalityContent Can anyone provide me with guidance on the exact URL that should be used with OTBI dashboard to drill down from O…
-
BI Publisher Report sporadically fails - database error?Summary Error message: SQL or ORA exceptions caused due to invalid SQL, database package state or some database exceptionsContent The error message "SQL or ORA exception…
-
SQL to Report on List of User Logins Per DaySummary seeking a listing of unique user loginsContent Can anyone provide SQL, or perhaps just table name, to get a list of unique user logins into Fusion? Thanks, Wendy -
Debtors / Supplier's view at consolidated level (Across Ledgers)Summary Debtors / Supplier's view at consolidated level (Across Ledgers)Content Hi, If I have a "supplier" with whom my organization is trading across BU and across Ledg…
-
Cash Flow statementSummary Cash Flow statementContent Hello anyoune has experience or suggestion about creation of a cash flow report? Best regards, Antonio -
Issue seeing requisitioner details in procurement subject areaSummary Financial users are unable to see requisitioner names for purchase ordersContent I am hoping someone can please advise in regards to this issue, we have a report…
-
Cost Center DescriptionSummary Link from GL_CODE_COMBINATIONS table to Cost Center DescriptionContent Using BI Publisher I need to get from the GL_CODE_COMBINATIONS Table to a Table which cont…
-
GST Report for SingaporeSummary Anyone has built GST report for Sinagpore country?Content Anyone has built GST report for Singapore where output is bifurcated as per the tax rate and tax type c…
-
BIP Report Output To Content ServerSummary Need to burst BIP Report Output to Content ServerContent Hi As per the oracle doc, I need to add a content server by navigating to Administrator--> Manage BIP --… -
OTBI Subject Areas documentationSummary Does documentation exist for OTBI Subject AreasContent Does documentation exist for the content of the ERP OTBI Subject Areas? My goal is to determine the subjec…
-
OTBI MobileSummary Documentation for best practice OTBI moblieContent Is there documentation for best practices for OTBI mobile? Should I use Oracle Business Intelligence Mobile or…
-
Filtering Issue on Data ModelSummary The results of the data model are not being filteredContent we are trying to create a simple data model with a variable. But the data is not being filtered as pe…
-
OTBI Report: Issue Aging AnalysisSummary PMOs, Project managers and stakeholders want to view their issues and due dates in a summary compressed view initially and then have the ability to drill down to… -
Role Customization to view Procurement and Finance AnalysisSummary Role Customization to view Procurement and Finance AnalysisContent Hi All, We have a requirement where Procurement Team will be accessing (only view) customized …
-
How to extract Registration Number on OTBI?Content Hi I've used the mapping tables for R11 but cannot seem to find the 'Registration Number' under Registration Details (For Suppliers). What I do get back is 'Firs…