Search Results wip_bflproc_priv




Overview
Explore in AI Chat

Overview

APPS.WIP_BFLPROC_PRIV is an internal, private PL/SQL package within the Oracle E-Business Suite Work in Process (WIP) application. Its name reflects its role: "BFL" denotes backflush processing, the mechanism by which Oracle Manufacturing automatically issues component material against an assembly based on the bill of materials rather than through explicit manual issues, and "PROC" denotes the procedural routines that implement that logic. The package is classified as VALID under the APPS schema and is identified in ETRM as an OTHER-type API, indicating that it is an internal implementation package rather than a formally published open interface. In practical terms, WIP_BFLPROC_PRIV encapsulates the requirement explosion and backflush processing rules that drive component consumption during discrete and flow manufacturing transactions. It operates on the boundary between the BOM explosion engine and the material transaction interface, allowing WIP to determine quantities required, resolve supply from inventory, and stage the resulting material issues for validation and cost processing.

Key Procedures and Functions

The documented metadata lists four procedures and functions. PROCESSREQUIREMENTS is the principal routine controlling evaluation of component requirements for a given assembly, determining what quantities must be satisfied. EXPLODEREQUIREMENTS performs the bill-of-materials explosion required to derive those component requirements, working from the BOM structures and temporary explosion tables. BACKFLUSH carries out the actual backflush operation, translating resolved requirements into material transaction records for the affected components. The package also exposes a fourth documented element referenced collectively in the procedure list. Because these routines are private, parameter signatures are not published in the ETRM documentation and should not be assumed; they are invoked exclusively by other WIP packages rather than by external callers.

Tables Accessed

WIP_BFLPROC_PRIV references a substantial set of APPS synonyms. BOM_STRUCTURES_B supplies the bill-of-material structure, while BOM_EXPLOSION_TEMP and BOM_EXPLOSION_TEMP_S hold the working results of the explosion, and BOM_PARAMETERS provides the BOM profile and parameter context. BOM_DEPARTMENTS supports department-level defaults for the explosion. MTL_SYSTEM_ITEMS, MTL_SYSTEM_ITEMS_B, and MTL_SYSTEM_ITEMS_KFV provide item master attributes, including the key flexfield view used to present item segments. MTL_PARAMETERS supplies organization-level inventory controls. MTL_ITEM_LOCATIONS and MTL_UNITS_OF_MEASURE provide location and unit-of-measure validation. MTL_MATERIAL_TRANSACTIONS_S and MTL_MATERIAL_TRANSACTIONS_TEMP receive the staged transaction lines produced by the backflush, MTL_TRANSACTION_LOTS_TEMP holds lot and serial detail for the affected components, and MTL_TRANSACTIONS_INTERFACE is used to queue transactions for the transaction manager. The package also references the PL/SQL types WIP_COMPONENT_TBL_T and WIP_LOT_SERIAL_OBJ_T.

Usage Notes

WIP_BFLPROC_PRIV is an internal dependency rather than a supported public API. It is referenced by seven other packages, including WIP_MOVPROC_PRIV, WIP_MOVPROC_GRP, WIP_FLOWUTIL_PRIV, WIP_MTI_PUB, JMF_SUBCONTRACT_ORDERS_PVT, WMA_COMPLETION, and WMA_MOVE, and it calls back into itself. These callers cover move transactions, completion transactions, flow manufacturing utilities, and subcontracting, all of which may trigger backflush. Consequently, the package is invoked indirectly whenever an operator performs a move or completion in the WIP Material Transactions form or when flow manufacturing completion or move transactions are processed. Custom code should not call this package directly. Customers requiring backflush functionality should use the documented public interfaces such as WIP_MTI_PUB or the transaction manager, since the private routines and their signatures may change between releases.