FA CIP Cost – Oracle EBS SQL Report
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.
Overview
CIP Costs Summary/Detail Report
Equivalent to Oracle Standard Reports: CIP Summary Report CIP Detail Report
DB package: XXEN_FA_FAS_XMLP
Report Parameters
Book, Set of Books Currency, From Period, To Period
Oracle EBS Tables Used
fa_system_controls, gl_ledgers, fnd_currencies, fa_balances_report_gt, fa_additions, gl_code_combinations
Report Categories
Related Reports
FA Asset Cost, FA Revaluation Reserve, FA Depreciation Reserve, FA Tax Reserve Ledger, FA Journal Entry Reserve Ledger, FA Cost Adjustments
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 CIP Cost 30-Aug-2021 075221.xlsx |
| Blitz Report™ XML Import | FA_CIP_Cost.xml |
| Full SQL on Enginatics | www.enginatics.com/reports/fa-cip-cost/ |
Executive Summary
The FA CIP Cost report tracks Construction-In-Process (CIP) assets. It details the costs accumulated for assets that are being built or installed but are not yet placed in service. This is crucial for managing capital projects and ensuring timely capitalization.
Business Challenge
- Capital Project Tracking: Monitoring the spend on ongoing projects.
- Timely Capitalization: Identifying projects that are complete and should be moved to active assets to start depreciation.
- Expense vs. Capital: Verifying that only valid capital costs are accumulating in CIP accounts.
The Solution
This Blitz Report provides visibility into CIP accounts by:
- Summary & Detail: Offering both high-level project totals and detailed invoice line items.
- Aging Analysis: Helping identify old CIP items that may need write-off or capitalization.
- Reconciliation: Matching CIP subledger balances to the General Ledger CIP account.
Technical Architecture
Equivalent to the standard CIP Summary/Detail reports, it queries FA_ADDITIONS where the asset type is ‘CIP’. It sums up the cost from FA_BOOKS and details from FA_ASSET_INVOICES.
Parameters & Filtering
- Book: The corporate book used for tracking CIP.
- Period: The reporting period (usually the current open period).
Performance & Optimization
- Clean Up: Regularly capitalizing or expensing CIP items keeps this report performant and the subledger clean.
- Detail Level: Running in “Detail” mode can produce many rows if there are many small invoices attached to CIP assets.
FAQ
- Q: Do CIP assets depreciate?
- A: No, CIP assets do not depreciate until they are capitalized and placed in service.
- Q: How do I move items off this report?
- A: You must perform a “Capitalization” transaction in Oracle Assets to move them from CIP to Capitalized status.
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