Blitz Report™ Library

This library is a free open source SQL knowledge base for Oracle E-Business Suite customers and IT professionals. It contains SQLs that we created (category: Enginatics) and SQLs imported from Oracle’s BI Publisher reports (category: BI Publisher).

If you have Bitz Report installed, you can download a single or multiple reports as XML file from this library and automatically load them into your environment, including parameters, LOVs and category assignments.

If you would like to try one of these SQLs without having Blitz Report installed, as SQLs are composed dynamically at runtime, it is easiest to copy the query from the second tab of the example Excel sheet instead from the report’s detail page. Note that some of the reports require functions from utility package xxen_util.

To facilitate development work and help learning the EBS table structure, there are hyperlinks on each table to navigate directly to the corresponding Oracle ETRM record.

We also encourage you to contribute by adding your own SQL reports or suggesting enhancements and corrections to existing SQLs.
To add new reports, simply log in to our online demo environment, create a Blitz Report and it will automatically show up in this library (creation of a Blitz Report is shown here).

Module GL 143 AP 146 AR 123 FA 138 CE 25 PO 116 INV 130 OM 89 MFG 215 COST 175 PA 131 HR 182 PAY 152 SYS 162

152 reports

DescriptionDownload
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 line's values with the input value names of the element in display sequence, which is the order in which BEE assigns Value 1 to Value 15. Use Line Status Error to review lines that failed validation or transfer before correcting and revalidating the batch.
 Payroll Enginatics XLS XML
PAY Costing Detail
Imported from Concurrent Program Application: Payroll Source: Costing Detail Report Short Name: PAYRPCDR
 Payroll Enginatics XLS XML
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 employees whose entries are still valid at that date. One row per element entry and input value, so that the values of an input value, for example Pay Value or Amount, can be filtered and summed across employees and elements. An entry without input values shows one row with blank input value columns. Entry Value shows the meaning of lookup validated input values and dates in display format. Numeric Value holds the value of money, number,…
full description		 Payroll Enginatics XLS XML
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 to employees.
 Payroll Enginatics XLS XML
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 monitoring payroll runs, prepayments, costing, transfers to the ledger and other payroll processes. Messages counts the process level and assignment action level messages. First Message is the first process level message, or else the first fatal assignment action message. Use Errors Only to list processes in error or with assignment actions in error, for example as a scheduled alert.
 Payroll Enginatics XLS XML
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 Pre-Tax, Tax, Voluntary and Involuntary Deductions, which equals the prepayment amount of the US payroll. Imputed Earnings and Information elements do not count towards it. Previous Net Pay is the employee's net pay of the preceding payroll run date within the selected run date range, so the first run date of an employee has no variance. Use Variance % Over to list only changes above a percentage.
 Payroll Enginatics XML
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, employer charges, and calculated net pay. Based on completed payroll run results. Useful for payroll reconciliation and compensation analysis.
 Payroll Enginatics XML
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 of each step from hire to the first payment, the termination dates, and the payroll processing exceptions of the period. Assignment columns are those of the primary assignment on Date To, or on the termination date for a leaver. New Hire and Leaver mark a hire or termination date within the period. Payroll Ready Date is the later of the hire date and the dates the payroll and the first approved salary were entered. First Period Cut Off…
full description		 Payroll Enginatics, R12 only XML
PAY Database Triggers Status
Application: Payroll Source: Database Triggers Status Report (XML) Short Name: PAYRPHTS_XML DB package: PAY_PAYRPHTS_XMLP_PKG
 Payroll BI Publisher XLS XML
PAY Dynamic Triggers Status
Application: Payroll Source: Dynamic Triggers Status Report (XML) Short Name: PAYRPDTR_XML DB package: PAY_PAYRPDTR_XMLP_PKG
 Payroll BI Publisher XLS XML
PAY Dynamic Triggers missing from Database
Application: Payroll Source: Dynamic Triggers missing from Database (XML) Short Name: PAYRPTMD_XML DB package: PAY_PAYRPTMD_XMLP_PKG
 Payroll BI Publisher XLS XML
PAY Functional Area
Application: Payroll Source: Functional Area Report (XML) Short Name: PAYRPFAR_XML DB package: PAY_PAYRPFAR_XMLP_PKG
 Payroll BI Publisher XLS XML
PAY GRE Totals
Imported from BI Publisher Description: Display GRE Tax Totals prior to Magtape run Application: Payroll Source: GRE Totals Report (XML) Short Name: PAYUSTOT_XML DB package: PAY_PAYUSTOT_XMLP_PKG
 Payroll BI Publisher XLS XML
PAY IE Cheque Listing
Application: Payroll Source: IE Cheque Listing (XML) Short Name: PAYIECHL_XML DB package: PAY_PAYIECHL_XMLP_PKG
 Payroll BI Publisher XLS XML
PAY Quarterly Employment Survey
Imported from BI Publisher Description: Quarterly Employment Survey (New Zealand) Application: Payroll Source: Quarterly Employment Survey (XML) Short Name: PYNZQES_XML DB package: PAY_PYNZQES_XMLP_PKG
 Payroll BI Publisher XLS XML
PAY A8A Summary
Application: Payroll Source: A8A Summary Report Short Name: PYSGA8A_XML DB package:
 Payroll BI Publisher XML
PAY A8B Summary
Application: Payroll Source: A8B Summary Report Short Name: PYSGA8B_XML DB package:
 Payroll BI Publisher XML
PAY A8B Summary (1)
Imported from BI Publisher Description: Generate IR8A MOAs and Summary Report Application: Payroll Source: A8B Summary Report Short Name: PYSGA8B_XML DB package:
 Payroll BI Publisher XML
PAY Advance Pay Listing (Australasia)
Imported from BI Publisher Description: Advance Pay Listing (Australasia) Application: Payroll Source: Advance Pay Listing (Australasia) (XML) Short Name: PYAUAPL_XML DB package: PAY_PYAUAPL_XMLP_PKG
 Payroll BI Publisher XML
PAY Annual FUTA Tax Return (Form 940)
Imported from BI Publisher Description: Annual FUTA Tax Return (Form 940) Application: Payroll Source: Annual FUTA Tax Return (Form 940) (XML) Short Name: PAYRP940_XML DB package: PAY_PAYRP940_XMLP_PKG
 Payroll BI Publisher XML
PAY Assignments Unavailable for Processing
Imported from BI Publisher Description: List the assignments on a payroll who won't be picked up in the run Application: Payroll Source: Assignments Unavailable for Processing (XML) Short Name: PAYRPBLK_XML DB package: PAY_PAYRPBLK1_XMLP_PKG
 Payroll BI Publisher XML
PAY Business Payrolls Survey
Imported from BI Publisher Description: Business Payrolls Survey Report Application: Payroll Source: Business Payrolls Survey (XML) Short Name: PAYCABPS_XML DB package: PAY_PAYCABPS_XMLP_PKG
 Payroll BI Publisher XML
PAY COIDA
Imported from BI Publisher Application: Payroll Source: COIDA Report Short Name: PYZARPCOXML DB package:
 Payroll BI Publisher XML
PAY Deductions
Imported from BI Publisher Description: Deductions Report. Application: Payroll Source: Deductions Report (XML) Short Name: PAYUSDED_XML DB package: PAY_PAYUSDED_XMLP_PKG
 Payroll BI Publisher XML
PAY Dutch AOW HR
Application: Payroll Source: Dutch AOW HR Report Short Name: PAYNLAOW_HR DB package: PAY_AOW_HR_REPORT_PKG
 Payroll BI Publisher XML
PAY Dutch Labour Cost Agreement Audit
Imported from BI Publisher Description: Dutch Labour Cost Agreement - Audit Report Application: Payroll Source: Dutch Labour Cost Agreement Audit Report Short Name: PAY_NL_LCA_AUDIT DB package:
 Payroll BI Publisher XML
PAY Earnings Audit
Imported from BI Publisher Description: Earnings Audit Report Application: Payroll Source: Earnings Audit Report (XML) Short Name: PAYRPEAR_XML DB package: PAY_PAYUSEAR_XMLP_PKG
 Payroll BI Publisher XML
PAY Electronic Tax File
Imported from BI Publisher Application: Payroll Source: Electronic Tax File Short Name: PYZAIRPM_XML DB package: PAY_ZA_ELE_TAX_FILE
 Payroll BI Publisher XML
PAY Employee Bank Accounts Payroll Draft XML
PAY Employee Run Results
Imported from BI Publisher Description: Employee Run Results Report Application: Payroll Source: Employee Run Results Report (XML) Short Name: PAYUSRRS_XML DB package: PAY_PAYUSRRS_XMLP_PKG
 Payroll BI Publisher XML
PAY Employee Run Results Report (CA)
Imported from BI Publisher Description: Employee Run Results Report Application: Payroll Source: Employee Run Results Report (CA) (XML) Short Name: PAYCARRS_XML DB package: PAY_PAYCARRS_XMLP_PKG
 Payroll BI Publisher XML
PAY Employee Run Results Summary Report (GB)
Imported from BI Publisher Description: Employee Run Results Summary Report (GB) Application: Payroll Source: Employee Run Results Summary Report (GB) (XML) Short Name: PYGBERRS_XML DB package: PAY_PAYGBRRS_XMLP_PKG
 Payroll BI Publisher XML
PAY Employee Salary
Profile report showing the employee demographic information including name, gender SSN, birthdate, age, nationality, effective start date, and additional profile information.
 Payroll Draft XML
PAY Employment Tax Incentive Register
Imported from BI Publisher Application: Payroll Source: Employment Tax Incentive Register Report Short Name: PYZAETIR DB package: PAY_ZA_ETI
 Payroll BI Publisher XML
PAY End of Year Reconciliation Detail
Application: Payroll Source: End of Year Reconciliation Detail (XML) Short Name: PYAUREPSR_XML DB package: PAY_PYAURECD_XMLP_PKG
 Payroll BI Publisher XML
PAY End of Year Reconciliation Summary Totals
Application: Payroll Source: End of Year Reconciliation Summary Totals (XML) Short Name: PYAURECPR_XML DB package: PAY_PYAURECP_XMLP_PKG
 Payroll BI Publisher XML
PAY Exception Reporting for China Payroll Data Export
Application: Payroll Source: Exception Reporting for China Payroll Data Export Short Name: PYCNAOESP DB package:
 Payroll BI Publisher XML
PAY Fringe Benefits
Imported from BI Publisher Description: Fringe Benefits Report Application: Payroll Source: Fringe Benefits Report (XML) Short Name: PYAUFBR_XML DB package: PAY_PYAUFBR_XMLP_PKG
 Payroll BI Publisher XML
PAY GB - DEA Payment Schedule Output
Application: Payroll Source: GB - DEA Payment Schedule Output Short Name: PYGBDEASOP DB package:
 Payroll BI Publisher XML
PAY GB - DEO Payment Schedule Output
Application: Payroll Source: GB - DEO Payment Schedule Output Short Name: PYGBDEOSOP DB package:
 Payroll BI Publisher XML
PAY GB Apprenticeship Levy Costing Sheet
Imported from BI Publisher Description: GB Apprenticeship Levy Costing Report Application: Payroll Source: GB Apprenticeship Levy Costing Sheet Short Name: PYGBAPRCS DB package:
 Payroll BI Publisher XML
PAY GB BIK Audit
Application: Payroll Source: GB BIK Audit Report Short Name: PYGBBIKAUDIT DB package:
 Payroll BI Publisher XML
PAY GB BIK Class 1A NIC
Application: Payroll Source: GB BIK Class 1A NIC Report Short Name: PYGBBIKNIC DB package:
 Payroll BI Publisher XML
PAY GB Pensions Automatic Enrollment
Application: Payroll Source: GB Pensions Automatic Enrollment Report Short Name: PYGBPAER DB package:
 Payroll BI Publisher XML
PAY GB Pensions Automatic Enrollment not applied
Application: Payroll Source: GB Pensions Automatic Enrollment not applied Short Name: PYGBPAENR DB package:
 Payroll BI Publisher XML
PAY GB Pensions Automatic Re-enrolment
Application: Payroll Source: GB Pensions Automatic Re-enrolment Report Short Name: PYGBPARER DB package:
 Payroll BI Publisher XML
PAY GB Pensions Qualifying Scheme exists
Application: Payroll Source: GB Pensions Qualifying Scheme exists Short Name: PYGBPAEQ DB package:
 Payroll BI Publisher XML
PAY Gender Pay Gap
Application: Payroll Source: Gender Pay Gap Report Short Name: PYGBGPGREP DB package:
 Payroll BI Publisher XML
PAY Generate Employer Quarterly Tax Returns (India) - Excel
Application: Payroll Source: Generate Employer Quarterly Tax Returns (India) - Excel Short Name: PAYINF24Q DB package:
 Payroll BI Publisher XML
PAY Gross To Net Summary Report (GB)
Imported from BI Publisher Description: Gross To Net Summary Report (GB) Application: Payroll Source: Gross To Net Summary Report (GB) (XML) Short Name: PAYGBGTN_XML DB package: PAY_PAYGBGTN_XMLP_PKG
 Payroll BI Publisher XML