Fusion Project reporting
Discussion List
-
Project Contracts Integration with Order ManagementSummary What is the standard Integration available between project contracts and order managementContent Hi, We have scenario where the customer enters a sales order aga… -
SQL for OTBI Analysis historyContent Does anyone know if there is a seeded report/analysis or SQL to pull the history of all OTBI analyses? We have a lot of old OTBI analyses that were created by fo…Mike Burnett 105 views 12 comments 4 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP -
Hyperlinking PO Number, AP Invoice Number on BI Publisher reportsSummary Hyperlinking PO Number, AP Invoice Number on BI Publisher reportsContent We have a BI Publisher report where we are showing Project profitability and showing all…User_2025-01-28-19-49-26-512 494 views 19 comments 2 points Most recent by alexey.shtrakhov Reporting and Analytics for ERP -
Budgetary Control Analysis Report (BCAR) amounts not matching with Project CostsSummary: Hi, We have a business requirement to create an obligations report to show the Budgetary Control Analysis Report (BCAR) obligation amounts and obligations from …
-
Need SQL Query for Project Custom ReportSummary: 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 …Awal 62 views 1 comment 0 points Most recent by Andreea Versanu-Oracle Reporting and Analytics for ERP
-
When using smartview for the projects Essbase cluster how to display description instead of IdsWhen using smartview for the projects Essbase cluster how to display Tasks_Dimensions or Resource_Dimensions with their description instead of their IDs There is no clea…Ivan Olivera-Oracle 11 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP -
I cannot see bursting enabled in batch scheduler in FRSSummary: I cannot see bursting enabled in batch scheduler in FRS Content (required): I created a batch and added two reports. Next I created a batch scheduler and added …ShitalRamteke 1 view 2 comments 0 points Most recent by Carlos Suarez Lopes Reporting and Analytics for ERP
-
PJB - billed quantity is blank in Invoice distribution tableSummary: Content (please ensure you mask any confidential information): In Application, For a project invoice for all Timecard EIs, all details are showing correctly in …
-
Tables to get the Project Budget by monthSummary: Can anyone help me with the details of the tables that have Project budget in PPM. I am looking for the budget data by month. Building a custom BIP report. Cont… -
Capture Financial Progress on a project - ETC and EAC CalculationsSummary: EAC amounts are getting changed when the capture progress is run multiple time for a period. For testing purposes, we booked cost for a project for the period D…
-
sql query to get COA segments for a project when event_id is NULL in xla_distribution_links tableSummary: There were some projects created in third party system and when the Fusion applications went on live, these projects were manually imported into Oracle. Kindly …Divya_Dammalapati 173 views 3 comments 0 points Most recent by Vivek Vishal-Oracle Project Management
-
Table name and column for award numberSummary Table name and column for award numberContent In EBS GMS_Awards_All has award number in fusion what is the corresponding table and column to get the value.
-
Privilege needed for task "Manage Mapping Sets: Project Costing"Summary Which Privileges or Project role is needed to Access SLA Task "Manage Mapping Sets: Project Costing"Content HI Team, We have one requirement where we have to giv…Rohit Kumar Singh 513 views 5 comments 0 points Most recent by Dustin Grabowski-Oracle Project Management
-
How to fetch Import errors for Project tasksSummary: Where Import errors for Project tasks will get stored .W e dont see them in PJF_OPEN_XFACE_REPORT table and PJF_TASK_ERRORS table after import run. Content (ple…Lakshmi Bandlamudi 191 views 7 comments 0 points Most recent by Venkat Patlola-Oracle Project Management
-
How to do query for Join between Project, Project Cost distribution and GL code combinationSummary: We require GL Code combination for project costing from project tables rather than creating a join between Project, subledger tables and GL tables. Content (ple…
-
Frequency of update in the Table - PJF_PROJECTS_COA_ALL_VL in PROJECT Segment of COASummary: In the COA set up the table (PJF_PROJECTS_COA_ALL_VL) under PROJECT segment It is defined as "When the Project is in Active status with Start Date the segment v…
-
How to restrict backdating the Expenditure Item Date?Summary: Business Case: Users can bypass Project holds by backdating the Expenditure Item Date on requisitions and PO change orders. When a project is marked as overbudg…
-
disable contract approvalHi Experts - Can I disable contracts for project billing ? My client does not need contract to be approved. Or can I do autoapproval ? -
How to enable change status button for project only if user is a project coordinator of projectSummary: Hi Oracle I want to show below button 'change status' only if the logged in user is the project coordinator for the project for which the user wants to change t…
-
Custom Import Project Budget Ess JobHi, In the Import Project Budget ESS Job, we have parameters for "From Project Name" and "To Project Name." However, the client requires "From Project Number" and "To Pr…
-
Extra blank page in the output from BI Publisher RTF template due to using page break to get multiBI Publisher - RTF Template Report Output - Extra Blank Page is getting generated at the end of the Output.Srini_Venkat 361 views 1 comment 1 point Most recent by Shankar-Oracle Reporting and Analytics for ERP
-
Fusion Financials Cloud: Project Cash Flow Detailed ReportOracle fusion cloud services There is a business requirement to get project cash flow statement, including all cash inflows and cash outflows: Receivables Received or no…
-
SQL Link between AP and Projects ?Summary: Report which shows project transaction that have flown through to AP Content (required): Hi Does anyone know the links/joins between AP and Projects, we are try…
-
Defaulting CIP Clearing Account in PPMSummary: Currently, in PPM, the CIP (Construction-in-Progress) Clearing Account is defaulted based on the Debit side account of the cost in the primary ledger. I’m inter…SanthiSreeK-Oracle 32 views 1 comment 0 points Most recent by Andreea Versanu-Oracle Project Management -
Planned Value Formula in Program ManagmentSummary: Hi, I need to understand the Formula that the system used to calculate the Planned Value in Program Managment, based on settings/inputs in below screenshots. No…
-
Project Costing (PPM) table where Invoice numbers stores.Summary Project Costing (PPM) table where Invoice numbers stores.Content Hi Gurus, I am in development of Project reports. I have to capture AP invoices details which ar…
-
Resource Breakdown Structure FBDI ValidationWhen Trying to generate the CSV file I get this validation message You cannot create multiple resources with the same format and resource values. meanwhile there's no du…
-
Sending Secondary Ledger Accounting (Clearing Account) from PPM to Corporate Book in AssetsSummary: I have a question regarding secondary ledger accounting in Oracle PPM. Is it possible to send secondary ledger accounting entries, specifically the clearing acc…SanthiSreeK-Oracle 11 views 1 comment 0 points Most recent by Andreea Versanu-Oracle Project Management
-
Do we have a seeded report we can run for the approval rules under Projects Module.We wanted to check if there are seeded report with regards to extracting the approval rules for the Projects Module? As for the GL, there is a readily available report t…Gene Garcia 11 views 1 comment 0 points Most recent by Vinodhini Vobhilineni-Oracle Project Management
-
Project executionProject execution