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
AR Duplicate DUNS	Application: Receivables Source: Duplicate DUNS Report (XML) Short Name: ARHDUNDP_XML DB package: AR_ARHDUNDP_XMLP_PKG	Receivables BI Publisher
AR Incomplete Invoices	Application: Receivables Source: Incomplete Invoices Report (XML) Short Name: RAXIIR_XML DB package: AR_RAXIIR_XMLP_PKG	Receivables BI Publisher
AR Ordering and Grouping Rules Listing	Application: Receivables Source: Ordering and Grouping Rules Listing (XML) Short Name: ARXGRL_XML DB package: AR_ARXGRL_XMLP_PKG	Receivables BI Publisher
AR Payment Terms Listing	Application: Receivables Source: Payment Terms Listing (XML) Short Name: RAXPTL_XML DB package: AR_RAXPTL_XMLP_PKG	Receivables BI Publisher
AR Receipt Journal	Imported from BI Publisher Description: Receipt Journal Report Application: Receivables Source: Receipt Journal Report (XML) Short Name: ARXRJR_XML DB package: AR_ARXRJR_XMLP_PKG	Receivables BI Publisher
AR Receipts Awaiting Bank Clearance	Imported from BI Publisher Description: Receipts Awaiting Bank Clearance Report Application: Receivables Source: Receipts Awaiting Bank Clearance Report (XML) Short Name: ARXAPRCL_XML DB package: AR_ARXAPRCL_XMLP_PKG	Receivables BI Publisher
AR Receipts Awaiting Remittance	Imported from BI Publisher Description: Receipts Awaiting Remittance Report Application: Receivables Source: Receipts Awaiting Remittance Report (XML) Short Name: ARXAPRRM_XML DB package: AR_ARXAPRRM_XMLP_PKG	Receivables BI Publisher
AR Receipts Without Sites	Application: Receivables Source: Receipts Without Sites Report (XML) Short Name: ARXRWS_XML DB package: AR_ARXRWS_XMLP_PKG	Receivables BI Publisher
AR Remittance Batch Management	Imported from BI Publisher Description: Remittance Batch Management Report Application: Receivables Source: Remittance Batch Management Report (XML) Short Name: ARXAPRMB_XML DB package: AR_ARXAPRMB_XMLP_PKG	Receivables BI Publisher
AR Standard Memo Lines Listing	Application: Receivables Source: Standard Memo Lines Listing (XML) Short Name: RAXILL_XML DB package: AR_RAXILL_XMLP_PKG	Receivables BI Publisher
AR Transaction Batch Source Listing	Application: Receivables Source: Transaction Batch Source Listing (XML) Short Name: RAXSOL_XML DB package: AR_RAXSOL_XMLP_PKG	Receivables BI Publisher
AR Transaction Detail	Application: Receivables Source: Transaction Detail Report (XML) Short Name: ARXTDR_XML DB package: AR_ARXTDR_XMLP_PKG	Receivables BI Publisher
BEN Default Enrollment Summary	Application: Advanced Benefits Source: Default Enrollment Summary Report (XML) Short Name: BENDFSUM_XML DB package: BEN_BENDFSUM_XMLP_PKG	Human Resources BI Publisher
BEN Dependent Eligibility Summary	Application: Advanced Benefits Source: Dependent Eligibility Summary Report (XML) Short Name: BENDESUM_XML DB package: BEN_BENDESUM_XMLP_PKG	Human Resources BI Publisher
BEN Extract Audit	Application: Advanced Benefits Source: Extract Audit Report (XML) Short Name: BENXAUDT_XML DB package: BEN_BENXAUDT_XMLP_PKG	Human Resources BI Publisher
BEN Extract Summary	Application: Advanced Benefits Source: Extract Summary Report (XML) Short Name: BENXSMRY_XML DB package: BEN_BENXSMRY_XMLP_PKG	Human Resources BI Publisher
BEN HIPAA Letter	Imported from BI Publisher Description: HIPAA Letter` Application: Advanced Benefits Source: HIPAA Letter (XML) Short Name: BENHIPAA_XML DB package: BEN_BENHIPAA_XMLP_PKG	Human Resources BI Publisher
BOM Alternates	Imported from BI Publisher Description: Alternates Report Application: Bills of Material Source: Alternates Report (XML) Short Name: BOMRDBAD_XML DB package: BOM_BOMRDBAD_XMLP_PKG	Manufacturing BI Publisher
BOM Bill of Material Listing	Imported from BI Publisher Description: Bill of Material Listing Application: Bills of Material Source: Bill of Material Listing (XML) Short Name: BOMRASSY_XML DB package: BOM_BOMRASSY_XMLP_PKG	Manufacturing BI Publisher
BOM Bills of Material Parameters	Imported from BI Publisher Description: Bills of Material Parameters Report Application: Bills of Material Source: Bills of Material Parameters Report (XML) Short Name: BOMRDBPR_XML DB package: BOM_BOMRDBPR_XMLP_PKG	Manufacturing BI Publisher
BOM Delete Items	Imported from BI Publisher Description: Delete Items Report Application: Bills of Material Source: Delete Items Report (XML) Short Name: BOMRDDEL_XML DB package: BOM_BOMRDDEL_XMLP_PKG	Manufacturing BI Publisher
BOM Resource	Imported from BI Publisher Description: Resource Report Application: Bills of Material Source: Resource Report (XML) Short Name: BOMRDORS_XML DB package: BOM_BOMRDORS_XMLP_PKG	Manufacturing BI Publisher
BOM Workday Exception Sets	Application: Bills of Material Source: Workday Exception Sets Report (XML) Short Name: BOMRDEXS_XML DB package: BOM_BOMRDEXS_XMLP_PKG	Manufacturing BI Publisher
CSE Bill of Lading	Application: Asset Tracking Source: Bill of Lading Report (XML) Short Name: CSEBOFLD_XML DB package: CSE_CSEBOFLD_XMLP_PKG	BI Publisher
CSI Asset Tracking listing of pending transactions with specific transaction ID parameter	When a transaction is successfully interfaced to Oracle Assets, the transaction's status will be updated from 'PENDING' to 'COMPLETE'. The majority reasons are: 1) OAT related set ups are not completed/correct, e.g asset category, asset location, asset name. 2) Previous transaction for the same asset is still in pending, e.g. asset is not created by create asset program so move transaction will not be processed. 3) Asset is updated from Oracle Asset which caused asset status, location out of sync with OAT record. Erro message - 'Prior transactions are in pending status for this item… full description	Draft
CSI Asset Tracking pending error transactions for all serial number/instance in your system	When OAT is installed, INV transactions are interfaced to create/update related instances in Installed Base, then the transactions further interfaced to FA to create/update the related fixed assets. Whether a INV transaction need be interfaced to FA is determined by the installed base transaction_status. If it is at 'PENDING' then it need be processed to FA. There are two concurrent programs to process 'PENDING' install base transactions to Oracle Assets: 'Create Asset: Interface Inventory Transaction to Oracle Assets' and 'Interface Move Transaction to Oracle Assets'	Draft
CST All Inventories Value	Imported from BI Publisher Description: All Inventories Value Report Application: Bills of Material Source: All Inventories Value Report (XML) Short Name: CSTRAIVR_XML DB package: BOM_CSTRAIVR_XMLP_PKG	Cost Management BI Publisher
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	Cost Management BI Publisher
CST Inventory Subledger	Imported from BI Publisher Description: Inventory Subledger Report Application: Bills of Material Source: Inventory Subledger Report (XML) Short Name: CSTRISLR_XML DB package: BOM_CSTRISLR_XMLP_PKG	Cost Management BI Publisher
CST Overhead	Imported from BI Publisher Description: Overhead Report Application: Bills of Material Source: Overhead Report (XML) Short Name: CSTROVHD_XML DB package: BOM_CSTROVHD_XMLP_PKG	Cost Management BI Publisher
CST Shipping Transaction Summary	Imported from BI Publisher Description: Shipping Transaction Summary Report Application: Bills of Material Source: Shipping Transaction Summary Report (XML) Short Name: CSTRSTSR_XML DB package: BOM_CSTRSTSR_XMLP_PKG	Cost Management BI Publisher
CUSTOM IDC Authorized Bank Account Signers	Application: Custom Development Source: IDC Authorized Bank Account Signers Short Name: IDC_BA_SIGN DB package:	BI Publisher
Concurrent Requests Bucketed	Displays a the number of concurrent requests running within specified time buckets.
EIS Usage Summary	EIS eXpress Reporting usage by calendar month of the run start, to estimate the number of Blitz Report licenses required for the EIS user base. User Count is the number of distinct users who ran an EIS report in the month. User Count 60 Days is the number of distinct users in the 60 days before the month started, which corresponds to the rolling 60-day window that Blitz Report licensing is based on. Runs count executions from eXpress and XL Connect. A scheduled run counts for the user who created the schedule. Email distribution jobs are deliveries of a run and are not counted. EIS purges… full description	EIS
ENG Engineering Change Order Approval Lists	Imported from BI Publisher Description: Engineering Change Order Approval Lists Report Application: Engineering Source: Engineering Change Order Approval Lists Report (XML) Short Name: ENGRCOAL_XML DB package: ENG_ENGRCOAL_XMLP_PKG	BI Publisher
ENG Engineering Change Order Priorities	Imported from BI Publisher Description: Engineering Change Order Priorities Report Application: Engineering Source: Engineering Change Order Priorities Report (XML) Short Name: ENGRDECP_XML DB package: ENG_ENGRDECP_XMLP_PKG	BI Publisher
ENG Engineering Change Order Reasons	Imported from BI Publisher Description: Engineering Change Order Reasons Report Application: Engineering Source: Engineering Change Order Reasons Report (XML) Short Name: ENGRDECR_XML DB package: ENG_ENGRDECR_XMLP_PKG	BI Publisher
ENG Engineering Change Order Types	Imported from BI Publisher Description: Engineering Change Order Types Report Application: Engineering Source: Engineering Change Order Types Report (XML) Short Name: ENGRECOT_XML DB package: ENG_ENGRECOT_XMLP_PKG	BI Publisher
FA Asset Category Listing	Fixed Asset categories overview report with asset category, general ledger accounts, depreciation method, expected life and depreciated life.	Assets Draft
FA Asset%	Detail report with retirement ID, asset ID, date retired, cost retired, status, retirement prorate convention, number of units, cost, gain or loss amount, proceeds and retirement type.	Assets Draft
GMF Accounting Unit Mapping	Imported from BI Publisher Description: Accounting Unit Mapping Report of OPM GL Application: Process Manufacturing Financials Source: Accounting Unit Mapping Report (XML) Short Name: GLR17USR_XML DB package: GMF_GLR17USR_XMLP_PKG	Manufacturing BI Publisher
GMF GL Expense Allocation Definition	Imported from BI Publisher Description: GL Expense Allocation Definition Report of OPM CM Application: Process Manufacturing Financials Source: GL Expense Allocation Definition Report (XML) Short Name: CMR10USR_XML DB package: GMF_CMR10USR_XMLP_PKG	Manufacturing BI Publisher
GMI Lot Master	Imported from BI Publisher Description: Lot Master Report of OPM IC Application: Process Manufacturing Inventory Source: Lot Master Report (XML) Short Name: RILMS_XML DB package: GMI_RILMS_XMLP_PKG	Manufacturing BI Publisher
GR Disclosure Code Details	Application: Process Manufacturing Regulatory Management Source: Disclosure Code Details Report (XML) Short Name: GRRPT908_XML DB package: GR_GRRPT908_XMLP_PKG	BI Publisher
GR Field Name Class Codes	Application: Process Manufacturing Regulatory Management Source: Field Name Class Codes Report (XML) Short Name: GRRPT005_XML DB package: GR_GRRPT005_XMLP_PKG	BI Publisher
GR Field Name Codes	Application: Process Manufacturing Regulatory Management Source: Field Name Codes Report (XML) Short Name: GRRPT009_XML DB package: GR_GRRPT009_XMLP_PKG	BI Publisher
GR Hazard Classification Code Details	Application: Process Manufacturing Regulatory Management Source: Hazard Classification Code Details Report (XML) Short Name: GRRPT931_XML DB package: GR_GRRPT931_XMLP_PKG	BI Publisher
GR Hazard Classification Group Codes	Application: Process Manufacturing Regulatory Management Source: Hazard Classification Group Codes Report (XML) Short Name: GRRPT032_XML DB package: GR_GRRPT032_XMLP_PKG	BI Publisher
GR Master Item Associations	Application: Process Manufacturing Regulatory Management Source: Master Item Associations Report (XML) Short Name: GRRPT028_XML DB package: GR_GRRPT028_XMLP_PKG	BI Publisher
GR Product Class Code Details	Application: Process Manufacturing Regulatory Management Source: Product Class Code Details Report (XML) Short Name: GRRPT904_XML DB package: GR_GRRPT904_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