Search Results jl_br_ar_tx_fsc_cls_all_pk

Overview

The table JL_BR_AR_TX_FSC_CLS_ALL is a legacy data object within the Oracle E-Business Suite, specifically part of the JL (Latin America Localizations) product module. Its primary purpose was to store Brazilian tax fiscal classification information, linking specific fiscal classification codes to tax categories within a multi-organization (multi-org) enabled environment, as indicated by the "_ALL" suffix. A critical piece of documented metadata is its explicit status description: "no longer used." This indicates the table is a historical artifact, likely superseded by other localization features or tables in current implementations of Oracle EBS 12.1.1 and 12.2.2. Its role was to support the configuration and validation of tax rules according to Brazilian fiscal requirements.

Key Information Stored

The table's structure centers on defining a relationship between a fiscal classification and a tax category, with validity dates. The primary key is a composite of three columns, ensuring uniqueness for a given organizational context. The most significant columns include:

• FISCAL_CLASSIFICATION_CODE: A code representing a specific Brazilian fiscal classification.
• TAX_CATEGORY_ID: A foreign key identifier linking to a tax category defined in the JL_BR_AR_TX_CATEG_ALL table.
• END_DATE_ACTIVE: Part of the primary key, this column manages the effective dating of the fiscal classification-to-tax-category mapping, allowing rules to be expired or made future-dated.
• ORG_ID: The multi-org identifier specifying the operating unit for which the tax classification rule is defined.

Common Use Cases and Queries

Given its documented status as "no longer used," direct operational or reporting use cases in active systems are improbable. Its primary historical use case was to support tax determination logic for Brazilian transactions by providing a lookup between a product's fiscal classification and the applicable tax category. In a legacy data migration or audit scenario, one might query the table to understand historical tax setups. A sample query to retrieve all active mappings for a specific operating unit would be:

SELECT fiscal_classification_code, tax_category_id FROM jl_br_ar_tx_fsc_cls_all WHERE org_id = :org_id AND (end_date_active IS NULL OR end_date_active >= SYSDATE);

Analysts might also join this table to the tax category table to generate a legacy setup report before transitioning to a new tax configuration model.

Related Objects

The documented foreign key relationships explicitly define this table's dependencies within the Brazilian localization schema. The key related objects are:

• JL_BR_AR_TX_CATEG_ALL: This is the primary related table. The foreign key from JL_BR_AR_TX_FSC_CLS_ALL.TAX_CATEGORY_ID references JL_BR_AR_TX_CATEG_ALL, establishing that every fiscal classification must be associated with a valid, pre-defined tax category.
• JL_BR_AR_TX_FSC_CLS_ALL_PK: The primary key constraint on the composite columns (FISCAL_CLASSIFICATION_CODE, TAX_CATEGORY_ID, END_DATE_ACTIVE) enforces the uniqueness of the fiscal classification mapping over time.

The relationship with JL_BR_AR_TX_CATEG_ALL via the TAX_CATEGORY_ID and ORG_ID columns is fundamental, as the tax category table holds the definitive tax rates and rules applied to transactions.