Reporting and Analytics for ERP
Discussion List
-
Account Analysis ReportSummary Unable to save Account Analysis Report data model due to lexical parametersContent Hi All, We have requirement to enable some dff values in this standard report.… -
Column aggregates without showing measure columnsSummary Column aggregates without showing measure columnsContent Hi All, I have built a report with multiple measures. Is it possible to show only the column level aggre… -
Trial Balance report ends in error and no report is generatedSummary Trial Balance report ends in error and no report is generatedContent Hi All We regularly run the Trial Balance report for the entire financial year from schedule… -
Smart View Report MaintenanceSummary Smarter way to do Smart View report and minimise maintenance?Content We have a Smart View reports across multiple legal entities (7) with the reports required to… -
Report Job History is blank for BI ReportSummary Report Job History is blank for BI ReportContent Hi All, We have created a simple BI Report with one data model. When users are running this report, the activity…
-
Static Financial Reports - Using Smartview FunctionsSummary Using Functions in Smartview for Static Formats Ex: BS, IS,CF etc.Content When we look at reporting tools available in fusion for financial reporting (based on G… -
Sending Email notification to users when no data is returned from BI ReportSummary Sending Email notification to users when no data is returned from BI ReportContent We have implemented OCR(Invoice scanning) functionality in R13 Fusion cloud an…
-
Using Excel 64-bit with ADF and SmartviewSummary We are looking to upgrade our user's Excel from 32-bit to 64-bit. What is the impact on ADF, Smartview, etc? Does anyone have any feedback on using Excel 64-bit …
-
BPA ApprovalSummary BPA Approval Email notification report issueContent Hi, I was trying to customize the BPA approval email notification seeded template(from Purchase Document E-Ma…
-
Date Incorrect in Report OutputSummary I can't get the date to be correct in the Excel outputContent I have a report that is pulling from the AP tables. The date fields are set to True for Ignore User…
-
Generate CSV Data Extract from BI Publisher and transfer via SFTPSummary Need to Extract Customer data from Cloud ERP to a Third Party platformContent Hi All, I would need to extract customer data from Oracle Cloud ERP to a third-part… -
BIP - search using wildcard and multiple values in a text parameterSummary BIP - search using wildcard and multiple values in a text parameterContent User would like to input values in BIP parameters and search using wildcards or multip…
-
Issue with month format to create Trend Analysis Report for Data ProgressionSummary Issue with month format to create Trend Analysis Report for Data ProgressionContent Hi All, We would like to create a dashboard to show data volume progression b…
-
Select_physical * fromVO_nameSummary Select_physical only works on some VO'sContent Hi, Looking to expand the capability to search VO's using "Select_physical" on all VO's. "Select_physical * from V…
-
How to filter between Accounting Period Name in GL dashboard promptSummary How to filter between "Accounting Period Name" in GL dashboard promptContent Hi, I need to use "Accounting Period Name" in "General Ledger - Journals Real Time" … -
How to set Default Rows Displayed In Download in OTBI reportContent I need to set DefaultRowsDisplayedInDownload as " 65000" for my OTBI report. Is there a way to do it ? Already referred some oracle docs but I could not able to … -
Requester field blank on OTBI report from Procure to Pay Subject AreaSummary Requester field blank on OTBI report from Procure to Pay Subject AreaContent Hi All, In R13, we built a OTBI report based on "Procure to Pay" subject area. But R…
-
How to get Oracle Fusion Financial Cloud Standard Industry wise vertical reportsSummary How to get Oracle Standard Industry wise vertical reportsContent As a Oracle partner we are not able to find and share the Oracle Standard Industry wise/specific… -
R11 ERP OTBI Subject Area Mapping to Fusion Database TablesSummary Release 11 ERP OTBI subject area database table mapping spreadsheetContent This spreadsheet is published by Oracle OTBI Development. This spreadsheet documents F… -
Reporting on descriptive flexfields - BI Enabled checkbox not showingSummary Unable to use descriptive flexfield in OTBI - missing BI Enabled checkboxContent I need to create a new report using the Receivables - Customer Real Time subject… -
Issues with display in BIP reportSummary Issues with display in BIP reportContent Hi, I created a simple BIP report to retrieve two columns Requisition # and Requisition description. The description is …
-
Sample OTBI Reports Available - Payables, Receivables, Budgetary ControlSummary OTBI reports covering Oracle Fusion Payables, Receivables, and Budgetary ControlContent In case you do not subscribe to the Business Intelligence and Reporting F…
-
Out of the Box Financial Reports in Fusion CloudSummary I need to know about the availability of any out of the Box Financial Reports in Fusion Cloud Release 12Content I want to know about the availability of out of b… -
Reports Generated from Schedule Processes to be mapped to spring boardSummary Reports Generated from Schedule Processes to be mapped to spring board e.g. GL Accounts AnalysisContent Hi All, Is there a possibility to map reports generated v… -
Default "Account Period Name" value in OTBI Prompt while scheduling AgentsSummary Is there a way to default Period name on the OTBI Prompt while scheduling the Analysis from Agents?Content We have an OTBIE analysis "AP Transaction Report" that… -
How to update the New Analysis querySummary How to update the New Analysis queryContent How to update the New Analysis query from advanced tab with other operator functions/Group by function
-
Report that shows Payables Invoice Approver name, Initiated by , Validated by valuesSummary We are trying to build a report in Payables that shows Invoice details along with Approver name, Initiated by, Validated by ValuesContent We are trying to build …
-
OTBI Reporting QuestionSummary Adding field, removes othersContent Hi, I am brand new to OTBI and am having issues adding a field to my Received Not Invoiced report I am attempting to build wi… -
Add OTBI reports to Scheduled ProcessesSummary How to add OTBI reports to Scheduled ProcessesContent Hi, Can we add OTBI reports to Scheduled Processes rather than access them in Reports and Analytics?
-
Period-End Accrual Drill downSummary Period-End Accrual Drill down to Receipt numberContent Dear Masters, Is it possible to drill down period-end accruals from GL to particular receipt number? what …