Results for “pa_project_assets_efc”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

PA_PROJECT_ASSETS_EFC is a table in the PA (Projects) schema of Oracle E-Business Suite, documented as VALID in releases 12.1.1 and 12.2.2. The "EFC" suffix denotes Enterprise Foundation Common, indicating that this is a denormalized staging or interface structure populated by the Projects costing and capitalization engine. Its documented column set (SET_OF_BOOKS_ID, PROJECT_ASSET_ID, CAPITALIZED_COST, GROUPED_CIP_COST, CREATION_DATE) shows that the table stores monetary summaries related to capitalized project assets, segmented by ledger and by the asset surrogate identifier. It is not an operational transaction table; rather, it supports the calculation, aggregation, and transfer of construction-in-process (CIP) and capitalized cost amounts used in asset generation and posting.

The mined Data Vault classification for this object is standalone, which in heuristic terms suggests the table behaves as a single-source satellite rather than a hub or link. It carries descriptive and numeric measures keyed primarily by project asset and ledger, but it does not act as an integrating hub connecting multiple business entities, nor as an associative link between two or more hubs. From a Data Vault perspective, a modeling exercise would likely treat SET_OF_BOOKS_ID plus PROJECT_ASSET_ID as the composite key of a satellite whose parent hub is the project asset.

Key Information Stored

All five documented columns are significant. The most important are:

• PROJECT_ASSET_ID — the foreign key to PA_PROJECT_ASSETS_ALL and the primary business identifier of the asset record. This is the principal candidate for the surrogate primary key within this table, since it links the EFC summary row back to the asset definition.
• SET_OF_BOOKS_ID — the ledger identifier. Because capitalization and CIP balances are maintained per ledger, this column forms a secondary business-key component and is essential for multi-set-of-books reporting.
• CAPITALIZED_COST — the amount of cost that has been marked as capitalized for the asset. This is the primary monetary measure used in asset cost transfer and in reconciliation of CIP to fixed assets.
• GROUPED_CIP_COST — the construction-in-process cost grouped and accumulated for the asset, reflecting the balance eligible for capitalization or transfer.
• CREATION_DATE — the timestamp when the summary row was created, used for audit, aging, and population-window analysis.

The absence of a documented unique index in the metadata means that uniqueness must be inferred from the business combination of PROJECT_ASSET_ID and SET_OF_BOOKS_ID. No columns beyond those five are documented for this object in ETRM 12.2.2.

Common Use Cases and Queries

PA_PROJECT_ASSETS_EFC is typically consumed during capitalization processing and in reconciliation reporting. A common pattern joins the EFC table back to its parent asset table to retrieve descriptive asset attributes while reporting monetary summaries:

SELECT p.project_asset_id, p.set_of_books_id, p.capitalized_cost, p.grouped_cip_cost
FROM pa.pa_project_assets_efc p
WHERE p.set_of_books_id = :ledger_id;

Another frequent use case involves joining to PA_PROJECT_ASSETS_ALL on PROJECT_ASSET_ID to compare summarized EFC amounts against the asset master, for example to validate that capitalized costs agree with the asset's recorded cost basis. Reporting scenarios include CIP aging, capitalized cost rollups by ledger, and period-end reconciliation between project costing and fixed assets. Because the table is populated with a CREATION_DATE, it is also useful for incremental extraction into a data warehouse, filtering only rows created after the previous load date.

Related Objects

• PA_PROJECT_ASSETS_ALL — the primary parent table. The documented foreign key PA_PROJECT_ASSETS_EFC.PROJECT_ASSET_ID → PA_PROJECT_ASSETS_ALL.PROJECT_ASSET_ID defines the core join path between the EFC summary rows and the asset master.
• FA_ADDITIONS (Fixed Assets) — the capitalized amounts derived through this table are transferred into asset addition records during the capitalization interface; logical join on asset cost and ledger.
• GL_LEDGERS / GL_SETS_OF_BOOKS — supplies the ledger context for SET_OF_BOOKS_ID, required to resolve currency and accounting period information.
• PA_PROJECT_ASSETS_LINES and PA_PROJECT_ASSETS_DIST — detail and distribution tables that feed the summarized EFC amounts.
• PA_ASSET_LINES and the PRC: Asset Generation concurrent programs — the operational processes that populate and consume EFC data during capitalize and transfer operations.

These relationships confirm that PA_PROJECT_ASSETS_EFC functions as a financial summarization layer that bridges project asset definitions and downstream fixed asset and GL postings.