Search Results zx_parameters_b




Overview
Explore in AI Chat

Overview

ZX_PARAMETERS_B is the base definition table for tax parameters within the ZX (E-Business Tax) schema in Oracle E-Business Suite releases 12.1.1 and 12.2.2. It stores the master definitions of all configurable tax parameters that drive the E-Business Tax calculation and configuration engine. Each row describes a single tax parameter, including its data type, formatting rules, and behavioral controls such as seeding, generation, enablement, and override permissions. Because E-Business Tax relies on a repository of predefined and user-defined parameters to control how tax setup behaves, ZX_PARAMETERS_B functions as a foundational configuration reference that other ZX components depend on.

The table follows the standard Oracle multi-language design pattern, with the "_B" suffix indicating it holds language-independent (base) rows. Translated, language-specific descriptions are stored separately in ZX_PARAMETERS_TL, which joins back to this table on TAX_PARAMETER_CODE. The heuristic Data Vault classification of this object is hub-leaning, suggesting it models naturally as a hub: a stable, uniquely keyed set of business entities (tax parameters) referenced by dependent child structures. This classification is a modeling suggestion derived from the foreign key topology rather than a physical constraint in the EBS schema.

Key Information Stored

The primary key is ZX_PARAMETERS_B_PK, defined on the column TAX_PARAMETER_CODE. A secondary unique index, ZX_PARAMETERS_B_U1, spans TAX_PARAMETER_CODE together with ZD_EDITION_NAME; this composite serves as the documented business-key candidate, reflecting the edition-aware nature of the parameter set.

  • TAX_PARAMETER_CODE — The surrogate primary key and the unique identifier for each tax parameter.
  • ZD_EDITION_NAME — Edition discriminator that, combined with the parameter code, forms the business-key candidate.
  • TAX_PARAMETER_TYPE_CODE — Classifies the parameter type, determining how the value is interpreted.
  • FORMAT_TYPE_CODE — Specifies the expected format or presentation of the parameter value.
  • MAX_SIZE — The maximum permissible size of the parameter value.
  • SEEDED_FLAG — Indicates whether the parameter was seeded by Oracle versus user-defined.
  • GENERATE_GET_FLAG — Controls whether a getter routine is generated for the parameter.
  • ENABLED_FLAG — Determines whether the parameter is currently active for use.
  • ALLOW_OVERRIDE_FLAG — Indicates whether the parameter value may be overridden at a higher level.
  • CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard auditing columns tracking creation and modification.

Common Use Cases and Queries

Typical usage centers on validating tax parameter configuration, reporting on enabled parameters, and joining parameter definitions to their translations and detail rows. Administrators and developers frequently filter on SEEDED_FLAG to distinguish Oracle-provided parameters from custom ones, or on ENABLED_FLAG to identify active configuration.

A representative query retrieves enabled, seeded parameters with their translated names:

  • SELECT b.TAX_PARAMETER_CODE, b.TAX_PARAMETER_TYPE_CODE, b.SEEDED_FLAG, t.TAX_PARAMETER_NAME FROM ZX.ZX_PARAMETERS_B b, ZX.ZX_PARAMETERS_TL t WHERE b.TAX_PARAMETER_CODE = t.TAX_PARAMETER_CODE AND b.ENABLED_FLAG = 'Y' AND t.LANGUAGE = USERENV('LANG');

Reporting use cases include auditing override permissions, checking format and size constraints before populating parameter values, and reconciling parameter details against their base definitions.

Related Objects

  • ZX_PARAMETERS_TL — Holds translated parameter names and descriptions; joins on ZX_PARAMETERS_TL.TAX_PARAMETER_CODE = ZX_PARAMETERS_B.TAX_PARAMETER_CODE.
  • ZX_PARAM_DETAILS — Stores detail-level parameter data; joins on ZX_PARAM_DETAILS.TAX_PARAMETER_CODE = ZX_PARAMETERS_B.TAX_PARAMETER_CODE.
  • ZX_PARAMETERS_B_PK — The primary key constraint enforcing uniqueness of TAX_PARAMETER_CODE.
  • ZX_PARAMETERS_B_U1 — The composite unique index on TAX_PARAMETER_CODE and ZD_EDITION_NAME.
  • ZX_PARAMETERS_VL — The standard EBS view layered over the base and translation tables for language-aware access.

Together these objects form the parameter configuration sub-model of E-Business Tax, with ZX_PARAMETERS_B acting as the central base definition from which translations and detail rows extend.