Search Results zx_fc_codes_tl




Overview
Explore in AI Chat

Overview

The ZX_FC_CODES_TL table is a core data object within the Oracle E-Business Tax (ZX) module of Oracle E-Business Suite (EBS) releases 12.1.1 and 12.2.2. It functions as a translation table, providing multilingual support (MLS) for fiscal classification codes. These codes are used to categorize parties, products, and transactions for tax determination and reporting purposes across different jurisdictions. The table's primary role is to enable the storage and retrieval of user-defined fiscal classification code names and descriptions in multiple languages, ensuring that tax-related data can be accurately presented and printed in the language of the business context or regulatory requirement.

Key Information Stored

The table stores the translated attributes for each fiscal classification code. Its structure is typical of an MLS table in Oracle EBS, utilizing a composite primary key that links to the base table and specifies the language. The most critical columns include:

  • CLASSIFICATION_ID: The foreign key that uniquely links each row to its corresponding master record in the base table ZX_FC_CODES_B. This column is part of the primary key (ZX_FC_CODES_TL_PK).
  • LANGUAGE: The language code (e.g., 'US' for American English) for the translated text. This column completes the primary key, ensuring only one translation per code per language exists.
  • NAME: The translated name of the fiscal classification code in the specified language.
  • DESCRIPTION: The translated description providing further detail about the fiscal classification code.
  • Standard Oracle columns such as CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, and LAST_UPDATE_DATE for auditing.
  • The SOURCE_LANG column, which indicates the original language of the record.

Common Use Cases and Queries

This table is primarily accessed by the E-Business Tax engine and related user interfaces to display code descriptions in the user's session language. A common reporting use case is to generate a list of all fiscal classification codes with their descriptions in a specific language for documentation or setup verification. The following sample SQL pattern retrieves such information by joining the translation table with its base table, filtered by language.

SELECT b.CLASSIFICATION_CODE, tl.NAME, tl.DESCRIPTION
FROM ZX_FC_CODES_B b, ZX_FC_CODES_TL tl
WHERE b.CLASSIFICATION_ID = tl.CLASSIFICATION_ID
AND tl.LANGUAGE = USERENV('LANG')
ORDER BY b.CLASSIFICATION_CODE;

Another critical scenario involves data migration or initialization scripts, where translated values must be populated for each installed language. Queries against this table are also essential for debugging issues where code descriptions appear incorrectly or in the wrong language within tax reports or forms.

Related Objects

The ZX_FC_CODES_TL table has a direct and mandatory relationship with its base table, ZX_FC_CODES_B, which holds the language-independent attributes of the fiscal classification codes. The foreign key constraint ensures referential integrity between these two objects. This translation table is also referenced by various E-Business Tax APIs and views that present fiscal classification data to other modules, such as Oracle Receivables (AR) and Oracle Payables (AP), for tax calculation processes. While specific view names are not detailed in the provided metadata, it is standard for EBS to create views (often suffixed with '_V') that join base and translation tables to simplify application queries.

  • Table: ZX_FC_CODES_TL 12.2.2

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_FC_CODES_TL,  object_name:ZX_FC_CODES_TL,  status:VALID,  product: ZX - E-Business Tax ,  description: This table provides multilingual support (MLS) for each fiscal classification code. MLS enables you to store and print data that you define in multiple languages. ,  implementation_dba_data: ZX.ZX_FC_CODES_TL , 

  • Table: ZX_FC_CODES_TL 12.1.1

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_FC_CODES_TL,  object_name:ZX_FC_CODES_TL,  status:VALID,  product: ZX - E-Business Tax ,  description: This table provides multilingual support (MLS) for each fiscal classification code. MLS enables you to store and print data that you define in multiple languages. ,  implementation_dba_data: ZX.ZX_FC_CODES_TL , 

  • Table: ZX_FC_CODES_B 12.2.2

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_FC_CODES_B,  object_name:ZX_FC_CODES_B,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores fiscal classification code hierarchies for types of Document Sub Type, Intended Use, User Defined Fiscal Classification, Product Category, Transaction Business Category and Transaction Fiscal Classification categories. ,  implementation_dba_data: ZX.ZX_FC_CODES_B , 

  • Table: ZX_FC_CODES_B 12.1.1

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_FC_CODES_B,  object_name:ZX_FC_CODES_B,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores fiscal classification code hierarchies for types of Document Sub Type, Intended Use, User Defined Fiscal Classification, Product Category, Transaction Business Category and Transaction Fiscal Classification categories. ,  implementation_dba_data: ZX.ZX_FC_CODES_B ,