Search Results rollup_cost_update




Overview
Explore in AI Chat

Overview

GMD_SPREAD_CALCULATE_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports the Process Manufacturing (OPM) product development and formulation functionality. Its principal business role is to calculate, roll up, and propagate the spread of material quantities, weights, volumes, and cost percentages across a multi-level product or material structure. The package drives the arithmetic that distributes a parent item's total quantity or cost across its components and by-products, applying the technical parameters and expressions defined for each line. It further evaluates those expressions, recalculates equivalent weights and volumetric percentages, and updates roll-up results that are persisted against the formulation. In Oracle EBS 12.1.1 and 12.2.2 the package is classified as a non-public "OTHER" API rather than a formal open interface, meaning it is intended primarily for internal OPM processing and controlled extension rather than direct customer integration. The package exposes ten documented procedures and functions, including two diagnostic helpers, TEMP_DUMP and TEMP_PARAM, which are relevant to the user's search term.

Key Procedures and Functions

  • CALCULATE — The primary entry point that performs the overall spread calculation for a given entity and organization.
  • ROLLUP_WT_PCT — Rolls up weight percentages for a specified entity, line, parameter, and sort sequence.
  • EVALUATE_EXPRESSION — Evaluates a technical parameter expression and returns the resulting expression string for use in downstream roll-ups.
  • ROLLUP_COST_UPDATE — Updates cost-related roll-up values, incorporating primary quantity information.
  • ROLLUP_UPDATE — Performs the general roll-up update that writes recalculated values back to the underlying records.
  • ROLLUP_COST_UNITS — A function that returns the rolled-up cost units for a given entity, line, and parameter.
  • ROLLUP_EQUIV_WT — Rolls up equivalent weight values, taking a unit code and organization into account.
  • TEMP_DUMP — A diagnostic procedure that accepts an entity identifier and dumps temporary calculation data, used for troubleshooting the spread process.
  • TEMP_PARAM — A diagnostic procedure that dumps temporary parameter data for an entity and optional line.
  • AUTO_CALC_PRODUCT — Automatically calculates product-level spread values for an entity, returning status and message information through its output parameters.

Tables Accessed

The package operates against several OPM formulation and technical data structures accessed through APPS synonyms. FM_FORM_MST and FM_MATL_DTL hold the formulation header and material detail lines that define the product structure being spread. GMD_MATERIAL_HEADER_GTMP and GMD_MATERIAL_DETAILS_GTMP are global temporary tables that stage the header- and detail-level material data during calculation. GMD_TECHNICAL_DATA_GTMP and GMD_TECHNICAL_PARAMETER_GTMP stage technical data and parameter definitions used when evaluating expressions and rolling up values. GMD_SPREAD_ERRORS_GTMP captures errors encountered during spread processing, supporting the return status reported by the procedures. MTL_UNITS_OF_MEASURE provides unit-of-measure conversion information needed for equivalent weight and volumetric roll-ups.

Usage Notes

GMD_SPREAD_CALCULATE_PKG is typically invoked from OPM formulation and product development forms, from concurrent programs that recalculate spread and roll-up values for large volumes of formulations, and from custom code that extends OPM costing or specification processing. Because the package is classified as OTHER and is referenced by no other documented packages, direct calls from customizations should be undertaken with caution and validated against the specific EBS release, since the roll-up and expression-evaluation logic depends on the populated global temporary tables. The TEMP_DUMP and TEMP_PARAM procedures are most useful during implementation and support activities, when a developer or functional consultant needs to inspect the intermediate spread data staged for a given entity in order to diagnose discrepancies in calculated percentages, costs, or equivalent weights.