Sample Reports
Discussion List
-
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… -
Custom LOV based on two inputs in Value setsSummary: Hi All, We have a requirement where we have to create 3 DFFs which will have LOVs depends on each other. These values are custom ones which we have to create th…L.G.M Manikanta 15 views 2 comments 0 points Most recent by L.G.M Manikanta Fusion Applications Administration
-
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 22 views 3 comments 0 points Most recent by Lakshmi Bandlamudi Project Management
-
Query for Projects, Subledger and General LedgerSummary: Query for Projects, Subledger and General Ledger Content (required): Hello I was wondering if you can share with me any Query for Projects, Subledger and Genera…
-
Resource that is set in RBS is not able to appear in Smart View.Resource that is set in RBS is not able to appear in Smart View. I set new resource for Expenditure Category, Organization and Expenditure Type in order to varify if it …
-
Where to find Warning limit and Error limit for the fusion tablesSummary: Greetings of the day.. Please share the information where we can find Warning limit and Error limit for the fusion tables Content (please ensure you mask any co…
-
customer required a report to fetch resources dataHi Everyone, we have a requirement to create a report to fetch details of resources who are working in a project for more than 24 months for a client. Can anyone share t… -
-
Approach to retrieve the value "5000009" from the string 01-4211002-00000000-0000-CH10-0000-5001044-Summary: I used the below, but it is giving syntax error. Can some one please assist and provide me corrected query SUBSTRING( "GL Account"."Concatenated Segments", LOCA… -
Sample Report: Project Financial Management Cloud: Project Budget vs. ActualSummary This dashboard displays Budget details for a specific project.Content The attached sample dashboard displays budget vs. actual cost and commitment details for a …Dustin Grabowski-Oracle 936 views 21 comments 11 points Most recent by aileen.joy.g.arcilla Project Management -
OTBI Reports CalculationSummary: Hello, We have resource assignment report and our aim is to join Project Resource Assignment and Worker Assignment, in order to calculate each employee ‘s proje… -
Project CostingSummary Project CostingContent 1. How do you Transfer Cost from one project to the next? 2. how to split cost from one project to multiple? 3. How to correct duplicate l…
-
What is the purpose of Organization Credits in an Award ?Content Hi What is the purpose of Organization Credits in an Award ? Does it have any relation with Internal Funding Source ? If I have Cost Share internal funding sourc…Anandhan Erulappan-160556 56 views 3 comments 0 points Most recent by Nishant Agarwal Project Management
-
Did you know? Use OTBI to view period close exceptionsSummary Sample dashboard that gives you an overview of your accounting period close exceptions Content The attached sample dashboard gives you an overview of your accoun…Prithi Bandla-Oracle 61 views 5 comments 1 point Most recent by Marcelo Cardoso Project Management Resource Center -
Project Cost Budget BreakoutSummary: Project Cost Budget Breakout Content (please ensure you mask any confidential information): How can I get the breakout of what makes up the Cost Budget? Which r…
-
Project Budget Cost vs ActualSummary: Project Budget Cost vs Actual Content (required): What would cause a Project Budget carry forward cost to reflect a change than what was reflected at the beginn…
-
query to retrieve expenditure type linked to a project, task and organizationSummary: I need to extract the expenditure type linked to a specific project, task and organization (cost center). How can I build this query? Any suggestion? Content (r…Giuseppe Galluzzo 2K views 14 comments 0 points Most recent by Dustin Grabowski-Oracle Project Management
-
How to derive only accounted PPM cost transactions from backend tables?Hi, We have a requirement to derive only accounted project cost transactions by creating custom BIP report. Currently I am using pjc_cost_dist_lines_all table in my quer…Ankit_Bhadja 31 views 1 comment 0 points Most recent by Vinodhini Vobhilineni-Oracle Project Management -
PPM Contracts - How to setup new roles on the Parties LOV tab ?Summary: PPM Contracts - How to setup new roles on the Parties LOV tab ? Content (required): Hello We have the contracts module and on the parties tab , there are only t…
-
OTBI-Expense-Expense Transactions - SQL to Link Expense and PPM ?Summary: OTBI-Expense - Expense Transactions - SQL to Link Expense and PPM Content (required): Hello I have an OTBI report with the subject area Expense-Expense Transact…Cesar Saveedra 41 views 1 comment 0 points Most recent by Vinodhini Vobhilineni-Oracle Project Management
-
Can we extract import project errors using custom BIP report?Hi, We are using FBDI to import projects in Oracle PPM Cloud. As per our observation, projects interface table PJF_PROJECTS_ALL_XFACE is getting purged automatically onc…
-
Better approach to follow in loading manpower or salary costsSummary: Which is the better approach to follow when HCM is not used a) Uploading salary costs to the General Ledger (GL) and subsequently uploading them as costed trans…
-
EPS element by delegate/EPS element by owner analysis not displaying hierarchy dataSummary: After Creating EPS element assigning delegate and assigning projects under it, when we run the EPS element by delegate/EPS element by owner analysis- these do n…
-
Custom Report example for PPM Allocations ?Summary: Custom Report for PPM Allocations ? Content (required): Hello I would like to create a custom report for PPM Allocations, will you please share with me the tabl…Cesar Saveedra 32 views 1 comment 0 points Most recent by Shivashish Dwivedi-Oracle Project Management
-
Infolet for Percentage of work complete and amount billedSummary: We have a requirement from the customer that they want to see the percentage of work that is complete (Method can be either cost/effort/manual) and how much amo…
-
Grants standard reports don't show up in FRCSummary: I am able to see the Awards reports in Reports and Analytics but not in Financial Reporting Center Content (required): Grants Management sample reports that can…
-
Table name and column for Projects To ProcurementSummary Table name and column for Projects To ProcurementContent Hi Champs, what could be possible Table name and column for Projects To Procurement and payables or any …
-
Project Report focused on people project historySummary: Content (required): Hi team, I'm an HCM consultant so I have no experience about ERP - Project, sorry in advantage if I will say something not correct. A client…Gabriele Falso-Oracle 32 views 5 comments 0 points Most recent by Andy May-Coates-Oracle Project Management -
Project Labor Cost Transactions InterfaceSummary: Project Labor Cost Transactions Interface FBDI import template Content (required): Where on the template does the Project Classification (category and class)is …
-
Exception reporting for projects with no baselined budgetContent We are trying to create a report that will list any projects that do not have a baselined budget. I have been able to get so far in OTBI using 'Project Control -…