Search Results gmd_formulation_specs

Overview

GMD.GMD_FORMULATION_SPECS is the master specification table within the Oracle Process Manufacturing (OPM) Product Development module (GMD). It stores formulation specifications that define the composition rules and constraints for manufacturing a product. Each record represents a controlled formulation specification version, capturing ingredient quantity requirements, acceptable ingredient count ranges, expected process loss, and optional technical parameter criteria used to select or validate a formulation. In Oracle EBS 12.1.1 and 12.2.2, this table underpins formulation development, specification management, and the linkage between product definitions and shop-floor routing.

Its heuristic Data Vault classification, mined from the foreign key structure, is standalone. This suggests that, in a modeling context, GMD_FORMULATION_SPECS behaves primarily as an independent reference/specification entity rather than as a classic hub or link with an extensive downstream FK web. It also exhibits characteristics of a versioned satellite, since each specification is name- and version-qualified and tied to a product. The table belongs to schema GMD and is documented with 25 physical columns in ETRM 12.2.2.

Key Information Stored

The surrogate primary key is FORMULATION_SPEC_ID, a system-generated identifier for each specification record. Business-key candidates include the combination of SPEC_NAME and SPEC_VERS, optionally scoped by OWNER_ORGANIZATION_ID, which establishes the owning organization context for the specification.

The most significant columns include:

• SPEC_NAME and SPEC_VERS — the specification name and version number defining identity and change management.
• PRODUCT_ID — foreign key to FND_DM_PRODUCTS, identifying the product to which the formulation applies.
• SPEC_STATUS — the lifecycle state of the specification (for example, draft versus approved/active).
• STD_QTY and STD_UOM — the standard batch quantity and unit of measure for the formulation.
• PROCESS_LOSS — expected loss percentage during processing.
• MIN_INGREDS and MAX_INGREDS — allowable ingredient count range.
• INGRED_PICK_BASE_IND and PICK_LOT_STRATEGY — control flags governing how ingredient lots are selected.
• TECH_PARM_ID — foreign key to GMD_TECH_PARAMETERS_B, linking the specification to technical parameter definitions.
• START_DATE and END_DATE — the effective date range of the specification.
• OBJECTIVE_IND — an indicator marking the objective or preferred specification.
• ROUTING_ID — linkage to routing information.
• DELETE_MARK — the standard soft-delete flag; audit columns include CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, and LAST_UPDATE_LOGIN.

Common Use Cases and Queries

Typical reporting and integration scenarios include retrieving active specifications for a product, comparing versions, and validating ingredient count constraints. A sample query to list approved specifications for a product is:

• SELECT fs.SPEC_NAME, fs.SPEC_VERS, fs.SPEC_STATUS, fs.STD_QTY, fs.STD_UOM FROM GMD.GMD_FORMULATION_SPECS fs WHERE fs.PRODUCT_ID = :product_id AND fs.SPEC_STATUS = 'APPROVED' AND fs.DELETE_MARK = 0;

Additional use cases include joining to FND_DM_PRODUCTS to resolve product names, joining to GMD_TECH_PARAMETERS_B to report on technical parameter criteria, and filtering by START_DATE/END_DATE to identify currently effective specifications. Specification-driven analysis of process loss and pick strategy supports production planning and cost estimation.

Related Objects

The most significant related objects, based on documented foreign key relationships, are:

• FND_DM_PRODUCTS — joined via GMD_FORMULATION_SPECS.PRODUCT_ID = FND_DM_PRODUCTS.PRODUCT_ID, supplying the product definition.
• GMD_TECH_PARAMETERS_B — joined via GMD_FORMULATION_SPECS.TECH_PARM_ID = GMD_TECH_PARAMETERS_B.TECH_PARM_ID, providing technical parameter definitions.
• GMD_SPEC_VERSIONS — version-level detail associated with each specification.
• GMD_FORMULATION_SPEC_DTL / formulation ingredient tables — the ingredient-level detail that realizes the specification.
• GMD_ROUTINGS_B — routing definitions referenced through ROUTING_ID.

These relationships make GMD_FORMULATION_SPECS a central reference point linking product development specifications to ingredient and routing data within the GMD module.