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

7 reports

DescriptionDownload
GL Journal Upload
GL Journal Upload Templates are provided for the following Journal Types - Functional Actuals - Foreign Actuals - Budget Journals - Encumbrance Journals Submit for Approval --------------------------- Imported Journals requiring approval can be submitted for approval after import if they are eligble. Submit Journal Post --------------------------- Imported Journals can be submitted for immediate posting after import if they are eligible. In order to submit journals for posting, the current responsibility must have access to post journals.
 General Ledger Enginatics, Upload XLS XML
GL Account Upload
This upload allows creation of new GL code combinations and update of existing ones. For creation of new code combinations, the upload requires the setup to allow dynamic inserts for code combinations.
 General Ledger Enginatics, Upload XML
GL Account Upload 11i
This upload allows creation of new GL code combinations and update of existing ones. For creation of new code combinations, the upload requires the setup to allow dynamic inserts for code combinations.
 General Ledger Enginatics, Upload XML
GL Budget Amounts Upload
GL Budget Amounts Upload =================== This can be used to upload GL Budget Amounts
 General Ledger Enginatics, Upload XML
GL Daily Rates Upload
GL Daily Rates Upload ================== Use this upload to upload new or update existing GL Daily Exchange Rate Conversions. If exchange rates do not already exist for the entered data, they will be created. If exchange rates do already exist for the entered data, they will be updated.
 General Ledger Enginatics, Upload XML
GL Setup Upload
Create and update the General Ledger setup entities that the GL Setup menu maintains, replicating the Calendars (GLXSTCAL), Period Types (GLXSTPTY), Journal Sources (GLXSTSRC), Journal Categories (GLXSTCAT), Encumbrance Types (GLXSTENC), Statistical Units of Measure (GLXSTUOM), Ledger Sets (GLXSTLST), Data Access Sets (GLXSTACC), Journal Reversal Criteria (GLXSTARV) and AutoPost Criteria (GLXSTAPO) forms, plus ledger options. Each row is one of fifteen entity types, chosen in the Row Type column. Only the columns belonging to that entity are read; all other columns are ignored. A template is…
full description		 General Ledger Enginatics, R12 only, Upload XML
GL Summary Account Upload
This upload can be used to import Summary Account Templates.
 General Ledger Enginatics, R12 only, Upload XML