Search Results zx_status_tl




Overview
Explore in AI Chat

Overview

The ZX_STATUS_TL table is a core data object within the ZX (E-Business Tax) module of Oracle E-Business Suite, versions 12.1.1 and 12.2.2. It functions as a translation or multilingual support (MLS) table, specifically for tax statuses. Its primary role is to enable the storage and retrieval of language-specific descriptions for tax status codes, which are defined in the base table ZX_STATUS_B. This design is fundamental to global deployments, allowing the system to present and print tax-related information, such as status names, in the language of the transaction or the user, thereby supporting international compliance and reporting requirements.

Key Information Stored

The table stores translated text for each tax status across multiple installed languages. Its structure is typical of Oracle MLS tables. The critical columns include:

  • TAX_STATUS_ID: The unique identifier for the tax status. This column forms a foreign key relationship to the primary key of the base table ZX_STATUS_B.
  • LANGUAGE: The code (e.g., 'US', 'FR', 'DE') representing the language of the translated text in the row.
  • SOURCE_LANG: A column typically present in MLS tables to denote the original language in which the data was entered.
  • STATUS_NAME: The translated name or description of the tax status in the specified language.

The primary key is a composite of TAX_STATUS_ID and LANGUAGE, ensuring a unique translation entry per status per language.

Common Use Cases and Queries

This table is primarily accessed indirectly through the application's user interface or via reporting queries that require language-specific tax data. A common operational use case is the generation of multilingual tax invoices or statutory reports where the tax status description must appear in a local language. For reporting and data extraction, a standard pattern is to join this table with its base table and filter by the desired language. For example, to retrieve all status names in French:

SELECT b.tax_status_code, tl.status_name
FROM zx_status_b b, zx_status_tl tl
WHERE b.tax_status_id = tl.tax_status_id
AND tl.language = 'F'
AND tl.source_lang = USERENV('LANG');

Developers customizing or extending tax functionality must ensure any UI or integration that displays status descriptions correctly joins to ZX_STATUS_TL based on the current session language context.

Related Objects

The ZX_STATUS_TL table has a direct and dependent relationship with several key E-Business Tax objects.

  • ZX_STATUS_B: This is the primary base table, holding the core, language-independent definition of a tax status (code, effective dates, etc.). The foreign key ZX_STATUS_TL.TAX_STATUS_ID references ZX_STATUS_B.TAX_STATUS_ID.
  • Views: The application typically provides language-sensitive views (e.g., ZX_STATUSES_VL, where 'VL' denotes "View, Localized") that perform the join between ZX_STATUS_B and ZX_STATUS_TL automatically based on the user's session language. These views are the recommended access point for most queries.
  • Tax Determination Setup: Tax statuses defined in these tables are integral to the tax rules engine, referenced within condition sets and determination logic to assess the applicability of specific tax rates.