Search Results wip_online_mtl_txn_processor




Overview
Explore in AI Chat

Overview

WIP_ONLINE_MTL_TXN_PROCESSOR is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite. In the ETRM metadata it is classified as an "OTHER" API, distinguishing it from formally published open interfaces. Its role is to process Work in Process (WIP) material transactions submitted online — that is, transactions driven from the Oracle Forms interface rather than from a batch or interface program. The package performs the low-level work of writing rows into the material transaction interface tables, resolving component and lot/serial data, and completing assemblies and their associated components in response to an operator action on a WIP form.

The package is documented as VALID in both 12.1.1 and 12.2.2. The dependency list shows it references only the SYS schema's STANDARD package (the implicit PL/SQL runtime package) and is referenced by no other package, confirming that it is a leaf-level utility invoked directly by the calling UI layer rather than being part of a wider package hierarchy.

Key Procedures and Functions

The ETRM record documents eight callable units. Their names indicate the following responsibilities:

  • BACKFLUSHCOMPONENTS — Performs backflush processing of the components associated with a WIP job or assembly, generating the material issues that a completed assembly consumes based on the bill of material and supply type.
  • COMPLETEWOL — Completes a work order line, carrying out the completion transaction for the specified job or schedule line.
  • COMPLETEASSYANDCOMPONENTS — Completes the assembly while simultaneously processing its component issues, providing a single entry point for combined assembly completion and backflush.
  • COMPLETEASSYITEM — Handles completion of the assembly item itself, without necessarily processing components.
  • TRANSACTMATERIALS — Processes material transactions in a plural sense; likely accepts and processes a set or collection of material transaction entries.
  • TRANSACTMATERIAL — The singular counterpart, processing an individual material transaction.
  • LPNCOMPLETEFLOW — Drives the completion flow for License Plate Number (LPN) controlled items, addressing the warehouse-management aspects of completing an assembly held on an LPN.
  • LPNCOMPLETEJOB — Completes a WIP job in the context of LPN-managed material, coordinating job completion with LPN records.

Parameter lists are not reproduced in the ETRM excerpt and must be obtained from the deployed package specification. The names should not be assumed to define a public interface contract.

Tables Accessed

The documented table references are made through APPS synonyms and reveal how the package stages and records transactions:

Usage Notes

This package is an internal implementation component, not a supported public API. It is normally invoked by Oracle's WIP Material Transactions and Work in Process completion forms, and by related UI flows for LPN-managed completions. Custom code should generally call the supported documented interfaces — such as the WIP and Inventory open interfaces or the corresponding public APIs — rather than calling WIP_ONLINE_MTL_TXN_PROCESSOR directly, because its procedures are designed around the internal temp-table staging model and may change between releases. Where direct invocation is unavoidable, the package specification in the target environment should be inspected to obtain exact signatures, and the behavior should be verified in a non-production instance before deployment.