Fusion Project reporting
Discussion List
-
R13.x FSCM BI Cloud Adapter BI View Object to Database Lineage Mapping SpreadsheetSummary This posting includes R13 FSCM BI Cloud Adapter BI view object to database lineage mapping. Content This spreadsheet is published by Oracle BI Cloud Adapter Deve…Rashmi M-Oracle 59.5K views 146 comments 33 points Most recent by Stéphane Lamy-Bouchard Reporting and Analytics for ERP -
Change row output number on Oracle OTBI AnalysisHow I am able to change the output of the rows from 75000 to more on an Oracle OTBI analysis? -
Data Migration - Project Assets - Data TemplateHi All, While uploading Project Asset Processing Import Template, I am unable to do the same. Getting the below error. Has anyone faced similar kind of Issue. XLA_TAB_CC… -
Project Health Analysis Based on Schedule and BudgetHello, We have a requirement to analyze the overall health of a project based on its current status, schedule, and budget consumption. For example, if a project has a st… -
Restrict Project Accountant access by Team memberSummary: We have a requirement to restrict Project accountant role only to certain projects where they are assigned as the Project Accountant. By default if standard Pro…
-
How to retrieve historical values of project task attributes in Oracle ProjectsHi, Based on a client requirement, we would like to understand whether it is possible to query historical (past) values of project task attributes in Oracle. We identifi…
-
Project Cost and Commitment are not Visible in Project Financial ProgressWe have configured the Fusion Project for Capital Project functionality. So we have followed the implementation guidelines for defining Capital Projects. After completin…
-
Need asset key details in project - Assets real time subject areaSummary: I’m unable to locate Asset Key details in the Projects – Assets Real Time subject area, which is required by the customer. Is Asset Key available in this subjec… -
Project Costing Rejection Reasons During the Import Costs processSummary: Is there any table/lookup which stores all the possible "Project Costing Rejection Reasons" which can be encountered during Import Costs process. For example if…
-
Unable to find the table and column in which "Grouped construction in progress" flag at project ExpContent Hi All, I am able to find the "Grouped Construction in Progress" flag at project expenditure level. please find the navigation attached. I'm unable to find the f…
-
How to ensure date columns in BI Publisher Excel output use date filters instead of text filters?Our customer wants to download online versions of reports in Excel format, next they will be applying filters on the table for deeper review and analysis. There are mult…Sayan Jasu 21 views 3 comments 0 points Most recent by Lee Eslick-Huff Reporting and Analytics for ERP -
In Oracle Projects,the BPM tables take time to fetch the data from UI to backend tables for a reportHello Team, The following BPM tables take time to fetch the data from UI. The application takes 5 days to reflect the data in the report after updating the data in UI (P…
-
Need to update Baseline Start Date and Finish Date of a project from UI in oracle fusionSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
How to import labor cost by using Manage Expenditure Batches?Summary: one of our new branched want to import Labor/Nonlabor/ Raw Material cost into Fusion project cost. we decided to use Manage Expenditure Batches function to impo…
-
Cost Variance KPI to compare Actual Cost against the full annual budget (not Budget-to-Date)Summary: How to configure a Cost Variance KPI to compare Actual Cost against the full annual budget (not Budget-to-Date)? I need a KPI that evaluates cost variance at th…
-
Query to fetch project and Time card entries(OTL)Summary: Hi Team, We need a table where the project number and time card entires details or SQL query Content (please ensure you mask any confidential information): We n…Opkey PA 964 views 5 comments 0 points Most recent by Sathyaseelan Chandran Reporting and Analytics for ERP
-
How to download all attachments from a Projects Invoice workflow transactionSummary: How to download all attachments from a Projects Invoice workflow transaction Content (please ensure you mask any confidential information): Approvers are attach…
-
Adding Project Classification (Class Code) to OTBI report duplicate Costs RowsSummary Adding Project Classification (Class Code) to OTBI report duplicate Costs RowsContent Adding Project Classification (Class Code) to OTBI report duplicate Costs R…User_2025-01-30-23-00-53-497 110 views 5 comments 1 point Most recent by Rich Merkel Reporting and Analytics for ERP -
Export XML data vs republished reportWe have a requirement to send the XML data export generated via "Create Accounting Execution Report" to a mailbox. We created a job set with "Create Accounting" as the f…
-
business would like to understand the detailed functionality of all Gen AI features available in PPMSummary: The business would like to understand the detailed functionality of all Gen AI features available in PPM, specifically: Project Program Analysis and Action Plan…
-
Project Class Category Causes Duplicate Rows for Project Financial Information in OTBI and BI PUBSummary: When we want to report on the Project Classifications class categories for a project number there is no clean way to do it. The current solution we are doing re…
-
Best way for users to look up project time by expenditure TypeWhat would best way for users to pull their time on projects by expenditure type. User is ONLY Project Team Member on a project, nothing else.
-
Project Financial ReportingSummary: Our organization uses the Projects module primarily for tracking the costs of projects (no awards, no project billing). Our project managers want a 'one-stop sh… -
Audit tables for Project Tasks and Sub Tasks in Oracle fusion cloud and policies to enableHi, Are there any Audit tables for Project Tasks and Sub Tasks related in Oracle fusion cloud to create a BI publisher report? I was able to enable the audit policies fo…
-
How can I join the hz_parties table to a project number or contract number table using sql.Hi everyone, I'm creating a work-in-progress report that tracks project costs and needs your help joining several Oracle tables efficiently. I'm working with: PJF_PROJEC…
-
Does Oracle Fusion Allow a Link to Microsoft Power BI?Summary I'm looking to see if Fusion would allow Microsoft Power BI to link to the Servers In Order to Build ReportsContent My company uses Microsoft Power BI for alot o…Brian Burns 87 views 5 comments 5 points Most recent by daniel.valdovinos Reporting and Analytics for ERP -
Forecast ETC Revenue CalculationSummary: It appears to me ETC revenue in forecasts for future periods are calculated by spreading the amounts evenly based on contract line project funding amount. Pleas…Raj Mohanraju FRNT 31 views 3 comments 0 points Most recent by Raj Mohanraju FRNT Project Management
-
How to find the workplan template from which a project is created in PEMSummary: Finding the Workplan Template from which a project is created in Project Execution Management. Findings: Currently, the tables only show the assigned Workplan t…
-
Denormalize Task Structure Hierarchies for Business Intelligence ended up long runningSummary: The business has experienced when the Denormalize Task Structure Hierarchies for Business Intelligence job was run it ends up in long running. There is no optio…
-
Essbase Projects - Project Task can we add this POVSummary: We would like to know if we could add an additional POV which is projects task and how to do this ? Content (please ensure you mask any confidential information…