Search Results zx_fc_codes_b




Overview
Explore in AI Chat

Overview

The ZX_FC_CODES_B table is a core repository within the ZX (E-Business Tax) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. It is designed to store the hierarchical master data for various fiscal classification codes used in the tax determination engine. These codes are essential for classifying transactions, products, and document types according to country-specific tax regulations. The table's role is foundational, serving as the system of record for tax-related categorization, which E-Business Tax leverages to accurately apply the correct tax rules, rates, and reporting requirements based on the attributes of a transaction.

Key Information Stored

The table's primary entity is the fiscal classification code, with each record representing a unique node in a classification hierarchy. The key columns include CLASSIFICATION_ID, which is the primary key and unique identifier for each code. The PARENT_CLASSIFICATION_ID column establishes the hierarchical parent-child relationships between codes, enabling the creation of multi-level tax classifications. The COUNTRY_CODE, referencing FND_TERRITORIES, ties each classification hierarchy to a specific legal jurisdiction. Other critical columns store the classification type (e.g., Product Category, Transaction Business Category), the actual code value, its effective dates, and creation/modification metadata. This structure allows for the management of distinct, country-specific trees of fiscal codes.

Common Use Cases and Queries

A primary use case is the setup and maintenance of fiscal classifications during the implementation and ongoing configuration of E-Business Tax. Tax managers use this data to define how products or services are categorized for tax purposes. For reporting and analysis, common queries involve retrieving a full hierarchy of codes for a given country and type. A typical SQL pattern to find all child codes under a specific parent would be:

  • SELECT classification_code, meaning FROM zx_fc_codes_b WHERE parent_classification_id = (SELECT classification_id FROM zx_fc_codes_b WHERE classification_code = 'PARENT_CODE') ORDER BY classification_code;

Another critical use case is troubleshooting tax determination; developers may query this table to verify the codes assigned to a product or transaction category when the applied tax is unexpected.

Related Objects

The ZX_FC_CODES_B table is central to a cluster of related objects. The ZX_FC_CODES_TL table provides translated descriptions (TL stands for "Translations") for the classification codes stored in the base table, supporting multilingual implementations. The ZX_FC_CODES_DENORM_B table is a denormalized derivative designed for improved performance in hierarchical queries and tax determination logic. As indicated by the foreign keys, the table has a recursive relationship with itself via PARENT_CLASSIFICATION_ID and is linked to the standard FND_TERRITORIES table. This object is primarily accessed via the E-Business Tax public APIs and user interface (UI) for configuration, rather than through direct, unsupported database manipulation.