Search Results mr_shdy_dtl




Overview
Explore in AI Chat

Overview

The MR_SHDY_DTL table is a core data object within the Oracle E-Business Suite (EBS) Process Manufacturing Process Planning (GMP) module. It functions as the detail table for shop day definitions, storing granular information about specific shifts within a defined shop day. In the context of process manufacturing planning, a shop day represents a working period, which is further broken down into operational shifts. This table, therefore, is critical for modeling the detailed calendar and capacity of production facilities, enabling precise scheduling, resource allocation, and throughput calculations within the manufacturing process flow.

Key Information Stored

The table's primary structure is defined by its composite primary key, which consists of SHOPDAY_NO and SHIFT_NO. This design enforces the relationship that a single shop day header can have multiple detail records for its constituent shifts. While the provided metadata does not list all columns, the foreign key relationships indicate other critical data points. The SHOPDAY_NO column links the detail record to its parent header in the MR_SHDY_HDR table. The TEXT_CODE column provides a link to descriptive text or notes stored in the MR_TEXT_HDR table, allowing for additional shift-specific instructions or comments. Typical data held would include shift start and end times, efficiency factors, and capacity parameters for the specific time period.

Common Use Cases and Queries

This table is primarily accessed for capacity planning, detailed production scheduling, and shop floor calendar maintenance. A common operational query would involve joining to the header table to retrieve a complete shop calendar for a given facility or production line. For example, a planner might run a report to list all shifts for the upcoming week. A typical SQL pattern would be:

  • SELECT hdr.shopday_name, dtl.shift_no, dtl.start_time, dtl.end_time FROM gmp.mr_shdy_dtl dtl, gmp.mr_shdy_hdr hdr WHERE dtl.shopday_no = hdr.shopday_no AND hdr.organization_id = :org_id ORDER BY hdr.shopday_no, dtl.shift_no;

This data is essential for generating finite schedules and calculating available working hours for resources, which feeds into Material Requirements Planning (MRP) and detailed scheduling engines within GMP.

Related Objects

The MR_SHDY_DTL table has defined dependencies within the GMP schema, as indicated by its foreign keys. Its primary relationship is with the MR_SHDY_HDR table, which contains the master definition of the shop day (e.g., date, organization). This establishes a classic header-detail relationship. Furthermore, its link to the MR_TEXT_HDR table allows for flexible, multilingual descriptive text associated with each shift. The table is also likely referenced by various GMP planning and scheduling APIs, programs, and forms that manage shop floor calendars and capacity. Understanding these relationships is crucial for any data extraction, integration, or customization effort involving manufacturing calendars in Oracle EBS Process Manufacturing.