Reports
Discussion List
-
Close Accounting Period Exceptions for range of periodsSummary: Can we submit the Close Accounting Period Exceptions for a range of periods? Content (please ensure you mask any confidential information): working 24D it only … -
Query or Table for Budgetary Control Settings under Manage Financial Plan TypesSummary: Hi Team, We need a Query or Table for Budgetary Control Settings to get below fields under Manage Financial Plan Types. Content (please ensure you mask any conf…
-
25A-SOAK- Project Reports ending into errorProject Summary Reports are ending in error with below message. The same reports are up and running in Production and other environments where 25A has not yet been appli…Tina_Motwani 25 views 2 comments 0 points Most recent by Sue Gordon - Frontera Consulting UK Project Management
-
For the custom reports User is not able to see the data in the report outputSummary: For the Custom Reports, users are not able to view the data when they run the report. Content (please ensure you mask any confidential information): Version (in…
-
We need a table to get the data for the setup Manage Labor Costing RulesSummary: Hi Team, We need a table or SQL query to get the data for the setup Manage Labor Costing Rules Content (please ensure you mask any confidential information): Ve…
-
Is there any connection link to pull data from PPM via SmartView ?Summary: We have a requirement to pull awards and other project-related details from the PPM dashboard via SmartView. Wanted to check if there is a connection link to pu…
-
Seeded report listingSummary: Hello Experts Can someone help me with the listing of PPM (PFM + PEM) seeded reports ?Navya Krishna Yarlagadda 17 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Project Management -
Subledger Period Close Exception ReportSummary Subledger Period Close Exception ReportContent I am seeing these transaction on the Sub-ledger exception report as per below table. 1. Does this means they were …
-
Project Contract List Dashboard with Null Project NumberSummary: Hi In the analytics, there is project contract list dashboard. When we run this dashboard, there is contract with null project number. When we check in the UI, …
-
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 …
-
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.
-
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 41 views 7 comments 0 points Most recent by Venkat Patlola-Oracle Project Management
-
Sql query to print numbers between 2 column numbers when both columns are not equalSummary: Sql query when both columns are same print first column value , else if both columns are different print the series of numbers between the columns Content (plea…
-
Does the Accounting Period Close Exception Report include Project OTL Timecards?Summary: Content (please ensure you mask any confidential information): Hi, Does the Accounting Period Close Exception Report include Project OTL Timecards that have not…
-
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…
-
Query to export project fund allocationSummary: We are creating a report to pull supplement details and associated project details. Content (please ensure you mask any confidential information): Navigation Aw…
-
Resource Management - Resource Creation Exceptions not identified after 24DSummary: Manage Project Enterprise Labor Resource Maintenance Conditions Following the Maintain Project Enterprise Labor Resources process has run and completes, the Res…
-
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…
-
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 1 view 1 comment 0 points Most recent by Cristian Bilibou-Oracle Project Management
-
how to query accounting details of project billing event by using sql querySummary: Hi Team, we have created a Project billing event and generated revenue for this event and in manage revenue distributions screen we have executed create account…
-
Lease Disclosure ReportSummary: I need to know what formula is used in the Standard Lease Disclosure Report for Section 4 in order to calcualte figures of below two rows Weighted Average for R…
-
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
-
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…
-
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…
-
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…
-
SmartView and ProjectsSummary: Hi, I am looking for help/guidance if Smartview can be used with project information. Hundreds of projects are used to track IT spend using one account. Use cas…Larry Greenblatt 22 views 1 comment 0 points Most recent by Andreea Versanu-Oracle Project Management
-
Access to Project Budget vs Actual and Project Capital Costs reportIs there a specific privilege or data policy to access Project Budget vs Actual and Project Capital Costs report? Project Accountant gives us access however it has too m…
-
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… -
PPM Control Budget Balance Report RequirementHi, We have multiple requirements from users asking for drilldown of balance shown in Award Overview Page under Control Budget Balances view. So we are trying to develop…
-
How to connect to SQL Server to report in context to PPMSummary: We want to develop a BI report to get data from PPM costing and also want to fetch related data from a SQL server DB. Please suggest how we can connect to SQL s…