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

2,741 reports

DescriptionDownload
HXT Actual and Rounded Time Punch
Application: Time and Labor Source: Actual and Rounded Time Punch (XML) Short Name: HXT958A_XML DB package: HXT_HXT958A_XMLP_PKG
 Human Resources BI Publisher XLS XML
HXT Earning Group Table Listing
Application: Time and Labor Source: Earning Group Table Listing (XML) Short Name: HXT957G_XML DB package: HXT_HXT957G_XMLP_PKG
 Human Resources BI Publisher XLS XML
HXT Earning Policy Table Listing
Application: Time and Labor Source: Earning Policy Table Listing (XML) Short Name: HXT956A_XML DB package: HXT_HXT956A_XMLP_PKG
 Human Resources BI Publisher XLS XML
HXT Holiday Calendar Table
Application: Time and Labor Source: Holiday Calendar Table Report (XML) Short Name: HXT957A_XML DB package: HXT_HXT957A_XMLP_PKG
 Human Resources BI Publisher XLS XML
HXT Organization Variance Calc
Application: Time and Labor Source: Organization Variance Calc (XML) Short Name: HXT951A_XML DB package: HXT_HXT951A_XMLP_PKG
 Human Resources BI Publisher XLS XML
HXT Shift Table Listing
Application: Time and Labor Source: Shift Table Listing (XML) Short Name: HXT957D_XML DB package: HXT_HXT957D_XMLP_PKG
 Human Resources BI Publisher XLS XML
HXT Total Table Entries
Application: Time and Labor Source: Total Table Entries (XML) Short Name: HXT957H_XML DB package: HXT_HXT957H_XMLP_PKG
 Human Resources BI Publisher XLS XML
HXT Variance Table Listing
Application: Time and Labor Source: Variance Table Listing (XML) Short Name: HXT957F_XML DB package: HXT_HXT957F_XMLP_PKG
 Human Resources BI Publisher XLS XML
HACTL AR Transaction Listings XML
HR Per All People F Diagnostic Listing
Diagnostic Listing of per_all_people_f table
 XML
HR_OPERATING_UNITS XML
HXC Missing Timecard
Imported from BI Publisher Description: OTL Missing Timecard Report Application: Time and Labor Engine Source: Missing Timecard Report (XML) Short Name: HXCMISTC_XML DB package: HXC_HXCMISTC_XMLP_PKG
 BI Publisher XML
HXC Retrieval Error Handling
Application: Time and Labor Engine Source: Retrieval Error Handling Report (XML) Short Name: HXCRTERR_XML DB package: HXC_HXCRTERR_XMLP_PKG
 BI Publisher XML
HXC Timecard Audit Trail
Application: Time and Labor Engine Source: OTL: Timecard Audit Trail Report Short Name: HXCRPTAUD DB package: HXC_RPT_TC_AUDIT_TRAIL
 BI Publisher XML
HXT Earning Variance Calculation
Application: Time and Labor Source: Earning Variance Calculation (XML) Short Name: HXT953A_XML DB package: HXT_HXT953A_XMLP_PKG
 Human Resources BI Publisher XML
HXT Hour Deduction Plcy Tbl List
Application: Time and Labor Source: Hour Deduction Plcy Tbl List (XML) Short Name: HXT956B_XML DB package: HXT_HXT956B_XMLP_PKG
 Human Resources BI Publisher XML
HXT Location Variance Calculation
Application: Time and Labor Source: Location Variance Calculation (XML) Short Name: HXT952A_XML DB package: HXT_HXT952A_XMLP_PKG
 Human Resources BI Publisher XML
HXT Manual and Autogen
Application: Time and Labor Source: Manual and Autogen Report (XML) Short Name: HXT970A_XML DB package: HXT_HXT970A_XMLP_PKG
 Human Resources BI Publisher XML
HXT OTLR Missing Timecard
Application: Time and Labor Source: OTLR Missing Timecard Report (XML) Short Name: HXT964A_XML DB package: HXT_HXT964A_XMLP_PKG
 Human Resources BI Publisher XML
HXT Periodic Late Clock-In
Application: Time and Labor Source: Periodic Late Clock-In Report (XML) Short Name: HXT959A_XML DB package: HXT_HXT959A_XMLP_PKG
 Human Resources BI Publisher XML
HXT Person/Assignment Table List
Application: Time and Labor Source: Person/Assignment Table List (XML) Short Name: HXT957I_XML DB package: HXT_HXT957I_XMLP_PKG
 Human Resources BI Publisher XML
HXT Prem. Interaction Plcy Tbl Lst
Application: Time and Labor Source: Prem. Interaction Plcy Tbl Lst (XML) Short Name: HXT956E_XML DB package: HXT_HXT956E_XMLP_PKG
 Human Resources BI Publisher XML
HXT Premium Elg. Policy Tbl List
Application: Time and Labor Source: Premium Elg. Policy Tbl List (XML) Short Name: HXT956D_XML DB package: HXT_HXT956D_XMLP_PKG
 Human Resources BI Publisher XML
HXT Project Accounting Table List
Application: Time and Labor Source: Project Accounting Table List (XML) Short Name: HXT957E_XML DB package: HXT_HXT957E_XMLP_PKG
 Human Resources BI Publisher XML
HXT Rotation Plan Table Listing
Application: Time and Labor Source: Rotation Plan Table Listing (XML) Short Name: HXT957C_XML DB package: HXT_HXT957C_XMLP_PKG
 Human Resources BI Publisher XML
HXT Shift Diff. Pol. Table Listing
Application: Time and Labor Source: Shift Diff. Pol. Table Listing (XML) Short Name: HXT956C_XML DB package: HXT_HXT956C_XMLP_PKG
 Human Resources BI Publisher XML
HXT Time Entry Detail
Application: Time and Labor Source: OTL: Time Entry Detail Report Short Name: HXTDETRPT DB package: HXT_DET_HRS_WORKED_RPT
 Human Resources BI Publisher XML
HXT Time Management to Project Accounting Retrieval
Application: Time and Labor Source: OTL: Time Management to Project Accounting Retrieval Report Short Name: HXTPATRAN DB package: HXT_TRAN_PA_RPT
 Human Resources BI Publisher XML
HXT Total Hours To BEE
Application: Time and Labor Source: Total Hours To BEE (XML) Short Name: HXT007A_XML DB package: HXT_HXT007A_XMLP_PKG
 Human Resources BI Publisher XML
HXT Work Plan Table Listing
Application: Time and Labor Source: Work Plan Table Listing (XML) Short Name: HXT957B_XML DB package: HXT_HXT957B_XMLP_PKG
 Human Resources BI Publisher XML
HZ_CUST_ACCOUNTS XML
HZ_CUST_ACCT_SITES_ALL XML
HZ_CUST_SITE_USES_ALL XML
HZ_PARTIES XML
HZ_PARTY_SITES XML
Hyperlink sql XML
AD Applied Patches
AD applied patches, patch runs, included bugs, filenames and actions
 System Enginatics XLS XML
AD Applied Patches R12.2
Check if a specific patch is applied in 12.2
 System Enginatics XLS XML
AD Patch Task Timing
Run time of each job of an adpatch, adop or upgrade session from AD_TASK_TIMING, to identify the jobs that took longest. Session Percentage is the job's share of the total elapsed time of all jobs in the session. Jobs run in parallel by several workers, so the session's wall clock time is shorter than the sum of the job times.
 System Enginatics XLS XML
AP Cash Requirement
Detail cash requirement report showing all unpaid or partially paid amounts, where the invoice is neither on hold nor cancelled, including invoice currency amount, exchange rate, and currency code When India Localization is installed, the following GST columns are also included: CGST Amount, SGST Amount, IGST Amount, Custom Amount, Unclassified Tax Amount, Taxable Value, HSN SAC Code, CGST Rate, SGST Rate, IGST Rate, GST Supplier Registration No, GST Registration No, GST PAN No, GST TAN No.
 Payables Enginatics, R12 only XLS XML
AP Invoice and Payment Audit by Voucher Number
Lists every voucher number of the Payables invoice and payment document sequences with its status: Entered, Deleted (the number was issued, but the invoice or payment no longer exists) or Not Entered (the number is missing from the sequence audit trail). Replaces Oracle's Invoice Audit by Voucher Number (APXINVAD) and Payment Audit by Voucher Number (APXPAYAD). Unlike Oracle's payment report, a voided payment is listed as Entered with its void date, and a payment number without a payment as Deleted instead of Not Entered. Missing numbers are the gaps between the numbers recorded in the…
full description		 Payables Enginatics XLS XML
AP Invoice on Hold
Based on Oracle standard Invoice on Hold report Source: Invoice on Hold Report (XML) Short Name: APXINROH_XML When India Localization is installed, the following GST columns are also included: GST Registration No, Supplier GSTIN (Invoice Date), GST PAN No, GST TAN No, CGST Amount, SGST Amount, IGST Amount, CESS Amount, CGST Rate, SGST Rate, IGST Rate, CESS Rate, Custom Amount, Unclassified Tax Amount, Taxable Value, HSN SAC Code, Days Since Invoice, Amount Settled, Amount Unpaid, ITC Reversal Due, ITC Reversal Exposure.
 Payables Enginatics XLS XML
AP Matched and Modified Receipts
Imported from BI Publisher Description: Matched and Modified Receipts Report Application: Payables Source: Matched and Modified Receipts Report (XML) - Not Supported: Reserved For Future Use Short Name: APXMTMRR_XML DB package: AP_APXMTMRR_XMLP_PKG When India Localization is installed, the following GST columns are also included: GST Registration No, GST PAN No, GST TAN No, CGST Amount, SGST Amount, IGST Amount, CGST Rate, SGST Rate, IGST Rate, Custom Amount, Unclassified Tax Amount, Taxable Value, HSN SAC Code.
 Payables Enginatics, R12 only XLS XML
AR Customer Credit Snapshot
Application: Receivables Source: Customer Credit Snapshot (XML) Short Name: ARXCCS_XML DB package: AR_ARXCCS_XMLP_PKG
 Receivables Enginatics, R12 only XLS XML
Blitz Report Deletion History
Shows deleted Blitz Reports and can be used to recover accidentally deleted reports. The history of deleted reports can be purged completely by running concurrent 'Blitz Report Monitor' with parameter 'Purge delete reports SQL history' set to Yes
 Enginatics XLS XML
Blitz Report License User History
Shows the history of active Blitz Report users at every at every month end, looking back the past 60 days.
 Enginatics XLS XML
Blitz Report Parameter Anchor Validation
Checks if all parameter anchors exist in the xxen_report_parameter_anchors table.
 Enginatics XLS XML
Blitz Report Record History SQL Text Creation
Creates a string for the record history columns, based on a table alias.
 Enginatics XLS XML
Blitz Report User History
Lists all active EBS users with their active responsibilities and blitz report execution counts. The report can be used to analyze blitz report usage within the EBS user community e.g. to find the most active users or to spot the ones not using blitz report to it's full potential yet.
 Enginatics XLS XML
Blitz Upload History
History of uploaded data, which is kept for profile option Blitz Upload Data Retention Days number of days.
 Enginatics XLS XML