Results for “ap_tax_codes_val_v”

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

Overview

AP_TAX_CODES_VAL_V is a Payables (AP) validation view exposed within the Oracle E-Business Suite data dictionary. Per the documented metadata, it is flagged "(Release 10SC Only)," indicating that its definition originates from a legacy release and is retained for backward compatibility rather than for active use in EBS 12.1.1 or 12.2.2. The view presents a filtered, value-oriented list of tax codes by exposing the tax code name, its associated tax rate, and the internal tax identifier. Its purpose is to support list-of-values (LOV) population and validation lookups, allowing forms and integrations to resolve a tax code name selected by a user into the corresponding TAX_ID and rate.

The metadata explicitly records that the view is "Not implemented in this database." In EBS 12.1.1 and 12.2.2 environments this typically means the view is not deployed, or that it appears in the dictionary as a historical artifact without a live underlying definition. Consultants should confirm presence and definition against the target instance rather than assuming availability based on the ETRM record alone.

Underlying Base Objects

The documented base object is AP_TAX_CODES, the Payables tax code definition table. The view is a projection over that table, applying a single filter and exposing three of its columns. The full documented view text is:

• SELECT ATC.NAME NAME, ATC.TAX_RATE TAX_RATE, ATC.TAX_ID TAX_ID FROM AP_TAX_CODES ATC WHERE NVL(ATC.ENABLED_FLAG, 'Y') = 'Y'

The WHERE clause restricts output to enabled tax codes. Because the predicate uses NVL against a default of 'Y', records where ENABLED_FLAG is NULL are treated as enabled and included; only rows explicitly set to a value other than 'Y' are excluded. The ETRM "referenced base objects" field is documented as "none documented," so AP_TAX_CODES is identified from the view text rather than from a formal dependency listing.

Key Columns

• NAME — The tax code name sourced from AP_TAX_CODES.NAME. This is the user-facing identifier displayed in lists of values and selected on transaction lines.
• TAX_RATE — The rate associated with the tax code, sourced from AP_TAX_CODES.TAX_RATE. It represents the percentage applied when the tax code is used on an invoice or distribution.
• TAX_ID — The internal surrogate key from AP_TAX_CODES.TAX_ID. This is the value stored on transactional tables and used for joins back to the tax code definition.

Common Use Cases and Queries

The principal application is resolving a tax code name to its identifier and rate during validation or data migration. A representative query against a release where the view exists is:

• SELECT NAME, TAX_RATE, TAX_ID FROM AP_TAX_CODES_VAL_V WHERE NAME = :tax_code_name;
• SELECT TAX_ID, TAX_RATE FROM AP_TAX_CODES_VAL_V ORDER BY NAME;

Note on the originating search ("tax code A6 update sap"): this object relates exclusively to Oracle Payables and has no connection to SAP. Updates to a tax code such as A6 would be performed against AP_TAX_CODES (via the Payables Tax Codes form), not against this read-only view. Because the ETRM entry states this view is not implemented in the current database, equivalent results in 12.1.1/12.2.2 should be obtained by querying AP_TAX_CODES directly with the same enabled-flag filter.

Oracle Proprietary, Confidential Information — Legal Notices apply to the source metadata.