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 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 SARS Codes Payroll Draft 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
PAY SuperStream Contribution Report Alternative Format (ALL FUNDS)
Application: Payroll Source: SuperStream Contribution Report Alternative Format (ALL FUNDS) Short Name: PYAUSUPCONTRALLCSV_XSLFO DB package: PAY_AU_SUPER_STREAM_ARCHIVE
 Payroll BI Publisher XML
PAY SuperStream Contribution Report XBRL
Application: Payroll Source: SuperStream Contribution Report XBRL Short Name: PYAUSUPCONTR_XML DB package: PAY_AU_SUPER_STREAM_ARCHIVE
 Payroll BI Publisher XML
PAY SuperStream Registration Report Alternative Format
Application: Payroll Source: SuperStream Registration Report Alternative Format Short Name: PYAUSUPREGICSV_XSLFO DB package: PAY_AU_SUPER_STREAM_ARCHIVE
 Payroll BI Publisher XML
PAY SuperStream Registration Report Alternative Format (ALL FUNDS)
Application: Payroll Source: SuperStream Registration Report Alternative Format (ALL FUNDS) Short Name: PYAUSUPREGIALLCSV_XSLFO DB package: PAY_AU_SUPER_STREAM_ARCHIVE
 Payroll BI Publisher XML
PAY SuperStream Registration Report XBRL
Application: Payroll Source: SuperStream Registration Report XBRL Short Name: PYAUSUPREGI_XML DB package: PAY_AU_SUPER_STREAM_ARCHIVE
 Payroll BI Publisher XML
PAY Superannuation Contribution
Imported from BI Publisher Description: Superannuation Contribution Report Application: Payroll Source: Superannuation Contribution Report (XML) Short Name: PYAUSGC_XML DB package: PAY_PYAUSGC_XMLP_PKG
 Payroll BI Publisher XML
PAY TIAA CREF Transmission Report (ASCII)
Application: Payroll Source: TIAA CREF Transmission Report (ASCII) (XML) Short Name: PAYUSTIM_XML DB package: PAY_PAYUSTIM_XMLP_PKG
 Payroll BI Publisher XML
PAY Tax Audit Report Template
Application: Payroll Source: Tax Audit Report Template Short Name: PYZATXAUR DB package: PAY_ZA_TX_AUDIT_ARCHIVE
 Payroll BI Publisher XML
PAY Tax Explanation
Imported from BI Publisher Description: Tax Explanation Details Application: Payroll Source: Tax Explanation Report Short Name: PYZAPAYEEXDT DB package:
 Payroll BI Publisher XML
PAY Tax Payments Listing
Imported from BI Publisher Description: Tax Payments Listing Application: Payroll Source: Tax Payments Listing (XML) Short Name: PAYRPTPL_XML DB package: PAY_PAYGBTPL_XMLP_PKG
 Payroll BI Publisher XML
PAY Tax Register
Imported from BI Publisher Application: Payroll Source: Tax Register Report (XML) Short Name: PYZATXREGREP DB package: PAY_ZA_TAX_REG_AR
 Payroll BI Publisher XML
PAY Void Payments
Imported from BI Publisher Description: Void Payments Report Application: Payroll Source: Void Payments Report (XML) Short Name: PAYRPVPR_XML DB package: PAY_PAYRPVPR_XMLP_PKG
 Payroll BI Publisher XML