Fusion Project reporting
Discussion List
-
SQL Query for Project Budget InformationSummary: Hi Please help us to answer the table and the column for this project budget information (all project not specific project): Version Status Project Number Task … -
OTBI report on Project analysisSummary OTBI report on Project analysisContent Hi Experts, I am creating OTBI report on project analysis. I got all the columns in work area. Now need to add one column … -
Unable to map from job to to job in manage job mappingsWe have a custom report to calculate direct, overhead, g&a, profit. For this calculation I need to derive from job name from the to job name of project invoice lines. Un… -
MSP Integration for Project Budgets and Project ForecastsSummary: Has anyone in your implementations used MSP to create, plan, manage and maintain projects budgets and project forecasts and use the MSP Integration to push the …Raj Mohanraju FRNT 11 views 1 comment 0 points Most recent by Clara Azoitei-Support-Oracle Project Management -
Extracting data from project management pvos and linking them to build an external reporting model.I need to extract data out through Project PVO's in order to fullfil an external reporting requirement. I am trying to find the PVO to bring below information together a… -
How to move Project Sub-Task to another Parent-TaskWe have business requirement where As part of the new task restructuring for projects module, we need to move subtasks from one parent to another. We were able to update… -
Need to create project revenue OTBI report with 'Revenue in Ledger Currency' attributeSummary: We have a requirement to create an OTBI report to retrieve all the Revenue Distributions in Project Billing. Specifically, we're looking to include details such…Vinodhini Vobhilineni-Oracle 11 views 2 comments 0 points Most recent by Vinodhini Vobhilineni-Oracle Project Management -
Project Costing - Actual Costs Real Time: want to summarize totals by GL expense accountSummary: Project Costing - Actual Costs Real Time: want to summarize totals by GL expense account. The subject area itself includes fields like Natural Account, Concaten… -
fusion project funding pattern tablesHi There, Does anyone know how to query via DB existing funding patterns? We need to give list of funding patterns converted (using REST call) to client. Thanks in advan… -
Reqirement to calculate EAC and ETC using custom Calculation methodSummary: Client wants to calculate EAC and ETC using a custom Calculation method can this be achieved using the Manage Performance Measures task else any possbile way of… -
BIP Report path for "Project Program Status Summary Generation"Team, As per the link provided below, we suppose to Add the Program Executive Update catalog item to report template to generate comprehensive. But unable to figure out …Thanigainathan R 4 views 1 comment 0 points Most recent by JyotiPrasadDash-Oracle Project Management -
What table holds the synchronize Task Transaction Dates with Planned DatesSummary: I want to know the table that holds the Use Task Planned Dates as Task Assignment Dates, Automatically Roll up task planned dates, and synchronize Task Transact… -
How to Handle Billing for prepaid Awards in Grants Management ?For the Grants which were prepaid/money received, we told the customer to create a Receipt in AR, and account it. Once the client started incurring cost on it, we told t… -
Is there any connection link to pull data from PPM via SmartView ?Summary: We have a requirement to pull awards and other project-related details from the PPM dashboard via SmartView. Wanted to check if there is a connection link to pu… -
PPM Manage project status - Status classification tableSummary: Hi All, I have noticed a discrepancy between the project screen status and the backend table status. On the project screen, the status code is displayed as DRAF… -
'Assets' Icon is not showing under 'Projects' Work are on Home pageSummary 'Assets' Icon is not showing under 'Projects' Work are on Home page but in Navigator , it is showing under 'Projects'Content Hi Team, 'Assets' Icon is not showin… -
Can you add a project number to a contract event after it's been billed?Summary: We've identified that we should have included the project number when creating an event for a contract to allow us to report through Fusion Data Intelligence (F… -
COGS matching with RevenueHello, We are doing billing using a Project billing solution without having an order management module in scope. The cost will be accumulated on the Projects from variou… -
How do we find the PVO of these tables(PJF_PROJ_ELEMENTS_B TASK, PJF_PROJ_ELEMENTS_TL PPETL)?Summary: MTIA PO and PO Value in ERP - The columns above highlighted are present in the one of the base tables PJF_PROJ_ELEMENTS_B TASK, PJF_PROJ_ELEMENTS_TL PPETL as pe…Rasagna Repaka-Oracle 103 views 9 comments 0 points Most recent by Neha Jha-Oracle Project Management -
How can we manage the Burn rate indicators / KPI values on Awards overview screen.Summary: Can we manage the Indicators that are shown on the Award overview screens against the associated project ? Indicators against the Available amount on Awards ove… -
Query or Table for Budgetary Control Settings under Manage Financial Plan TypesSummary: Hi Team, We need a Query or Table for Budgetary Control Settings to get below fields under Manage Financial Plan Types. Content (please ensure you mask any conf… -
Clarification on Impact of Removing Standard Project Manager RoleSummary: I wanted to check the impact of removing the standard Project Manager role when we are not using Project Execution Management. Since we already have other roles… -
Billing Dashboard OTBI AnalysisSummary: Can one of you share the OTBI Analysis shown in screenshots in new feature (23B) documentation (link below) ? Content (please ensure you mask any confidential i… -
How to Debug and Track Burden Cost Generation in Oracle Fusion ProjectsSummary: I am looking for insights on debugging burden cost generation in Oracle Fusion. Specifically, I would like to understand which costs contribute to burden calcul… -
Invoice Exceeding PO Amount Not Reflecting in Project Costs – Missing Validation & Costing ImpactSummary: We have a scenario where an invoice is being created against a Purchase Order (PO) with an original amount of 1,000 and a 12% non-recoverable tax, bringing the … -
Is there any project level chat option available to chat with team members?Summary: Is there any project level chat option available to chat with team members? Content (required): Version (include the version you are using, if applicable): 23A … -
PVO and Oracle Base Table for Project approvalsSummary: We have approval hierarchies enabled for Projects Module, for that to reflect in BI report we need related PVO & Base table which I am not able to find it anywh…User_7DZID 11 views 2 comments 0 points Most recent by sambasivarao kosuri-Oracle Project Management -
Project Manager role to restrict access to purchasing data for own projects onlySummary: Project managers should only be able to view purchase orders, requisitions and AP invoices for the projects that they are assigned to as a project manager. Can … -
Need a SQL Query to fetch Inception to date Budget Amount from Oracle Grants Management AwardsSummary: Hi, I need to fetch Inception to date Budget Amount for each funding source from Awards screen that is under Awards → Award Details → Project Financial Details … -
Securing purchase order-, purchase requisition- and supplier invoice details by projectSince the project commitment and project cost subject areas do not provide all required purchase order/requisition and supplier invoice details, project managers of our …