Supplier & Vendor Master Health Diagnostic

Vendor master data problems in Oracle EBS are among the most pervasive and most difficult to diagnose because the vendor record spans four separate Oracle modules — the AP supplier tables, the TCA party model in HZ, the IBY payment instrument tables, and the ZX tax profile. A symptom that presents as a payment failure may have its root cause in a missing IBY bank account assignment. A symptom that presents as a 1099 reporting discrepancy may have its root cause in an incomplete ZX_PARTY_TAX_PROFILE record. The AP team sees the payment error. The Tax team sees the 1099 gap. Neither team has full visibility across the complete vendor record structure.

The most operationally damaging vendor master condition is a vendor placed on hold without a clear release path. Oracle EBS supports multiple hold types at the vendor level — AP_HOLDS_ALL records a hold on an existing invoice, but a vendor-level hold set in AP_SUPPLIERS.HOLD_FLAG blocks all future invoice entry for that vendor across every operating unit. In environments where the AP team and the Purchasing team use different forms, it is common for a vendor hold to be placed by one team and released by another — with neither team realizing the hold persists because it is stored in a different field than the one they checked.

Duplicate vendor records compound the problem. When the same supplier exists under two or more AP_SUPPLIERS records — often created because the Purchasing team created a new vendor rather than searching for the existing one — invoices accumulate against both records. 1099 reportable amounts are split between them, neither reaching the reporting threshold individually, resulting in missed filings and potential IRS penalties. Vendor merge is the correct resolution, but it requires identifying all transactions referencing both vendor IDs across AP, PO, and potentially FA and PA before the merge is executed.

AP-03 examines the complete vendor record — header status and hold flags, all vendor sites across operating units, bank account existence and active status in IBY, payment terms and pay group configuration, 1099 type and Federal Tax ID completeness, and duplicate detection by name similarity, bank account, and tax ID. It identifies every condition that will block invoice entry, payment processing, or correct tax reporting — and provides the exact resolution path for each one.