Reports
Discussion List
-
Project invoice table to subledger table joinSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):KOTTHURI ASHOKBABU 11 views 1 comment 0 points Most recent by Pradeep Balakrishnan Project Management
-
Project to GL Reconciliation ReportCan you confirm if there is an existing Project to GL Reconciliation Report? We are trying to check if there is a counterpart for Projects. Sample is attached screenshot…Gene Garcia 11 views 1 comment 0 points Most recent by Vinodhini Vobhilineni-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
-
Ledger is not showing in LOV in 'Create Accounting for Projects' ESS JobSummary Ledger is not showing in LOV in 'Create Accounting for Projects' ESS JobContent User is not able to select Ledger from LOV in 'Create Accounting for Projects' ES…
-
Add DFF on Project LevelIs there anyway to add an additional DFF on the Project Level , Like Project Overview Page or Project Setttings i need to add a free Text field on the Project Level and …Ali Essam El-Bandrawy 11 views 1 comment 0 points Most recent by Simon Ball-Oracle Project Management
-
CIP Account Dashboard - includes transactions which have been transferred to FASummary: How can I in Projects see a specified list of all CIP transations, which are NOT transferred to FA? As I see the CIP Account Dashboard or CIP Account Analysis r…
-
CIP Account Analysis is not showing dataSummary: Why is my asset project not showing data here in the dashboard: There are plenty of cap transactions. I have also tried with chosing all periods - same result 🙄…
-
Expose Billing Instructions field (Bill Plan) in AR Transactions UISummary: We have a global customer with each region using different invoice templates. I'm hoping to populate AR Invoice Template in the "Billing Instructions" field so …Raj Mohanraju FRNT 21 views 1 comment 0 points Most recent by Zaheer Ahmed-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…
-
Query to fetch project actual cost accounting statusSummary: In my BIP report I'm trying to fetch the accounting status of the project actual cost. Content (required): Version (include the version you are using, if applic…
-
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…
-
How can we limit access to reports residing in delivered (out of the box) folders?Summary: How can we limit access to reports residing in delivered folders? Most of the users have access to BI roles (Consumer/Author/Admin) inherited through other role…
-
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…
-
Committed Costs showing on Project Control Budget Balances report but is not in Manage Committed CosSummary Committed Costs showing on Project Control Budget Balances report but is not in Manage Committed Costs PageContent We have committed costs showing in the Project…Michelle Swisher 81 views 4 comments 0 points Most recent by Venkat Patlola-Oracle Project Management
-
OTBI Report for Manage Unprocessed Cost Area in ProjectsSummary: I am trying to create an OTBI report to extract all the Cost available in Manage Unprocessed Cost area (Projects) where most of the Columns are extracted. (I am…Shashank Verma-Oracle 61 views 3 comments 0 points Most recent by Shashank Verma-Oracle Project Management
-
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 41 views 1 comment 0 points Most recent by Shivashish Dwivedi-Oracle Project Management
-
Unable to See Values for Project Organization Name Parameter in project List OTBI Using Custom RoleSummary: We are using Custom role for projects and added required Duty roles to enable this OTBI report. But Unable to See Values for Project Organization Name Parameter…Rohit Kumar Singh 51 views 3 comments 0 points Most recent by Shivashish Dwivedi-Oracle Project Management
-
We are weighing the option of having Project segment in COA vs implementing Project moduleWe are considering 2 options to have reports for Project by having Project segment in COA structure or implementing full fledged functionalities. We are considering para…
-
Security on OTBI reportSummary: Hi, We prepared an OTBI report on programs/projects. We are able to view all the data in the reports irrespective of Business unit/project unit/ project organiz…Santhi Sree 232 views 3 comments 0 points Most recent by Shivashish Dwivedi-Oracle Project Management
-
What is the equivalent of EBS Request Group in FusionSummary: I would like to know the equivalent of EBS Request Group in Fusion. For Example, I have a project accountant who needs to have access to run and view AP custom …Navaneeth TechM 61 views 1 comment 0 points Most recent by Shivashish Dwivedi-Oracle Project Management
-
How to create schedule wise S curve in fusionSummary: How to do Project Schedule wise S curve as explained in below link? Excel S-Curve Charts • My Online Training Hub Is there any workaround available? please advi…
-
Cumulative totals in OTBISummary: We want to create cumulative Actual costs in OTBI. Please advise how to do this? SET VARIABLE PREFERRED_CURRENCY='User Preferred Currency 1';SELECT 0 s_0, "Proj…
-
Is there a standard report for generating invoice cover letter by contractSummary: Is there a standard report for generating invoice cover letter by contract Any inputs on this will be appreciated. Content (required): Version (include the vers…
-
How To Import Contract Revenue Plans Using Import ManagementSummary: How To Import Contract Revenue Plans Using Import Management Content (required): Hello I was wondering which are the fields should I populate for the revenue pl…Cesar Saveedra 91 views 7 comments 0 points Most recent by Vinodhini Vobhilineni-Oracle Project Management
-
Huge number of Contracts impact on reporting/performanceHello team, We are evaluating options where there will be around half a million contracts created in the system to perform billing from Projects each year. I need pointe…
-
Project CostingSummary: Project Costing Content (required): We have added our subsidiaries business unit to Project Costing, however, when Create Accounting for Labor Cost is generated…
-
Project Manager viewing other ProjectsSummary: Hello, Is there a seeded role in Oracle that allows a Project Manager to view the Projects of his direct reports in the application as well as through reporting…
-
Revenue Generation: How to ignore all migrated dataSummary: We are now live with Fusion ERP. Old projects and transactions have been migrated. Transactions are non-billable. Revenue is migrated using events. For new tran…
-
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 …