Results for “det_factor_templ_code”

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

Overview

ZX_DET_FACTOR_TEMPL_B is a foundational configuration table within the Oracle E-Business Tax (E-Business Tax / ZX) module, residing in the ZX schema. It stores templates that define how determining factors—the criteria Oracle E-Business Tax evaluates to derive the correct tax regime, tax, tax status, rate, and jurisdiction for a transaction—are used by the tax determination engine. Each row in the table represents a single determining factor template, providing a reusable blueprint against which tax rules, regimes, and event classification logic are configured.

Because determining factor templates are referenced by many downstream tax configuration objects, the table serves as a central reference point rather than a transactional or historical ledger. In Data Vault modeling terms, the heuristic classification for this object is a hub: it holds a stable, uniquely identified business concept (the template code and surrogate identifier) with minimal descriptive payload of its own, and other tax objects connect to it. This classification is offered as a modeling suggestion and should be validated against the actual column semantics prior to use in any integration or data-warehouse design.

Key Information Stored

The table is physically owned by ZX and contains 18 documented columns. The most significant columns are:

• DET_FACTOR_TEMPL_CODE – The user-facing business key identifying each determining factor template. It is the single-column component of the primary key ZX_DET_FACTOR_TEMPL_B_PK and also participates in unique index ZX_DET_FACTOR_TEMPL_B_U2 together with ZD_EDITION_NAME.
• DET_FACTOR_TEMPL_ID – The internal surrogate identifier for the template, paired with ZD_EDITION_NAME in unique index ZX_DET_FACTOR_TEMPL_B_U1.
• TAX_REGIME_CODE – Identifies the tax regime (for example, VAT or a country-specific regime) to which the template belongs, scoping the configuration to a regulatory context.
• TEMPLATE_USAGE_CODE – Indicates the intended purpose of the template, determining where and how it may be applied within tax determination.
• RECORD_TYPE_CODE – Classifies the type of template record, distinguishing variants such as seeded versus user-defined entries.
• LEDGER_ID – Associates the template with a specific ledger, enabling ledger-scoped tax configuration. LEDGER_ID is referenced as a foreign key relationship against the ledger structure.
• CHART_OF_ACCOUNTS_ID – Links the template to a chart of accounts, supporting account-based scoping of determining factors.
• ZD_EDITION_NAME – Supports the edition/versioning framework within E-Business Tax, allowing multiple effective editions of the same template to coexist.
• OBJECT_VERSION_NUMBER – Implements optimistic locking for concurrent update protection.
• Audit columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_LOGIN_ID) – Capture standard Oracle Applications audit and concurrent program context, enabling traceability of who created or last changed each template.

Together, DET_FACTOR_TEMPL_CODE and ZD_EDITION_NAME form the effective business-key candidate, while DET_FACTOR_TEMPL_ID provides the surrogate join key used by dependent objects.

Common Use Cases and Queries

Typical use cases include auditing which determining factor templates exist for a given regime, verifying ledger and chart-of-accounts scoping, and tracing which rules, regimes, or taxes depend on a template before making configuration changes.

• Listing templates by regime:

  SELECT det_factor_templ_code, tax_regime_code, template_usage_code, record_type_code FROM zx.zx_det_factor_templ_b WHERE tax_regime_code = :regime;

• Finding templates scope to a ledger or chart of accounts:

  SELECT det_factor_templ_code, ledger_id, chart_of_accounts_id FROM zx.zx_det_factor_templ_b WHERE ledger_id = :ledger_id;

• Detecting dependency on a template before change: query ZX_RULES_B, ZX_TAXES_B, ZX_REGIMES_B, or ZX_EXCEPTIONS for matching DET_FACTOR_TEMPL_CODE or THRSHLD_CHK_TMPLT_CODE.
• Reporting which templates are referenced by event class mappings or exemptions, supporting impact analysis for tax configuration changes.

Related Objects

Several E-Business Tax objects reference this table through foreign keys on DET_FACTOR_TEMPL_CODE or THRSHLD_CHK_TMPLT_CODE:

• ZX_RULES_B – References DET_FACTOR_TEMPL_CODE; tax rules consuming the template.
• ZX_TAXES_B – References THRSHLD_CHK_TMPLT_CODE; taxes using the template for threshold checking.
• ZX_REGIMES_B – References THRSHLD_CHK_TMPLT_CODE; regimes linked to the template.
• ZX_EVNT_CLS_MAPPINGS – References DET_FACTOR_TEMPL_CODE; event class mapping configuration.
• ZX_EVNT_CLS_OPTIONS – References DET_FACTOR_TEMPL_CODE; event class option configuration.
• ZX_EXCEPTIONS – References DET_FACTOR_TEMPL_CODE; exception handling definitions.
• ZX_EXEMPTIONS – References DET_FACTOR_TEMPL_CODE; exemption definitions.
• GL_MGT_SEG_UPGRADE_H – Related through CHART_OF_ACCOUNTS_ID, supporting chart-of-accounts context.