Search Results cst_le_cost_types




Overview
Explore in AI Chat

Overview

CST_LE_COST_TYPES is an Oracle EBS cost management table owned by the BOM schema that defines the association between a legal entity and the cost types available to that legal entity. It acts as a control record set: for each combination of legal entity and cost type it records the general ledger context, the primary cost method, and a series of accounting, transfer, and relief processing flags that govern how inventory and manufacturing transactions are costed and posted. The table is central to multi-organization costing setups because it determines, at the legal-entity level, which cost type is used for perpetual and periodic costing and how those costs flow into the general ledger.

The table is documented as a 24-column object with a composite primary key, CST_LE_COST_TYPES_PK, defined on (LEGAL_ENTITY, COST_TYPE_ID). A second unique index, CST_LE_COST_TYPES_U1, enforces the same business key, confirming that a legal entity may reference a given cost type only once. Based on the heuristic Data Vault classification mined from the foreign-key structure, this object is best modeled as a link — it resolves a many-to-many style relationship between legal entities, cost types, and related accounting configuration rather than acting as a standalone hub or a descriptive satellite.

Key Information Stored

The most significant columns of CST_LE_COST_TYPES include the following:

The composite primary key provides the surrogate identity, while the unique index CST_LE_COST_TYPES_U1 mirrors the same columns as the business-key candidate. No separate single-column surrogate key exists.

Common Use Cases and Queries

CST_LE_COST_TYPES is commonly queried to determine the costing and GL posting configuration for a specific legal entity, to validate that the correct cost types and accounting library are assigned, and to trace how periodic actual cost rates are sourced. A representative query to retrieve the configuration for a legal entity follows:

  • SELECT legal_entity, cost_type_id, set_of_books_id, primary_cost_method, pac_rates_cost_type_id, accounting_library_id, post_to_gl, gl_transfer_mode FROM cst_le_cost_types WHERE legal_entity = :legal_entity_id;

Additional reporting scenarios include validating the accounting library and set of books alignment against the operating unit, identifying which legal entities post costs to GL, and auditing changes to the transfer and material relief flags. Because the FK model links legal entities, cost types, sets of books, and accounting libraries, reporting joins across CST_COST_TYPES, HR_ALL_ORGANIZATION_UNITS, GL_SETS_OF_BOOKS_11I and CST_ACCOUNTING_LIBRARIES are typical.

Related Objects

The following objects are the most significant related to CST_LE_COST_TYPES based on the documented foreign-key relationships:

  • CST_COST_TYPES — joined on COST_TYPE_ID and again on PAC_RATES_COST_TYPE_ID; supplies cost type definitions.
  • HR_ALL_ORGANIZATION_UNITS — joined on LEGAL_ENTITY; provides legal entity details.
  • GL_SETS_OF_BOOKS_11I — joined on SET_OF_BOOKS_ID; provides the ledger context.
  • CST_ACCOUNTING_LIBRARIES — joined on ACCOUNTING_LIBRARY_ID; provides accounting rule definitions.
  • CST_LE_COST_TYPES_PK / CST_LE_COST_TYPES_U1 — the primary and unique indexes enforcing the composite business key.

Together these objects form the configuration backbone that cost processing and cost accounting transactions rely on when resolving legal-entity-level costing behavior in Oracle EBS 12.1.1 and 12.2.2.