Results for “fiscal_classification_code”

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

Overview

The JL_BR_AR_TX_FSC_CLS_ALL table resides in the JL schema, which underpins Oracle E-Business Suite's Latin America Localizations, specifically the Brazilian Accounts Receivable tax solution. Its documented purpose is to store Brazilian Tax Fiscal Classification Information, and the ETRM metadata explicitly annotates the object as "no longer used." Consequently, while the table remains VALID in the data dictionary and continues to appear in 12.1.1 and 12.2.2 instances upgraded from earlier releases, it should be treated as a legacy artifact rather than an active configuration surface.

The relationship data classifies this object as satellite-leaning under a heuristic Data Vault model. This classification is a modeling suggestion: the table describes attributes (rates, validity windows, classifications) attached to a tax category hub, rather than acting as a hub of independent business entities or a pure link between them. Its dependency on JL_BR_AR_TX_CATEG_ALL via TAX_CATEGORY_ID reinforces that satellite reading.

Key Information Stored

The table contains 13 documented columns. The most significant are summarized below.

• FISCAL_CLASSIFICATION_CODE — The Brazilian fiscal classification identifier assigned to a tax category; part of the primary key and of both unique indexes.
• TAX_CATEGORY_ID — Foreign key to JL_BR_AR_TX_CATEG_ALL, tying the classification to its AR tax category.
• END_DATE_ACTIVE — The date through which the classification is effective; participates in the primary key and the U1 unique index, enabling date-tracked (slowly changing) history.
• START_DATE_ACTIVE — The effective-from date bounding the validity window of the row.
• FSC_CLS_ID — Surrogate-style identifier that is foreign-keyed to JL_ZZ_AR_TX_FSC_CLS_ALL; it exclusively drives the U2 unique index.
• TAX_CODE — The tax code associated with the fiscal classification.
• BASE_RATE — The base rate applied to the tax classification.
• ORG_ID — The operating unit (multi-org) discriminator, foreign-keyed to the organization definition table.
• Audit columns — LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, and LAST_UPDATE_LOGIN provide standard who-column auditing.

The surrogate primary key JL_BR_AR_TX_FSC_CLS_ALL_PK is composite, comprising FISCAL_CLASSIFICATION_CODE, TAX_CATEGORY_ID, and END_DATE_ACTIVE. The business-key candidates are captured by two unique indexes: JL_BR_AR_TX_FSC_CLS_U1 on the same three columns, and JL_BR_AR_TX_FSC_CLS_U2 on FSC_CLS_ID alone, which effectively makes FSC_CLS_ID the most direct single-column lookup path.

Common Use Cases and Queries

Because the table is documented as no longer used, primary use cases are historical reporting, data migration reconciliation, and impact analysis during upgrades. A typical currency query joins the classification rows to their parent tax category:

• Extract active classifications per category: SELECT f.FISCAL_CLASSIFICATION_CODE, f.TAX_CODE, f.BASE_RATE FROM JL_BR_AR_TX_FSC_CLS_ALL f, JL_BR_AR_TX_CATEG_ALL c WHERE f.TAX_CATEGORY_ID = c.TAX_CATEGORY_ID AND TRUNC(SYSDATE) BETWEEN f.START_DATE_ACTIVE AND NVL(f.END_DATE_ACTIVE, TRUNC(SYSDATE)+1);
• Point-in-time reconstruction: constrain END_DATE_ACTIVE to a cutoff to reproduce which fiscal classification was in force for a given invoice date.
• Multi-org scoping: filter on ORG_ID to isolate classifications configured for a specific operating unit.
• Resolve legacy references: look rows up by FSC_CLS_ID to bridge to JL_ZZ_AR_TX_FSC_CLS_ALL.

Reporting should avoid treating this table as authoritative for current Brazilian tax determination; active fiscal classification behavior should be sourced from the replacement objects referenced below.

Related Objects

• JL_BR_AR_TX_CATEG_ALL — Parent AR tax category table; joined via TAX_CATEGORY_ID.
• JL_ZZ_AR_TX_FSC_CLS_ALL — Referenced through FSC_CLS_ID; the likely successor structure for fiscal classification data.
• JL_BR_AR_TX_FSC_CLS_ALL_PK — Composite primary key on FISCAL_CLASSIFICATION_CODE, TAX_CATEGORY_ID, and END_DATE_ACTIVE.
• JL_BR_AR_TX_FSC_CLS_U1 — Unique index on the business-key triple listed above.
• JL_BR_AR_TX_FSC_CLS_U2 — Unique index on FSC_CLS_ID, supporting single-column lookups.
• Organization definition table referenced by ORG_ID for operating-unit validation.

Collectively, these relationships confirm the table's role as a date-tracked satellite of the AR tax category hub, with a secondary dependency on the fiscal classification structure it historically enriched.