Search Results mrp_release_so




Overview
Explore in AI Chat

Overview

APPS.MRP_RELEASE_SO is an Oracle E-Business Suite PL/SQL package that supports the release of planned supply and demand recommendations generated by Oracle Material Requirements Planning (MRP) and related planning engines into Oracle Order Management. In the planning lifecycle, MRP and its successors (MSC, the Advanced Supply Chain Planning module) produce recommendations that must be converted into executable transactional documents. This package provides the entry point for releasing sales order-based planned orders. It is declared AUTHID CURRENT_USER, meaning it executes with the privileges of the invoking schema and relies on APPS synonyms for access to underlying base tables. The package is classified under the ETRM registry as API classification OTHER, indicating it is a supporting internal utility rather than a formally published public API, and it exposes a single documented procedure. It is referenced by zero other packages, so it functions as a top-level callable unit invoked directly by concurrent program definitions or custom wrappers.

Key Procedures and Functions

The package exposes one documented procedure: RELEASE_SO_PROGRAM. Based on its naming, signature conventions, and the presence of standard concurrent program output parameters (errbuf and retcode), this is a concurrent-program driver procedure. It is designed to be registered as the executable logic of a concurrent program that performs the batch release of sales order planned orders. Its documented parameters include the standard error buffer and return code outputs, a batch identifier, a database link name, and an instance identifier. The database link parameter supports distributed processing in multi-instance planning environments, where the release may occur against a remote planning instance. The batch identifier scopes the set of recommendations to be processed in a single run, and the instance identifier distinguishes the originating application instance for concurrency control and data partitioning.

Tables Accessed

ETRM records five tables accessed through APPS synonyms:

  • MSC_FORM_QUERY — planning schema table that stores saved form query and selection criteria, used to determine which planned order records qualify for release.
  • MTL_SYSTEM_ITEMS — the item master, consulted to validate item attributes and planning-enabled status for the records being released.
  • OE_ORDER_HEADERS_ALL — the Order Management sales order header table, into which released planned orders are inserted or updated as sales order headers.
  • OE_ORDER_LINES_ALL — the corresponding sales order lines table, populated with released planned order line detail.
  • PLITBLM — a standard EBS PL/SQL index-by table type used for in-memory collections, supporting bulk processing of the release set.

Usage Notes

This package is typically invoked directly by a concurrent program, with the standard concurrent manager passing errbuf and retcode. Parameters such as the batch identifier and instance identifier are ordinarily supplied through concurrent program parameters defined in the application. The procedure is not intended for ad hoc interactive execution from a form; instead, it is scheduled or launched from the planning workbench or a related release screen. Custom code should generally not call this internal utility directly, as it is not a published API and its behavior may change between patch levels. Organizations integrating with planning release should prefer the supported MSC and Order Management public APIs. This package is present in both Oracle EBS 12.1.1 and 12.2.2 codelines; the header comment referencing a 2008 build date indicates long-standing stability across releases.