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
Enginatics

12 reports

DescriptionDownload
CE Bank Account Balances
Application: Cash Management Description: Bank Accounts - Balances Report Provides equivalent functionality to the following standard Oracle Forms/Reports - Bank Account Balances OAF Page - Bank Account Balance Range Day Report - Bank Account Balance Single Date Report - Bank Account Balance Actual vs Projected Report Single (As Of) Date Report - Specify the required Date in the As Of Date parameter - Specify Yes in the 'Bring Forward Prior Balances' if you want to roll the most recent prior balance entries forward if a balance does not exist on the specified As Of Date - Specify No in the…
full description		 Cash Management Enginatics, R12 only XLS XML
CE Bank Branches
This Report is the repository of all bank branches covering both internal and external bank accounts and will list the bank branches along with an indication of usage: -Internal -Supplier -Customer
 Cash Management Enginatics, R12 only XLS XML
CE Bank Statement Import Execution
Application: Cash Management Source: Bank Statement Import Execution Report Short Name: CEIMPERR DB package: CE_CEXINERR_XMLP_PKG
 Cash Management BI Publisher, Enginatics, R12 only XLS XML
CE Bank Statement and Reconciliation
Application: Cash Management Description: Bank Statements - Bank Statement Details and Reconciliation Provides equivalent functionality to the following standard Oracle Forms/Reports - Bank Statements and Reconciliation Form Applicable Templates: Pivot: Bank Statement by Transaction Type Bank Statement Detail Bank Statement Detail with Reconciled Trxs - Bank Statement Summary Report Applicable Templates: Pivot: Bank Statement by Transaction Type Bank Statement Summary - Bank Statement Detail Report Applicable Templates: Pivot: Bank Statement by Transaction Type Bank…
full description		 Cash Management Enginatics, R12 only XLS XML
CE Bank Transaction Codes Listing
Imported from BI Publisher Description: Bank Transaction Codes Application: Cash Management Source: Bank Transaction Codes Listing Short Name: CEXTRXCD DB package: CE_CEXTRXCD_XMLP_PKG
 Cash Management Enginatics, R12 only XLS XML
CE General Ledger Cash Account Usage
Application: Cash Management Description: Cash Account Usage This report details the General Ledger Cash Accounts assigned to Bank Accounts, and their usage. The following templates are available: Pivot: Bank Accounts, Assigned Cash Accounts - Pivot by Bank Account, Cash Account showing cash account usage within each bank account. Pivot: Cash Account, Assigned Bank Accounts - Pivot by Cash Account, Bank Account, showing cash account usage within each bank account.
 Cash Management Enginatics, R12 only XLS XML
CE General Ledger Reconciliation
Application: Cash Management Description: Bank Statements - General Ledger Reconciliation Provides equivalent functionality to the following standard Oracle Forms/Reports - General Ledger Reconciliation Report Applicable Templates: Pivot: Reconciliation Summary Source: General Ledger Reconciliation Report Short Name: CEXRECRE DB package: CE_CEXRECRE_XMLP_PKG
 Cash Management Enginatics, R12 only XLS XML
CE Bank Statement Upload
CE Bank Statement Upload ======================== Loads bank statements (header and lines) into Oracle Cash Management through the bank statement open interface and runs Oracle's Bank Statement Import automatically after upload. Optionally, AutoReconciliation runs in the same step to match the imported statement lines against AR receipts, AP payments and GL journal lines according to the bank account's transaction codes and matching rules, in the same way as the standard 'Bank Statement Import & AutoReconciliation' concurrent program. Each row represents one statement line. Statement header…
full description		 Cash Management Enginatics, R12 only, Upload XML
CE Bank and Branch Upload
CE Bank and Branch Upload ========================== Creates or updates banks and bank branches in Oracle Cash Management (CE) using the ce_bank_pub API (TCA-based). Each row represents one bank branch. If the bank does not exist it is created automatically. The branch is then created or updated within that bank. Upload Mode =========== Create ------ Opens an empty spreadsheet to enter new banks and branches. Create, Update -------------- Returns existing bank branches. Edit fields and re-upload to update. Required Fields =============== - Country: Country of the bank (e.g. United…
full description		 Cash Management Enginatics, R12 only, Upload XML
CE Cash in Transit
Application: Cash Management Description: Cash in Transit Provides equivalent functionality to the following standard Oracle Forms/Reports - Cash in Transit Applicable Templates: - Pivot: Cash in Transit - Pivot: Bank Account Currency, Bank Account, In Transit Type, Operating Unit, Third Party (Supplier/Customer) with drill down to details - Cash In Transit Detail - Detail Extract Source: Cash in Transit (CEXCSHTR) DB package: CE_CEXCSHTR_XMLP_PKG (required to initialize security)
 Cash Management Enginatics, R12 only XML
CE Cleared Transactions
Application: Cash Management Description: Transactions - Cleared Payment/Receipt Transactions Provides equivalent functionality to the following standard Oracle Forms/Reports - Cleared Transactions Report Applicable Templates: Pivot: Cleared Transactions Summary Pivot: Cleared Batches Summary Source: Cleared Transactions Report (CEXCLEAR) DB package: CE_CEXCLEAR_XMLP_PKG (required to initialize security)
 Cash Management Enginatics, R12 only XML
CE Transactions Available for Reconciliation
Application: Cash Management Description: Transactions - Transactions Available for Reconciliation Provides equivalent functionality to the following standard Oracle Forms/Reports - Transactions Available for Reconciliation Report Applicable Templates: Pivot: Transactions Available by Bank Account, Source and Type Source: Transactions Available for Reconciliation Report (CEXAVTRX) DB package: CE_CEXSTMRR_XMLP_PKG (required to initialize security)
 Cash Management Enginatics, R12 only XML