FA Cost Adjustments – 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: Cost Adjustments Report Application: Assets Source: Cost Adjustments Report (XML) Short Name: FAS840_XML DB package: FA_FAS840_XMLP_PKG
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, Show Source Invoice Details
Oracle EBS Tables Used
fdp, fb_old, fb_new, fa_system_controls, gl_ledgers, fnd_currencies, fa_asset_history, fa_additions, fa_asset_keywords_kfv, fa_categories, fa_category_books, fa_lookups, fa_distribution_history, gl_code_combinations, fa_transaction_headers, fa_asset_invoices, ap_suppliers
Report Categories
Related Reports
FA Asset Additions, FA Asset Book Details, FA Fixed Assets Book, FA Asset Upload, FA Asset Summary (Germany), FA Asset Retirements, FA CIP Assets and Invoices, FA Asset Reclassification, FA Depreciation Reserve
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 Cost Adjustments 30-Aug-2021 053010.xlsx |
| Blitz Report™ XML Import | FA_Cost_Adjustments.xml |
| SQL Source | FA Cost Adjustments.sql |
| Full Report 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
© Enginatics GmbH