Search Results mrp_print_pk




Overview
Explore in AI Chat

Overview

MRP_PRINT_PK is an Oracle EBS PL/SQL package owned by the APPS schema that provides shared utility services for the Oracle Material Requirements Planning (MRP) and related planning modules. Its primary business function is to support the output, formatting, and message-handling activities associated with planning runs — most notably the printing of planning output and the management of planner messages generated during and after an MRP, MPS, or DRP planning cycle. The package is classified as an OTHER API, indicating it is an internal helper package rather than a public, supported API surface intended for external integration. In ETRM 12.2.2 it is documented as a VALID object with seven documented procedures and functions, and it is referenced by four other planning packages, which confirms its role as a low-level building block in the planning infrastructure rather than an entry point invoked directly by end users.

Key Procedures and Functions

The package exposes the following documented entry points:

  • MRPRINT — the principal routine, responsible for producing the printed planning output. It drives the formatting and emission of planning results, typically in conjunction with a concurrent program that submits the planning report.
  • START_WATCH — begins a timing or diagnostic measurement interval, used to instrument planning and printing operations for performance monitoring and troubleshooting.
  • STOP_WATCH — closes the interval opened by START_WATCH, capturing elapsed time for the same performance and diagnostic purposes.
  • CLEAR_MESSAGES — removes or resets entries in the temporary planner message tables, ensuring that message data is not carried over between planning runs or printing invocations.

These routines are intentionally narrow in scope; they supplement the larger planning packages rather than duplicating their logic. The metadata documents their existence and purpose only, and no parameter signatures should be assumed without inspecting the package specification.

Tables Accessed

The package reads and writes three documented objects through APPS synonyms:

  • MRP_MESSAGES_TMP — the temporary table holding planner messages generated during a planning run. MRP_PRINT_PK writes to and clears this table as part of message output and cleanup.
  • MRP_MESSAGES_TMP_S — the companion sequence used to generate unique identifiers for rows inserted into the temporary message table.
  • DUAL — the standard Oracle single-row utility table, used for trivial queries and expression evaluation.

No permanent planning tables are directly manipulated by these documented routines, consistent with the package's role as a printing and message-management helper.

Usage Notes

MRP_PRINT_PK is typically invoked indirectly. Its dependents include CRP_PLANNER_PK, MRP_AUTO_REDUCE_PK, MRP_MANAGER_PK, and MRP_UPDATE_MRP_INFO_PK, all of which call into the package to obtain printing, timing, or message-clearing behavior during planning workflows. The most common practical entry point is the concurrent program that prints MRP output, which internally invokes MRPRINT. Because the package is classified as OTHER, custom code should avoid depending on it directly; organizations requiring planning output customization should extend the standard concurrent program or use supported APIs rather than calling these procedures. When troubleshooting planning reports, the START_WATCH and STOP_WATCH routines can be used within the same session to isolate performance bottlenecks, while CLEAR_MESSAGES remains useful when message tables must be reset between test runs.