Results for “absorption_account”

50+ results




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

Overview

The view CSTBV_RTNG_OVHD_CST_SUB_ELMNT is an APPS-owned database view in Oracle E-Business Suite, delivered under the Bills of Material (BOM) product family. Its name indicates that it exposes routing overhead cost sub-elements — specifically the resource-level attributes used to derive overhead cost components during cost rollup and standard costing. The metadata classifies the object as "Retrofitted," meaning it is a backward-compatibility construct preserved across release boundaries; the same definition is shipped for 12.1.1 and 12.2.2.

The view is a filtered, attribute-formatted projection of resource definitions rather than a stored table. Its purpose is to present cost element 5 (overhead) resource records together with the descriptive and accounting attributes required by forms, concurrent programs, and reporting layers that expect a stable, user-facing interface. Because it is created WITH READ ONLY, it functions purely as a query surface and cannot be used for DML.

Users searching for rate_variance_account are typically investigating where a resource's rate variance posting account is stored and how it is surfaced for costing and accounting derivation. This view is one of the standard presentation points for that attribute.

Underlying Base Objects

The view is defined over a single documented base object, referenced in the shipped metadata as the synonym BOM_RESOURCES in the APPS schema. In practice this synonym resolves to the BOM resources table that holds resource codes, expenditure types, absorption and variance accounts, and organization-level costing attributes. No joins to other tables are present in the view text; the definition performs only row filtering and column projection.

Two predicates govern the result set. The first is COST_ELEMENT_ID = 5, restricting output to resources belonging to the overhead cost element. The second is the security predicate '_SEC:BR.ORGANIZATION_ID' IS NOT NULL, which is substituted at runtime by the Multi-Org / security layer so that only resources within the operating units accessible to the current responsibility are visible. The final WITH READ ONLY clause enforces the non-updatable nature of the view.

Key Columns

Common Use Cases and Queries

Typical usage includes verifying that overhead resources carry a valid rate variance account before a cost rollup, reconciling variance postings back to resource setup, and driving custom reports that join resource attributes to cost element or organization data.

  • Locating resources with a missing or unexpected variance account prior to period close.
  • Auditing absorption versus rate variance account assignment across organizations.
  • Extracting overhead resource attributes for integration into external costing or analytics platforms.
  • Validating multi-org visibility — confirming which organization's resources a given responsibility can query.

A representative query:

SELECT resource_id,
       resource_code,
       organization_id,
       rate_variance_account,
       absorption_account
  FROM cstbv_rtng_ovhd_cst_sub_elmnt
 WHERE rate_variance_account IS NOT NULL
   AND (disable_date IS NULL OR disable_date > SYSDATE);

Because the view applies organization security and filters strictly on cost element 5, it returns only active overhead resources visible to the session, making it suitable as a lightweight validation source without directly referencing BOM_RESOURCES.