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
BI Publisher Service

141 reports

DescriptionDownload
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 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 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
PAY IE BIK Arrearage
Imported from BI Publisher Description: Irish Benefit in Kind Arrearage Report Application: Payroll Source: IE BIK Arrearage Report (XML) Short Name: PYIEBIKA_XML DB package: PAY_PYIEBIKA_XMLP_PKG
 Payroll BI Publisher XML
PAY IE P30
Imported from BI Publisher Description: P30 Report Application: Payroll Source: IE P30 Report (XML) Short Name: PAYIEP30_XML DB package: PAY_PAYIEP30_XMLP_PKG
 Payroll BI Publisher XML
PAY IE Payroll Submission Reconciliation
Imported from BI Publisher Application: Payroll Source: IE Payroll Submission Reconciliation Report Short Name: PYIESUBREC DB package:
 Payroll BI Publisher XML
PAY IR56B Control Listing
Application: Payroll Source: IR56B Control Listing Report (XML) Short Name: PAYHKCTL_XML DB package: PAY_PAYHKCTL_XMLP_PKG
 Payroll BI Publisher XML
PAY IR8A Summary
Application: Payroll Source: IR8A Summary Report Short Name: PYSGIR8A_XML DB package:
 Payroll BI Publisher XML
PAY IR8S Ad Hoc Printed Report New
Application: Payroll Source: IR8S Ad Hoc Printed Report New (XML) Short Name: PYSG8SAD_XML DB package: PAY_PYSG8SAD_XMLP_PKG
 Payroll BI Publisher XML
PAY IR8S Summary
Application: Payroll Source: IR8S Summary Report Short Name: PYSGIR8S_XML DB package:
 Payroll BI Publisher XML
PAY IRP5 Tax Certificates
Imported from BI Publisher Description: IRP5 Certificates Process Application: Payroll Source: IRP5 Tax Certificates Short Name: PYZAIRP5_XML DB package: PAY_ZA_IRP5_IT3A_XMLP_PKG
 Payroll BI Publisher XML
PAY IT3A Tax Certificates
Imported from BI Publisher Description: IRP5 Certificates Process Application: Payroll Source: IT3A Tax Certificates Short Name: PYZAIT3A_XML DB package: PAY_ZA_IRP5_IT3A_XMLP_PKG
 Payroll BI Publisher XML
PAY Income Tax Ref No Bulk Upload
Imported from BI Publisher Application: Payroll Source: Income Tax Ref No Bulk Upload Short Name: PYZAITREFU DB package: PY_ZA_ITREF_UPLOAD
 Payroll BI Publisher XML