Search Results sro_plan

Overview

The APPS.GMP_HORIZONTAL_PDR_PKG package body is a Process Manufacturing (OPM) planning utility that supports the Horizontal Plan view of the Planner Workbench and the Planner's Desktop Report (PDR) framework. Its principal business function is to consolidate supply, demand, on-hand, safety stock, and available-to-promise (ATP) information for a selected plan into a horizontal time-phased format, so that planners can review material availability across buckets rather than through individual transaction records.

The package header comment references $Header: GMPHPDRB.pls 120.21 2012/03/29, identifying it as a shipping OPM object maintained through the 12.1.1 and 12.2.2 release streams. The body defines a large set of named constants that map internal plan and horizontal plan type identifiers — for example SRO_PLAN, PURCHASE_ORDER, WORK_ORDER, PLANNED_ORDER, SALES, FORECAST, WIP, PO, REQ, PLANNED, SUPPLY, ON_HAND, PAB, SS, and ATP — which classify the rows that populate the horizontal plan.

The body also declares a package-level variable l_debug, initialized from the profile option GMP_DEBUG_ENABLED (reference Bug 9366921). Activation of this profile governs whether diagnostic output is emitted by the package's debug routine, which is the object the user searched for under the term gmp_debug_message.

Key Procedures and Functions

• POPULATE_HORIZONTAL_PLAN — The primary worker routine. It assembles the horizontal plan result set by combining plan-level supply and demand data from the MSC planning tables with OPM-specific quantities. It is the entry point invoked when the Horizontal Plan is refreshed or displayed for a given plan and item range.
• GMP_DEBUG_MESSAGE — The diagnostic logging procedure. It writes debug messages conditioned on the GMP_DEBUG_ENABLED profile option (l_debug). When debugging is disabled, calls are effectively suppressed; when enabled, the routine records processing milestones and values useful for troubleshooting plan population. The user's search term corresponds to this routine.

Tables Accessed

• MSC_SUPPLIES and MSC_DEMANDS — The core supply and demand facts from Advanced Supply Chain Planning, read to derive PO, requisition, WIP, planned order, sales, forecast, and dependent demand columns.
• MSC_INVENTORY_LEVELS and MSC_AVAILABLE_TO_PROMISE — Utilized for on-hand, ATP, and projected available balance figures.
• MSC_SAFETY_STOCKS — Populates safety stock and unconstrained safety stock columns.
• MSC_PLANS, MSC_ANALYSIS_AGGREGATE, MSC_CALENDAR_DATES, and MSC_PERIOD_START_DATES — Provide plan definition, bucket boundaries, and period start dates for horizontal time-phasing.
• MSC_TRADING_PARTNERS — Supplies customer or supplier identification for demand and supply rows.
• GMP_HORIZONTAL_PDR_GTMP and GMP_PDR_ITEMS_GTMP — OPM global temporary tables used to stage item lists and the assembled horizontal plan results.
• DUAL and PLITBLM — Used for single-row selection and standard OPM item master lookups respectively.

Usage Notes

GMP_HORIZONTAL_PDR_PKG is an internal OPM planning package rather than a public API. It is normally invoked indirectly through the Horizontal Plan/Planner's Desktop Report flow, typically from an OPM planning form or a concurrent program that calls POPULATE_HORIZONTAL_PLAN to build the temporary result set before display or printing. Because it is referenced by one other package, customizations should avoid direct calls and instead drive the standard Horizontal Plan interface.

Debug output is controlled entirely by the GMP_DEBUG_ENABLED profile option set at the user, responsibility, or site level. Setting it to Y enables GMP_DEBUG_MESSAGE output, which is the supported technique for tracing plan population issues. Custom code should not depend on the many integer constants defined in the body, as their values are internal and subject to change across patches.