Search Results cst_ap_variance_lines_u1

Overview

BOM.CST_AP_VARIANCE_LINES is a transaction detail table in the Oracle E-Business Suite Cost Management (CST) and Bills of Material (BOM) schemas. It stores the line-level variance information generated when an Accounts Payable invoice is matched to a purchase order distribution and subsequently processed by the payables variance cost batch programs. Each row represents a single variance line for a purchase order distribution captured within a specific batch run.

The table operates in the APPS_TS_TX_DATA tablespace with a PCT Free of 10, aligning it with the transactional data tier characteristic of high-volume cost processing objects. In Oracle EBS 12.1.1 and 12.2.2, this object plays a supporting role in the invoice price variance (IPV) and inventory variance transfer flows, where amounts calculated at invoice match time must be staged, retained by batch, and ultimately transferred to Inventory or absorbed by the appropriate accounts.

From a Data Vault modeling perspective, the heuristic classification for this object is that of a link table. The presence of multiple foreign key relationships to CST_AP_VARIANCE_HEADERS, CST_AP_VARIANCE_BATCHES, PO_DISTRIBUTIONS_ALL, and CST_COST_GROUPS, combined with a composite primary key, suggests a structure that resolves relationships between parent variance headers, batch executions, PO distributions, and cost groups rather than acting as an independent hub or a purely descriptive satellite.

Key Information Stored

The table is anchored by a composite primary key, CST_AP_VARIANCE_LINES_PK, defined on VARIANCE_HEADER_ID and VARIANCE_LINE_ID. A unique index, CST_AP_VARIANCE_LINES_U1, exists on the same pair of columns and therefore serves as the documented business-key candidate. The non-unique index CST_AP_VARIANCE_LINES_N1 on BATCH_ID supports batch-oriented retrieval and purge processing.

The most significant columns include:

• VARIANCE_HEADER_ID and VARIANCE_LINE_ID — the composite primary key identifying the parent header and the line within it.
• BATCH_ID — identifies the batch run that created the record, enabling reprocessing and reconciliation by execution.
• INVOICE_DISTRIBUTION_ID, INVOICE_ID, and DISTRIBUTION_LINE_NUMBER — the AP-side references identifying the matched invoice and its distribution line.
• PO_DISTRIBUTION_ID — the purchase order distribution to which the invoice was matched.
• INVOICE_PRICE_VARIANCE and BASE_INVOICE_PRICE_VARIANCE — the invoice price variance amount in entered and base currency respectively.
• VAR_AMOUNT — the invoice variance amount eligible for transfer to Inventory.
• PROJECT_ID, ORGANIZATION_ID, INVENTORY_ITEM_ID, and COST_GROUP_ID — the project, inventory organization, item, and cost group context for the variance.
• REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, and PROGRAM_UPDATE_DATE — extended Who columns identifying the concurrent program that produced the row.

Common Use Cases and Queries

Cost accountants and technical consultants query this table to reconcile invoice price variances transferred to inventory, to investigate discrepancies by batch, and to trace AP invoice distributions back to their PO distributions. A typical query joining to the header and batch tables retrieves all lines for a given batch run:

• SELECT l.variance_header_id, l.variance_line_id, l.po_distribution_id, l.invoice_id, l.invoice_price_variance, l.var_amount FROM bom.cst_ap_variance_lines l WHERE l.batch_id = :batch_id;
• Reconciliation by invoice: filter on INVOICE_ID and INVOICE_DISTRIBUTION_ID to view all variance lines generated for a specific AP invoice.
• Organization-level analysis: group by ORGANIZATION_ID and INVENTORY_ITEM_ID to report variance absorption by item across a period.
• Cost group trending: aggregate VAR_AMOUNT by COST_GROUP_ID to review transfer activity for a cost group.
• Batch monitoring: join to CST_AP_VARIANCE_BATCHES on BATCH_ID to confirm batch completion status and row counts.

Related Objects

The table maintains documented foreign key relationships and is most frequently joined with the following objects:

• BOM.CST_AP_VARIANCE_HEADERS — joined on VARIANCE_HEADER_ID; provides header-level variance context.
• BOM.CST_AP_VARIANCE_BATCHES — joined on BATCH_ID; identifies the batch execution that created the lines.
• PO.PO_DISTRIBUTIONS_ALL — joined on PO_DISTRIBUTION_ID; supplies the matched purchase order distribution.
• BOM.CST_COST_GROUPS — joined on COST_GROUP_ID; defines the cost group for transfer processing.
• AP.AP_INVOICE_DISTRIBUTIONS_ALL — related through INVOICE_DISTRIBUTION_ID and INVOICE_ID to the AP invoice distributions.
• INV.MTL_SYSTEM_ITEMS_B and INV.MTL_PARAMETERS — joined on INVENTORY_ITEM_ID and ORGANIZATION_ID for item and organization attributes.