| layout | default |
|---|---|
| title | FA Additions By Source | Oracle EBS SQL Report |
| description | Application: Assets Source: Additions By Source Report Short Name: FASASSBS – Oracle E-Business Suite SQL report |
| keywords | Oracle EBS, Oracle E-Business Suite, SQL report, Blitz Report, Enginatics, R12 only, Additions, Source, fa_lookups_vl, fa_distribution_history, fa_asset_history |
| permalink | /FA%20Additions%20By%20Source/ |
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.
Application: Assets Source: Additions By Source Report Short Name: FASASSBS
Book, From Period, To Period
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_adjustments, fa_asset_invoices, fa_invoice_transactions, po_vendors
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 Additions By Source - Pivot Default Template 18-Jul-2023 150338.xlsx |
| Blitz Report™ XML Import | FA_Additions_By_Source.xml |
| Full SQL on Enginatics | www.enginatics.com/reports/fa-additions-by-source/ |
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.
- Book: The depreciation book to report on.
- From Period: Start period for the report.
- To Period: End period for the report.
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.
- Enginatics: Fixed Assets reporting and reconciliation.
- 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