Search Results gmp_resource_instances




Overview
Explore in AI Chat

Overview

GMP_RESOURCE_INSTANCES is a table in the GMP schema (Process Manufacturing Process Planning) within Oracle E-Business Suite 12.1.1 and 12.2.2. As its description indicates, it stores Resource Instances—the discrete, individually tracked physical units or pieces of equipment belonging to a defined process manufacturing resource. Where a resource such as a machine type or mixing vessel is defined generically, this table records the actual serialized instances of that resource, capturing their identity, vendor, model, calibration, maintenance, and certification state.

The object is owned by the GMP schema and carries a documented physical schema of 58 columns in ETRM 12.2.2. The ETRM data vault classification for this object is standalone, meaning it is not modeled as a hub, link, or satellite in the heuristic FK structure. From a modeling-suggestion perspective, it behaves as a self-contained reference/master entity rather than a component of a normalized data vault, and its relationships are expressed through its own business keys rather than through documented foreign keys to dependent tables.

Key Information Stored

Common Use Cases and Queries

The primary use case is resource-instance resolution during process planning and execution: given a resource, determine which serialized instance is valid, calibrated, and certified before scheduling or releasing a batch. Typical operational reporting checks calibration and certification currency to enforce compliance and to flag instances approaching expiry.

A common query selects active, in-date instances for a resource:

  • SELECT instance_number, equipment_item_id, eqp_serial_number, next_calibration_date FROM gmp_resource_instances WHERE resource_id = :resource_id AND inactive_ind = 'N' AND TRUNC(SYSDATE) BETWEEN eff_start_date AND NVL(eff_end_date, SYSDATE);

Compliance and maintenance dashboards frequently group by calibration horizon:

  • SELECT equipment_item_id, eqp_serial_number, next_calibration_date FROM gmp_resource_instances WHERE next_calibration_date <= :horizon AND inactive_ind = 'N' ORDER BY next_calibration_date;

Reporting may also join to inventory or resource master data using EQUIPMENT_ITEM_ID and RESOURCE_ID, and pivot the ATTRIBUTE1–ATTRIBUTE30 columns where client-specific DFF segments carry additional tracking values.

Related Objects

The ETRM relationship data classifies this object as standalone, meaning no documented FK links exist within the mined structure. Logical associations implied by its columns include:

  • Resource master — joined on RESOURCE_ID to relate the instance to its generic process resource.
  • Equipment/inventory items — joined on EQUIPMENT_ITEM_ID (the PK component) to the associated item definition.
  • Vendor master — joined on VENDOR_ID for supplier attribution.
  • Calibration items — joined on CALIBRATION_ITEM_ID to calibration schedule definitions.
  • Setup references — joined on LAST_SETUP_ID to the setup record governing the instance.
  • Serialized equipment / eAM objects — correlated on EQP_SERIAL_NUMBER where serialized asset tracking is maintained.

The precise physical join columns are documented only for the primary key (EQUIPMENT_ITEM_ID, EQP_SERIAL_NUMBER) and the RESOURCE_ID association; other relationships should be validated against the specific implementation's data model.