Case 00039350 – AP Invoice Lines and Distributions Zeroed with ZX Correction

AP Invoice Lines and Distributions Zeroed with ZX Determining Factor Correction

Case Number	00039350
Oracle Module	Accounts Payable (AP) / eBusiness Tax (ZX)
EBS Version	R12
Functional Area	Invoice Processing / Tax Calculation
Related Patches	None

Symptoms

An AP invoice has incorrect non-zero amounts on lines and distributions that should be zero.
The eBusiness Tax determining factor table (ZX_LINES_DET_FACTORS) has a line_amt that does not match the corrected zero value.
The invoice may fail validation or produce incorrect accounting due to the amount discrepancy between AP and ZX tables.

Root Cause

The invoice line amounts, distribution amounts, and the corresponding ZX tax determining factor line amount contain stale non-zero values that should be zero. This can occur when a cancellation, adjustment, or correction process did not complete cleanly, leaving residual amounts in the AP and ZX tables.

Resolution

Step 1 – Create backup tables

Run data_fix.sql. Backup tables are created for:

AP_INVOICE_LINES_ALL
AP_INVOICE_DISTRIBUTIONS_ALL
ZX_LINES_DET_FACTORS

Step 2 – Zero invoice line amounts

Update AP_INVOICE_LINES_ALL to set amount = 0 for all lines on the affected invoice.

Step 3 – Zero invoice distribution amounts

Update AP_INVOICE_DISTRIBUTIONS_ALL to set amount = 0 and total_dist_amount = 0 for all distributions on the affected invoice.

Step 4 – Zero ZX determining factor line amount

Update ZX_LINES_DET_FACTORS to set line_amt = 0 for the affected invoice's AP_INVOICES entity records.

Step 5 – Commit and validate

Issue COMMIT. Re-validate the invoice to confirm it passes with zero amounts.

Script Inventory

File	Description
data_fix.sql	Creates backups; sets AP_INVOICE_LINES_ALL amounts to 0; sets AP_INVOICE_DISTRIBUTIONS_ALL amount and total_dist_amount to 0; sets ZX_LINES_DET_FACTORS line_amt to 0.

Key Tables Affected

Table	Action
AP_INVOICE_LINES_ALL	Update amount to 0
AP_INVOICE_DISTRIBUTIONS_ALL	Update amount, total_dist_amount to 0
ZX_LINES_DET_FACTORS	Update line_amt to 0