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
-
Audit Report for Oracle backup Log in Oracle fusionSummary: Hello, We are looking for report where the Oracle system backs up all data, libraries, applications, and user profiles daily/on a regular basis. Is there any re… -
How to Link a Column in OTBI to a Parameter Based on Conditions?Hello, I am working on a report in Oracle Transactional Business Intelligence (OTBI) and I need some help with linking a column to a parameter based on conditions. Speci…
-
How to delete chart of accountsSummary: How to delete chart of accounts Content (please ensure you mask any confidential information): Hi All, How to delete chart of accounts which is defined wrongly?…
-
pvo to link between catalog and categoryIs there any PVO to link between Purchase Catalog and Purchase Category
-
How to get Risk Code value in BIP Custom ReportSummary: We are developing a customer report and we need a column called Risk Score. The value we may need is similar to this 'Any value between 1 – 69 is high risk and …
-
24A ERP OTBI subject areas to database tables mapping spreadsheetsSummary: 24A ERP OTBI subject areas to database tables mapping spreadsheets Content (please ensure you mask any confidential information): Where can I find 24A SCM and P…
-
OTBI Report - Hyperlink Path Not Found ErrorI'm getting a "path not found" error when clicking a hyperlink on a graph in my OTBI report. The hyperlink is supposed to open a customer profile report when I click on …
-
How to create a new KPISummary: How to create a new KPI Content (please ensure you mask any confidential information): Hi Team, How to create a new KPI reports for Finance? Could anyone guide …
-
Project Resource varianceI have created an analysis that reflects the variance of actual cost to the budget at resource level and also the variance of the same cost but related to the whole proj…
-
How to add category parameter to account analysis reportSummary: We need to add category parameter to customized account analysis report and it runs into error "'P_CATEGORY' must be declared ORA-06550: line 2, column 1: PL/SQ…
-
Unsupported use of WITH clauseSummary: My custom report is producing the error of Unsupported use of WITH clause Content (please ensure you mask any confidential information): I have developed a repo…
-
Supplier contracts OTBI/SQL reportSummary: Is there any standard Supplier contract OTBI/SQL report available? Content (please ensure you mask any confidential information): Version (include the version y…
-
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 -…