Results for “css_def_languages_b”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

CSS_DEF_LANGUAGES_B is documented in the Oracle E-Business Suite ETRM repository as the base table for Supported Languages within the CSS – Support product module. The CSS module is identified in the metadata as obsolete, which is a material consideration for any analysis: implementations on Oracle EBS 12.1.1 or 12.2.2 may retain the object as a residual schema artifact, but it is not actively maintained. The metadata explicitly states "Not implemented in this database," indicating the table is either absent or empty on the reference instance from which the ETRM entry was generated.

The table functions as a language definition repository, storing supported language records keyed by a surrogate identifier. Its role is that of a reference or lookup table: it consolidates language entries used by dependent transactional and configuration entities. A heuristic Data Vault classification mined from the foreign key structure characterizes this table as satellite-leaning. In modeling terms, this suggests treating it as a descriptive satellite attached to a language hub, where LANGUAGE_ID supplies the durable key and ancillary descriptive attributes (such as the FND language code) provide the context that changes independently of the parent hub.

Key Information Stored

The metadata identifies a limited set of columns; the following are the documented structural elements rather than an exhaustive column listing.

• LANGUAGE_ID — The primary key column forming the CSS_DEF_LANGUAGES_B_PK constraint. This is the surrogate identifier and the join target for all dependent tables. It is the single most important column in the table and the column referenced by every inbound foreign key listed in the relationship data.
• FND_LANGUAGE_CODE — A foreign key column referencing FND_LANGUAGES, the Oracle Application Object Library table that holds installed language definitions. This column is the business-key linkage to the EBS language framework and establishes the semantic identity of each supported language.

The primary key CSS_DEF_LANGUAGES_B_PK is defined on LANGUAGE_ID, which is therefore the surrogate key. FND_LANGUAGE_CODE is documented as a foreign key to FND_LANGUAGES, and can serve as a business-key candidate in combination with LANGUAGE_ID depending on whether a unique constraint was deployed on that column. The ETRM metadata does not enumerate additional descriptive columns such as language name or territory code, so no further attributes should be assumed without inspecting the actual database dictionary.

Common Use Cases and Queries

Because the table is obsolete and unimplemented in the reference database, the primary practical use cases involve impact assessment and dependency analysis rather than new development. A common diagnostic query resolves the language code through the FND_LANGUAGES join:

• Join pattern: CSS_DEF_LANGUAGES_B cd LEFT JOIN FND_LANGUAGES fl ON fl.LANGUAGE_CODE = cd.FND_LANGUAGE_CODE to translate surrogate language identifiers into human-readable language names.
• Referential integrity audits: identify orphaned rows in dependent tables such as OTA_EVENTS or CS_INCIDENTS_AUDIT_B whose LANGUAGE_ID no longer resolves in CSS_DEF_LANGUAGES_B.
• Data migration and purge validation: determine whether the table is populated before removing legacy CSS objects during an upgrade from 12.1.1 to 12.2.2.
• Reporting: reconstruct supported-language lists for downstream modules that rely on this table as their definition source.

Related Objects

The relationship metadata identifies a broad reference set, indicating that many modules consume language identifiers from this table.

• FND_LANGUAGES — referenced via CSS_DEF_LANGUAGES_B.FND_LANGUAGE_CODE; the authoritative EBS language registry.
• CSS_DEF_DEF_LANGUAGES — references LANGUAGE_ID, a companion CSS definition table.
• FND_CONCURRENT_REQUESTS — carries LANGUAGE_ID, linking concurrent program execution to language context.
• CS_INCIDENTS_AUDIT_B — audit table referencing LANGUAGE_ID for incident records.
• OTA_EVENTS, OTA_OFFERINGS, OTA_ACTIVITY_VERSIONS, OTA_LEARNING_OBJECTS, OTA_COMPETENCE_LANGUAGES, OTA_DELEGATE_BOOKINGS — the Oracle Training Administration family, all referencing LANGUAGE_ID.
• IES_SVY_RESOURCES — survey resource table referencing LANGUAGE_ID.

The wide inbound reference surface contrasts with the table's obsolete status, a situation that warrants verification against the target instance before any retirement or refactoring decision.