Results for “determining_factor”

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

Overview

JL_ZZ_AR_TX_CAT_ATT_ALL is a Latin America Localizations (JL) table that stores Latin Tax Category – Conditions Association information. It defines the set of attributes or conditions that qualify a given Latin American tax category, linking each condition back to a parent tax category definition. In Oracle EBS 12.1.1 and 12.2.2, this object supports the tax determination engine used by Latin American localizations, where tax categories are qualified by configurable attributes (for example, item classification, fiscal classification, or transaction characteristics) rather than by hard-coded rules.

Within the ETRM data model, the heuristic Data Vault classification for this object is satellite-leaning. The table behaves as a dependent satellite of the tax category definition: it carries descriptive condition attributes keyed to a parent business entity and is not itself a standalone business hub. Modeling exercises should treat it accordingly, with TAX_CATEGORY_ID as the link to the driving hub.

Key Information Stored

The table contains 31 documented columns. The most significant are:

• TAX_CATEG_ATTR_ID – Surrogate primary key. It is the single column of the primary key constraint JL_ZZ_AR_TX_CAT_ATT_ALL_PK.
• TAX_CATEGORY_ID – Foreign key to JL_ZZ_AR_TX_CATEG_ALL, identifying the parent tax category to which the condition belongs.
• TAX_ATTRIBUTE_TYPE and TAX_ATTRIBUTE_NAME – The attribute type and name that define the condition applied to the category.
• MANDATORY_IN_CLASS – Indicates whether the attribute is mandatory within the category class.
• DETERMINING_FACTOR – Flags whether the attribute participates in determining the applicable tax.
• GROUPING_ATTRIBUTE – Supports grouping of attributes for tax condition evaluation.
• PRIORITY_NUMBER – Controls evaluation order when multiple conditions apply.
• ORG_ID – Multi-org operating unit context.
• ZD_EDITION_NAME – Editioning column supporting Online Patching (EBR) in release 12.2.2.
• Standard WHO/audit columns: CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, and LAST_UPDATE_LOGIN.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 – DFF-enabled descriptive flexfield columns for customer extensions.

Two unique indexes are documented: JL_ZZ_AR_TX_CAT_ATT_U1 on (TAX_ATTRIBUTE_TYPE, TAX_ATTRIBUTE_NAME, TAX_CATEGORY_ID, ORG_ID, ZD_EDITION_NAME), and JL_ZZ_AR_TX_CAT_ATT_U2 on (TAX_CATEG_ATTR_ID, ORG_ID, ZD_EDITION_NAME). These represent the business-key candidates that enforce uniqueness of a condition per category and operating unit.

Common Use Cases and Queries

Typical use cases include auditing tax category configuration, reproducing tax determination logic in reports, and troubleshooting why a category qualification rule is or is not firing. A representative query joins conditions to their parent category:

• SELECT a.TAX_CATEG_ATTR_ID, a.TAX_ATTRIBUTE_TYPE, a.TAX_ATTRIBUTE_NAME, a.MANDATORY_IN_CLASS, a.DETERMINING_FACTOR, a.PRIORITY_NUMBER FROM JL_ZZ_AR_TX_CAT_ATT_ALL a WHERE a.TAX_CATEGORY_ID = :category_id ORDER BY a.PRIORITY_NUMBER;
• SELECT a.*, c.* FROM JL_ZZ_AR_TX_CAT_ATT_ALL a JOIN JL_ZZ_AR_TX_CATEG_ALL c ON c.TAX_CATEGORY_ID = a.TAX_CATEGORY_ID WHERE a.ORG_ID = :org_id;
• Reporting on determining factors, grouped by ORG_ID, to validate that each category has complete mandatory attribute coverage.
• Comparison across editions using ZD_EDITION_NAME to confirm configuration carried through an Online Patching cycle.

Related Objects

The table's dependencies center on the tax category hierarchy maintained by Latin American Localizations:

• JL_ZZ_AR_TX_CATEG_ALL – Parent tax category definitions; joined on TAX_CATEGORY_ID. This is the sole documented foreign key target.
• JL_ZZ_AR_TX_CAT_ATT_ALL_PK – Primary key constraint on TAX_CATEG_ATTR_ID.
• JL_ZZ_AR_TX_CAT_ATT_U1 / U2 – Unique indexes enforcing condition uniqueness within a category and operating unit.
• JL_ZZ_AR_TX_CATEG_B and JL_ZZ_AR_TX_CATEG_TL – Base and translation tables for tax categories in EBS 12.2.2.
• JL_ZZ_AR_TX_RULES_ALL / tax rule structures – Consume determining factors and priorities for tax calculation.
• ZX (E-Business Tax) repositories – Downstream consumers of JL tax category configuration for Latin American tax regimes.

Because the table is dependent and localized, direct DML should be avoided; configuration is normally performed through the Latin American tax setup UI, with changes propagated to dependent tax determination repositories.