Search Results ap_update_1099_awt_dists_pkg




Overview
Explore in AI Chat

Overview

AP_UPDATE_1099_AWT_DISTS_PKG is an Oracle Payables (AP) database package owned by the APPS schema. It exists to support update processing of 1099-related distribution and withholding data within the Oracle E-Business Suite payables subsystem. In Oracle EBS 12.1.1 and 12.2.2, US 1099 reporting and income tax withholding (AWT, or "Automatic Withholding Tax") intersect when suppliers are subject to withholding and the resulting distributions must be classified correctly for year-end 1099 reporting. This package provides the PL/SQL logic that maintains the linkage between invoice distributions, income tax regions, and the 1099 reporting attributes that drive the US 1099 forms and reports.

The package is classified in ETRM as an "OTHER" API, meaning it is not a public, documented integration API but rather an internal utility package invoked by other Payables processes. Its name and exposed procedures indicate a maintenance/setup role: reconciling or upgrading 1099 and withholding distribution records rather than exposing a business service to external callers.

Key Procedures and Functions

The ETRM 12.2.2 metadata documents two callable units within the package:

  • GET_INCOME_TAX_REGION — Returns the income tax region applicable to a given context. Income tax regions determine the jurisdiction-specific reporting rules used for 1099 and withholding processing. This function is used to resolve which region drives the tax/1099 attributes on invoice distributions and payments.
  • UPGRADE — Performs the core repository update: applying the resolved 1099 and withholding attributes to existing distribution records so that previously created data conforms to the current region configuration. The name suggests a data-migration or upgrade activity, consistent with the pattern of packages that patch historical data during implementation or release upgrades.

No parameter lists are documented; their signatures should be verified against the package specification in the target instance before any direct invocation.

Tables Accessed

ETRM documents the following tables accessed through APPS synonyms:

  • AP_INVOICES — Header-level invoice data, used to identify the supplier, invoice type, and other attributes that determine 1099 applicability.
  • AP_INVOICE_DISTRIBUTIONS — The distribution lines that carry the 1099 and withholding attributes being read and updated by UPGRADE.
  • AP_INVOICE_PAYMENTS — Payment records linked to invoices, needed to reconcile distributions with actual payment/withholding activity.
  • AP_SYSTEM_PARAMETERS — Payables system options, providing the operating context such as the 1099 configuration and withholding settings.
  • DUAL — Used for scalar evaluation and simple single-row queries within PL/SQL logic.

These tables constitute the standard 1099/withholding data model in Payables; the package reads configuration and invoice data and writes back corrected distribution attributes.

Usage Notes

Because this package is an internal utility rather than a public API, it is not part of the supported external integration surface. ETRM lists zero packages referencing it, indicating limited dependency exposure. In practice, packages of this class are invoked by:

  • Concurrent programs performing 1099 or withholding data maintenance and upgrades.
  • Oracle-supplied upgrade or patch scripts run during release migration (consistent with the UPGRADE procedure name).
  • Periodic maintenance processes that reconcile invoice distributions with current income tax region rules.

Direct calls from custom code are discouraged. Customers requiring 1099 or withholding configuration changes should use supported Payables setup and report flows (for example, the Supplier Income Tax and 1099 setup windows and standard 1099 reports) rather than invoking AP_UPDATE_1099_AWT_DISTS_PKG directly. Any targeted use should first be validated against the package specification in the specific 12.1.1 or 12.2.2 instance, since the ETRM metadata documents function names without signatures.