Search Results zx_id_tcc_mapping_all




Overview
Explore in AI Chat

Overview

The ZX_ID_TCC_MAPPING_ALL table is a core repository within the ZX (E-Business Tax) module of Oracle E-Business Suite (EBS) releases 12.1.1 and 12.2.2. It serves a dual purpose in the tax architecture. Primarily, it defines the list of Tax Classification Codes (TCCs) that are valid and applicable for a specific internal organization, enabling tax determination based on organizational context. Critically, it also functions as a historical mapping table to support system upgrades. It maintains the relationship between migrated legacy tax classification codes from pre-E-Business Tax releases and their corresponding tax code identifiers from the legacy Accounts Payable (AP) and Accounts Receivable (AR) tax systems, ensuring data continuity and auditability post-migration.

Key Information Stored

The table's structure, as indicated by its primary and foreign keys, centers on mapping tax identifiers across systems and organizations. The primary key is a composite of SOURCE and TAX_RATE_CODE_ID, suggesting a unique mapping per source system. Key columns include ORG_ID, which links to HR_ALL_ORGANIZATION_UNITS to scope code applicability; TAX_RATE_CODE_ID, which serves as a foreign key to both AP_TAX_CODES_ALL and AR_VAT_TAX_ALL_B, directly linking to the legacy tax codes; and LEDGER_ID, which ties the mapping to a specific financial ledger. The SOURCE column likely indicates the origin system (e.g., 'AP', 'AR') for the mapped code, while other inferred columns would store the current E-Business Tax TCC and effective date ranges.

Common Use Cases and Queries

This table is essential for troubleshooting tax calculations for migrated data and for generating reports that reconcile legacy and current tax setups. A common query would trace the current TCC for a historical AP tax code used in a specific organization. For example, to find the mapping for a legacy AP tax code ID (like the user's search fragment 'ap'123' might suggest) for a given operating unit, one might query:

  • SELECT tcc_mapping.tax_classification_code, ap_tax.name
    FROM zx_id_tcc_mapping_all tcc_mapping,
    ap_tax_codes_all ap_tax
    WHERE tcc_mapping.tax_rate_code_id = ap_tax.tax_id
    AND tcc_mapping.source = 'AP'
    AND ap_tax.tax_id = 123
    AND tcc_mapping.org_id = :org_id;

This table is also queried by the E-Business Tax engine during tax determination to validate if a TCC is enabled for the transaction's operating unit.

Related Objects

ZX_ID_TCC_MAPPING_ALL is a central hub with defined relationships to several key tables. Its foreign key dependencies are critical: ORG_ID references HR_ALL_ORGANIZATION_UNITS for the organizational model. TAX_RATE_CODE_ID references both AP_TAX_CODES_ALL (for Payables tax codes) and AR_VAT_TAX_ALL_B (for Receivables tax codes), encapsulating the legacy mapping. The LEDGER_ID column suggests a relationship to the General Ledger (GL) structure. As a foundation table in the ZX schema, it is referenced by various E-Business Tax views and APIs responsible for tax configuration and lookups. The primary key constraint ZX_ID_TCC_MAPPING_ALL_PK enforces the integrity of the source-to-code mapping.