Case 00171076 – AP Invoice Batch Deletion — Remove Invoice, Tax Lines, Holds, and Batch Record

AP Invoice Batch Deletion — Remove Invoice, Tax Lines, Holds, and Batch Record

Case Number	00171076
Oracle Module	Accounts Payable (AP) / eBusiness Tax (ZX)
EBS Version	R12
Functional Area	Invoice Processing / Invoice Batches / Tax Lines / Invoice Holds
Related Patches	None

Symptoms

An AP invoice was incorrectly created and cannot be processed or cancelled through normal application channels.
The invoice has outstanding holds in AP_HOLDS_ALL that prevent normal release.
The invoice has tax lines in ZX_LINES and ZX_LINES_SUMMARY that need to be removed as part of the cleanup.
The invoice is associated with an AP invoice batch (AP_BATCHES_ALL) that also requires cleanup.
The invoice has a payment schedule in AP_PAYMENT_SCHEDULES_ALL.

Root Cause

An AP invoice and its associated invoice batch were incorrectly created, leaving orphaned or invalid records across the AP, ZX, and AP batch tables. The invoice cannot be processed or voided through the UI. A complete data-level deletion of the invoice record, its distributions, holds, tax lines, payment schedule, and the associated batch record is required to remove the erroneous data from the system.

Resolution

Step 1 – Create backup tables

Run data_fix.txt. Backup tables are created for:

AP_HOLDS_ALL
AP_PAYMENT_SCHEDULES_ALL
ZX_LINES_SUMMARY
ZX_LINES
AP_INVOICE_DISTRIBUTIONS_ALL
AP_INVOICES_ALL
AP_BATCHES_ALL

Step 2 – Delete associated records

Delete records from the affected tables in the following order (child records before parent records to satisfy referential integrity):

Delete from AP_HOLDS_ALL for the affected invoice.
Delete from ZX_LINES_SUMMARY for the affected tax summary line.
Delete from ZX_LINES for the affected tax line.
Delete from AP_INVOICE_DISTRIBUTIONS_ALL for the affected invoice.
Delete from AP_PAYMENT_SCHEDULES_ALL for the affected invoice.
Delete from AP_INVOICES_ALL for the affected invoice.
Delete from AP_BATCHES_ALL for the affected batch.

Step 3 – Commit and validate

Commit. Verify the invoice and batch no longer appear in the AP module.

Note: This fix script is delivered as a .txt file containing a partial action plan. The deletion step was not fully completed in the documented fix file — the order of deletions above is inferred from the backup tables created. Verify the correct deletion order and child/parent dependencies before executing in production. If the invoice has XLA accounting events, those must also be cleaned up before or after the AP record deletion.

Script Inventory

File	Description
data_fix.txt	Partial action plan (fix file is incomplete). Documents backup creation for AP_HOLDS_ALL, AP_PAYMENT_SCHEDULES_ALL, ZX_LINES_SUMMARY, ZX_LINES, AP_INVOICE_DISTRIBUTIONS_ALL, AP_INVOICES_ALL, and AP_BATCHES_ALL. Deletion step text is truncated.

Key Tables Affected

Table	Action
AP_HOLDS_ALL	Delete holds for the affected invoice
AP_PAYMENT_SCHEDULES_ALL	Delete payment schedule for the affected invoice
AP_INVOICE_DISTRIBUTIONS_ALL	Delete distributions for the affected invoice
AP_INVOICES_ALL	Delete the affected invoice record
ZX_LINES_SUMMARY	Delete tax summary line
ZX_LINES	Delete tax line
AP_BATCHES_ALL	Delete the associated invoice batch record