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
Upload

2 reports

DescriptionDownload
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