Search Results fnd_irep_classes_tl_u1

Overview

APPLSYS.FND_IREP_CLASSES_TL is the translation (TL) table for the Oracle E-Business Suite Internet Reporting (IREP) classes table, FND_IREP_CLASSES_B. It stores the language-dependent display attributes for each reporting class defined in the EBS environment. The table resides in the APPLSYS schema, carries FND design data reference FND.FND_IREP_CLASSES_TL, and is held in the APPS_TS_SEED tablespace with PCTFREE 10, consistent with its role as a seeded reference data structure maintained by Oracle rather than by end users.

In the Oracle EBS multilanguage architecture, a _TL table works in tandem with its base (_B) table. One row exists per class per installed language, allowing the same reporting class to present translated display names and descriptions according to the session language of the connected user. The object holds a status of VALID and is classified in the ETRM metadata as a standalone table with no outgoing foreign keys to other business entities, other than the governance reference to FND_SECURITY_GROUPS through SECURITY_GROUP_ID. From a Data Vault modeling perspective, the heuristic classification of this object is standalone; in practice it functions as a language-dependent satellite of the base FND_IREP_CLASSES_B entity, qualified by the LANGUAGE and ZD_EDITION_NAME components of its unique key.

Key Information Stored

The table's primary identifier is composed of CLASS_ID and LANGUAGE, with ZD_EDITION_NAME present in the documented 12.2.2 physical schema as a further partitioning attribute. The unique index FND_IREP_CLASSES_TL_U1 enforces uniqueness across CLASS_ID and LANGUAGE, and in the 12.2.2 schema across ZD_EDITION_NAME as well. This index constitutes the principal business-key candidate for the table; CLASS_ID itself is the numeric surrogate key that links the row back to the base entity.

• CLASS_ID — The numeric identifier of the reporting class. Documented as the primary key component and as part of the unique index.
• LANGUAGE — The language code in which the display attributes are expressed; part of the unique index.
• SOURCE_LANG — The language from which the row was translated, supporting the standard EBS translation lifecycle.
• DISPLAY_NAME — The translatable name of the reporting class shown to the user, up to 240 characters.
• SHORT_DESCRIPTION — A lengthier, translatable description of the class, up to 2000 characters.
• SECURITY_GROUP_ID — Governance column linked to FND_SECURITY_GROUPS, used to scope the row within the security model.
• Standard who columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN capture the audit trail for each translated row.
• ZD_EDITION_NAME — Editioning attribute present in the documented 12.2.2 schema, supporting the Edition-Based Redefinition model.

Common Use Cases and Queries

Reporting on the classes available for Internet Reporting typically requires joining the translation table back to the base table and filtering by the active language so that display text is rendered correctly. A representative query retrieves the class, its identifier, and the translated name and description:

SELECT t.CLASS_ID, t.LANGUAGE, t.DISPLAY_NAME, t.SHORT_DESCRIPTION FROM APPLSYS.FND_IREP_CLASSES_TL t WHERE t.LANGUAGE = USERENV('LANG');

Administrators and support analysts use this data to verify which reporting classes are seeded, to audit translation coverage by comparing row counts per language, and to confirm that each class in FND_IREP_CLASSES_B has a corresponding translated row. Because the table is seeded in APPS_TS_SEED, direct DML is generally discouraged; changes to display text should flow through the language installation and patch mechanisms.

Related Objects

• APPLSYS.FND_IREP_CLASSES_B — The base table supplying the language-independent columns; joined on CLASS_ID.
• APPLSYS.FND_IREP_CLASSES_VL — The multilingual view that unions base and translation data for query access.
• FND_SECURITY_GROUPS — Referenced through SECURITY_GROUP_ID for security governance.
• APPLSYS.FND_IREP_CLASSES_TL_U1 — The unique index enforcing uniqueness across CLASS_ID, LANGUAGE, and ZD_EDITION_NAME.
• FND_LANGUAGES — Provides the valid values against which LANGUAGE and SOURCE_LANG are interpreted.
• FND_IREP_OBJECTS — Separately maintains the reporting objects associated with each class at the base level.