FA Asset Retirements – 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 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.
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, Set of Books Currency, From Period, To Period
Oracle EBS Tables Used
fb, fr, fa_deprn_periods, fa_lookups_vl, fadj, fa_system_controls, gl_sets_of_books, fa_transaction_headers, fa_additions, fa_distribution_history, gl_code_combinations, fa_asset_history, fa_category_books, fa_lookups, fadj1, fa_book_controls, fa_additions_b, fa_asset_keywords_kfv
Report Categories
Related Reports
FA Asset Additions, FA Asset Upload, FA Asset Book Details, FA Fixed Assets Book, FA Asset Reclassification, FA Asset Transfers, FA Cost Adjustments, FA Asset Summary (Germany), FA Asset Inventory 11i
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 Retirements 30-Aug-2021 052300.xlsx |
| Blitz Report™ XML Import | FA_Asset_Retirements.xml |
| SQL Source | FA Asset Retirements.sql |
| Full Report on Enginatics | www.enginatics.com/reports/fa-asset-retirements/ |
Executive Summary
The FA Asset Retirements report details assets that have been retired or sold during a specific period. It is essential for calculating gains and losses on disposal and ensuring that retired assets are removed from the active depreciation schedule.
Business Challenge
- Gain/Loss Calculation: Accurately determining the financial impact of asset disposals.
- Tax Reporting: Reporting asset disposals correctly for tax purposes.
- Clean Register: Preventing “zombie assets” (retired but still on books) from inflating insurance premiums or tax liabilities.
The Solution
This Blitz Report streamlines retirement analysis by:
- Gain/Loss Visibility: Clearly showing the Proceeds of Sale, Cost of Removal, and resulting Gain/Loss.
- Retirement Types: Distinguishing between sales, thefts, or casual retirements.
- Period-End Processing: assisting in the month-end close process by validating all retirement transactions.
Technical Architecture
Based on FAS440_XML, the report queries FA_RETIREMENTS and joins with FA_BOOKS to get the Net Book Value at the time of retirement. It calculates the gain/loss based on the formula: Proceeds - Cost of Removal - Net Book Value.
Parameters & Filtering
- Book: The depreciation book.
- From/To Period: The period range when the retirement occurred.
Performance & Optimization
- Period Range: Keep the range consistent with your financial reporting cycle (e.g., monthly or quarterly).
- Currency: Ensure the correct currency is selected if working in a multi-currency environment.
FAQ
- Q: What happens if I reinstate a retirement?
- A: Reinstatements are typically handled as a separate transaction type or by reversing the retirement entry, depending on how the report filters status.
- Q: Does this include partial retirements?
- A: Yes, it shows both full and partial retirements, with the retired cost portion displayed.
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