Search Results mr_shcl_hdr




Overview
Explore in AI Chat

Overview

The MR_SHCL_HDR table is a core data structure within the Oracle E-Business Suite (EBS) Process Manufacturing Process Planning (GMP) module. It functions as the shop calendar header, serving as the master definition for a production calendar. In manufacturing and process planning, a shop calendar defines the working days, shifts, and available production time for a specific plant, production line, or resource. This calendar is fundamental for scheduling production orders, calculating lead times, and performing capacity planning. The table's integrity is maintained by the primary key MR_SHCL_HDR_PK, ensuring each calendar definition is uniquely identified.

Key Information Stored

The table's primary identifier is the CALENDAR_ID column. A critical structural aspect of MR_SHCL_HDR is its representation of a standard work week, which is implemented through seven foreign key columns: DAY1, DAY2, DAY3, DAY4, DAY5, DAY6, and DAY7. Each of these columns references a specific day definition in the MR_SHDY_HDR (Shop Day Header) table, allowing for the flexible construction of a repeating weekly pattern. Furthermore, the table includes a TEXT_CODE column, which provides a foreign key link to the MR_TEXT_HDR table. This enables the association of descriptive, translatable text with the calendar definition, supporting multi-language implementations.

Common Use Cases and Queries

The primary use case for MR_SHCL_HDR is the creation and maintenance of shop calendars, which are then applied to resources or production lines for scheduling purposes. A common reporting requirement is to list all defined calendars along with their associated day patterns. A typical query would join MR_SHCL_HDR with MR_SHDY_HDR to resolve the day names. For example:

  • SELECT h.calendar_id, d1.day_code AS Monday, d2.day_code AS Tuesday FROM gmp.mr_shcl_hdr h JOIN gmp.mr_shdy_hdr d1 ON h.day1 = d1.day_id JOIN gmp.mr_shdy_hdr d2 ON h.day2 = d2.day_id;

Another critical scenario involves validating scheduling data. When a production schedule appears to violate calendar constraints, technicians may trace the CALENDAR_ID from a scheduling entity back to MR_SHCL_HDR to review the defined working days.

Related Objects

MR_SHCL_HDR is a central hub with several key relationships. It is the parent table for MR_SHCL_DTL (Shop Calendar Detail), which likely holds exceptions to the standard weekly pattern, such as holidays or special shifts. The foreign key to MR_TEXT_HDR manages descriptive text. Crucially, the calendar is referenced by scheduling execution tables, most notably PS_SCHD_DTL. The MR_MESG_TBL table also references MR_SHCL_HDR via CALENDAR_ID, indicating the calendar's use in messaging or transactional contexts. The seven individual foreign keys to MR_SHDY_HDR establish the foundational weekly template for the shop calendar.