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
-
Actual Revenue VS. Budgeted RevenueSummary: I want to make a dashboard of Actual Revenue VS. Budgeted Revenue. Which subject area could be used for this query? Comparison is required between 2024 Budget, … -
Different Checklist IDSummary: Checklist_ID is always equals to Task_ID for the task associated with the particular checklist. do there is some cases where it can be different, please help. C…
-
Allocation percentage for resources in the projectSummary: Hi everyone, We're looking to gather details on project resources, specifically allocation percentages. It's important that these resources are currently assign… -
How to enable Export options when analysis added to Reports and AnalyticsSummary: Enable export options below a report from an analysis Content (please ensure you mask any confidential information): We have created custom analysis and made th…
-
Using BICC with UCM - Expected CostSummary: I am intending to use BICC (Business Intelligence Cloud Connector) in combination with UCM as an external Storage. What are the costs I can expect related to th…
-
Why OTBI report output file in excel is not showing morethan 25000 recordsSummary: Is there any OTBI Developer can help me resolve this issue. If the output excel file of AD PO ALL PURCHASE ORDERS Report is morethan 25003 records it is skippin…
-
BI Report Exported Data Wrong in Date but Become Correct after ReopenSummary: When I exported the report data. I find that when I chose the period like from 2024.06.01-2024.06.30. but the export date period in the report parameter will be…
-
How to include attachments from the main transaction page into a custom reportSummary: Hello team, greetings for the day!! I was asked to develop 'AR Payment Plan' bursting report which triggers an email consists of 3 PDF pages. out of those pages…
-
Custom Folder is unavailable to all the UsersSummary: Our users are not able to see the Custom Folder under Shared Folders All our reports are in the Custom folder. Possibly -mistakenly the permission of the folder…
-
Navigation to ERP AnalyticsSummary: Hi All We have client that buy ERP Analytics license. How to navigate to this ERP Analytics? You can check the screenshot using this link : But, I dont know how…
-
API to Manage Objects in BI CatalogSummary API availability to upload or download BI Catalog objectsContent Is there any working example of managing BI Catalog objects in terms of uploading and downloadin…
-
Oracle Fusion Workflow Report for all pending transactionsSummary: Is there any seeded Report available for all pending Workflows (PR,PO,AP Invoice, Payment, GL Journals, Expenses, HCM, PPM, OTL,etc). The report should show tra…
-
OTBI PO Balance Report to Tie to Budgetary Control Obligation BalancesSummary: I am attempting to build an OTBI report that will pull PO balances by PO that will ultimately tie to a cost centers obligation balance in Budgetary Control. We … -
Job Definitions Created Did not Connect to BIP reportSummary: l need to create job definitions to run reports as scheduled processes. However after l maintained the job definition and BI report's property, the schedule pro…
-
Is there a Standard report in Oracle Cloud for ECD in Brazil? Does it show the previous year's?Summary: Is there a Standard report in Oracle Cloud for ECD in Brazil? If so, does it show the previous year's operations? What to do when starting to use the platform? …
-
The search is not working in the drop down menu in Data set BU publisher reportI have this parameter that is related to a list of value that give all the contract number. the query i am using for the list of value is: select DISTINCT TV.CONTRACT_NU…
-
How we can invoke multiple templates/Grids in FRS reporting based on the input parameters ?how we can invoke multiple templates in FRS reporting based on the input parameters. Unfortunately, we have not found any functionality to invoke multiple templates like…
-
Payment Approval HistorySummary: We need the payment approval history data to capture the approvers at template level Content (please ensure you mask any confidential information): Hello Team -…
-
can we fetch report for how many times a report runHi Everyone, we have a requirement to fetch the all custom reports in the fusion, along with their information of how many times that report run in 2024 and what is the …
-
Parameter values to pass to save update Data model of Subledger Period Close Exception ReportSummary: Customer is looking for Customized Subledger Period Close Exception Report to add Supporting Reference columns. Thus looking for an input to know which valid va…
-
Custom role Project Administrator and Cost Controller cannot see AnalyticsThe custom role that we made Project Administrator and Cost Controller should be able to see the Analytics Widget with Project Dashboard information. However its missing…
-
i want sql query to find business days differnece between two datesSummary: I want a query in sql to get businees days between two dates E.g i have two dates of differnet tables the gap is of 15 days or may be 7 days or may be 30 i want… -
Sending Customer Statements via API or SOAPSummary: Mass sending of customer statement of account to selected list of random customers. Similar to mail merge Is there any API or SOAP that can be used to call Stat… -
Convert English numbers into Arabic numbers in rtfI used function to calculate the summation of the VARI variable in the page and used this to show the number in footer, I need this number to be displayed in Arabic, n…
-
accouting hubSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Project receivable invoices payment statusIs there any analysis or OTBI subject area that can help in tracking the Project AR invoices status based on the applied amount. the image below is captured from the man…
-
How to download entire Data ModelsHello, We have created an update of a very complex data model and would like to compare it with the old one. We remember that in the previous versions it was possible to…
-
Account is outside of report range message for Receivables to General Ledger ReconciliationSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Fusion Finance Analytical Reports Dashboard in FAWSummary: GL Account Analysis Dashboard in FAW enables user to analyze account activity from various sub-ledger sources supported in FAW like AP, AR, etc. contributing to… -
How to export 500K rows from OTBI report into ExcelSummary: We have a report where total data is coming close to 500K and we are only able to export 25K in Excel, is there is any way to do this? If I develop this in BI P…