Results for “asset_category_id”

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

Overview

PA_STANDARD_UNIT_COSTS is a Projects (PA) module table in the Oracle E-Business Suite 12.1.1 and 12.2.2 data model that stores the standard cost per unit for project assets, keyed by asset category and asset book. Its principal functional role is to supply the costing basis for asset line generation when the Asset Cost Allocation Method is set to "Standard Unit Cost." In that configuration, the asset line generation process reads the applicable standard unit cost and uses it to allocate indirect and common costs to generated asset lines. Without a matching row in this table, standard-unit-cost allocation cannot resolve a rate for the category and book combination.

From a dimensional modeling perspective, the heuristic Data Vault classification mined from the foreign key structure is link. This is a modeling suggestion rather than a physical design property: the table resolves the association between an asset book and an asset category and carries the resulting cost measure. Because the two foreign keys form the natural uniqueness of the row, the relationship behaves as a link between two reference entities rather than as a standalone hub or a pure descriptive satellite.

Key Information Stored

The documented physical schema for 12.2.2 comprises eight columns. The most significant are the following:

• BOOK_TYPE_CODE — identifies the asset book. This column carries a foreign key to FA_BOOK_CONTROLS, establishing the depreciation book context in which the standard cost applies.
• ASSET_CATEGORY_ID — identifies the asset category. This column carries a foreign key to FA_CATEGORIES_B, tying the rate to the category used by Oracle Assets.
• STANDARD_UNIT_COST — the substantive business measure: the standard cost per unit applied during asset line generation under the Standard Unit Cost allocation method.
• LAST_UPDATE_DATE — the date of the most recent change to the row; used for incremental extraction and audit.
• LAST_UPDATED_BY — the application user who performed the last update.
• CREATION_DATE — the date the row was inserted.
• CREATED_BY — the application user who created the row.
• LAST_UPDATE_LOGIN — the login identifier associated with the most recent update, used for auditing sessions.

No surrogate single-column primary key is documented. The unique index PA_STANDARD_UNIT_COSTS_U1 on (BOOK_TYPE_CODE, ASSET_CATEGORY_ID) is the business-key candidate: it guarantees a single standard unit cost per asset category within each asset book. The remaining columns are standard WHO/audit attributes.

Common Use Cases and Queries

The primary operational use case is setup validation and troubleshooting of asset line generation. Project accountants maintain these rates so that indirect and common costs are spread predictably across generated asset lines. A frequent query retrieves the configured rate for a given book and category:

• Lookup by business key: SELECT standard_unit_cost FROM pa.pa_standard_unit_costs WHERE book_type_code = :book AND asset_category_id = :category;
• Completeness audit: identify categories lacking a rate for an active book, by joining FA_CATEGORIES_B against this table and filtering for null matches.
• Rate maintenance report: list all books and categories with current rates, ordered by book type code and category.
• Change tracking: extract rows where LAST_UPDATE_DATE exceeds a prior run date, supporting incremental reconciliation and audit trails.
• Zero or negative rate detection: flag rows where STANDARD_UNIT_COST is null, zero, or negative, since these can produce incorrect allocations.

Because the table is small and reference-like, reporting typically involves direct joins to Oracle Assets reference tables rather than aggregation over project transaction volumes.

Related Objects

• FA_BOOK_CONTROLS — joined on BOOK_TYPE_CODE; provides book configuration such as the book class and accounting rules that qualify the standard cost.
• FA_CATEGORIES_B — joined on ASSET_CATEGORY_ID; supplies the asset category definition and related defaults.
• FA_CATEGORIES_TL — the translated category name table, joined through FA_CATEGORIES_B for user-facing reporting.
• PA_ASSET_LINES_ALL — the generated asset lines whose cost allocation depends on the standard unit cost under the Standard Unit Cost method.
• PA_PROJECTS_ALL and PA_TASKS — upstream project structures whose assets are ultimately costed using these rates.
• FA_ADDITIONS_B — the resulting asset additions created from project asset lines, where the allocated cost is ultimately recorded.

Collectively, these relationships position PA_STANDARD_UNIT_COSTS as a compact configuration link between Oracle Assets reference data and the Projects asset line generation process.