Search Results gmd_ss_material_sources




Overview
Explore in AI Chat

Overview

GMD_SS_MATERIAL_SOURCES is a Process Manufacturing Product Development table in the GMD schema that stores the material sources associated with stability studies. A stability study establishes the conditions and duration under which samples of a product or material are monitored for quality attributes over time. The material sources records define the specific plant, batch, lot, recipe, and sampling event from which the stability samples were drawn, thereby anchoring each study to the actual production or laboratory material that is being monitored.

The table is registered as VALID in Oracle EBS 12.1.1 and 12.2.2 and is owned by GMD. Its primary key is GMD_SS_MATERIAL_SOURCES_PK, defined on the SOURCE_ID column. The heuristic Data Vault classification mined from the foreign key structure is standalone, which suggests a modeling recommendation that this object behaves as an independent entity rather than being subsumed into a broader hub or satellite construct. In practical ETRM designs, it functions as a detail table linked to the parent stability study header.

Key Information Stored

The table contains fifty-four documented columns. The most significant include the following:

The only documented unique index is the primary key on SOURCE_ID; no additional business-key unique indexes are listed, although SS_ID combined with batch and lot attributes commonly forms a logical business key.

Common Use Cases and Queries

Typical reporting scenarios include retrieving all material sources for a given stability study, tracing a lot back to its stability studies, and reconciling sample quantities by plant or organization. A representative query joining the parent study follows:

  • SELECT s.SOURCE_ID, s.SS_ID, s.PLANT_CODE, s.BATCH_ID, s.LOT_NO, s.SAMPLE_QTY, s.SAMPLE_QTY_UOM FROM GMD_SS_MATERIAL_SOURCES s WHERE s.SS_ID = :study_id AND NVL(s.DELETE_MARK, 0) = 0;
  • Joining to GMD_RECIPES_B on RECIPE_ID to report the recipe associated with each stability sample.
  • Joining to GMD_SAMPLING_EVENTS on SAMPLING_EVENT_ID to analyze sampling frequency versus material sources.

Related Objects

  • GMD_STABILITY_STUDIES_B — parent header, joined on SS_ID.
  • GMD_RECIPES_B — recipe definition, joined on RECIPE_ID.
  • GMD_SAMPLING_EVENTS — sampling activity, joined on SAMPLING_EVENT_ID.

These relationships reflect the documented foreign keys and establish GMD_SS_MATERIAL_SOURCES as the traceability detail for stability studies within Process Manufacturing Product Development.