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, andLAST_UPDATE_LOGINprovide 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_IDuniqueness. - JL_BR_AR_TX_RULES_ALL_PK – Composite primary key constraint over
TAX_RULE_LEVEL,TAX_CATEGORY_ID,CONTRIBUTOR_TYPE,CUST_TRX_TYPE_ID, andPRIORITY. - E-Business Tax tables (ZX schema) – The functional successor where Brazilian tax determination rules are now maintained.
-
Brazilian Tax Rules Information;no longer used
-
Brazilian Tax Rules Information;no longer used
-
12.2.2 DBA Data 12.2.2
-
12.2.2 DBA Data 12.2.2
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
12.2.2 DBA Data 12.2.2
-
12.1.1 FND Design Data 12.1.1
-
12.1.1 DBA Data 12.1.1
-
12.2.2 FND Design Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
12.2.2 DBA Data 12.2.2
-
eTRM - JL Tables and Views 12.1.1
Temporary Table For Inflation Adjustment Report
-
eTRM - JL Tables and Views 12.2.2
JL_ZZ_INFO_T is temporary table
-
PACKAGE BODY: APPS.AD_MORG 12.1.1
-
PACKAGE BODY: APPS.AD_MORG 12.2.2
-
eTRM - JL Tables and Views 12.2.2
JL_ZZ_INFO_T is temporary table
-
eTRM - JL Tables and Views 12.1.1
Temporary Table For Inflation Adjustment Report
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1