FA CIP Cost – 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
CIP Costs Summary/Detail Report
Equivalent to Oracle Standard Reports: CIP Summary Report CIP Detail Report
DB package: XXEN_FA_FAS_XMLP
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
Oracle EBS Tables Used
msc_form_query, fa_system_controls, gl_ledgers, fnd_currencies, fa_additions, fa_asset_keywords_kfv, gl_code_combinations
Report Categories
Related Reports
FA Asset Cost, FA Revaluation Reserve, FA Depreciation Reserve, FA Cost Adjustments, FA Tax Reserve Ledger, FA Asset Additions, FA Asset Summary (Germany), FA Fixed Assets Book, FA Asset Book Details
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 CIP Cost 30-Aug-2021 075221.xlsx |
| Blitz Report™ XML Import | FA_CIP_Cost.xml |
| SQL Source | FA CIP Cost.sql |
| Full Report 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
© Enginatics GmbH