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
-
SOD Conflicts Report in Oracle FusionSummary Is there a report or dashboard to review the conflicts of roles as per SODContent Hi Can someone please let us know if there is any report / dashboard to let us … -
Is there a way to see the date a Project Forecast was created?Summary Is there a way to see the date a Project Forecast was created?Content I'm trying to find project forecasts created between a specific date range regardless of th… -
How to find last logon date of users in Fusion Applications?Summary How to find last logon date of users in Fusion Applications?Content Hello people You know how to inform me please, in which table can I retrieve a list with the …
-
Project Number is still seeing wrongSummary I changed project number in the system. I am seeing old number for the project in analyticsContent Hi Dear All, We are using an Analytics using Procurement - Pur…User_2025-02-05-02-38-04-251 47 views 1 comment 0 points Most recent by User_2025-02-05-02-38-04-251 -
Different PR - PO Matched in AnalyticsSummary for one pr has multiple po one of them cancelled the other one closed but i saw cancelled one. I cannot reach the closed oneContent Hi Dear All, We had a PR and …User_2025-02-05-02-38-04-251 13 views 0 comments 0 points Most recent by User_2025-02-05-02-38-04-251
-
Table for BPM - specifically CONFIGURATIONSContent We are looking for tables to be able to look at the workflow rule configuration. For example, we want to be able to create a report that will tell us things like… -
How to restrict Data Model options to avoid users to access directly to the tables (SQL Query)?Summary Power users and contracts need to create data models based on BI Analysis, but this will also give them access to run SQL Queries. We want to restrict SQL Query … -
Competency ReportSummary developing a competency report using otbiContent Dear All, Which work area is suitable to create a report to check the competency name, the target competency, th… -
Schedule Audit ReportSummary Schedule Audit ReportContent Hi How to schedule the Audit Report and Auto forward the excel or csv format in email Regards M.Padmanabhan
-
Custom OTBI content that we did not createSummary Why is there report objects under custom folder after install of OTBI that we did not createContent After our new POD was brought up I went into OTBI and I'm fin… -
Enable prompt auto completion for OTBI Analysis and BI Publisher reportsContent Dashboard, analysis and BI Publisher prompts should have auto completion available and enable by default. This feature is not available at all at the moment. Thi…
-
Scheduled OTBI report isn't showing all rowsSummary Scheduled OTBI is truncated when exported as a CSV fileContent Hi All, I have several OTBI reports which I have scheduled to be run each morning and delivered in…
-
Implementation Roll-out, ERP first, EPM first, or Big BangSummary Looking for implementation roll-out examples from clients who have implemented EPM and ERP (Financials, PPM, Procurement)Content We are in the process of outlini…
-
Pivot self-assessed tax amount from a column to a row in an OTBI ReportSummary Pivot self-assessed tax amount from a column to a row in an OTBI ReportContent Currently, we have an OTBI report using the subject area “Payables Invoices – Tran…
-
Audit Table with Approval LinkSummary Audit TableContent Hi All, How to join the audit table (IBY_EXT_BANK_ACCOUNTS_ ) and POZ_APPROVAL_HISTORY table. Regards M.Padmanabhan
-
Analysis is missing the promptsSummary Missing prompt on Expense ReportContent We have a report called 'Expense Type Report' It was created with the 'Analysis' tool. This report has prompts when you g… -
Depreciation reserve of assetContent We're building a Fixed Asset Balances report out of Subject area Fixed Asset Balances - Real Time'. But we are not able to get the balances for Accumulated Depre…
-
How to get Projects Cross Subject Area Analysis to show projects both with and without Billed AccounSummary How to get Projects Cross Subject Area Analysis to show projects both with and without Billed Account NameContent I have created a simple analysis using Projects…
-
ce_available_transactions_vSummary Recreate ce_available_transactions_v in OACContent Hello all I'm trying to recreate 'ce_available_transactions_v ' in Oracle Analytics Cloud (either via replicat…
-
How to get list of custom BI and OTBI Reports in FusionSummary How to get list of custom BI and OTBI Reports in FusionContent Hi, Do we have any standard ESS job or tables which can give us below details of custom report: Na…
-
in otbi create analysis from 2 subject areaContent can i create analysis from 2 subject area ? if yes i need an example
-
on otbi create conditional format for rows not columnContent can i create conditional format to become a row is green ? not for column
-
last item costContent i need a query , to get last item cost.
-
How to capture page overflow in rtf template - BI PublisherSummary I need to display the sum of a particular field for all the Invoices in the current page only even if the Invoices overflow to the next pageContent Hello, I have…
-
FRS General Ledger Financial ReportingSummary Combing Accounts and or Parents in FRS ReportContent Hello - does anyone know why we can't combine multiple accounts or multiple parents into one line on an FRS …
-
Publish reference document within Oracle FusionSummary Is there a way to publish reference document or link to a reference document within Oracle FusionContent Our Finance department is currently engaged in a project…User_2025-02-03-23-21-35-207 44 views 3 comments 0 points Most recent by User_2025-02-03-23-21-35-207
-
Exclude a column in XML Report output formatSummary My select query has two columns. I want to have only one column in my report output which is in XML format. Is there wa we can achieve this.Content My select que…
-
How to migrate the Common lookup from one instance to another instanceSummary We have created a Comoon lookup and need to migrate into another environment. Can you please help me by providing steps for migration
-
Differences between running Reports Online vs Schedule/ESSSummary Can anyone list the differences in terms of restrictions of running Reports Online from BI Catalog vs Schedule / ESS DefinitionContent Hi Team, Our customer is a…
-
Is it possible to Hide columns in List of Values used in a PVO ?Summary Is it possible to Hide columns in List of Values used in a PVO ?Content We have defined a number of custom Reports and ESS Definitions. We try to use the standar…