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 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
PAY RTI - Employer Payment Summary Output File
Application: Payroll Source: RTI - Employer Payment Summary Output File Short Name: PYGBRTIEPSOP14 DB package:
 Payroll BI Publisher XML
PAY RTI - Employer Payment Summary Output File 2017/18
Application: Payroll Source: RTI - Employer Payment Summary Output File 2017/18 Short Name: PYGBEPSEDIOP17 DB package:
 Payroll BI Publisher XML
PAY RTI - Full Payment Submission Output 2013/14
Application: Payroll Source: RTI - Full Payment Submission Output 2013/14 Short Name: PYGBRTIFPSOP13 DB package:
 Payroll BI Publisher XML
PAY RTI - Full Payment Submission Output 2014/15
Application: Payroll Source: RTI - Full Payment Submission Output 2014/15 Short Name: PYGBRTIFPSOP14 DB package:
 Payroll BI Publisher XML
PAY RTI - Full Payment Submission Output 2015/16
Application: Payroll Source: RTI - Full Payment Submission Output 2015/16 Short Name: PYGBRTIFPSOP15 DB package:
 Payroll BI Publisher XML
PAY RTI - Full Payment Submission Output 2016/17
Application: Payroll Source: RTI - Full Payment Submission Output 2016/17 Short Name: PYGBRTIFPSOP16 DB package:
 Payroll BI Publisher XML
PAY RTI - Full Payment Submission Output 2017/18
Application: Payroll Source: RTI - Full Payment Submission Output 2017/18 Short Name: PYGBRTIFPSOP17 DB package:
 Payroll BI Publisher XML
PAY RTI - NINO Verification Request Process - NVR Output
Application: Payroll Source: RTI - NINO Verification Request Process - NVR Output Short Name: PYGBRTININOOP DB package:
 Payroll BI Publisher XML
PAY RTI - Year End P60 Report Process
Imported from BI Publisher Application: Payroll Source: RTI - Year End P60 Report Process Short Name: PYGBRTIP60OP DB package:
 Payroll BI Publisher XML
PAY RTI - Year End P60 Report Process (Multi Threaded)
Imported from BI Publisher Description: RTI - Year End P60 Report Process Application: Payroll Source: RTI - Year End P60 Report Process (Multi Threaded) Short Name: PYGBP60MULTI DB package:
 Payroll BI Publisher XML
PAY RTI ? Employer Alignment Submission Output
Application: Payroll Source: RTI ? Employer Alignment Submission Output Short Name: PYGBRTIEASOP DB package:
 Payroll BI Publisher XML
PAY RTI EYU Run Reconciliation
Application: Payroll Source: RTI EYU Run Reconciliation Report Short Name: PYGBEYUREC DB package:
 Payroll BI Publisher XML
PAY RTI FPS Amendments Run Reconciliation
Imported from BI Publisher Application: Payroll Source: RTI FPS Amendments Run Reconciliation Report Short Name: PYGBFPSAMEREC DB package:
 Payroll BI Publisher XML
PAY RTI FPS Run Reconciliation
Application: Payroll Source: RTI FPS Run Reconciliation Report Short Name: PYGBFPSREC DB package:
 Payroll BI Publisher XML
PAY RTI YTD Reconciliation Report Output
Imported from BI Publisher Application: Payroll Source: RTI YTD Reconciliation Report Output Short Name: PYGBRTIRECDISOP20 DB package: PAY_GB_RTI_REC_DIFF
 Payroll BI Publisher XML
PAY RTI Year to Date Reconciliation Report Output
Application: Payroll Source: RTI Year to Date Reconciliation Report Output Short Name: PYGBRTIRECOP DB package: PAY_GB_RTI_REC
 Payroll BI Publisher XML
PAY RTI Year to Date Reconciliation Report output
Application: Payroll Source: RTI Year to Date Reconciliation Report output Short Name: PYGBRTIRECDISOP DB package: PAY_GB_RTI_REC_DIFF
 Payroll BI Publisher XML
PAY Real Time Class 1A NIC
Imported from BI Publisher Application: Payroll Source: Real Time Class 1A NIC Report Short Name: PYGBRTNIC_XML DB package:
 Payroll BI Publisher XML
PAY STP Archive Exception
Imported from BI Publisher Description: Australian Single Touch Payroll Exception report Application: Payroll Source: STP Archive Exception Report Short Name: PYAUSTPARC_XML DB package:
 Payroll BI Publisher XML
PAY STP Archive Validation
Imported from BI Publisher Description: Australian Single Touch Payroll Validation report Application: Payroll Source: STP Archive Validation Report Short Name: PYAUSTPVALID_XML DB package:
 Payroll BI Publisher XML
PAY STP Report Declaration
Imported from BI Publisher Description: Single Touch Payroll Report Declaration to ATO Application: Payroll Source: STP Report Declaration Short Name: PYAUSTPDECL_XML DB package:
 Payroll BI Publisher XML
PAY STP W1 and W2 Reporting
Imported from BI Publisher Application: Payroll Source: STP W1 and W2 Reporting Short Name: PYAUSTPWRPT_XML DB package:
 Payroll BI Publisher XML
PAY Statement Of Earnings (New Zealand)
Imported from BI Publisher Description: Statement Of Earnings (New Zealand) Application: Payroll Source: Statement Of Earnings (New Zealand) (XML) Short Name: PYNZSOE_XML DB package: PAY_PYNZSOE_XMLP_PKG
 Payroll BI Publisher XML
PAY Summary of Tax Certificates
Imported from BI Publisher Application: Payroll Source: Summary of Tax Certificates Short Name: PYZASOTC_XML DB package: PAY_ZA_SOTC_PKG
 Payroll BI Publisher XML
PAY SuperStream Combined Report Alternative Format
Application: Payroll Source: SuperStream Combined Report Alternative Format Short Name: PYAUSUPCOMBCSV_XSLFO DB package: PAY_AU_SUPER_STREAM_ARCHIVE
 Payroll BI Publisher XML
PAY SuperStream Combined Report Alternative Format (ALL FUNDS)
Application: Payroll Source: SuperStream Combined Report Alternative Format (ALL FUNDS) Short Name: PYAUSUPCOMBALLCSV_XSLFO DB package: PAY_AU_SUPER_STREAM_ARCHIVE
 Payroll BI Publisher XML
PAY SuperStream Contribution Report Alternative Format
Application: Payroll Source: SuperStream Contribution Report Alternative Format Short Name: PYAUSUPCONTRCSV_XSLFO DB package: PAY_AU_SUPER_STREAM_ARCHIVE
 Payroll BI Publisher XML