Search Results tax_rule_level

Overview

The JL_BR_AR_TX_RULES_ALL table is a historical data object within the Oracle E-Business Suite, specifically part of the JL (Latin America Localizations) product family. Its primary function was to store configuration rules for Brazilian tax calculations within the Accounts Receivable (AR) module. The table's design allowed for the definition of tax applicability based on a combination of transaction type, tax category, contributor type, and organizational context. Critically, the official ETRM documentation explicitly states this table is "no longer used," indicating it has been superseded by a newer tax engine or data model in current implementations of releases 12.1.1 and 12.2.2. Its presence in the database is typically for backward compatibility or data migration purposes.

Key Information Stored

The table's structure centers on defining the priority and applicability of tax categories. Its composite primary key reveals the core dimensions used for rule resolution. The TAX_RULE_LEVEL column likely defined the scope of the rule (e.g., Line or Header). The TAX_CATEGORY_ID served as a foreign key to the specific tax category being applied. The CONTRIBUTOR_TYPE column identified the tax contributor type (e.g., ICMS taxpayer). The CUST_TRX_TYPE_ID linked to the transaction type from RA_CUST_TRX_TYPES_ALL. Finally, the PRIORITY column determined the order of evaluation when multiple rules could apply. The ORG_ID column provided multi-organization support, segregating data by operating unit.

Common Use Cases and Queries

Given its deprecated status, direct operational use cases are obsolete. However, understanding its structure remains relevant for analyzing legacy data, executing historical tax reports, or supporting data migration and cleanup projects. Sample queries would typically involve joining to its referenced tables to decipher the full context of stored rules. For instance, a query to retrieve all historical tax rules for a specific operating unit might follow this pattern:

• SELECT rule.tax_rule_level, cat.name tax_category, rule.contributor_type, trx.name trx_type, rule.priority FROM jl_br_ar_tx_rules_all rule, jl_br_ar_tx_categ_all cat, ra_cust_trx_types_all trx WHERE rule.tax_category_id = cat.tax_category_id AND rule.cust_trx_type_id = trx.cust_trx_type_id AND rule.org_id = 123;

Related Objects

The table maintains defined foreign key relationships with two primary tables, which are essential for any joins when querying its data. These relationships are documented as follows:

• JL_BR_AR_TX_CATEG_ALL: The TAX_CATEGORY_ID column in JL_BR_AR_TX_RULES_ALL references this table to obtain the detailed definition of the Brazilian tax category.
• RA_CUST_TRX_TYPES_ALL: The CUST_TRX_TYPE_ID column in JL_BR_AR_TX_RULES_ALL references this standard AR table to link the tax rule to a specific transaction type.

These relationships underscore that the rules table acted as a junction, connecting transaction types from the core AR module to localized Brazilian tax categories.