Results for “ap_tax_codes_v”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

AP_TAX_CODES_V is a Payables (AP) view that consolidates tax code definitions used by Oracle Payables for tax calculation, withholding, and reporting. The ETRM metadata records a single authoritative description: "View: AP_TAX_CODES_V — Product: AP - Payables — Description: (Release 10SC Only)." The "(Release 10SC Only)" qualifier indicates the view originated in the Release 10 Smart Client environment and that subsequent releases re-platformed the equivalent tax code definition data.

The view's most significant functional characteristic is that it exposes withholding tax (AWT — Automatic Withholding Tax) configuration columns directly alongside standard tax code attributes. The inclusion of AWT_VENDOR_ID and AWT_VENDOR_SITE_ID identifies this view as the reporting interface for tax codes configured with vendor and vendor site level withholding rules. This is the object referenced when a user searches for "awt_vendor_site_id" in the context of Payables tax code inquiry and reporting.

The view presents a denormalized, report-friendly projection of tax code data: descriptive attributes, rate and range logic, accounting flexfield linkage, descriptive flexfield context, global descriptive flexfield segments, and audit columns are all surfaced through a single SELECT. This makes it suitable for tax code listing reports, withholding configuration audits, and integration extracts where the caller cannot or should not join the underlying tax code and AWT configuration tables directly.

Underlying Base Objects

The ETRM metadata records the referenced base objects for this view as "none documented," and the view metadata owner field is blank. The view text excerpt provided is a single-level projection over an alias ATC — every selected column is qualified as ATC.<column_name>, and the leading expression is ATC.ROWID ROW_ID. This pattern is characteristic of an Oracle EBS "view" implemented as a straight projection (potentially a synonym-backed or row-id-keyed query) rather than a multi-table join. The single-table projection means no join conditions, decode logic, or outer joins are exposed in the documented text.

Given the column naming and the "(Release 10SC Only)" designation, the underlying object is the Payables tax code definition entity. In Release 10SC the corresponding base object carries the AP_TAX_CODES naming convention. The columns AWT_PERIOD_LIMIT, AWT_PERIOD_TYPE, AWT_VENDOR_ID, and AWT_VENDOR_SITE_ID are not part of the standard tax code definition — they represent attributes added to support automatic withholding tax at the tax code level, and their presence in the view text confirms that the base object was extended (or a companion AWT configuration object joined) to persist withholding vendor and site attribution.

Because the ETRM record documents no base object explicitly, the view should be treated as an interface object whose internal definition is not guaranteed stable across release transitions. In 12.1.1 and 12.2.2, the documented implementation status is "Not implemented in this database," meaning the object is not present in the current environment and references to it will fail at parse time unless the replacement object is substituted. Practitioners migrating Release 10SC customizations, reports, or interfaces must locate the replacement tax code object in the target release rather than persisting the AP_TAX_CODES_V name.

Key Columns

The view exposes the following functionally distinct column groups. All columns retain their base object names; the view provides no renaming or transformation other than the ROWID alias.

• Identity and description: NAME, DESCRIPTION, and ROW_ID (aliased from ATC.ROWID) provide the tax code identifier and its human-readable label.
• Tax calculation attributes: TAX_TYPE, TAX_RATE, RANGE_AMOUNT_BASIS, and RANGE_PERIOD_BASIS define the tax classification and the rate or range logic applied when the code is used.
• Accounting linkage: TAX_CODE_COMBINATION_ID points to the accounting flexfield combination that receives the tax liability, and SET_OF_BOOKS_ID scopes the tax code to a ledger.
• Withholding tax configuration (AWT): AWT_VENDOR_ID, AWT_VENDOR_SITE_ID, AWT_PERIOD_LIMIT, and AWT_PERIOD_TYPE define the withholding vendor, the specific vendor site subject to withholding, the threshold amount for the withholding period, and the period basis over which the threshold is evaluated. AWT_VENDOR_SITE_ID is the column required when withholding must be tied to a particular supplier site rather than the supplier as a whole.
• Effective dating: INACTIVE_DATE marks the date after which the tax code is no longer selectable.
• Audit columns: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN provide standard EBS who/when auditing.
• Descriptive flexfield: ATTRIBUTE_CATEGORY plus ATTRIBUTE1 through ATTRIBUTE15 expose the DFF context and its segment values as configured by the customer.
• Global descriptive flexfield: GLOBAL_ATTRIBUTE_CATEGORY plus GLOBAL_ATTRIBUTE1 through GLOBAL_ATTRIBUTE15 expose localization and country-specific tax code attributes.

Common Use Cases and Queries

The primary use case is withholding tax configuration reporting — enumerating which tax codes carry supplier or supplier site level withholding rules. A secondary use case is tax code reference extraction for data migration or reconciliation between Release 10SC and later releases.

Listing active withholding tax codes with their vendor site attribution:

SELECT name,
       description,
       tax_type,
       tax_rate,
       awt_vendor_id,
       awt_vendor_site_id,
       awt_period_type,
       awt_period_limit,
       inactive_date
  FROM ap_tax_codes_v
 WHERE awt_vendor_site_id IS NOT NULL
   AND (inactive_date IS NULL OR inactive_date > SYSDATE)
 ORDER BY name;

Auditing unresolved ledger and accounting assignments:

SELECT set_of_books_id,
       tax_code_combination_id,
       COUNT(*) tax_code_count
  FROM ap_tax_codes_v
 GROUP BY set_of_books_id, tax_code_combination_id
 HAVING tax_code_combination_id IS NULL;

Because the ETRM record states the view is not implemented in the documented 12.x database, these queries are illustrative of the column contract, not of parsed execution against AP_TAX_CODES_V in 12.1.1 or 12.2.2. Any migration exercise should first confirm whether the object exists in the target instance; if it does not, the equivalent tax code and withholding attributes must be sourced from the release-appropriate tax code definition object. Where the view is absent, the AWT_VENDOR_SITE_ID reference should be remapped to the corresponding withholding vendor site column in the current data model before the SQL is deployed.