Results for “actual_qty”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

CST_MGD_INFL_ADJUSTED_COSTS is a cost management table owned by the BOM schema in Oracle E-Business Suite, documented in the ETRM reference for releases 12.1.1 and 12.2.2. Its documented purpose is to store inflation adjustment values. The table supports the inflation accounting and cost adjustment routines executed by Oracle Cost Management and Manufacturing, where period-end inventory balances and transaction costs are restated to reflect inflationary effects on monetary and non-monetary asset positions. Each row captures, for a given inventory item within a given organization and accounting period, the opening balance, purchasing activity, actual activity, and issue activity alongside their respective inflation adjustments and the resulting accounting entries.

Applying heuristic Data Vault modeling to the documented foreign key structure yields a satellite-leaning classification. The table is anchored by a composite that resolves to an organization, an item, and an accounting period, and it carries descriptive and quantitative measures rather than representing an independent business event or a pure association between two hubs. In Data Vault terms, ORGANIZATION_ID, INVENTORY_ITEM_ID, and ACCT_PERIOD_ID behave as the hub reference set, while the balance, cost, adjustment, and account columns are satelite attributes that change across periods.

Key Information Stored

The documented physical schema comprises 29 columns. The primary key index, CST_MGD_INFL_ADJUSTED_COSTS_PK, is defined over ORGANIZATION_ID, INVENTORY_ITEM_ID, and ACCT_PERIOD_ID. A second unique index, CST_MGD_INFL_ADJUSTED_COSTS_U1, is defined over INVENTORY_ITEM_ID, ORGANIZATION_ID, and ACCT_PERIOD_ID — the same business key in a different column order, confirming that the natural identifier of a row is the item-organization-period combination. The most significant columns are:

• ORGANIZATION_ID — the inventory organization whose cost balances are being adjusted.
• INVENTORY_ITEM_ID — the item for which the inflation-adjusted cost record is maintained.
• ACCT_PERIOD_ID — the accounting period of the adjustment; foreign key to ORG_ACCT_PERIODS.
• COUNTRY_CODE — identifies the inflationary economy or localization under which the adjustment is calculated.
• BEGIN_QTY, BEGIN_COST — opening quantity and opening cost value for the period.
• BEGIN_INFLATION_ADJ — the inflation adjustment applied to the opening balance.
• PURCHASE_QTY, PURCHASE_COST — quantity and value of receipts or purchases during the period.
• ACTUAL_QTY, ACTUAL_COST — actual (on-hand or counted) quantity and associated cost.
• ACTUAL_INFLATION_ADJ — inflation adjustment derived from the actual activity.
• ISSUE_QTY, ISSUE_COST, ISSUE_INFLATION_ADJ — issued quantity, issue cost, and the corresponding inflation adjustment.
• INVENTORY_ADJ_ACCT_CR, INVENTORY_ADJ_ACCT_DR — the inventory adjustment accounting entry references.
• MONETARY_CORR_ACCT_CR, SALES_COST_ACCT_DR — the monetary correction credit and sales cost debit accounts used in the adjustment posting.
• HISTORICAL_FLAG — indicates whether the record is retained as historical data rather than an active period adjustment.

Standard WHO columns — LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — and concurrent request columns — REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE — are present and support auditability and traceability back to the generating program.

Common Use Cases and Queries

Typical reporting retrieves period-over-period inflation adjustments for an organization and item, comparing opening, purchase, actual, and issue components. A representative query joins the table to the accounting periods to obtain the period name:

SELECT c.organization_id, c.inventory_item_id, p.period_name, c.begin_qty, c.begin_cost, c.begin_inflation_adj, c.issue_inflation_adj, c.actual_inflation_adj FROM cst_mgd_infl_adjusted_costs c, org_acct_periods p WHERE c.acct_period_id = p.acct_period_id AND c.organization_id = p.organization_id AND c.organization_id = :org_id AND p.period_name = :period;

Additional scenarios include reconciling the inventory adjustment and monetary correction account postings for inflation accounting, validating that concurrent programs completed correctly by filtering on REQUEST_ID and PROGRAM_ID, and isolating current-period activity by excluding rows where HISTORICAL_FLAG is set. Analysts frequently aggregate BEGIN_COST and ISSUE_COST by country code to assess exposure in inflationary economies.

Related Objects

The documented foreign key relationship links CST_MGD_INFL_ADJUSTED_COSTS.ACCT_PERIOD_ID and ORGANIZATION_ID to ORG_ACCT_PERIODS, which supplies the accounting period definition and organization context. Because the table references inventory items and organizations, it is also dependent on the master item and organization definitions maintained in MTL_SYSTEM_ITEMS_B and HR_ORGANIZATION_UNITS (or the organization definition views exposed through inventory). Cost management reporting views and the Inflation Adjustment concurrent programs in Cost Management read from this table to produce period close adjustments. The unique index CST_MGD_INFL_ADJUSTED_COSTS_U1 provides the primary access path for item-organization-period lookups, while the composite primary key index supports organization-scoped period reporting.