Search Results cst_cg_list_temp

Overview

CST_CG_LIST_TEMP is a transient staging table owned by the BOM (Bills of Material) schema in Oracle E-Business Suite. Its documented purpose is to hold a "temporary list of cost groups for use in cost reporting." In practice, this object serves as a scratchpad or collection buffer: rather than storing durable application data such as item costs or open orders, it holds a working set of cost group identifiers that a reporting or cost rollup process has selected for downstream processing. Cost groups in EBS are used during standard costing to segregate inventory valuation and to drive cost rollup logic across organizations. A temporary list of those groups allows a concurrent program or report to iterate over a caller-defined subset — commonly one specific cost group or a filtered range — without persisting that selection permanently.

Under the heuristic Data Vault classification derived from the foreign-key structure, this table is tagged as standalone. In Data Vault modeling terms, such a profile is typically associated with a satellite (or, more loosely, a technical staging structure) rather than a hub or a link, because the object carries limited descriptive payload and exists to serve a process rather than to represent an enduring business entity. Because it lacks a composite key relationship to multiple parents, it should not be modeled as a link table. Treat this as a modeling suggestion rather than a definitive architectural ruling.

Key Information Stored

The documented 12.2.2 physical schema for this object records a single column:

• COST_GROUP_ID — the identifier of a cost group. It is the only documented column, and it is explicitly modeled as a foreign key referencing CST_COST_GROUPS, the cost group master. This is the business-key candidate in the table: values correspond to rows in the cost group definition, and the column is meaningful only in relation to that parent. Because Table: CST_CG_LIST_TEMP is a temporary list, the pairs or sequences of cost group identifiers it accumulates are deleted or truncated by the calling process once reporting completes.

No surrogate primary key, unique index, or additional descriptive column is documented in the ETRM metadata. The absence of a non-key payload column is consistent with the classification of this object as a process-support structure: it functions as a set membership list rather than an entity with attributes of its own. Readers building integrations or data lineage maps should assume the row set is non-durable and must not be treated as a system of record.

Common Use Cases and Queries

The primary use case is cost reporting over a restricted set of cost groups. A typical pattern is to resolve the temporary list back to its master definition:

• Joining CST_CG_LIST_TEMP to CST_COST_GROUPS on COST_GROUP_ID to retrieve cost group names, descriptions, and organization context for a report run.
• Filtering cost rollup or inventory valuation queries by the membership set held in the temporary table, e.g. SELECT ... FROM cst_cost_groups cg WHERE cg.cost_group_id IN (SELECT cost_group_id FROM cst_cg_list_temp).
• Diagnosing a hanging or failed concurrent request by inspecting which cost groups were staged before the process aborted.
• Validating completeness of a reporting run by comparing the count of staged identifiers against the expected cost groups for an inventory organization.

Because the table is temporary, any query should be scoped to the currently active process and must not assume row persistence across sessions. Reports should not be built to read this table directly as a fixed source; it is expected to be populated and consumed within a single program invocation.

Related Objects

• CST_COST_GROUPS — the master cost group definition. CST_CG_LIST_TEMP.COST_GROUP_ID is documented as a foreign key to this table; this is the primary join path.
• CST_COST_GROUP_ACCOUNTS — maintains the account mappings associated with each cost group, useful when a report requires valuation accounts alongside the staged groups.
• CST_COST_GROUP_RELATIONS — relates cost groups to organizations and category structures, supporting organization-scoped reporting.
• MTL_SYSTEM_ITEMS_B — item master; items are associated to cost groups and are the typical subject of cost reports driven by a staged group list.
• CST_ITEM_COST_DETAILS — item cost layers, frequently reported within the restriction of a cost group set.
• CST_ITEM_COSTS — summarized item cost information used in valuation and rollup reporting.
• BOM concurrent programs and reports — the cost reporting programs in the BOM and CST products that populate and consume this temporary table during execution.