Results for “tax_attribute_type”

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

Overview

JL_ZZ_AR_TX_ATT_CLS_ALL is a Latin America Localizations (JL) table that stores tax condition class information for Latin American tax reporting and calculation. In Oracle EBS 12.1.1 and 12.2.2, this table acts as the definitional master for attribute classes that classify accounts receivable tax attributes, enabling country-specific tax rules (notably for Argentina, Brazil, and Mexico localizations) to resolve tax attributes correctly during transaction processing.

The table is owned by the JL schema and is documented as VALID in ETRM. Under a heuristic Data Vault classification, the table would most naturally be modeled as a hub or standalone reference entity, since the metadata shows it as "standalone" with no outgoing foreign-key relationships to other tables. The documentation does not define a dependent link or satellite relationship, so the classification is best treated as a modeling suggestion rather than an established fact.

Key Information Stored

The table contains 31 columns. The most significant are:

• ATTRIBUTE_CLASS_ID — Surrogate primary key, governed by constraint JL_ZZ_AR_TX_ATT_CLS_ALL_PK. Uniquely identifies each tax attribute class record.
• TAX_ATTR_CLASS_TYPE — Business classification type for the attribute class; part of unique index JL_ZZ_AR_TX_ATT_CLS_U1.
• TAX_ATTR_CLASS_CODE — Business code identifying the attribute class; part of unique index JL_ZZ_AR_TX_ATT_CLS_U1.
• TAX_ATTRIBUTE_TYPE — Type of tax attribute being classified; part of unique index JL_ZZ_AR_TX_ATT_CLS_U1.
• TAX_ATTRIBUTE_NAME — Business name of the tax attribute; part of unique index JL_ZZ_AR_TX_ATT_CLS_U1.
• TAX_ATTRIBUTE_VALUE — Default or assigned value associated with the tax attribute.
• TAX_CATEGORY_ID — Reference to the tax category to which the attribute class applies; part of unique index JL_ZZ_AR_TX_ATT_CLS_U1.
• ORG_ID — Operating unit identifier, enforcing multi-org data segregation; part of both unique indexes.
• ZD_EDITION_NAME — Edition identifier supporting Oracle's edition-based redefinition (EBR) in 12.2.x; part of both unique indexes.
• ENABLED_FLAG — Controls whether the attribute class is active for use in tax determination.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — Standard EBS who-columns used for auditing and concurrency.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — Descriptive flexfield (DFF) segments for locale-specific extensions.

Two unique indexes act as business-key candidates: JL_ZZ_AR_TX_ATT_CLS_U1 (TAX_ATTR_CLASS_TYPE, TAX_ATTR_CLASS_CODE, TAX_ATTRIBUTE_TYPE, TAX_ATTRIBUTE_NAME, TAX_CATEGORY_ID, ORG_ID, ZD_EDITION_NAME) and JL_ZZ_AR_TX_ATT_CLS_U2 (ATTRIBUTE_CLASS_ID, ORG_ID, ZD_EDITION_NAME).

Common Use Cases and Queries

Typical reporting scenarios include auditing active tax attribute classes by operating unit, validating configured attribute classes against tax categories, and reconciling DFF values for localization reporting.

• List enabled attribute classes for an operating unit:

  SELECT attribute_class_id, tax_attr_class_code, tax_attribute_name, tax_attribute_value
  FROM   jl.jl_zz_ar_tx_att_cls_all
  WHERE  org_id = :p_org_id
  AND    enabled_flag = 'Y';

• Join to tax categories to see which attributes classify each category:

  SELECT c.tax_category_id, c.tax_attr_class_code, c.tax_attribute_name
  FROM   jl.jl_zz_ar_tx_att_cls_all c
  WHERE  c.tax_category_id = :p_category_id;

• Edition-aware query in 12.2.x:

  SELECT *
  FROM   jl.jl_zz_ar_tx_att_cls_all
  WHERE  zd_edition_name = 'SET1';

These patterns are useful for localization audits, tax configuration reviews, and migration checks when moving between 12.1.1 and 12.2.2.

Related Objects

The documented relationship data classifies this table as standalone, meaning no declared foreign keys originate from it. Related objects are therefore inferred from the localization tax model rather than explicit FK constraints:

• JL_ZZ_AR_TX_ATT_CLS_ALL (self) — via ATTRIBUTE_CLASS_ID / ORG_ID for edition-based lookups.
• ZX_TAX_CATEGORIES (or JL equivalent) — joined via TAX_CATEGORY_ID to resolve the tax category definition.
• ZX_TAX_ATTRIBUTES — logically matched on TAX_ATTRIBUTE_TYPE and TAX_ATTRIBUTE_NAME to map configured attributes.
• JL_ZZ_AR_TX_ATTRIBUTES_ALL — companion Latin tax attribute definition table, joined by attribute type and name.
• JL_ZZ_AR_TX_RULES_ALL — tax rule definitions that consume attribute class codes during calculation.
• FND_FLEX_VALUES_VL — used when ATTRIBUTE_CATEGORY and ATTRIBUTE1–15 map to DFF value sets.
• HR_OPERATING_UNITS — joined via ORG_ID for multi-org reporting.

Because the FK structure is undocumented, joins to tax and rules tables should be validated against the specific localization patch level in use.