Search Results mr_shdy_hdr




Overview
Explore in AI Chat

Overview

The MR_SHDY_HDR table is a core data object within the Oracle E-Business Suite (EBS) Process Manufacturing (GMP) module, specifically for Process Planning. It functions as the master header table for defining and storing shop day calendars. In manufacturing planning, a shop day calendar defines the operational working days and shifts for a production facility, which is critical for accurate scheduling, capacity planning, and material requirement calculations. This table provides the foundational definition upon which detailed shift schedules and specific shop calendar assignments are built, enabling the system to differentiate between working and non-working days for production activities.

Key Information Stored

The primary data stored in MR_SHDY_HDR revolves around the unique identification and description of a shop day calendar. The table's structure, as indicated by its primary and foreign key relationships, centers on the SHOPDAY_NO column, which serves as the unique identifier (Primary Key: MR_SHDY_HDR_PK) for each calendar. Another significant column is TEXT_CODE, which forms a foreign key relationship to the FM_TEXT_HDR table. This link is standard in Oracle EBS for associating descriptive, translatable text notes or comments with the shop day definition, allowing for detailed explanations or instructions regarding the calendar's use.

Common Use Cases and Queries

This table is primarily accessed during master data setup for process manufacturing and during runtime scheduling operations. A common use case is the creation and maintenance of shop calendars, which are then assigned to production lines or resources. For reporting and integration, typical queries involve joining this header to its detail lines or related shop calendar tables. A fundamental query to retrieve a list of all defined shop day calendars with their associated descriptive text would be:

  • SELECT msdh.shopday_no, fth.text
    FROM gmp.mr_shdy_hdr msdh,
    fnd.fm_text_hdr fth
    WHERE msdh.text_code = fth.text_code(+);

Another critical pattern involves validating the existence of a shop day calendar before assigning it to a production schedule or checking its utilization across the system by joining to dependent tables like MR_SHCL_HDR.

Related Objects

The MR_SHDY_HDR table is central to a network of related objects within the GMP schema. Its primary foreign key relationships, as documented, are:

  • MR_SHDY_DTL: The detail table (MR_SHDY_DTL.SHOPDAY_NO) that holds specific shift definitions (e.g., start time, end time) for each shop day calendar.
  • MR_SHCL_HDR: The shop calendar header table, which references MR_SHDY_HDR multiple times (via columns DAY1 through DAY7). This structure allows a weekly shop calendar to be composed of specific shop day definitions for each day of the week.
  • MR_SHCL_DTL: Another detail table (MR_SHCL_DTL.SHOPDAY_NO) that likely provides further assignment or exception details for shop days within a calendar.
  • FM_TEXT_HDR: A cross-module table for descriptive text (MR_SHDY_HDR.TEXT_CODE), demonstrating integration with the EBS foundation layer.