Search Results update_mol_for_wip

Overview

APPS.INV_WIP_PICKING_PVT is a private PL/SQL package within the Oracle E-Business Suite Inventory (INV) module that supports the interface between Inventory picking operations and Work in Process (WIP) manufacturing execution. The package operates with AUTHID CURRENT_USER, meaning its SQL statements execute under the privileges of the calling schema rather than the package owner. Its scope is tightly coupled to component picking and material release activity for discrete jobs, repetitive schedules, and flow schedules, translating WIP material requirements into inventory picking actions and returning confirmation data or error records back to WIP.

The specification declares a package-level constant (g_pkg_name), global tracking variables for WIP patch level (g_wip_patch_level), pick release caller identification (g_pick_release_caller), and legacy detailed quantity handling (g_old_detailed_qty). These globals indicate the package maintains state across procedure calls within a session, a common pattern in EBS private APIs to cache caller context and patch-level behavior switches. The package also defines a record type, Trolin_ErrRec_Type, used to pass errored record information back to WIP together with descriptive error messages.

Key Procedures and Functions

• RELEASE_PICK_BATCH — Coordinates the release of a batch of picking activity, typically associated with processing multiple material requirements or transaction lines in a single invocation. It drives the overall pick-release flow for WIP-driven demand.
• PICK_RELEASE — Performs the core pick release action against WIP material requirements, generating and processing picking transactions. It is the primary operational entry point for releasing demand to the picking process.
• UPDATE_MOL_FOR_WIP — Updates the Move Order Line (MOL) records associated with WIP requirements. This procedure synchronizes MTL_TXN_REQUEST_LINES data with WIP demand, ensuring move orders reflect current requirement operation details. The user search term "update_mol_for_wip" corresponds directly to this procedure.
• GET_WIP_ATTRIBUTES — Retrieves WIP-related attributes, likely supplying complementary data needed during pick release or MOL updates, such as job or schedule characteristics.
• Five documented procedures/functions in total are recorded in the ETRM metadata; the remaining entry points follow the same private-API pattern and are invoked internally or by tightly coupled callers.

Tables Accessed

The package reads and writes a defined set of EBS base tables through APPS synonyms. Manufacturing definition tables include WIP_ENTITIES, WIP_OPERATIONS, WIP_REQUIREMENT_OPERATIONS, WIP_REPETITIVE_SCHEDULES, WIP_FLOW_SCHEDULES, BOM_DEPARTMENTS, BOM_OPERATIONAL_ROUTINGS, and BOM_OPERATION_SEQUENCES, supplying job, schedule, routing, and department context. Inventory transaction tables include MTL_MATERIAL_TRANSACTIONS_TEMP (staging pick and move transactions), MTL_SYSTEM_ITEMS (item attributes), MTL_PARAMETERS (organization-level defaults), and MTL_TXN_REQUEST_HEADERS/LINES (move orders). WSH_PICK_SLIP_NUMBERS_S provides pick slip sequencing, and DUAL supports simple value retrieval. This table set confirms the package bridges manufacturing demand with inventory move-order and material transaction processing.

Usage Notes

INV_WIP_PICKING_PVT is a PVT (private) API and is not intended for direct external invocation. It is referenced by four other packages and is normally called from within WIP and INV pick-release processing logic, including concurrent programs and form-driven flows such as WIP material transaction and move order forms. Custom code should not call this package directly; instead, the supported public APIs that encapsulate it should be used. Understanding UPDATE_MOL_FOR_WIP is relevant when diagnosing discrepancies between WIP requirements and move order lines in Oracle EBS 12.1.1 and 12.2.2.