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

141 reports

DescriptionDownload
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
PAY Pay Advice (China)
Imported from BI Publisher Description: China Printed Payslip Application: Payroll Source: Pay Advice (China) (XML) Short Name: PAYCNSOE_XML DB package: PAY_PAYCNSOE_XMLP_PKG
 Payroll BI Publisher XML
PAY Pay Advice (Hong Kong)
Imported from BI Publisher Description: Pay Advice (Hong Kong) Application: Payroll Source: Pay Advice (Hong Kong) (XML) Short Name: PAYHKSOE_XML DB package: PAY_PAYHKSOE_XMLP_PKG
 Payroll BI Publisher XML
PAY Pay Advice (Singapore)
Imported from BI Publisher Description: Pay Advice (Singapore) Application: Payroll Source: Pay Advice (Singapore) (XML) Short Name: PAYSGSOE_XML DB package: PAY_PAYSGSOE_XMLP_PKG
 Payroll BI Publisher XML
PAY Payments Summary Report (GB)
Imported from BI Publisher Description: Payments Summary Report (GB Version) Application: Payroll Source: Payments Summary Report (GB) (XML) Short Name: PAYGBPAY_XML DB package: PAY_PAYGBPAY_XMLP_PKG
 Payroll BI Publisher XML
PAY Payroll Actions By Person
Imported from BI Publisher Description: List Payroll Actions and Results for a Person (UK) Application: Payroll Source: Payroll Actions By Person (XML) Short Name: PAYGBACT_XML DB package: PAY_PAYGBACT_XMLP_PKG
 Payroll BI Publisher XML
PAY Payroll Reconciliation (New Zealand)
Imported from BI Publisher Description: Payroll Reconciliation (New Zealand) Application: Payroll Source: Payroll Reconciliation (New Zealand) (XML) Short Name: PYNZREC_XML DB package: PAY_PYNZREC_XMLP_PKG
 Payroll BI Publisher XML
PAY Payroll Reconciliation Detail
Application: Payroll Source: Payroll Reconciliation Detail (XML) Short Name: PYAURECD_XML DB package: PAY_PYAURECD_XMLP_PKG
 Payroll BI Publisher XML
PAY Payroll Report (Check List of Bonus Payment Notification for Health Ins/Welfare Pension Ins)
Imported from BI Publisher Description: Payroll Report (Check List of Bonus Payment Notification for Health Ins/Welfare Pension Ins) Application: Payroll Source: Payroll Report (Check List of Bonus Payment Notification for Health Ins/Welfare Pension Ins) (XML) Short Name: PAYJPBON_XML DB package: PAY_PAYJPBON_XMLP_PKG
 Payroll BI Publisher XML
PAY Payroll Report (Check list for Unemployment Ins)
Imported from BI Publisher Description: Payroll Report (Check list for Unemployment Ins) Application: Payroll Source: Payroll Report (Check list for Unemployment Ins) (XML) Short Name: PAYJPNUI_XML DB package: PAY_PAYJPNUI_XMLP_PKG
 Payroll BI Publisher XML
PAY Payroll Report (Final Notice of Fixed Labor Ins Fee)
Imported from BI Publisher Description: Payroll Report (Final Notice of Fixed Labor Ins Fee) Application: Payroll Source: Payroll Report (Final Notice of Fixed Labor Ins Fee) (XML) Short Name: PAYJPFLI_XML DB package: PAY_PAYJPFLI_XMLP_PKG
 Payroll BI Publisher XML
PAY Payroll Tax Report by Legal Employer
Application: Payroll Source: Payroll Tax Report by Legal Employer (XML) Short Name: PYAUPYL_XML DB package: PAY_PYAUPYT_XMLP_PKG
 Payroll BI Publisher XML
PAY Payslip (Korea)
Imported from BI Publisher Description: Payslip (Korea) Application: Payroll Source: Payslip (Korea) (XML) Short Name: PAYKRSOE_XML DB package: PAY_PAYKRSOE_XMLP_PKG
 Payroll BI Publisher XML
PAY Penny Deduction Detail Report Output
Application: Payroll Source: Penny Deduction Detail Report Output Short Name: PYGBPENNREPOP DB package:
 Payroll BI Publisher XML
PAY ROE Work Sheet
Imported from BI Publisher Description: ROE Work Sheet Report Application: Payroll Source: ROE Work Sheet (XML) Short Name: PYCAROEP_XML DB package: PAY_PYCAROEP_XMLP_PKG
 Payroll BI Publisher XML
PAY RTI - Earlier Year Update Output 2012/13
Application: Payroll Source: RTI - Earlier Year Update Output 2012/13 Short Name: PYGBRTIEYUOP13 DB package:
 Payroll BI Publisher XML
PAY RTI - Earlier Year Update Output 2013/14
Application: Payroll Source: RTI - Earlier Year Update Output 2013/14 Short Name: PYGBRTIEYUOP14 DB package:
 Payroll BI Publisher XML
PAY RTI - Earlier Year Update Output 2014/15
Application: Payroll Source: RTI - Earlier Year Update Output 2014/15 Short Name: PYGBRTIEYUOP15 DB package:
 Payroll BI Publisher XML
PAY RTI - Earlier Year Update Output 2015/16
Application: Payroll Source: RTI - Earlier Year Update Output 2015/16 Short Name: PYGBRTIEYUOP16 DB package:
 Payroll BI Publisher XML
PAY RTI - Earlier Year Update Output 2016/17
Application: Payroll Source: RTI - Earlier Year Update Output 2016/17 Short Name: PYGBRTIEYUOP17 DB package:
 Payroll BI Publisher XML
PAY RTI - Employer Alignment Submission Output April 13
Application: Payroll Source: RTI - Employer Alignment Submission Output April 13 Short Name: PYGBRTIEASOP13 DB package:
 Payroll BI Publisher XML
PAY RTI - Employer Payment Summary Output
Application: Payroll Source: RTI - Employer Payment Summary Output Short Name: PYGBRTIEPSOP DB package:
 Payroll BI Publisher XML
PAY RTI - Employer Payment Summary Output (EPS) File
Application: Payroll Source: RTI - Employer Payment Summary Output (EPS) File Short Name: PYGBRTIEPSEDI DB package:
 Payroll BI Publisher XML
PAY RTI - Employer Payment Summary Output 2013/14
Application: Payroll Source: RTI - Employer Payment Summary Output 2013/14 Short Name: PYGBRTIEPSOP13 DB package:
 Payroll BI Publisher XML