Search Results gmd_stability_studies_b




Overview
Explore in AI Chat

Overview

GMD_STABILITY_STUDIES_B is the base table that stores stability study definitions within the Oracle E-Business Suite Process Manufacturing Product Development module (GMD). A stability study describes a formal program for monitoring how a formulated product, item, or specification behaves over time under defined storage conditions, packaging configurations, and test intervals. This information supports shelf-life determination, regulatory submissions, and quality dispositioning. The table resides in the GMD schema and is documented as a valid object in both 12.1.1 and 12.2.2, with a physical schema of 68 columns in the 12.2.2 ETRM reference.

The heuristic Data Vault classification mined from the foreign key structure is standalone. In Data Vault modeling terms, this suggests the table functions primarily as a hub-like or independent entity rather than a pure link or satellite. Its relationships to other objects are driven principally through its surrogate key and organizational business key rather than through dense foreign key chains, which is consistent with a master definition object referenced by subordinate detail tables.

Key Information Stored

The table is anchored by the surrogate primary key SS_ID, defined through GMD_STABILITY_STUDIES_B_PK. A second unique index, GMD_STABILITY_STUDIES_B_U1, enforces the business-key combination of ORGN_CODE and SS_NO, meaning a stability study number is unique within an organization. Among the most operationally significant columns are:

Standard EBS audit columns (CREATION_DATE, CREATED_BY, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN), a DELETE_MARK flag, descriptive flexfield columns ATTRIBUTE1 through ATTRIBUTE30, and MIGRATED_IND are also present.

Common Use Cases and Queries

Quality and product development teams query this table to track active stability programs, evaluate study timelines, and report shelf-life outcomes. A typical query retrieves active studies for a given organization:

SELECT ss_no, item_id, status, scheduled_end_date
FROM gmd.gmd_stability_studies_b
WHERE orgn_code = :orgn_code AND delete_mark = 0 AND status = 'ACTIVE';

Where shelf-life trending is required, reports aggregate RECOMMENDED_SHELF_LIFE by ITEM_ID. Because child tables such as GMD_SS_VARIANTS and GMD_SS_MATERIAL_SOURCES join on SS_ID, standard extract patterns begin from this base table and expand into the variant and material-source details.

Related Objects

The following objects participate most directly in the stability study data model:

  • GMD_STORAGE_PLANS_B — referenced by GMD_STABILITY_STUDIES_B.STORAGE_PLAN_ID.
  • GMD_SS_VARIANTS — references GMD_STABILITY_STUDIES_B.SS_ID.
  • GMD_SS_MATERIAL_SOURCES — references GMD_STABILITY_STUDIES_B.SS_ID.

These child relationships, combined with the primary-key and alternate-key indexes, make GMD_STABILITY_STUDIES_B the central definition point for stability study processing in Process Manufacturing Product Development.