Search Results zx_fc_types_reg_assoc




Overview
Explore in AI Chat

Overview

The ZX_FC_TYPES_REG_ASSOC table is a core data object within the ZX (E-Business Tax) module of Oracle E-Business Suite (EBS) releases 12.1.1 and 12.2.2. It functions as a critical association table, defining the relationship between fiscal classification types and the tax regimes where they are applicable. Fiscal classifications are used to categorize parties, products, or transactions for tax determination purposes. This table enables a single fiscal classification type, such as a product category or industry code, to be associated with multiple tax jurisdictions (regimes), thereby supporting global tax compliance by mapping classification schemes to specific regional tax laws.

Key Information Stored

Each row in the table represents a unique link between a fiscal classification type and a tax regime. The structure is defined by a composite primary key, ensuring that each combination is stored only once. The key columns are:

Common Use Cases and Queries

This table is primarily accessed during tax setup and tax determination engine processes. A common use case is validating which fiscal classification codes are applicable for a given transaction based on its tax regime. For instance, when determining tax for an invoice line in Germany, the system will reference this table to identify the valid product classification types for the 'DE_VAT' regime. A typical query would retrieve all classification types for a specific regime to populate a list of values in an application setup form:

  • Sample Query: SELECT classification_type_code FROM zx_fc_types_reg_assoc WHERE tax_regime_code = '&REGIME_CODE';

Conversely, administrators may query which regimes utilize a particular classification type for impact analysis during a global tax configuration change. Reporting use cases often involve joining this table to ZX_FC_TYPES_B and ZX_REGIMES_B to produce a comprehensive mapping report for audit or configuration review purposes.

Related Objects

The table maintains defined foreign key relationships with other core E-Business Tax tables, ensuring referential integrity. The documented relationships are:

  • Primary Key: ZX_FC_TYPES_REG_ASSOC_PK on (CLASSIFICATION_TYPE_CODE, TAX_REGIME_CODE).
  • Foreign Key (References): The CLASSIFICATION_TYPE_CODE column is a foreign key referencing the ZX_FC_TYPES_B table. This enforces that only valid, pre-defined fiscal classification types can be associated with a tax regime.

While not explicitly listed in the provided metadata, this table is logically related to the ZX_REGIMES_B table (for regime details) and the ZX_FC_CODES_REG_ASSOC table, which stores the actual fiscal classification code values (e.g., 'BOOKS', 'ELECTRONICS') for the associated type-regime pairs.