Results for “ss_id”

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

Overview

The GMD_STABILITY_STUDIES_TL table is the translation table for stability studies within the Oracle E-Business Suite Process Manufacturing Product Development (GMD) module. Stability studies are core quality and product-development records that track how a formulated product, lot, or sample behaves over time under defined storage conditions, supporting regulatory submissions, shelf-life determination, and specification compliance. Because Oracle EBS is deployed in multi-language environments, the descriptive content of a stability study — its name, description, and other user-facing text — must be translatable. The _TL suffix denotes precisely this role: the table stores the language-dependent (translated) attributes of a stability study, one row per installed language in which the study's text has been entered.

Under the heuristic Data Vault classification mined from the foreign-key structure, this object is treated as standalone. In Data Vault modeling terms, this suggests modeling GMD_STABILITY_STUDIES_TL as its own satellite or reference construct rather than as a dependent link, since the documented dependencies do not resolve into a parent-child FK chain within the mined scope. It should not be treated as a hub. The primary key GMD_STABILITY_STUDIES_TL_PK is composite, spanning SS_ID and LANGUAGE, which enforces exactly one translated row per study per language.

Key Information Stored

The table contains nine documented columns. The most important are:

• SS_ID — The stability study identifier. This is the surrogate/foreign key that links each translated row back to its base stability study record. Together with LANGUAGE, it forms the composite primary key GMD_STABILITY_STUDIES_TL_PK.
• LANGUAGE — The installed language code for the translated row. The pairing of SS_ID and LANGUAGE is the unique business-key candidate documented via the unique index.
• SOURCE_LANG — The source language of the translation, indicating the language from which the description was derived.
• DESCRIPTION — The translated descriptive text of the stability study. This is the principal user-facing attribute carrying the language-specific content.
• CREATION_DATE, CREATED_BY — Standard audit columns recording when the translation row was created and by which user.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Audit columns capturing the most recent modification, the responsible user, and the login under which it occurred.

The primary key is the composite surrogate of SS_ID plus LANGUAGE; the documented business-key candidate is the same unique index GMD_STABILITY_STUDIES_TL_PK. The audit columns are generic Oracle EBS WHO columns and do not form part of any business key.

Common Use Cases and Queries

Typical usage centers on multilingual reporting and resolving the correct translated description for a given study. A common query retrieves the translated description for a specified language:

• Join GMD_STABILITY_STUDIES_TL to its base study table on SS_ID and filter by LANGUAGE = USERENV('LANG') or an explicit language code to present study text in the session language.
• Audit queries examining LAST_UPDATED_BY, LAST_UPDATE_DATE, and SOURCE_LANG to track translation maintenance and identify rows pending update.
• Completeness checks confirming that every active SS_ID has a translation row for each installed language.
• Regulatory and quality reporting that must output study descriptions in the language of the submission locale.

A representative pattern joins the base and translation tables on SS_ID and constrains LANGUAGE to the desired locale, selecting DESCRIPTION as the output text.

Related Objects

The most significant related objects are the base (non-translated) stability study table and the language reference objects that the LANGUAGE and SOURCE_LANG values depend upon:

• GMD_STABILITY_STUDIES_B — The base table holding language-independent stability study data, joined to this table on SS_ID.
• GMD_STABILITY_STUDIES_VL — The translated view typically layered over the base and _TL tables, exposing the current-language description.
• FND_LANGUAGES — The language reference table validating LANGUAGE and SOURCE_LANG values.
• GMD_STABILITY_STUDIES_TL_PK — The unique index enforcing the composite SS_ID and LANGUAGE key.
• FND_TERRITORIES and associated FND language/territory objects — supporting locale resolution for reporting.

These relationships follow the documented primary-key join pattern on SS_ID and the standard EBS translation architecture, in which a _B base table, a _TL translation table, and a _VL view together expose fully localized content.