Search Results cst_ap_variance_headers_u2

Overview

BOM.CST_AP_VARIANCE_HEADERS is a Cost Management (CST) transaction table that stores the header-level invoice price variance information computed against a purchase order distribution for each batch run of the Invoice Variance Adjustment process. In Oracle EBS 12.1.1 and 12.2.2, the object resides in the BOM schema, is stored in the APPS_TS_TX_DATA tablespace with PCTFREE 10, and holds status VALID with FND Design Data registered as BOM.CST_AP_VARIANCE_HEADERS. The table functions as the parent header for variance detail lines, capturing the aggregate variance amount that will be written back to inventory valuation for the identified item and cost group.

The heuristic Data Vault classification mined from the foreign key structure is satellite-leaning. This is a modeling suggestion rather than a physical attribute: the table records descriptive and measurable variance facts (amount, transaction date, batch context) that describe a business key formed by BATCH_ID, PO_DISTRIBUTION_ID, and COST_GROUP_ID, rather than acting as a pure hub of business entities or a pure link between them.

Key Information Stored

The primary key is the surrogate column VARIANCE_HEADER_ID, which is enforced by the unique index CST_AP_VARIANCE_HEADERS_U1. The documented business-key candidate is the composite unique index CST_AP_VARIANCE_HEADERS_U2 covering BATCH_ID, PO_DISTRIBUTION_ID, and COST_GROUP_ID, which guarantees that a given purchase order distribution is processed only once per cost group within a batch run.

• VARIANCE_HEADER_ID — surrogate primary key identifying the variance header record.
• PO_DISTRIBUTION_ID — the purchase order distribution for which invoice variance is computed; the central business reference of the row.
• BATCH_ID — identifier of the batch run that created the header, linking the row to its processing execution.
• COST_GROUP_ID — cost group identifier, populated only when the invoice option is selected at program run time.
• ORGANIZATION_ID — inventory organization in which the variance is applied.
• INVENTORY_ITEM_ID — the item whose cost is affected by the variance amount.
• VAR_AMOUNT — the invoice variance amount to be absorbed; the principal financial measure of the table.
• TRANSACTION_DATE — system-derived date used for the average cost update transaction.
• REQUEST_ID, PROGRAM_ID, PROGRAM_APPLICATION_ID, PROGRAM_UPDATE_DATE — extended Who columns identifying the concurrent request and program that generated the row.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard Who audit columns.

Common Use Cases and Queries

The table is queried primarily for invoice variance reconciliation, cost update auditing, and batch run diagnostics. A typical join returns variance headers with their detail lines for a specific batch:

• Reconcile variance by item and organization: SELECT ORGANIZATION_ID, INVENTORY_ITEM_ID, SUM(VAR_AMOUNT) FROM BOM.CST_AP_VARIANCE_HEADERS WHERE BATCH_ID = :batch GROUP BY ORGANIZATION_ID, INVENTORY_ITEM_ID;
• Trace a purchase order distribution back to its variance history: filter on PO_DISTRIBUTION_ID and order by TRANSACTION_DATE to view successive adjustments.
• Confirm uniqueness and detect duplicate processing by querying the CST_AP_VARIANCE_HEADERS_U2 key columns (BATCH_ID, PO_DISTRIBUTION_ID, COST_GROUP_ID).
• Link header and line detail: SELECT h.VARIANCE_HEADER_ID, h.VAR_AMOUNT, l.* FROM BOM.CST_AP_VARIANCE_HEADERS h, BOM.CST_AP_VARIANCE_LINES l WHERE h.VARIANCE_HEADER_ID = l.VARIANCE_HEADER_ID;

Related Objects

The dependency metadata identifies the following significant relationships:

• BOM.CST_AP_VARIANCE_BATCHES — parent of the BATCH_ID foreign key; describes the batch run that produced the header.
• BOM.CST_COST_GROUPS — parent of the COST_GROUP_ID foreign key; supplies the cost group definition.
• BOM.CST_AP_VARIANCE_LINES — child table joined on VARIANCE_HEADER_ID; holds the itemized variance detail.
• BOM.CST_AP_VARIANCE_HEADERS_EFC and BOM.CST_AP_VARIANCE_LINES_EFC — EFC (Enterprise Financials/consolidation) counterparts referencing VARIANCE_HEADER_ID, used for multi-organization or consolidated reporting scenarios.

Collectively these objects form the invoice variance processing chain from batch definition, through header and line variance capture, to consolidated representations. The header table is the pivot point for any reconciliation between the concurrent program execution and the resulting inventory cost adjustments.