Search Results jl_br_ar_tx_categ_all




Overview
Explore in AI Chat

Overview

The table JL_BR_AR_TX_CATEG_ALL is a legacy data object within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically part of the JL (Latin America Localizations) product module. Its primary purpose was to store master data for Brazilian tax categories, a critical component for configuring and calculating indirect taxes in compliance with Brazilian fiscal regulations. As explicitly noted in the official ETRM documentation, this table is "no longer used." This status indicates that while the table structure may still exist in the database for historical or upgrade compatibility reasons, its business logic has been superseded by newer tax configuration frameworks within the localization. Its role has been deprecated, and it should not be referenced for new development or configuration.

Key Information Stored

Based on the provided metadata, the table's structure is defined by a composite primary key and a self-referencing foreign key. The primary key is JL_BR_AR_TX_CATEG_ALL_PK, composed of the columns TAX_CATEGORY_ID and ORG_ID. This design enforces uniqueness of a tax category identifier within a specific operating unit (ORG_ID), a standard EBS multi-org architecture pattern. A significant column is TAX_CATEG_TO_REDUCE_ID, which, along with ORG_ID, forms a foreign key back to the table's own primary key. This suggests the table supported hierarchical tax category relationships, allowing one category to reference another for purposes like tax reduction or credit calculations. While specific descriptive columns (e.g., name, code) are not listed in the excerpt, the table's core function was to act as a repository for these tax category definitions.

Common Use Cases and Queries

Given its deprecated status, there are no active implementation use cases for this table. Its presence is primarily of interest for historical data analysis, data migration validation, or understanding the evolution of the Brazilian tax localization. Technical consultants or DBAs might query it to audit legacy data or ensure no active processes inadvertently reference it. A sample query to retrieve all remaining records, joined to its self-reference for hierarchy, would be:

  • SELECT cat.TAX_CATEGORY_ID, cat.ORG_ID, cat.TAX_CATEG_TO_REDUCE_ID, red.NAME AS REDUCTION_CATEGORY_NAME FROM JL.JL_BR_AR_TX_CATEG_ALL cat LEFT JOIN JL.JL_BR_AR_TX_CATEG_ALL red ON cat.TAX_CATEG_TO_REDUCE_ID = red.TAX_CATEGORY_ID AND cat.ORG_ID = red.ORG_ID WHERE cat.ORG_ID = :p_org_id;

Reporting on this table is not a standard business practice, as its data is considered obsolete within the application's current tax engine.

Related Objects

The ETRM documentation outlines several foreign key relationships, indicating this table was once central to the Brazilian tax configuration. The following tables reference JL_BR_AR_TX_CATEG_ALL, primarily joining on the TAX_CATEGORY_ID and ORG_ID columns:

The self-referencing foreign key on TAX_CATEG_TO_REDUCE_ID and ORG_ID is also documented. These relationships confirm the table's historical role as a master data source for various Brazilian tax configuration entities.