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 143 AR 123 FA 138 CE 25 PO 116 INV 129 OM 89 MFG 214 COST 175 PA 131 HR 182 PAY 151 SYS 162

3,151 reports

DescriptionDownload
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 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
PAY Workplace Gender Equality
Application: Payroll Source: Workplace Gender Equality Report (XML) Short Name: PYAUWPGER_XML DB package:
 Payroll BI Publisher XML
PAY Year End Reconciliation
Application: Payroll Source: Year End Reconciliation Report (XML) Short Name: PAYRPP35_XML DB package: PAY_PAYGBP35_XMLP_PKG
 Payroll BI Publisher XML
PER ADA
Imported from BI Publisher Description: Americans with Disabilities Act Report Application: Human Resources Source: ADA Report (XML) Short Name: PERRPADA_XML DB package: PER_PERUSADA_XMLP_PKG
 Human Resources BI Publisher XML
PER ADA (1)
Imported from BI Publisher Description: Americans with Disabilities Act Report Application: Human Resources Source: ADA Report (XML) Short Name: PERRPADA_XML DB package: PER_PERUSADA_XMLP_PKG
 Human Resources BI Publisher XML
PER ADS Current Vacancy Details (1)
Imported from BI Publisher Description: ADS Current Vacancy Details for Portal Application: Human Resources Source: ADS Current Vacancy Details Short Name: ADSCURVACDET DB package:
 Human Resources BI Publisher XML
PER Absence Calendar
Absence Calendar by John Keymer
 Human Resources XML
PER Absences
Imported from BI Publisher Description: Absences Report Application: Human Resources Source: Absences Report (XML) Short Name: PERRPRAA_XML DB package: PER_PERRPRAA_XMLP_PKG
 Human Resources BI Publisher XML
PER Approvals Deviation
Application: Human Resources Source: Approvals Deviation Report Short Name: AME_DEVIATION_RPT DB package: AME_APPROVER_DEVIATION_PKG
 Human Resources BI Publisher XML
PER COBRA Coverage
Imported from BI Publisher Description: COBRA Coverage Report Application: Human Resources Source: COBRA Coverage Report (XML) Short Name: PERRPCCR_XML DB package: PER_PERUSCCR_XMLP_PKG
 Human Resources BI Publisher XML
PER COBRA Expiration Letter
Imported from BI Publisher Description: COBRA Expiration Letter Application: Human Resources Source: COBRA Expiration Letter (XML) Short Name: PERRPCNE_XML DB package: PER_PERUSCNE_XMLP_PKG
 Human Resources BI Publisher XML
PER COBRA Grace Period Expiration Letter
Imported from BI Publisher Description: COBRA Grace Period Expiration Letter Application: Human Resources Source: COBRA Grace Period Expiration Letter (XML) Short Name: PERRPCPE_XML DB package: PER_PERUSCPE_XMLP_PKG
 Human Resources BI Publisher XML
PER COBRA Notification Letter
Imported from BI Publisher Description: COBRA Notification Letter Application: Human Resources Source: COBRA Notification Letter (XML) Short Name: PERRPCNL_XML DB package: PER_PERUSCNL_XMLP_PKG
 Human Resources BI Publisher XML
PER Conclude Placement
Imported from BI Publisher Description: Conclude Placement Report Application: Human Resources Source: Conclude Placement Report (XML) Short Name: PERRPCTM_XML DB package: PER_PERRPCTM_XMLP_PKG
 Human Resources BI Publisher XML
PER Duplicate Person
Imported from BI Publisher Application: Human Resources Source: Duplicate Person Report (XML) Short Name: PERWSDUP_XML DB package: PER_PERWSDUP_XMLP_PKG
 Human Resources BI Publisher XML