Fusion Project reporting
Discussion List
-
Audit on Task UpdatesI saw a few old threads in the community about Audit functionality not being available in PPM. Is this still the case, I am not able to see any release information that … -
Is there an attribute in PPM that shows the Return on Investment (ROI) of a Project or Program?Summary: In Project Performance or Program Analisys or OTBI, is there a collumn that represents the return of investiments? I didn't find this field. ROI = (Gain from In…Wilromar Benevides 31 views 2 comments 0 points Most recent by Wilromar Benevides Project Management -
AP Aging reportSummary AP Aging reportContent Is there a standard AP Aging report available online? We were advised that the AP Aging report in Oracle can only be run on the current da…
-
Current year + 2 as filter in columnSummary: Content (required): Hi I would like to show the forecast for 2 years from now for a specific column. For example in the code below I've used a repository variab…Nicolas Vahman 21 views 2 comments 0 points Most recent by Amrita Gupta-Oracle Reporting and Analytics for ERP
-
Do we latest SF-425 with expiry date : 02/28/2025 available?Summary: Do we latest SF-425 with expiry date : 02/28/2025 available? Currently SF-425 from 20D has expired in02/08/2022? Do we know when the latest form with updated ex… -
DFF not available in Subject area even after running the specified processSummary: We have created an OTBI report for Projects using Project Cost - Actual Real Time subject area and it includes a couple of DFFs. This report was migrated from o…Abhishek Shukla 1K views 7 comments 0 points Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP -
Is it possible to add a KPI for Actual Cost/ Budgeted Cost Value?Summary: Hi, I want to add a KPI on my project for Actual Cost/ Budgeted Cost Value. How do I add it? I have tried couple of options but none are giving me the desired r…
-
PSL to GL ReconciliationIf there is a reconciliation difference between Project Subledger Costs and General Ledger because of Revaluation, is there any way to bring PSL amount to match with GL?…
-
Fusion table to get data from Project UnitsSummary: We are creating the BI report to get master data like project unit organization’s code, project unit name. Unable to find the table to get the project unit orga…Suresh India-Oracle 885 views 2 comments 0 points Most recent by Suresh India-Oracle Project Management -
Unable to locate Direct SQL option after upgrade 19ASummary Unable to locate Direct SQL option after upgrade 19AContent HI, I'm not able to location the Direct SQL option after upgrade the 19A. Can anybody suggest where w…Suresh Kumarasamy-Oracle 85 views 10 comments 2 points Most recent by Shyam Patel Reporting and Analytics for ERP -
Fixed column for year and other columns are promptedSummary: Content (required): Hi all I would like to know if it is possible to have one fixed column which always shows the forecast for e.g. 2022 while other columns are…Nicolas Vahman 41 views 3 comments 0 points Most recent by Amrita Gupta-Oracle Reporting and Analytics for ERP
-
Did You Know? Change CFDA to Assistance Listing Numbers with the User Interface Text ToolSummary: There are several options available to change text within the Oracle cloud applications. This article describes how to utilize the User Interface Text tool with…Devon Dorch-Oracle 81 views 4 comments 2 points Most recent by Devon Dorch-Oracle Project Management Resource Center -
How to Create a CustomRrole Which Will Be Masking Of Rates And Labor Cost AmountsSummary: How to Create a CustomRrole Which Will Be Masking Of Rates And Labor Cost Amounts Content (required): I did remove the 'View Project Labor Costs' privilege from…
-
How to populate 'Financial Physical Percent Complete' ?Summary: We do not maintain planned costs on 'Project Plan'. The amounts are directly entered in the budget and the financial project plan is used only for maintaining c…
-
How to create a list of projects linked to ContractsSummary: We need a list of all projects and their links to Contracts. Similar to this overview for one project: Content (required): Version (include the version you are …
-
Funds Available for Project BudgetsSummary: Content (required): Our client needs to be able to report on funds available for their Project Budgets. We are not enabling Budgetary Control for Project Budget…
-
Award Project amountsSummary: Award Project amounts Content (required): Can you please help me with table name or query to extract amount on Manage Award --> Open award --> Financial Perform…Nidhi Chhajed 11 views 1 comment 0 points Most recent by Amrita Gupta-Oracle Reporting and Analytics for ERP
-
Report for project related transactions from GLSummary: Report for project related transactions from GL Content (required): Could you pleas suggest for all the project related transactions we will able to extract dat…
-
Impact of PPM w.r.t changes in COA structureSummary: Impact of PPM w.r.t changes in COA structure Content (required): Hi Team, What will be the impact in PPM area , if there is a change in COA structure. I mean Pr…
-
Need Budget and Forecast Report in Bulk loadSummary: Need Budget and Forecast Report in Bulk load Content (required): Hi All, I am working on a integration where I am loading both budget and forecast data using in…
-
Is there a report or analisys for historical percent complete on Project management?Summary: Customer is asking for a report that shows the evolution of Actual Percent Complete of Project Plan on Project Management and compare with Target Percent comple…Wilromar Benevides 11 views 2 comments 0 points Most recent by Wilromar Benevides Project Management
-
Use cases for billing offsetsSummary Use cases for billing offsetsContent Please can you share your experiences in implementing billing offsets in project billing? Any specific use cases will be ext…User_2025-02-05-23-22-49-102 57 views 4 comments 0 points Most recent by Bo Tøpgaard Project Management -
Import Project ErrorHi Experts, Import projects are failing and showing error message "Some team members weren't copied to the new project because of a validation failure" I have checked th…
-
Access OTBI Data without Job RolesSummary For OTBI Administrators - Is there a way to access Data as a Super User without getting a specific Job Role assigned?Content Hey Guys, We were checking to see if…User_2025-01-30-04-49-10-284 127 views 4 comments 0 points Most recent by IIGC Reporting and Analytics for ERP
-
OTBI Subject Area to fetch Employee Rates in Manage Rate SchedulesSummary: Hi all, Could someone help me get a OTBI Subject Area to fetch Employee Rates defined in Manage Rate Schedules ? Content (required): Version (include the versio…Anandhan Erulappn 71 views 2 comments 0 points Most recent by Andy May-Coates-Oracle Project Management
-
BI Publisher Output File NameSummary BI Publisher output file name Suffixes Template/Layout NameContent BI Publisher report output file from Oracle Fusion cloud suffixes the Template/Layout name at …Senthilrajan V 165 views 12 comments 2 points Most recent by Ravi Tilekar Reporting and Analytics for ERP -
How to generate automatic accruals in PPM ? Project Contract and FinanancialSummary How to generate automatic accruals in PPM ? Project Contract and Finanancial Content Hello . I was wondering if there is an automatic process to generate a Sales…gabriel kinovisques-163562 60 views 2 comments 0 points Most recent by Michele Cursio Project Management
-
Need to push output files of the job Import Project Budgets through SFTP.Summary: Content (required): The issue can be reproduced with the following steps: Step1: We are scheduling the Import Project Budgets job. This is a seeded processes. S…Lokesh Senthilnathan 3 views 0 comments 0 points Started by Lokesh Senthilnathan Reporting and Analytics for ERP
-
How to link more than one LE to a ProjectThe requirement is to link a Project to more than one LE having the same ledger. For example, a Marketing campaign in the EU will conduct certain programs in different E…
-
PO Spend Analysis in one currency (USD or Ledger Currency)Summary: PO Spend Analysis in one currency (USD or Ledger Currency) Content (required): We are using Oracle provided Analysis: PO Spend by Top Category We found that the…