Search Results cst_le_cost_types_n1

Overview

The BOM.CST_LE_COST_TYPES table is a foundational configuration object within the Oracle E-Business Suite Cost Management (CST) module. It stores the association between Legal Entities and Cost Types, thereby establishing which costing configurations apply to which legal entity within a multi-organization enterprise. The table is owned by the BOM schema (Bills of Material, which historically hosts shared cost management objects) and is classified as VALID in the ETRM metadata for both E-Business Suite 12.1.1 and 12.2.2.

Functionally, this table acts as the governing configuration register for periodic costing, accounting entry generation, and General Ledger transfer behavior. Each row defines the parameters under which a specific cost type operates for a specific legal entity, including whether accounting entries are created, whether those entries are posted to the General Ledger, and which accounting library governs distribution creation. The physical storage resides in the APPS_TS_TX_DATA tablespace with a PCT Free of 10.

From a Data Vault modeling perspective, the mined heuristic classification for CST_LE_COST_TYPES is a link. This reflects the table's inherent role as an associative entity connecting Legal Entities, Cost Types, Sets of Books, and Accounting Libraries, rather than acting as a standalone descriptive hub or a dependent satellite.

Key Information Stored

The table contains 24 documented columns. The most significant for functional and reporting purposes include:

• LEGAL_ENTITY (NUMBER(15), mandatory) — The organization_id of the legal entity; part of the composite primary key and the unique index CST_LE_COST_TYPES_U1.
• COST_TYPE_ID (NUMBER, mandatory) — The identifier of the cost type associated with the legal entity; the second component of the primary key and unique index.
• SET_OF_BOOKS_ID (NUMBER(15)) — The Set of Books (ledger) identifier governing financial postings.
• PRIMARY_COST_METHOD (NUMBER) — The primary cost method, derived from lookup values.
• PAC_RATES_COST_TYPE_ID (NUMBER) — The cost type designated to serve as the source of rates for Periodic Average Cost processing.
• ACCOUNTING_LIBRARY_ID (NUMBER) — Identifies the accounting library used to generate accounting distributions for the Legal Entity/Cost Type combination.
• CREATE_ACCT_ENTRIES (VARCHAR2) — Flag allowing creation of accounting entries for periodic costing; indexed by CST_LE_COST_TYPES_N1.
• POST_TO_GL (VARCHAR2) — Flag allowing posting of accounting entries to General Ledger; indexed by CST_LE_COST_TYPES_N2.
• GL_TRANSFER_ALLOW_OVERRIDE, GL_TRANSFER_MODE, GL_TRANSFER_SUBMIT_JOURNAL_IMP — Control override permissions, transfer mode, and journal import submission behavior.
• RESTRICT_DOC_FLAG, TRANSFER_COST_FLAG, ITERATION_PROC_FLAG, MATERIAL_RELIEF_ALGORITHM — Govern documentation restrictions, cost transfer behavior, iteration processing, and material relief calculation.
• Standard and Extended Who columns — LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, and LAST_UPDATE_LOGIN.

The surrogate primary key is CST_LE_COST_TYPES_PK (LEGAL_ENTITY, COST_TYPE_ID), which is functionally identical to the business-key candidate represented by unique index CST_LE_COST_TYPES_U1. The uniqueness constraint ensures a legal entity cannot be assigned the same cost type twice.

Common Use Cases and Queries

A recurring scenario is validating which cost types are enabled for accounting entry creation or GL posting across legal entities. A representative query joining to CST_COST_TYPES for descriptive names follows:

SELECT lec.legal_entity, ct.cost_type, lec.set_of_books_id,
       lec.create_acct_entries, lec.post_to_gl, lec.gl_transfer_mode
FROM   bom.cst_le_cost_types lec,
       bom.cst_cost_types ct
WHERE  lec.cost_type_id = ct.cost_type_id
AND    lec.create_acct_entries = 'Y';

Reporting use cases include auditing GL transfer configuration, identifying legal entities using a specific accounting library, and verifying Primary Cost Method assignments. The CST_LE_COST_TYPES_N1 and CST_LE_COST_TYPES_N2 indexes support efficient filtering on the CREATE_ACCT_ENTRIES and POST_TO_GL flags respectively, which is valuable when scanning large enterprises for misconfigured legal entities.

Related Objects

• HR_ALL_ORGANIZATION_UNITS — Joined via CST_LE_COST_TYPES.LEGAL_ENTITY = HR_ALL_ORGANIZATION_UNITS.ORGANIZATION_ID to resolve legal entity names.
• CST_COST_TYPES — Referenced twice via COST_TYPE_ID and PAC_RATES_COST_TYPE_ID; supplies cost type descriptions.
• GL_SETS_OF_BOOKS_11I — Referenced via SET_OF_BOOKS_ID; resolves ledger information.
• CST_ACCOUNTING_LIBRARIES — Referenced via ACCOUNTING_LIBRARY_ID; identifies distribution generation rules.
• CST_COST_TYPES_PK and the CST_LE_COST_TYPES indexes — CST_LE_COST_TYPES_U1, N1, and N2 — support integrity and query performance.