Results for “compound_precedence”

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

Overview

JL_BR_AR_TX_GROUP_ALL is a table in the JL (Latin America Localizations) product schema, part of the Oracle E-Business Suite Brazilian localization. It stores Brazilian tax group definitions used to associate tax categories with tax codes and transaction attributes for receivables tax processing. The ETRM documentation explicitly marks this object as legacy: the description states "Brazilian Tax Groups; no longer used." For that reason, the table should be treated as a historically significant, denormalized localization object that may still hold archived configuration and historical transaction tax attributes, but it is not the recommended integration point for new development on EBS 12.1.1 or 12.2.2. Its Data Vault classification is heuristic and mined from the foreign key structure: it is a link (relationship) table. It resolves many-to-many style relationships between tax category definitions and tax codes, adding descriptive attributes such as establishment type, contributor type, and transaction nature.

Key Information Stored

The primary key JL_BR_AR_TX_GROUP_ALL_PK is a composite of six columns: GROUP_TAX_ID, TAX_CATEGORY_ID, END_DATE_ACTIVE, TRANSACTION_NATURE, CONTRIBUTOR_TYPE, and ESTABLISHMENT_TYPE. Note that the unique index JL_BR_AR_TX_GROUP_U1 spans TRANSACTION_NATURE, CONTRIBUTOR_TYPE, ESTABLISHMENT_TYPE, GROUP_TAX_ID, TAX_CATEGORY_ID, and END_DATE_ACTIVE; this is a business-key candidate reflecting the same natural key with the effective end date. The most important columns include:

• GROUP_TAX_ID — foreign key to AR_VAT_TAX_ALL_B, identifying the tax code/rate definition associated with the group.
• TAX_CATEGORY_ID — foreign key to JL_BR_AR_TX_CATEG_ALL, the tax category assigned to the group.
• TAX_CATEGORY_TO_REDUCE_ID — self-referencing category used when a reduced tax base applies.
• TRANSACTION_NATURE, CONTRIBUTOR_TYPE, ESTABLISHMENT_TYPE — classification attributes that qualify when the tax group applies.
• START_DATE_ACTIVE / END_DATE_ACTIVE — effective dating for the tax group configuration.
• TAX_INCLUSIVE, TRIBUTARY_SUBSTITUTION, USED_TO_REDUCE, CALCULATE_IN_OE — tax calculation flags controlling inclusive pricing, substitute tributary treatment, base reduction, and Order Entry calculation.
• COMPOUND_PRECEDENCE, MIN_AMOUNT, MIN_PERCENTAGE — controls for compound and minimum tax application.
• TAX_CODE — internal tax code reference.
• ORG_ID — multi-org operating unit identifier.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — standard audit columns.

Common Use Cases and Queries

Because the table is documented as no longer used, primary use cases are historical reporting, tax audit reconstruction, and controlled migration away from legacy Brazilian tax group logic. A typical query joins to AR_VAT_TAX_ALL_B for the tax code and JL_BR_AR_TX_CATEG_ALL for category names, filtered by operating unit and transaction nature:

SELECT g.GROUP_TAX_ID, g.TAX_CATEGORY_ID, g.TRANSACTION_NATURE, g.ESTABLISHMENT_TYPE, g.CONTRIBUTOR_TYPE, g.START_DATE_ACTIVE, g.END_DATE_ACTIVE
FROM JL.JL_BR_AR_TX_GROUP_ALL g
WHERE g.ORG_ID = :org_id
AND :as_of_date BETWEEN g.START_DATE_ACTIVE AND NVL(g.END_DATE_ACTIVE, :as_of_date);

Patterns include as-of-date tax group analysis, identifying rows with TAX_INCLUSIVE or TRIBUTARY_SUBSTITUTION flags set for review, and reconciling GROUP_TAX_ID values against AR_VAT_TAX_ALL_B to detect orphaned configuration prior to decommissioning. Reporting should filter by ORG_ID and respect effective dating because both the primary key and unique index include END_DATE_ACTIVE.

Related Objects

The most significant related objects, derived from the documented foreign key relationships, are:

• AR_VAT_TAX_ALL_B — joined via GROUP_TAX_ID to obtain tax code and rate definitions (this table also references JL_BR_AR_TX_GROUP_ALL through its own foreign keys).
• JL_BR_AR_TX_CATEG_ALL — joined via TAX_CATEGORY_ID for the primary tax category definition.
• JL_BR_AR_TX_CATEG_ALL — joined via TAX_CATEGORY_TO_REDUCE_ID to identify the category used for reduced-tax-base scenarios.

Applications and localization concurrent programs that previously consumed this table should be reviewed for replacement by supported Brazilian receivables tax functionality in 12.1.1 and 12.2.2, while retaining the table for historical and archival query access.