Data Applications → Analyze Oracle EBS Projects

About the Oracle EBS Projects Data Application

The Oracle E-Business Suite (EBS) Projects module is a comprehensive project lifecycle and project management solution. It provides accurate forecasting, budgeting, and billings to track the profitability of the projects. It allows a broad accurate view of all the activities related to the projects.

The Incorta Direct Data Platform™ data application for the Projects module provides prebuilt schemas, dashboards, and insights to help you analyze the cost, revenue, and profitability of the projects.

Here are some of the questions answered by the Oracle EBS Projects data application:

  • What are the top 10 profitable projects and the top 10 customers, based on margin percentage?
  • What is the cost perf by organization and resource class, and what is the revenue by category?
  • How comparable is the cost of the projects versus the allocated budget and the funding provided?
  • What are the project cost and revenue by task hierarchy and financial resource?

Oracle EBS Projects Components

Here are the Incorta prebuilt Oracle EBS Projects physical schemas, business schemas, dashboard folders, dashboards, and insights:

Physical Schemas

  • EBS_AP
  • EBS common schemas:
    • EBS_CAL_COMMON
    • EBS_FIN_COMMON
    • EBS_FND_COMMON
    • EBS_HR_COMMON
    • EBS_PARTY_COMMON

Business Schemas

  • ProjectFinancials

Dashboards and Insights

Sample Query plan

Project Executive Dashboard

InsightDescription
KPIThis KPI shows the number of projects within margin.
Top 10 Profitable ProjectsThis pie insight shows the margin by project name, as a percent of total projects
Project View (Zoom to State → City)This advanced map insight shows the projects count per country.
Top 10 Incurred By Person CostsThis donut insight shows the top 10 incurred by person costs.
Top 10 customersThis pie insight shows the margin by the top 10 customers.
Cost Perf by OrgThis pyramid insight shows the cost per org.
Cost Perf by Resource ClassThis packed bubble insight shows the cost sum per resource class.
Revenue Perf by CategoryThis packed bubble insight shows the revenue per revenue category.
Project SummaryThis aggregated table insight shows the funding, budget, cost, bill, and revenue amounts and the margin per project owning org and project name.

Project Manager Dashboard

InsightDescription
KPIThis KPI insight shows the number of projects, funding amount, budget cost, commitment cost, billable cost, non-billable cost, margin percentage, and budget to cost variance.
Projects Cost Vs BudgetThis combo insight shows the budget cost, actual cost, budget hours, and actual hours by project name.
Task By StatusThis pie insight shows the count by task status.
Funding By ProjectThis donut insight shows the fund allocated by project name as a percentage of the total fund.
Top 10 Incurred By Person CostsThis donut insight shows the top 10 incurred by person costs.
Task Status by ProjectThis stacked column insight shows the task count per project and task status.
Cost Perf by Resource ClassThis aggregated table insight shows the cost by resource class.
DetailsThis listing table insight project details including: project name, project manager, project owning org, expenditure org, task number, wbs level, task name, task status, expenditure item date, line type, linne num, fiscal period, scheduled start date, actual start date, actual finish date, and completion date.

Project Cost & Revenue Summary

InsightDescription
Project Costs & Revenue By Task HierarchyThis aggregated table insight shows the cost, revenue, and margin by task name.
Budget to Actuals By Resource ClassThis aggregated table insight shows the planned cost and actual cost by resource class.
Actual Cost and Revenue By Financial ResourceThis aggregated table insight shows the cost and revenue by expenditure category and resource type.