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
-
Unable to find invoice validation status through BIP sqlSummary Unable to find invoice validation status through BIP sqlContent We are not bale find invoice validation status through BIP sql by using AP_INVOICE_ALL. Will be a… -
how to get the GL balances for a UOMSummary we are trying to build FRS or essbase adhoc report , we using the mixed currency journal to enter actual and stat journal all together but UOM is not presented i… -
How to show the grand total with group by option ?Summary How to show the grand total with group by option ?Content Can you please help us how to show the grand totals with group by option. I am trying to bring the repo…
-
Expense Report AnalysisSummary We are trying to improve our reporting on expense reports and add additional fields in our reportsContent We are trying to improve our analysis on expense report… -
Revoke Roles in Security Console R12 Still Showing Assigned in BI ReportSummary Since R12 upgrade revoking roles in Security Console, the revoked users' roles still appear to be assigned in our existing custom BI report (SQL below)Content In… -
Multiple Pillar Oracle Cloud implementation whitepaperSummary Leading implementation and configuration best practices for multiple pillar Oracle Cloud ERP implementations Content We have all heard the adage "A chain is onl… -
Automated Test script execution for Cloud SaaS applicationsSummary Automated Test script execution for Cloud SaaS applicationsContent Hi all, I posted this in Integrations track but didn't get a response, hoping someone can prov… -
fixed assetsSummary Cannot find reporting that shows assets with adjustted cost basisContent From fixed assets module, I'm generally using the Journal Entry Reserve Report to query …User_2025-01-29-20-33-47-986 62 views 0 comments 1 point Most recent by User_2025-01-29-20-33-47-986
-
OTBI Edit and Creation of new report Missing After Patch releaseSummary OTBI Edit and Creation of new report Missing After Patch releaseContent We just took the monthly patch this weekend and certain users, General Accountants and Fi…
-
Financial Data ExtractsSummary Extract Mode : Register custom enterprise scheduler jobContent How to leverage 'Generate Data File for Export' by executing in "Register custom enterprise schedu… -
Subject Areas and Roles - R12Content Can anyone point me in the direction of some documentation which shows which Roles can access which Subject Areas across ERP for Fusion R12? Thanks Dean WillifordUser_2025-01-29-00-51-37-288 87 views 4 comments 0 points Most recent by Venkateswarlu Yenuganti-23335
-
How to update the New Analysis querySummary How to update the New Analysis queryContent How to update the New Analysis query from advanced tab with other operator functions/Group by function
-
How to change the Costs Column for periodsSummary How to change the Costs Column for periodsContent Hi, I have a requirement to show the Budget and Actual costs with figures for month on month basis. So kindly g…
-
Standard Financial DashboardsSummary Need to create some basic Financials Dashboards, which gives a clarity over Company Financial HealthContent Hi All, I have implemented Oracle Financials Cloud fo…User_2025-01-29-20-34-14-699 165 views 2 comments 0 points Most recent by Farooq Syed, CPA, PMP, CISA, TOGAF
-
Fusion R12 Upgrade -BI | Icons appearing as dots ( . )Summary After upgrading to R12 Fusion, the BI icons like "Add" (+) and "Delete"(x) are appearing as dots (.)Content After upgrading to R12 fuion, the icons like "Add" (+…
-
Actual Cost is showing 0 in Project OTBI reports after R12 upgradeSummary Actual Cost is showing 0 in Project OTBI reports after R12 upgradeContent Hi, We are facing an issue like Actual costs are showing '0' for Project Analytics (OTB…
-
Order Type Column in DOO Subject AreasSummary Searching for 'ORDER TYPE' column in DOO-Fullfillment real-time SAContent Hi All , Someone can help to find ORDER TYPE column in DOO fulfillment Real-time SA , T…
-
Rescheduled - ERP - Cloud Cafe September 2017: Are You Ready For R13? -- September 20, 2017, 9 a.m.Content Due to some unforeseen circumstances, this event has been rescheduled for a later date. Apologies for the inconvenience. The updated date will be posted with the…
-
Changing the report logo based on the journal entry selected legal entitySummary Changing the report logo based on the journal entry selected legal entityContent Hello, we have managed to add a new button on Oracle financial GL, AR and AP tra… -
Project Portfolio Management Cloud OTBI Release 13: Subject Area Description DocumentSummary This document provides a comprehensive description of each subject area including the key business questions that can be answered using the same.Content Use this…
-
R13: Project Portfolio Management Cloud OTBI: Subject Areas to Database Tables Mapping SpreadsheetSummary The spreadsheet provides a mapping of the BI Subject Area columns to source database tables and columns. It also has the View Object (VO) names for each column. …
-
OTBI Report - Payment Document CountSummary CFO is requesting a report that will show the number of ACH/CHECK/WIRE PaymentsContent Hello All, I am trying to build a report that will show the amounts of che…User_2025-01-28-19-14-07-225 166 views 4 comments 0 points Most recent by User_2025-01-28-19-14-07-225
-
Managing Events ProfitabilitySummary Managing Events ProfitabilityContent we are using Oracle Fusion financials, procurement and inventory management to manage our daily transactions. in our line of…
-
Program or Portfolio Level ReportingSummary Project Portfolio Reporting in ERP Projects CloudContent Hi, We have a requirement to produce a Portfolio or Program level reporting from Project Costing Cloud, …
-
How to make the Graph OTBI ReportSummary How to make the Graph OTBI Report with feature drill down to applicationContent Hi, We have require to prepare the OTBI graph report with the feature drill down …
-
R12 Asset Subject AreaSummary Does anyone use the 2 new subject area for reporting purposeContent In Release 12, there is only 2 subject area in Asset. Does anyone use these 2 subject area to…User_2025-01-29-00-39-52-080 56 views 6 comments 1 point Most recent by User_2025-01-29-00-39-52-080
-
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… -
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…
-
Adding and embedding BI content into Fusion Cloud ApplicationsSummary Looking for guidelines on which Fusion Cloud Applications pages we can add or embed BI content intoContent Hi All, Our client wants to be able to add some BI con…
-
FTP a FR studio report to run on monthly basis with previous month as parameterSummary FTP a FR studio report to run on monthly basis with previous month as parameterContent We have two custom FR Studio (Financial Reporting Studio) reports that we …