| layout | default |
|---|---|
| title | FA Cost Adjustments | Oracle EBS SQL Report |
| description | Imported from BI Publisher Description: Cost Adjustments Report Application: Assets Source: Cost Adjustments Report (XML) Short Name: FAS840XML DB… |
| keywords | Oracle EBS, Oracle E-Business Suite, SQL report, Blitz Report, Enginatics, R12 only, Cost, Adjustments, fa_system_controls, gl_ledgers, fnd_currencies |
| permalink | /FA%20Cost%20Adjustments/ |
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.
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
Book, Set of Books Currency, From Period, To Period, Show Source Invoice Details
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
FA Asset Additions, FA Asset Cost, FA Asset Retirements, FA Asset Summary (Germany), FA Asset Book Details, FA Asset Upload
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 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/ |
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.
- 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.
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.
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.
- Book: The asset book.
- Period Range: The time window for the adjustments.
- Show Source Invoice Details: A toggle to include granular invoice data.
- 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.
- 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.
- 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