Search Results cst_le_cost_types_pk

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:

• LEGAL_ENTITY — the legal entity (organization) for which the cost type configuration applies. Part of the primary key and a business-key candidate; references HR_ALL_ORGANIZATION_UNITS.
• COST_TYPE_ID — the cost type being associated with the legal entity. Part of the primary key; references CST_COST_TYPES.
• SET_OF_BOOKS_ID — the general ledger set of books associated with the legal entity, referencing GL_SETS_OF_BOOKS_11I.
• PRIMARY_COST_METHOD — the default costing method used for the legal entity's cost type.
• PAC_RATES_COST_TYPE_ID — the cost type from which periodic actual costing (PAC) rates are drawn; references CST_COST_TYPES.
• ACCOUNTING_LIBRARY_ID — the accounting library applied to the legal entity; references CST_ACCOUNTING_LIBRARIES.
• CREATE_ACCT_ENTRIES — controls whether accounting entries are generated for the cost type.
• POST_TO_GL — indicates whether cost transactions are posted to the general ledger.
• GL_TRANSFER_MODE and GL_TRANSFER_ALLOW_OVERRIDE — govern how and whether journal transfer behavior may be overridden.
• GL_TRANSFER_SUBMIT_JOURNAL_IMP — controls journal import submission during GL transfer.
• RESTRICT_DOC_FLAG — indicates whether documentation is restricted.
• TRANSFER_COST_FLAG and ITERATION_PROC_FLAG — control cost transfer and iteration processing behavior.
• MATERIAL_RELIEF_ALGORITHM — the algorithm used for material relief processing.
• LAST_UPDATE_DATE, CREATION_DATE, CREATED_BY, LAST_UPDATED_BY, REQUEST_ID, PROGRAM_ID and related audit columns — standard EBS who-columns and concurrent program context.

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.