Results for “zx_fc_codes_b”

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

Overview

ZX_FC_CODES_B is the base (untranslated) table in the E-Business Tax (ZX) module that stores fiscal classification code hierarchies. It holds the parent-child definitions for the fiscal classification types that drive tax determination in Oracle EBS 12.1.1 and 12.2.2, including Document Sub Type, Intended Use, User Defined Fiscal Classification, Product Category, Transaction Business Category, and Transaction Fiscal Classification. Each row represents a single fiscal classification code node within a hierarchy, identified by a surrogate key and positioned relative to a parent node where the hierarchy is multi-level.

From a Data Vault modeling perspective, the mined foreign key structure suggests this object is hub-leaning: the surrogate primary key CLASSIFICATION_ID behaves like a hub key, while the self-referencing PARENT_CLASSIFICATION_ID introduces a hierarchical (recursive) relationship that would typically be modeled as a same-as or hierarchical link. Volatile descriptive attributes, if separated, would resolve to satellite structures.

Key Information Stored

• CLASSIFICATION_ID — Surrogate primary key (constrained by ZX_FC_CODES_B_PK); uniquely identifies each fiscal classification code row.
• CLASSIFICATION_CODE — The user-facing code value for the classification; part of the composite business-key candidate ZX_FC_CODES_B_U2.
• CLASSIFICATION_TYPE_CODE — Identifies which classification category the row belongs to (e.g., Document Sub Type, Intended Use, Product Category); also part of ZX_FC_CODES_B_U2.
• PARENT_CLASSIFICATION_ID — Self-referencing FK to ZX_FC_CODES_B defining the hierarchy; part of ZX_FC_CODES_B_U2.
• PARENT_CLASSIFICATION_CODE — Denormalized code of the parent node, useful for hierarchy reporting without a self-join.
• COUNTRY_CODE — FK to FND_TERRITORIES, scoping classification codes to a legal jurisdiction.
• COMPILED_FLAG — Indicates whether the classification has been compiled for tax rule processing.
• EFFECTIVE_FROM / EFFECTIVE_TO — Date-range effective dating controlling when a classification code is valid.
• RECORD_TYPE_CODE — Distinguishes record categories used internally by tax configuration.
• CLASSIFICATION_ID / OBJECT_VERSION_NUMBER — Optimistic locking and concurrency control columns standard to EBS.
• ZD_EDITION_NAME — Editioning column present in 12.2.2 online patching; the unique indexes ZX_FC_CODES_B_U1 and ZX_FC_CODES_B_U2 both include it.
• ATTRIBUTE1–15 / ATTRIBUTE_CATEGORY — Descriptive flexfield segments for extensibility.
• Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_LOGIN_ID.

Common Use Cases and Queries

Configuration and support teams query ZX_FC_CODES_B to validate hierarchy setup, verify effective dates, and resolve code translations via ZX_FC_CODES_TL. A typical parent lookup:

• SELECT b.classification_code, b.classification_type_code, t.description FROM zx_fc_codes_b b, zx_fc_codes_tl t WHERE b.classification_id = t.classification_id AND t.language = USERENV('LANG');
• Recursive hierarchy traversal using CONNECT BY on PARENT_CLASSIFICATION_ID to render full classification trees per COUNTRY_CODE and type.
• Effective-date filtered reporting: WHERE SYSDATE BETWEEN effective_from AND NVL(effective_to, SYSDATE);

Related Objects

• ZX_FC_CODES_TL — Translation table keyed on CLASSIFICATION_ID; supplies language-specific descriptions.
• ZX_FC_CODES_DENORM_B — Denormalized base table referencing CLASSIFICATION_ID for flattened hierarchy lookups.
• ZX_FC_CODES_B (self) — PARENT_CLASSIFICATION_ID joins back to CLASSIFICATION_ID for hierarchy resolution.
• FND_TERRITORIES — Joined via COUNTRY_CODE for jurisdiction descriptions.

Together these objects support the fiscal classification structures consumed by Oracle E-Business Tax during tax rule evaluation.