Results for “owner_id_num”

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

Overview

ZX_FC_TYPES_B is the base configuration table in the E-Business Tax (ZX) module that stores the fiscal classification types defined in an Oracle EBS 12.1.1 or 12.2.2 instance. Fiscal classifications are the mechanism by which E-Business Tax associates tax rules and tax regimes with operational data such as inventory categories, customer class categories, product fiscal classifications, and user-defined transaction inputs. Each row in ZX_FC_TYPES_B represents a single fiscal classification type belonging to a specific classification category, with the row carrying the effective-date, delimiter, and positional attributes needed to parse or derive classification values from source data. The object resides in the ZX schema and is documented by ETRM as a VALID table containing 41 columns.

From a Data Vault modeling perspective, the mined foreign-key structure suggests a satellite-leaning classification. The table carries its own surrogate identifier (CLASSIFICATION_TYPE_ID), business-facing codes, effective-dating attributes, and descriptive configuration columns, but it also references parent category entities. It therefore behaves less like a pure hub and more like a descriptive satellite attached to classification category and category set hubs.

Key Information Stored

ZX_FC_TYPES_B is keyed by the surrogate primary key CLASSIFICATION_TYPE_ID, which is enforced through the unique index ZX_FC_TYPES_B_U1 (CLASSIFICATION_TYPE_ID, ZD_EDITION_NAME). A second unique index, ZX_FC_TYPES_B_U2 (CLASSIFICATION_TYPE_CODE, ZD_EDITION_NAME), establishes CLASSIFICATION_TYPE_CODE as the business-key candidate that users and interfaces reference directly. The ZD_EDITION_NAME column participates in both unique keys, reflecting edition-based support for multiple configuration editions.

• CLASSIFICATION_TYPE_CODE – the user-visible, business-key code for the fiscal classification type.
• CLASSIFICATION_TYPE_ID – surrogate primary key used by all foreign key relationships.
• CLASSIFICATION_TYPE_CATEG_CODE – the classification category to which the type belongs.
• CLASSIFICATION_TYPE_GROUP_CODE – grouping used to organize related fiscal classification types.
• OWNER_TABLE_CODE, OWNER_ID_NUM, OWNER_ID_CHAR – identify the owning entity, such as a category set or class category, and drive the documented foreign keys.
• EFFECTIVE_FROM, EFFECTIVE_TO – effective-date range controlling when the type is valid for tax determination.
• START_POSITION, NUM_CHARACTERS, DELIMITER – positional parsing attributes used when the classification value is derived from a source string.
• CLASSIFICATION_TYPE_LEVEL_CODE – indicates the level at which the type applies.
• RECORD_TYPE_CODE – distinguishes record variants within the table.
• OBJECT_VERSION_NUMBER – optimistic locking column used by the Oracle Applications framework.
• ATTRIBUTE_CATEGORY, ATTRIBUTE1 through ATTRIBUTE15 – descriptive flexfield storage for customer-specific extensions.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_LOGIN_ID – standard WHO and concurrent program audit columns.

Common Use Cases and Queries

The most frequent reporting patterns resolve fiscal classification types by category or by business code, and join them to the registration association table to determine which types are available to a tax regime or configuration owner.

• Listing active types for a category: SELECT classification_type_code, classification_type_categ_code FROM zx.zx_fc_types_b WHERE classification_type_categ_code = :category AND SYSDATE BETWEEN effective_from AND NVL(effective_to, SYSDATE);
• Lookup by business key: SELECT classification_type_id, classification_type_group_code FROM zx.zx_fc_types_b WHERE classification_type_code = :code;
• Joining to registration associations to find types configured for a regime: SELECT b.classification_type_code FROM zx.zx_fc_types_b b, zx.zx_fc_types_reg_assoc a WHERE b.classification_type_code = a.classification_type_code;
• Resolving the owning category set or class category through OWNER_TABLE_CODE and OWNER_ID_NUM / OWNER_ID_CHAR.
• Diagnosing tax determination failures caused by expired EFFECTIVE_TO dates or missing registration associations.

Related Objects

• ZX_FC_TYPES_REG_ASSOC – associates fiscal classification types with tax registrations; joined on CLASSIFICATION_TYPE_CODE.
• ZX_FC_TYPES_B (self-reference) – OWNER_ID_CHAR can reference another row in this same table, supporting hierarchical ownership.
• MTL_CATEGORY_SETS_B – joined via OWNER_ID_NUM to link a fiscal classification type to an inventory category set.
• HZ_CLASS_CATEGORIES – joined via OWNER_ID_CHAR to link a fiscal classification type to a customer class category.
• ZX_FC_TYPES_TL – the translation table holding language-specific names and descriptions for each classification type.
• ZX_RATES_B, ZX_RULES_B – tax rate and rule configuration that consume fiscal classification types during tax determination.