Results for “jl_br_ar_tx_rules_all”

28 results




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

Overview

The JL_BR_AR_TX_RULES_ALL table is a Brazilian Localization (JL) object within the Oracle E-Business Suite Receivables (AR) module. It is documented as storing "Brazilian Tax Rules Information," with the critical annotation that it is no longer used in the current release. The table resides in the JL schema and is marked with a status of VALID, meaning it remains physically present in the database even though Oracle has deprecated its functional role. This reflects the historical evolution of Brazilian fiscal localization, where tax rule configuration shifted away from this single-purpose AR construct toward the global E-Business Tax (E-BT) engine beginning with Release 12.

From a Data Vault modeling heuristic derived from its foreign-key structure, this table is best classified as a link table. It associates independent business entities—tax categories and customer transaction types—by resolving them through foreign keys, with attributes such as priority and contributor type qualifying the association. This classification is a modeling suggestion rather than an Oracle-imposed designation; it indicates the table behaved as a relationship or junction object binding tax categories to transaction types within Brazilian AR processing.

Key Information Stored

The table comprises 14 documented columns. Its surrogate primary key is RULE_ID, surfaced through the unique index JL_BR_AR_TX_RULES_U2. The business-key candidate is defined by the composite unique index JL_BR_AR_TX_RULES_U1, covering TAX_RULE_LEVEL, TAX_CATEGORY_ID, CONTRIBUTOR_TYPE, CUST_TRX_TYPE_ID, and PRIORITY, which also constitutes the documented primary key JL_BR_AR_TX_RULES_ALL_PK.

  • RULE_ID – Surrogate system identifier; the cleanest single-column key for joins.
  • TAX_RULE_LEVEL – Classifies the granularity or tier at which the tax rule applies.
  • TAX_CATEGORY_ID – Foreign key to JL_BR_AR_TX_CATEG_ALL, identifying the Brazilian tax category governed by the rule.
  • CUST_TRX_TYPE_ID – Foreign key to RA_CUST_TRX_TYPES_ALL, tying the rule to a Receivables transaction type.
  • CONTRIBUTOR_TYPE – Qualifies the contributor classification relevant to the tax determination.
  • PRIORITY – Ordering value resolving precedence when multiple rules compete for the same transaction.
  • RULE – The rule definition or expression content.
  • DESCRIPTION – Free-text description of the rule.
  • ORG_ID – Multi-org operating unit discriminator, part of the "_ALL" designation.
  • Audit columns – LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, and LAST_UPDATE_LOGIN provide standard WHO-column tracking.

Common Use Cases and Queries

Because Oracle documents this object as no longer used, its primary contemporary role is forensic and archival. Migration or upgrade assessments routinely query it to determine whether legacy Brazilian tax rule configuration must be mapped to the E-Business Tax repository. A representative query retrieves rule definitions with their linked tax categories and transaction types:

SELECT r.RULE_ID,
       r.TAX_RULE_LEVEL,
       r.PRIORITY,
       r.DESCRIPTION,
       c.TAX_CATEGORY_NAME,
       t.NAME AS TRX_TYPE_NAME
FROM   JL_BR_AR_TX_RULES_ALL r,
       JL_BR_AR_TX_CATEG_ALL  c,
       RA_CUST_TRX_TYPES_ALL  t
WHERE  r.TAX_CATEGORY_ID  = c.TAX_CATEGORY_ID
AND    r.CUST_TRX_TYPE_ID = t.CUST_TRX_TYPE_ID
AND    r.ORG_ID           = :p_org_id;

Data-cleansing scripts may also profile unused rows by operating unit or count active rule definitions per tax category to confirm deprecation before decommissioning. Auditors reviewing historical Brazilian fiscal configuration frequently extract the table alongside its ETRM metadata to document the pre-E-Business Tax rule landscape.

Related Objects

  • JL_BR_AR_TX_CATEG_ALL – Referenced through JL_BR_AR_TX_RULES_ALL.TAX_CATEGORY_ID; defines the tax categories that rules are attached to.
  • RA_CUST_TRX_TYPES_ALL – Referenced through JL_BR_AR_TX_RULES_ALL.CUST_TRX_TYPE_ID; supplies Receivables transaction types.
  • JL_BR_AR_TX_RULES_U1 / U2 – Unique indexes enforcing the business key and surrogate RULE_ID uniqueness.
  • JL_BR_AR_TX_RULES_ALL_PK – Composite primary key constraint over TAX_RULE_LEVEL, TAX_CATEGORY_ID, CONTRIBUTOR_TYPE, CUST_TRX_TYPE_ID, and PRIORITY.
  • E-Business Tax tables (ZX schema) – The functional successor where Brazilian tax determination rules are now maintained.