Fusion Project reporting
Discussion List
-
Unable to find the SQL joining for Event class and Mapping set in Oracle fusion Project to CostingSummary: Hi, We are unable to find the SQL joining Event class (XLA_EVENT_CLASSES_VL) and Mapping set (XLA_MAPPING_SETS_VL) in Oracle fusion Project to Costing. The inpu… -
Update of Location of Final discharge column in PPM invoice or Interfaced AR InvoiceHi, Could you please suggest a way to update the column "Location of Final Discharge" in PPM invoice or when the invoice is interfaced in Oracle fusion, without any manu…
-
I need Mass update the role of team members for multiple projects via fbdi & we cannot use Rest apiHi, There's a need where we have to mass update the role of team members of multiple projects & we cannot do via rest api and has to be done via fbdi. Is this feasible, …Shubhendra Rathore 31 views 4 comments 0 points Most recent by Shubhendra Rathore Project Management
-
Missing project and data when reporting from Project- Performance Reporting Real TimeSummary: I am reporting from Project- Performance Reporting Real Time, but some projects (not closed yet) is missing from this data set compeletely.. We have run the Upd…
-
Project conversion attributes are not being populated under Manage Financial Settings > FinancialsSummary: Project conversion attributes are not being populated under Manage Financial Settings > Financials for projects that were enabled from Project Management, even … -
Table name and column for EXPENDITURE BUSINESS UNITSummary Table name and column for EXPENDITURE BUSINESS UNITContent what could be the Table name and column for EXPENDITURE BUSINESS UNIT for project commitment although …
-
Need to know the Accounting Status identifier from Projects expenditure/costing tablesSummary: We have a requirement to create a report/integration listing Expenditure / Costing information along with Billing information. For this request we need to know …
-
What is the subject area of Project Definition DFF on OTBI on Projects module?Summary: We cannot find Project Definition DFF on OTBI. What is the subject area of this attribute on Projects module. DFF is BI enabled, we run "Import Oracle Fusion Da…
-
Require sql statement to extract committed, actual and budgeted costs for projectsSummary: I am trying to extract committed, actual and budgeted costs for projects (if possible funds available) and I am unsure which tables to include in the sql statem…
-
Program ManagementSummary: Please may I know: How do I add additional DFFs or User Defined Attributes to capture additional meta data, that can also be reported via OTBI? I have had a loo…
-
How can we trigger alert or notification when new projects createdSummary: How can we trigger alert or notification when new projects created. Content (please ensure you mask any confidential information): Hi All, Is it possible to cre…
-
Required Tables and column to store the Currency setting details under Manage Financial Plan typesSummary: Hi Team, What are the Tables and columns that store the Currency setting details under Manage Financial Plan types - functionality "Use same conversion attribut…
-
Assign Requirements (agile) to TaskSummary: We currently do not have any functionality available—neither through FPDI nor ADFDI—to update or attach requirements or assign resources directly to a task. Cou…
-
I am unable to join between Project types and class category for the task project typesSummary: Hi Team, Could you please help us to get class category under the classification associated with project types in oracle PPM Module Task Name: Manage Project Ty…
-
Create custom notification with Agents in OTBISummary: We are looking to create custom notifications utilizing Agents in OTBI. We have specific use cases where we need users to receive notifications (i.e. project co…
-
Subject area for project period close statusSummary: We want to create OTBI report with project period status across multiple business units. Is there an OTBI subject area we can leverage? Content (please ensure y…
-
How to prevent changes to task name/number after accounted project costs?Summary: We would like to prevent changes to task name/number after actuals or baseline so that off-system data is accurate Content (please ensure you mask any confident…
-
Capture in BI Report the "Proposed Increase and Decrease in Budget" valueWe have a report requirement to extract in BIP report the "Proposed Increase or Decrease in Budget" value from Project budget version. Upon initial investigation, we hav…
-
Unable to add KPI at project levelSummary: Hi Team, I am facing an issue where I am unable to add KPI tro project or project template . We want to send a notification to user when actual cost reaches 90%…
-
Gross to Net Process Using Oracle PPMSummary: Gross to Net Reporting - Booking All costs to P/L using custom SLA in EBS which is not supported in Oracle Fusion Content (please ensure you mask any confidenti…Ranju Nair 2 views 1 comment 0 points Most recent by Clara Azoitei-Support-Oracle Project Management
-
How would we query the Award Project Burden Schedule --> Manage Override Burden Schedule?Summary: I have been trying to write a query on Award Project Burden Schedule. The columns I need are 'Burden Schedule Name' and 'Multiplier'. I have used pjf_ind_cost_m…Divya_Dammalapati 71 views 3 comments 0 points Most recent by JyotiPrasadDash-Oracle Project Management
-
Standard Report/DashboardSummary: The standard reports/dashboards (project lists, project performance (cost, revenue etc) are they available for closed projects? Content (please ensure you mask …
-
Unable to send Generate Invoices Output to EmailSummary: Looking for an option to send "Generate Invoices" scheduled process output PDF output to the Email ID Content (please ensure you mask any confidential informati… -
How to save an OTBI report into Reports and Analystics Favorites of Job Managers role in ERPI have developed some OTBI and BIP reports and I would like to centrally save this report in the Reports and Analystics Favorites for list of users / role. (Instead of e…
-
Sql query or Table name for Classify Organizations under Manage Project Organization ClassificationSummary: Hi Team, We need a table or query to get the flag columns for Classify Organizations under Manage Project Organization Classification Attached the screenshot fo…
-
How to migrate the custom defined ess job reports to the another instanceSummary How to migrate the custom defined ess job reports to the another instanceContent we have created the custom bip reports and those reports we registered as a ess …Koteswararao Yenikepalli 148 views 6 comments 3 points Most recent by Nathan CCC Reporting and Analytics for ERP -
Trying to join Projects Burden Schedule with Burden Structure but I am not getting desired resultsCould you please help me with query to join Burden Schedule with Burden Structure to get Burden Schedule Name, Burden Structure Name, Cost Base, Burden Cos Codes, Preced…
-
Inquiry: Project Margin and Profitability Reporting by Party LevelHello Everyone, I am currently conducting a POC to determine whether we can run project margin and profitability reports using the customer party hierarchy defined in th…
-
How to assign project code creation role only ( Edit, delete) to users.I have requirement to provide project code creation role only to users. But users already have project related roles and General ledger related roles. it's not possible …
-
How to find the customer information from Manage Financial Project SettingsI want to retrieve customer information from Manage Financial Project Settings page. Can anyone help on the query?