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

1,745 reports

DescriptionDownload
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
PAY Inland Revenue Form IR21 (Singapore)
Imported from BI Publisher Description: Inland Revenue Form IR21 (Singapore) Application: Payroll Source: Inland Revenue Form IR21 (Singapore) (XML) Short Name: PAYSG21A_XML DB package: PAY_PAYSG21A_XMLP_PKG
 Payroll BI Publisher XML
PAY Inland Revenue IR21 Main (Singapore)
Application: Payroll Source: Inland Revenue IR21 Main (Singapore) (XML) Short Name: PAYSG21B_XML DB package: PAY_PAYSGI21_XMLP_PKG
 Payroll BI Publisher XML
PAY Inland Revenue Remittance Certificate
Imported from BI Publisher Description: Inland Revenue Remittance Certificate (New Zealand) Application: Payroll Source: Inland Revenue Remittance Certificate (XML) Short Name: PYNZ345_XML DB package: PAY_PYNZ345_XMLP_PKG
 Payroll BI Publisher XML
PAY KR Health Insurance Premium Adjustment Annual Earnings
Application: Payroll Source: KR Health Insurance Premium Adjustment Annual Earnings Report (XML) Short Name: PAYKRHCL_XML DB package: PAY_PAYKRHCL_XMLP_PKG
 Payroll BI Publisher XML
PAY KR Separation Pay Liability Detail
Imported from BI Publisher Description: KR Separation Pay Liability Detail Report Application: Payroll Source: KR Separation Pay Liability Detail Report (XML) Short Name: PAYKRSPL_XML DB package: PAY_PAYKRSPL_XMLP_PKG
 Payroll BI Publisher XML
PAY KR Separation Pay Liability Summary
Imported from BI Publisher Description: KR Separation Pay Liability Summary Report Application: Payroll Source: KR Separation Pay Liability Summary Report (XML) Short Name: PYKRSSEL_XML DB package: PAY_PYKRSSEL_XMLP_PKG
 Payroll BI Publisher XML
PAY KR Simple Earnings Report Efile
Imported from BI Publisher Application: Payroll Source: KR Simple Earnings Report Efile Short Name: PAYKRSER DB package:
 Payroll BI Publisher XML
PAY Leave Liability Report (Australasia)
Imported from BI Publisher Description: Leave Liability Report (Australasia) Application: Payroll Source: Leave Liability Report (Australasia) (XML) Short Name: PYAULLAL_XML DB package: PAY_PYAULLAL_XMLP_PKG
 Payroll BI Publisher XML
PAY Leave Liability Report (Australasia) (1)
Imported from BI Publisher Description: Leave Liability Report (Australasia) Application: Payroll Source: Leave Liability Report (Australasia) (XML) Short Name: PYAULLAL_XML DB package: PAY_PYAULLAL_XMLP_PKG
 Payroll BI Publisher XML
PAY List Payroll Actions and Results By Person
Imported from BI Publisher Description: List Payroll Actions and Results for a Person Application: Payroll Source: List Payroll Actions and Results By Person (XML) Short Name: PAYRPACT_XML DB package: PAY_PAYRPACT_XMLP_PKG
 Payroll BI Publisher XML
PAY MPF Remittance
Imported from BI Publisher Description: MPF Remittance Report Application: Payroll Source: MPF Remittance Report (XML) Short Name: PAYHKMPF_XML DB package: PAY_PAYHKMPF_XMLP_PKG
 Payroll BI Publisher XML
PAY NACHA
Imported from BI Publisher Description: NACHA Report Application: Payroll Source: NACHA Report (XML) Short Name: PAYRPNAC_XML DB package: PAY_PAYUSNAC_XMLP_PKG
 Payroll BI Publisher XML
PAY NI Class Validation
Imported from BI Publisher Description: NI Class Validation Report Application: Payroll Source: NI Class Validation Report (XML) Short Name: PYGBNICV_XML DB package: PAY_PYGBNICV_XMLP_PKG
 Payroll BI Publisher XML
PAY NZ Generate ED Payday Exception
Imported from BI Publisher Application: Payroll Source: NZ Generate ED Payday Exception Report Short Name: PYNZEDEXP_XML DB package:
 Payroll BI Publisher XML
PAY NZ Generate ED Payday File
Imported from BI Publisher Application: Payroll Source: NZ Generate ED Payday File Short Name: PYNZED_XML DB package:
 Payroll BI Publisher XML
PAY NZ Generate EI Amended
Imported from BI Publisher Description: The eText output of NZ Payday Report - Amended Application: Payroll Source: NZ Generate EI Amended Report Short Name: PYNZEIAM_XML DB package:
 Payroll BI Publisher XML
PAY NZ Generate EI Payday
Imported from BI Publisher Description: The eText output of NZ Payday Report Application: Payroll Source: NZ Generate EI Payday Report Short Name: PYNZEI_XML DB package:
 Payroll BI Publisher XML
PAY NZ Payday Reconciliation
Imported from BI Publisher Description: NZ Reconciliation report spawned by NZ Payday Report Application: Payroll Source: NZ Payday Reconciliation Report Short Name: PYNZEIVALID_XML DB package:
 Payroll BI Publisher XML
PAY New Zealand CEC Contributions
Imported from BI Publisher Application: Payroll Source: New Zealand CEC Contributions Report Short Name: PAYNZCECETC DB package: pay_nz_cec_report_pkg
 Payroll BI Publisher XML
PAY P45
Application: Payroll Source: P45 Report (XML) Short Name: PAYRPP45_XML DB package: PAY_PAYGBP45_XMLP_PKG
 Payroll BI Publisher XML
PAY P45 A4
Application: Payroll Source: P45 A4 Report Short Name: PYGBA4P45 DB package: PAY_PAYGBP45_A4_PKG
 Payroll BI Publisher XML
PAY P45 Report (laser)
Application: Payroll Source: P45 Report (laser) (XML) Short Name: PAYGB45L_XML DB package: PAY_PAYGB45L_XMLP_PKG
 Payroll BI Publisher XML
PAY P46 EDI Process v6 Output
Application: Payroll Source: P46 EDI Process v6 Output Short Name: GB_P46_V6_ETO DB package: PAY_GB_P46V6_EDI_BIP
 Payroll BI Publisher XML
PAY P46EXP EDI Process v6 Output
Application: Payroll Source: P46EXP EDI Process v6 Output Short Name: GB_P46EXP_V6_ETO DB package: PAY_GB_P46EXP_EDI_BIP
 Payroll BI Publisher XML
PAY PQP GB Scottish LGPS End of Year Report Output
Application: Payroll Source: PQP GB Scottish LGPS End of Year Report Output Short Name: PQGBSCLGPSROP DB package:
 Payroll BI Publisher XML
PAY Pay Advice
Imported from BI Publisher Description: GB Pay Advice Report Application: Payroll Source: Pay Advice (XML) Short Name: PAYGBSOE_XML DB package: PAY_PAYGBSOE_XMLP_PKG
 Payroll BI Publisher XML
PAY Pay Advice (Australia)
Imported from BI Publisher Description: Pay Advice (Australia) Application: Payroll Source: Pay Advice (Australia) (XML) Short Name: PAYAUSOE_XML DB package: PAY_PAYAUSOE_XMLP_PKG
 Payroll BI Publisher XML