Fusion Reference

CST_COST_DISTRIBUTIONS

Product: CSTtransaction

Cost distribution headers — one per costed transaction event, carrying the cost org/book, item, event class, GL date, and accounting state ahead of subledger accounting

Identity

Module: Cost ManagementNot org-partitioned

Grain note

Distributions explode once per cost org-book — filter to the primary book (via the org-book association) or amounts double-count

Notes

Column-name trap: the cost org is spelled COST_ORGANIZATION_ID here, while every sibling table spells it COST_ORG_ID — same key, different name. No cost element at this level; the element grain is on the lines. ACCOUNTED_FLAG runs N → draft → final.

What the badges mean

Product: EGP: Product: the Oracle product family that owns the object — the short code Oracle's Tables and Views documentation lists as the object owner. Fusion is SaaS, so this isn't a database schema; there's no SQL path to the tables at all (see the quirks guide).
master: Data class: what the table holds — master data, transaction documents, control/configuration, interface/staging, or a documented view.
BU-striped (ORG_ID): Rows are scoped to a business unit. The column is still named ORG_ID, but in Fusion it means business unit, not the EBS operating unit — treat any migrated “operating unit” filter as suspect (see the quirks guide).
Per inventory org: Rows are scoped to an inventory organization via ORGANIZATION_ID — always pair it with INVENTORY_ITEM_ID on item-level joins (see the quirks guide).
Set / ledger / named-BU striped: Some tables stripe by a named column instead of ORG_ID: reference data set (SET_ID — see the quirks guide), ledger (LEDGER_ID on the GL journal tables), or a named business-unit column (PRC_BU_ID / REQ_BU_ID in procurement). The table page’s partition line names the column, and the generated SQL anchors on it — never treat these tables as unpartitioned.
Language-striped: The table carries a LANGUAGE column (a _TL translation table or FND_LOOKUP_VALUES) — one row per language. Filter to one LANGUAGE or a join multiplies rows.
Date-effective: This is an _F table — one row per entity per effectivity window, with EFFECTIVE_START_DATE and EFFECTIVE_END_DATE part of the key. Join without a window filter and every fact multiplies by history (see the quirks guide).
View: This is a documented convenience view, not a physical table. Extract through the BICC data store that fronts its base objects instead of assuming the view lands as-is.

Header & line

CST_COST_DISTRIBUTIONS is the header for its lines in CST_COST_DISTRIBUTION_LINES.

Extract access

The delivered surfaces that reach this table — the BICC extract data store (PVO) for bulk extraction and the OTBI subject areas for real-time queries. There is no SQL path to the SaaS database.

FscmTopModelAM.ScmExtractAM.CstBiccExtractAM.CostDistributionsExtractPVO
OTBI: Costing - Cost Accounting Real Time
Cost Distributions (header) data store — keyed on DistributionId.
Oracle data-store documentation (opens in new tab)

Fields

14 fields · 1 key

14 fields.

Table fields: position, field name, description, data type, and flags. 14 fields.
#	Field	Description	Type	Flags
1	DISTRIBUTION_ID	Surrogate key of the distribution header	NUMBER	Key
2	COST_ORGANIZATION_ID	The cost org — spelled COST_ORGANIZATION_ID here, COST_ORG_ID everywhere else	NUMBER
3	COST_BOOK_ID	Cost book — filter to the primary book or amounts double-count	NUMBER
4	INVENTORY_ITEM_ID	Item on the transaction	NUMBER
5	TRANSACTION_ID	The costing transaction distributed	NUMBER
6	EVENT_CLASS_CODE	Subledger accounting event class	VARCHAR2
7	EVENT_TYPE_CODE	Subledger accounting event type	VARCHAR2
8	COST_TRANSACTION_TYPE	Issue, receipt, or adjustment	VARCHAR2
9	GL_DATE	Accounting date	DATE	Filter date
10	BASE_CURRENCY_CODE	Legal entity base currency	VARCHAR2
11	LEGAL_ENTITY_ID	Legal entity of the cost org	NUMBER
12	LEDGER_ID	Ledger of the org-book	NUMBER
13	PERIOD_NAME	Costed period (periodic average books)	VARCHAR2
14	ACCOUNTED_FLAG	N, draft, or final accounting state	VARCHAR2

Field provenance: hand-curated. 1 key field.

Boilerplate SQL

Starting point for reading the BICC-landed copy of CST_COST_DISTRIBUTIONS on Databricks — real DATE columns need no conversion, and the org anchor and the LAST_UPDATE_DATE watermark (the column incremental BICC extracts key on) are already in place. Set your Unity Catalog location, schema, and org values below; they’re substituted into the SQL and the copy button.

Query parameters

CatalogSchemaDistribution IDDate from (yyyy-mm-dd)Date to (yyyy-mm-dd)watermark

Include optional filters (4)

6 parameters not filled: <catalog>, <schema>, <DISTRIBUTION_ID>, <DATE_FROM>, <DATE_TO>, <watermark>

-- ============================================================
-- Table  : CST_COST_DISTRIBUTIONS — Cost distribution headers — one per costed transaction event, carrying the cost org/book, item, event class, GL date, and accounting state ahead of subledger accounting
-- Purpose: Column-selected read of CST_COST_DISTRIBUTIONS — auto-generated from field metadata
-- Grain  : One row per DISTRIBUTION_ID
-- Caution: Distributions explode once per cost org-book — filter to the primary book (via the org-book association) or amounts double-count
-- Notes  : Auto-generated skeleton for Oracle Fusion Cloud data landed in your lakehouse by a BICC extract — there is no SQL path to the SaaS database. Column names follow Oracle's table documentation — if your landed data still carries PVO attribute headers, map names first; see quirks #pvo-drift. Dates are real DATE/TIMESTAMP columns — no conversion needed. WHO audit columns omitted (see the quirks guide); the optional LAST_UPDATE_DATE watermark filter supports incremental extracts.
-- ============================================================
SELECT
  t.DISTRIBUTION_ID AS "Surrogate key of the distribution header",
  t.COST_ORGANIZATION_ID AS "The cost org — spelled COST_ORGANIZATION_ID here, COST_ORG_ID everywhere else",
  t.COST_BOOK_ID AS "Cost book — filter to the primary book or amounts double-count",
  t.INVENTORY_ITEM_ID AS "Item on the transaction",
  t.TRANSACTION_ID AS "The costing transaction distributed",
  t.EVENT_CLASS_CODE AS "Subledger accounting event class",
  t.EVENT_TYPE_CODE AS "Subledger accounting event type",
  t.COST_TRANSACTION_TYPE AS "Issue, receipt, or adjustment",
  t.GL_DATE AS "Accounting date",
  t.BASE_CURRENCY_CODE AS "Legal entity base currency",
  t.LEGAL_ENTITY_ID AS "Legal entity of the cost org",
  t.LEDGER_ID AS "Ledger of the org-book",
  t.PERIOD_NAME AS "Costed period (periodic average books)",
  t.ACCOUNTED_FLAG AS "N, draft, or final accounting state"
FROM <catalog>.<schema>.CST_COST_DISTRIBUTIONS t
WHERE
  1 = 1  -- no automatic partition anchor on this table; the filters below are optional
  -- AND t.DISTRIBUTION_ID = <DISTRIBUTION_ID>
  -- AND t.GL_DATE >= DATE '<DATE_FROM>'
  -- AND t.GL_DATE <= DATE '<DATE_TO>'
  -- AND t.LAST_UPDATE_DATE >= TIMESTAMP '<watermark>'  -- the column incremental BICC extracts key on
ORDER BY t.DISTRIBUTION_ID;

Verified September 2026 · docs release 26C

Column names differ in BICC extracts — see PVO header drift.

Relationships

Diagram of 1-hop neighbors — join details below. FND lookup decode and translation edges are highlighted; they’re the joins newcomers most often get wrong.

Join details

CST_COST_DISTRIBUTIONSCST_TRANSACTIONSforeign key · N:1
ON CST_COST_DISTRIBUTIONS.TRANSACTION_ID = CST_TRANSACTIONS.TRANSACTION_ID
CST_COST_DISTRIBUTIONSCST_COST_ORG_BOOKSforeign key · N:1
ON CST_COST_DISTRIBUTIONS.COST_ORGANIZATION_ID = CST_COST_ORG_BOOKS.COST_ORG_ID AND CST_COST_DISTRIBUTIONS.COST_BOOK_ID = CST_COST_ORG_BOOKS.COST_BOOK_ID
CST_COST_DISTRIBUTIONSGL_LEDGERSforeign key · N:1
ON CST_COST_DISTRIBUTIONS.LEDGER_ID = GL_LEDGERS.LEDGER_ID
CST_COST_DISTRIBUTIONSCST_COST_DISTRIBUTION_LINESheader line · 1:N
ON CST_COST_DISTRIBUTIONS.DISTRIBUTION_ID = CST_COST_DISTRIBUTION_LINES.DISTRIBUTION_ID

Browse more Cost Management tables