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
-
BIP Local Solutions reports do not print Natural Account descriptions in selected local languageSummary: Predefined Latin America Local Cloud Solution (LALCS) BIP reports do not print Natural Account Descriptions in translated language - Spanish. Content (please en… -
How to configure an additional Input parameter in Account Analysis Report XLAAARPTHello, We have a requirement to add additional department type Input parameter as a filter in BI Account Analysis Report XLAAARPT. This report is being run through the E… -
How to schedule an OTBI report to generate monthly with dynamic prompt?Summary: We have an OTBI report that contains a datetime prompt. I'd like to schedule the OTBI report to run each month and have the datetime prompt automatically popula…
-
Cannot Deliver More Than 75K Lines to an OTBI reportSummary: Hi, The customer needs to extract data from an OTBI report with more than 75,000 rows. How can we change this limit, which is already pre-set in the report? Cur…
-
Display days of a week in order using rtf templateI have a rtf template which is using days of week to display receipt totals for each day for different entities I am using pivot table to display data weekday vs entity …
-
HCM OTBI Report on all absences with a future or missing end dateSummary: Our IT dept are having a hard time identifying logins that are due for auto deletion due to inactivity but that actually need to be kept open (eg those on long … -
Approval History - AP Invoice Account Coding Workflow Notification CustomizationSummary: We need to customize "AP Invoice Account Coding Workflow Notification" to display approval history using SQL Query. In BPM Workflow notification we can see the …
-
two Factor Authentication for Fusion ERP Usersis two Factor Authentication feature available for Fusion ERP Users
-
Get Recipients from the Analysis as Task Owners from Project Subject AreaSummary: Cannot set dynamic recipients of an email with analysis. The standard functionality should be available using an Agent. The agent was setup for an analysis done…
-
Unable to see requests run by service account.Summary:Unable to see requests run by service account. We have few service users defined through which we run some scheduled jobs. Recently we have created new service a…
-
How to find indexes really used in OTBI - Subject Areas ?Summary: How to find indexes really used in OTBI - Subject Areas ? The document R13_23D_FIN_OTBI_database_mapping_with ViewObjects.xlsx doesn't give really indexes used … -
Need Outstanding Check Report in Oracle fusionSummary: Hello, We are looking for a report that shows payments that were issued but have not cleared the bank account yet. Is there any report already available in Orac…
-
Query or the table that contains columns of the Account Analysis ReportSummary: Content (required): Hello everyone, I have a requirement to make a custom report for the Account Analysis Report. I need to pick some of the columns in the seed… -
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…