Search Results jl_br_ar_tx_exc_fsc_all




Overview
Explore in AI Chat

Overview

The table JL_BR_AR_TX_EXC_FSC_ALL is a data object within the Oracle E-Business Suite, specifically part of the JL (Latin America Localizations) product module. Its primary purpose was to store configuration data for Brazilian tax exceptions based on fiscal classification. This table enabled the localization to define specific tax rules that would override standard calculations based on combinations of shipping locations, fiscal classification codes, and tax categories. However, as explicitly noted in the official ETRM documentation, this table is flagged as "no longer used." This status indicates it is likely a legacy artifact from a previous implementation of Brazilian tax logic within the localization, and its business rules may have been superseded by other tables or application features in releases 12.1.1 and 12.2.2.

Key Information Stored

The table's structure centers on defining the parameters for a tax exception rule. Its primary key is a composite of five columns, ensuring uniqueness for each rule definition. The critical columns include SHIP_FROM_CODE and SHIP_TO_SEGMENT_ID, which identify the shipping origin and destination locations involved in the transaction. The FISCAL_CLASSIFICATION_CODE represents the specific fiscal classification of an item. The TAX_CATEGORY_ID links to the applicable tax category. Finally, the END_DATE_ACTIVE column allows for the temporal control of the exception rule, enabling it to be expired. The inclusion of ORG_ID signifies the table is multi-organization enabled, storing data for multiple operating units.

Common Use Cases and Queries

Given its documented status as "no longer used," direct operational or reporting use cases against this table in active implementations are improbable. Its primary historical use case would have been to query for active tax exception rules applicable to a specific sales order or invoice line. A sample analytical query to audit legacy data might follow this pattern:

  • SELECT exc.ship_from_code, exc.ship_to_segment_id, exc.fiscal_classification_code, exc.tax_category_id, exc.end_date_active FROM jl_br_ar_tx_exc_fsc_all exc WHERE exc.org_id = :p_org_id AND (exc.end_date_active IS NULL OR exc.end_date_active >= SYSDATE);

In current practice, technical consultants or DBAs might query this table only during data migration audits, system health checks, or while analyzing the impact of customizations that may still reference this legacy object.

Related Objects

Based on the provided foreign key metadata, JL_BR_AR_TX_EXC_FSC_ALL has documented relationships with two other tables. These relationships are key to understanding its intended role in the data model before it was deprecated.

  • AR_LOCATION_VALUES_OLD: The SHIP_TO_SEGMENT_ID column in JL_BR_AR_TX_EXC_FSC_ALL references this table. This links the tax exception to a specific customer location or address.
  • JL_BR_AR_TX_CATEG_ALL: The TAX_CATEGORY_ID column in JL_BR_AR_TX_EXC_FSC_ALL references this table. This links the exception rule to a defined Brazilian tax category, which holds the core tax rate and type information.

The reference to AR_LOCATION_VALUES_OLD, which itself appears to be a legacy object, further supports the historical nature of this table's function within the application.