Search Results ps_schd_for




Overview
Explore in AI Chat

Overview

The PS_SCHD_FOR table is a core intersection table within the Oracle E-Business Suite Process Manufacturing (GMP) module, specifically for Process Planning. Its primary function is to manage the many-to-many association between production schedules and forecasts. This association is critical for aligning production planning activities with demand projections, enabling process manufacturers to ensure material and capacity availability meets forecasted requirements. The table acts as a relational bridge, linking the schedule header (PS_SCHD_HDR) with the forecast header (FC_FCST_HDR), thereby integrating the planning and scheduling components of the GMP application.

Key Information Stored

The table's structure is defined by its composite primary key, which consists of two columns that serve as foreign keys to related master entities. The SCHEDULE_ID column uniquely identifies a specific production schedule, while the FORECAST_ID column uniquely identifies a specific demand forecast. The association record itself does not typically store quantitative data; its existence denotes the linkage. An additional TEXT_CODE column provides a foreign key reference to descriptive text or notes stored in the FC_TEXT_HDR table, allowing for contextual information about the specific schedule-forecast relationship to be maintained.

Common Use Cases and Queries

A primary use case is reporting and analysis to answer which forecasts are driving a particular production schedule, or conversely, which schedules have been created to fulfill a given forecast. This is essential for traceability and audit purposes within the planning cycle. Common queries involve joining PS_SCHD_FOR to its related header tables to retrieve descriptive information. For example, to list all forecasts associated with a specific schedule, a developer might use a query pattern such as:

  • SELECT sh.schedule_name, fh.forecast_name FROM gmp.PS_SCHD_FOR sf, gmp.PS_SCHD_HDR sh, gmp.FC_FCST_HDR fh WHERE sf.schedule_id = sh.schedule_id AND sf.forecast_id = fh.forecast_id AND sh.schedule_id = :p_schedule_id;

This table is also central to any custom logic or integration that needs to programmatically create or dissociate links between schedules and forecasts, often via the relevant GMP APIs.

Related Objects

PS_SCHD_FOR maintains documented foreign key relationships with three primary tables, as per the provided ETRM metadata:

  • PS_SCHD_HDR: The master table for production schedules. PS_SCHD_FOR.SCHEDULE_ID references PS_SCHD_HDR.SCHEDULE_ID.
  • FC_FCST_HDR: The master table for forecast headers. PS_SCHD_FOR.FORECAST_ID references FC_FCST_HDR.FORECAST_ID.
  • FC_TEXT_HDR: The table for storing descriptive text. PS_SCHD_FOR.TEXT_CODE references FC_TEXT_HDR.TEXT_CODE (and likely related TEXT_ID).

These relationships enforce data integrity and are essential for any join operation when building reports or interfaces that require schedule or forecast details beyond the simple association keys.