Reporting and Analytics for ERP
Discussion List
-
Report Job Hoistory Table nameContent Hi Team, Could you please let me know, whether BI Report job history stores in any table, if so,could you please let me know the table name. Thanks. Uva Version … -
How to Link Purchase Order Invoices back to Project Costs?Content Hi All We're working on a Project Statement report that brings back a comprehensive breakdown of the project costs and revenue. For the costs, we were able to br… -
ESS Job Parameter Conditionally RequiredSummary Conditional ParameterContent Good People, Can we make the ESS Job parameter conditionally required ? e.g. I have 2 parameters say parameter P1 & P2 , can I make … -
Preparing a Opening Journal in Cloud from last period balances from EBSContent Team, I need help in Preparing an Opening Journal in Cloud, I am using balances from EBS for last period. I am trying to use GL_Balances Table, but I see lot of …
-
BI Publisher connecting bank account to receiptSummary Need advice on creating a data model for a BI Publisher report on AR receiptsContent I need to create a new BI Publisher data model which returns the bank accoun… -
GL Approval Date, Group for BIP reportSummary GL Approval Date, Group for BIP reportContent We have a requirement for bringing up approval date, approval group, final approver etc. into a custom BIP report. …
-
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 … -
Fixed Asset ReportingSummary Reporting from Fixed Asset Sub-LedgerContent Hello - I'm looking for the following information in a report from the Fixed Asset sub-ledger. I am looking for a re…
-
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…