FA Asset Register – Oracle EBS SQL Report
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™. Oracle EBS module: Assets · all Assets reports
Overview
Application: Assets Source: Asset Register Report (XML) Short Name: FAS600_XML DB package: FA_FAS600_XMLP_PKG
Run this report in Excel in seconds: download Blitz Report™ free (your first 30 reports are free) or try it in the online demo.
Report Parameters
Book, From Period, To Period, From Asset Number, To Asset Number, Asset Key, Show Deprn Book Details, Show Distribution Details, Show Invoice Details, DFF Display
Oracle EBS Tables Used
fa_asset_keywords_kfv, fa_transaction_headers, fa_asset_history, fa_books, fa_categories, fa_lookups, fa_additions_tl, fa_additions_b, fa_book_controls, fa_deprn_periods, fa_ceiling_types, fa_deprn_summary, fa_methods, fa_itc_rates, fa_convention_types, fa_calendar_periods, fa_calendar_types, fa_locations, gl_code_combinations, per_all_people_f, fa_distribution_history, fa_employees, ap_invoices_all, fa_asset_invoices, po_vendors
Report Categories
Related Reports
FA Asset Book Details, FA Asset Upload, FA Fixed Assets Book, FA Asset Additions, FA Asset Summary (Germany), FA Asset Transfers, FA Additions By Source
Running This SQL Without Blitz Report
The SQL source can be run in any SQL client. Some Oracle EBS SQL reports in this library use functions from the utility package xxen_util – install it first. Blitz Report™ adds parameters, Excel output with pivots, scheduling and security on top.
Download & Import Options
| Resource | Link |
|---|---|
| Excel Example Output | FA Asset Register 06-Sep-2023 081714.xlsx |
| Blitz Report™ XML Import | FA_Asset_Register.xml |
| SQL Source | FA Asset Register.sql |
| Full Report on Enginatics | www.enginatics.com/reports/fa-asset-register/ |
Executive Summary
The FA Asset Register is a fundamental report for fixed asset management, providing a comprehensive listing of all assets in a book. It serves as the primary source of truth for asset details, including cost, depreciation, location, and invoice information.
Business Challenge
- Asset Visibility: Difficulty in getting a complete picture of an asset’s financial and physical attributes in one place.
- Reconciliation: Needing a detailed subledger report to reconcile with General Ledger balances.
- Data Integrity: Verifying that all capitalized assets have the correct depreciation method and life assigned.
The Solution
This Blitz Report enhances the standard Asset Register by:
- Comprehensive Data: Combining asset header, book, distribution, and invoice data into a single view.
- Flexible Detail Levels: Allowing users to toggle details for depreciation, distributions, and invoices.
- Excel Analysis: Enabling pivot tables to summarize cost by category, location, or cost center.
Technical Architecture
The report mimics the FAS600_XML standard report. It joins FA_ADDITIONS (header), FA_BOOKS (financials), FA_DISTRIBUTION_HISTORY (assignments), and FA_ASSET_INVOICES (source). It handles the complexity of showing current vs. historical data based on the selected period.
Parameters & Filtering
- Book: The depreciation book (Required).
- Asset Number Range: To run for specific assets.
- Show Details: Flags to include/exclude Depreciation, Distribution, and Invoice details.
Performance & Optimization
- Detail Flags: Turn off “Show Invoice Details” or “Show Distribution Details” if you only need high-level financial data to speed up execution.
- Asset Range: Use for targeted analysis of specific assets rather than running the full book.
FAQ
- Q: Why is the report output so wide?
- A: It includes detailed sections for distributions and invoices, which adds many columns. You can hide unused columns in Blitz Report.
- Q: Does this show fully retired assets?
- A: It typically shows assets active during the requested period or fiscal year.
Useful Links
- Blitz Report™ – World’s Fastest Oracle EBS Reporting Tool
- Oracle Discoverer Replacement – Import Worksheets into Blitz Report™
- Oracle EBS Reporting Toolkits by Blitz Report™
- Blitz Report™ FAQ & Community Q&A
- Supply Chain Hub by Blitz Report™
- Blitz Report™ Customer Case Studies
- Oracle EBS Reporting Blog
- Oracle EBS Reporting Resource Centre
© Enginatics GmbH