Search Results ps_schd_hdr




Overview
Explore in AI Chat

Overview

The PS_SCHD_HDR table is a core data object within the Oracle E-Business Suite Process Manufacturing (GMP) module, specifically for the Process Planning sub-module. It functions as the primary header table for production schedules. In the context of manufacturing operations, a schedule defines the plan for producing batches or lots of a product. This table stores the master definition and controlling attributes for each unique schedule, serving as the parent record for detailed scheduling components. Its existence is critical for the planning, execution, and tracking of manufacturing processes within Oracle EBS.

Key Information Stored

The table's structure is anchored by its primary key, SCHEDULE_ID, which uniquely identifies each schedule record. A significant alternate unique key is the combination of ORGN_CODE and SCHEDULE, indicating that within a specific operating unit (organization), the schedule name or identifier must be unique. The ORGN_CODE column itself is a foreign key to the organization master tables (SY_ORGN_MST and SY_ORGN_MST_B), tying the schedule to a specific manufacturing entity. Another notable column is TEXT_CODE, which links to the PS_TEXT_HDR table, allowing for the storage of descriptive notes or instructions associated with the schedule header.

Common Use Cases and Queries

This table is central to scheduling-related inquiries and reporting. Common operational scenarios include retrieving all active schedules for a given organization, listing schedules by product or date range, and generating high-level schedule summaries for management review. A typical query pattern involves joining PS_SCHD_HDR with organization and detail tables to provide a comprehensive view.

  • Basic Schedule Listing: SELECT schedule_id, orgn_code, schedule FROM gmp.ps_schd_hdr WHERE orgn_code = :org_id ORDER BY schedule;
  • Schedule Header with Organization Name: SELECT sh.schedule_id, sh.schedule, sh.orgn_code, om.orgn_name FROM gmp.ps_schd_hdr sh, sy_orgn_mst om WHERE sh.orgn_code = om.orgn_code;
  • Identifying Schedules with Associated Details: SELECT DISTINCT h.schedule_id, h.schedule FROM gmp.ps_schd_hdr h INNER JOIN gmp.ps_schd_dtl d ON h.schedule_id = d.schedule_id;

Related Objects

As a header table, PS_SCHD_HDR has numerous dependent child tables that store the specifics of the schedule, forming a key data hierarchy. The primary foreign key relationships, as documented, are:

  • PS_SCHD_DTL: The main detail table, containing the individual lines or steps of the schedule.
  • PS_SCHD_FOR: Likely stores forecast or demand data linked to the schedule.
  • MR_PARM_DTL and MR_SIZE_TBL: Manufacturing-related parameter and size tables that reference the schedule.
  • PS_TEXT_HDR: Provides descriptive text via the TEXT_CODE foreign key.
  • SY_ORGN_MST / SY_ORGN_MST_B: Master tables defining the organization to which the schedule belongs.

Any data extraction or integration effort concerning process manufacturing schedules must begin with this header table and navigate through these related objects to build a complete picture.