Sample reports for Oracle Fusion Cloud
The page showcases various sample reports for Oracle Fusion Cloud, focusing on simplifying data insights across multiple business areas like payroll, finance, recruitment, benefits, supply chain, absence management and HR. These reports help users optimize their decision-making by making it easier to analyze, manage, reconcile, and visualize data efficiently.
Human Resources
- Contingent Worker Report
- Element Entry Values Date Range
- Employee Change Report
- New Hire Report
- Salary As of Date Report
- Termination Report Date Range
Contingent Worker Report
This report shows the information about contingent workers. The information is available in the employment page of Fusion Human Resources module. A row is displayed for each Contingent Worker and shows information such as Person Name, Person Number, Person Type, Employment Category, Date of Hire, Job Name along with other person information. For this report, access to data is dependent on HR roles the user has of Fusion Human Resources module.
Element Entry Values Date Range
This report displays information about Element Entries and their associated assignments to an employee. The information is available in Element Entries in the Fusion Human Resources Module. A row is displayed for each employee record and displays information such as Element Name, Input Value name, Pay Value, EE Input value along with other person information. For this report, access to data is dependent on HR roles the user has of Fusion Human Resources module.
Employee Change Report
This report displays information of Employees Work structure changes. The information is available in employment page of Fusion Human Resources Module. A row is displayed for each employee change record and displays information such as Assignment Number, Assignment Change Reason, New Values, Old Value, Employment Category, Job Name, Grade along with other person information. For this report, access to data is dependent on HR roles the user has of Fusion Human Resources module.
New Hire Report
This report displays information about newly hired persons. The information is available in Person, Assignment, Department, Job, Position, Grade, Location windows of Fusion Human Resources module. A row is displayed for each newly hired person and displays information about person and assignments such as Department, Job, Position, Grade, Location, Payroll, Salary for all active employees along with other person information. For this report, access to data is dependent on HR roles the user has of Fusion Human Resources module.
Salary As of Date Report
This report displays Salary details of an employee. The information is available in Change Salary page of Fusion Human Resources Module. A row is displayed for each person record and displays information such as Assignment Number, Salary Amount, Salary Change Date, Salary Change Reason, Annual Salary along with other person information. For this report, access to data is dependent on HR roles the user has of Fusion Human Resources module.
Termination Report Date Range
This report can be used to fetch the list of terminated employees with in a date range. This information is available in Employment page, of Fusion Human Resources Module. A row is displayed for each employee record and displays information such as Termination date, Termination Reason, Length of Service, Gender, Job Name, Location and Department along with other person information. For this report, access to data is dependent on HR roles the user has of Fusion Human Resources module.
Payroll
- Costing Details
- Net Outside the Range Report
- Payroll Register
- Payment Register
- Payroll to GL Reconciliation
- Payroll Comparison Report
- Tax Balance Report Date Range
Costing Details
This report provides details about the payroll entries that have been costed for an employee. The information can be verified using the Costing of a Person screen in the Payroll module of Oracle Fusion. A row is displayed for each costed element of an employee. This report can be used to retrieve costing details of all elements at the assignment level. It displays information such as element name, balance or cost, cost company, debit or credit value, along with person details. Access to this report is dependent on the Payroll Administrator and Payroll Manager roles.
Net Outside the Range Report
This report provides details on the net balances for every assignment for each payroll action within a specified date range and net amount range. The information can be viewed using the Person Results screen of the Payroll module in Oracle Fusion. A row is displayed for each employee who had their net balance processed in the payroll run. This report can be used as an audit tool to show all employees whose net amount exceeds a specified parameter. It displays details such as run amount, quarter-to-date, and year-to-date values for the net and gross balance for each employee with a net balance outside the specified range. Access to this report is dependent on the Payroll Administrator and Payroll Manager roles.
Payroll Register
This report provides details related to Earnings, Deductions, and Net Payments for all or selected employees for a given pay period. The information is available on the Person Results page of the Payroll module in Oracle Fusion. A row is displayed for each balance processed in the payroll run for an employee. This report can be used as an audit tool, showing run balance details for employees across multiple processes such as quickpay, regular runs, balance initializations, and balance adjustments. It displays information such as the run amount, period-to-date, quarter-to-date, month-to-date, and year-to-date values for each employee’s balances. Secured views are used to ensure data security.
Payment Register
This report provides details on all payments, including checks and direct deposits, for selected employees during every payroll run. The information can be viewed in the Person Results window of the Payroll module in Oracle Fusion. A row is displayed for each payment that has been processed for an employee. This report can be used to fetch details of the check payments and direct deposits processed for employees within the given date range. It displays information such as payment type, method, status, amount, check number, and bank details of the selected employees. Access to this report is dependent on the Payroll Administrator and Payroll Manager roles.
Payroll to GL Reconciliation
This report reconciles payroll to costing in GL and identifies any differences at the employee level. GL information is retrieved only if there is an index created on GL_JE_LINES. The information can be viewed using the Person Results screen of the Payroll module in Oracle Fusion. A row is displayed for each element that has been processed, costed, and transferred to GL during the payroll run for an employee. The report also provides a PDF output. It can be used to identify differences in costing to GL amounts for employees, as well as on a departmental level. It displays details such as element name, payroll amount, costed amount, GL amount, costing segments, GL batch name, and GL period name, along with employee information. Access to this report is dependent on Payroll Administrator and Payroll Manager roles.
Payroll Comparison Report
This report compares the run results from two different payroll periods for a given payroll and shows differences that are greater than the specified variance. To submit this report, two payroll period end dates must be entered as parameters, and the report will compare the run results and provide the details. The information can be viewed using the Person Results screen of the Payroll module in Oracle Fusion. A row is displayed for each element that has been processed in the two payroll periods for an employee. This report can be used to identify the variance in the run amounts of the elements between two payroll periods. It displays information such as balance name, payroll period run amounts, differences in run amounts, and percentage variance for each employee. Access to this report is dependent on Payroll Administrator and Payroll Manager roles.
Tax Balance Report Date Range
This report shows tax balance amounts for all categories, tax types, and jurisdictions for each employee within the specified date range. The information can be viewed using the Payslips task of the Payroll module in Oracle Fusion. A row is displayed for each employee for whom payroll has been processed within the specified date range. This report can be used to list the tax balances processed in the payroll for an employee. It displays total voluntary deductions, NI employer, NI employee, and total deductions for each employee. Access to this report is dependent on the Payroll Administrator and Payroll Manager roles.
Benefits
- Benefits Enrollment Results
- Benefits Enrollment Rates
- Dependents and Beneficiary Report
- Life Event Report
Benefits Enrollment Results
This report displays information about beneficiary enrollment results. The information is available on the Benefits Summary screen under the Enrollment section of the Fusion Benefits module. A row is displayed for each beneficiary. This report can be used to retrieve details of programs, plans, options, and life events. It displays information such as benefit group name, enrollment coverage start date, enrollment coverage end date, and original enrollment date. Access to this report is dependent on the Benefits Administrator and Benefits Manager roles.
Benefits Enrollment Rates
This report displays information about beneficiary enrollment rates. The information is available on the Benefits Summary screen under the Enrollment section of the Fusion Benefits module. A row is displayed for each beneficiary. This report can be used to retrieve the details of the rates for each beneficiary program. It displays information such as participant rate values, employee contributions, rate tax type, and rate activity type name. Access to this report is dependent on the Benefits Administrator and Benefits Manager roles.
Dependents and Beneficiary Report
This report displays information about beneficiaries and their respective dependents. The information is available on the Benefits Summary screen under the Enrollment section of the Fusion Benefits module. A row is displayed for each beneficiary. This report can be used to fetch dependent details of a beneficiary. It displays information such as the dependent's full name, dependent NI number, contact type, along with personal and assignment information. Access to this report is dependent on the Benefits Administrator and Benefits Manager roles.
Life Event Report
This report displays information about personal life events and potential life events, including the status of the employee. The information is available on the Benefits Service Center screen of the Fusion Benefits module. A row is displayed for each employee. This report can be used to retrieve details of an employee's life events. It displays information such as life event name, life event status, and occurrence date, along with employee information. Access to this report is dependent on the Benefits Administrator and Benefits Manager roles.
Absence Management
Absence Details
This report provides information about the absence details of employees. The information is available on the Absence Records page of the Absence Management module. A row is displayed for each absence entry of an employee based on various absence types. The report can be used to retrieve absence details, displaying information such as Person Name, Absence Status, Absence Type, Absence Reason, Approval Status, and Duration.
Absence Top Employees by Department
This report displays the employees with the top 5 absences in each department. The information is available on the Absence Records page of the Absence Management module. A row is displayed for each employee who has availed the most number of absence days department-wise. The report can be used to track employees who have more frequent absences. It displays information such as Person Name, Absence Type, Absence Reason, Approval Status, Start Date, End Date, Duration, and more.
Absence Eligibility
This report lists the details of employees' eligibility for different absence plans. The information is available on the Absence Records page of the Absence Management module. A row is displayed for each employee's absence plan eligibility. The report can be used to identify different absence plans for which an employee is eligible. It displays information such as Person Name, Eligibility Profile Name, Eligibility Effective Start Date, Eligibility Effective End Date, Absence Plan Name, Plan Status, and more.
Accrued Balances Report
This report provides information on employees' accrual balances for various plans. The information is available on the Absence Records page of the Absence Management module. A row is displayed for each absence plan accrual entry detail. The report can be used to track leave balances. It displays details such as Person Name, Plan Name, Accrual Period, Begin Balance, End Balance, Accrued, and more.
Recruitment
Application Tracking History
This report displays information about applicants. The information is available in the Job Requisitions/Applications section. A row is displayed for each application, showing details of candidates who applied to one or more requisitions. It includes information such as when the candidate applied to a requisition and all the phases or states the applicant has gone through.
Candidates List
This report displays information about all candidates. The information is available in the Candidates Search section. A row is displayed for each candidate, showing personal details, email address, status, and candidate type. It also provides details such as candidate name, candidate number, candidate type, recent employer, location, school, degree, and date of birth.
Time To Hire
This report displays information about the time taken to hire an application. The submission date is considered the start date, and the time is calculated until the application reaches the HR phase. A row is displayed for each hire, showing the details of candidates hired for any job requisition. It provides information such as candidate name, job requisition name, and time taken to hire.
Top 10 Previous Employers for Hires
This report displays information about the top 10 previous employers from where employees are hired most frequently. Candidates who did not provide their previous employment information are excluded from the report. The information is available in the Candidate Details section. A row is displayed for each previous employer along with the hired count. It includes details about the previous employers and the number of hires.
Finance
- Account Balances with Subledger Detail
- As of Date AP Aging
- As of Date AR Aging
- PO Matching Detail Report
- Trial Balance
Account Balances with Subledger Detail
This report prints the journal entry lines and beginning and ending balances of the accounts requested. For each journal entry line, the report prints the accounting date, category, journal batch name, header, sequence, number, line, description, and amount. For each journal entry line, the report also prints subledger details, including the vendor or customer name, transaction number, associated transaction, sequence, number, line, and transaction type.
As of Date AP Aging
This report displays detail information about aging analysis for payables invoice according to the specified Date.
As of Date AR Aging
This report displays detail information about aging analysis for receivables according to the specified date.
PO Matching Detail Report
This report displays information about how purchase order was matched. The Report has PO Number, Supplier Name, Supplier Number as parameters
Trial Balance
The Detailed report enables a review of general ledger actual account balances. It prints a line for each of your accounts and lists them in ascending order by account segment value. For each account, the report provides the beginning balance, period activity, and ending balance. The Actuals report also enables a review of general ledger actual account balances, printing a line for each account and listing them in ascending order by account segment value. It also provides the beginning balance, period activity, and ending balance for each account.
Supply Chain
Back Order Report (Backlog)
This report lists all the customer orders that have been backordered(sales order (Lines) which are not processed due to unavailability of the enough quantity in the subinventory).
Inventory On Hand
The Onhand Quantity Report displays the total quantity of an item in a subinventory.
Inventory Layer
Inventory Layered Report displays the quantity, unit cost and value of your inventory in hand. If you run this report using either the FIFO or LIFO cost type, depending on the costing method, the subinventories (stock) and intransit items are valued at FIFO or LIFO costs.
Open Purchase Order
This report can be used to get the details of open purchase orders within a data range, supplier range or PO number range.
