Search Results pa_standard_unit_costs




Overview
Explore in AI Chat

Overview

The PA_STANDARD_UNIT_COSTS table is a core data structure within Oracle E-Business Suite Projects (PA) module. It functions as a repository for pre-defined cost rates used specifically for capitalizing project expenditures as fixed assets. The table's primary role is to support the "Standard Unit Cost" asset cost allocation method. When this method is configured, the system utilizes the standard costs stored in this table during the asset line generation process to automatically allocate indirect and common costs to project assets. This enables systematic and rule-based capitalization, ensuring asset costs are calculated consistently based on asset category and accounting book.

Key Information Stored

The table stores the standard cost per unit, keyed by two critical dimensions from the Fixed Assets module: the Asset Book and the Asset Category. While the full column list is not detailed in the provided metadata, the foreign key relationships explicitly identify the core columns. The BOOK_TYPE_CODE column links to the FA_BOOK_CONTROLS table, identifying the depreciation or corporate book for which the standard cost is valid. The ASSET_CATEGORY_ID column links to the FA_CATEGORIES_B table, defining the class of asset (e.g., Computers, Machinery, Furniture). The central piece of data is the STANDARD_COST column (implied by the table's description), which holds the monetary value per unit for that specific category and book combination. Additional columns likely include effective date ranges, last update information, and a unique identifier.

Common Use Cases and Queries

The primary use case is the automated generation of asset lines for project costs. When a project's asset cost allocation method is set to "Standard Unit Cost," the system references this table to assign a cost to capitalized items. Common operational queries involve maintenance and reporting. Administrators may run queries to review or update standard costs for an upcoming fiscal period. Financial analysts often query the table to audit capitalization rates or reconcile project costs with fixed asset valuations. A typical reporting query would join this table with asset category and book control descriptions.

SELECT fc.SEGMENT1 asset_category,
       fbc.BOOK_TYPE_CODE,
       psc.standard_cost,
       psc.last_update_date
  FROM pa_standard_unit_costs psc,
       fa_categories_b fc,
       fa_book_controls fbc
 WHERE psc.asset_category_id = fc.category_id
   AND psc.book_type_code = fbc.book_type_code
   AND fbc.book_class = 'CORPORATE';

Related Objects

  • FA_BOOK_CONTROLS: A Fixed Assets table that defines accounting books. It is referenced via a foreign key on the BOOK_TYPE_CODE column to ensure the standard cost is associated with a valid asset book.
  • FA_CATEGORIES_B: The base table for Fixed Assets categories. It is referenced via a foreign key on the ASSET_CATEGORY_ID column, tying the standard cost to a specific type of capital asset.
  • Project Assets & Capitalization Processes: The table is integral to the asset line generation engine within Projects. Key APIs and programs that perform asset cost allocation will read from this table when the standard unit cost method is applied.