Results for “tax_rate_code_id”

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

Overview

ZX_ID_TCC_MAPPING_ALL is a core E-Business Tax (ZX) table in Oracle EBS 12.1.1 and 12.2.2. It serves two closely related purposes. First, it stores the list of tax classification codes that are applicable for a given internal organization, enabling the tax engine to determine which tax classes (and therefore which tax rules, rates, and regimes) apply when transactions are processed. Second, it preserves the mapping of migrated tax classification codes to the legacy tax code identifiers used by Oracle Payables (AP) and Oracle Receivables (AR) in prior releases. This migration-mapping role is central to the upgrade path from pre-E-Business Tax architectures (such as the older EBS Tax / Global Tax structures) into the centralized ZX model introduced in Release 12.

The table is owned by the ZX schema and is documented as VALID in the ETRM 12.2.2 physical schema, with 20 columns. The heuristic Data Vault classification mined from the foreign-key structure is a link. This reflects the table's principal function: it relates independent business entities (organizations, ledgers, tax codes, and tax classifications) rather than acting as a descriptive hub or a slowly changing satellite. Practitioners modeling this data in a warehouse context may therefore treat it as a link table joining those reference dimensions.

Key Information Stored

The table's primary key is ZX_ID_TCC_MAPPING_ALL_PK, defined over (SOURCE, TAX_RATE_CODE_ID). Two unique indexes act as business-key candidates: ZX_ID_TCC_MAPPING_ALL_U1 on TCC_MAPPING_ID and ZX_ID_TCC_MAPPING_ALL_U2 on (SOURCE, TAX_RATE_CODE_ID). The most significant columns include:

• TCC_MAPPING_ID — surrogate identifier for a mapping row; unique via U1.
• SOURCE — component of the primary key, indicating whether the mapping originated in AP or AR (the legacy source system).
• TAX_RATE_CODE_ID — the legacy tax code identifier from AP_TAX_CODES_ALL or AR_VAT_TAX_ALL_B; second component of the primary key.
• ORG_ID — the internal organization for which the tax classification codes are applicable; foreign key to HR_ALL_ORGANIZATION_UNITS.
• LEDGER_ID — the ledger context for the mapping.
• TAX_CLASSIFICATION_CODE and TAX_CLASS — the ZX tax classification code (and class) assigned to the organization.
• TAX_TYPE — qualifying the tax type associated with the classification.
• EFFECTIVE_FROM / EFFECTIVE_TO — date-range columns supporting effective-dated applicability of the mapping.
• ACTIVE_FLAG — indicates whether the mapping row is currently active.
• REQUEST_ID, PROGRAM_ID, PROGRAM_APPLICATION_ID, PROGRAM_LOGIN_ID — concurrent program audit columns identifying the process that created the row.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard WHO audit columns.

Common Use Cases and Queries

Typical scenarios include auditing classification-code setup by organization, resolving legacy AP/AR tax codes to their ZX equivalents after migration, and validating that the correct classification set is active for a ledger.

To list active classifications for an organization:

SELECT org_id, tax_class, tax_classification_code, effective_from, effective_to FROM zx.zx_id_tcc_mapping_all WHERE org_id = :org_id AND active_flag = 'Y';

To resolve a legacy AP tax code to its ZX classification:

SELECT m.source, m.tax_rate_code_id, m.tax_classification_code FROM zx.zx_id_tcc_mapping_all m WHERE m.source = 'AP' AND m.tax_rate_code_id = :code_id;

Reconciliation reports joining this table to HR_ALL_ORGANIZATION_UNITS are common during migration validation, as are extracts feeding downstream tax determination or reporting models.

Related Objects

Significant related objects and their join columns include:

• HR_ALL_ORGANIZATION_UNITS — joined on ZX_ID_TCC_MAPPING_ALL.ORG_ID.
• AP_TAX_CODES_ALL — joined on ZX_ID_TCC_MAPPING_ALL.TAX_RATE_CODE_ID (legacy AP tax codes).
• AR_VAT_TAX_ALL_B — joined on ZX_ID_TCC_MAPPING_ALL.TAX_RATE_CODE_ID (legacy AR VAT tax codes).
• ZX_ID_TCC_MAPPING_ALL.LEDGER_ID — references the ledger context used across ZX tax determination.
• ZX tax classification and ZX regime/rate setup tables — consumed alongside this mapping to derive applicable tax rules.
• Standard AP/AR tax interfaces and the E-Business Tax engine, which read this table during tax determination and migration processing.