Data Applications → Analyze Oracle EBS Human Resources
About the Oracle EBS Human Resources (HR) Data Application
The Oracle E-Business Suite (EBS) Human Resources module enables the efficient management of workforce data and supports all standard HR activities, including workforce organization, development, and measurement. The Incorta Direct Data Platform™ data application for the Human Resources module provides prebuilt schemas, dashboards, and insights to help you easily monitor and analyze your organization’s human resources to manage your resources better.
Here are some of the questions answered by the Oracle EBS Human Resources data application:
What is the compensation rate?
What is the gender distribution?
What are the reasons for termination?
You can further customize and add to the insights in the Incorta Human Resources data application to support your specific business needs.
Note
The Oracle EBS Human Resources data application is available in the On-Premises and Cloud Versions of Incorta.
Human Resources Data Application Components
Here are the Incorta prebuilt Human Resources data application physical schemas, business schemas, dashboard folders, dashboards, and insights:
Physical Schemas
EBS_HR
EBS common schemas:
EBS_ITEM_COMMON
EBS_CAL_COMMON
EBS_FND_COMMON
EBS_HR_COMMON
EBS_FIN_COMMON
EBS_PARTY_COMMON
Business Schemas
WorkforceDeployment: Provides details related to workforce deployment and information related to people, employment, and work structures.
WorkforceTrendHistory: Includes a monthly snapshot of workforce deployment and activities.
This aggregated table insight indicates the sum of annual compensated salaries for the subordinates per supervisor.
Compensation By Org Hierarchy
This aggregated table insight indicates the sum of annual compensated salaries per child organization.
Compensation Cost by Locations
This bar insight indicates the sum of compensation costs sorted in descending order per location.
Compensation Cost By Organizations
This column insight indicates the sum of annual compensated costs sorted in descending order by the organization.
Workers Salary Band
This column insight indicates the total annual salary bands based on gender.
Compensation Cost Over Time
This column insight indicates the total compensated salaries over the years.
Compensation By Org Over Time
This column insight indicates the descending order of total compensated salaries per organization over the years.
Employees Compensation By Location
This aggregated table insight indicates the total annual salary per employee grouped by their location code
Example: Compensation Dashboard
Worker By Organization Dashboard
Insight
Description
Organization Hierarchy
This aggregated table insight indicates the hierarchical structure of the organizations, including the sum of child organizations and the sum of the number of workers.
Organization List
This aggregated table insight indicates the list of organizations and the number of workers in each. It also shows the average age of workers and their percentage based on gender.
Gender Distribution
This stacked column insight indicates the number of workers across organizations based on their gender.
Manager vs. Non-Manager
This stacked column insight indicates the number of managers in each organization. It also shows the number of missing or undetermined titles across workers.
Assignment Categories
This stacked column insight indicates the number of workers in each organization and their distribution based on their employment type, whether they are full-time - regular, full-time - temporary, or part-time - regular. It also shows the number of workers that are missing their assignments.
Worker List
This listing table insight indicates a list of workers with their complete information, such as their employee number, gender, age, and their address.
Example: Worker by Organization
Worker By Supervisor (Current) Dashboard
Insight
Description
Use Parent
This aggregated table insight indicates the current organization's hierarchical order of workers starting from the highest level supervisor.
Use Child
This aggregated table insight indicates the current organization hierarchical order by supervisor starting from down to top.
Workers List
This listing table insight indicates a list of current workers with their complete information, such as their employee number, gender, age, and their address.
Example: Worker By Supervisor (Current) Dashboard
Worker By Supervisor (History) Dashboard
Insight
Description
Supervisor Hierarchy
This aggregated table insight indicates the historical organization hierarchical order of workers starting from the highest level supervisor.
Employee Organization Hierarchy
This aggregated table insight indicates the historical organization hierarchical order by supervisor starting from down to top.
Worker List
This listing table insight indicates a list of previous workers with their complete information, such as their employee number, gender, age, and address.
Example: Worker By Supervisor (History) Dashboard
Workforce Deployment Dashboard
Insight
Description
Worker’s Age
This column insight indicates the number of workers for each age range based on their gender.
Workers By Gender
This pie insight indicates the percentage of female workers and male workers in the organization.
Workers By Organizations
This column insight indicates the total number of workers in each organization. The total numbers of workers are in descending order.
Worker US Veteran Statuses
This bar insight indicates the categorization of workers and their total number based on their US veteran statuses sorted in descending order.
Workers by Locations
This bar insight indicates the total number of workers in each location sorted in descending order.
Workers Distribution
This aggregated table insight indicates the number of workers in each location categorized by assignment type and organization.
Workers By Categories
This aggregated table insight indicates the number of workers per their assignment category.
Worker
This listing table insight indicates a list of workers with their details, such as complete name, job title, location, and organization name.
Example: Workforce Deployment Dashboard
Workforce Termination Dashboard
Insight
Description
Termination By Reason
This column insight indicates the number of terminated workers categorized by their age band for each reason for termination.
Workers Tenure
This donut insight indicates the percentage of terminated workers based on their length of service band.
Gender Distribution By Location
This column insight indicates the number of terminated workers in each location based on their gender.
Termination By Location
This bar insight indicates the number of terminated workers in each location sorted in descending order.
Termination By Organization
This column insight indicates the number of terminated workers in each organization sorted in descending order.
Workers Termination List
This listing table insight indicates a list of terminated workers with their details including their reason for termination.
Example: Workforce Termination Dashboard
Workforce Trend Analysis Dashboard
Insight
Description
Number of Workers Over Years
This column insight indicates the total number of workers each year.
Number of Workers Per Year
This aggregated table insight indicates the total number of workers each year categorized by the period name.
Turnover Rate (Year over year)
This aggregated table insight indicates the turnover rate throughout the years.
Termination Info
This listing table insight indicates a list of employees' IDs with their information, such as the date they started working and their termination date.
