Results for “effective_from”

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

Overview

ZX_FC_PRODUCT_CATEGORIES_V is a reporting view owned by the APPS schema in Oracle E-Business Suite releases 12.1.1 and 12.2.2. It is registered under the FND — Application Object Library product and is documented in the E-Business Tax (ETRM) object inventory, which confirms its role as part of the tax configuration and content infrastructure rather than a transactional table. The view presents a filtered, language-aware list of product category fiscal classification codes as they are defined in the tax content repository.

In EBS, fiscal classifications associate a tax regime with a category of goods or services so that the correct tax rules, rates, and reporting treatment can be applied during tax determination. The PRODUCT_CATEGORY classification type is the mechanism by which inventory product categories are mapped to these fiscal classifications. This view exposes exactly that subset of classification codes, restricted to enabled rows for the user's current language. It is therefore a read-only reference view used by tax setup validation, reporting, and integration layers that must resolve a product category to its classification code or name.

Underlying Base Objects

The view is defined over a single documented base object: ZX_FC_CODES_DENORM_B, accessed through an APPS synonym. ZX_FC_CODES_DENORM_B is the denormalized codes table in the fiscal classification content model; it stores classification codes flattening the hierarchical relationships between classification types and their parent structures, together with country, effective dating, language, and enabled status.

The view text joins this base table with three restricting predicates. First, CLASSIFICATION_TYPE_CODE must equal 'PRODUCT_CATEGORY', which isolates product category rows from all other fiscal classification types present in the same table. Second, LANGUAGE must match USERENV('LANG'), returning only rows in the session's current language, which allows the same logical classification to exist in multiple languages without duplication in the result set. Third, ENABLED_FLAG must be 'Y', excluding disabled or end-dated content delivered by tax content updates.

Key Columns

The view exposes a compact set of five columns derived entirely from the base table.

• CONCAT_CLASSIF_CODE — the concatenated classification code, the canonical identifier for the product category fiscal classification as used in tax setup, lookups, and integrations.
• CONCAT_CLASSIF_NAME — the concatenated classification name, the descriptive label displayed in the user interface and printed on reports.
• COUNTRY_CODE — the country to which the classification applies, reflecting the country-specific nature of tax content.
• EFFECTIVE_FROM — the date from which the classification becomes active and eligible for tax determination.
• EFFECTIVE_TO — the date on which the classification ceases to be active; the view itself does not filter on this column, so consumers performing date-sensitive queries must apply their own effective date predicate.

Common Use Cases and Queries

Typical scenarios include building LOVs or lookup lists for tax configuration screens, validating that a product category has an active fiscal classification prior to tax rule assignment, and joining tax determination data to product category reporting. Because the view is pre-filtered on classification type, language, and enabled status, a simple SELECT returns a clean, immediately usable list.

• List all active product category classifications: SELECT concat_classif_code, concat_classif_name FROM zx_fc_product_categories_v ORDER BY concat_classif_name;
• Restrict to a country and current effective window: SELECT concat_classif_code, concat_classif_name, effective_from, effective_to FROM zx_fc_product_categories_v WHERE country_code = 'US' AND TRUNC(SYSDATE) BETWEEN effective_from AND NVL(effective_to, TRUNC(SYSDATE) + 1);
• Validate a specific code during integration: SELECT COUNT(*) FROM zx_fc_product_categories_v WHERE concat_classif_code = :p_code;

Because the base object is a denormalized content table, the view reflects the tax content release currently installed; joins to transactional tables should be made on the classification code, and effective dating should be handled explicitly by the calling application.