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
-
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 … -
create analysis (item/on hand quantity/item cost )Content i need to create analysis item/on hand quantity/item cost/quantity*item cost -
Procurement – Purchasing Real TimeContent i need from Procurement – Purchasing Real Time item /quantity/unit price/line amount(quantity * unit price)
-
ESS Monitor: Cancelling a scheduled daily processSummary I'm trying to cancel a scheduled daily process, that day gets cancelled, but it keeps all other scheduled daysContent I'm trying to cancel a scheduled daily proc… -
analysis from (Procurement – Purchasing Real Time) and (Procurement - Procure to Pay Real Time)Content i need to create analysis contain data from 2 subject area Procurement – Purchasing Real Time & Procurement - Procure to Pay Real Time is this available ? if ava…
-
Segment Security in BI ReportSummary Restrict the BI report based on the user logged in and their Natural Account/Department.Content Folks, We have a requirement to restrict the BI report by Segment…
-
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…
-
create dashboard from supplier trial balance &procure to payContent i need to create a dashboard from subject area supplier trial balance and procure to pay , i created analysis from 2 subject area and put supplier as prompt,i cr…
-
How to fix table position at the bottom of my pageSummary Need to fix table position at the bottom of my last pageContent Hello, I have a requirement to fix a table at the bottom of my last page. I have managed to get t…
-
Capacity of Smartview report breaching 250k lines in ExcelSummary When running a Smartview TB Report, if it is filtered by more than 1 segment Eg, Account then fund, it will not run the query as it brings back > 250k linesConte… -
Which roles to use to secure custom OTBI ObjectsSummary In Otbi I see job roles, Duty Roles and Privileges what should I use to secure custom content in OTBI catalogContent All, When setting up custom folders in OTBI … -
OTBI Report Suppress option and excel filters issueSummary When the columns are merged in suppress mode, Filters don't work properly in excelContent Hi, We created an OTBI report with suppress checkbox enabled for all th…
-
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…
-
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… -
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 …
-
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 …
-
GL reports on multiple ledgersContent Our client has close to 40 million journal lines across ledgers for a single period. They want a BIP report where they will only pass the ledger set and choose a…
-
Daily Journals Report (Standard Report) in Oracle Fusion does not show Some ParametersContent Dear, Daily Journals Report (Standard Report) does not show Some Parameters it works perfectly but issue is it does not show some parameter which are mentioned b… -
FRS Reporting Query - Current yearSummary FRS Reporting Query - Current YearContent Hi team, In FRS Report, If the current open period is Jun 20 and the report is run for year 2020, it does not give any …
-
FRS Report, calculation does not equal report TotalSummary A calculated value of four columns is off by less than $1 from the Report Total of those same four columnsContent Company 1 Company 2 Company 3 Company 4 Sum Rep…
-
Smartview - reversing the signs so revenue presents as positiveSummary Wanting to pull in revenue as a positive valueContent We are new to Oracle and Smartview, and are learning how to use the tool. We have not determined how to bri… -
R13 Risk Management OTBI subject area to database lineage mapping spreadsheetSummary This spreadsheet documents R13 Risk Management OTBI subject area to database lineage mapping and subject area security. Content This spreadsheet is published by …
-
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…
-
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… -
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… -
Limit number of lines per pageSummary I have an invoice where I want to limit the number of lines that appears per pageContent Is there an IF statement that could limit the number of lines that appea…
-
Request Guidance of Changes Oracle makes to seeded Oracle ReportsSummary Does Oracle have a list of changes they made to Oracle Reports on a Quarterly basis?Content During our Quarterly Updates Readiness Review process, it would be ve…
-
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…
-
Fusion BI Catalog Folder Management Best PracticesSummary A white paper on Fusion BI Catalog Folder Management Best PracticesContent This white paper provides the best practices for working with BI catalog folders, and … -
How can i find BI Tables easily?Summary How can i find BI Tables easily?Content How can I find BI tables where specific data is stored, I spend so many times trying to map and also get a table I want f…