Search Results gmp_rsrc_excp_dtl




Overview
Explore in AI Chat

Overview

The GMP_RSRC_EXCP_DTL table is a core data object within the Oracle E-Business Suite (EBS) Process Manufacturing Process Planning (GMP) module. It functions as the detailed transaction table for recording and managing resource-related exceptions that occur during manufacturing operations. In the context of Oracle EBS 12.1.1 and 12.2.2, this table plays a critical role in capturing granular data about deviations from planned resource usage, such as machine downtime, labor inefficiencies, or material consumption variances. By storing these exception details, it provides the necessary audit trail and data foundation for analyzing production performance, identifying bottlenecks, and facilitating corrective actions within a process manufacturing environment.

Key Information Stored

While the provided ETRM metadata does not list specific columns, the table's name and foreign key relationships define its primary data elements. As the "Exception Details Table," it stores line-level records for each resource exception. The key columns typically include a unique detail identifier, a foreign key (EXCEPTION_ID) linking to the parent header record in the GMP_RSRC_EXCP_HDR table, and a foreign key (REASON_CODE) linking to a standard reason code in the SY_REAS_CDS_B table. Additional columns would capture specifics such as the resource identifier, operation sequence, the actual versus planned quantity or hours, the variance amount, transaction dates, and references to the associated work order or batch. This structure allows for a detailed breakdown of why and how a resource plan was not met.

Common Use Cases and Queries

This table is central to exception-based reporting and operational analysis in Process Manufacturing. Common use cases include generating detailed variance reports for a specific production batch, analyzing recurring resource downtime patterns by reason code, and calculating overall equipment effectiveness (OEE) metrics. A typical analytical query would join this detail table to its header and reason code tables to produce a comprehensive exception report.

  • Sample Query Pattern:
    SELECT hdr.batch_no, dtl.resource_code, rcd.reason_name, dtl.variance_quantity
    FROM gmp_rsrc_excp_dtl dtl,
    gmp_rsrc_excp_hdr hdr,
    sy_reas_cds_b rcd
    WHERE dtl.exception_id = hdr.exception_id
    AND dtl.reason_code = rcd.reason_code
    AND hdr.organization_id = :p_org_id
    AND hdr.exception_date BETWEEN :p_from_date AND :p_to_date;

Related Objects

The GMP_RSRC_EXCP_DTL table exists within a defined relational schema, primarily interacting with two key objects as confirmed by the ETRM metadata.

  • GMP_RSRC_EXCP_HDR: This is the parent header table. Each detail record in GMP_RSRC_EXCP_DTL must correspond to a single header record via the EXCEPTION_ID foreign key. The header typically stores batch-level information and summary data.
  • SY_REAS_CDS_B (Standard Reason Codes): This is a foundational EBS table that provides a standardized list of reason codes across various modules. The REASON_CODE foreign key in the detail table ensures that every exception is categorized using a controlled vocabulary, enabling consistent reporting and analysis.