Fusion Project reporting
Discussion List
-
How to ensure we don't miss generating revenue?Summary: We have fixed fee/milestone and cost reimbursed invoices. Due to the design of Oracle we must run Generate Revenue by project to ensure the correct dates are in… -
Table or SQL queries for getting Project number along witht Expense report number ?Summary: Hi Team, Can anyone please let us know the table or SQL queries for getting Project number along witht Expense report number ?. Need to connect table PJF_PROJEC…
-
How to get the Unplanned Resources that appears in budgetI have created an analysis that shows the unplanned resources, but the actual costs and commitments don't match what appears on budget what could be the reason for this ?Mohamed Abdelbar 11 views 1 comment 0 points Most recent by Daniela Crisan-Support-Oracle Project Management
-
PJC_COMMITMENT_TXNS.TRANSACTION_SOURCE_IDSummary: PJC_COMMITMENT_TXNS.TRANSACTION_SOURCE_ID Content (please ensure you mask any confidential information): I am looking at column TRANSACTION_SOURCE_ID in PJC_COM… -
Project Loss AccountingHi All, Could please anyone tell us the project loss accounting handling process in the fusion PPM. Regards, Ajit
-
Manage Project UnitHi All, Thanks in Advance !!!! Could you please help us understand significance and impact of Project Unit structure design Currently the Ent structure is One legal enti…
-
Oracle Business Process ManagementHello Team, We have a business requirement to report on the Project Adjustment BPM approval routing. To Achieve this requirement, we are trying to establish link from fa…
-
Need Physical % Complete - Decimal with 5 digits - Project Port Folio ManagementSummary: Currently, Physical Percent Complete (%) is showing with 2 digit decimal Value. Need to increase the decimal value upto 5 digits. Content (please ensure you mas… -
Can we change the Project Organization Hierarchy TypesHi All, Could you please tell us, can we change the Organization Hierarchy type at any point of time. Ex: currently we are using the "HCM Organization Hierarchy Tree Str…
-
Query for Projects, Subledger and General Ledger - RevenueSummary: I have a similar issue to this post; - https://community.oracle.com/customerconnect/discussion/660682/query-for-projects-subledger-and-general-ledger But I am l…
-
Roles for changing of Project OrganizationsSummary Roles for changing of Project OrganizationsContent Good Day, Kindly advise how to correctly create a specific user account / role for a Project Administrator. We…User_2025-01-30-04-45-54-197 115 views 6 comments 0 points Most recent by Dustin Grabowski-Oracle Project Management -
Can We Set an approval Based Upon Project TypeHi All, Thanks in Advance!! Could you please let us know Can we implement the project approvals based upon the project types. We have a requirement where client wants ap…Ajit Samendla 21 views 1 comment 0 points Most recent by Vinodhini Vobhilineni-Oracle Project Management
-
how to get the budget revenue from contractI'm using the Revenue Generation Method Contract revenue classification method in Budget generation options , meanwhile no revenue amounts appear what could be the appro…
-
Hi, Can we deploy a sandbox during Business hours/days or we do this only during the weekend?Summary: Can we do a Sandbox deployment during Business hours/days or this should only be done during weekends for PROD? Content (please ensure you mask any confidential…
-
Is it Possible to Crate a Contract With Multiple currenciesSummary: We have a requirement where customer wants to create a PPM Contract (Enterprise Contract) with multiple lines and each line currency should be different. Please…
-
How would be migration of ongoing projects, some are invoiced and recognized revenueHi All, Customer wants to migrate the On going projects and those were invoiced and recognized revenue and they to see the invoiced amount and revenue recoginized amount…
-
Is it Possible Bill Plan is Amount Based and Revenue Will be on ProgressHi All, Thanks in Advance!! We have a requirement where client wants to do the billing on amount based where as they will generate the revenue on percentage completion/p…
-
Is it possible to change the Project OrganizationCould you please let us know is it possible to change the project organization after certain period. If yes please let us know the steps to achieve this. Regards, Ajit
-
TIP: Dynamic deep links / drilldowns on BIP report. Relative deeplink path.Summary: You can use this trick to make your deeplinks working without instance hardcoding and make them working also on email templates and e.g. excel extracts. Content…alexey.shtrakhov 716 views 3 comments 3 points Most recent by alexey.shtrakhov Reporting and Analytics for ERP -
API for Project Resource creation on Project PlanWe want to create resource at the Project level based on the structure specified on the Planning and resource breakdown structure and linked to the Project. Have you use…
-
When PJF_OPEN_XFACE_REPORT table gets purged? Is there a setup to control the same?Hi, We have a requirement to automate a Projects creation via FBDI using inetgartion. As part of error handling we found that even though interface table data gets purge… -
project transaction source setup with wrong expenditure type classSummary: We have a payroll system that we setup as a project transaction source, but we are running into issues changing the expenditure type class to accurately reflect… -
What is the table name that stores the data for the Review Project Performance screen?Summary: Since Review Project Performance screen is apparently independent from many of the tables used in OTBI reporting, is there a subject area or table that can be u… -
How to See Projects with Current StatusesSummary: Hi All, we would like to see the All the projects with current statuses or with given parameter. Could you please let us know how to check this.Ajit Samendla 11 views 2 comments 0 points Most recent by Dustin Grabowski-Oracle Project Management
-
What Process Populates the Projects Essbase Cube?Summary: What process should be run to initially populate the essbase cube and/or keep it updated and what parameters should be used? Content (please ensure you mask any…
-
How to export csv file for Import Jounals with OTBI.Summary: Do you know how to export csv file for Import Jounals with OTBI? I tried to create OTBI report like the following. It is used Project Costing - Actual Costs Rea…
-
How to send Project details to GLSummary: Hi All, We have a requirement from client where we do not have a project segment at COA but in GL they want see the project/task related information. Please let…
-
Burden Costs details PrivilegesSummary: Content (please ensure you mask any confidential information): This is the only functionality we want the user to have But this also gives access to this setup …
-
MOAC Priv Name cannot be null; Initialize MOAC errorSummary: MOAC Priv Name cannot be null; Initialize MOAC error Content (please ensure you mask any confidential information): I duplicated the job Create Accounting for P…
-
Reporting subledger modules to GL with transaction detailSummary: We're looking for a report that provides information from subledgers into the GL in an Excel like format. For example, we need the project number, expenditure t…Kristen Shimkus 41 views 3 comments 0 points Most recent by Rich Merkel Reporting and Analytics for ERP