Symptoms

• AP invoice validation or cancellation fails for a PO-matched invoice with a tax line that has an invoice_price_variance amount but a NULL PRICE_VAR_CODE_COMBINATION_ID.
• The error or hold indicates that the price variance account is missing on the TAX distribution that is linked to a PO distribution.
• The invoice has posted_flag = 'N' and the affected distribution has LINE_TYPE_LOOKUP_CODE = 'TAX' with a non-zero invoice_price_variance.

Root Cause

When a PO-matched AP invoice has tax lines with a price variance (the tax amount differs from the PO-expected amount), the system should automatically populate PRICE_VAR_CODE_COMBINATION_ID on the TAX distribution from the PO distribution's variance_account_id. This population was omitted, leaving the column NULL and causing validation to fail when it tries to generate the IPV/TIPV accounting entry.

Identification SQL

Use the following query to identify affected distributions, substituting the invoice ID:

SELECT *
FROM ap_invoice_distributions_all id
WHERE id.posted_flag = 'N'
  AND id.PRICE_VAR_CODE_COMBINATION_ID IS NULL
  AND NVL(id.invoice_price_variance, 0) <> 0
  AND id.LINE_TYPE_LOOKUP_CODE = 'TAX'
  AND id.PO_DISTRIBUTION_ID IS NOT NULL
  AND id.invoice_id = &Invoice_ID;

Resolution

Run data_fix.sql. A backup of the affected AP_INVOICE_DISTRIBUTIONS_ALL rows is created.

Confirm the backup table row count matches the expected number of affected distributions.

Update AP_INVOICE_DISTRIBUTIONS_ALL.PRICE_VAR_CODE_COMBINATION_ID from PO_DISTRIBUTIONS_ALL.variance_account_id for the affected invoice TAX distributions joined via po_distribution_id.

Issue COMMIT. Retry invoice validation or cancellation to confirm it proceeds without the missing variance account error.

Script Inventory

Key Tables Affected