Search Results inv_create_move_order_pvt




Overview
Explore in AI Chat

Overview

INV_CREATE_MOVE_ORDER_PVT is a private PL/SQL package in the APPS schema that provides the transactional engine for creating move orders within Oracle Inventory. A move order is an internal requisition that authorizes and tracks the movement of material between inventory organizations, subinventories, and locators without the need for a full purchase or sales cycle. The package belongs to the PVT (private) API classification, meaning it is intended to be called by other Oracle EBS application modules rather than directly by external or customer-written code. Its primary role is to encapsulate the validation and insertion logic required to generate move order headers and lines in the inventory transaction tables, ensuring that replenishment, min-max planning, and subinventory transfer processes can generate move orders consistently and in accordance with Inventory business rules.

Key Procedures and Functions

The ETRM metadata documents a single procedure within this package:

  • CREATE_MOVE_ORDERS — The core routine responsible for constructing one or more move orders. It accepts the source and destination context for the requested material movement, validates the input against Inventory setup, and performs the insert operations that create the move order header and its associated lines. Because the procedure is defined as a private API, its parameter list is not exposed in the documented metadata and should not be assumed or modified by external callers.

Tables Accessed

The documented metadata does not enumerate specific base tables in the excerpt, but based on the package's stated function, CREATE_MOVE_ORDERS operates against the core move order and transaction tables in Oracle Inventory. These include the move order header and line tables (such as MTL_MOVE_ORDER_HEADERS and MTL_MOVE_ORDER_LINES), which store the demand, sourcing, and destination details, and related inventory item and organization tables used to validate that the item, subinventory, and locator combinations are valid. The package reads existing inventory setup data to confirm that the requested move is permissible before writing the new move order records.

Usage Notes

INV_CREATE_MOVE_ORDERS_PVT is invoked internally by Oracle EBS processes rather than by end users directly. The documented dependency information shows it is referenced by CSP_MINMAX_PVT and by itself, indicating that the min-max replenishment and related supply chain planning routines rely on this package to generate move orders automatically when inventory falls below defined thresholds. It may also be called from other private Inventory APIs that need to create move orders as part of a larger transaction flow. Because the package is classified as PVT and is not a public API, customizations and third-party integrations should avoid calling it directly; instead they should use the supported public move order APIs or the standard Inventory forms and concurrent programs. Direct invocation risks bypassing validation logic that Oracle may change between releases such as 12.1.1 and 12.2.2.