Search Results zx_reporting_codes_tl




Overview
Explore in AI Chat

Overview

ZX_REPORTING_CODES_TL is a multilingual support (MLS) translation table within the Oracle E-Business Tax (ZX) module of Oracle E-Business Suite 12.1.1 and 12.2.2, owned by the ZX schema. Its purpose is to store the language-specific, translated attributes that describe each tax reporting code defined in E-Business Tax. Reporting codes are used to classify tax transactions and tax lines for regulatory reporting (for example, VAT, GST, and other indirect tax returns), and because such codes must be presented, printed, and audited in the operating language of each legal entity, the base definition is held in the primary table while the translatable text is held here.

Oracle's MLS architecture pairs a base table (ZX_REPORTING_CODES_B) with this _TL translation table, using a shared primary key identifier and a LANGUAGE column to distinguish rows. The row for SOURCE_LANG represents the original language of entry; additional rows carry the translations maintained by the user. The table is classified as VALID and is part of the standard ETRM data model shipped with the product.

Based on the FK/PK relationship metadata, the heuristic Data Vault classification for this object is standalone. As a modeling suggestion, this reflects the fact that ZX_REPORTING_CODES_TL participates in no outbound foreign-key dependencies of its own: it is a dependent, attribute-bearing table that qualifies the reporting code entity, which is consistent with a satellite-style role rather than a hub or link.

Key Information Stored

The table comprises ten documented columns. The most significant are:

  • REPORTING_CODE_ID — the surrogate identifier of the reporting code; it links each translation row back to the base reporting code definition. This column forms the leading component of the primary key.
  • LANGUAGE — the language code for the row, expressed as an NLS language identifier. Together with REPORTING_CODE_ID it forms the primary key ZX_REPORTING_CODES_TL_PK.
  • SOURCE_LANG — the language in which the reporting code was originally created; it flags the source row versus its translations.
  • REPORTING_CODE_NAME — the translated, user-facing name of the reporting code, and the principal translatable attribute of the table.
  • ZD_EDITION_NAME — the edition identifier that partitions the row for edition-based redefinition; it participates in the unique index ZX_REPORTING_CODES_TL_U1.

The remaining columns are standard audit and concurrency attributes maintained by the Oracle Applications framework: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN.

The surrogate primary key is ZX_REPORTING_CODES_TL_PK (REPORTING_CODE_ID, LANGUAGE). The unique index ZX_REPORTING_CODES_TL_U1 (REPORTING_CODE_ID, LANGUAGE, ZD_EDITION_NAME) acts as the business-key candidate, enforcing that only one translation row exists per reporting code, per language, per edition.

Common Use Cases and Queries

Typical use cases include reporting on tax reporting code lists in a specific language, validating that all required translations exist, and joining translated names to transaction or tax line data for printed returns.

Retrieve the name of a reporting code in the session's language:

SELECT t.reporting_code_id, t.reporting_code_name
FROM zx_reporting_codes_tl t
WHERE t.language = USERENV('LANG')
AND t.zd_edition_name = 'ORA_EDITION';

Detect reporting codes missing a translation in a target language:

SELECT b.reporting_code_id
FROM zx_reporting_codes_b b
WHERE NOT EXISTS (SELECT 1 FROM zx_reporting_codes_tl t
WHERE t.reporting_code_id = b.reporting_code_id
AND t.language = 'ES');

Related Objects

The most significant related objects are:

  • ZX_REPORTING_CODES_B — the base MLS table holding the language-independent definition of each reporting code, joined on REPORTING_CODE_ID.
  • ZX_REPORTING_CODES_VL — the MLS view that joins the base and translation tables to present the reporting code with its translated name in the current language.
  • ZX_REPORTING_CODES_TL_PK / ZX_REPORTING_CODES_TL_U1 — primary key constraint and the unique business-key index on (REPORTING_CODE_ID, LANGUAGE, ZD_EDITION_NAME).
  • ZX_FC_COUNTRY_SEC_RULES and other ZX reporting/configuration tables — reference reporting codes for regulatory reporting configuration.
  • FND_LANGUAGES — supplies the valid values for LANGUAGE and SOURCE_LANG.
  • ZX_TAX_LINES / ZX_LINES — consume reporting codes for tax reporting and reconciliation of transaction lines.