Search Results wip_wol_processor




Overview
Explore in AI Chat

Overview

WIP_WOL_PROCESSOR is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite. Its name and structure associate it with Work in Process (WIP) work order-less (WOL) completion processing, the mechanism by which discrete manufacturing environments complete assemblies without requiring a formally released discrete job. The package declaration uses AUTHID CURRENT_USER, meaning its SQL statements execute with the privileges of the calling session rather than the definer, which is characteristic of packages intended to be invoked from within the APPS runtime where the invoking user already holds the required grants. The ETRM metadata classifies the object as an "OTHER" API, and the single documented procedure indicates a narrowly scoped utility rather than a broad public API surface. In EBS 12.1.1 and 12.2.2 the object remains present in the APPS schema; the source header revision predates the 12.2 online patching architecture, so the package is a long-standing component that has been carried forward rather than newly introduced.

Key Procedures and Functions

Exactly one procedure is documented in the ETRM metadata.

  • completeAssyItem — The sole documented entry point. Its name denotes completion of an assembly item, that is, the transaction that moves a manufactured assembly into inventory and relieves its components. The procedure accepts a header identifier as input and returns an error message and a return status to the caller, following the standard EBS API return convention of an x_return_status indicating success, expected error, or unexpected error. No parameter list beyond this convention should be assumed; the signature is documented in the package specification and callers should reference the specification directly. Because the procedure is a processor rather than a validation-only API, it performs the completion business logic rather than merely checking eligibility.

Tables Accessed

The ETRM metadata records three tables referenced through APPS synonyms:

  • WIP_LPN_COMPLETIONS — The primary transactional table. It holds license plate number (LPN) completion records associated with WIP completion activity, and is the natural target for a procedure that completes an assembly item.
  • MTL_SYSTEM_ITEMS — The item master. The procedure reads this table to resolve the assembly being completed and to apply item-level controls such as inventory item status and attributes that govern completion.
  • MTL_ITEM_REVISIONS — The revision control table. Completion of a revision-controlled assembly requires a valid revision, so this table is consulted to validate or default the revision for the completed item.

Usage Notes

WIP_WOL_PROCESSOR is referenced by one other package in the ETRM metadata, which indicates that its principal consumers are other server-side PL/SQL modules rather than end-user forms invoked directly. In practice, such a processor is called from work order-less completion flows, from mobile or shop-floor completion logic, and from custom extensions or concurrent programs that need to complete an assembly programmatically. Callers must supply a valid header identifier and must handle the returned status and error message, since the procedure reports failures through its OUT parameters rather than by raising exceptions. Because the package executes with AUTHID CURRENT_USER, any custom code invoking it must run under a session that has execute privilege on the package and the necessary DML privileges on the underlying WIP and inventory tables. As with all EBS processing APIs, it should be invoked within a controlled transaction boundary, and the caller is responsible for commit or rollback.