Search Results zx_fc_types_b

Overview

The ZX_FC_TYPES_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 serves as the master definition table for fiscal classification types across all classification categories. In the context of E-Business Tax, fiscal classifications are critical for determining the correct tax treatment of transactions, items, and parties based on regulatory requirements (e.g., HTS codes, NCM codes, or other statutory product classifications). This table stores the distinct types of classifications that can be assigned, effectively defining the valid "code sets" or "schemes" (like "HARMONIZED_TARIFF" or "PRODUCT_CATEGORY") that are available for use within the system. Its role is foundational, as it provides the metadata that governs how detailed classification codes are organized and validated.

Key Information Stored

The primary data stored in ZX_FC_TYPES_B centers on the classification type definition. The most critical column is the CLASSIFICATION_TYPE_CODE, which is the table's primary key and uniquely identifies a fiscal classification type (e.g., 'PRODUCT_CATEGORY', 'HARMONIZED_TARIFF'). The table also includes owner identifier columns that link the classification type to its controlling entity within EBS. The OWNER_ID_NUM column typically holds a numeric foreign key, such as linking to a category set in MTL_CATEGORY_SETS_B. The OWNER_ID_CHAR column serves a similar purpose for character-based keys, potentially linking to classification categories in HZ_CLASS_CATEGORIES or to other rows within ZX_FC_TYPES_B itself, indicating hierarchical relationships. Additional columns (implied by standard EBS table structures) would include creation date, last update date, and enabled flags to control the active status of each classification type.

Common Use Cases and Queries

This table is primarily referenced for setup validation, reporting, and integration. Common scenarios include generating a list of all active fiscal classification types available for assignment to products or tax rules. A typical query would retrieve the master list of types for a setup screen or a data load interface file. For instance, to validate if a specific classification type exists before assigning codes, one might execute:

• SELECT classification_type_code FROM zx_fc_types_b WHERE enabled_flag = 'Y';

Another key use case is troubleshooting data relationships. When a detailed fiscal classification code (stored in related tables like ZX_FC_CODES_B) fails to validate, support personnel would query this table to confirm the parent classification type is active and correctly configured. Reporting on the usage of different classification schemes across the enterprise also starts with a query against this master table.

Related Objects

ZX_FC_TYPES_B is a central hub in the fiscal classification data model. Its primary key is referenced by the ZX_FC_TYPES_REG_ASSOC table, which associates classification types with specific tax regimes, a crucial step for regulatory compliance setup. The detailed classification codes themselves are stored in ZX_FC_CODES_B, which uses the CLASSIFICATION_TYPE_CODE as a foreign key. As indicated by the foreign keys, it has important relationships with inventory (MTL_CATEGORY_SETS_B) and trading community architecture (HZ_CLASS_CATEGORIES) modules, allowing product categories and party classifications to be leveraged as fiscal types. This interconnectivity underscores its role in unifying tax determination logic across the EBS suite.