FA Additions By Source – 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: Additions By Source Report Short Name: FASASSBS
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, Asset Number, Asset Key
Oracle EBS Tables Used
fa_lookups_vl, fa_distribution_history, fa_asset_history, fa_category_books, fa_lookups, fa_additions, gl_code_combinations, fa_transaction_headers, fa_deprn_detail, fa_deprn_periods, fa_locations_kfv, fa_asset_keywords_kfv, fa_adjustments, fa_asset_invoices, fa_invoice_transactions, po_vendors
Report Categories
Related Reports
FA Asset Additions, FA Asset Retirements, FA Asset Upload, FA Fixed Assets Book, FA Asset Book Details, FA Asset Register
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 Additions By Source - Pivot Default Template 18-Jul-2023 150338.xlsx |
| Blitz Report™ XML Import | FA_Additions_By_Source.xml |
| SQL Source | FA Additions By Source.sql |
| Full Report on Enginatics | www.enginatics.com/reports/fa-additions-by-source/ |
FA Additions By Source
Description
This report provides a detailed analysis of asset additions, categorized by their source. It is based on the standard Oracle “Additions By Source Report” and helps financial analysts track where new assets are originating from (e.g., Accounts Payable invoices, manual entries, or project capitalization).
Key features:
- Source Tracking: Identifies the origin of each asset addition.
- Financial Details: Includes cost, depreciation, and transaction details.
- Audit Trail: Links assets back to their source transactions, such as AP invoices (
fa_asset_invoices,po_vendors).
This report is essential for reconciling asset subledgers with general ledger accounts and verifying the accuracy of capital expenditures.
Parameters
- Book: The depreciation book to report on.
- From Period: Start period for the report.
- To Period: End period for the report.
Used Tables
fa_lookups_vl,fa_lookups: Lookup values for codes.fa_distribution_history: Asset distribution history.fa_asset_history: Asset history changes.fa_category_books: Asset category configurations.fa_additions: Asset master information.gl_code_combinations: General Ledger account codes.fa_transaction_headers: Transaction history.fa_deprn_detail,fa_deprn_periods: Depreciation details.fa_adjustments: Financial adjustments.fa_asset_invoices: Links to AP invoices.fa_invoice_transactions: Invoice transaction details.po_vendors: Supplier information.
Categories
- Enginatics: Fixed Assets reporting and reconciliation.
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