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
-
order management (order type table)Content i need to know table of order type in order management -
How to create a Batch name from BIP report.Summary How to create a Batch name from BIP report.Content All, any examples on how to create a Batch name from the BIP report. I think we can do it using an eText templ…
-
sql to get po number & receipt number from glContent if i create a report in gl to get each journal, if journal get from AP i need purchase order number and receipt number. i need a sql statement .
-
in gl how i get account balance for specific dayContent if i want to create a report from gl to get account balance for specific day and get balance before this day as open balance can i do it with financial reporting…
-
Not-for-Profit Statement of ActivitiesSummary Seeking sample Statement of ActivitiesContent Statement of Activities quantifying revenue and expenses of our not-for-profit entity for a reporting period. The n…User_2025-02-11-03-09-13-126 19 views 0 comments 1 point Most recent by User_2025-02-11-03-09-13-126 -
Limitations of OTBI reportsContent Can someone please share the limitations on OTBI reporting compared to BI reporting. I'll inputs regarding the performance, number of records/columns that can be…User_2025-02-08-08-48-00-058 611 views 5 comments 0 points Most recent by User_2025-02-08-08-48-00-058
-
Raw data extraction from Oracle Fusion to Datalake/SFTP serverSummary Exporting data from Oracle Fusion to SFTP Server - Unable to handle systematic deletesContent Hi All, We have a requirement where we need to push raw data into a…
-
action link & agentContent in OTBI i need an example for action link. and another example agent.
-
Using Task Number instead of Task IDSummary I want to use Task Number as a Prompt but when i am searching with task number. system search with task IDContent Hi, I am using Task Number value in a Prompt. M…
-
What is best practice for Functional Designs for OTBI Reports for support purposesSummary What design documents if any are you creating for OTBI reports created by power users for support purposesContent We are in the middle of a cloud implementation … -
Person data reporting with Financial only implementationSummary We need to do Person data reporting can we use Workforce Management - Person Real Time OTBI subject area on a finance only implementationContent We are currently…
-
User Interface Across the Financial ModulesSummary Can anyone confirm if there are plans to update the User Interface in the Financial Modules?Content Our customer has just moved to the Responsive UI for HCM and …
-
create analysis (item/on hand quantity/item cost )Content i need to create analysis item/on hand quantity/item cost/quantity*item cost
-
How to use Validation type "View Object" in the valuesets?Summary How to use Validation type "View Object" in the valuesets?Content Hi Experts, I am trying to understand how to use the validation type with "View Object" in the …
-
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…
-
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… -
General Ledger - Balances Real Time Subject Area: not returning Beginning and Ending BalanceSummary General Ledger - Balances Real Time Subject Area: not returning Beginning and Ending BalanceContent I am trying to create an analysis based on General Ledger - B… -
Schedule BIP report only when it has DataSummary Schedule BIP report only when it has DataContent We have one requirement for BIP report where we have schedule BIP report daily. so we need that if report data i…
-
RTF Template : Hide Row based on SUM() after complex RegroupingSummary Has anyone tried to Hide a row after regrouping the data and the conditions should be based on the SUM() of a column obtained after groupingContent The XML data …
-
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…
-
Analytic needs to work with Prompt in DashboardSummary Analytic needs to work with Prompt in DashboardContent Hi, I have a Dashboard include one analytic and one prompt. When i open the dashboard, analytic is searchi…
-
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…
-
20D Common Financial Features - Details RequiredSummary REFINED USER EXPERIENCE FOR KEY LISTS OF VALUES SEARCH & SERVICE EXCELLENCE CONTINUING INVESTMENTS in particularContent 20D release notes contain the following C…
-
Financial ReportsSummary Balance Sheet and Income Statement ReportsContent Hello All, Are there the following seeded reports in Oracle? * Balance Sheet * Income Statements * Cash Flow I … -
Smart View Error - "XML Load Error: 'End tag 'head' does not match the start tag 'meta'Summary Smart View Error - "XML Load Error: 'End tag 'head' does not match the start tag 'meta'Content We just started receiving this error on Saturday after 20D was app…
-
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…
-
How to remove/supress subtotal lines in SmartviewSummary Is it possible when drilling down in a Smartview report to 'remove subtotal rows' in the same was as you can with a standard pivot table output?
-
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…
-
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 …