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
Insight | Description |
---|---|
KPI | This KPI shows the number of projects within margin. |
Top 10 Profitable Projects | This 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 Costs | This donut insight shows the top 10 incurred by person costs. |
Top 10 customers | This pie insight shows the margin by the top 10 customers. |
Cost Perf by Org | This pyramid insight shows the cost per org. |
Cost Perf by Resource Class | This packed bubble insight shows the cost sum per resource class. |
Revenue Perf by Category | This packed bubble insight shows the revenue per revenue category. |
Project Summary | This 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
Insight | Description |
---|---|
KPI | This 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 Budget | This combo insight shows the budget cost, actual cost, budget hours, and actual hours by project name. |
Task By Status | This pie insight shows the count by task status. |
Funding By Project | This donut insight shows the fund allocated by project name as a percentage of the total fund. |
Top 10 Incurred By Person Costs | This donut insight shows the top 10 incurred by person costs. |
Task Status by Project | This stacked column insight shows the task count per project and task status. |
Cost Perf by Resource Class | This aggregated table insight shows the cost by resource class. |
Details | This 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
Insight | Description |
---|---|
Project Costs & Revenue By Task Hierarchy | This aggregated table insight shows the cost, revenue, and margin by task name. |
Budget to Actuals By Resource Class | This aggregated table insight shows the planned cost and actual cost by resource class. |
Actual Cost and Revenue By Financial Resource | This aggregated table insight shows the cost and revenue by expenditure category and resource type. |