Blitz Report™ Library

The Blitz Report™ library is a collection of operational and diagnostic reports for Oracle E-Business Suite

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

	Description
PSP Post Upgrade Bad Data	Application: Labor Distribution Source: PSP: Post Upgrade Bad Data Report (XML) Short Name: PSPUPREP_XML DB package: PSP_PSPUPREP_XMLP_PKG	BI Publisher
PSP Reconciliation between distribution lines and summary	Imported from BI Publisher Description: Reconciliation between distribution lines and summary lines Application: Labor Distribution Source: PSP: Reconciliation between distribution lines and summary (XML) Short Name: PSPRCDLS_XML DB package: PSP_PSPRCDLS_XMLP_PKG	BI Publisher
PSP Reconciliation between payroll lines and sublines	Application: Labor Distribution Source: PSP: Reconciliation between payroll lines and sublines (XML) Short Name: PSPRCLSL_XML DB package: PSP_PSPRCLSL_XMLP_PKG	BI Publisher
PSP Reconciliation between pre-generated distribution lines and summary lines	Imported from BI Publisher Description: Reconciliation between pre-generated distribution lines and summary lines Application: Labor Distribution Source: PSP: Reconciliation between pre-generated distribution lines and summary lines (XML) Short Name: PSPRCPGD_XML DB package: PSP_PSPRCPGD_XMLP_PKG	BI Publisher
PSP Reconciliation between sublines and distribution lines	Imported from BI Publisher Description: Reconciliation between sublines and distribution lines Application: Labor Distribution Source: PSP: Reconciliation between sublines and distribution lines (XML) Short Name: PSPRCSLD_XML DB package: PSP_PSPRCSLD_XMLP_PKG	BI Publisher
PURE Lotwise Aging		Custom Reports PURE
Payroll Balance Listing	Lists payroll balances for employees between two dates. Uses standard HR security.
Profile Setup Track and Change	BR100 Export / change tracking Unlike Oracle's SQL script from note 201945.1, this report also shows the user visible profile option value in addition to the internal system profile option value.
QP Accrual Details	Application: Advanced Pricing Source: Accrual Details (XML) Short Name: QPXPACRL_XML DB package: QP_QPXPACRL_XMLP_PKG	Order Management BI Publisher
QP Modifier Details (1)	Imported from BI Publisher Description: Modifier Details Report for QP Application: Advanced Pricing Source: Modifier Details (XML) Short Name: QPXPRMLS_XML DB package: QP_QPXPRMLS_XMLP_PKG	Order Management BI Publisher
QP Pricing Formulas	Application: Advanced Pricing Source: Pricing Formulas (XML) Short Name: QPXPRFOR_XML DB package: QP_QPXPRFOR_XMLP_PKG	Order Management BI Publisher
QP Qualifier Grouping	Application: Advanced Pricing Source: Qualifier Grouping (XML) Short Name: QPXPRQFS_XML DB package: QP_QPXPRQFS_XMLP_PKG	Order Management BI Publisher
QP_LIST_HEADERS_B
QP_LIST_LINES
QP_PRICING_ATTRIBUTES
RD INV Inventory Aging	Application: Inventory Source: Inventory Aging Report(XML) Short Name: INVAGERP_XML DB package: INV_AGERPXML_PKG	BI Publisher
RKD Employee Element History
RKD Employee Salary Element Wise
RLM Compare Schedule To Demand	Imported from BI Publisher Description: Compare Schedule To Demand Report Application: Release Management Source: Compare Schedule To Demand Report (XML) Short Name: RLMDMCOM_XML DB package: RLM_RLMDMCOM_XMLP_PKG	BI Publisher
RLM Demand Status Inquiry	Application: Release Management Source: Demand Status Inquiry Report (XML) Short Name: RLMDMQRY_XML DB package: RLM_RLMDMSIQ_XMLP_PKG	BI Publisher
RLM Net Change	Application: Release Management Source: Net Change Report (XML) Short Name: RLMNTCHG_XML DB package: RLM_RLMNETCH_XMLP_PKG	BI Publisher
RLM Release Management Purge Schedule Exception	Application: Release Management Source: Release Management Purge Schedule Exception Report (XML) Short Name: RLMPSRP_XML DB package: RLM_RLMDPPSR_XMLP_PKG	BI Publisher
RNK ABC
RW - GL Ledgers and Organizations	RW - GL Ledgers and Organizations
RWB Database Functions used by Calculated Columns	List of all database functions used by Polaris Reporting Workbench reports, which were executed within the past x history day, to analyze during migration to Blitz Report	RWB
RWB Database Objects used by Report Views	Lists of all database objects referenced by views of Polaris Reporting Workbench reports, which were executed within the past x history day, to analyze during migration to Blitz Report	RWB
RWB Execution History	Execution history of Polaris Reporting Workbench reports. This can be used when migrating from Polaris Reporting Workbench to Blitz Report, to analyze which Polaris reports were previously used by the business.	RWB
RWB Execution Summary	Execution history of Polaris Reporting Workbench reports, summarized by combination of accessed views, similar to the Blitz Report import menu option LOV. This can be used when migrating from Polaris Reporting Workbench to Blitz Report, to analyze which Polaris view were previously used by the business	RWB
RWB Folders and Folder Asscociations	Polaris Reporting Workbench folders, their included reports and accessed data objects	RWB
RWB Report Columns	Polaris Reporting Workbench report columns	RWB
RWB Report Conditions		RWB
RWB Report Output	Polaris Reporting Workbench concurrent program output history	RWB
RWB Reports	Polaris Reporting Workbench reports, folders, data objects, database views and the data object folders that these views reside in	RWB
RWB Security	Polaris Reporting Workbench folder report security and sharing setup. The report lists all responsibilities or users and the folders or reports they have access to	RWB
RWB Views (Data Objects)	List of Polaris Reporting Workbench views (data objects)	RWB
Rakesh Supply Chain - Draft Works	Rakesh : Supply chain Query BOM Indented Cost of Materials	Draft
Rares AP INVOICES
Rares AP supplier list	All the users can use this template
Rares report
Rares report number 2
Raymond's Report
SAM Training
SDS - CST Intransit Value	Imported from BI Publisher Description: Intransit Value Report Application: Bills of Material Source: Intransit Value Report (XML) Short Name: CSTRITVR_XML DB package: BOM_CSTRITVR_XMLP_PKG	BI Publisher
SDS AR Aging with document currency amounts	SDS AR Aging with document currency amounts created from AR Aging
SQL data access security
SRF Training
SSP Element Results	Imported from BI Publisher Description: SSP Pay Element Result Report Application: SSP Source: SSP Element Results (XML) Short Name: SSPRPELR_XML DB package: SSP_SSPRPELR_XMLP_PKG	BI Publisher
SSP Maximum SSP Weeks	Imported from BI Publisher Description: Maximum SSP Weeks Report Application: SSP Source: Maximum SSP Weeks (XML) Short Name: SSPRPWKS_XML DB package: SSP_SSPRPWKS_XMLP_PKG	BI Publisher
SSP Open Sickness Absences	Imported from BI Publisher Description: Open Sickness Absences Report Application: SSP Source: Open Sickness Absences Report (XML) Short Name: SSPRPOAR_XML DB package: SSP_SSPRPOAR_XMLP_PKG	BI Publisher
SSP SMP Element Results	Imported from BI Publisher Description: SMP Pay Element Result Report Application: SSP Source: SMP Element Results (XML) Short Name: SMPRPELR_XML DB package: SSP_SMPRPELR_XMLP_PKG	BI Publisher

Blitz Report™ Library

The Blitz Report™ library is a collection of operational and diagnostic reports for Oracle E-Business Suite

Also found in SQL, tables and columns