Results for “determining_factor_desc”

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

Overview

ZX_DET_FACTORS_TL is the multilingual support (MLS) table for determining factors within the Oracle E-Business Tax (E-Business Tax / ZX) module in Oracle EBS 12.1.1 and 12.2.2. A determining factor is a configurable attribute used by the tax determination engine to decide which tax rules, rates, and regimes apply to a transaction line. Because tax setups are often authored and consumed by users operating in different languages, E-Business Tax stores each determining factor's name and description in every installed language, with the translated content held in this table and the language-independent attributes held in the corresponding base table, ZX_DET_FACTORS_B.

The table is owned by the ZX schema and is documented as VALID in the ETRM 12.2.2 physical schema, containing 11 columns. The mined Data Vault classification for this object is standalone. As a modeling suggestion, this classification is consistent with an MLS translation satellite: the object exists purely to carry descriptive, language-dependent attributes of a business concept, keyed by the concept's identifier plus a language code. It holds no independent FK relationships to other business entities, so it functions as a dependent descriptor rather than a hub or link in its own right.

Key Information Stored

The primary key of the table is ZX_DET_FACTORS_TL_PK, defined on the composite of DETERMINING_FACTOR_ID and LANGUAGE. A second documented unique index, ZX_DET_FACTORS_TL_U1, extends this to DETERMINING_FACTOR_ID, LANGUAGE, and ZD_EDITION_NAME, which serves as the business-key candidate and aligns the MLS row with the edition of the determining factor definition.

• DETERMINING_FACTOR_ID — Surrogate identifier of the determining factor; the join key back to the base definition table.
• LANGUAGE — The installed language of the translated row, forming the second component of the primary key.
• SOURCE_LANG — The language in which the determining factor name and description were originally authored, identifying the source of the translation.
• DETERMINING_FACTOR_NAME — The translated, user-visible name of the determining factor as presented in setup and inquiry pages.
• DETERMINING_FACTOR_DESC — The translated description providing guidance on the meaning and intended use of the determining factor.
• ZD_EDITION_NAME — Edition identifier supporting the editioning model introduced in EBS 12.2; part of the business-key unique index.
• CREATION_DATE — Timestamp when the translated row was created.
• CREATED_BY — The application user who created the translated row.
• LAST_UPDATE_DATE — Timestamp of the most recent modification to the row.
• LAST_UPDATED_BY — The application user who last modified the row.
• LAST_UPDATE_LOGIN — The login session identifier associated with the most recent update, used for audit and concurrency tracing.

Common Use Cases and Queries

The most frequent use of this table is retrieving a determining factor's display name and description in the query language of the current session, typically by joining it to the base table on the determining factor identifier. A representative pattern filters on the session language via the FND_GLOBAL utility:

• SELECT b.determining_factor_id, tl.determining_factor_name, tl.determining_factor_desc FROM zx_det_factors_b b, zx_det_factors_tl tl WHERE b.determining_factor_id = tl.determining_factor_id AND tl.language = USERENV('LANG');
• Translation audits: identify determining factors that have a row in a source language but no corresponding row for a required target language, indicating gaps in the translation set.
• Edition comparison: use ZD_EDITION_NAME to reconcile the active edition of a determining factor with its translated text, particularly after an upgrade or a configuration migration.
• Metadata repositories and integration feeds: extract the translated names for downstream reporting, tax authority documentation, or external tax engines that present factor labels to end users.

Related Objects

The relationship data identifies this object as standalone from an FK perspective, so the significant relationships are those documented by key structure and by function within E-Business Tax:

• ZX_DET_FACTORS_B — The base (language-independent) table for determining factors; joined on DETERMINING_FACTOR_ID and the parent of the MLS rows in this table.
• ZX_DET_FACTORS_TL_PK — The primary key constraint on DETERMINING_FACTOR_ID and LANGUAGE that enforces one translated row per language.
• ZX_DET_FACTORS_TL_U1 — The unique index on DETERMINING_FACTOR_ID, LANGUAGE, and ZD_EDITION_NAME that acts as the business-key candidate.
• ZX_DET_FACTOR_VALUES — The table of permissible values for a determining factor; joined indirectly through the determining factor identifier when building complete tax determination setups.
• ZX_RULES_B / ZX_RULES_TL — Tax rules that reference determining factors as the conditions driving rule evaluation; the translated factor name is displayed when rules are reviewed.
• ZX_TAX_REGIMES_B and related tax configuration tables — Regime-level tax setups that consume determining factors to shape the determination process.
• FND_GLOBAL — Supplies the session language used to select the appropriate MLS row at runtime.

Because all descriptive content is language-partitioned, any custom query against this table should constrain LANGUAGE explicitly to avoid returning duplicate rows for a single determining factor.