Search Results wma_common




Overview
Explore in AI Chat

Overview

WMA_CFM is an Oracle E-Business Suite PL/SQL package owned by the APPS schema, classified under the ETRM metadata as an "OTHER" API type. Its name and documented dependency set indicate that it serves as a supporting engine for the Warehouse Management (WMS) and Work in Process (WIP) flow of material through flow manufacturing and license plate number (LPN) driven completions. In EBS 12.1.1 and 12.2.2, WMA_CFM is one of several WMA_* packages that operate beneath the Warehouse Management application layer, working alongside WMA_COMMON to provide shared processing logic for material movement transactions. The package is marked VALID and remains an active internal component of the APPS schema. It is documented primarily as an internal helper rather than a public, customer-facing API, and its role is to process, derive, and persist completion and transaction data used by higher-level WIP and Warehouse Management processors.

Key Procedures and Functions

  • PROCESS — The principal driver procedure. It carries out the core processing logic of the package, likely evaluating incoming completion or transaction records and applying the appropriate warehouse management handling.
  • DERIVE — A derivation routine. It calculates or derives values required by the processing flow, such as attribute defaults or context-dependent fields, before the records are written or consumed downstream.
  • PUT — A persistence routine. It writes or places records into the target interface or transaction tables, completing the create/update cycle initiated by PROCESS and DERIVE.

The ETRM documentation records six documented procedures or functions in total for WMA_CFM, of which PROCESS, DERIVE, and PUT are named. The remaining entries are not itemized in the available metadata. No parameter signatures are published here; the procedures should be treated as internal and invoked only through their documented callers.

Tables Accessed

WMA_CFM references the following tables through APPS synonyms, according to the documented dependency list:

  • MTL_TRANSACTIONS_INTERFACE — The standard Inventory open interface table for material transactions. WMA_CFM reads and/or writes staged transaction rows here as part of the processing/put cycle.
  • WIP_LPN_COMPLETIONS — The WIP table holding license plate number completion records. This confirms the package's role in LPN-driven work order completion processing.
  • WIP_FLOW_SCHEDULES — The flow manufacturing schedule table. WMA_CFM consults flow schedule data to derive and validate completion context.

In addition, the package depends on the shared package WMA_COMMON, which supplies common warehouse management routines, and on the SYS.STANDARD package for base PL/SQL types. This reuse of WMA_COMMON is directly relevant to searches for "wma_common" and explains why WMA_CFM appears in that dependency neighbourhood.

Usage Notes

WMA_CFM is referenced by only one other package in the ETRM metadata: WIP_ONLINE_MTL_TXN_PROCESSOR, the online material transaction processor that handles interactive WIP and inventory transactions. It also references itself internally, indicating recursive or nested calls within the package body. This dependency pattern shows that WMA_CFM is not intended for direct invocation by forms, concurrent programs, or custom code; it is an internal implementation layer called by the online transaction processor when LPN-based flow schedule completions and material interface records are processed. Customers and integrators should not call WMA_CFM directly. Instead, customizations should use the documented public APIs of WIP and Inventory and rely on WIP_ONLINE_MTL_TXN_PROCESSOR, WMA_COMMON, or the standard transaction interfaces to trigger this logic.