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

3 reports

DescriptionDownload
FA Asset Upload
Upload to create, update, and retire fixed assets using FA Public APIs. New assets are created via fa_addition_pub.do_addition. Existing assets are updated via fa_asset_desc_pub.update_desc, fa_reclass_pub.do_reclass, and fa_adjustment_pub.do_adjustment. Asset retirements are processed via fa_retirement_pub.do_retirement; after uploading retirements, run the Calculate Gains and Losses program to finalize them and post the gain/loss. Use the Record Type column to select Addition or Retirement processing. Fully retired assets are excluded from the list unless Include Retired Assets is set to…
full description		 Assets Enginatics, Upload XML
FA Mass Additions Upload
Maintains Oracle Assets Prepare Mass Additions queue lines. Use the Operation column to choose what each row does: Update (change fields and/or Queue), Create (add a new mass addition line), Merge, Split, Unsplit, Add to Asset or Undo Add to Asset. Queue (Post, On Hold, Delete, On-Review) sets the posting status of the line on an Update. Merge combines the lines that share a Merge Group label into the one row marked Primary Line = Yes; that line is kept as the asset and accumulates the cost of the other lines (and their units when Sum Units = Yes), and is set to On Hold. The Attribute…
full description		 Assets Enginatics, Upload XML
FA Mass Additions Upload 11i
Maintains Oracle Assets Prepare Mass Additions queue lines. Use the Operation column to choose what each row does: Update (change fields and/or Queue), Create (add a new mass addition line), Merge, Split, Unsplit, Add to Asset or Undo Add to Asset. Queue (Post, On Hold, Delete, On-Review) sets the posting status of the line on an Update. Merge combines the lines that share a Merge Group label into the one row marked Primary Line = Yes; that line is kept as the asset and accumulates the cost of the other lines (and their units when Sum Units = Yes), and is set to On Hold. The Attribute…
full description		 Assets Enginatics, Upload XML