Oracle EBS Payroll Reports

8 ready-to-run SQL reports for Oracle E-Business Suite Payroll, maintained by Enginatics and used in production at Oracle EBS customers worldwide. Each report page lists its parameters, the Oracle EBS tables it reads and an Excel example output. The most frequently used Payroll tables in these reports are hr_all_organization_units_vl, per_all_assignments_f, per_all_people_f, pay_all_payrolls_f, pay_assignment_actions, pay_payroll_actions.

Run any of these reports in Excel in seconds: download Blitz Report™ free – your first 30 reports are free.

Payroll SQL Reports

Report Description
PAY Batch Element Entry Batch Element Entry (BEE) batch lines with their batch header, line status, element, input values and validation or transfer messages. Input Values lists the…
PAY Costing Detail Imported from Concurrent Program Application: Payroll Source: Costing Detail Report Short Name: PAYRPCDR
PAY Element Entries Element entries and their input values valid at the Effective Date, for all assignments including non-primary assignments and the assignments of terminated…
PAY Employee Payroll History Payroll results per employee and payroll run date: run result Pay Values summed by element classification. Net Pay is Earnings plus Supplemental Earnings minus…
PAY Gross to Net Summary Payroll gross-to-net summary per employee and pay period, showing gross pay (earnings), pre-tax deductions, involuntary deductions (tax), voluntary deductions…
PAY Hire to Retire Tracker One row per employee period of service that overlaps the period from Date From to Date To: new hires, leavers and everyone employed in between, with the date…
PAY Payroll Element Details Master data report showing HR payroll element details. Elements are the units used to build all the earnings, deductions and benefits that companies can give…
PAY Payroll Process Summary Payroll processes (payroll actions) of all action types with their assignment action counts by status, the number of messages and the first message, for…

← All Oracle EBS modules

© Enginatics GmbH