Search Results sy_reas_cds_b




Overview
Explore in AI Chat

Overview

The GMP_RSRC_UNAVAIL_MAN table is a core data object within the Oracle E-Business Suite (EBS) Process Manufacturing Process Planning (GMP) module. It functions as the repository for manually entered records that define periods of unavailability for manufacturing resources. This table is critical for accurate capacity planning and scheduling, as it allows planners to account for scheduled downtime, maintenance, or other planned outages that would prevent a resource from being used in production. By capturing these manual unavailability entries, the system ensures that finite capacity planning calculations reflect true resource availability, preventing the scheduling of jobs during known downtime periods.

Key Information Stored

While the provided ETRM metadata does not list specific columns beyond the foreign keys, the table's purpose and relationships indicate it stores data to define a discrete unavailability event. Based on standard GMP schema patterns, key columns likely include a unique identifier (e.g., UNAVAIL_ID), the RESOURCE_ID linking to the specific manufacturing resource (CR_RSRC_DTL), and a REASON_CODE classifying the cause of unavailability (linked to SY_REAS_CDS_B). Other probable columns are START_DATE and END_DATE to define the duration of the outage, and standard WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE) for auditing. The "Manual Entries" description distinguishes these records from system-generated or calculated unavailability.

Common Use Cases and Queries

The primary use case is the management and reporting of planned resource downtime. Planners create, update, or delete records in this table via the GMP application interface to maintain an accurate availability calendar. Common reporting needs include generating a schedule of all upcoming maintenance windows or analyzing historical downtime by reason code. A typical query would join to related tables to make the data meaningful:

  • Listing Manual Unavailability for a Resource: SELECT g.start_date, g.end_date, s.reason_name FROM gmp_rsrc_unavail_man g, sy_reas_cds_b s WHERE g.reason_code = s.reason_code AND g.resource_id = :p_resource_id ORDER BY g.start_date;
  • Capacity Analysis: Queries often aggregate data from this table with scheduled jobs from other GMP tables to calculate net available capacity over a given time horizon.

Related Objects

The GMP_RSRC_UNAVAIL_MAN table maintains defined foreign key relationships with two other EBS tables, as documented in the metadata:

  • CR_RSRC_DTL (via GMP_RSRC_UNAVAIL_MAN.RESOURCE_ID): This is the master table for resources (e.g., equipment, labor) in Process Manufacturing. The join ensures each unavailability entry is associated with a valid, defined resource.
  • SY_REAS_CDS_B (via GMP_RSRC_UNAVAIL_MAN.REASON_CODE): This is a generic EBS table that stores reason codes used across various modules. The relationship standardizes the categorization of unavailability reasons (e.g., "Preventive Maintenance," "Calibration," "Holiday"). The user's search for "sy_reas_cds_b" is directly relevant to understanding the reason code values populating this table.