Search Results gmd_ss_variants_pk




Overview
Explore in AI Chat

Overview

GMD_SS_VARIANTS is a table within the Oracle E-Business Suite Process Manufacturing Product Development (GMD) module. It stores Stability Study Variants, which represent distinct configurations or execution paths of a stability study. A stability study defines how a product's characteristics change over time under defined storage conditions; a variant captures one particular arrangement of storage plan, sampling cadence, resource assignment, and specification defaults within that study. Each row therefore records a single schedulable variant belonging to a parent stability study.

The table resides in the GMD schema and is identified in ETRM 12.2.2 documentation as a VALID object with 63 columns. Under the heuristic Data Vault classification derived from foreign key mining, GMD_SS_VARIANTS is characterized as standalone, meaning it does not function cleanly as a hub, link, or pure satellite on its own. In modeling terms, it can be treated as a disconnected entity whose relationships are carried by its own foreign key references to parent studies, storage plans, and sampling events, rather than by an intermediate link table.

Key Information Stored

The primary key is the surrogate identifier VARIANT_ID, enforced by the unique index GMD_SS_VARIANTS_PK. No alternate unique index is documented, so business-key uniqueness on VARIANT_NO (the user-facing variant number) is not independently enforced at the database level.

Common Use Cases and Queries

Typical reporting joins variants to their parent study and storage plan to produce stability schedules.

  • List variants for a study: SELECT v.variant_no, v.scheduled_start_date FROM gmd_ss_variants v WHERE v.ss_id = :study_id;
  • Join to storage conditions: SELECT v.variant_no, d.* FROM gmd_ss_variants v, gmd_storage_plan_details d WHERE v.storage_plan_detail_id = d.storage_plan_detail_id;
  • Trace samples per variant: SELECT s.sample_no, v.variant_no FROM gmd_samples s, gmd_ss_variants v WHERE s.variant_id = v.variant_id;
  • Active-only listing using DELETE_MARK = 0.

Related Objects

  • GMD_STABILITY_STUDIES_B – parent study; join on SS_ID.
  • GMD_STORAGE_PLAN_DETAILS – storage condition definition; join on STORAGE_PLAN_DETAIL_ID.
  • GMD_SAMPLING_EVENTS – sampling event; join on SAMPLING_EVENT_ID and VARIANT_ID.
  • GMD_SAMPLES – samples generated for the variant; join on VARIANT_ID.
  • GMD_SS_TIME_POINTS – time-point schedule per variant; join on VARIANT_ID.
  • GMD_SS_STORAGE_HISTORY – storage history per variant; join on VARIANT_ID.