Search Results zx_det_factor_templ_tl_pk

Overview

The ZX_DET_FACTOR_TEMPL_TL table is a critical component of the Oracle E-Business Tax (ZX) module within Oracle E-Business Suite (EBS) releases 12.1.1 and 12.2.2. It functions as a translation table, providing multilingual support (MLS) for determining factor templates. In the E-Business Tax engine, determining factor templates define the rules and logic used to calculate tax applicability, rates, and jurisdictions for transactions. This table enables the storage and subsequent printing of user-defined template descriptions and other textual attributes in multiple languages, ensuring compliance and clarity in global deployments where tax data must be presented in local languages.

Key Information Stored

The table stores translated textual attributes for each determining factor template record. Its structure is characteristic of Oracle's MLS architecture, combining a source key with a language code. The primary key, as documented, is a composite of DET_FACTOR_TEMPL_ID and LANGUAGE. While the full column list is not provided in the excerpt, based on standard EBS MLS table design, the table typically contains the following key columns:

• DET_FACTOR_TEMPL_ID: The foreign key linking to the base determining factor template table (ZX_DET_FACTOR_TEMPLATES_B). This identifies the specific template being translated.
• LANGUAGE: The ISO code for the language of the translated text (e.g., 'US' for American English).
• SOURCE_LANG: The original language in which the data was entered.
• TEMPLATE_NAME: The translated name of the determining factor template.
• DESCRIPTION: The translated description of the template's purpose or logic.
• Standard WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN).

Common Use Cases and Queries

This table is primarily accessed by the E-Business Tax engine to retrieve locale-specific labels for templates during tax calculation and reporting. A common use case is generating tax determination reports or customer-facing documents in a user's preferred language. For support and implementation tasks, queries often join this table to its base table to verify or audit translations. A typical pattern is:

• Retrieving all translations for a specific template: SELECT language, template_name, description FROM zx_det_factor_templ_tl WHERE det_factor_templ_id = :id;
• Finding the base template record with its Spanish translation: SELECT b.template_code, tl.template_name FROM zx_det_factor_templates_b b, zx_det_factor_templ_tl tl WHERE b.det_factor_templ_id = tl.det_factor_templ_id AND tl.language = 'ES';

Direct data manipulation (DML) on this table is not standard practice; translations are typically managed through the E-Business Tax administration forms or dedicated MLS tools, which update this table via the corresponding API.

Related Objects

ZX_DET_FACTOR_TEMPL_TL has direct relationships with several core E-Business Tax objects. Its primary relationship is with the base table ZX_DET_FACTOR_TEMPLATES_B, which holds the non-translatable attributes of the template. The table is also intrinsically linked to the FND_LANGUAGES table for valid language codes. The determining factor templates themselves are used within the broader tax determination setup, referencing objects like ZX_RATES_B, ZX_JURISDICTIONS_B, and tax regimes. The primary key constraint ZX_DET_FACTOR_TEMPL_TL_PK enforces data integrity for the composite key. For programmatic access, the corresponding PL/SQL API package for the ZX_DET_FACTOR_TEMPLATES entity would handle operations involving this translation table.