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
-
Requisition Life-cycle report (OTBI)Summary Simple report showing creation date, approval date, PO creation date etc for purchase requisitionsContent See attached screenshot for details. Unarchive the atta… -
How to identify and group Subject Areas by module in Oracle Cloud Financials?Hello everyone, I’m currently reviewing the documentation about Subject Areas for Transactional Business Intelligence in Financials as part of a training plan I’m design… -
How to add Dashboard or OTBI analysis on Navigator or Springboard (Home page)This discussion provides step by step guidance on how to add OTBI analysis or Dashboard or any external webpage to application UI home page or on Navigator as new page e… -
SQL query to display Purchase Category hierarchySummary: SQL query to display Purchase Category hierarchy Content (required): For anyone who might find this useful, I've written a SQL to pull the Purchase Category hie… -
How do we distinguish between custom reports and standard reports?Summary We want to know how many custom reports are created in reporting center. How do we distinguish between custom reports and standard reports?Version Oracle Fusion … -
Retrospective Purchase Oders reportSummary Simple report showing any invoice-matched purchase orders where PO was created after the invoiceContent Many organisations have instances of employees ordering g…
-
Budgetary Control Carry Forward Sample BIP ReportsSummary Sample reports to identify transactions that impact budget account balances, and also facilitate the identification of transactions and balances that need to be … -
Sample OTBI Reports: Budgetary ControlSummary OTBI Reports for Budgetary Control and Carry ForwardContent These are sample reports for customers using Budgetary Control to assist them in managing their contr…
-
How to Schedule a BI Publisher Report with Dynamic time range in parameter ValuesIssue Description: We need to view the BIP Reports -'Execution History by User' and 'BIP Reports Execution Summary'. To accommodate this, we are utilizing one of Oracle'…
-
Redwood Plan for Oracle Cloud ERPSummary: I haven't found clear discussion on how the Redwood would affect Oracle Cloud ERP. I see documentations and notices for EPM, HCM, and SCM, but I'm unclear on wh…
-
What's your go-to browser for Oracle Fusion Cloud Financials?Summary Firefox? Chrome? Edge? Which one do you prefer--and which do you avoid?Content Like many Oracle users at the City of San Luis Obispo, California, I use Chrome fo… -
Customize Receivables aging seeded ReportSummary Customize Receivables aging seeded Report - to include Project information and grouping totalsContent Hi, We want to customize Receivables aging by General Ledge… -
Power BI and OBIEESummary How to create a connection between Oracle Cloud (FIN and/or SCM)?Content Hello, we would like to start using Microsoft Power BI for BI Reporting, instead of OTBI… -
Drill Down using Invoice NumberContent Hi, I have created analytical report which has Ledger Name, Supplier Name and Invoice Number When the invoice number is clicked i would like to drill down to tra… -
Cool new dashboard charts from Oracle Customer CareSummary Gain single page access to dozens of ERP resources!Content Check out these product specific Quick Link charts. These make navigating Oracle much easier! * To che… -
New OTBI Help Landing PageSummary Introducing a brand-new OTBI Help Landing PageContent This e-mail is sent by Oracle OTBI product management. Starting with Release 13.18.10, a brand-new OTBI Hel… -
A better way to navigate OracleSummary Use Customer Care Quick Link charts for an easy way to know what Oracle resources to use and when!Content For anyone not already aware, you can sign up (for free…
-
GL/SLA Account Analysis Report - Custom Spreadsheet Output FormatSummary Custom BIP template for the Account Analysis Report that displays GL/SLA journal line output in a spreadsheet format for easier searching and filteringContent * …
-
How to set the currency for an individual BI AnalysisSummary Instructions for ensuring that data is always displayed in the correct currency on your reports and dashboards.Content Unless otherwise specified in the analysis… -
A fresh environment with no dataSummary: A fresh environment with no data Content (required): Dear all, I would like to ask if a test or production instance can be refreshed, but not as p2t or t2t, so … -
In Cash Management OTBI, is it possible to get the transactions reconcilied to a statement line?Summary: On the Manual Reconciliation Cash Management page, it is possible to see which system transactions (AP, AR, etc) are reconciled to a given bank statement line. …
-
P2T Post Clone Tasks & Activities - ERP, EPM & PaaS/IaaS CustomerSummary: P2T Post Clone Tasks & Activities - ERP, EPM & PaaS/IaaS Customer Content (required): We are using ERP, EPM and PaaS/IaaS and we would like to know if there a d… -
In OTBI the table view window presented is too small. How to resizeSummary In OTBI the table view window presented is too small. How to resizeContent In OTBI the table view window presented is too small. How do I resize this preview win…
-
downloadESSJobExecutionDetails returns NULL when the ESS Job Output Size is more than 2GBSummary downloadESSJobExecutionDetails returns NULL when the ESS Job Output Size is more than 2GBContent Hi, We have an Integration built to send Oracle POET(Project,Org…
-
Projected Cash Balances with Selected Installment Report KitContent The Projected Cash Balances with Selected Installments sample report provides Public Sector Entities visibility into their Projected Cash Balances once a Payment…
-
Budgetary Control Purchase Order Life Cycle Custom ReportSummary Use this report to analyze a purchase order life cycle and its impact on budgetary control balances.Content The Budgetary Control Transaction Life Cycle report i…
-
White Paper | Using Seeded Data Extract Services for Oracle ERP Financial CloudSummary White Paper | Using Seeded Data Extract Services for Oracle ERP Financial CloudContent I come through this useful white paper and think it will be useful to shar… -
OTBI performance recommendations V2 paper (2679006.1) is available on MOS PortalSummary OTBI performance recommendations V2 doc is intended for OTBI system integrators, BI report developers and admins. It covers advanced performance tuning technique…
-
Add PDF Attachment to Email Bursting MethodSummary I want to attach a specific pdf file as an attachment to emails sent by a bursting methodContent I created a data model that looks at overdue invoices and produc…
-
Does Oracle Fusion Allow a Link to Microsoft Power BI?Summary I'm looking to see if Fusion would allow Microsoft Power BI to link to the Servers In Order to Build ReportsContent My company uses Microsoft Power BI for alot o…