Search Results orig_schedule

Overview

MRP_PLANNER_PK is an APPS-owned PL/SQL package body within Oracle E-Business Suite, validated as VALID in both the 12.1.1 and 12.2.2 releases. It supports the Oracle Material Requirements Planning (MRP) and Master Production Scheduling (MPS) planning engine, providing the server-side logic that underpins the Planner Workbench and related planning activities. The package is classified under the API classification OTHER and is not a public, formally supported API; it is internal infrastructure used by Oracle's planning forms and concurrent programs.

The name and its dependency on MRP_SCHEDULE_DATES, MRP_SCHEDULE_DATES_S, and MRP_RECOMMENDATIONS confirm its role in managing planner-owned schedule dates and generating the planning entries that flow into the Planner Workbench. The user search term "mrp_schedule_dates_s" corresponds to the synonym for the schedule dates table that this package supplies data to through the planning engine.

Key Procedures and Functions

The ETRM documentation lists five documented procedures/functions within MRP_PLANNER_PK (four named in the excerpt):

• MB_DELETE_MS_OUTSIDE_TF — Deletes master schedule (MPS) entries that fall outside the planning time fence, ensuring the planning engine respects the defined time fence boundaries.
• CREATE_NEW_PLANNER_MPS_ENTRIES — Creates new MPS entries owned by the planner, typically in response to planning runs or manual planning actions.
• CREATE_ORIG_MPS_ENTRIES — Creates original MPS entries, establishing baseline schedule records against which revisions and replanning are compared.
• CREATE_MBP_ORIG_MPS_ENTRIES — Creates original MPS entries for the MBP (Master Production Schedule / Master Business Planning) context, supporting master-level planning data.

Tables Accessed

The documented table dependencies, resolved through APPS synonyms, are:

• MRP_SCHEDULE_DATES and MRP_SCHEDULE_DATES_S — The schedule dates table and its synonym, holding the planner-owned schedule dates that the package reads and maintains.
• MRP_RECOMMENDATIONS — Planning recommendations generated for the Planner Workbench, including suggested orders and schedule changes.
• MRP_SYSTEM_ITEMS and MTL_SYSTEM_ITEMS — Item master data used to qualify planning items and their attributes.
• MRP_PLAN_ORGANIZATIONS_V — The planning organizations view, used for organization-scoped processing.
• BOM_CALENDAR_DATES — Calendar dates from the BOM calendar, used in schedule date calculation.
• MTL_PARAMETERS — Organization parameters controlling planning behavior.
• MRP_FORM_QUERY — The form query helper used by the Planner Workbench forms.
• FND_PROFILE — Profile option lookups controlling processing behavior.

Usage Notes

MRP_PLANNER_PK is typically invoked from Oracle's MRP/MPS Planner Workbench forms and from the planning concurrent programs during a plan run, not from custom code. Because the ETRM metadata reports zero other database objects referencing this package, it is a top-level internal unit rather than a reusable extension point. Customizations should avoid direct calls to these procedures; supported integration should use documented planner APIs. When troubleshooting schedule date inconsistencies in the Planner Workbench (the common context for the "mrp_schedule_dates_s" search), this package and the MRP_SCHEDULE_DATES tables are the primary objects to inspect. In 12.2.2 the package remains VALID with the same object dependencies as 12.1.1.