Search Results wip_define_inv_parameters

Overview

The APPS.WIP_WEIGHTED_AVG package body supports Work in Process (WIP) costing in Oracle E-Business Suite. Its core responsibility is to determine whether a given inventory organization is configured for a weighted-average, FIFO, or LIFO cost method and, when it is, to drive the automatic computation of final completion costs for discrete jobs. Organizations configured with standard costing are excluded from this processing, since weighted-average valuation logic does not apply to them. The package therefore acts as a decision and processing gate for WIP cost finalization, reading inventory and WIP setup parameters to decide whether resource and material cost adjustments should be rolled into the completed job value.

Key Procedures and Functions

The ETRM documentation for 12.2.2 lists two documented procedures, though the package body header shows an earlier internal driver named get_parms that illustrates the design intent.

• get_parms — An internal helper that reads the organization's primary cost method from MTL_PARAMETERS and the final-completion flag from WIP_PARAMETERS. It returns the cost method, the auto-compute-final-completion flag, and standard return code/message values. If inventory parameters are missing it raises WIP_DEFINE_INV_PARAMETERS; if the cost method is not average, FIFO, or LIFO it short-circuits and returns without further processing. If WIP parameters are missing it raises WIP_DEFINE_WIP_PARAMETERS.
• FINAL_COMPLETE — The documented entry point that performs final completion costing for a discrete job, applying weighted-average valuation logic and adjusting job costs accordingly. It is the procedure exposed for external invocation and the one referenced by the calling package identified in the metadata.

Note that parameter signatures are intentionally omitted here, as the documented metadata does not specify them for the public procedure.

Tables Accessed

The package reads and writes the following tables through APPS synonyms:

• MTL_PARAMETERS — Provides the organization's primary_cost_method, used to determine whether weighted-average, FIFO, or LIFO costing applies.
• WIP_PARAMETERS — Supplies the auto_compute_final_completion flag controlling whether final completion costs should be automatically computed.
• WIP_DISCRETE_JOBS — The discrete job being finalized; cost and status information is read and updated.
• WIP_OPERATIONS — Operation-level detail used when rolling up resource costs into the completed quantity.
• MTL_MATERIAL_TRANSACTIONS and MTL_MATERIAL_TRANSACTIONS_TEMP — Transaction cost records consulted for material valuation during final completion.

Usage Notes

This package is invoked as part of the WIP cost finalization flow rather than being called directly by end users. Typical invocation paths include the Discrete Jobs form when a user performs a final completion, and concurrent programs that process job cost adjustments in the background. The metadata indicates the package is referenced by one other package, suggesting it is a subordinate component in a larger costing module.

Because weighted-average and FIFO/LIFO valuation logic is central to this package, organizations running standard costing will see it exit early without cost adjustments — this is expected behavior, not an error. Custom code that calls the public FINAL_COMPLETE procedure should handle the documented return codes and check for the parameter-missing conditions, since the package raises WIP_DEFINE_INV_PARAMETERS and WIP_DEFINE_WIP_PARAMETERS when required setup is incomplete. Users searching for "get_cost_method" are likely tracing the internal cursor of the same name, which confirms the package's role as the cost-method resolution point for WIP final completion.