Results for “det_factor_templ_name”
38 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
The ZX_DET_FACTOR_TEMPL_TL table is a multilingual support (MLS) table within the Oracle E-Business Tax (ZX) module. It stores translated and language-specific attributes for each determining factor template defined in E-Business Tax. Determining factor templates provide the configurable structure through which tax determining factors — such as party type, product fiscal classification, tax classification code, and regime-to-rate flow attributes — are evaluated during tax determination. Because these templates carry user-facing names and descriptions, Oracle EBS stores the display text in this companion translation table so that the same template can be rendered in multiple installed languages.
The object resides in the ZX schema and is classified as VALID in the documented ETRM 12.2.2 metadata. From a heuristic Data Vault modeling perspective, this table is best characterized as a satellite: it is attached to the determining factor template business key through DET_FACTOR_TEMPL_ID and carries descriptive, time-and-language-bound attributes rather than independent relationships. This classification is a modeling suggestion derived from the foreign key structure; the table is not a hub or link in its own right.
Key Information Stored
The table follows the standard Oracle EBS MLS pattern, combining a composite primary key with descriptive columns. The most significant columns are:
- DET_FACTOR_TEMPL_ID — the surrogate identifier of the determining factor template; the parent key shared with the base table and part of the primary key.
- LANGUAGE — the language code identifying the translation row; the second component of the primary key.
- SOURCE_LANG — indicates the language from which the row was originally created or seeded, used by the MLS infrastructure to manage translation lineage.
- DET_FACTOR_TEMPL_NAME — the translated display name of the determining factor template.
- DET_FACTOR_TEMPL_DESC — the translated description of the template.
- ZD_EDITION_NAME — the edition identifier associated with the row, reflecting the edition-based redefinition model used in E-Business Tax reference data.
- CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard Oracle EBS audit columns recording insert and update context.
The primary key is defined as ZX_DET_FACTOR_TEMPL_TL_PK on (DET_FACTOR_TEMPL_ID, LANGUAGE). A unique index, ZX_DET_FACTOR_TEMPL_TL_U1, covers (DET_FACTOR_TEMPL_ID, LANGUAGE, ZD_EDITION_NAME) and serves as the business-key candidate that guarantees at most one translation row per template per language per edition. There is no foreign-key-driven parent/child structure inside this table itself; it functions as a standalone descriptive satellite.
Common Use Cases and Queries
Typical uses include multilingual reporting of tax configuration, template maintenance in non-base languages, and translation-completeness audits. A common query retrieves the translated template name and description for a given language:
- SELECT det_factor_templ_id, language, det_factor_templ_name, det_factor_templ_desc FROM zx.zx_det_factor_templ_tl WHERE language = 'US' AND zd_edition_name = 'ORA_EDITION';
- Joining the base table to the translation table on DET_FACTOR_TEMPL_ID to report all configured templates with their localized names.
- Finding templates lacking a translation in a required language by comparing distinct template IDs against translation rows.
- Extracting template metadata for governance or documentation using SOURCE_LANG to distinguish seeded versus user-created definitions.
Related Objects
The following objects are most significant in relation to ZX_DET_FACTOR_TEMPL_TL:
- ZX_DET_FACTOR_TEMPL_B — the base table holding the language-independent template definitions, joined on DET_FACTOR_TEMPL_ID.
- ZX_DET_FACTOR_TEMPL_TL_PK / ZX_DET_FACTOR_TEMPL_TL_U1 — the primary key and unique index enforcing translation uniqueness.
- ZX_DET_FACTOR_TEMPL_LINES — child configuration records that depend on templates defined in the base and translation tables.
- ZX_PARTY_TYPES / ZX_TAX_CLASSIFICATIONS — determining factor value sets commonly referenced by templates during tax determination.
- FND_LANGUAGES — the language reference table supplying valid LANGUAGE codes used in the MLS key.
-
This table provides multilingual support (MLS) for each determining factor template. MLS enables you to store and print data that you define in multiple languages.
-
This table provides multilingual support (MLS) for each determining factor template. MLS enables you to store and print data that you define in multiple languages.
-
View: ZX_DET_FACTOR_TEMPL_VL 12.1.1
APPS.ZX_DET_FACTOR_TEMPL_VL·↳ ZX_DET_FACTOR_TEMPL_B·↳ ZX_DET_FACTOR_TEMPL_TL·Explore FND module →
-
View: ZX_DET_FACTOR_TEMPL_VL 12.2.2
APPS.ZX_DET_FACTOR_TEMPL_VL·↳ ZX_DET_FACTOR_TEMPL_B·↳ ZX_DET_FACTOR_TEMPL_TL·Explore FND module →
-
eTRM - ZX Tables and Views 12.1.1
This global temporary table is used to return validation errors for imported transactions from tax perspective.
-
eTRM - ZX Tables and Views 12.2.2
This global temporary table is used to return validation errors for imported transactions from tax perspective.
-
eTRM - FND Tables and Views 12.2.2
No longer used
-
eTRM - FND Tables and Views 12.1.1
No longer used