Search Results cst_ap_variance_lines




Overview
Explore in AI Chat

Overview

CST_AP_VARIANCE_LINES is a transactional detail table owned by the BOM schema within Oracle E-Business Suite. It stores the variance information detail associated with a purchase order distribution and each batch run executed during the cost variance processing cycle. The table functions as the line-level counterpart to CST_AP_VARIANCE_HEADERS, capturing the quantified variance between the invoiced price and the purchase order price at the granularity of an individual distribution line and cost group.

The object is classified in the BOM product family, though its presence in the cost management data flow means it is populated by the cost processing programs that reconcile Accounts Payable invoice distributions against purchase order receipts and inventory valuations. Each row represents a single variance measurement attributable to a specific batch execution, enabling traceability from a summarized variance header down to the originating AP invoice distribution and PO distribution.

Following the heuristic Data Vault classification derived from its foreign key structure, CST_AP_VARIANCE_LINES is best modeled as a link table. It does not function as a standalone hub of business entities; rather, it resolves the many-to-many relationships among variance headers, variance batches, purchase order distributions, and cost groups, while carrying descriptive variance amounts and audit attributes alongside those associations.

Key Information Stored

The primary key is the composite key CST_AP_VARIANCE_LINES_PK, defined over VARIANCE_HEADER_ID and VARIANCE_LINE_ID. A unique index, CST_AP_VARIANCE_LINES_U1, mirrors this same column pair, confirming it as the business-key candidate that guarantees one row per variance line within a header. The documented schema contains 23 columns; the most significant are summarized below.

Common Use Cases and Queries

Typical usage centers on variance reporting, AP-to-receipt reconciliation, and audit of cost processing batches. A common query joins lines to their headers to report total variance by organization:

SELECT l.VARIANCE_HEADER_ID,
       l.PO_DISTRIBUTION_ID,
       l.INVOICE_PRICE_VARIANCE,
       l.VAR_AMOUNT,
       l.ORGANIZATION_ID
FROM   BOM.CST_AP_VARIANCE_LINES l
WHERE  l.ORGANIZATION_ID = :org_id
AND    l.CREATION_DATE >= :from_date;

Reconciliation scenarios join PO_DISTRIBUTION_ID to PO_DISTRIBUTIONS_ALL and INVOICE_DISTRIBUTION_ID to the AP distribution tables to trace a variance back to its source transaction. Batch-oriented analysis filters on BATCH_ID to examine all variances produced during a single run and correlates them with CST_AP_VARIANCE_BATCHES. Cost group rollups aggregate VAR_AMOUNT grouped by COST_GROUP_ID. Concurrent program diagnostics query REQUEST_ID and PROGRAM_ID to determine which process populated a given set of lines.

Related Objects

  • CST_AP_VARIANCE_HEADERS — Parent table joined on VARIANCE_HEADER_ID; holds the summarized variance record.
  • CST_AP_VARIANCE_BATCHES — Joined on BATCH_ID; defines the batch run that generated the line.
  • PO_DISTRIBUTIONS_ALL — Joined on PO_DISTRIBUTION_ID; source purchase order distribution for the variance.
  • CST_COST_GROUPS — Joined on COST_GROUP_ID; provides cost group classification.
  • AP invoice distribution tables — Referenced via INVOICE_DISTRIBUTION_ID and INVOICE_ID for AP reconciliation.
  • INVENTORY_ITEM_ID / ORGANIZATION_ID references — Link to item and organization master data for reporting context.