FA Asset Inventory – 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
Imported Oracle standard asset inventory report Source: Asset Inventory Report (XML) Short Name: FAS410_XML DB package: FA_FAS410_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 Cost Center, To Cost Center, From Date Placed in Service, To Date Placed in Service
Oracle EBS Tables Used
fa_system_controls, fa_deprn_detail, per_people_f, fa_additions, fa_asset_keywords_kfv, fa_locations, gl_code_combinations, fa_books, fa_distribution_history, fa_adjustments, fa_lookups
Report Categories
Related Reports
FA Asset Transfers, FA Fixed Assets Book, FA Asset Inventory 11i, FA Asset Additions, FA Asset Register, FA Asset Upload, FA Asset Book Details, GL Account Distribution Analysis, FA Asset Retirements
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 Inventory 30-Sep-2020 221751.xlsx |
| Blitz Report™ XML Import | FA_Asset_Inventory.xml |
| SQL Source | FA Asset Inventory.sql |
| Full Report on Enginatics | www.enginatics.com/reports/fa-asset-inventory/ |
Executive Summary
The FA Asset Inventory report is a direct import of the standard Oracle “Asset Inventory Report” (FAS410_XML). It generates a comprehensive list of assets for physical inventory verification, ensuring that the system records match the physical reality of asset holdings.
Business Challenge
- Physical Verification: The need to periodically verify the existence and condition of fixed assets.
- Ghost Assets: Identifying assets that are recorded in the system but no longer exist physically.
- Location Tracking: Ensuring assets are located where the system says they are.
The Solution
This Blitz Report provides the standard Oracle functionality with the added benefit of direct Excel output:
- Standard Compliance: Uses the certified Oracle logic (
FA_FAS410_XMLP_PKG) for inventory reporting. - Location & Custodian: Displays key physical attributes like Location, Employee, and Tag Number.
- Cost Center Analysis: Allows grouping by cost center for departmental sign-offs.
Technical Architecture
This report is based on the Oracle standard XML Publisher report FAS410_XML. It utilizes standard views and tables such as FA_ADDITIONS, FA_BOOKS, FA_LOCATIONS, and FA_DISTRIBUTION_HISTORY. It calculates current cost and net book value as of the run date.
Parameters & Filtering
- Book: The depreciation book (Required).
- From/To Cost Center: Range of cost centers to limit the inventory list.
- From/To Date Placed in Service: Filter assets based on their capitalization date.
Performance & Optimization
- Cost Center Batching: For large organizations, run the report by ranges of Cost Centers to distribute the verification workload.
- Active Assets: The report typically filters for active assets; ensure retired assets are not expected unless specified.
FAQ
- Q: Is this different from the standard Oracle PDF report?
- A: The data source is the same, but Blitz Report renders it directly into Excel, making it easier to filter, sort, and use as a checklist.
- Q: Can I see retired assets?
- A: This report is primarily for existing inventory. Use “FA Asset Retirements” for retired assets.
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