This post shares Fusion HCM Analytics sample content as part of Oracle Fusion Data Intelligence (FDI), a family of prebuilt, cloud-native analytics applications for Oracle Fusion Cloud Applications. These sample artifacts are intended to demonstrate potential use cases, accelerate implementation efforts, and provide examples of how customers can extend and customize FDI content to meet their business needs. To explore additional reusable sample content, visit the FDI Content Library.
Content Description: An AI-enabled payroll earnings analytics workbook that enables users to analyze earnings, distributions, accumulations, variances, and growth trends.
Application: Fusion HCM Analytics
Fusion Module: Oracle Cloud Payroll ( Payroll Balances )
Target Persona: HRBP, Line Manager, Business Leaders
Subject Areas: HCM - Workforce Rewards - Payroll Balances , HCM - Workforce Rewards - Payroll Balances (Monthly) , HCM- Payroll Balances LSA
Business Use Case/Questions:
- What are the total earnings by month for the last 2 years?
- What are the standard earnings by business unit for the last 5 quarters?
- What are the supplemental earnings by job name for the previous 5 quarters?
- How many workers were processed by payroll name this past 12 months?
- Show the standard earnings by job name, Month?
- What are the total earnings by various legislations for last 5 years?
- What is the month to date supplemental earnings for the last 12 months by business unit?
- What are the standard earnings (YTD) in current year by job?
- What are the standard earnings by gender for the past 5 years?
- What are Top 10 balance names for Supplemental Earning in last 12 quarters?
- How do standard vs supplemental earnings compare by payroll name and business unit in the last 12 quarters?
- Show standard earnings by month for last 5 years?
- Which payrolls show the highest supplemental earnings variance for the past 6 months?
- How does the worker count try and compare to the trend of total earnings for last 12 quarters?
- What proportion of total earnings comes from supplemental earnings by job in the past 5 years?
- List the standard earnings growth rate by Job family, Year for last 5 years?
- How does Supplemental & Standard Earnings compare by payroll name in last 8 quarters?
- Are there noticeable differences in standard earnings by gender across business units in the past 8 quarters?
- List Top 3 business units with standard earnings variance compared to the previous 3 years?
- How does the worker count trend compare with the trend in standard earnings by business unit over the last three years?
- Which are the top 5 jobs showing supplemental earnings based on growth rates in the past 6 year?
- How does Total Earnings vary by gender across business units in the past 6 quarter?
- List Top 10 payrolls that have the highest supplemental earnings variance in last 5 years?
- What are the Top 10 payroll names for standard earnings growth in last 3 years?
Pre-Requisites: Enable Workforce Management & Payroll Balances Functional Area
Download: Available in the FDI Content Library.
Best Practices:
Include a Time Period
Providing a time reference helps the agent return more relevant results.
Examples:
- Current Month
- Current Quarter
- Current Year
- Previous Year
- Last N Months
- Last N Quarters
- Last N Years
- MTD, QTD, YTD
Example: Show total earnings by payroll for the last 4 quarters.
Specify Business Dimensions
Mention the business attribute you want to analyse.
Examples:
- By Business Unit
- By Payroll
- By Job Name
- By Gender
- By Month, Quarter, or Year
Example: Show supplemental earnings by business unit for the current year.
Ask Comparative Questions
Comparison-based questions often provide deeper insights.
Examples:
- Compare earnings between Payroll A and Payroll B.
- Compare worker count across business units.
- Compare standard earnings and supplemental earnings by payroll.
- Compare current year earnings with previous year earnings.
Use Top N / Bottom N Requests
Examples:
- Show top 10 jobs by earnings.
- List bottom 5 payrolls by worker count.
- Show top business units by supplemental earnings.Examples:
Continue the Conversation
The agent remembers the context of your conversation and can build on previous responses.
Example:
- Show total earnings by business unit this year.
- Which business unit has the highest earnings?
- Show the monthly trend for that business unit.
- Compare standard and supplemental earnings for that business unit.
- Show worker count for the same business unit.
Data Coverage & Limitations
This agent can answer questions only about measures and attributes available in the associated subject area.
It may not recognize:
- Metrics not present in the subject area
- Custom KPIs not modeled in the dataset
- Data from unrelated business domains
Example: Payroll Balances Overview Agent may not recognize Annualized Salary Amount, Voluntary Deductions, or other measures not available in the Payroll Balances subject area.
Important Notes
- Workbook filters remain active throughout the conversation.
- Responses are influenced by currently selected filters.
- MTD = Month-to-Date
- QTD = Quarter-to-Date
- YTD = Year-to-Date
- Always validate AI-generated insights before making business decisions.
We’d love to get your feedback and business use cases to help build more sample FDI content.
