Blitz Report™ Library

The Blitz Report™ library is a collection of operational and diagnostic reports for Oracle E-Business Suite

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

138 reports

	Description
FA Additions By Source	Application: Assets Source: Additions By Source Report Short Name: FASASSBS	Assets Enginatics
FA Asset Additions	Imported from BI Publisher Description: Asset Additions Report Application: Assets Source: Asset Additions Report (XML) Short Name: FAS420_XML DB package: FA_FAS420_XMLP_PKG	Assets Enginatics
FA Asset Book Details	FA asset books with asset depreciation summary and financial transaction values. Using parameters 'Show Calendar', 'Show Alternative Ledgers', 'Show Accounting Rules', 'Show Natural Accounts' shows the setup details of book controls.	Assets Enginatics
FA Asset Cost	Asset Costs Summary/Detail Report Equivalent to Oracle Standard Reports: Cost Summary Report Cost Detail Report DB package: XXEN_FA_FAS_XMLP	Assets Enginatics, R12 only
FA Asset Inventory	Imported Oracle standard asset inventory report Source: Asset Inventory Report (XML) Short Name: FAS410_XML DB package: FA_FAS410_XMLP_PKG	Assets Enginatics
FA Asset Reclassification	Application: Assets Source: Asset Reclassification Report (XML) - Not Supported: Reserved For Future Use Short Name: FAS740_XML DB package: FA_FAS740_XMLP_PKG	Assets Enginatics, R12 only
FA Asset Register	Application: Assets Source: Asset Register Report (XML) Short Name: FAS600_XML DB package: FA_FAS600_XMLP_PKG	Assets Enginatics
FA Asset Retirements	Imported from BI Publisher Description: Asset Retirements Report Application: Assets Source: Asset Retirements Report (XML) Short Name: FAS440_XML DB package: FA_FAS440_XMLP_PKG Note: as in the Oracle report, a retirement is listed only once its gain and loss accounting entries exist.	Assets Enginatics
FA Asset Summary (Germany)	Description: Asset Summary Report (Germany) Application: Assets This Blitz Report has been extended to allow it to be run across multiple Ledgers and/or Asset Books. Source: Asset Summary Report (Germany) Short Name: FASSUMRPT DB package: XXEN_FA_FAS_XMLP	Assets Enginatics, R12 only
FA Asset Transfers	Asset transfers between distributions (employee, expense account and location), one row per transfer and distribution side. A transfer closes the From distributions and creates the To distributions. Units, cost and reserve are signed, negative on the From side and positive on the To side, so a transfer nets to zero and a sum by cost center, account or location shows what moved in and out. Cost, reserve, depreciation expense and revaluation reserve are the amounts the transfer moved between the distributions in the selected book, taken from its accounting adjustments. A back-dated transfer… full description	Assets Enginatics
FA CIP Cost	CIP Costs Summary/Detail Report Equivalent to Oracle Standard Reports: CIP Summary Report CIP Detail Report DB package: XXEN_FA_FAS_XMLP	Assets Enginatics, R12 only
FA Cost Adjustments	Imported from BI Publisher Description: Cost Adjustments Report Application: Assets Source: Cost Adjustments Report (XML) Short Name: FAS840_XML DB package: FA_FAS840_XMLP_PKG	Assets Enginatics
FA Depreciation Projection	Based on Oracle's 'Depreciation Projection Report' FASPRJ Uses custom DB package call XXEN_FA_FAS_XMLP to launch Oracle standard Depreciation Projection concurrent FAPROJ. The data generation is explained in note: How Does FA Depreciation Projections Handle Table FA_PROJ_INTERIM_XXX or FA_PROJ_INTERIM_REP ? (KB730395) https://support.oracle.com/support/?kmContentId=1607626	Assets Enginatics, R12 only
FA Depreciation Reserve	Depreciation Reserve Summary/Detail Report Equivalent to Oracle Standard Reports: Reserve Summary Report Reserve Detail Report DB package: XXEN_FA_FAS_XMLP	Assets Enginatics, R12 only
FA Journal Entry Reserve Ledger	Imported Oracle standard journal entry reserve ledger report. The Asset Account column and the template 'Pivot: Account Reconciliation Reserve Ledger' cover the Account Reconciliation Reserve Ledger Report (FAS403), which shows the same reserve ledger grouped by asset account instead of depreciation expense account. Source: Journal Entry Reserve Ledger Report (XML) Short Name: FAS400_XML DB package: XXEN_FA_FAS_XMLP	Assets Enginatics, R12 only
FA Revaluation Reserve	Revaluation Reserve Summary/Detail Report Equivalent to Oracle Standard Reports: Revaluation Reserve Summary Report Revaluation Reserve Detail Report DB package: XXEN_FA_FAS_XMLP	Assets Enginatics, R12 only
FA Tax Reserve Ledger	Imported Oracle standard tax reserve ledger report Source: Tax Reserve Ledger Report (XML) Short Name: FAS480_XML DB package: FA_FAS480_XMLP_PKG Custom Package: XXEN_FA_FAS_XMLP	Assets Enginatics, R12 only
FA Asset Impairments	Source: Asset Impairment Report Short Name: FAXRASIM DB package:	Assets Enginatics, R12 only
FA Asset Inventory 11i	Imported Oracle standard asset inventory report Source: Asset Inventory Report (XML) Short Name: FAS410_XML DB package: FA_FAS410_XMLP_PKG	Assets Enginatics
FA Asset Inventory Report	Application: Assets Source: Asset Inventory Report (Enginatics)	Assets Enginatics
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
FA CIP Assets and Invoices	CIP (Construction in Progress) assets with invoice details. Shows asset master information (category, location, tag, cost) alongside AP invoice lines that feed into CIP. Run as-is for invoice-level detail, or pivot/group in Excel for an asset-level summary - Use template Asset Summary Covers the use cases of: - Monthly CIP Report - Asset Details (CapEx) - Monthly CIP Report - CIP Invoice Activity	Assets Enginatics
FA Fixed Assets Book	Assets held in a depreciation book with their cost, depreciation and net book value as at the end of the selected period. Replaces the Oracle standard RXi: Fixed Assets Book report. The rows are extracted by the same routine its RX-only: Fixed Assets Book data program uses, so cost and depreciation figures are identical. The two seeded RXi attribute sets, Default and Book Details, are shipped as the templates of the same names; each puts the asset detail on the report sheet and the RXi group subtotals on a pivot sheet beside it. One row per asset distribution, so an asset split over several… full description	Assets Enginatics, R12 only
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
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
FA Asset Category Listing	Fixed Asset categories overview report with asset category, general ledger accounts, depreciation method, expected life and depreciated life.	Assets Draft
FA Asset%	Detail report with retirement ID, asset ID, date retired, cost retired, status, retirement prorate convention, number of units, cost, gain or loss amount, proceeds and retirement type.	Assets Draft
FA ACE Depreciation Comparison	Application: Assets Source: ACE Depreciation Comparison Report Short Name: FASACEDP	Assets
FA ACE Non-Depreciating Assets Exception	Imported from Concurrent Program Application: Assets Source: ACE Non-Depreciating Assets Exception Report Short Name: FASACEND	Assets Concurrent Program
FA Account Reconciliation Reserve Ledger - draft	Application: Assets Source: Account Reconciliation Reserve Ledger Report (XML) - Not Supported: Reserved For Future Use Short Name: FAS403_XML DB package: FA_FAS403_XMLP_PKG	Assets BI Publisher
FA Adjusted Form 4626 - AMT Detail Report- Not Supported: Reserved For Future Use	Imported from BI Publisher Description: Adjusted Form 4626 - AMT Detail Report Application: Assets Source: Adjusted Form 4626 - AMT Detail Report (XML) - Not Supported: Reserved For Future Use Short Name: FASAAMTD_XML DB package: FA_FASAAMTD_XMLP_PKG	Assets BI Publisher
FA Adjusted Form 4626 - AMT Summary Report- Not Supported: Reserved For Future Use	Imported from BI Publisher Description: Adjusted Form 4626 - AMT Summary Report Application: Assets Source: Adjusted Form 4626 - AMT Summary Report (XML) - Not Supported: Reserved For Future Use Short Name: FASAAMTS_XML DB package: FA_FASAAMTS_XMLP_PKG	Assets BI Publisher
FA Annual Additions - draft	Application: Assets Source: Annual Additions Report (XML) - Not Supported: Reserved For Future Use Short Name: FASANADD_XML DB package: FA_FASANADD_XMLP_PKG	Assets BI Publisher
FA Asset Additions By Cost Center Report- Not Supported: Reserved For Future Use	Imported from BI Publisher Description: Asset Additions By Cost Center Report Application: Assets Source: Asset Additions By Cost Center Report (XML) - Not Supported: Reserved For Future Use Short Name: FAS421_XML DB package: FA_FAS421_XMLP_PKG	Assets BI Publisher
FA Asset Additions Responsibility Report- Not Supported: Reserved For Future Use	Imported from BI Publisher Description: Asset Additions Responsibility Report Application: Assets Source: Asset Additions Responsibility Report (XML) - Not Supported: Reserved For Future Use Short Name: FAS490_XML DB package: FA_FAS490_XMLP_PKG	Assets BI Publisher
FA Asset Description Listing - draft	Application: Assets Source: Asset Description Listing (XML) - Not Supported: Reserved For Future Use Short Name: FAS730_XML DB package: FA_FAS730_XMLP_PKG	Assets BI Publisher
FA Asset Details		Assets
FA Asset Disposals Responsibility Report- Not Supported: Reserved For Future Use	Imported from BI Publisher Description: Asset Disposals Responsibility Report Application: Assets Source: Asset Disposals Responsibility Report (XML) - Not Supported: Reserved For Future Use Short Name: FAS500_XML DB package: FA_FAS500_XMLP_PKG	Assets BI Publisher
FA Asset Maintenance Report- Not Supported: Reserved For Future Use	Imported from BI Publisher Description: Asset Maintenance Report Application: Assets Source: Asset Maintenance Report (XML) - Not Supported: Reserved For Future Use Short Name: FASMAINT_XML DB package: FA_FASMAINT_XMLP_PKG	Assets BI Publisher
FA Asset Reclassification Reconciliation - draft	Application: Assets Source: Asset Reclassification Reconciliation Report (XML) - Not Supported: Reserved For Future Use Short Name: FAS741_XML DB package: FA_FAS741_XMLP_PKG	Assets BI Publisher
FA Asset Retirement Tax Register -(Russia)	Application: Assets Source: Asset Retirement Tax Register -(Russia) Short Name: FASARTR DB package: FA_RETMT_TAX_REG_RPT_PKG	Assets BI Publisher
FA Asset Retirements By Cost Center Report- Not Supported: Reserved For Future Use	Imported from BI Publisher Description: Asset Retirements By Cost Center Report Application: Assets Source: Asset Retirements By Cost Center Report (XML) - Not Supported: Reserved For Future Use Short Name: FAS441_XML DB package: FA_FAS441_XMLP_PKG	Assets BI Publisher
FA Asset Retirements Report- Not Supported: Reserved For Future Use	Application: Assets Source: Asset Retirements Report (XML) - Not Supported: Reserved For Future Use Short Name: FAS440_XML DB package: FA_FAS440_XMLP_PKG	Assets BI Publisher
FA Asset Tag Listing - draft	Application: Assets Source: Asset Tag Listing (XML) - Not Supported: Reserved For Future Use Short Name: FAS720_XML DB package: FA_FAS720_XMLP_PKG	Assets BI Publisher
FA Asset Tax Accounting Card (Russia)	Imported from BI Publisher Application: Assets Source: Asset Tax Accounting Card (Russia) Short Name: FASTAC DB package: FA_TAX_ACCT_CARD_PKG	Assets BI Publisher
FA Asset Transfer Reconciliation - draft	Application: Assets Source: Asset Transfer Reconciliation Report (XML) - Not Supported: Reserved For Future Use Short Name: FAS431_XML DB package: FA_FAS431_XMLP_PKG	Assets BI Publisher
FA Asset Transfers - draft	Application: Assets Source: Asset Transfers Report (XML) - Not Supported: Reserved For Future Use Short Name: FAS430_XML DB package: FA_FAS430_XMLP_PKG	Assets BI Publisher
FA Assets By Category Report- Not Supported: Reserved For Future Use	Imported from BI Publisher Description: Assets By Category Report Application: Assets Source: Assets By Category Report (XML) - Not Supported: Reserved For Future Use Short Name: FAS780_XML DB package: FA_FAS780_XMLP_PKG	Assets BI Publisher
FA Assets Not Assigned To Any Books Listing - draft	Application: Assets Source: Assets Not Assigned To Any Books Listing (XML) - Not Supported: Reserved For Future Use Short Name: FAS700_XML DB package: FA_FAS700_XMLP_PKG	Assets BI Publisher
FA Bonus Depreciation Rule Listing - draft	Application: Assets Source: Bonus Depreciation Rule Listing (XML) - Not Supported: Reserved For Future Use Short Name: FASRTDBR_XML DB package: FA_FASRTDBR_XMLP_PKG	Assets BI Publisher

Blitz Report™ Library

The Blitz Report™ library is a collection of operational and diagnostic reports for Oracle E-Business Suite

Also found in SQL, tables and columns