Results for “pa_project_assets_all”

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

Overview

PA_PROJECT_ASSETS_ALL is the Oracle Projects (PA) transaction table that stores the asset definitions created for capital projects. In Oracle EBS 12.1.1 and 12.2.2, it resides in the PA schema and holds one row per asset (or asset line grouping) that a capital project intends to capitalize, transfer, or otherwise interface to Oracle Assets (FA). It serves as the bridge between project capital events and FA asset records, capturing the attributes required to create FA additions when capitalization is processed.

From a Data Vault modeling perspective, the mined FK structure classifies this object as satellite-leaning. This is a modeling suggestion: the table retains descriptive and state attributes (capitalization flags, dates, cost amounts, asset attributes) tied to a primary business key, rather than acting purely as a hub of distinct business entities or a link resolving many-to-many relationships. Its grain is essentially one asset record per project, anchored by the surrogate PROJECT_ASSET_ID.

Key Information Stored

The table carries 65 documented columns in 12.2.2. The most functionally significant are outlined below.

• PROJECT_ASSET_ID — Surrogate primary key (PA_PROJECT_ASSETS_PK) and the target of dependent foreign keys from assignment and line tables.
• PROJECT_ID — FK to PA_PROJECTS_ALL; identifies the capital project owning the asset definition.
• ASSET_NUMBER, ASSET_NAME, ASSET_DESCRIPTION — Business-facing identifiers and descriptors carried into FA.
• ASSET_CATEGORY_ID — FK to FA_CATEGORIES_B; determines depreciation rules applied on capitalization.
• FA_ASSET_ID, PARENT_ASSET_ID, RET_TARGET_ASSET_ID — FKs to FA_ADDITIONS_B linking to the created asset, its parent, and any retirement target.
• CAPITAL_EVENT_ID — FK to PA_CAPITAL_EVENTS; ties the asset to the capital event that drives capitalization.
• CAPITALIZED_FLAG, CAPITALIZED_DATE, CAPITALIZED_COST — Capitalization status, timing, and cost amount.
• BOOK_TYPE_CODE, FA_PERIOD_NAME, DATE_PLACED_IN_SERVICE — FA book and period context for the addition.
• ORG_ID — Operating unit identifier for multi-org security and partitioning.
• PROJECT_ASSET_TYPE, CAPITAL_HOLD_FLAG — Asset type classification and hold indicator.
• LAST_UPDATE_DATE, CREATED_BY, REQUEST_ID, PROGRAM_ID — Standard WHO/audit and concurrent program columns.

The unique index PA_PROJECT_ASSETS_U1 on PROJECT_ASSET_ID reinforces the surrogate key; no separate natural business-key unique index is documented, so business key candidates should be evaluated from ASSET_NUMBER combined with PROJECT_ID and ORG_ID.

Common Use Cases and Queries

Typical uses include capital project capitalization reporting, reconciliation between project costs and FA additions, and identifying assets pending capitalization.

• Listing un-capitalized assets for a project:

  SELECT project_asset_id, asset_number, asset_name, capitalized_cost FROM pa_project_assets_all WHERE project_id = :p_project_id AND capitalized_flag = 'N';

• Reconciling PA assets to FA additions by joining on FA_ASSET_ID to FA_ADDITIONS_B.
• Retrieving asset attributes destined for the FA interface using ASSET_CATEGORY_ID, BOOK_TYPE_CODE, and DATE_PLACED_IN_SERVICE.
• Audit and purge analysis using CREATED_BY, LAST_UPDATE_DATE, and REQUEST_ID.

Related Objects

• PA_PROJECTS_ALL — joined via PROJECT_ID; the owning project.
• FA_CATEGORIES_B — joined via ASSET_CATEGORY_ID; asset category/depreciation definition.
• PA_CAPITAL_EVENTS — joined via CAPITAL_EVENT_ID; capitalization event source.
• FA_ADDITIONS_B — joined via FA_ASSET_ID, PARENT_ASSET_ID, and RET_TARGET_ASSET_ID; the FA asset master.
• PA_PROJECT_ASSET_ASSIGNMENTS — references PROJECT_ASSET_ID; assignment detail.
• PA_PROJECT_ASSET_LINES_ALL — references PROJECT_ASSET_ID; the cost lines grouped into each asset.
• IPA_APIS_INTERFACE and IPA_APIS_INTERFACE_ERRORS — reference PROJECT_ASSET_ID in the asset interface process.
• PA_PROJECT_ASSETS_EFC — the EFC view counterpart referencing PROJECT_ASSET_ID.