| layout | default |
|---|---|
| title | FA Asset Inventory | Oracle EBS SQL Report |
| description | Imported Oracle standard asset inventory report Source: Asset Inventory Report (XML) Short Name: FAS410XML DB package: FAFAS410XMLPPKG |
| keywords | Oracle EBS, Oracle E-Business Suite, SQL report, Blitz Report, Enginatics, R12 only, Asset, Inventory, fa_system_controls, fa_deprn_detail, per_people_f |
| permalink | /FA%20Asset%20Inventory/ |
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.
Imported Oracle standard asset inventory report Source: Asset Inventory Report (XML) Short Name: FAS410_XML DB package: FA_FAS410_XMLP_PKG
Book, From Cost Center, To Cost Center, From Date Placed in Service, To Date Placed in Service
fa_system_controls, fa_deprn_detail, per_people_f, fa_additions, fa_locations, gl_code_combinations, fa_books, fa_distribution_history, fa_adjustments, fa_lookups
Some Oracle EBS SQL reports in this library require functions from the utility package xxen_util. Install it before running the SQL directly against your Oracle EBS database.
| Resource | Link |
|---|---|
| Excel Example Output | FA Asset Inventory 30-Sep-2020 221751.xlsx |
| Blitz Report™ XML Import | FA_Asset_Inventory.xml |
| Full SQL on Enginatics | www.enginatics.com/reports/fa-asset-inventory/ |
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.
- 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.
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.
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.
- 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.
- 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.
- 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.
- 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
© 2026 Enginatics