Search Results populate_horizontal_plan

Overview

GMP_HORIZONTAL_PDR_PKG is an Oracle EBS Process Manufacturing (OPM) package owned by the APPS schema. It supports the horizontal material plan report, a planning output that presents supply, demand, inventory, and available-to-promise information across a configurable time horizon for a given plan and organization. Rather than a vertical, item-by-item listing, the horizontal plan lays out bucket columns (days, weeks, or periods) side by side, allowing planners to view the projected flow of material across time in a single row per item.

The package is classified as OTHER in the ETRM repository, meaning it is not a public, published API but an internal implementation unit invoked by OPM planning components. Its header, dated 2011, shows a stable interface with two documented procedures and references a subset of MSC (Advanced Supply Chain Planning) and GMP (Process Manufacturing) tables, indicating it bridges OPM planning data with the shared MSC planning engine tables.

Key Procedures and Functions

POPULATE_HORIZONTAL_PLAN — This is the principal procedure of the package. It accepts a set of inputs identifying the plan context, including an instance identifier, organization identifier, plan identifier, cutoff dates for day and week buckets, a period bucket indicator, and a flag controlling whether items with no activity are included. The procedure drives the population of the horizontal planning result, deriving bucketed supply and demand figures for the specified plan and organization and writing them to the horizontal planning temporary tables. The inclusion flag traces to a prior enhancement (Bug 8486531) that allows planners to suppress items showing no movement.

GMP_DEBUG_MESSAGE — A diagnostic utility procedure that writes a message to a debug buffer. It was introduced under Bug 9366921 to provide controlled tracing during execution of the package. This is the procedure most frequently located by searches for "gmp_debug_message," since it appears across multiple OPM packages as a shared debugging convention. It takes no business parameters of note and is used purely for instrumentation and troubleshooting.

Tables Accessed

The package reads from and writes to a defined set of tables through APPS synonyms. The GMP_HORIZONTAL_PDR_GTMP and GMP_PDR_ITEMS_GTMP global temporary tables hold the working and item-level output for the horizontal plan. Planning inputs are drawn from MSC_PLANS, MSC_INVENTORY_LEVELS, MSC_SUPPLIES, MSC_DEMANDS, MSC_SAFETY_STOCKS, MSC_AVAILABLE_TO_PROMISE, and MSC_ANALYSIS_AGGREGATE, which supply the plan definition, on-hand balances, receipts, issues, safety stock targets, ATP quantities, and pre-aggregated planning data. MSC_CALENDAR_DATES and MSC_PERIOD_START_DATES provide the calendar and period boundaries used to form day, week, and period buckets. MSC_TRADING_PARTNERS supports sourcing or customer-related attributes. DUAL is used for trivial single-row expressions, and PLITBLM is the standard EBS PL/SQL index-by table used for bulk processing within the package.

Usage Notes

GMP_HORIZONTAL_PDR_PKG is normally invoked indirectly. In Oracle Process Manufacturing, the horizontal material plan is generated through planning concurrent programs and report components rather than by direct user execution. The package is referenced by one other package in the ETRM metadata, confirming it serves as a supporting routine in a larger planning flow.

Because the package is declared AUTHID CURRENT_USER, it executes with the privileges of the calling schema, which is a relevant consideration when invoking it from custom code. The GMP_DEBUG_MESSAGE procedure is the practical entry point for troubleshooting: setting the appropriate debug level allows diagnostic output to be captured during plan population. Customizations should call GMP_HORIZONTAL_PDR_PKG only where the calling environment already supplies valid plan, organization, and instance identifiers; the populated global temporary tables are session-scoped and must be consumed within the same session.