FA Cost Adjustments – Oracle EBS SQL Report
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.
Overview
Imported from BI Publisher Description: Cost Adjustments Report Application: Assets Source: Cost Adjustments Report (XML) Short Name: FAS840_XML DB package: FA_FAS840_XMLP_PKG
Report Parameters
Book, Set of Books Currency, From Period, To Period, Show Source Invoice Details
Oracle EBS Tables Used
fa_system_controls, gl_ledgers, fnd_currencies, fa_asset_history, fa_additions, fa_categories, fa_category_books, &lp_fa_books, fa_lookups, &lp_fa_deprn_periods, fa_distribution_history, gl_code_combinations, fa_transaction_headers, fa_trx, fa_asset_invoices, ap_suppliers
Report Categories
Related Reports
FA Asset Additions, FA Asset Cost, FA Asset Retirements, FA Asset Summary (Germany), FA Asset Book Details, FA Asset Upload
Running This SQL Without Blitz Report
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.
Download & Import Options
| Resource | Link |
|---|---|
| Excel Example Output | FA Cost Adjustments 30-Aug-2021 053010.xlsx |
| Blitz Report™ XML Import | FA_Cost_Adjustments.xml |
| Full SQL on Enginatics | www.enginatics.com/reports/fa-cost-adjustments/ |
Executive Summary
The FA Cost Adjustments report provides a detailed audit trail of all changes made to asset costs within a specified period. It is essential for verifying that cost adjustments—whether from invoice additions, manual adjustments, or revaluations—are correctly recorded and approved.
Business Challenge
- Audit Trail: Tracking who changed an asset’s cost and why.
- Financial Accuracy: Ensuring that cost adjustments are reflected in the depreciation base.
- Invoice Reconciliation: Matching cost adjustments back to the source AP invoices.
The Solution
This Blitz Report enhances the standard cost adjustment tracking by:
- Source Details: Optionally showing the specific invoice lines that drove the cost change.
- Transaction Context: Linking the adjustment to the specific transaction type (e.g., ADDITION, ADJUSTMENT).
- Supplier Visibility: Displaying supplier information for invoice-related adjustments.
Technical Architecture
Based on FAS840_XML, the report queries FA_TRANSACTION_HEADERS for cost-impacting transactions. It joins FA_ASSET_INVOICES and AP_SUPPLIERS to provide the upstream source document details when requested.
Parameters & Filtering
- Book: The asset book.
- Period Range: The time window for the adjustments.
- Show Source Invoice Details: A toggle to include granular invoice data.
Performance & Optimization
- Invoice Details: Enabling “Show Source Invoice Details” adds significant volume to the report; use only when detailed reconciliation is needed.
- Period Range: Keep the range narrow (e.g., current period) for month-end validation.
FAQ
- Q: Does this show mass additions?
- A: Yes, if the mass addition resulted in a cost adjustment or new asset cost.
- Q: Why is the cost adjustment negative?
- A: A negative adjustment typically indicates a credit memo or a manual reduction in asset value.
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
© 2026 Enginatics