Reports
Discussion List
-
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…
-
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.
-
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 9 views 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 17 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…
-
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 24 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…
-
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 21 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…
-
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… -
UPPD without producing report ESS Process is running for more than 4 to 5 hoursSummary: UPPD without producing report ESS Process is scheduled on daily basis and it is running fine, completing in 60-90 minutes. But when we run this process during p…
-
Did You Know? Export Large Volumes of Project Costs to Excel EfficientlySummary Export large volumes of project costs from the Manage Project Costs page to Excel. Content You can export the search results on the Manage Project Costs page to … -
OTBI Subject area to get Project cost and accounting entriesSummary: Unable to get details of view accounting page from Project Costing - Actual Costs Real Time. Wanted to pull the Project cost transactions which are enabled for …
-
Not able to see data from front end in LookupSummary: We are entering values in common lookup with help of Pl-sql wrapper program. In this program we are using 'fnd_lookup_values_pkg.insert_row' api to insert value…
-
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… -
-
Need help configuring BPM Workflow Task for Issue NotificationsSummary: I have tried to customize the Issue Notifications Catalog workflow template for the Create Issues task under Project Management, but it is not reflecting my new…
-
Labor Distribution - Reporting Attribute to Identify Labor Cost AdjustmentsIs there a reporting attribute within the "Projects - Labor Distribution Cost Analysis Real Time" subject area within OTBI that identifies when a transaction is related … -
Invoices are getting failed while importing only for one specific supplier.Summary: All invoices from one specific supplier are failing to import, but no issues are arising when keying them manually. There seems to be some issue with the image …Akanksha Bhardwaj 21 views 3 comments 0 points Most recent by Shivam Chauhan-Oracle Payables, Payments & Cash Management