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 …
-
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 …
-
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…
-
Smart View for Project Performance - Guidance for Understanding DimensionsSummary: Trying to create a Smart View report for Project Performance but struggling to understand why some dimensions don't work - looking for any documentation that ca…
-
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 41 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 299 views 5 comments 0 points Most recent by Dustin Grabowski-Oracle Project Management
-
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…
-
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 44 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…
-
How can we trigger alert or notification when new projects createdSummary: How can we trigger alert or notification when new projects created. Content (please ensure you mask any confidential information): Hi All, Is it possible to cre…
-
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 24 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
-
The format of PersonName in Get all team members for a projectSummary: What is the format of PersonName in Get all team members for a project REST web service? Is this dependent on user's setup or is it a fixed format of [First Nam…
-
Borrowed and Lent ReportingSummary: I have a customer that has migrated from EBS, in EBS they used a process called EBS : AUD_ Cross Charge Audit Report to report on borrowed and lent charges. Doe…Maria Smith- de Novo Solutions 9 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Project Management
-
The RBS list shows no RBS in the project templateWhile creating a new template I can't get the RBS that I have defined , only the default one exists what could be the reason for this ?
-
URGENT! Project level plan not workingSummary: Hi Team, We had planning level at project. We have two types of expenditures - cost and revenue Please find the below example IT expenses expenditure type has r…
-
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…