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
EAM Senfor Intl

2 reports

DescriptionDownload
EAM Senfor Intl - eAM Preventative Maintenance Planning
This report will extract all eAM preventative maintenance work orders that are pending release from the last forecast run. The report can be run by any combination of organization, department, scheduled start dates, asset group and asset; see below. Additional parameters may be added as required. Version Modified on Modified  by   Description  ===== ======== == ====== ========   1.0     09 Jun 2020 Ion Yılmaz     Initial Release Copyright 2020 Senfor International Yönetim Danışmanlık Hizmetleri Ltd. Şti. Original Author: İon Yılmaz ([email protected])…
full description		 Manufacturing EAM Senfor Intl XML
EAM Senfor Intl Work Order Details Extract for multiple activity assignments
This report extracts eAM work order details from the eAM Work Order View. The particularity of this report is that it will also search for any valid attributes from the eAM asset activities view. For example, in this case the asset activity attribute2 is used to identify if the asset activity is an ''At Risk'' activity. This attribute is also extracted in this report. The cumulative total lead time, if present, of the activities is also output. The primary usage of this report is in the tracking and planning of eAM maintenance work orders. The report can be run by any combination of…
full description		 Manufacturing EAM Senfor Intl XML