Results for “tax_attr_value_code”

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

Overview

JL_ZZ_AR_TX_ATT_VAL_ALL is a Latin America Localizations (JL) table that stores Latin Tax Condition Values Information within Oracle E-Business Suite 12.1.1 and 12.2.2. It resides in the JL schema and holds the attribute-value pairs that define how tax conditions are configured for Latin American tax categories, most notably the Brazilian and Argentine localization requirements delivered through the JL product family. Each row represents a single tax condition value — the concrete setting assigned to a named tax attribute within a given tax category — and serves as the configuration substrate from which downstream tax determination engines derive rates and rules.

From a Data Vault modeling perspective, the mined foreign-key structure classifies this object as hub-leaning. In other words, it behaves primarily as a hub of business keys (tax condition values) rather than as a transactional link or a purely descriptive satellite, though it also carries descriptive and audit columns. This classification should be treated as a modeling suggestion rather than a definitive design statement.

Key Information Stored

The table is documented with 30 physical columns. The most significant are:

• TAX_CATEG_ATTR_VAL_ID — the surrogate primary key (JL_ZZ_AR_TX_ATT_VAL_ALL_PK), uniquely identifying each tax condition value row.
• TAX_CATEGORY_ID — the tax category to which this attribute value belongs; a business-key component of unique index JL_ZZ_AR_TX_ATT_VAL_U1.
• TAX_ATTRIBUTE_TYPE and TAX_ATTRIBUTE_NAME — the attribute classifier and its name; both are part of the U1 business key.
• TAX_ATTRIBUTE_VALUE — the actual value assigned to the named attribute; also part of U1.
• TAX_ATTR_VALUE_CODE — a coded representation of the attribute value, used by the tax engine for internal lookups.
• DEFAULT_TO_CLASS — a flag indicating whether the attribute value defaults to a tax class.
• ORG_ID — the operating unit context; part of both unique indexes (U1 and U2), reflecting multi-org partitioning.
• ZD_EDITION_NAME — the edition indicator used by the EBS editioning/setup mechanism; part of both unique indexes.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — standard WHO audit columns.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE15 — the flexible descriptive flexfield (DFF) segment set for localization-specific extensions.

The two unique indexes distinguish the surrogate identity (U2: TAX_CATEG_ATTR_VAL_ID, ORG_ID, ZD_EDITION_NAME) from the business key (U1: TAX_CATEGORY_ID, TAX_ATTRIBUTE_TYPE, TAX_ATTRIBUTE_NAME, TAX_ATTRIBUTE_VALUE, ORG_ID, ZD_EDITION_NAME).

Common Use Cases and Queries

Typical scenarios include listing all condition values for a tax category, verifying which attribute values default to a tax class, and driving tax-rate lookups. Representative SQL:

• SELECT tax_categ_attr_val_id, tax_attribute_type, tax_attribute_name, tax_attribute_value FROM jl_zz_ar_tx_att_val_all WHERE tax_category_id = :category AND org_id = :org;
• SELECT * FROM jl_zz_ar_tx_att_val_all WHERE default_to_class = 'Y' AND org_id = :org;
• Joining to JL_ZZ_AR_TX_NAT_RAT_ALL on TAX_CATEG_ATTR_VAL_ID to resolve the natural rates tied to each condition value.

Reporting uses include tax configuration audits, migration validation across ORG_ID partitions, and reconciliation of localization setup before period close.

Related Objects

The dominant relationship is with the natural-rate table, which references this table's primary key:

• JL_ZZ_AR_TX_NAT_RAT_ALL — joins on TAX_CATEG_ATTR_VAL_ID → JL_ZZ_AR_TX_ATT_VAL_ALL.TAX_CATEG_ATTR_VAL_ID.
• JL_ZZ_AR_TX_ATT_VAL_ALL_PK — primary key index.
• JL_ZZ_AR_TX_ATT_VAL_U1 / U2 — unique business-key indexes enforcing uniqueness per ORG_ID and ZD_EDITION_NAME.
• The tax category referenced by TAX_CATEGORY_ID (JL tax category definitions) is a logical parent dependency used in query joins.

Together these objects form the configuration backbone for Latin American tax determination in EBS.