Fusion Project reporting
Discussion List
-
BPM workflow approval question for PPM Project BudgetsContent Hi all, I have a question on BPM workflow approvals for PPM Project Budgets. For the workflow approval of any new budget version, business wants to use the DIFFE… -
Are the Infolets available in the Analytics section be available by default?Summary: Are the Infolets available in the Analytics section of the Oracle Fusion application be available by default or are we required to do configuration to make it a…
-
Connecting Workiva Cloud Service with ERP Cloud for SEC ReportingSummary Would like to know if anybody has done this connection and how worksContent Hello, I'm trying to learn from somebody that already experienced how to connect Work…Patricia Gonzalez 56 views 5 comments 0 points Most recent by Sean Rogers Reporting and Analytics for ERP -
Need SQL Query to find Baselined Project Budget VersionSummary: Hi Please help us to query baselined project budget version by sql query. I want to find the Project Number, Version, Revenue Budget, and Cost Budget. Our expec…
-
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…
-
Require logic to fetch month end exchange rate while generating revenue in Projects Billing ModuleSummary: Urgent!!!!!! Client requires the Revenue in Projects Billing to have month end exchange rate even if the Event Completion date is mid month. Example, event was …
-
Default Expenditure Type - LOV not containing Expenditure TypesSummary: Content (required): Hi, I have created multiple Expenditure Type and tagged them to seeded Expenditure Category Classes as well. However, I have the below conce…
-
bi query to extract journal approval rules, Invoice Apprvoal Rules and Project Approval RulesSummary: Hi All, I am looking for the tables or query to extract the journal approval rules, Invoice Approval Rules and Project Approval Rules from Oracle ERP Cloud thro…Chandra MAdasi 32 views 8 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
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…
-
Smart View for Project Performance - Guidance for Understanding DimensionsSummary: Trying to create a Smart View report for Project Performance but struggling to understand why some dimensions don't work - looking for any documentation that ca… -
Project LOV empty on Purchase RequisitionSummary Project LOV empty on Purchase RequisitionContent Hello, I am in the process of configuring Project Financial Management. I've set up and successfully activated a… -
Issue from inventory to projectsHello Community. I created a Misc issue transaction for issue to project. Its successfully interfaced to Projects but Projects cost details report does not show accounti…
-
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 60.9K views 147 comments 33 points Most recent by YevgenyM Reporting and Analytics for ERP
-
Best Practice on using Organization TreeSummary: Currently we have one Organization Tree with the below structure Enterprise (Company XYZ) Business Unit (US XYZ) Department (Project Expenditure / Task Owning O…
-
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 1.1K 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…