Reports
Discussion List
-
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… -
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…
-
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…
-
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 25 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 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…
-
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 -
Trigger custom validation on Project Status ChangesHi Folks - Is there a feature in cloud where you can add a custom validation / code whenever project status changes get triggered? As an example. User change the Project…
-
Need access for Custom OTBI Dashboards : "Projects Control Dashboard" reportSummary: Project Role as "Project Team member" on Oracle seeded has no access for Custom OTBI Dash boards (specially "Projects Control Dashboard") . Our request is to pr…SRIRAMULA RAJKUMAR 31 views 6 comments 0 points Most recent by Sudhir Agir-Oracle Project Management
-
Is there any way to control displayed size for name of DFF not input column?Summary: Is there any way to control displayed size for name of DFF not input column? I set DFF in Project Billing Event and I would like to displayed DFF without line b…
-
Enterprise Contract -> Manage Contract-> Contract Deliverables ->Activation Status Field Missing.Summary: Need to pull the list of newly created contract deliverables which are 'NOT ACTIVATED' for each contract/Award. ' Deliverable Activation status field is missing…Guna Suriya 32 views 3 comments 0 points Most recent by Andrei Ursachel-Support-Oracle Enterprise Contracts -
Query for Project Management (PPM) relatedSummary: I need to include budget details ( labor, materials and expense), forecast details ( labor, materials, expense) and forecast ( labor, budget, expense) in my BIP…
-
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…
-
Hima Bindu Kukkala-Oracle 11 views 1 comment 0 points Most recent by Pradeep Balakrishnan Project Management
-
Query for Project Management (PPM) relatedSummary: I need to include budget details ( labor, materials and expense), forecast details ( labor, materials, expense) and forecast ( labor, budget, expense) in my BIP…