Fusion Project reporting
Discussion List
-
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… -
sql query to get COA segments for a project when event_id is NULL in xla_distribution_links tableSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
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…
-
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…
-
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 26 views 1 comment 0 points Most recent by Andreea Versanu-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.
-
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…
-
Assigning a Single Asset to Multiple Projects in Oracle Fusion – Is It Possible?Summary: From a business perspective, projects may share resources or jointly fund a single asset. However, Oracle Fusion typically aligns one asset with one project tas…SanthiSreeK-Oracle 32 views 4 comments 0 points Most recent by SanthiSreeK-Oracle Project Management
-
Create OTBI Report for Project with it's Expenditure Type and costSummary: Title: How to Create an OTBI Report in below Table Format for Projects Hello Oracle Community, I’m looking to create an OTBI (Oracle Transactional Business Inte…Karthik Selvaraj 11 views 1 comment 0 points Most recent by sambasivarao kosuri-Oracle Project Management
-
Primary Flag - Project Manager - Oracle Fusion TableSummary: Which Oracle table contains information for Project Manager - Primary Flag. Content (please ensure you mask any confidential information): We are trying to mode…
-
fbdi project managerHi Experts How to update project manager for many projects in bulk ? Is there any FBDI process ?
-
Need a query to get the GL ACCOUNT details from manage project costs pageSummary: Hi All, I need a query to get the GL ACCOUNT details from the manage project costs → View accounting page. below is the screenshot of where I need the data. Con…
-
PPM Project Budget, Actual and Commitment table in FusionSummary: In EBS we were using the below tables and Columns to get the Budget, Actual and Commitment Amounts. PA_PROJECT_ACCUM_BUDGETS --> BASE_BURDENED_COST_TOT PA_PROJE…