Results for “arbv_ar_tax_groups”

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

Overview

ARBV_AR_TAX_GROUPS is a read-only Oracle EBS Receivables (AR) view that exposes tax group definitions configured for use during transaction entry and tax calculation. It is a retrofitted "BV" (business view) object, meaning it was added in later releases to surface tax group data through a simplified, functionally-oriented interface than the underlying tax setup tables. Organizations use this view to report on the tax groups available for a given operating unit, to validate that tax group assignments reference valid and currently effective configuration, and to feed downstream integration or data-warehouse processes that need a flattened list of tax groups without navigating the full tax model.

The view becomes relevant to any query searching on tax_group_id: it is the column exposed here as TAX_GROUP_ID. In practice the value is sourced from the underlying VAT tax identifier, so the same surrogate key identifies both the tax group in this view and its tax-family definition used elsewhere in the tax engine.

Underlying Base Objects

The documented view text is straightforward. ARBV_AR_TAX_GROUPS is defined over a single base object, AR_VAT_TAX_ALL_VL, the validated, multi-org, translated view of VAT tax and tax-group setups. The definition applies three filters:

• A type restriction: VT.TAX_TYPE = 'TAX_GROUP', so only tax group records are returned, not individual taxes or tax rates.
• A security predicate: '_SEC:VT.ORG_ID' IS NOT NULL, which is the standard EBS row-level security substitution applied to ORG_ID, limiting results to the operating unit(s) the querying responsibility is authorized for.
• A read-only clause, WITH READ ONLY, preventing DML through the view.

The columns are aliased from the VAT view: VAT_TAX_ID, TAX_CODE, PRINTED_TAX_NAME, DESCRIPTION, START_DATE, END_DATE, and the WHO audit columns are all carried forward, with the display names in the view mapping them to TAX_GROUP_ID, TAX_GROUP_CODE, TAX_GROUP_NAME, TAX_GROUP_DESCRIPTION, START_EFFECTIVE_DATE, and END_EFFECTIVE_DATE. The metadata documents no additional referenced base objects, so AR_VAT_TAX_ALL_VL and its own underlying tax setup tables are the authoritative source for the data returned here.

Key Columns

• TAX_GROUP_ID — Surrogate key for the tax group; the primary join key back to tax configuration tables and the column most commonly used in WHERE clauses.
• TAX_GROUP_CODE — Alphanumeric code identifying the group (mapped from TAX_CODE).
• TAX_GROUP_NAME — Printed name used on documents (mapped from PRINTED_TAX_NAME).
• TAX_GROUP_DESCRIPTION — Free-text description of the group's purpose.
• START_EFFECTIVE_DATE / END_EFFECTIVE_DATE — Active date range; an END_EFFECTIVE_DATE of null or a future date indicates a currently usable group.
• ORG_ID — Operating unit that owns the definition; the enforced security dimension.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY — Standard WHO audit columns for change tracking.

Common Use Cases and Queries

Typical scenarios include listing active tax groups for the current operating unit, validating a tax group referenced by an application, and reconciling tax group setup across operating units.

SELECT tax_group_id, tax_group_code, tax_group_name,
       start_effective_date, end_effective_date
  FROM arbv_ar_tax_groups
 WHERE (end_effective_date IS NULL OR end_effective_date >= SYSDATE)
 ORDER BY tax_group_name;

To resolve a specific tax_group_id discovered on a transaction line:

SELECT tax_group_code, tax_group_name, org_id
  FROM arbv_ar_tax_groups
 WHERE tax_group_id = :p_tax_group_id;

Because ORG_ID is secured by the _SEC predicate, results are automatically scoped to the querying responsibility's operating units; users requiring cross-org visibility must run the query under a responsibility with the appropriate security profile. When the object is "not implemented in this database," as the ETRM metadata notes for some instances, queries must fall back to AR_VAT_TAX_ALL_VL directly using the equivalent TAX_TYPE = 'TAX_GROUP' filter.